DROP DATABASE IF EXISTS guns_test;
|
CREATE DATABASE IF NOT EXISTS guns_test DEFAULT CHARSET utf8 COLLATE utf8_general_ci;
|
|
use guns_test;
|
|
SET NAMES utf8mb4;
|
SET FOREIGN_KEY_CHECKS = 0;
|
|
-- ----------------------------
|
-- Table structure for test
|
-- ----------------------------
|
DROP TABLE IF EXISTS `test`;
|
CREATE TABLE `test` (
|
`aaa` int(11) NOT NULL AUTO_INCREMENT,
|
`bbb` varchar(255) DEFAULT NULL,
|
PRIMARY KEY (`aaa`) USING BTREE
|
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
|
|
SET FOREIGN_KEY_CHECKS = 1;
|
