提交 | 用户 | 时间
|
1ac2bc
|
1 |
DROP DATABASE IF EXISTS guns_test; |
懒 |
2 |
CREATE DATABASE IF NOT EXISTS guns_test DEFAULT CHARSET utf8 COLLATE utf8_general_ci; |
|
3 |
|
|
4 |
use guns_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; |