{"id":27,"date":"2024-07-31T12:10:28","date_gmt":"2024-07-31T04:10:28","guid":{"rendered":"https:\/\/note.ui11.cc\/?p=27"},"modified":"2024-08-05T17:23:09","modified_gmt":"2024-08-05T09:23:09","slug":"%e8%8b%8d%e7%a9%b9%e5%a4%96%e5%8d%96%e5%bb%ba%e8%a1%a8%e8%af%ad%e5%8f%a5","status":"publish","type":"post","link":"https:\/\/note.ui11.cc\/index.php\/2024\/07\/31\/%e8%8b%8d%e7%a9%b9%e5%a4%96%e5%8d%96%e5%bb%ba%e8%a1%a8%e8%af%ad%e5%8f%a5\/","title":{"rendered":"\u82cd\u7a79\u5916\u5356\u5efa\u8868\u8bed\u53e5"},"content":{"rendered":"\n
CREATE DATABASE  IF NOT EXISTS `sky_take_out` ;\n\/\/\u521b\u5efa\u6570\u636e\u5e93\nUSE `sky_take_out`;\n\/\/\u4f7f\u7528\u8fd9\u4e2a\u6570\u636e\u5e93\n\nDROP TABLE IF EXISTS `address_book`;\/\/\u5efa\u8868\nCREATE TABLE `address_book` (\n  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '\u4e3b\u952e',\n     bigint\u662f\u6570\u636e\u7c7b\u578b<\/em>\n\/\/1.\nNOT NULL\uff1a\u786e\u4fdd\u5217\u4e2d\u7684\u503c\u4e0d\u80fd\u4e3aNULL\uff0c\u5373\u8be5\u5217\u5fc5\u987b\u6709\u503c\u3002\n2.\nUNIQUE\uff1a\u786e\u4fdd\u5217\u4e2d\u7684\u6240\u6709\u503c\u90fd\u662f\u552f\u4e00\u7684\uff0c\u5373\u4e0d\u5141\u8bb8\u91cd\u590d\u503c\u3002\n3.\nPRIMARY KEY\uff1a\u552f\u4e00\u6807\u8bc6\u8868\u4e2d\u7684\u6bcf\u4e00\u884c\u3002\u901a\u5e38\u4e0eAUTO_INCREMENT\u4e00\u8d77\u4f7f\u7528\uff0c\u4ee5\u786e\u4fdd\u6bcf\u884c\u90fd\u6709\u4e00\u4e2a\u552f\u4e00\u7684\u6807\u8bc6\u7b26\u3002\n4.\nFOREIGN KEY\uff1a\u7528\u4e8e\u5728\u4e24\u4e2a\u8868\u4e4b\u95f4\u5efa\u7acb\u94fe\u63a5\uff0c\u786e\u4fdd\u4e00\u4e2a\u8868\u4e2d\u7684\u503c\u5fc5\u987b\u662f\u53e6\u4e00\u4e2a\u8868\u4e2d\u5217\u7684\u503c\u3002\n5.\nCHECK\uff1a\u786e\u4fdd\u5217\u4e2d\u7684\u503c\u6ee1\u8db3\u7279\u5b9a\u6761\u4ef6\u3002\u4f8b\u5982\uff0c\u53ef\u4ee5\u786e\u4fdd\u5e74\u9f84\u5217\u7684\u503c\u572818\u523065\u4e4b\u95f4\u3002\n6.\nDEFAULT\uff1a\u4e3a\u5217\u63d0\u4f9b\u9ed8\u8ba4\u503c\u3002\u5982\u679c\u5728\u63d2\u5165\u8bb0\u5f55\u65f6\u6ca1\u6709\u4e3a\u8be5\u5217\u6307\u5b9a\u503c\uff0c\u5c06\u4f7f\u7528\u9ed8\u8ba4\u503c\u3002\n7.\nINDEX\uff1a\u7528\u4e8e\u521b\u5efa\u7d22\u5f15\uff0c\u63d0\u9ad8\u67e5\u8be2\u901f\u5ea6\u3002\u867d\u7136\u4e0d\u662f\u7ea6\u675f\uff0c\u4f46\u5b83\u662f\u6570\u636e\u5e93\u6027\u80fd\u4f18\u5316\u7684\u91cd\u8981\u90e8\u5206\u3002\n8.\nAUTO_INCREMENT\uff1a\u901a\u5e38\u4e0ePRIMARY KEY\u4e00\u8d77\u4f7f\u7528\uff0c\u7528\u4e8e\u81ea\u52a8\u751f\u6210\u552f\u4e00\u7684\u6570\u503c\u3002\u6bcf\u6b21\u63d2\u5165\u65b0\u884c\u65f6\uff0c\u8be5\u5217\u7684\u503c\u4f1a\u81ea\u52a8\u589e\u52a0\u3002\n\n9.utf8mb3_bin \u662f\u4e00\u4e2a\u4e8c\u8fdb\u5236\u6392\u5e8f\u89c4\u5219\uff0c\u5b83\u4e0d\u8003\u8651\u5b57\u7b26\u7684\u5927\u5c0f\u5199\u548c\u91cd\u97f3\u7b26\u53f7\uff0c\u9002\u7528\u4e8e\u9700\u8981\u7cbe\u786e\u5339\u914d\u7684\u573a\u666f\n\u5b57\u7b26\u96c6\uff08Character Set\uff09\uff1a\u5b57\u7b26\u96c6\u662f\u4e00\u5957\u7b26\u53f7\u548c\u7f16\u7801\u7684\u89c4\u5219\uff0c\u7528\u4e8e\u8868\u793a\u6587\u672c\u6570\u636e\u3002\u5e38\u89c1\u7684\u5b57\u7b26\u96c6\u5305\u62ecASCII\u3001UTF-8\u3001UTF-16\u7b49\u3002\u5b57\u7b26\u96c6\u51b3\u5b9a\u4e86\u6570\u636e\u5e93\u5982\u4f55\u5b58\u50a8\u6587\u672c\u6570\u636e\u3002\u6392\u5e8f\u89c4\u5219\uff08Collation\uff09\uff1a\u6392\u5e8f\u89c4\u5219\u5b9a\u4e49\u4e86\u5b57\u7b26\u7684\u6bd4\u8f83\u89c4\u5219\uff0c\u5305\u62ec\u5927\u5c0f\u5199\u654f\u611f\u6027\u3001\u91cd\u97f3\u7b26\u53f7\u7684\u5904\u7406\u3001\u5b57\u7b26\u6392\u5e8f\u987a\u5e8f\u7b49\u3002\u4e0d\u540c\u7684\u8bed\u8a00\u548c\u6587\u5316\u53ef\u80fd\u9700\u8981\u4e0d\u540c\u7684\u6392\u5e8f\u89c4\u5219\u3002\u4f8b\u5982\uff0cutf8_general_ci \u662f\u4e00\u4e2a\u4e0d\u533a\u5206\u5927\u5c0f\u5199\u7684\u6392\u5e8f\u89c4\u5219\uff0c\u800c utf8_bin \u662f\u4e00\u4e2a\u4e8c\u8fdb\u5236\u6392\u5e8f\u89c4\u5219\uff0c\u5b83\u4e0d\u8003\u8651\u5b57\u7b26\u7684\u5927\u5c0f\u5199\u548c\u91cd\u97f3\u7b26\u53f7\n\n\u4f8b\uff1aCREATE TABLE example_table (\n    column1 VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,\n    column2 VARCHAR(255) CHARACTER SET latin1 COLLATE latin1_german1_ci\n);\n\n10.\u4e00\u4e2a\u6c49\u5b57\u5360\u4e09\u4e2a\u5b57\u8282\n11\uff1aengine = InnoDB\uff1a\u6307\u5b9a\u8868\u4f7f\u7528\u7684\u5b58\u50a8\u5f15\u64ce\u4e3aInnoDB\u3002InnoDB\u662fMySQL\u548cMariaDB\u4e2d\u5e7f\u6cdb\u4f7f\u7528\u7684\u4e8b\u52a1\u5b89\u5168\u578b\u5b58\u50a8\u5f15\u64ce\uff0c\u652f\u6301\u884c\u7ea7\u9501\u5b9a\u548c\u5916\u952e\u7ea6\u675f\u3002\nauto_increment=2\uff1a\u8bbe\u7f6e\u8868\u7684\u81ea\u52a8\u589e\u957f\u5217\u7684\u8d77\u59cb\u503c\u4e3a2\u3002\u8fd9\u610f\u5473\u7740\u5982\u679c\u8868\u4e2d\u6709\u4e00\u4e2a\u81ea\u52a8\u589e\u957f\u7684\u5217\uff08\u5982\u4e3b\u952e\uff09\uff0c\u90a3\u4e48\u8be5\u5217\u7684\u503c\u5c06\u4ece2\u5f00\u59cb\u9012\u589e\u3002\ndefault charset=utf8mb3\uff1a\u8bbe\u7f6e\u8868\u7684\u9ed8\u8ba4\u5b57\u7b26\u96c6\u4e3autf8mb3\u3002utf8mb3\u662futf8\u5b57\u7b26\u96c6\u7684\u4e00\u4e2a\u53d8\u4f53\uff0c\u5b83\u652f\u6301\u66f4\u5c11\u7684\u5b57\u7b26\uff0c\u4f46\u901a\u5e38\u8db3\u4ee5\u6ee1\u8db3\u5927\u591a\u6570\u8bed\u8a00\u7684\u9700\u6c42\u3002utf8mb3\u5b57\u7b26\u96c6\u53ef\u4ee5\u5b58\u50a8\u5927\u90e8\u5206Unicode\u5b57\u7b26\uff0c\u4f46\u4e0d\u5305\u62ec\u4e00\u4e9b\u7279\u6b8a\u5b57\u7b26\u3002\ncollate=utf8_bin\uff1a\u8bbe\u7f6e\u8868\u7684\u9ed8\u8ba4\u6392\u5e8f\u89c4\u5219\u4e3autf8_bin\u3002utf8_bin\u6392\u5e8f\u89c4\u5219\u662f\u4e8c\u8fdb\u5236\u6bd4\u8f83\uff0c\u5b83\u4e0d\u8003\u8651\u5b57\u7b26\u7684\u5927\u5c0f\u5199\u548c\u91cd\u97f3\u7b26\u53f7\uff0c\u9002\u7528\u4e8e\u9700\u8981\u7cbe\u786e\u5339\u914d\u7684\u573a\u666f\u3002\ncomment='\u5730\u5740\u7c3f'\uff1a\u4e3a\u8868\u6dfb\u52a0\u6ce8\u91ca\uff0c\u8bf4\u660e\u8be5\u8868\u7528\u4e8e\u5b58\u50a8\u5730\u5740\u7c3f\u4fe1\u606f\u3002\n\n\n\n\n\n\n<\/em>  `user_id` bigint NOT NULL COMMENT '\u7528\u6237id',\n  `consignee` varchar(50) COLLATE utf8_bin DEFAULT NULL COMMENT '\u6536\u8d27\u4eba',\n  `sex` varchar(2) COLLATE utf8_bin DEFAULT NULL COMMENT '\u6027\u522b',\n  `phone` varchar(11) COLLATE utf8_bin NOT NULL COMMENT '\u624b\u673a\u53f7',\n  `province_code` varchar(12) CHARACTER SET utf8mb4  DEFAULT NULL COMMENT '\u7701\u7ea7\u533a\u5212\u7f16\u53f7',\n  `province_name` varchar(32) CHARACTER SET utf8mb4  DEFAULT NULL COMMENT '\u7701\u7ea7\u540d\u79f0',\n  `city_code` varchar(12) CHARACTER SET utf8mb4  DEFAULT NULL COMMENT '\u5e02\u7ea7\u533a\u5212\u7f16\u53f7',\n  `city_name` varchar(32) CHARACTER SET utf8mb4  DEFAULT NULL COMMENT '\u5e02\u7ea7\u540d\u79f0',\n  `district_code` varchar(12) CHARACTER SET utf8mb4  DEFAULT NULL COMMENT '\u533a\u7ea7\u533a\u5212\u7f16\u53f7',\n  `district_name` varchar(32) CHARACTER SET utf8mb4  DEFAULT NULL COMMENT '\u533a\u7ea7\u540d\u79f0',\n  `detail` varchar(200) CHARACTER SET utf8mb4  DEFAULT NULL COMMENT '\u8be6\u7ec6\u5730\u5740',\n  `label` varchar(100) CHARACTER SET utf8mb4  DEFAULT NULL COMMENT '\u6807\u7b7e',\n  `is_default` tinyint(1) NOT NULL DEFAULT '0' COMMENT '\u9ed8\u8ba4 0 \u5426 1\u662f',\n  PRIMARY KEY (`id`)\n) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3 COLLATE=utf8_bin COMMENT='\u5730\u5740\u7c3f';\n\nDROP TABLE IF EXISTS `category`;\nCREATE TABLE `category` (\n  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '\u4e3b\u952e',\n  `type` int DEFAULT NULL COMMENT '\u7c7b\u578b   1 \u83dc\u54c1\u5206\u7c7b 2 \u5957\u9910\u5206\u7c7b',\n  `name` varchar(32) COLLATE utf8_bin NOT NULL COMMENT '\u5206\u7c7b\u540d\u79f0',\n  `sort` int NOT NULL DEFAULT '0' COMMENT '\u987a\u5e8f',\n  `status` int DEFAULT NULL COMMENT '\u5206\u7c7b\u72b6\u6001 0:\u7981\u7528\uff0c1:\u542f\u7528',\n  `create_time` datetime DEFAULT NULL COMMENT '\u521b\u5efa\u65f6\u95f4',\n  `update_time` datetime DEFAULT NULL COMMENT '\u66f4\u65b0\u65f6\u95f4',\n  `create_user` bigint DEFAULT NULL COMMENT '\u521b\u5efa\u4eba',\n  `update_user` bigint DEFAULT NULL COMMENT '\u4fee\u6539\u4eba',\n  PRIMARY KEY (`id`),\n  UNIQUE KEY `idx_category_name` (`name`)\n) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8mb3 COLLATE=utf8_bin COMMENT='\u83dc\u54c1\u53ca\u5957\u9910\u5206\u7c7b';\n\nINSERT INTO `category` VALUES (11,1,'\u9152\u6c34\u996e\u6599',10,1,'2022-06-09 22:09:18','2022-06-09 22:09:18',1,1);\nINSERT INTO `category` VALUES (12,1,'\u4f20\u7edf\u4e3b\u98df',9,1,'2022-06-09 22:09:32','2022-06-09 22:18:53',1,1);\nINSERT INTO `category` VALUES (13,2,'\u4eba\u6c14\u5957\u9910',12,1,'2022-06-09 22:11:38','2022-06-10 11:04:40',1,1);\nINSERT INTO `category` VALUES (15,2,'\u5546\u52a1\u5957\u9910',13,1,'2022-06-09 22:14:10','2022-06-10 11:04:48',1,1);\nINSERT INTO `category` VALUES (16,1,'\u8700\u5473\u70e4\u9c7c',4,1,'2022-06-09 22:15:37','2022-08-31 14:27:25',1,1);\nINSERT INTO `category` VALUES (17,1,'\u8700\u5473\u725b\u86d9',5,1,'2022-06-09 22:16:14','2022-08-31 14:39:44',1,1);\nINSERT INTO `category` VALUES (18,1,'\u7279\u8272\u84b8\u83dc',6,1,'2022-06-09 22:17:42','2022-06-09 22:17:42',1,1);\nINSERT INTO `category` VALUES (19,1,'\u65b0\u9c9c\u65f6\u852c',7,1,'2022-06-09 22:18:12','2022-06-09 22:18:28',1,1);\nINSERT INTO `category` VALUES (20,1,'\u6c34\u716e\u9c7c',8,1,'2022-06-09 22:22:29','2022-06-09 22:23:45',1,1);\nINSERT INTO `category` VALUES (21,1,'\u6c64\u7c7b',11,1,'2022-06-10 10:51:47','2022-06-10 10:51:47',1,1);\n\nDROP TABLE IF EXISTS `dish`;\nCREATE TABLE `dish` (\n  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '\u4e3b\u952e',\n  `name` varchar(32) COLLATE utf8_bin NOT NULL COMMENT '\u83dc\u54c1\u540d\u79f0',\n  `category_id` bigint NOT NULL COMMENT '\u83dc\u54c1\u5206\u7c7bid',\n  `price` decimal(10,2) DEFAULT NULL COMMENT '\u83dc\u54c1\u4ef7\u683c',\n  `image` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '\u56fe\u7247',\n  `description` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '\u63cf\u8ff0\u4fe1\u606f',\n  `status` int DEFAULT '1' COMMENT '0 \u505c\u552e 1 \u8d77\u552e',\n  `create_time` datetime DEFAULT NULL COMMENT '\u521b\u5efa\u65f6\u95f4',\n  `update_time` datetime DEFAULT NULL COMMENT '\u66f4\u65b0\u65f6\u95f4',\n  `create_user` bigint DEFAULT NULL COMMENT '\u521b\u5efa\u4eba',\n  `update_user` bigint DEFAULT NULL COMMENT '\u4fee\u6539\u4eba',\n  PRIMARY KEY (`id`),\n  UNIQUE KEY `idx_dish_name` (`name`)\n) ENGINE=InnoDB AUTO_INCREMENT=70 DEFAULT CHARSET=utf8mb3 COLLATE=utf8_bin COMMENT='\u83dc\u54c1';\n\nINSERT INTO `dish` VALUES (46,'\u738b\u8001\u5409',11,6.00,'https:\/\/sky-itcast.oss-cn-beijing.aliyuncs.com\/41bfcacf-7ad4-4927-8b26-df366553a94c.png','',1,'2022-06-09 22:40:47','2022-06-09 22:40:47',1,1);\nINSERT INTO `dish` VALUES (47,'\u5317\u51b0\u6d0b',11,4.00,'https:\/\/sky-itcast.oss-cn-beijing.aliyuncs.com\/4451d4be-89a2-4939-9c69-3a87151cb979.png','\u8fd8\u662f\u5c0f\u65f6\u5019\u7684\u5473\u9053',1,'2022-06-10 09:18:49','2022-06-10 09:18:49',1,1);\nINSERT INTO `dish` VALUES (48,'\u96ea\u82b1\u5564\u9152',11,4.00,'https:\/\/sky-itcast.oss-cn-beijing.aliyuncs.com\/bf8cbfc1-04d2-40e8-9826-061ee41ab87c.png','',1,'2022-06-10 09:22:54','2022-06-10 09:22:54',1,1);\nINSERT INTO `dish` VALUES (49,'\u7c73\u996d',12,2.00,'https:\/\/sky-itcast.oss-cn-beijing.aliyuncs.com\/76752350-2121-44d2-b477-10791c23a8ec.png','\u7cbe\u9009\u4e94\u5e38\u5927\u7c73',1,'2022-06-10 09:30:17','2022-06-10 09:30:17',1,1);\nINSERT INTO `dish` VALUES (50,'\u9992\u5934',12,1.00,'https:\/\/sky-itcast.oss-cn-beijing.aliyuncs.com\/475cc599-8661-4899-8f9e-121dd8ef7d02.png','\u4f18\u8d28\u9762\u7c89',1,'2022-06-10 09:34:28','2022-06-10 09:34:28',1,1);\nINSERT INTO `dish` VALUES (51,'\u8001\u575b\u9178\u83dc\u9c7c',20,56.00,'https:\/\/sky-itcast.oss-cn-beijing.aliyuncs.com\/4a9cefba-6a74-467e-9fde-6e687ea725d7.png','\u539f\u6599\uff1a\u6c64\uff0c\u8349\u9c7c\uff0c\u9178\u83dc',1,'2022-06-10 09:40:51','2022-06-10 09:40:51',1,1);\nINSERT INTO `dish` VALUES (52,'\u7ecf\u5178\u9178\u83dc\u9bb0\u9c7c',20,66.00,'https:\/\/sky-itcast.oss-cn-beijing.aliyuncs.com\/5260ff39-986c-4a97-8850-2ec8c7583efc.png','\u539f\u6599\uff1a\u9178\u83dc\uff0c\u6c5f\u56e2\uff0c\u9bb0\u9c7c',1,'2022-06-10 09:46:02','2022-06-10 09:46:02',1,1);\nINSERT INTO `dish` VALUES (53,'\u8700\u5473\u6c34\u716e\u8349\u9c7c',20,38.00,'https:\/\/sky-itcast.oss-cn-beijing.aliyuncs.com\/a6953d5a-4c18-4b30-9319-4926ee77261f.png','\u539f\u6599\uff1a\u8349\u9c7c\uff0c\u6c64',1,'2022-06-10 09:48:37','2022-06-10 09:48:37',1,1);\nINSERT INTO `dish` VALUES (54,'\u6e05\u7092\u5c0f\u6cb9\u83dc',19,18.00,'https:\/\/sky-itcast.oss-cn-beijing.aliyuncs.com\/3613d38e-5614-41c2-90ed-ff175bf50716.png','\u539f\u6599\uff1a\u5c0f\u6cb9\u83dc',1,'2022-06-10 09:51:46','2022-06-10 09:51:46',1,1);\nINSERT INTO `dish` VALUES (55,'\u849c\u84c9\u5a03\u5a03\u83dc',19,18.00,'https:\/\/sky-itcast.oss-cn-beijing.aliyuncs.com\/4879ed66-3860-4b28-ba14-306ac025fdec.png','\u539f\u6599\uff1a\u849c\uff0c\u5a03\u5a03\u83dc',1,'2022-06-10 09:53:37','2022-06-10 09:53:37',1,1);\nINSERT INTO `dish` VALUES (56,'\u6e05\u7092\u897f\u5170\u82b1',19,18.00,'https:\/\/sky-itcast.oss-cn-beijing.aliyuncs.com\/e9ec4ba4-4b22-4fc8-9be0-4946e6aeb937.png','\u539f\u6599\uff1a\u897f\u5170\u82b1',1,'2022-06-10 09:55:44','2022-06-10 09:55:44',1,1);\nINSERT INTO `dish` VALUES (57,'\u709d\u7092\u5706\u767d\u83dc',19,18.00,'https:\/\/sky-itcast.oss-cn-beijing.aliyuncs.com\/22f59feb-0d44-430e-a6cd-6a49f27453ca.png','\u539f\u6599\uff1a\u5706\u767d\u83dc',1,'2022-06-10 09:58:35','2022-06-10 09:58:35',1,1);\nINSERT INTO `dish` VALUES (58,'\u6e05\u84b8\u9c88\u9c7c',18,98.00,'https:\/\/sky-itcast.oss-cn-beijing.aliyuncs.com\/c18b5c67-3b71-466c-a75a-e63c6449f21c.png','\u539f\u6599\uff1a\u9c88\u9c7c',1,'2022-06-10 10:12:28','2022-06-10 10:12:28',1,1);\nINSERT INTO `dish` VALUES (59,'\u4e1c\u5761\u8098\u5b50',18,138.00,'https:\/\/sky-itcast.oss-cn-beijing.aliyuncs.com\/a80a4b8c-c93e-4f43-ac8a-856b0d5cc451.png','\u539f\u6599\uff1a\u732a\u8098\u68d2',1,'2022-06-10 10:24:03','2022-06-10 10:24:03',1,1);\nINSERT INTO `dish` VALUES (60,'\u6885\u83dc\u6263\u8089',18,58.00,'https:\/\/sky-itcast.oss-cn-beijing.aliyuncs.com\/6080b118-e30a-4577-aab4-45042e3f88be.png','\u539f\u6599\uff1a\u732a\u8089\uff0c\u6885\u83dc',1,'2022-06-10 10:26:03','2022-06-10 10:26:03',1,1);\nINSERT INTO `dish` VALUES (61,'\u5241\u6912\u9c7c\u5934',18,66.00,'https:\/\/sky-itcast.oss-cn-beijing.aliyuncs.com\/13da832f-ef2c-484d-8370-5934a1045a06.png','\u539f\u6599\uff1a\u9ca2\u9c7c\uff0c\u5241\u6912',1,'2022-06-10 10:28:54','2022-06-10 10:28:54',1,1);\nINSERT INTO `dish` VALUES (62,'\u91d1\u6c64\u9178\u83dc\u725b\u86d9',17,88.00,'https:\/\/sky-itcast.oss-cn-beijing.aliyuncs.com\/7694a5d8-7938-4e9d-8b9e-2075983a2e38.png','\u539f\u6599\uff1a\u9c9c\u6d3b\u725b\u86d9\uff0c\u9178\u83dc',1,'2022-06-10 10:33:05','2022-06-10 10:33:05',1,1);\nINSERT INTO `dish` VALUES (63,'\u9999\u9505\u725b\u86d9',17,88.00,'https:\/\/sky-itcast.oss-cn-beijing.aliyuncs.com\/f5ac8455-4793-450c-97ba-173795c34626.png','\u914d\u6599\uff1a\u9c9c\u6d3b\u725b\u86d9\uff0c\u83b2\u85d5\uff0c\u9752\u7b0b',1,'2022-06-10 10:35:40','2022-06-10 10:35:40',1,1);\nINSERT INTO `dish` VALUES (64,'\u998b\u5634\u725b\u86d9',17,88.00,'https:\/\/sky-itcast.oss-cn-beijing.aliyuncs.com\/7a55b845-1f2b-41fa-9486-76d187ee9ee1.png','\u914d\u6599\uff1a\u9c9c\u6d3b\u725b\u86d9\uff0c\u4e1d\u74dc\uff0c\u9ec4\u8c46\u82bd',1,'2022-06-10 10:37:52','2022-06-10 10:37:52',1,1);\nINSERT INTO `dish` VALUES (65,'\u8349\u9c7c2\u65a4',16,68.00,'https:\/\/sky-itcast.oss-cn-beijing.aliyuncs.com\/b544d3ba-a1ae-4d20-a860-81cb5dec9e03.png','\u539f\u6599\uff1a\u8349\u9c7c\uff0c\u9ec4\u8c46\u82bd\uff0c\u83b2\u85d5',1,'2022-06-10 10:41:08','2022-06-10 10:41:08',1,1);\nINSERT INTO `dish` VALUES (66,'\u6c5f\u56e2\u9c7c2\u65a4',16,119.00,'https:\/\/sky-itcast.oss-cn-beijing.aliyuncs.com\/a101a1e9-8f8b-47b2-afa4-1abd47ea0a87.png','\u914d\u6599\uff1a\u6c5f\u56e2\u9c7c\uff0c\u9ec4\u8c46\u82bd\uff0c\u83b2\u85d5',1,'2022-06-10 10:42:42','2022-06-10 10:42:42',1,1);\nINSERT INTO `dish` VALUES (67,'\u9bb0\u9c7c2\u65a4',16,72.00,'https:\/\/sky-itcast.oss-cn-beijing.aliyuncs.com\/8cfcc576-4b66-4a09-ac68-ad5b273c2590.png','\u539f\u6599\uff1a\u9bb0\u9c7c\uff0c\u9ec4\u8c46\u82bd\uff0c\u83b2\u85d5',1,'2022-06-10 10:43:56','2022-06-10 10:43:56',1,1);\nINSERT INTO `dish` VALUES (68,'\u9e21\u86cb\u6c64',21,4.00,'https:\/\/sky-itcast.oss-cn-beijing.aliyuncs.com\/c09a0ee8-9d19-428d-81b9-746221824113.png','\u914d\u6599\uff1a\u9e21\u86cb\uff0c\u7d2b\u83dc',1,'2022-06-10 10:54:25','2022-06-10 10:54:25',1,1);\nINSERT INTO `dish` VALUES (69,'\u5e73\u83c7\u8c46\u8150\u6c64',21,6.00,'https:\/\/sky-itcast.oss-cn-beijing.aliyuncs.com\/16d0a3d6-2253-4cfc-9b49-bf7bd9eb2ad2.png','\u914d\u6599\uff1a\u8c46\u8150\uff0c\u5e73\u83c7',1,'2022-06-10 10:55:02','2022-06-10 10:55:02',1,1);\n\nDROP TABLE IF EXISTS `dish_flavor`;\nCREATE TABLE `dish_flavor` (\n  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '\u4e3b\u952e',\n  `dish_id` bigint NOT NULL COMMENT '\u83dc\u54c1',\n  `name` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '\u53e3\u5473\u540d\u79f0',\n  `value` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '\u53e3\u5473\u6570\u636elist',\n  PRIMARY KEY (`id`)\n) ENGINE=InnoDB AUTO_INCREMENT=104 DEFAULT CHARSET=utf8mb3 COLLATE=utf8_bin COMMENT='\u83dc\u54c1\u53e3\u5473\u5173\u7cfb\u8868';\n\nINSERT INTO `dish_flavor` VALUES (40,10,'\u751c\u5473','[\\\"\u65e0\u7cd6\\\",\\\"\u5c11\u7cd6\\\",\\\"\u534a\u7cd6\\\",\\\"\u591a\u7cd6\\\",\\\"\u5168\u7cd6\\\"]');\nINSERT INTO `dish_flavor` VALUES (41,7,'\u5fcc\u53e3','[\\\"\u4e0d\u8981\u8471\\\",\\\"\u4e0d\u8981\u849c\\\",\\\"\u4e0d\u8981\u9999\u83dc\\\",\\\"\u4e0d\u8981\u8fa3\\\"]');\nINSERT INTO `dish_flavor` VALUES (42,7,'\u6e29\u5ea6','[\\\"\u70ed\u996e\\\",\\\"\u5e38\u6e29\\\",\\\"\u53bb\u51b0\\\",\\\"\u5c11\u51b0\\\",\\\"\u591a\u51b0\\\"]');\nINSERT INTO `dish_flavor` VALUES (45,6,'\u5fcc\u53e3','[\\\"\u4e0d\u8981\u8471\\\",\\\"\u4e0d\u8981\u849c\\\",\\\"\u4e0d\u8981\u9999\u83dc\\\",\\\"\u4e0d\u8981\u8fa3\\\"]');\nINSERT INTO `dish_flavor` VALUES (46,6,'\u8fa3\u5ea6','[\\\"\u4e0d\u8fa3\\\",\\\"\u5fae\u8fa3\\\",\\\"\u4e2d\u8fa3\\\",\\\"\u91cd\u8fa3\\\"]');\nINSERT INTO `dish_flavor` VALUES (47,5,'\u8fa3\u5ea6','[\\\"\u4e0d\u8fa3\\\",\\\"\u5fae\u8fa3\\\",\\\"\u4e2d\u8fa3\\\",\\\"\u91cd\u8fa3\\\"]');\nINSERT INTO `dish_flavor` VALUES (48,5,'\u751c\u5473','[\\\"\u65e0\u7cd6\\\",\\\"\u5c11\u7cd6\\\",\\\"\u534a\u7cd6\\\",\\\"\u591a\u7cd6\\\",\\\"\u5168\u7cd6\\\"]');\nINSERT INTO `dish_flavor` VALUES (49,2,'\u751c\u5473','[\\\"\u65e0\u7cd6\\\",\\\"\u5c11\u7cd6\\\",\\\"\u534a\u7cd6\\\",\\\"\u591a\u7cd6\\\",\\\"\u5168\u7cd6\\\"]');\nINSERT INTO `dish_flavor` VALUES (50,4,'\u751c\u5473','[\\\"\u65e0\u7cd6\\\",\\\"\u5c11\u7cd6\\\",\\\"\u534a\u7cd6\\\",\\\"\u591a\u7cd6\\\",\\\"\u5168\u7cd6\\\"]');\nINSERT INTO `dish_flavor` VALUES (51,3,'\u751c\u5473','[\\\"\u65e0\u7cd6\\\",\\\"\u5c11\u7cd6\\\",\\\"\u534a\u7cd6\\\",\\\"\u591a\u7cd6\\\",\\\"\u5168\u7cd6\\\"]');\nINSERT INTO `dish_flavor` VALUES (52,3,'\u5fcc\u53e3','[\\\"\u4e0d\u8981\u8471\\\",\\\"\u4e0d\u8981\u849c\\\",\\\"\u4e0d\u8981\u9999\u83dc\\\",\\\"\u4e0d\u8981\u8fa3\\\"]');\nINSERT INTO `dish_flavor` VALUES (86,52,'\u5fcc\u53e3','[\\\"\u4e0d\u8981\u8471\\\",\\\"\u4e0d\u8981\u849c\\\",\\\"\u4e0d\u8981\u9999\u83dc\\\",\\\"\u4e0d\u8981\u8fa3\\\"]');\nINSERT INTO `dish_flavor` VALUES (87,52,'\u8fa3\u5ea6','[\\\"\u4e0d\u8fa3\\\",\\\"\u5fae\u8fa3\\\",\\\"\u4e2d\u8fa3\\\",\\\"\u91cd\u8fa3\\\"]');\nINSERT INTO `dish_flavor` VALUES (88,51,'\u5fcc\u53e3','[\\\"\u4e0d\u8981\u8471\\\",\\\"\u4e0d\u8981\u849c\\\",\\\"\u4e0d\u8981\u9999\u83dc\\\",\\\"\u4e0d\u8981\u8fa3\\\"]');\nINSERT INTO `dish_flavor` VALUES (89,51,'\u8fa3\u5ea6','[\\\"\u4e0d\u8fa3\\\",\\\"\u5fae\u8fa3\\\",\\\"\u4e2d\u8fa3\\\",\\\"\u91cd\u8fa3\\\"]');\nINSERT INTO `dish_flavor` VALUES (92,53,'\u5fcc\u53e3','[\\\"\u4e0d\u8981\u8471\\\",\\\"\u4e0d\u8981\u849c\\\",\\\"\u4e0d\u8981\u9999\u83dc\\\",\\\"\u4e0d\u8981\u8fa3\\\"]');\nINSERT INTO `dish_flavor` VALUES (93,53,'\u8fa3\u5ea6','[\\\"\u4e0d\u8fa3\\\",\\\"\u5fae\u8fa3\\\",\\\"\u4e2d\u8fa3\\\",\\\"\u91cd\u8fa3\\\"]');\nINSERT INTO `dish_flavor` VALUES (94,54,'\u5fcc\u53e3','[\\\"\u4e0d\u8981\u8471\\\",\\\"\u4e0d\u8981\u849c\\\",\\\"\u4e0d\u8981\u9999\u83dc\\\"]');\nINSERT INTO `dish_flavor` VALUES (95,56,'\u5fcc\u53e3','[\\\"\u4e0d\u8981\u8471\\\",\\\"\u4e0d\u8981\u849c\\\",\\\"\u4e0d\u8981\u9999\u83dc\\\",\\\"\u4e0d\u8981\u8fa3\\\"]');\nINSERT INTO `dish_flavor` VALUES (96,57,'\u5fcc\u53e3','[\\\"\u4e0d\u8981\u8471\\\",\\\"\u4e0d\u8981\u849c\\\",\\\"\u4e0d\u8981\u9999\u83dc\\\",\\\"\u4e0d\u8981\u8fa3\\\"]');\nINSERT INTO `dish_flavor` VALUES (97,60,'\u5fcc\u53e3','[\\\"\u4e0d\u8981\u8471\\\",\\\"\u4e0d\u8981\u849c\\\",\\\"\u4e0d\u8981\u9999\u83dc\\\",\\\"\u4e0d\u8981\u8fa3\\\"]');\nINSERT INTO `dish_flavor` VALUES (101,66,'\u8fa3\u5ea6','[\\\"\u4e0d\u8fa3\\\",\\\"\u5fae\u8fa3\\\",\\\"\u4e2d\u8fa3\\\",\\\"\u91cd\u8fa3\\\"]');\nINSERT INTO `dish_flavor` VALUES (102,67,'\u8fa3\u5ea6','[\\\"\u4e0d\u8fa3\\\",\\\"\u5fae\u8fa3\\\",\\\"\u4e2d\u8fa3\\\",\\\"\u91cd\u8fa3\\\"]');\nINSERT INTO `dish_flavor` VALUES (103,65,'\u8fa3\u5ea6','[\\\"\u4e0d\u8fa3\\\",\\\"\u5fae\u8fa3\\\",\\\"\u4e2d\u8fa3\\\",\\\"\u91cd\u8fa3\\\"]');\n\nDROP TABLE IF EXISTS `employee`;\nCREATE TABLE `employee` (\n  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '\u4e3b\u952e',\n  `name` varchar(32) COLLATE utf8_bin NOT NULL COMMENT '\u59d3\u540d',\n  `username` varchar(32) COLLATE utf8_bin NOT NULL COMMENT '\u7528\u6237\u540d',\n  `password` varchar(64) COLLATE utf8_bin NOT NULL COMMENT '\u5bc6\u7801',\n  `phone` varchar(11) COLLATE utf8_bin NOT NULL COMMENT '\u624b\u673a\u53f7',\n  `sex` varchar(2) COLLATE utf8_bin NOT NULL COMMENT '\u6027\u522b',\n  `id_number` varchar(18) COLLATE utf8_bin NOT NULL COMMENT '\u8eab\u4efd\u8bc1\u53f7',\n  `status` int NOT NULL DEFAULT '1' COMMENT '\u72b6\u6001 0:\u7981\u7528\uff0c1:\u542f\u7528',\n  `create_time` datetime DEFAULT NULL COMMENT '\u521b\u5efa\u65f6\u95f4',\n  `update_time` datetime DEFAULT NULL COMMENT '\u66f4\u65b0\u65f6\u95f4',\n  `create_user` bigint DEFAULT NULL COMMENT '\u521b\u5efa\u4eba',\n  `update_user` bigint DEFAULT NULL COMMENT '\u4fee\u6539\u4eba',\n  PRIMARY KEY (`id`),\n  UNIQUE KEY `idx_username` (`username`)\n) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3 COLLATE=utf8_bin COMMENT='\u5458\u5de5\u4fe1\u606f';\n\nINSERT INTO `employee` VALUES (1,'\u7ba1\u7406\u5458','admin','123456','13812312312','1','110101199001010047',1,'2022-02-15 15:51:20','2022-02-17 09:16:20',10,1);\n\nDROP TABLE IF EXISTS `order_detail`;\nCREATE TABLE `order_detail` (\n  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '\u4e3b\u952e',\n  `name` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '\u540d\u5b57',\n  `image` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '\u56fe\u7247',\n  `order_id` bigint NOT NULL COMMENT '\u8ba2\u5355id',\n  `dish_id` bigint DEFAULT NULL COMMENT '\u83dc\u54c1id',\n  `setmeal_id` bigint DEFAULT NULL COMMENT '\u5957\u9910id',\n  `dish_flavor` varchar(50) COLLATE utf8_bin DEFAULT NULL COMMENT '\u53e3\u5473',\n  `number` int NOT NULL DEFAULT '1' COMMENT '\u6570\u91cf',\n  `amount` decimal(10,2) NOT NULL COMMENT '\u91d1\u989d',\n  PRIMARY KEY (`id`)\n) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb3 COLLATE=utf8_bin COMMENT='\u8ba2\u5355\u660e\u7ec6\u8868';\n\nDROP TABLE IF EXISTS `orders`;\nCREATE TABLE `orders` (\n  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '\u4e3b\u952e',\n  `number` varchar(50) COLLATE utf8_bin DEFAULT NULL COMMENT '\u8ba2\u5355\u53f7',\n  `status` int NOT NULL DEFAULT '1' COMMENT '\u8ba2\u5355\u72b6\u6001 1\u5f85\u4ed8\u6b3e 2\u5f85\u63a5\u5355 3\u5df2\u63a5\u5355 4\u6d3e\u9001\u4e2d 5\u5df2\u5b8c\u6210 6\u5df2\u53d6\u6d88 7\u9000\u6b3e',\n  `user_id` bigint NOT NULL COMMENT '\u4e0b\u5355\u7528\u6237',\n  `address_book_id` bigint NOT NULL COMMENT '\u5730\u5740id',\n  `order_time` datetime NOT NULL COMMENT '\u4e0b\u5355\u65f6\u95f4',\n  `checkout_time` datetime DEFAULT NULL COMMENT '\u7ed3\u8d26\u65f6\u95f4',\n  `pay_method` int NOT NULL DEFAULT '1' COMMENT '\u652f\u4ed8\u65b9\u5f0f 1\u5fae\u4fe1,2\u652f\u4ed8\u5b9d',\n  `pay_status` tinyint NOT NULL DEFAULT '0' COMMENT '\u652f\u4ed8\u72b6\u6001 0\u672a\u652f\u4ed8 1\u5df2\u652f\u4ed8 2\u9000\u6b3e',\n  `amount` decimal(10,2) NOT NULL COMMENT '\u5b9e\u6536\u91d1\u989d',\n  `remark` varchar(100) COLLATE utf8_bin DEFAULT NULL COMMENT '\u5907\u6ce8',\n  `phone` varchar(11) COLLATE utf8_bin DEFAULT NULL COMMENT '\u624b\u673a\u53f7',\n  `address` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '\u5730\u5740',\n  `user_name` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '\u7528\u6237\u540d\u79f0',\n  `consignee` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '\u6536\u8d27\u4eba',\n  `cancel_reason` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '\u8ba2\u5355\u53d6\u6d88\u539f\u56e0',\n  `rejection_reason` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '\u8ba2\u5355\u62d2\u7edd\u539f\u56e0',\n  `cancel_time` datetime DEFAULT NULL COMMENT '\u8ba2\u5355\u53d6\u6d88\u65f6\u95f4',\n  `estimated_delivery_time` datetime DEFAULT NULL COMMENT '\u9884\u8ba1\u9001\u8fbe\u65f6\u95f4',\n  `delivery_status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '\u914d\u9001\u72b6\u6001  1\u7acb\u5373\u9001\u51fa  0\u9009\u62e9\u5177\u4f53\u65f6\u95f4',\n  `delivery_time` datetime DEFAULT NULL COMMENT '\u9001\u8fbe\u65f6\u95f4',\n  `pack_amount` int DEFAULT NULL COMMENT '\u6253\u5305\u8d39',\n  `tableware_number` int DEFAULT NULL COMMENT '\u9910\u5177\u6570\u91cf',\n  `tableware_status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '\u9910\u5177\u6570\u91cf\u72b6\u6001  1\u6309\u9910\u91cf\u63d0\u4f9b  0\u9009\u62e9\u5177\u4f53\u6570\u91cf',\n  PRIMARY KEY (`id`)\n) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb3 COLLATE=utf8_bin COMMENT='\u8ba2\u5355\u8868';\n\nDROP TABLE IF EXISTS `setmeal`;\nCREATE TABLE `setmeal` (\n  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '\u4e3b\u952e',\n  `category_id` bigint NOT NULL COMMENT '\u83dc\u54c1\u5206\u7c7bid',\n  `name` varchar(32) COLLATE utf8_bin NOT NULL COMMENT '\u5957\u9910\u540d\u79f0',\n  `price` decimal(10,2) NOT NULL COMMENT '\u5957\u9910\u4ef7\u683c',\n  `status` int DEFAULT '1' COMMENT '\u552e\u5356\u72b6\u6001 0:\u505c\u552e 1:\u8d77\u552e',\n  `description` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '\u63cf\u8ff0\u4fe1\u606f',\n  `image` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '\u56fe\u7247',\n  `create_time` datetime DEFAULT NULL COMMENT '\u521b\u5efa\u65f6\u95f4',\n  `update_time` datetime DEFAULT NULL COMMENT '\u66f4\u65b0\u65f6\u95f4',\n  `create_user` bigint DEFAULT NULL COMMENT '\u521b\u5efa\u4eba',\n  `update_user` bigint DEFAULT NULL COMMENT '\u4fee\u6539\u4eba',\n  PRIMARY KEY (`id`),\n  UNIQUE KEY `idx_setmeal_name` (`name`)\n) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8mb3 COLLATE=utf8_bin COMMENT='\u5957\u9910';\n\nDROP TABLE IF EXISTS `setmeal_dish`;\nCREATE TABLE `setmeal_dish` (\n  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '\u4e3b\u952e',\n  `setmeal_id` bigint DEFAULT NULL COMMENT '\u5957\u9910id',\n  `dish_id` bigint DEFAULT NULL COMMENT '\u83dc\u54c1id',\n  `name` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '\u83dc\u54c1\u540d\u79f0 \uff08\u5197\u4f59\u5b57\u6bb5\uff09',\n  `price` decimal(10,2) DEFAULT NULL COMMENT '\u83dc\u54c1\u5355\u4ef7\uff08\u5197\u4f59\u5b57\u6bb5\uff09',\n  `copies` int DEFAULT NULL COMMENT '\u83dc\u54c1\u4efd\u6570',\n  PRIMARY KEY (`id`)\n) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=utf8mb3 COLLATE=utf8_bin COMMENT='\u5957\u9910\u83dc\u54c1\u5173\u7cfb';\n\nDROP TABLE IF EXISTS `shopping_cart`;\nCREATE TABLE `shopping_cart` (\n  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '\u4e3b\u952e',\n  `name` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '\u5546\u54c1\u540d\u79f0',\n  `image` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '\u56fe\u7247',\n  `user_id` bigint NOT NULL COMMENT '\u4e3b\u952e',\n  `dish_id` bigint DEFAULT NULL COMMENT '\u83dc\u54c1id',\n  `setmeal_id` bigint DEFAULT NULL COMMENT '\u5957\u9910id',\n  `dish_flavor` varchar(50) COLLATE utf8_bin DEFAULT NULL COMMENT '\u53e3\u5473',\n  `number` int NOT NULL DEFAULT '1' COMMENT '\u6570\u91cf',\n  `amount` decimal(10,2) NOT NULL COMMENT '\u91d1\u989d',\n  `create_time` datetime DEFAULT NULL COMMENT '\u521b\u5efa\u65f6\u95f4',\n  PRIMARY KEY (`id`)\n) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb3 COLLATE=utf8_bin COMMENT='\u8d2d\u7269\u8f66';\n\nDROP TABLE IF EXISTS `user`;\nCREATE TABLE `user` (\n  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '\u4e3b\u952e',\n  `openid` varchar(45) COLLATE utf8_bin DEFAULT NULL COMMENT '\u5fae\u4fe1\u7528\u6237\u552f\u4e00\u6807\u8bc6',\n  `name` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '\u59d3\u540d',\n  `phone` varchar(11) COLLATE utf8_bin DEFAULT NULL COMMENT '\u624b\u673a\u53f7',\n  `sex` varchar(2) COLLATE utf8_bin DEFAULT NULL COMMENT '\u6027\u522b',\n  `id_number` varchar(18) COLLATE utf8_bin DEFAULT NULL COMMENT '\u8eab\u4efd\u8bc1\u53f7',\n  `avatar` varchar(500) COLLATE utf8_bin DEFAULT NULL COMMENT '\u5934\u50cf',\n  `create_time` datetime DEFAULT NULL,\n  PRIMARY KEY (`id`)\n) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb3 COLLATE=utf8_bin COMMENT='\u7528\u6237\u4fe1\u606f';<\/code><\/pre>\n\n\n\n
<\/code><\/pre>\n\n\n\n
ALTER\u5173\u952e\u5b57<\/p>\n\n\n\n
\u5728SQL\uff08Structured Query Language\uff0c\u7ed3\u6784\u5316\u67e5\u8be2\u8bed\u8a00\uff09\u4e2d\uff0cALTER<\/code> \u662f\u4e00\u4e2a\u5173\u952e\u5b57\uff0c\u7528\u4e8e\u4fee\u6539\u6570\u636e\u5e93\u8868\u7684\u7ed3\u6784\u3002\u4f7f\u7528 ALTER<\/code> \u8bed\u53e5\u53ef\u4ee5\u6dfb\u52a0\u3001\u5220\u9664\u6216\u4fee\u6539\u8868\u4e2d\u7684\u5217\uff0c\u4e5f\u53ef\u4ee5\u4fee\u6539\u8868\u7684\u5176\u4ed6\u5c5e\u6027\uff0c\u5982\u7ea6\u675f\u3001\u7d22\u5f15\u7b49\u3002<\/p>\n\n\n\n
ALTER<\/code> \u8bed\u53e5\u7684\u57fa\u672c\u8bed\u6cd5\u5982\u4e0b\uff1a<\/p>\n\n\n\n
ALTER TABLE table_name action;<\/code><\/pre>\n\n\n\n
\u5176\u4e2d\u00a0table_name<\/code>\u00a0\u662f\u8981\u4fee\u6539\u7684\u8868\u7684\u540d\u79f0\uff0caction<\/code>\u00a0\u662f\u8981\u6267\u884c\u7684\u5177\u4f53\u64cd\u4f5c\uff0c\u53ef\u4ee5\u662f\u6dfb\u52a0\u5217\u3001\u5220\u9664\u5217\u3001\u4fee\u6539\u5217\u5c5e\u6027\u7b49\u3002<\/p>\n\n\n\n
1.<\/p>\n\n\n\n
\u6dfb\u52a0\u5217<\/strong><\/p>\n\n\n\n
ALTER TABLE users ADD COLUMN age INT;\n\n<\/code><\/code><\/pre>\n\n\n\n
\u8fd9\u6761\u8bed\u53e5\u5411 users<\/code> \u8868\u4e2d\u6dfb\u52a0\u4e86\u4e00\u4e2a\u540d\u4e3a age<\/code> \u7684\u65b0\u5217\uff0c\u6570\u636e\u7c7b\u578b\u4e3a\u6574\u6570\uff08INT\uff09<\/p>\n\n\n\n
\u5220\u9664\u5217<\/strong>\uff1a<\/p>\n\n\n\n
ALTER TABLE users DROP COLUMN age;<\/code><\/pre>\n\n\n\n
\u8fd9\u6761\u8bed\u53e5\u4ece\u00a0users<\/code>\u00a0\u8868\u4e2d\u5220\u9664\u4e86\u540d\u4e3a\u00a0age<\/code>\u00a0\u7684\u5217\u3002<\/p>\n\n\n\n
.<\/p>\n\n\n\n
\u4fee\u6539\u5217<\/strong><\/p>\n\n\n\n
ALTER TABLE users MODIFY COLUMN age VARCHAR(255);<\/code><\/pre>\n\n\n\n
\u8fd9\u6761\u8bed\u53e5\u5c06\u00a0users<\/code>\u00a0\u8868\u4e2d\u7684\u00a0age<\/code>\u00a0\u5217\u7684\u6570\u636e\u7c7b\u578b\u4ece\u6574\u6570\uff08INT\uff09\u4fee\u6539\u4e3a\u5b57\u7b26\u4e32\uff08VARCHAR(255)\uff09<\/p>\n\n\n\n
.<\/p>\n\n\n\n
\u6dfb\u52a0\u7ea6\u675f<\/strong>\uff1a<\/p>\n\n\n\n
ALTER TABLE users ADD CONSTRAINT unique_age UNIQUE (age);<\/code><\/pre>\n\n\n\n
    \n
  1. \u8fd9\u6761\u8bed\u53e5\u4e3a\u00a0users<\/code>\u00a0\u8868\u4e2d\u7684\u00a0age<\/code>\u00a0\u5217\u6dfb\u52a0\u4e86\u4e00\u4e2a\u552f\u4e00\u7ea6\u675f\uff08UNIQUE\uff09\uff0c\u786e\u4fdd\u00a0age<\/code>\u00a0\u5217\u7684\u503c\u5728\u8868\u4e2d\u662f\u552f\u4e00\u7684<\/li>\n<\/ol>\n\n\n\n
    ALTER<\/code> \u8bed\u53e5\u975e\u5e38\u5f3a\u5927\uff0c\u4f46\u4f7f\u7528\u65f6\u9700\u8981\u8c28\u614e\uff0c\u56e0\u4e3a\u4fee\u6539\u8868\u7ed3\u6784\u53ef\u80fd\u4f1a\u5f71\u54cd\u5230\u4f9d\u8d56\u4e8e\u8be5\u8868\u7684\u5e94\u7528\u7a0b\u5e8f\u3002\u5728\u6267\u884c ALTER<\/code> \u64cd\u4f5c\u4e4b\u524d\uff0c\u5efa\u8bae\u5907\u4efd\u6570\u636e\u5e93\uff0c\u5e76\u786e\u4fdd\u7406\u89e3\u64cd\u4f5c\u7684\u5f71\u54cd\u3002<\/p>\n\n\n\n
    \u65b0\u589e\u5458\u5de5\u9700\u6c42\u5206\u6790\u8bbe\u8ba1\u6837\u4f8b<\/summary>\n
    sql\u8bed\u53e5\uff1a<\/p>\n\n\n\n
    create table employee\n(\n    id          bigint auto_increment comment '\u4e3b\u952e'\n        primary key,\n    name        varchar(32)   not null comment '\u59d3\u540d',\n    username    varchar(32)   not null comment '\u7528\u6237\u540d',\n    password    varchar(64)   not null comment '\u5bc6\u7801',\n    phone       varchar(11)   not null comment '\u624b\u673a\u53f7',\n    sex         varchar(2)    not null comment '\u6027\u522b',\n    id_number   varchar(18)   not null comment '\u8eab\u4efd\u8bc1\u53f7',\n    status      int default 1 not null comment '\u72b6\u6001 0:\u7981\u7528\uff0c1:\u542f\u7528',\n    create_time datetime      null comment '\u521b\u5efa\u65f6\u95f4',\n    update_time datetime      null comment '\u66f4\u65b0\u65f6\u95f4',\n    create_user bigint        null comment '\u521b\u5efa\u4eba',\n    update_user bigint        null comment '\u4fee\u6539\u4eba',\n    constraint idx_username unique (username)\n)\n    comment '\u5458\u5de5\u4fe1\u606f' collate = utf8mb3_bin;\n\n\u9875\u9762\u539f\u578b\uff1a\n<\/code><\/pre>\n\n\n<\/details>\n\n\n\n
    <\/p>\n\n\n\n
    <\/p>\n\n\n\n
    <\/p>\n\n\n\n
    <\/p>\n","protected":false},"excerpt":{"rendered":"
    ALTER\u5173\u952e\u5b57 \u5728SQL\uff08Structured Query Language\uff0c\u7ed3\u6784\u5316\u67e5\u8be2\u8bed\u8a00\uff09\u4e2d\uff0cALTER […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[],"class_list":["post-27","post","type-post","status-publish","format-standard","hentry","category-4"],"_links":{"self":[{"href":"https:\/\/note.ui11.cc\/index.php\/wp-json\/wp\/v2\/posts\/27","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/note.ui11.cc\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/note.ui11.cc\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/note.ui11.cc\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/note.ui11.cc\/index.php\/wp-json\/wp\/v2\/comments?post=27"}],"version-history":[{"count":5,"href":"https:\/\/note.ui11.cc\/index.php\/wp-json\/wp\/v2\/posts\/27\/revisions"}],"predecessor-version":[{"id":101,"href":"https:\/\/note.ui11.cc\/index.php\/wp-json\/wp\/v2\/posts\/27\/revisions\/101"}],"wp:attachment":[{"href":"https:\/\/note.ui11.cc\/index.php\/wp-json\/wp\/v2\/media?parent=27"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/note.ui11.cc\/index.php\/wp-json\/wp\/v2\/categories?post=27"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/note.ui11.cc\/index.php\/wp-json\/wp\/v2\/tags?post=27"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}