commit | author | age
|
9bcb19
|
1 |
DROP DATABASE IF EXISTS snowy_test; |
I |
2 |
CREATE DATABASE IF NOT EXISTS snowy_test DEFAULT CHARSET utf8 COLLATE utf8_general_ci; |
|
3 |
|
|
4 |
use snowy_test; |
|
5 |
|
|
6 |
SET NAMES utf8mb4; |
|
7 |
SET FOREIGN_KEY_CHECKS = 0; |
|
8 |
|
|
9 |
-- ---------------------------- |
|
10 |
-- Table structure for test |
|
11 |
-- ---------------------------- |
|
12 |
DROP TABLE IF EXISTS `test`; |
|
13 |
CREATE TABLE `test` ( |
|
14 |
`aaa` int(11) NOT NULL AUTO_INCREMENT, |
|
15 |
`bbb` varchar(255) DEFAULT NULL, |
|
16 |
PRIMARY KEY (`aaa`) USING BTREE |
|
17 |
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC; |
|
18 |
|
|
19 |
SET FOREIGN_KEY_CHECKS = 1; |