test.sql 543 B

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