/*
 Navicat Premium Data Transfer

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 50731 (5.7.31-log)
 Source Host           : localhost:3306
 Source Schema         : sky_take_out

 Target Server Type    : MySQL
 Target Server Version : 50731 (5.7.31-log)
 File Encoding         : 65001

 Date: 03/04/2024 18:24:07
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for address_book
-- ----------------------------
DROP TABLE IF EXISTS `address_book`;
CREATE TABLE `address_book`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `user_id` bigint(20) NOT NULL COMMENT '用户id',
  `consignee` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '收货人',
  `sex` varchar(2) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '性别',
  `phone` varchar(11) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '手机号',
  `province_code` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '省级区划编号',
  `province_name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '省级名称',
  `city_code` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '市级区划编号',
  `city_name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '市级名称',
  `district_code` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '区级区划编号',
  `district_name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '区级名称',
  `detail` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '详细地址',
  `label` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '标签',
  `is_default` tinyint(1) NOT NULL DEFAULT 0 COMMENT '默认 0 否 1是',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_bin COMMENT = '地址簿' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of address_book
-- ----------------------------
INSERT INTO `address_book` VALUES (1, 1, '爪爪', '0', '13645678897', '61', '陕西省', '6101', '西安市', '610113', '雁塔区', '丈八六路一号', '3', 1);
INSERT INTO `address_book` VALUES (2, 1, '爪爪', '0', '13596976364', '11', '北京市', '1101', '市辖区', '110102', '西城区', '北京大学', '1', 0);

-- ----------------------------
-- Table structure for category
-- ----------------------------
DROP TABLE IF EXISTS `category`;
CREATE TABLE `category`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `type` int(11) NULL DEFAULT NULL COMMENT '类型   1 菜品分类 2 套餐分类',
  `name` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '分类名称',
  `sort` int(11) NOT NULL DEFAULT 0 COMMENT '顺序',
  `status` int(11) NULL DEFAULT NULL COMMENT '分类状态 0:禁用，1:启用',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
  `create_user` bigint(20) NULL DEFAULT NULL COMMENT '创建人',
  `update_user` bigint(20) NULL DEFAULT NULL COMMENT '修改人',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `idx_category_name`(`name`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 29 CHARACTER SET = utf8 COLLATE = utf8_bin COMMENT = '菜品及套餐分类' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of category
-- ----------------------------
INSERT INTO `category` VALUES (11, 1, '酒水饮料', 13, 1, '2022-06-09 22:09:18', '2023-12-10 18:32:29', 1, 1);
INSERT INTO `category` VALUES (12, 1, '传统主食', 12, 1, '2022-06-09 22:09:32', '2023-12-10 18:32:25', 1, 1);
INSERT INTO `category` VALUES (13, 2, '人气套餐', 1, 1, '2022-06-09 22:11:38', '2023-12-10 18:31:36', 1, 1);
INSERT INTO `category` VALUES (15, 2, '商务套餐', 2, 1, '2022-06-09 22:14:10', '2023-12-10 18:31:45', 1, 1);
INSERT INTO `category` VALUES (16, 1, '蜀味烤鱼', 6, 1, '2022-06-09 22:15:37', '2023-12-10 18:32:00', 1, 1);
INSERT INTO `category` VALUES (17, 1, '蜀味牛蛙', 10, 1, '2022-06-09 22:16:14', '2023-12-10 18:12:21', 1, 1);
INSERT INTO `category` VALUES (18, 1, '特色蒸菜', 9, 1, '2022-06-09 22:17:42', '2023-12-10 18:32:12', 1, 1);
INSERT INTO `category` VALUES (19, 1, '新鲜时蔬', 7, 1, '2022-06-09 22:18:12', '2022-06-09 22:18:28', 1, 1);
INSERT INTO `category` VALUES (20, 1, '水煮鱼', 8, 1, '2022-06-09 22:22:29', '2022-06-09 22:23:45', 1, 1);
INSERT INTO `category` VALUES (21, 1, '汤类', 11, 1, '2022-06-10 10:51:47', '2022-06-10 10:51:47', 1, 1);
INSERT INTO `category` VALUES (22, 1, '霸气午餐', 6, 1, '2023-12-07 22:04:39', '2023-12-07 22:05:20', 1, 1);
INSERT INTO `category` VALUES (23, 1, '黄金午餐', 4, 1, '2023-12-07 22:06:33', '2023-12-10 18:31:32', 1, 1);
INSERT INTO `category` VALUES (24, 1, '素拼', 5, 1, '2023-12-08 14:37:54', '2023-12-10 18:31:07', 1, 1);
INSERT INTO `category` VALUES (25, 2, '汉堡套餐', 3, 1, '2023-12-10 18:28:09', '2024-03-28 13:32:10', 1, 1);
INSERT INTO `category` VALUES (28, 1, '爪爪烤肉', 1, 1, '2023-12-22 11:17:56', '2023-12-22 11:17:59', 1, 1);

-- ----------------------------
-- Table structure for dish
-- ----------------------------
DROP TABLE IF EXISTS `dish`;
CREATE TABLE `dish`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `name` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '菜品名称',
  `category_id` bigint(20) NOT NULL COMMENT '菜品分类id',
  `price` decimal(10, 2) NULL DEFAULT NULL COMMENT '菜品价格',
  `image` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '图片',
  `description` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '描述信息',
  `status` int(11) NULL DEFAULT 1 COMMENT '0 停售 1 起售',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
  `create_user` bigint(20) NULL DEFAULT NULL COMMENT '创建人',
  `update_user` bigint(20) NULL DEFAULT NULL COMMENT '修改人',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `idx_dish_name`(`name`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 88 CHARACTER SET = utf8 COLLATE = utf8_bin COMMENT = '菜品' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of dish
-- ----------------------------
INSERT INTO `dish` VALUES (46, '王老吉', 11, 6.00, 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/78f9bef7-d1f6-4bc9-95f8-eb2b7571f049.png', '怕上火喝王老吉', 1, '2022-06-09 22:40:47', '2023-12-03 13:05:28', 1, 1);
INSERT INTO `dish` VALUES (48, '雪花啤酒', 11, 4.00, 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/1184d249-eb14-42f3-990d-24fbae149e4d.png', '经典雪花啤酒(罐装)', 1, '2022-06-10 09:22:54', '2023-12-03 13:25:34', 1, 1);
INSERT INTO `dish` VALUES (49, '米饭', 12, 6.00, 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/c4195594-ae65-4091-847d-12360f0fbb51.png', '精选五常大米', 1, '2022-06-10 09:30:17', '2023-12-03 13:04:37', 1, 1);
INSERT INTO `dish` VALUES (53, '蜀味水煮草鱼', 20, 38.00, 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/0b04f37a-092b-4462-afbc-c43afab875c2.png', '原料：草鱼，汤', 1, '2022-06-10 09:48:37', '2023-12-03 13:04:24', 1, 1);
INSERT INTO `dish` VALUES (55, '蒜蓉娃娃菜', 19, 18.00, 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/03826012-bcfe-4e2a-9a18-783f8bb0c638.png', '原料：蒜，娃娃菜', 1, '2022-06-10 09:53:37', '2023-12-03 13:04:06', 1, 1);
INSERT INTO `dish` VALUES (58, '清蒸鲈鱼', 18, 98.00, 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/087e2bbd-82ad-4ccd-94bb-f06612770ff0.png', '原料：鲈鱼', 1, '2022-06-10 10:12:28', '2023-12-03 13:03:38', 1, 1);
INSERT INTO `dish` VALUES (59, '东坡肘子', 18, 138.00, 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/02a03c59-2e8f-479a-9e6e-952aff6e4418.png', '原料：猪肘棒', 1, '2022-06-10 10:24:03', '2023-12-03 13:03:23', 1, 1);
INSERT INTO `dish` VALUES (61, '剁椒鱼头', 18, 66.00, 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/9082a315-e171-4243-83a9-9637aa269473.png', '原料：鲢鱼，剁椒', 1, '2022-06-10 10:28:54', '2023-12-03 13:03:02', 1, 1);
INSERT INTO `dish` VALUES (62, '金汤酸菜牛蛙', 17, 88.00, 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/7bf704b8-246f-4cda-ac58-5be4515f84ac.png', '原料：鲜活牛蛙，酸菜', 1, '2022-06-10 10:33:05', '2023-12-03 13:02:48', 1, 1);
INSERT INTO `dish` VALUES (64, '馋嘴牛蛙', 17, 88.00, 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/42e122db-6a6b-40e6-b1e5-692abaa832ba.png', '配料：鲜活牛蛙，丝瓜，黄豆芽', 1, '2022-06-10 10:37:52', '2023-12-03 13:02:29', 1, 1);
INSERT INTO `dish` VALUES (65, '草鱼2斤', 16, 68.00, 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/e4b677b8-e53c-4ecb-9e7b-8915b3004f9e.png', '原料：草鱼，黄豆芽，莲藕', 1, '2022-06-10 10:41:08', '2023-12-03 13:01:44', 1, 1);
INSERT INTO `dish` VALUES (66, '江团鱼2斤', 16, 119.00, 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/7611e5d1-7ed0-4aee-bb99-eec5a5fb1c0b.png', '配料：江团鱼，黄豆芽，莲藕', 1, '2022-06-10 10:42:42', '2023-12-03 13:01:23', 1, 1);
INSERT INTO `dish` VALUES (67, '鮰鱼2斤', 16, 72.00, 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/fa45d23b-dcc5-44c9-86ff-f70cfdb7af1d.png', '原料：鮰鱼，黄豆芽，莲藕', 1, '2022-06-10 10:43:56', '2023-12-03 13:01:10', 1, 1);
INSERT INTO `dish` VALUES (68, '鸡蛋汤', 21, 4.00, 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/6edd0ffc-0496-44da-af21-b9c9a8fe1975.png', '配料：鸡蛋，紫菜', 1, '2022-06-10 10:54:25', '2023-12-03 13:00:31', 1, 1);
INSERT INTO `dish` VALUES (69, '平菇豆腐', 21, 6.00, 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/8b959d8a-e0b3-4f6a-a3e8-23ec6042f2e1.png', '配料：豆腐，平菇', 1, '2022-06-10 10:55:02', '2023-12-03 13:00:13', 1, 1);
INSERT INTO `dish` VALUES (71, '北冰洋', 11, 3.50, 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/50b1e04f-1617-40b6-ac9a-1b366fa7488d.png', '老北京汽水儿~', 1, '2023-08-18 08:33:12', '2023-12-03 12:12:55', 1, 1);
INSERT INTO `dish` VALUES (72, '馒头', 12, 2.00, 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/d53f04b2-d908-4bd5-a08f-f307ece2b578.png', '经典大馒头', 1, '2023-12-03 13:07:03', '2023-12-10 18:12:06', 1, 1);
INSERT INTO `dish` VALUES (73, '荔枝烤鱼', 22, 168.00, 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/31db8ee3-d49e-4f23-8b6e-fb536210974f.png', '鱼酷黄金荔枝烤鱼', 1, '2023-12-07 22:45:59', '2023-12-07 22:56:08', 1, 1);
INSERT INTO `dish` VALUES (74, '素拼菜花', 24, 6.00, 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/494264c7-9325-4ace-ad88-0eb7dcd44698.png', '菜花', 1, '2023-12-10 13:17:12', '2023-12-10 18:10:50', 1, 1);
INSERT INTO `dish` VALUES (75, '凉拌娃娃菜', 24, 10.00, 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/67755952-f475-4e12-adbb-73b63d22fcd1.png', '娃娃菜凉拌素拼', 1, '2023-12-10 18:12:01', '2023-12-10 18:12:04', 1, 1);
INSERT INTO `dish` VALUES (76, '巨无霸汉堡', 23, 29.90, 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/7eda84b5-5612-46d5-a8be-62d1e86d1b0c.jpg', '四拼巨无霸套餐，限量29.9起', 1, '2023-12-10 18:21:20', '2023-12-10 18:22:41', 1, 1);
INSERT INTO `dish` VALUES (77, '冰柠可乐', 23, 3.00, 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/ccd39e8b-256d-4903-9f6a-6fa6c5a0aac4.jpg', '可乐', 1, '2023-12-10 18:24:58', '2023-12-10 18:26:03', 1, 1);
INSERT INTO `dish` VALUES (78, '炸鸡', 23, 20.00, 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/f7da025d-dece-4688-99e8-bdad4b7902ad.jpg', '炸鸡', 1, '2023-12-10 18:25:21', '2023-12-10 18:26:05', 1, 1);
INSERT INTO `dish` VALUES (80, '双排鸡柳汉堡', 23, 7.90, 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/84e3e2f3-f916-4a35-a3f5-388c6f3e142e.jpg', '汉堡', 1, '2023-12-10 18:26:00', '2023-12-10 18:26:07', 1, 1);
INSERT INTO `dish` VALUES (81, '薯条', 23, 3.90, 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/419f7454-8e66-42c5-926d-c78e51ceb3a5.jpg', '炸薯条', 1, '2023-12-10 18:26:31', '2023-12-15 09:19:40', 1, 1);
INSERT INTO `dish` VALUES (82, '烤鸡翅', 28, 10.99, 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/71c92db3-8d75-42c5-b623-ff4d5d60da04.jpg', '烤只因翅', 1, '2023-12-22 11:18:43', '2023-12-22 11:18:46', 1, 1);
INSERT INTO `dish` VALUES (83, '一把烤肠', 28, 6.99, 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/06d15d1c-9586-4838-a932-e560be9840bc.png', '烤肠~', 1, '2023-12-22 11:19:15', '2023-12-22 11:19:18', 1, 1);
INSERT INTO `dish` VALUES (84, '烤面包片', 28, 5.99, 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/34a408db-1c0c-4e1f-af34-77f14a2bf940.jpg', '面包片', 1, '2023-12-22 11:19:43', '2023-12-22 11:19:46', 1, 1);
INSERT INTO `dish` VALUES (85, '烤牛肉', 28, 19.99, 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/ba3b9095-9e25-4e9e-a7d5-5c7d29419b8e.png', '牛肉~~~', 1, '2023-12-22 11:20:08', '2023-12-22 11:20:11', 1, 1);
INSERT INTO `dish` VALUES (86, '烤五花肉', 28, 20.99, 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/e74428e1-757d-4e50-adfa-f5680d2c95e6.jpg', '五花肉~', 1, '2023-12-22 11:20:34', '2023-12-22 11:30:06', 1, 1);
INSERT INTO `dish` VALUES (87, '烤肉筋', 28, 19.99, 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/7799f271-9bd0-4254-b53e-436491ee6f62.png', '肉筋', 1, '2023-12-22 11:20:59', '2023-12-22 11:23:06', 1, 1);

-- ----------------------------
-- Table structure for dish_flavor
-- ----------------------------
DROP TABLE IF EXISTS `dish_flavor`;
CREATE TABLE `dish_flavor`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `dish_id` bigint(20) NOT NULL COMMENT '菜品',
  `name` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '口味名称',
  `value` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '口味数据list',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 131 CHARACTER SET = utf8 COLLATE = utf8_bin COMMENT = '菜品口味关系表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of dish_flavor
-- ----------------------------
INSERT INTO `dish_flavor` VALUES (40, 10, '甜味', '[\"无糖\",\"少糖\",\"半糖\",\"多糖\",\"全糖\"]');
INSERT INTO `dish_flavor` VALUES (41, 7, '忌口', '[\"不要葱\",\"不要蒜\",\"不要香菜\",\"不要辣\"]');
INSERT INTO `dish_flavor` VALUES (42, 7, '温度', '[\"热饮\",\"常温\",\"去冰\",\"少冰\",\"多冰\"]');
INSERT INTO `dish_flavor` VALUES (45, 6, '忌口', '[\"不要葱\",\"不要蒜\",\"不要香菜\",\"不要辣\"]');
INSERT INTO `dish_flavor` VALUES (46, 6, '辣度', '[\"不辣\",\"微辣\",\"中辣\",\"重辣\"]');
INSERT INTO `dish_flavor` VALUES (47, 5, '辣度', '[\"不辣\",\"微辣\",\"中辣\",\"重辣\"]');
INSERT INTO `dish_flavor` VALUES (48, 5, '甜味', '[\"无糖\",\"少糖\",\"半糖\",\"多糖\",\"全糖\"]');
INSERT INTO `dish_flavor` VALUES (49, 2, '甜味', '[\"无糖\",\"少糖\",\"半糖\",\"多糖\",\"全糖\"]');
INSERT INTO `dish_flavor` VALUES (50, 4, '甜味', '[\"无糖\",\"少糖\",\"半糖\",\"多糖\",\"全糖\"]');
INSERT INTO `dish_flavor` VALUES (51, 3, '甜味', '[\"无糖\",\"少糖\",\"半糖\",\"多糖\",\"全糖\"]');
INSERT INTO `dish_flavor` VALUES (52, 3, '忌口', '[\"不要葱\",\"不要蒜\",\"不要香菜\",\"不要辣\"]');
INSERT INTO `dish_flavor` VALUES (109, 71, '温度', '[\"热饮\",\"常温\",\"去冰\",\"少冰\",\"多冰\"]');
INSERT INTO `dish_flavor` VALUES (110, 67, '辣度', '[\"不辣\",\"微辣\",\"中辣\",\"重辣\"]');
INSERT INTO `dish_flavor` VALUES (111, 66, '辣度', '[\"不辣\",\"微辣\",\"中辣\",\"重辣\"]');
INSERT INTO `dish_flavor` VALUES (112, 65, '辣度', '[\"不辣\",\"微辣\",\"中辣\",\"重辣\"]');
INSERT INTO `dish_flavor` VALUES (113, 53, '忌口', '[\"不要葱\",\"不要蒜\",\"不要香菜\",\"不要辣\"]');
INSERT INTO `dish_flavor` VALUES (114, 53, '辣度', '[\"不辣\",\"微辣\",\"中辣\",\"重辣\"]');
INSERT INTO `dish_flavor` VALUES (115, 46, '温度', '[\"热饮\",\"常温\",\"去冰\",\"少冰\",\"多冰\"]');
INSERT INTO `dish_flavor` VALUES (116, 48, '温度', '[\"热饮\",\"常温\",\"去冰\",\"少冰\",\"多冰\"]');
INSERT INTO `dish_flavor` VALUES (121, 74, '辣度', '[\"不辣\",\"微辣\",\"中辣\",\"重辣\"]');
INSERT INTO `dish_flavor` VALUES (122, 75, '辣度', '[\"不辣\",\"微辣\",\"中辣\",\"重辣\"]');
INSERT INTO `dish_flavor` VALUES (125, 76, '忌口', '[\"不要葱\",\"不要蒜\",\"不要香菜\",\"不要辣\"]');
INSERT INTO `dish_flavor` VALUES (126, 77, '温度', '[\"热饮\",\"常温\",\"去冰\",\"少冰\",\"多冰\"]');
INSERT INTO `dish_flavor` VALUES (127, 82, '辣度', '[\"不辣\",\"微辣\",\"中辣\",\"重辣\"]');
INSERT INTO `dish_flavor` VALUES (128, 87, '辣度', '[\"不辣\",\"微辣\",\"中辣\",\"重辣\"]');
INSERT INTO `dish_flavor` VALUES (129, 86, '辣度', '[\"不辣\",\"微辣\",\"中辣\",\"重辣\"]');
INSERT INTO `dish_flavor` VALUES (130, 86, '忌口', '[\"不要葱\",\"不要蒜\",\"不要香菜\",\"不要辣\"]');

-- ----------------------------
-- Table structure for employee
-- ----------------------------
DROP TABLE IF EXISTS `employee`;
CREATE TABLE `employee`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `name` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '姓名',
  `username` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '用户名',
  `password` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '密码',
  `phone` varchar(11) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '手机号',
  `sex` varchar(2) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '性别',
  `id_number` varchar(18) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '身份证号',
  `status` int(11) NOT NULL DEFAULT 1 COMMENT '状态 0:禁用，1:启用',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
  `create_user` bigint(20) NULL DEFAULT NULL COMMENT '创建人',
  `update_user` bigint(20) NULL DEFAULT NULL COMMENT '修改人',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `idx_username`(`username`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 22 CHARACTER SET = utf8 COLLATE = utf8_bin COMMENT = '员工信息' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of employee
-- ----------------------------
INSERT INTO `employee` VALUES (1, '管理员', 'admin', 'e10adc3949ba59abbe56e057f20f883e', '13312347894', '1', '222333444555666111', 1, '2022-02-15 15:51:20', '2023-08-03 19:53:31', 1, 1);
INSERT INTO `employee` VALUES (5, '张三', 'zhangsan', 'e10adc3949ba59abbe56e057f20f883e', '13571674355', '1', '1122334455', 1, '2023-08-01 22:27:40', '2023-12-05 15:35:44', 10, 16);
INSERT INTO `employee` VALUES (6, '李四', 'lisi', 'e10adc3949ba59abbe56e057f20f883e', '13212345678', '1', '111222333444555666', 1, '2023-08-01 22:29:29', '2023-08-01 22:29:29', 10, 10);
INSERT INTO `employee` VALUES (12, '王五', 'wangwu', 'e10adc3949ba59abbe56e057f20f883e', '13597648826', '1', '112233445566778899', 1, '2023-08-02 08:27:46', '2023-08-02 08:27:46', 1, 1);
INSERT INTO `employee` VALUES (14, '庹梦瑶', '001', 'e10adc3949ba59abbe56e057f20f883e', '13312347894', '1', '222333444555666111', 1, '2023-08-02 19:31:44', '2023-08-03 19:56:05', 1, 1);
INSERT INTO `employee` VALUES (15, '庹梦曦', '002', 'e10adc3949ba59abbe56e057f20f883e', '13595621234', '0', '610721200506090321', 1, '2023-08-03 19:19:49', '2023-08-16 20:04:54', 1, 1);
INSERT INTO `employee` VALUES (16, '爪爪', 'test', 'e10adc3949ba59abbe56e057f20f883e', '13696316453', '1', '610721200103090693', 0, '2023-08-22 15:43:41', '2023-12-07 15:03:40', 1, 1);
INSERT INTO `employee` VALUES (17, 'zhuazhua', 'test002', 'e10adc3949ba59abbe56e057f20f883e', '13211111111', '1', '111111111222222222', 1, '2023-08-27 20:49:12', '2023-08-27 20:49:12', 1, 1);
INSERT INTO `employee` VALUES (19, '爪爪1', 'test1', 'e10adc3949ba59abbe56e057f20f883e', '15891678338', '1', '610721200309060693', 1, '2023-12-07 16:31:03', '2023-12-07 21:41:12', 1, 1);
INSERT INTO `employee` VALUES (20, '爪爪2', '123456', 'e10adc3949ba59abbe56e057f20f883e', '15891683888', '1', '610781200609230692', 0, '2023-12-08 14:28:28', '2023-12-08 14:30:14', 1, 1);
INSERT INTO `employee` VALUES (21, 'test', '123', 'e10adc3949ba59abbe56e057f20f883e', '13571678355', '1', '610721200110260912', 1, '2023-12-15 09:50:47', '2023-12-15 09:50:47', 1, 1);

-- ----------------------------
-- Table structure for order_detail
-- ----------------------------
DROP TABLE IF EXISTS `order_detail`;
CREATE TABLE `order_detail`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `name` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '名字',
  `image` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '图片',
  `order_id` bigint(20) NOT NULL COMMENT '订单id',
  `dish_id` bigint(20) NULL DEFAULT NULL COMMENT '菜品id',
  `setmeal_id` bigint(20) NULL DEFAULT NULL COMMENT '套餐id',
  `dish_flavor` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '口味',
  `number` int(11) NOT NULL DEFAULT 1 COMMENT '数量',
  `amount` decimal(10, 2) NOT NULL COMMENT '金额',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 222 CHARACTER SET = utf8 COLLATE = utf8_bin COMMENT = '订单明细表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of order_detail
-- ----------------------------
INSERT INTO `order_detail` VALUES (1, '金汤酸菜牛蛙', 'https://sky-itcast.oss-cn-beijing.aliyuncs.com/7694a5d8-7938-4e9d-8b9e-2075983a2e38.png', 1, 62, NULL, NULL, 1, 88.00);
INSERT INTO `order_detail` VALUES (2, '馋嘴牛蛙', 'https://sky-itcast.oss-cn-beijing.aliyuncs.com/7a55b845-1f2b-41fa-9486-76d187ee9ee1.png', 1, 64, NULL, NULL, 1, 88.00);
INSERT INTO `order_detail` VALUES (3, '北冰洋', 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/50b1e04f-1617-40b6-ac9a-1b366fa7488d.png', 1, 71, NULL, '去冰', 1, 3.50);
INSERT INTO `order_detail` VALUES (4, '馋嘴牛蛙', 'https://sky-itcast.oss-cn-beijing.aliyuncs.com/7a55b845-1f2b-41fa-9486-76d187ee9ee1.png', 2, 64, NULL, NULL, 1, 88.00);
INSERT INTO `order_detail` VALUES (5, '北冰洋', 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/50b1e04f-1617-40b6-ac9a-1b366fa7488d.png', 3, 71, NULL, '去冰', 1, 3.50);
INSERT INTO `order_detail` VALUES (6, '馋嘴牛蛙', 'https://sky-itcast.oss-cn-beijing.aliyuncs.com/7a55b845-1f2b-41fa-9486-76d187ee9ee1.png', 4, 64, NULL, NULL, 1, 88.00);
INSERT INTO `order_detail` VALUES (7, '金汤酸菜牛蛙', 'https://sky-itcast.oss-cn-beijing.aliyuncs.com/7694a5d8-7938-4e9d-8b9e-2075983a2e38.png', 4, 62, NULL, NULL, 1, 88.00);
INSERT INTO `order_detail` VALUES (8, '金汤酸菜牛蛙', 'https://sky-itcast.oss-cn-beijing.aliyuncs.com/7694a5d8-7938-4e9d-8b9e-2075983a2e38.png', 5, 62, NULL, NULL, 1, 88.00);
INSERT INTO `order_detail` VALUES (9, '金汤酸菜牛蛙', 'https://sky-itcast.oss-cn-beijing.aliyuncs.com/7694a5d8-7938-4e9d-8b9e-2075983a2e38.png', 6, 62, NULL, NULL, 1, 88.00);
INSERT INTO `order_detail` VALUES (10, '金汤酸菜牛蛙', 'https://sky-itcast.oss-cn-beijing.aliyuncs.com/7694a5d8-7938-4e9d-8b9e-2075983a2e38.png', 7, 62, NULL, NULL, 1, 88.00);
INSERT INTO `order_detail` VALUES (11, '金汤酸菜牛蛙', 'https://sky-itcast.oss-cn-beijing.aliyuncs.com/7694a5d8-7938-4e9d-8b9e-2075983a2e38.png', 8, 62, NULL, NULL, 1, 88.00);
INSERT INTO `order_detail` VALUES (12, '金汤酸菜牛蛙', 'https://sky-itcast.oss-cn-beijing.aliyuncs.com/7694a5d8-7938-4e9d-8b9e-2075983a2e38.png', 9, 62, NULL, NULL, 1, 88.00);
INSERT INTO `order_detail` VALUES (13, '金汤酸菜牛蛙', 'https://sky-itcast.oss-cn-beijing.aliyuncs.com/7694a5d8-7938-4e9d-8b9e-2075983a2e38.png', 10, 62, NULL, NULL, 1, 88.00);
INSERT INTO `order_detail` VALUES (14, '金汤酸菜牛蛙', 'https://sky-itcast.oss-cn-beijing.aliyuncs.com/7694a5d8-7938-4e9d-8b9e-2075983a2e38.png', 11, 62, NULL, NULL, 1, 88.00);
INSERT INTO `order_detail` VALUES (15, '金汤酸菜牛蛙', 'https://sky-itcast.oss-cn-beijing.aliyuncs.com/7694a5d8-7938-4e9d-8b9e-2075983a2e38.png', 12, 62, NULL, NULL, 2, 88.00);
INSERT INTO `order_detail` VALUES (16, '金汤酸菜牛蛙', 'https://sky-itcast.oss-cn-beijing.aliyuncs.com/7694a5d8-7938-4e9d-8b9e-2075983a2e38.png', 13, 62, NULL, NULL, 1, 88.00);
INSERT INTO `order_detail` VALUES (17, '金汤酸菜牛蛙', 'https://sky-itcast.oss-cn-beijing.aliyuncs.com/7694a5d8-7938-4e9d-8b9e-2075983a2e38.png', 14, 62, NULL, NULL, 1, 88.00);
INSERT INTO `order_detail` VALUES (18, '金汤酸菜牛蛙', 'https://sky-itcast.oss-cn-beijing.aliyuncs.com/7694a5d8-7938-4e9d-8b9e-2075983a2e38.png', 15, 62, NULL, NULL, 1, 88.00);
INSERT INTO `order_detail` VALUES (19, '金汤酸菜牛蛙', 'https://sky-itcast.oss-cn-beijing.aliyuncs.com/7694a5d8-7938-4e9d-8b9e-2075983a2e38.png', 16, 62, NULL, NULL, 1, 88.00);
INSERT INTO `order_detail` VALUES (20, '馋嘴牛蛙', 'https://sky-itcast.oss-cn-beijing.aliyuncs.com/7a55b845-1f2b-41fa-9486-76d187ee9ee1.png', 17, 64, NULL, NULL, 1, 88.00);
INSERT INTO `order_detail` VALUES (21, '金汤酸菜牛蛙', 'https://sky-itcast.oss-cn-beijing.aliyuncs.com/7694a5d8-7938-4e9d-8b9e-2075983a2e38.png', 18, 62, NULL, NULL, 1, 88.00);
INSERT INTO `order_detail` VALUES (22, '金汤酸菜牛蛙', 'https://sky-itcast.oss-cn-beijing.aliyuncs.com/7694a5d8-7938-4e9d-8b9e-2075983a2e38.png', 19, 62, NULL, NULL, 1, 88.00);
INSERT INTO `order_detail` VALUES (23, '金汤酸菜牛蛙', 'https://sky-itcast.oss-cn-beijing.aliyuncs.com/7694a5d8-7938-4e9d-8b9e-2075983a2e38.png', 20, 62, NULL, NULL, 1, 88.00);
INSERT INTO `order_detail` VALUES (24, '金汤酸菜牛蛙', 'https://sky-itcast.oss-cn-beijing.aliyuncs.com/7694a5d8-7938-4e9d-8b9e-2075983a2e38.png', 21, 62, NULL, NULL, 1, 88.00);
INSERT INTO `order_detail` VALUES (25, '金汤酸菜牛蛙', 'https://sky-itcast.oss-cn-beijing.aliyuncs.com/7694a5d8-7938-4e9d-8b9e-2075983a2e38.png', 22, 62, NULL, NULL, 1, 88.00);
INSERT INTO `order_detail` VALUES (26, '馋嘴牛蛙', 'https://sky-itcast.oss-cn-beijing.aliyuncs.com/7a55b845-1f2b-41fa-9486-76d187ee9ee1.png', 23, 64, NULL, NULL, 1, 88.00);
INSERT INTO `order_detail` VALUES (27, '人气套餐', 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/532eea35-dce8-412b-a062-97c084885545.png', 24, NULL, 6, NULL, 1, 399.00);
INSERT INTO `order_detail` VALUES (28, '商务套餐', 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/dc03fad5-0b4d-4264-8223-0ca700ad0dfd.png', 25, NULL, 5, NULL, 1, 200.00);
INSERT INTO `order_detail` VALUES (29, '金汤酸菜牛蛙', 'https://sky-itcast.oss-cn-beijing.aliyuncs.com/7694a5d8-7938-4e9d-8b9e-2075983a2e38.png', 26, 62, NULL, NULL, 1, 88.00);
INSERT INTO `order_detail` VALUES (30, '馋嘴牛蛙', 'https://sky-itcast.oss-cn-beijing.aliyuncs.com/7a55b845-1f2b-41fa-9486-76d187ee9ee1.png', 27, 64, NULL, NULL, 1, 88.00);
INSERT INTO `order_detail` VALUES (31, '北冰洋', 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/50b1e04f-1617-40b6-ac9a-1b366fa7488d.png', 28, 71, NULL, '去冰', 1, 3.50);
INSERT INTO `order_detail` VALUES (32, '馋嘴牛蛙', 'https://sky-itcast.oss-cn-beijing.aliyuncs.com/7a55b845-1f2b-41fa-9486-76d187ee9ee1.png', 29, 64, NULL, NULL, 1, 88.00);
INSERT INTO `order_detail` VALUES (33, '金汤酸菜牛蛙', 'https://sky-itcast.oss-cn-beijing.aliyuncs.com/7694a5d8-7938-4e9d-8b9e-2075983a2e38.png', 29, 62, NULL, NULL, 1, 88.00);
INSERT INTO `order_detail` VALUES (34, '北冰洋', 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/50b1e04f-1617-40b6-ac9a-1b366fa7488d.png', 30, 71, NULL, '去冰', 1, 3.50);
INSERT INTO `order_detail` VALUES (35, '馋嘴牛蛙', 'https://sky-itcast.oss-cn-beijing.aliyuncs.com/7a55b845-1f2b-41fa-9486-76d187ee9ee1.png', 30, 64, NULL, NULL, 1, 88.00);
INSERT INTO `order_detail` VALUES (36, '馋嘴牛蛙', 'https://sky-itcast.oss-cn-beijing.aliyuncs.com/7a55b845-1f2b-41fa-9486-76d187ee9ee1.png', 31, 64, NULL, NULL, 1, 88.00);
INSERT INTO `order_detail` VALUES (37, '馋嘴牛蛙', 'https://sky-itcast.oss-cn-beijing.aliyuncs.com/7a55b845-1f2b-41fa-9486-76d187ee9ee1.png', 32, 64, NULL, NULL, 1, 88.00);
INSERT INTO `order_detail` VALUES (38, '馋嘴牛蛙', 'https://sky-itcast.oss-cn-beijing.aliyuncs.com/7a55b845-1f2b-41fa-9486-76d187ee9ee1.png', 33, 64, NULL, NULL, 2, 88.00);
INSERT INTO `order_detail` VALUES (39, '金汤酸菜牛蛙', 'https://sky-itcast.oss-cn-beijing.aliyuncs.com/7694a5d8-7938-4e9d-8b9e-2075983a2e38.png', 34, 62, NULL, NULL, 1, 88.00);
INSERT INTO `order_detail` VALUES (40, '馋嘴牛蛙', 'https://sky-itcast.oss-cn-beijing.aliyuncs.com/7a55b845-1f2b-41fa-9486-76d187ee9ee1.png', 35, 64, NULL, NULL, 1, 88.00);
INSERT INTO `order_detail` VALUES (41, '金汤酸菜牛蛙', 'https://sky-itcast.oss-cn-beijing.aliyuncs.com/7694a5d8-7938-4e9d-8b9e-2075983a2e38.png', 36, 62, NULL, NULL, 1, 88.00);
INSERT INTO `order_detail` VALUES (42, '金汤酸菜牛蛙', 'https://sky-itcast.oss-cn-beijing.aliyuncs.com/7694a5d8-7938-4e9d-8b9e-2075983a2e38.png', 37, 62, NULL, NULL, 2, 88.00);
INSERT INTO `order_detail` VALUES (43, '金汤酸菜牛蛙', 'https://sky-itcast.oss-cn-beijing.aliyuncs.com/7694a5d8-7938-4e9d-8b9e-2075983a2e38.png', 38, 62, NULL, NULL, 2, 88.00);
INSERT INTO `order_detail` VALUES (44, '金汤酸菜牛蛙', 'https://sky-itcast.oss-cn-beijing.aliyuncs.com/7694a5d8-7938-4e9d-8b9e-2075983a2e38.png', 39, 62, NULL, NULL, 2, 88.00);
INSERT INTO `order_detail` VALUES (45, '金汤酸菜牛蛙', 'https://sky-itcast.oss-cn-beijing.aliyuncs.com/7694a5d8-7938-4e9d-8b9e-2075983a2e38.png', 40, 62, NULL, NULL, 2, 88.00);
INSERT INTO `order_detail` VALUES (46, '馋嘴牛蛙', 'https://sky-itcast.oss-cn-beijing.aliyuncs.com/7a55b845-1f2b-41fa-9486-76d187ee9ee1.png', 40, 64, NULL, NULL, 1, 88.00);
INSERT INTO `order_detail` VALUES (47, '金汤酸菜牛蛙', 'https://sky-itcast.oss-cn-beijing.aliyuncs.com/7694a5d8-7938-4e9d-8b9e-2075983a2e38.png', 41, 62, NULL, NULL, 2, 88.00);
INSERT INTO `order_detail` VALUES (48, '馋嘴牛蛙', 'https://sky-itcast.oss-cn-beijing.aliyuncs.com/7a55b845-1f2b-41fa-9486-76d187ee9ee1.png', 41, 64, NULL, NULL, 1, 88.00);
INSERT INTO `order_detail` VALUES (49, '金汤酸菜牛蛙', 'https://sky-itcast.oss-cn-beijing.aliyuncs.com/7694a5d8-7938-4e9d-8b9e-2075983a2e38.png', 42, 62, NULL, NULL, 2, 88.00);
INSERT INTO `order_detail` VALUES (50, '馋嘴牛蛙', 'https://sky-itcast.oss-cn-beijing.aliyuncs.com/7a55b845-1f2b-41fa-9486-76d187ee9ee1.png', 42, 64, NULL, NULL, 1, 88.00);
INSERT INTO `order_detail` VALUES (51, '金汤酸菜牛蛙', 'https://sky-itcast.oss-cn-beijing.aliyuncs.com/7694a5d8-7938-4e9d-8b9e-2075983a2e38.png', 43, 62, NULL, NULL, 2, 88.00);
INSERT INTO `order_detail` VALUES (52, '馋嘴牛蛙', 'https://sky-itcast.oss-cn-beijing.aliyuncs.com/7a55b845-1f2b-41fa-9486-76d187ee9ee1.png', 43, 64, NULL, NULL, 1, 88.00);
INSERT INTO `order_detail` VALUES (53, '金汤酸菜牛蛙', 'https://sky-itcast.oss-cn-beijing.aliyuncs.com/7694a5d8-7938-4e9d-8b9e-2075983a2e38.png', 44, 62, NULL, NULL, 2, 88.00);
INSERT INTO `order_detail` VALUES (54, '馋嘴牛蛙', 'https://sky-itcast.oss-cn-beijing.aliyuncs.com/7a55b845-1f2b-41fa-9486-76d187ee9ee1.png', 44, 64, NULL, NULL, 1, 88.00);
INSERT INTO `order_detail` VALUES (55, '金汤酸菜牛蛙', 'https://sky-itcast.oss-cn-beijing.aliyuncs.com/7694a5d8-7938-4e9d-8b9e-2075983a2e38.png', 45, 62, NULL, NULL, 2, 88.00);
INSERT INTO `order_detail` VALUES (56, '馋嘴牛蛙', 'https://sky-itcast.oss-cn-beijing.aliyuncs.com/7a55b845-1f2b-41fa-9486-76d187ee9ee1.png', 45, 64, NULL, NULL, 1, 88.00);
INSERT INTO `order_detail` VALUES (57, '金汤酸菜牛蛙', 'https://sky-itcast.oss-cn-beijing.aliyuncs.com/7694a5d8-7938-4e9d-8b9e-2075983a2e38.png', 46, 62, NULL, NULL, 1, 88.00);
INSERT INTO `order_detail` VALUES (58, '金汤酸菜牛蛙', 'https://sky-itcast.oss-cn-beijing.aliyuncs.com/7694a5d8-7938-4e9d-8b9e-2075983a2e38.png', 47, 62, NULL, NULL, 2, 88.00);
INSERT INTO `order_detail` VALUES (59, '馋嘴牛蛙', 'https://sky-itcast.oss-cn-beijing.aliyuncs.com/7a55b845-1f2b-41fa-9486-76d187ee9ee1.png', 47, 64, NULL, NULL, 1, 88.00);
INSERT INTO `order_detail` VALUES (60, '蒜蓉娃娃菜', 'https://sky-itcast.oss-cn-beijing.aliyuncs.com/4879ed66-3860-4b28-ba14-306ac025fdec.png', 48, 55, NULL, NULL, 1, 18.00);
INSERT INTO `order_detail` VALUES (61, '剁椒鱼头', 'https://sky-itcast.oss-cn-beijing.aliyuncs.com/13da832f-ef2c-484d-8370-5934a1045a06.png', 49, 61, NULL, NULL, 1, 66.00);
INSERT INTO `order_detail` VALUES (62, '东坡肘子', 'https://sky-itcast.oss-cn-beijing.aliyuncs.com/a80a4b8c-c93e-4f43-ac8a-856b0d5cc451.png', 49, 59, NULL, NULL, 1, 138.00);
INSERT INTO `order_detail` VALUES (63, '清蒸鲈鱼', 'https://sky-itcast.oss-cn-beijing.aliyuncs.com/c18b5c67-3b71-466c-a75a-e63c6449f21c.png', 49, 58, NULL, NULL, 1, 98.00);
INSERT INTO `order_detail` VALUES (64, '雪花啤酒', 'https://sky-itcast.oss-cn-beijing.aliyuncs.com/bf8cbfc1-04d2-40e8-9826-061ee41ab87c.png', 50, 48, NULL, NULL, 1, 4.00);
INSERT INTO `order_detail` VALUES (65, '王老吉', 'https://sky-itcast.oss-cn-beijing.aliyuncs.com/41bfcacf-7ad4-4927-8b26-df366553a94c.png', 50, 46, NULL, NULL, 1, 6.00);
INSERT INTO `order_detail` VALUES (66, '金汤酸菜牛蛙', 'https://sky-itcast.oss-cn-beijing.aliyuncs.com/7694a5d8-7938-4e9d-8b9e-2075983a2e38.png', 51, 62, NULL, NULL, 1, 88.00);
INSERT INTO `order_detail` VALUES (67, '蜀味水煮草鱼', 'https://sky-itcast.oss-cn-beijing.aliyuncs.com/a6953d5a-4c18-4b30-9319-4926ee77261f.png', 52, 53, NULL, '不辣,不要香菜', 6, 38.00);
INSERT INTO `order_detail` VALUES (68, '金汤酸菜牛蛙', 'https://sky-itcast.oss-cn-beijing.aliyuncs.com/7694a5d8-7938-4e9d-8b9e-2075983a2e38.png', 53, 62, NULL, NULL, 1, 88.00);
INSERT INTO `order_detail` VALUES (69, '剁椒鱼头', 'https://sky-itcast.oss-cn-beijing.aliyuncs.com/13da832f-ef2c-484d-8370-5934a1045a06.png', 54, 61, NULL, NULL, 1, 66.00);
INSERT INTO `order_detail` VALUES (70, '蜀味水煮草鱼', 'https://sky-itcast.oss-cn-beijing.aliyuncs.com/a6953d5a-4c18-4b30-9319-4926ee77261f.png', 55, 53, NULL, '中辣,不要蒜', 1, 38.00);
INSERT INTO `order_detail` VALUES (71, '蜀味水煮草鱼', 'https://sky-itcast.oss-cn-beijing.aliyuncs.com/a6953d5a-4c18-4b30-9319-4926ee77261f.png', 56, 53, NULL, '中辣,不要蒜', 1, 38.00);
INSERT INTO `order_detail` VALUES (72, '蜀味水煮草鱼', 'https://sky-itcast.oss-cn-beijing.aliyuncs.com/a6953d5a-4c18-4b30-9319-4926ee77261f.png', 57, 53, NULL, '中辣,不要蒜', 1, 38.00);
INSERT INTO `order_detail` VALUES (73, '清蒸鲈鱼', 'https://sky-itcast.oss-cn-beijing.aliyuncs.com/c18b5c67-3b71-466c-a75a-e63c6449f21c.png', 58, 58, NULL, NULL, 1, 98.00);
INSERT INTO `order_detail` VALUES (74, '金汤酸菜牛蛙', 'https://sky-itcast.oss-cn-beijing.aliyuncs.com/7694a5d8-7938-4e9d-8b9e-2075983a2e38.png', 59, 62, NULL, NULL, 1, 88.00);
INSERT INTO `order_detail` VALUES (75, '馋嘴牛蛙', 'https://sky-itcast.oss-cn-beijing.aliyuncs.com/7a55b845-1f2b-41fa-9486-76d187ee9ee1.png', 60, 64, NULL, NULL, 1, 88.00);
INSERT INTO `order_detail` VALUES (76, '鸡蛋汤', 'https://sky-itcast.oss-cn-beijing.aliyuncs.com/c09a0ee8-9d19-428d-81b9-746221824113.png', 60, 68, NULL, NULL, 1, 4.00);
INSERT INTO `order_detail` VALUES (77, '馋嘴牛蛙', 'https://sky-itcast.oss-cn-beijing.aliyuncs.com/7a55b845-1f2b-41fa-9486-76d187ee9ee1.png', 61, 64, NULL, NULL, 1, 88.00);
INSERT INTO `order_detail` VALUES (78, '鸡蛋汤', 'https://sky-itcast.oss-cn-beijing.aliyuncs.com/c09a0ee8-9d19-428d-81b9-746221824113.png', 61, 68, NULL, NULL, 1, 4.00);
INSERT INTO `order_detail` VALUES (79, '馋嘴牛蛙', 'https://sky-itcast.oss-cn-beijing.aliyuncs.com/7a55b845-1f2b-41fa-9486-76d187ee9ee1.png', 62, 64, NULL, NULL, 1, 88.00);
INSERT INTO `order_detail` VALUES (80, '鸡蛋汤', 'https://sky-itcast.oss-cn-beijing.aliyuncs.com/c09a0ee8-9d19-428d-81b9-746221824113.png', 62, 68, NULL, NULL, 1, 4.00);
INSERT INTO `order_detail` VALUES (81, '蒜蓉娃娃菜', 'https://sky-itcast.oss-cn-beijing.aliyuncs.com/4879ed66-3860-4b28-ba14-306ac025fdec.png', 63, 55, NULL, NULL, 1, 18.00);
INSERT INTO `order_detail` VALUES (82, '平菇豆腐', 'https://sky-itcast.oss-cn-beijing.aliyuncs.com/16d0a3d6-2253-4cfc-9b49-bf7bd9eb2ad2.png', 63, 69, NULL, NULL, 1, 6.00);
INSERT INTO `order_detail` VALUES (83, '王老吉', 'https://sky-itcast.oss-cn-beijing.aliyuncs.com/41bfcacf-7ad4-4927-8b26-df366553a94c.png', 63, 46, NULL, NULL, 2, 6.00);
INSERT INTO `order_detail` VALUES (84, '人气套餐', 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/532eea35-dce8-412b-a062-97c084885545.png', 63, NULL, 6, NULL, 1, 399.00);
INSERT INTO `order_detail` VALUES (85, '蒜蓉娃娃菜', 'https://sky-itcast.oss-cn-beijing.aliyuncs.com/4879ed66-3860-4b28-ba14-306ac025fdec.png', 64, 55, NULL, NULL, 1, 18.00);
INSERT INTO `order_detail` VALUES (86, '平菇豆腐', 'https://sky-itcast.oss-cn-beijing.aliyuncs.com/16d0a3d6-2253-4cfc-9b49-bf7bd9eb2ad2.png', 64, 69, NULL, NULL, 1, 6.00);
INSERT INTO `order_detail` VALUES (87, '王老吉', 'https://sky-itcast.oss-cn-beijing.aliyuncs.com/41bfcacf-7ad4-4927-8b26-df366553a94c.png', 64, 46, NULL, NULL, 2, 6.00);
INSERT INTO `order_detail` VALUES (88, '人气套餐', 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/532eea35-dce8-412b-a062-97c084885545.png', 64, NULL, 6, NULL, 1, 399.00);
INSERT INTO `order_detail` VALUES (89, '馋嘴牛蛙', 'https://sky-itcast.oss-cn-beijing.aliyuncs.com/7a55b845-1f2b-41fa-9486-76d187ee9ee1.png', 65, 64, NULL, NULL, 1, 88.00);
INSERT INTO `order_detail` VALUES (90, '金汤酸菜牛蛙', 'https://sky-itcast.oss-cn-beijing.aliyuncs.com/7694a5d8-7938-4e9d-8b9e-2075983a2e38.png', 66, 62, NULL, NULL, 1, 88.00);
INSERT INTO `order_detail` VALUES (91, '馋嘴牛蛙', 'https://sky-itcast.oss-cn-beijing.aliyuncs.com/7a55b845-1f2b-41fa-9486-76d187ee9ee1.png', 67, 64, NULL, NULL, 1, 88.00);
INSERT INTO `order_detail` VALUES (92, '馋嘴牛蛙', 'https://sky-itcast.oss-cn-beijing.aliyuncs.com/7a55b845-1f2b-41fa-9486-76d187ee9ee1.png', 68, 64, NULL, NULL, 1, 88.00);
INSERT INTO `order_detail` VALUES (93, '蜀味水煮草鱼', 'https://sky-itcast.oss-cn-beijing.aliyuncs.com/a6953d5a-4c18-4b30-9319-4926ee77261f.png', 68, 53, NULL, '不要葱,中辣', 1, 38.00);
INSERT INTO `order_detail` VALUES (94, '人气套餐', 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/532eea35-dce8-412b-a062-97c084885545.png', 68, NULL, 6, NULL, 1, 399.00);
INSERT INTO `order_detail` VALUES (95, '人气套餐', 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/532eea35-dce8-412b-a062-97c084885545.png', 69, NULL, 6, NULL, 1, 399.00);
INSERT INTO `order_detail` VALUES (96, '蜀味水煮草鱼', 'https://sky-itcast.oss-cn-beijing.aliyuncs.com/a6953d5a-4c18-4b30-9319-4926ee77261f.png', 69, 53, NULL, '不辣,不要香菜', 1, 38.00);
INSERT INTO `order_detail` VALUES (97, '鸡蛋汤', 'https://sky-itcast.oss-cn-beijing.aliyuncs.com/c09a0ee8-9d19-428d-81b9-746221824113.png', 69, 68, NULL, NULL, 1, 4.00);
INSERT INTO `order_detail` VALUES (98, '北冰洋', 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/50b1e04f-1617-40b6-ac9a-1b366fa7488d.png', 69, 71, NULL, '去冰', 1, 3.50);
INSERT INTO `order_detail` VALUES (99, '人气套餐', 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/532eea35-dce8-412b-a062-97c084885545.png', 70, NULL, 6, NULL, 1, 399.00);
INSERT INTO `order_detail` VALUES (100, '蜀味水煮草鱼', 'https://sky-itcast.oss-cn-beijing.aliyuncs.com/a6953d5a-4c18-4b30-9319-4926ee77261f.png', 70, 53, NULL, '不辣,不要香菜', 1, 38.00);
INSERT INTO `order_detail` VALUES (101, '鸡蛋汤', 'https://sky-itcast.oss-cn-beijing.aliyuncs.com/c09a0ee8-9d19-428d-81b9-746221824113.png', 70, 68, NULL, NULL, 1, 4.00);
INSERT INTO `order_detail` VALUES (102, '北冰洋', 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/50b1e04f-1617-40b6-ac9a-1b366fa7488d.png', 70, 71, NULL, '去冰', 1, 3.50);
INSERT INTO `order_detail` VALUES (103, '金汤酸菜牛蛙', 'https://sky-itcast.oss-cn-beijing.aliyuncs.com/7694a5d8-7938-4e9d-8b9e-2075983a2e38.png', 71, 62, NULL, NULL, 1, 88.00);
INSERT INTO `order_detail` VALUES (104, '金汤酸菜牛蛙', 'https://sky-itcast.oss-cn-beijing.aliyuncs.com/7694a5d8-7938-4e9d-8b9e-2075983a2e38.png', 72, 62, NULL, NULL, 1, 88.00);
INSERT INTO `order_detail` VALUES (105, '雪花啤酒', 'https://sky-itcast.oss-cn-beijing.aliyuncs.com/bf8cbfc1-04d2-40e8-9826-061ee41ab87c.png', 73, 48, NULL, NULL, 1, 4.00);
INSERT INTO `order_detail` VALUES (106, '王老吉', 'https://sky-itcast.oss-cn-beijing.aliyuncs.com/41bfcacf-7ad4-4927-8b26-df366553a94c.png', 73, 46, NULL, NULL, 1, 6.00);
INSERT INTO `order_detail` VALUES (107, '蒜蓉娃娃菜', 'https://sky-itcast.oss-cn-beijing.aliyuncs.com/4879ed66-3860-4b28-ba14-306ac025fdec.png', 74, 55, NULL, NULL, 1, 18.00);
INSERT INTO `order_detail` VALUES (108, '蜀味水煮草鱼', 'https://sky-itcast.oss-cn-beijing.aliyuncs.com/a6953d5a-4c18-4b30-9319-4926ee77261f.png', 75, 53, NULL, '不辣,不要香菜', 1, 38.00);
INSERT INTO `order_detail` VALUES (109, '馋嘴牛蛙', 'https://sky-itcast.oss-cn-beijing.aliyuncs.com/7a55b845-1f2b-41fa-9486-76d187ee9ee1.png', 76, 64, NULL, NULL, 1, 88.00);
INSERT INTO `order_detail` VALUES (110, '金汤酸菜牛蛙', 'https://sky-itcast.oss-cn-beijing.aliyuncs.com/7694a5d8-7938-4e9d-8b9e-2075983a2e38.png', 76, 62, NULL, NULL, 1, 88.00);
INSERT INTO `order_detail` VALUES (111, '馋嘴牛蛙', 'https://sky-itcast.oss-cn-beijing.aliyuncs.com/7a55b845-1f2b-41fa-9486-76d187ee9ee1.png', 77, 64, NULL, NULL, 1, 88.00);
INSERT INTO `order_detail` VALUES (112, '馋嘴牛蛙', 'https://sky-itcast.oss-cn-beijing.aliyuncs.com/7a55b845-1f2b-41fa-9486-76d187ee9ee1.png', 78, 64, NULL, NULL, 1, 88.00);
INSERT INTO `order_detail` VALUES (113, '金汤酸菜牛蛙', 'https://sky-itcast.oss-cn-beijing.aliyuncs.com/7694a5d8-7938-4e9d-8b9e-2075983a2e38.png', 79, 62, NULL, NULL, 1, 88.00);
INSERT INTO `order_detail` VALUES (114, '金汤酸菜牛蛙', 'https://sky-itcast.oss-cn-beijing.aliyuncs.com/7694a5d8-7938-4e9d-8b9e-2075983a2e38.png', 80, 62, NULL, NULL, 1, 88.00);
INSERT INTO `order_detail` VALUES (115, '金汤酸菜牛蛙', 'https://sky-itcast.oss-cn-beijing.aliyuncs.com/7694a5d8-7938-4e9d-8b9e-2075983a2e38.png', 81, 62, NULL, NULL, 1, 88.00);
INSERT INTO `order_detail` VALUES (116, '馋嘴牛蛙', 'https://sky-itcast.oss-cn-beijing.aliyuncs.com/7a55b845-1f2b-41fa-9486-76d187ee9ee1.png', 82, 64, NULL, NULL, 1, 88.00);
INSERT INTO `order_detail` VALUES (117, '金汤酸菜牛蛙', 'https://sky-itcast.oss-cn-beijing.aliyuncs.com/7694a5d8-7938-4e9d-8b9e-2075983a2e38.png', 83, 62, NULL, NULL, 1, 88.00);
INSERT INTO `order_detail` VALUES (118, '金汤酸菜牛蛙', 'https://sky-itcast.oss-cn-beijing.aliyuncs.com/7694a5d8-7938-4e9d-8b9e-2075983a2e38.png', 84, 62, NULL, NULL, 1, 88.00);
INSERT INTO `order_detail` VALUES (119, '米饭', 'https://sky-itcast.oss-cn-beijing.aliyuncs.com/76752350-2121-44d2-b477-10791c23a8ec.png', 85, 49, NULL, NULL, 1, 6.00);
INSERT INTO `order_detail` VALUES (120, '剁椒鱼头', 'https://sky-itcast.oss-cn-beijing.aliyuncs.com/13da832f-ef2c-484d-8370-5934a1045a06.png', 86, 61, NULL, NULL, 1, 66.00);
INSERT INTO `order_detail` VALUES (121, '商务套餐', 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/dc03fad5-0b4d-4264-8223-0ca700ad0dfd.png', 87, NULL, 5, NULL, 1, 200.00);
INSERT INTO `order_detail` VALUES (122, '米饭', 'https://sky-itcast.oss-cn-beijing.aliyuncs.com/76752350-2121-44d2-b477-10791c23a8ec.png', 88, 49, NULL, NULL, 1, 6.00);
INSERT INTO `order_detail` VALUES (123, '东坡肘子', 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/b3273a85-4e84-4de4-b528-19386fd6e630.png', 89, NULL, 7, NULL, 1, 50.00);
INSERT INTO `order_detail` VALUES (124, '东坡肘子', 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/b3273a85-4e84-4de4-b528-19386fd6e630.png', 90, NULL, 7, NULL, 1, 50.00);
INSERT INTO `order_detail` VALUES (125, '馋嘴牛蛙', 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/42e122db-6a6b-40e6-b1e5-692abaa832ba.png', 90, 64, NULL, NULL, 1, 88.00);
INSERT INTO `order_detail` VALUES (126, '馋嘴牛蛙', 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/42e122db-6a6b-40e6-b1e5-692abaa832ba.png', 91, 64, NULL, NULL, 1, 88.00);
INSERT INTO `order_detail` VALUES (127, '王老吉', 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/78f9bef7-d1f6-4bc9-95f8-eb2b7571f049.png', 92, 46, NULL, '热饮', 1, 6.00);
INSERT INTO `order_detail` VALUES (128, '金汤酸菜牛蛙', 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/7bf704b8-246f-4cda-ac58-5be4515f84ac.png', 93, 62, NULL, NULL, 1, 88.00);
INSERT INTO `order_detail` VALUES (129, '馋嘴牛蛙', 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/42e122db-6a6b-40e6-b1e5-692abaa832ba.png', 93, 64, NULL, NULL, 1, 88.00);
INSERT INTO `order_detail` VALUES (130, '蜀味水煮草鱼', 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/0b04f37a-092b-4462-afbc-c43afab875c2.png', 94, 53, NULL, '不要香菜,重辣', 1, 38.00);
INSERT INTO `order_detail` VALUES (131, '鸡蛋汤', 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/6edd0ffc-0496-44da-af21-b9c9a8fe1975.png', 95, 68, NULL, NULL, 1, 4.00);
INSERT INTO `order_detail` VALUES (132, '平菇豆腐', 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/8b959d8a-e0b3-4f6a-a3e8-23ec6042f2e1.png', 95, 69, NULL, NULL, 1, 6.00);
INSERT INTO `order_detail` VALUES (133, '人气套餐', 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/532eea35-dce8-412b-a062-97c084885545.png', 95, NULL, 6, NULL, 1, 399.00);
INSERT INTO `order_detail` VALUES (134, '东坡肘子', 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/b3273a85-4e84-4de4-b528-19386fd6e630.png', 95, NULL, 7, NULL, 1, 50.00);
INSERT INTO `order_detail` VALUES (135, '米饭', 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/c4195594-ae65-4091-847d-12360f0fbb51.png', 95, 49, NULL, NULL, 1, 6.00);
INSERT INTO `order_detail` VALUES (136, '北冰洋', 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/50b1e04f-1617-40b6-ac9a-1b366fa7488d.png', 95, 71, NULL, '去冰', 1, 3.50);
INSERT INTO `order_detail` VALUES (137, '鸡蛋汤', 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/6edd0ffc-0496-44da-af21-b9c9a8fe1975.png', 96, 68, NULL, NULL, 1, 4.00);
INSERT INTO `order_detail` VALUES (138, '平菇豆腐', 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/8b959d8a-e0b3-4f6a-a3e8-23ec6042f2e1.png', 96, 69, NULL, NULL, 1, 6.00);
INSERT INTO `order_detail` VALUES (139, '人气套餐', 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/532eea35-dce8-412b-a062-97c084885545.png', 96, NULL, 6, NULL, 1, 399.00);
INSERT INTO `order_detail` VALUES (140, '东坡肘子', 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/b3273a85-4e84-4de4-b528-19386fd6e630.png', 96, NULL, 7, NULL, 1, 50.00);
INSERT INTO `order_detail` VALUES (141, '米饭', 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/c4195594-ae65-4091-847d-12360f0fbb51.png', 96, 49, NULL, NULL, 1, 6.00);
INSERT INTO `order_detail` VALUES (142, '北冰洋', 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/50b1e04f-1617-40b6-ac9a-1b366fa7488d.png', 96, 71, NULL, '去冰', 1, 3.50);
INSERT INTO `order_detail` VALUES (143, '鸡蛋汤', 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/6edd0ffc-0496-44da-af21-b9c9a8fe1975.png', 97, 68, NULL, NULL, 1, 4.00);
INSERT INTO `order_detail` VALUES (144, '平菇豆腐', 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/8b959d8a-e0b3-4f6a-a3e8-23ec6042f2e1.png', 97, 69, NULL, NULL, 1, 6.00);
INSERT INTO `order_detail` VALUES (145, '人气套餐', 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/532eea35-dce8-412b-a062-97c084885545.png', 97, NULL, 6, NULL, 1, 399.00);
INSERT INTO `order_detail` VALUES (146, '东坡肘子', 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/b3273a85-4e84-4de4-b528-19386fd6e630.png', 97, NULL, 7, NULL, 1, 50.00);
INSERT INTO `order_detail` VALUES (147, '米饭', 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/c4195594-ae65-4091-847d-12360f0fbb51.png', 97, 49, NULL, NULL, 1, 6.00);
INSERT INTO `order_detail` VALUES (148, '北冰洋', 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/50b1e04f-1617-40b6-ac9a-1b366fa7488d.png', 97, 71, NULL, '去冰', 1, 3.50);
INSERT INTO `order_detail` VALUES (149, '剁椒鱼头', 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/9082a315-e171-4243-83a9-9637aa269473.png', 98, 61, NULL, NULL, 1, 66.00);
INSERT INTO `order_detail` VALUES (150, '蒜蓉娃娃菜', 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/03826012-bcfe-4e2a-9a18-783f8bb0c638.png', 98, 55, NULL, NULL, 1, 18.00);
INSERT INTO `order_detail` VALUES (151, '蜀味水煮草鱼', 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/0b04f37a-092b-4462-afbc-c43afab875c2.png', 99, 53, NULL, '不要香菜,重辣', 1, 38.00);
INSERT INTO `order_detail` VALUES (152, '米饭', 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/c4195594-ae65-4091-847d-12360f0fbb51.png', 99, 49, NULL, NULL, 1, 6.00);
INSERT INTO `order_detail` VALUES (153, '东坡肘子', 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/b3273a85-4e84-4de4-b528-19386fd6e630.png', 100, NULL, 7, NULL, 2, 50.00);
INSERT INTO `order_detail` VALUES (154, '人气套餐', 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/532eea35-dce8-412b-a062-97c084885545.png', 100, NULL, 6, NULL, 2, 399.00);
INSERT INTO `order_detail` VALUES (155, '雪花啤酒', 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/1184d249-eb14-42f3-990d-24fbae149e4d.png', 100, 48, NULL, '去冰', 1, 4.00);
INSERT INTO `order_detail` VALUES (156, '米饭', 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/c4195594-ae65-4091-847d-12360f0fbb51.png', 100, 49, NULL, NULL, 4, 6.00);
INSERT INTO `order_detail` VALUES (157, '鸡蛋汤', 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/6edd0ffc-0496-44da-af21-b9c9a8fe1975.png', 101, 68, NULL, NULL, 1, 4.00);
INSERT INTO `order_detail` VALUES (158, '平菇豆腐', 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/8b959d8a-e0b3-4f6a-a3e8-23ec6042f2e1.png', 101, 69, NULL, NULL, 1, 6.00);
INSERT INTO `order_detail` VALUES (159, '米饭', 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/c4195594-ae65-4091-847d-12360f0fbb51.png', 101, 49, NULL, NULL, 1, 6.00);
INSERT INTO `order_detail` VALUES (160, '蜀味水煮草鱼', 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/0b04f37a-092b-4462-afbc-c43afab875c2.png', 101, 53, NULL, '不辣,不要蒜', 1, 38.00);
INSERT INTO `order_detail` VALUES (161, '蒜蓉娃娃菜', 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/03826012-bcfe-4e2a-9a18-783f8bb0c638.png', 101, 55, NULL, NULL, 1, 18.00);
INSERT INTO `order_detail` VALUES (162, '剁椒鱼头', 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/9082a315-e171-4243-83a9-9637aa269473.png', 101, 61, NULL, NULL, 1, 66.00);
INSERT INTO `order_detail` VALUES (163, '东坡肘子', 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/02a03c59-2e8f-479a-9e6e-952aff6e4418.png', 101, 59, NULL, NULL, 1, 138.00);
INSERT INTO `order_detail` VALUES (164, '清蒸鲈鱼', 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/087e2bbd-82ad-4ccd-94bb-f06612770ff0.png', 101, 58, NULL, NULL, 1, 98.00);
INSERT INTO `order_detail` VALUES (165, '金汤酸菜牛蛙', 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/7bf704b8-246f-4cda-ac58-5be4515f84ac.png', 102, 62, NULL, NULL, 1, 88.00);
INSERT INTO `order_detail` VALUES (166, '米饭', 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/c4195594-ae65-4091-847d-12360f0fbb51.png', 103, 49, NULL, NULL, 1, 6.00);
INSERT INTO `order_detail` VALUES (167, '鸡蛋汤', 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/6edd0ffc-0496-44da-af21-b9c9a8fe1975.png', 103, 68, NULL, NULL, 1, 4.00);
INSERT INTO `order_detail` VALUES (168, '平菇豆腐', 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/8b959d8a-e0b3-4f6a-a3e8-23ec6042f2e1.png', 103, 69, NULL, NULL, 1, 6.00);
INSERT INTO `order_detail` VALUES (169, '人气套餐', 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/532eea35-dce8-412b-a062-97c084885545.png', 103, NULL, 6, NULL, 1, 399.00);
INSERT INTO `order_detail` VALUES (170, '东坡肘子', 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/b3273a85-4e84-4de4-b528-19386fd6e630.png', 103, NULL, 7, NULL, 1, 50.00);
INSERT INTO `order_detail` VALUES (171, '馋嘴牛蛙', 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/42e122db-6a6b-40e6-b1e5-692abaa832ba.png', 104, 64, NULL, NULL, 1, 88.00);
INSERT INTO `order_detail` VALUES (172, '江团鱼2斤', 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/7611e5d1-7ed0-4aee-bb99-eec5a5fb1c0b.png', 105, 66, NULL, '重辣', 1, 119.00);
INSERT INTO `order_detail` VALUES (173, '江团鱼2斤', 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/7611e5d1-7ed0-4aee-bb99-eec5a5fb1c0b.png', 106, 66, NULL, '重辣', 1, 119.00);
INSERT INTO `order_detail` VALUES (174, '江团鱼2斤', 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/7611e5d1-7ed0-4aee-bb99-eec5a5fb1c0b.png', 107, 66, NULL, '重辣', 1, 119.00);
INSERT INTO `order_detail` VALUES (175, '米饭', 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/c4195594-ae65-4091-847d-12360f0fbb51.png', 107, 49, NULL, NULL, 1, 6.00);
INSERT INTO `order_detail` VALUES (176, '雪花啤酒', 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/1184d249-eb14-42f3-990d-24fbae149e4d.png', 107, 48, NULL, '去冰', 1, 4.00);
INSERT INTO `order_detail` VALUES (177, '平菇豆腐', 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/8b959d8a-e0b3-4f6a-a3e8-23ec6042f2e1.png', 107, 69, NULL, NULL, 1, 6.00);
INSERT INTO `order_detail` VALUES (178, '东坡肘子', 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/02a03c59-2e8f-479a-9e6e-952aff6e4418.png', 108, 59, NULL, NULL, 1, 138.00);
INSERT INTO `order_detail` VALUES (179, '剁椒鱼头', 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/9082a315-e171-4243-83a9-9637aa269473.png', 108, 61, NULL, NULL, 1, 66.00);
INSERT INTO `order_detail` VALUES (180, '清蒸鲈鱼', 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/087e2bbd-82ad-4ccd-94bb-f06612770ff0.png', 108, 58, NULL, NULL, 1, 98.00);
INSERT INTO `order_detail` VALUES (181, '鮰鱼2斤', 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/fa45d23b-dcc5-44c9-86ff-f70cfdb7af1d.png', 109, 67, NULL, '重辣', 1, 72.00);
INSERT INTO `order_detail` VALUES (182, '米饭', 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/c4195594-ae65-4091-847d-12360f0fbb51.png', 109, 49, NULL, NULL, 1, 6.00);
INSERT INTO `order_detail` VALUES (183, '雪花啤酒', 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/1184d249-eb14-42f3-990d-24fbae149e4d.png', 109, 48, NULL, '少冰', 1, 4.00);
INSERT INTO `order_detail` VALUES (184, '平菇豆腐', 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/8b959d8a-e0b3-4f6a-a3e8-23ec6042f2e1.png', 109, 69, NULL, NULL, 1, 6.00);
INSERT INTO `order_detail` VALUES (185, '鸡蛋汤', 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/6edd0ffc-0496-44da-af21-b9c9a8fe1975.png', 109, 68, NULL, NULL, 1, 4.00);
INSERT INTO `order_detail` VALUES (186, '剁椒鱼头', 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/9082a315-e171-4243-83a9-9637aa269473.png', 109, 61, NULL, NULL, 1, 66.00);
INSERT INTO `order_detail` VALUES (187, '东坡肘子', 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/02a03c59-2e8f-479a-9e6e-952aff6e4418.png', 109, 59, NULL, NULL, 1, 138.00);
INSERT INTO `order_detail` VALUES (188, '蒜蓉娃娃菜', 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/03826012-bcfe-4e2a-9a18-783f8bb0c638.png', 110, 55, NULL, NULL, 1, 18.00);
INSERT INTO `order_detail` VALUES (189, '蒜蓉娃娃菜', 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/03826012-bcfe-4e2a-9a18-783f8bb0c638.png', 111, 55, NULL, NULL, 1, 18.00);
INSERT INTO `order_detail` VALUES (190, '鮰鱼2斤', 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/fa45d23b-dcc5-44c9-86ff-f70cfdb7af1d.png', 112, 67, NULL, '中辣', 2, 72.00);
INSERT INTO `order_detail` VALUES (191, '蒜蓉娃娃菜', 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/03826012-bcfe-4e2a-9a18-783f8bb0c638.png', 112, 55, NULL, NULL, 1, 18.00);
INSERT INTO `order_detail` VALUES (192, '鸡蛋汤', 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/6edd0ffc-0496-44da-af21-b9c9a8fe1975.png', 112, 68, NULL, NULL, 1, 4.00);
INSERT INTO `order_detail` VALUES (193, '人气套餐', 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/532eea35-dce8-412b-a062-97c084885545.png', 113, NULL, 6, NULL, 1, 399.00);
INSERT INTO `order_detail` VALUES (194, '东坡肘子', 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/b3273a85-4e84-4de4-b528-19386fd6e630.png', 113, NULL, 7, NULL, 1, 50.00);
INSERT INTO `order_detail` VALUES (195, '水煮鱼套餐', 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/c2a67941-508d-4fde-add6-bc2440935da0.png', 113, NULL, 8, NULL, 1, 60.00);
INSERT INTO `order_detail` VALUES (196, '汉堡五件套', 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/5f519597-233f-46cb-9281-6b6440939bb4.jpg', 114, NULL, 9, NULL, 1, 39.90);
INSERT INTO `order_detail` VALUES (197, '东坡肘子', 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/b3273a85-4e84-4de4-b528-19386fd6e630.png', 115, NULL, 7, NULL, 1, 50.00);
INSERT INTO `order_detail` VALUES (198, '薯条', 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/419f7454-8e66-42c5-926d-c78e51ceb3a5.jpg', 116, 81, NULL, NULL, 1, 3.90);
INSERT INTO `order_detail` VALUES (199, '双排鸡柳汉堡', 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/84e3e2f3-f916-4a35-a3f5-388c6f3e142e.jpg', 116, 80, NULL, NULL, 1, 7.90);
INSERT INTO `order_detail` VALUES (200, '炸鸡', 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/f7da025d-dece-4688-99e8-bdad4b7902ad.jpg', 116, 78, NULL, NULL, 1, 20.00);
INSERT INTO `order_detail` VALUES (201, '冰柠可乐', 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/ccd39e8b-256d-4903-9f6a-6fa6c5a0aac4.jpg', 116, 77, NULL, '少冰', 1, 3.00);
INSERT INTO `order_detail` VALUES (202, '人气套餐', 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/532eea35-dce8-412b-a062-97c084885545.png', 117, NULL, 6, NULL, 1, 399.00);
INSERT INTO `order_detail` VALUES (203, '荔枝烤鱼', 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/31db8ee3-d49e-4f23-8b6e-fb536210974f.png', 118, 73, NULL, NULL, 1, 168.00);
INSERT INTO `order_detail` VALUES (204, '荔枝烤鱼', 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/31db8ee3-d49e-4f23-8b6e-fb536210974f.png', 119, 73, NULL, NULL, 1, 168.00);
INSERT INTO `order_detail` VALUES (205, '人气套餐', 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/532eea35-dce8-412b-a062-97c084885545.png', 119, NULL, 6, NULL, 1, 399.00);
INSERT INTO `order_detail` VALUES (206, '人气套餐', 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/532eea35-dce8-412b-a062-97c084885545.png', 120, NULL, 6, NULL, 1, 399.00);
INSERT INTO `order_detail` VALUES (207, '东坡肘子', 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/b3273a85-4e84-4de4-b528-19386fd6e630.png', 121, NULL, 7, NULL, 1, 50.00);
INSERT INTO `order_detail` VALUES (208, '人气套餐', 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/532eea35-dce8-412b-a062-97c084885545.png', 122, NULL, 6, NULL, 1, 399.00);
INSERT INTO `order_detail` VALUES (209, '人气套餐', 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/532eea35-dce8-412b-a062-97c084885545.png', 123, NULL, 6, NULL, 1, 399.00);
INSERT INTO `order_detail` VALUES (210, '人气套餐', 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/532eea35-dce8-412b-a062-97c084885545.png', 124, NULL, 6, NULL, 1, 399.00);
INSERT INTO `order_detail` VALUES (211, '人气套餐', 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/532eea35-dce8-412b-a062-97c084885545.png', 125, NULL, 6, NULL, 1, 399.00);
INSERT INTO `order_detail` VALUES (212, '人气套餐', 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/532eea35-dce8-412b-a062-97c084885545.png', 126, NULL, 6, NULL, 1, 399.00);
INSERT INTO `order_detail` VALUES (213, '东坡肘子', 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/b3273a85-4e84-4de4-b528-19386fd6e630.png', 126, NULL, 7, NULL, 1, 50.00);
INSERT INTO `order_detail` VALUES (214, '水煮鱼套餐', 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/c2a67941-508d-4fde-add6-bc2440935da0.png', 126, NULL, 8, NULL, 1, 60.00);
INSERT INTO `order_detail` VALUES (215, '商务套餐', 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/dc03fad5-0b4d-4264-8223-0ca700ad0dfd.png', 127, NULL, 5, NULL, 1, 200.00);
INSERT INTO `order_detail` VALUES (216, '凉拌娃娃菜', 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/67755952-f475-4e12-adbb-73b63d22fcd1.png', 128, 75, NULL, '不辣', 1, 10.00);
INSERT INTO `order_detail` VALUES (217, '人气套餐', 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/532eea35-dce8-412b-a062-97c084885545.png', 129, NULL, 6, NULL, 1, 399.00);
INSERT INTO `order_detail` VALUES (218, '烤牛肉', 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/ba3b9095-9e25-4e9e-a7d5-5c7d29419b8e.png', 130, 85, NULL, NULL, 1, 19.99);
INSERT INTO `order_detail` VALUES (219, '烤牛肉', 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/ba3b9095-9e25-4e9e-a7d5-5c7d29419b8e.png', 131, 85, NULL, NULL, 1, 19.99);
INSERT INTO `order_detail` VALUES (220, '商务套餐', 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/dc03fad5-0b4d-4264-8223-0ca700ad0dfd.png', 132, NULL, 5, NULL, 1, 200.00);
INSERT INTO `order_detail` VALUES (221, '汉堡五件套', 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/5f519597-233f-46cb-9281-6b6440939bb4.jpg', 133, NULL, 9, NULL, 1, 39.90);

-- ----------------------------
-- Table structure for orders
-- ----------------------------
DROP TABLE IF EXISTS `orders`;
CREATE TABLE `orders`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `number` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '订单号',
  `status` int(11) NOT NULL DEFAULT 1 COMMENT '订单状态 1待付款 2待接单 3已接单 4派送中 5已完成 6已取消 7退款',
  `user_id` bigint(20) NOT NULL COMMENT '下单用户',
  `address_book_id` bigint(20) NOT NULL COMMENT '地址id',
  `order_time` datetime NOT NULL COMMENT '下单时间',
  `checkout_time` datetime NULL DEFAULT NULL COMMENT '结账时间',
  `pay_method` int(11) NOT NULL DEFAULT 1 COMMENT '支付方式 1微信,2支付宝',
  `pay_status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '支付状态 0未支付 1已支付 2退款',
  `amount` decimal(10, 2) NOT NULL COMMENT '实收金额',
  `remark` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '备注',
  `phone` varchar(11) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '手机号',
  `address` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '地址',
  `user_name` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '用户名称',
  `consignee` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '收货人',
  `cancel_reason` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '订单取消原因',
  `rejection_reason` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '订单拒绝原因',
  `cancel_time` datetime NULL DEFAULT NULL COMMENT '订单取消时间',
  `estimated_delivery_time` datetime NULL DEFAULT NULL COMMENT '预计送达时间',
  `delivery_status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '配送状态  1立即送出  0选择具体时间',
  `delivery_time` datetime NULL DEFAULT NULL COMMENT '送达时间',
  `pack_amount` int(11) NULL DEFAULT NULL COMMENT '打包费',
  `tableware_number` int(11) NULL DEFAULT NULL COMMENT '餐具数量',
  `tableware_status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '餐具数量状态  1按餐量提供  0选择具体数量',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 134 CHARACTER SET = utf8 COLLATE = utf8_bin COMMENT = '订单表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of orders
-- ----------------------------
INSERT INTO `orders` VALUES (1, '1692363102160', 6, 1, 1, '2023-08-18 20:51:40', NULL, 1, 0, 188.50, '', '13645678897', '丈八六路一号', NULL, '爪爪', '订单超时，自动取消', NULL, '2023-08-22 00:33:00', '2023-08-18 21:49:00', 0, NULL, 3, 0, 0);
INSERT INTO `orders` VALUES (2, '1692363209396', 6, 1, 1, '2023-08-18 20:53:29', NULL, 1, 0, 95.00, '', '13645678897', '丈八六路一号', NULL, '爪爪', '订单超时，自动取消', NULL, '2023-08-22 00:33:00', '2023-08-18 21:53:00', 0, NULL, 1, 0, 0);
INSERT INTO `orders` VALUES (3, '1692365014922', 6, 1, 1, '2023-08-18 21:23:35', NULL, 1, 0, 10.50, '', '13645678897', '丈八六路一号', NULL, '爪爪', '订单超时，自动取消', NULL, '2023-08-22 00:33:00', '2023-08-18 22:23:00', 0, NULL, 1, 0, 0);
INSERT INTO `orders` VALUES (4, '1692365837316', 6, 1, 1, '2023-08-18 21:37:17', NULL, 1, 0, 184.00, '', '13645678897', '丈八六路一号', NULL, '爪爪', '订单超时，自动取消', NULL, '2023-08-22 00:33:00', '2023-08-18 22:37:00', 0, NULL, 2, 0, 0);
INSERT INTO `orders` VALUES (5, '1692365919408', 6, 1, 1, '2023-08-18 21:38:39', NULL, 1, 0, 95.00, '', '13645678897', '丈八六路一号', NULL, '爪爪', '用户取消', NULL, '2023-08-21 21:27:21', '2023-08-18 22:38:00', 0, NULL, 1, 0, 0);
INSERT INTO `orders` VALUES (6, '1692365962990', 6, 1, 1, '2023-08-18 21:39:23', NULL, 1, 0, 95.00, '', '13645678897', '丈八六路一号', NULL, '爪爪', '订单超时，自动取消', NULL, '2023-08-22 00:33:00', '2023-08-18 22:39:00', 0, NULL, 1, 0, 0);
INSERT INTO `orders` VALUES (7, '1692365983344', 6, 1, 1, '2023-08-18 21:39:43', NULL, 1, 0, 95.00, '', '13645678897', '丈八六路一号', NULL, '爪爪', '订单超时，自动取消', NULL, '2023-08-22 00:33:00', '2023-08-18 22:39:00', 0, NULL, 1, 0, 0);
INSERT INTO `orders` VALUES (8, '1692366057455', 6, 1, 1, '2023-08-18 21:40:57', NULL, 1, 0, 95.00, '', '13645678897', '丈八六路一号', NULL, '爪爪', '订单超时，自动取消', NULL, '2023-08-22 00:33:00', '2023-08-18 22:40:00', 0, NULL, 1, 0, 0);
INSERT INTO `orders` VALUES (9, '1692370003702', 6, 1, 1, '2023-08-18 22:46:44', NULL, 1, 0, 95.00, '', '13645678897', '丈八六路一号', NULL, '爪爪', '订单超时，自动取消', NULL, '2023-08-22 00:33:00', '2023-08-18 23:46:00', 0, NULL, 1, 0, 0);
INSERT INTO `orders` VALUES (10, '1692370036529', 6, 1, 1, '2023-08-18 22:47:17', NULL, 1, 0, 95.00, '', '13645678897', '丈八六路一号', NULL, '爪爪', '订单超时，自动取消', NULL, '2023-08-22 00:33:00', '2023-08-18 23:47:00', 0, NULL, 1, 0, 0);
INSERT INTO `orders` VALUES (11, '1692370085256', 6, 1, 1, '2023-08-18 22:48:05', NULL, 1, 0, 95.00, '', '13645678897', '丈八六路一号', NULL, '爪爪', '用户取消', NULL, '2023-08-21 20:54:11', '2023-08-18 23:48:00', 0, NULL, 1, 0, 0);
INSERT INTO `orders` VALUES (12, '1692370232169', 5, 1, 1, '2023-08-18 22:50:32', '2023-08-18 22:50:34', 1, 1, 184.00, '', '13645678897', '丈八六路一号', NULL, '爪爪', NULL, NULL, NULL, '2023-08-18 23:50:00', 0, '2023-12-02 09:21:52', 2, 0, 0);
INSERT INTO `orders` VALUES (13, '1692370350446', 5, 1, 1, '2023-08-18 22:52:30', '2023-08-18 22:52:31', 1, 1, 95.00, '', '13645678897', '丈八六路一号', NULL, '爪爪', NULL, NULL, NULL, '2023-08-18 23:52:00', 0, '2023-12-02 09:21:52', 1, 0, 0);
INSERT INTO `orders` VALUES (14, '1692370361811', 5, 1, 1, '2023-08-18 22:52:42', '2023-08-18 22:52:43', 1, 1, 95.00, '', '13645678897', '丈八六路一号', NULL, '爪爪', NULL, NULL, NULL, '2023-08-18 23:52:00', 0, '2023-08-22 07:43:14', 1, 0, 0);
INSERT INTO `orders` VALUES (15, '1692370638332', 5, 1, 1, '2023-08-18 22:57:18', '2023-08-18 22:57:22', 1, 1, 95.00, '', '13645678897', '丈八六路一号', NULL, '爪爪', NULL, NULL, NULL, '2023-08-18 23:57:00', 0, '2023-08-22 07:43:13', 1, 0, 0);
INSERT INTO `orders` VALUES (16, '1692370684197', 5, 1, 1, '2023-08-18 22:58:04', '2023-08-18 22:58:05', 1, 1, 95.00, '', '13645678897', '丈八六路一号', NULL, '爪爪', NULL, NULL, NULL, '2023-08-18 23:58:00', 0, '2023-08-22 07:43:13', 1, 0, 0);
INSERT INTO `orders` VALUES (17, '1692399047993', 5, 1, 1, '2023-08-19 06:50:48', '2023-08-19 06:50:49', 1, 1, 95.00, '', '13645678897', '丈八六路一号', NULL, '爪爪', NULL, NULL, NULL, '2023-08-19 07:50:00', 0, '2023-08-22 07:43:13', 1, 0, 0);
INSERT INTO `orders` VALUES (18, '1692400072785', 5, 1, 1, '2023-08-19 07:07:53', '2023-08-19 07:07:54', 1, 1, 95.00, '', '13645678897', '丈八六路一号', NULL, '爪爪', NULL, NULL, NULL, '2023-08-19 08:07:00', 0, '2023-08-22 07:43:13', 1, 0, 0);
INSERT INTO `orders` VALUES (19, '1692400128939', 5, 1, 1, '2023-08-19 07:08:49', '2023-08-19 07:09:11', 1, 1, 95.00, '', '13645678897', '丈八六路一号', NULL, '爪爪', NULL, NULL, NULL, '2023-08-19 08:08:00', 0, '2023-08-22 07:43:12', 1, 0, 0);
INSERT INTO `orders` VALUES (20, '1692400700334', 5, 1, 1, '2023-08-19 07:18:20', '2023-08-19 07:18:21', 1, 1, 95.00, '', '13645678897', '丈八六路一号', NULL, '爪爪', NULL, NULL, NULL, '2023-08-19 08:18:00', 0, '2023-08-22 07:42:32', 1, 0, 0);
INSERT INTO `orders` VALUES (21, '1692400928050', 5, 1, 1, '2023-08-19 07:22:08', '2023-08-19 07:22:09', 1, 1, 95.00, '', '13645678897', '丈八六路一号', NULL, '爪爪', NULL, NULL, NULL, '2023-08-19 08:22:00', 0, NULL, 1, 0, 0);
INSERT INTO `orders` VALUES (22, '1692402602201', 6, 1, 1, '2023-08-19 07:50:02', '2023-08-19 07:50:06', 1, 2, 95.00, '', '13645678897', '丈八六路一号', NULL, '爪爪', '用户取消', NULL, '2023-08-21 20:45:04', '2023-08-19 08:49:00', 0, NULL, 1, 0, 0);
INSERT INTO `orders` VALUES (23, '1692450237570', 5, 1, 1, '2023-08-19 21:03:58', '2023-08-19 21:03:59', 1, 1, 95.00, '', '13645678897', '丈八六路一号', NULL, '爪爪', NULL, NULL, NULL, '2023-08-19 22:03:00', 0, '2023-08-21 22:24:19', 1, 0, 0);
INSERT INTO `orders` VALUES (24, '1692502830805', 6, 1, 1, '2023-08-20 11:40:31', '2023-08-20 11:40:32', 1, 1, 406.00, '', '13645678897', '丈八六路一号', NULL, '爪爪', NULL, '菜品已销售完，暂时无法接单', '2023-08-21 22:20:24', '2023-08-20 12:40:00', 0, NULL, 1, 0, 0);
INSERT INTO `orders` VALUES (25, '1692617367867', 6, 1, 1, '2023-08-21 19:29:28', '2023-08-21 19:29:29', 1, 1, 207.00, '', '13645678897', '丈八六路一号', NULL, '爪爪', NULL, '订单量较多，暂时无法接单', '2023-08-21 22:20:13', '2023-08-21 20:29:00', 0, NULL, 1, 0, 0);
INSERT INTO `orders` VALUES (26, '1692620962468', 6, 1, 1, '2023-08-21 20:29:22', '2023-08-21 20:29:30', 1, 1, 95.00, 'test\n', '13645678897', '丈八六路一号', NULL, '爪爪', '订单量较多，暂时无法接单', NULL, '2023-08-21 22:21:53', '2023-08-21 21:29:00', 0, NULL, 1, 0, 0);
INSERT INTO `orders` VALUES (27, '1692621431495', 6, 1, 1, '2023-08-21 20:37:11', '2023-08-21 20:37:12', 1, 2, 95.00, '', '13645678897', '丈八六路一号', NULL, '爪爪', '用户取消', NULL, '2023-08-21 20:54:18', '2023-08-21 21:37:00', 0, NULL, 1, 0, 0);
INSERT INTO `orders` VALUES (28, '1692622493374', 6, 1, 1, '2023-08-21 20:54:53', '2023-08-21 20:54:54', 1, 2, 10.50, '', '13645678897', '丈八六路一号', NULL, '爪爪', '用户取消', NULL, '2023-08-21 20:55:01', '2023-08-21 21:54:00', 0, NULL, 1, 0, 0);
INSERT INTO `orders` VALUES (29, '1692624392269', 6, 1, 1, '2023-08-21 21:26:32', '2023-08-21 21:26:33', 1, 2, 184.00, '', '13645678897', '丈八六路一号', NULL, '爪爪', '用户取消', NULL, '2023-08-21 21:26:46', '2023-08-21 22:26:00', 0, NULL, 2, 0, 0);
INSERT INTO `orders` VALUES (30, '1692629595962', 5, 1, 1, '2023-08-21 22:53:16', '2023-08-21 22:53:22', 1, 1, 99.50, '', '13645678897', '丈八六路一号', NULL, '爪爪', NULL, NULL, NULL, '2023-08-21 23:53:00', 0, '2023-08-22 07:43:12', 2, 0, 0);
INSERT INTO `orders` VALUES (31, '1692629637427', 6, 1, 1, '2023-08-21 22:53:57', NULL, 1, 0, 95.00, '', '13645678897', '丈八六路一号', NULL, '爪爪', '订单超时，自动取消', NULL, '2023-08-22 00:33:00', '2023-08-21 23:53:00', 0, NULL, 1, 0, 0);
INSERT INTO `orders` VALUES (32, '1692629648694', 6, 1, 1, '2023-08-21 22:54:09', NULL, 1, 0, 95.00, '', '13645678897', '丈八六路一号', NULL, '爪爪', '订单超时，自动取消', NULL, '2023-08-22 00:33:00', '2023-08-21 23:54:00', 0, NULL, 1, 0, 0);
INSERT INTO `orders` VALUES (33, '1692629779472', 6, 1, 1, '2023-08-21 22:56:19', NULL, 1, 0, 184.00, '', '13645678897', '丈八六路一号', NULL, '爪爪', '订单超时，自动取消', NULL, '2023-08-22 00:33:00', '2023-08-21 23:56:00', 0, NULL, 2, 0, 0);
INSERT INTO `orders` VALUES (34, '1692629789916', 5, 1, 1, '2023-08-21 22:56:30', '2023-08-21 22:56:32', 1, 1, 95.00, '', '13645678897', '丈八六路一号', NULL, '爪爪', NULL, NULL, NULL, '2023-08-21 23:56:00', 0, '2023-08-22 07:43:12', 1, 0, 0);
INSERT INTO `orders` VALUES (35, '1692637160394', 5, 1, 1, '2023-08-22 00:59:20', '2023-08-22 00:59:22', 1, 1, 95.00, '', '13645678897', '丈八六路一号', NULL, '爪爪', NULL, NULL, NULL, '2023-08-22 01:59:00', 0, '2023-08-22 07:34:25', 1, 0, 0);
INSERT INTO `orders` VALUES (36, '1692637381380', 5, 1, 1, '2023-08-22 01:03:01', '2023-08-22 01:03:02', 1, 1, 95.00, '', '13645678897', '丈八六路一号', NULL, '爪爪', NULL, NULL, NULL, '2023-08-22 02:02:00', 0, '2023-12-02 09:21:51', 1, 0, 0);
INSERT INTO `orders` VALUES (37, '1692637449269', 5, 1, 1, '2023-08-22 01:04:09', '2023-08-22 01:04:10', 1, 1, 184.00, '', '13645678897', '丈八六路一号', NULL, '爪爪', NULL, NULL, NULL, '2023-08-22 02:04:00', 0, '2023-08-22 07:43:12', 2, 0, 0);
INSERT INTO `orders` VALUES (38, '1692637905275', 5, 1, 1, '2023-08-22 01:11:45', '2023-08-22 01:11:50', 1, 1, 184.00, '', '13645678897', '丈八六路一号', NULL, '爪爪', NULL, NULL, NULL, '2023-08-22 02:11:00', 0, '2023-08-22 07:43:11', 2, 0, 0);
INSERT INTO `orders` VALUES (39, '1692637926786', 5, 1, 1, '2023-08-22 01:12:07', '2023-08-22 01:12:08', 1, 1, 184.00, '', '13645678897', '丈八六路一号', NULL, '爪爪', NULL, NULL, NULL, '2023-08-22 02:12:00', 0, '2023-08-22 07:43:11', 2, 0, 0);
INSERT INTO `orders` VALUES (40, '1692637992092', 5, 1, 1, '2023-08-22 01:13:12', '2023-08-22 01:13:15', 1, 1, 273.00, '', '13645678897', '丈八六路一号', NULL, '爪爪', NULL, NULL, NULL, '2023-08-22 02:13:00', 0, '2023-08-22 07:43:11', 3, 0, 0);
INSERT INTO `orders` VALUES (41, '1692641135451', 6, 1, 1, '2023-08-22 02:05:35', '2023-08-22 02:05:36', 1, 2, 273.00, '', '13645678897', '丈八六路一号', NULL, '爪爪', '用户取消', NULL, '2023-08-22 02:05:42', '2023-08-22 03:05:00', 0, NULL, 3, 0, 0);
INSERT INTO `orders` VALUES (42, '1692641148774', 5, 1, 1, '2023-08-22 02:05:49', '2023-08-22 02:05:50', 1, 1, 273.00, '', '13645678897', '丈八六路一号', NULL, '爪爪', NULL, NULL, NULL, '2023-08-22 03:05:00', 0, '2023-08-22 07:43:11', 3, 0, 0);
INSERT INTO `orders` VALUES (43, '1692659371473', 5, 1, 1, '2023-08-22 07:09:31', '2023-08-22 07:09:35', 1, 1, 273.00, '', '13645678897', '丈八六路一号', NULL, '爪爪', NULL, NULL, NULL, '2023-08-22 08:09:00', 0, '2023-08-22 07:43:11', 3, 0, 0);
INSERT INTO `orders` VALUES (44, '1692659393289', 5, 1, 1, '2023-08-22 07:09:53', '2023-08-22 07:09:54', 1, 1, 273.00, '', '13645678897', '丈八六路一号', NULL, '爪爪', NULL, NULL, NULL, '2023-08-22 08:09:00', 0, '2023-08-22 07:43:11', 3, 0, 0);
INSERT INTO `orders` VALUES (45, '1692660765913', 6, 1, 1, '2023-08-22 07:32:46', '2023-08-22 07:32:47', 1, 1, 273.00, '', '13645678897', '丈八六路一号', NULL, '爪爪', NULL, '菜品已销售完，暂时无法接单', '2023-08-22 07:34:42', '2023-08-22 08:32:00', 0, NULL, 3, 0, 0);
INSERT INTO `orders` VALUES (46, '1692661204959', 5, 1, 1, '2023-08-22 07:40:05', '2023-08-22 07:40:06', 1, 1, 95.00, '', '13645678897', '丈八六路一号', NULL, '爪爪', NULL, NULL, NULL, '2023-08-22 08:40:00', 0, '2023-08-22 07:43:10', 1, 0, 0);
INSERT INTO `orders` VALUES (47, '1692661326638', 5, 1, 1, '2023-08-22 07:42:07', '2023-08-22 07:42:09', 1, 1, 273.00, '', '13645678897', '丈八六路一号', NULL, '爪爪', NULL, NULL, NULL, '2023-08-22 08:42:00', 0, '2023-08-22 07:43:10', 3, 0, 0);
INSERT INTO `orders` VALUES (48, '1692663548208', 5, 1, 1, '2023-08-22 08:19:08', '2023-08-22 08:19:09', 1, 1, 25.00, '', '13645678897', '丈八六路一号', NULL, '爪爪', NULL, NULL, NULL, '2023-08-22 09:19:00', 0, '2023-08-22 08:19:49', 1, 0, 0);
INSERT INTO `orders` VALUES (49, '1692663559430', 5, 1, 1, '2023-08-22 08:19:19', '2023-08-22 08:19:21', 1, 1, 311.00, '', '13645678897', '丈八六路一号', NULL, '爪爪', NULL, NULL, NULL, '2023-08-22 09:19:00', 0, '2023-08-22 08:19:49', 3, 0, 0);
INSERT INTO `orders` VALUES (50, '1692663569653', 5, 1, 1, '2023-08-22 08:19:30', '2023-08-22 08:19:31', 1, 1, 18.00, '', '13645678897', '丈八六路一号', NULL, '爪爪', NULL, NULL, NULL, '2023-08-22 09:19:00', 0, '2023-08-22 08:19:48', 2, 0, 0);
INSERT INTO `orders` VALUES (51, '1692663631363', 6, 1, 1, '2023-08-22 08:20:31', '2023-08-22 08:20:32', 1, 1, 95.00, '', '13645678897', '丈八六路一号', NULL, '爪爪', '骑手不足无法配送', NULL, '2023-08-22 10:33:07', '2023-08-22 09:20:00', 0, '2023-08-22 08:20:40', 1, 0, 0);
INSERT INTO `orders` VALUES (52, '1692663677621', 6, 1, 1, '2023-08-22 08:21:18', '2023-08-22 08:21:20', 1, 1, 240.00, '', '13645678897', '丈八六路一号', NULL, '爪爪', '订单量较多，暂时无法接单', NULL, '2023-08-22 10:32:58', '2023-08-22 09:21:00', 0, '2023-08-22 08:21:29', 6, 0, 0);
INSERT INTO `orders` VALUES (53, '1692664821631', 5, 1, 1, '2023-08-22 08:40:22', '2023-08-22 08:40:23', 1, 1, 95.00, '', '13645678897', '丈八六路一号', NULL, '爪爪', NULL, NULL, NULL, '2023-08-22 09:40:00', 0, '2023-12-02 09:21:51', 1, 0, 0);
INSERT INTO `orders` VALUES (54, '1692664832019', 5, 1, 1, '2023-08-22 08:40:32', '2023-08-22 08:40:33', 1, 1, 73.00, '', '13645678897', '丈八六路一号', NULL, '爪爪', NULL, NULL, NULL, '2023-08-22 09:40:00', 0, '2023-12-02 09:21:51', 1, 0, 0);
INSERT INTO `orders` VALUES (55, '1692664845622', 6, 1, 1, '2023-08-22 08:40:46', '2023-08-22 08:40:46', 1, 2, 45.00, '', '13645678897', '丈八六路一号', NULL, '爪爪', '用户取消', NULL, '2023-08-22 10:21:21', '2023-08-22 09:40:00', 0, NULL, 1, 0, 0);
INSERT INTO `orders` VALUES (56, '1692670886565', 5, 1, 1, '2023-08-22 10:21:27', '2023-08-22 10:21:28', 1, 1, 45.00, '', '13645678897', '丈八六路一号', NULL, '爪爪', NULL, NULL, NULL, '2023-08-22 11:21:00', 0, '2023-12-02 09:21:51', 1, 0, 0);
INSERT INTO `orders` VALUES (57, '1692671552293', 5, 1, 1, '2023-08-22 10:32:32', '2023-08-22 10:32:33', 1, 1, 45.00, '', '13645678897', '丈八六路一号', NULL, '爪爪', NULL, NULL, NULL, '2023-08-22 11:32:00', 0, '2023-12-02 09:21:51', 1, 0, 0);
INSERT INTO `orders` VALUES (58, '1692694671934', 5, 1, 1, '2023-08-22 16:57:52', '2023-08-22 16:57:52', 1, 1, 105.00, '', '13645678897', '丈八六路一号', NULL, '爪爪', NULL, NULL, NULL, '2023-08-22 17:57:00', 0, '2023-12-02 09:20:32', 1, 0, 0);
INSERT INTO `orders` VALUES (59, '1692694701204', 5, 1, 1, '2023-08-22 16:58:21', '2023-08-22 16:58:22', 1, 1, 95.00, '', '13645678897', '丈八六路一号', NULL, '爪爪', NULL, NULL, NULL, '2023-08-22 17:58:00', 0, '2023-12-02 09:20:33', 1, 0, 0);
INSERT INTO `orders` VALUES (60, '1692695412008', 5, 1, 1, '2023-08-22 17:10:12', '2023-08-22 17:10:20', 1, 1, 100.00, '', '13645678897', '丈八六路一号', NULL, '爪爪', NULL, NULL, NULL, '2023-08-22 18:10:00', 0, '2023-12-02 09:20:34', 2, 0, 0);
INSERT INTO `orders` VALUES (61, '1692698644610', 5, 1, 1, '2023-08-22 18:04:05', '2023-08-22 18:04:08', 1, 1, 100.00, '', '13645678897', '丈八六路一号', NULL, '爪爪', NULL, NULL, NULL, '2023-08-22 19:04:00', 0, '2023-12-02 09:21:50', 2, 0, 0);
INSERT INTO `orders` VALUES (62, '1692705246423', 5, 1, 1, '2023-08-22 19:54:06', '2023-08-22 19:54:07', 1, 1, 100.00, '', '13645678897', '丈八六路一号', NULL, '爪爪', NULL, NULL, NULL, '2023-08-22 20:54:00', 0, '2023-12-02 09:21:50', 2, 0, 0);
INSERT INTO `orders` VALUES (63, '1692705555725', 5, 1, 1, '2023-08-22 19:59:16', '2023-08-22 19:59:28', 1, 1, 446.00, '', '13645678897', '丈八六路一号', NULL, '爪爪', NULL, NULL, NULL, '2023-08-22 20:59:00', 0, '2023-08-22 20:00:54', 5, 0, 0);
INSERT INTO `orders` VALUES (64, '1692706050628', 5, 1, 1, '2023-08-22 20:07:31', '2023-08-22 20:07:52', 1, 1, 446.00, '', '13645678897', '丈八六路一号', NULL, '爪爪', NULL, NULL, NULL, '2023-08-22 21:07:00', 0, '2023-12-02 09:21:50', 5, 0, 0);
INSERT INTO `orders` VALUES (65, '1692706544817', 6, 1, 1, '2023-08-22 20:15:45', NULL, 1, 0, 95.00, '', '13645678897', '丈八六路一号', NULL, '爪爪', '订单超时，自动取消', NULL, '2023-08-22 21:05:00', '2023-08-22 21:15:00', 0, NULL, 1, 0, 0);
INSERT INTO `orders` VALUES (66, '1692706569803', 5, 1, 1, '2023-08-22 20:16:10', '2023-08-22 20:16:11', 1, 1, 95.00, '', '13645678897', '丈八六路一号', NULL, '爪爪', NULL, NULL, NULL, '2023-08-22 21:15:00', 0, '2023-12-02 09:20:36', 1, 10, 0);
INSERT INTO `orders` VALUES (67, '1692706866582', 5, 1, 1, '2023-08-22 20:21:07', '2023-08-22 20:21:08', 1, 1, 95.00, '', '13645678897', '丈八六路一号', NULL, '爪爪', NULL, NULL, NULL, '2023-08-22 21:21:00', 0, '2023-12-02 09:20:36', 1, 0, 0);
INSERT INTO `orders` VALUES (68, '1692709607017', 5, 1, 1, '2023-08-22 21:06:47', '2023-08-22 21:06:48', 1, 1, 534.00, '', '13645678897', '丈八六路一号', NULL, '爪爪', NULL, NULL, NULL, '2023-08-22 22:06:00', 0, '2023-08-22 21:07:37', 3, 0, 0);
INSERT INTO `orders` VALUES (69, '1692710263387', 5, 1, 1, '2023-08-22 21:17:43', '2023-08-22 21:17:47', 1, 1, 454.50, '', '13645678897', '丈八六路一号', NULL, '爪爪', NULL, NULL, NULL, '2023-08-22 22:17:00', 0, '2023-08-22 21:18:42', 4, 0, 0);
INSERT INTO `orders` VALUES (70, '1692710284080', 5, 1, 1, '2023-08-22 21:18:04', '2023-08-22 21:18:06', 1, 1, 454.50, '', '13645678897', '丈八六路一号', NULL, '爪爪', NULL, NULL, NULL, '2023-08-22 22:18:00', 0, '2023-08-22 21:19:07', 4, 0, 0);
INSERT INTO `orders` VALUES (71, '1692710381549', 5, 1, 1, '2023-08-22 21:19:42', '2023-08-22 21:19:44', 1, 1, 95.00, '', '13645678897', '丈八六路一号', NULL, '爪爪', NULL, NULL, NULL, '2023-08-22 22:19:00', 0, '2023-12-02 09:20:27', 1, 0, 0);
INSERT INTO `orders` VALUES (72, '1693114987782', 6, 1, 1, '2023-08-27 13:43:08', '2023-08-27 13:43:12', 1, 1, 95.00, '', '13645678897', '丈八六路一号', NULL, '爪爪', NULL, '餐厅已打烊，暂时无法接单', '2023-08-27 13:43:22', '2023-08-27 14:43:00', 0, NULL, 1, 0, 0);
INSERT INTO `orders` VALUES (73, '1693115030859', 5, 1, 1, '2023-08-27 13:43:51', '2023-08-27 13:43:52', 1, 1, 18.00, '', '13645678897', '丈八六路一号', NULL, '爪爪', NULL, NULL, NULL, '2023-08-27 14:43:00', 0, '2023-08-27 13:49:02', 2, 0, 0);
INSERT INTO `orders` VALUES (74, '1693571135568', 5, 1, 1, '2023-09-01 20:25:36', '2023-09-01 20:25:39', 1, 1, 25.00, '', '13645678897', '丈八六路一号', NULL, '爪爪', NULL, NULL, NULL, '2023-09-01 21:25:00', 0, '2023-09-01 20:26:52', 1, 0, 0);
INSERT INTO `orders` VALUES (75, '1693731632510', 5, 1, 1, '2023-09-03 17:00:33', '2023-09-03 17:00:34', 1, 1, 45.00, '', '13645678897', '丈八六路一号', NULL, '爪爪', NULL, NULL, NULL, '2023-09-03 18:00:00', 0, '2023-12-02 09:20:28', 1, 0, 0);
INSERT INTO `orders` VALUES (76, '1693739196832', 5, 1, 1, '2023-09-03 19:06:37', '2023-09-03 19:06:38', 1, 1, 184.00, '', '13645678897', '丈八六路一号', NULL, '爪爪', NULL, NULL, NULL, '2023-09-03 20:06:00', 0, '2023-12-02 09:20:28', 2, 0, 0);
INSERT INTO `orders` VALUES (77, '1694014152221', 6, 1, 1, '2023-09-06 23:29:12', '2023-09-06 23:29:14', 1, 2, 95.00, '', '13645678897', '丈八六路一号', NULL, '爪爪', '用户取消', NULL, '2023-09-06 23:29:17', '2023-09-06 00:29:00', 0, NULL, 1, 0, 0);
INSERT INTO `orders` VALUES (78, '1694014186054', 5, 1, 1, '2023-09-06 23:29:46', '2023-09-06 23:29:48', 1, 1, 95.00, '', '13645678897', '丈八六路一号', NULL, '爪爪', NULL, NULL, NULL, '2023-09-06 00:29:00', 0, '2023-12-02 09:20:23', 1, 0, 0);
INSERT INTO `orders` VALUES (79, '1694014264015', 5, 1, 1, '2023-09-06 23:31:04', '2023-09-06 23:31:04', 1, 1, 95.00, '', '13645678897', '丈八六路一号', NULL, '爪爪', NULL, NULL, NULL, '2023-09-06 00:31:00', 0, '2023-11-14 20:39:28', 1, 0, 0);
INSERT INTO `orders` VALUES (80, '1694517790156', 6, 1, 1, '2023-09-12 19:23:10', '2023-09-12 19:23:14', 1, 1, 95.00, '', '13645678897', '丈八六路一号', NULL, '爪爪', '订单量较多，暂时无法接单', NULL, '2023-09-21 22:30:41', '2023-09-12 20:23:00', 0, NULL, 1, 0, 0);
INSERT INTO `orders` VALUES (81, '1695735887499', 6, 1, 1, '2023-09-26 21:44:47', '2023-09-26 21:44:50', 1, 1, 95.00, '', '13645678897', '丈八六路一号', NULL, '爪爪', NULL, '餐厅已打烊，暂时无法接单', '2023-10-01 08:35:01', '2023-09-26 22:44:00', 0, NULL, 1, 0, 0);
INSERT INTO `orders` VALUES (82, '1696934382124', 5, 1, 1, '2023-10-10 18:39:42', '2023-10-10 18:39:43', 1, 1, 95.00, '', '13645678897', '丈八六路一号', NULL, '爪爪', NULL, NULL, NULL, '2023-10-10 19:39:00', 0, '2023-11-14 20:39:27', 1, 0, 0);
INSERT INTO `orders` VALUES (83, '1697095041921', 5, 1, 1, '2023-10-12 15:17:22', '2023-10-12 15:17:23', 1, 1, 95.00, '', '13645678897', '丈八六路一号', NULL, '爪爪', NULL, NULL, NULL, '2023-10-12 16:17:00', 0, '2023-11-14 20:39:27', 1, 0, 0);
INSERT INTO `orders` VALUES (84, '1697605335288', 5, 1, 1, '2023-10-18 13:02:15', '2023-10-18 13:02:54', 1, 1, 95.00, '', '13645678897', '丈八六路一号', NULL, '爪爪', NULL, NULL, NULL, '2023-10-18 14:02:00', 0, '2023-11-14 20:39:26', 1, 0, 0);
INSERT INTO `orders` VALUES (85, '1698063224764', 6, 1, 1, '2023-10-23 20:13:45', '2023-10-23 20:13:47', 1, 1, 13.00, '', '13645678897', '丈八六路一号', NULL, '爪爪', '菜品已销售完，暂时无法接单', NULL, '2023-10-23 20:17:00', '2023-10-23 21:13:00', 0, '2023-10-23 20:16:48', 1, 0, 0);
INSERT INTO `orders` VALUES (86, '1699198587035', 5, 1, 1, '2023-11-05 23:36:27', '2023-11-05 23:36:29', 1, 1, 73.00, '', '13645678897', '丈八六路一号', NULL, '爪爪', NULL, NULL, NULL, '2023-11-05 00:36:00', 0, '2023-11-14 20:39:26', 1, 0, 0);
INSERT INTO `orders` VALUES (87, '1699373580006', 5, 1, 1, '2023-11-08 00:13:00', '2023-11-08 00:13:01', 1, 1, 207.00, '', '13645678897', '丈八六路一号', NULL, '爪爪', NULL, NULL, NULL, '2023-11-08 01:12:00', 0, '2023-11-14 20:39:26', 1, 0, 0);
INSERT INTO `orders` VALUES (88, '1699967647298', 6, 1, 1, '2023-11-14 21:14:07', '2023-11-14 21:14:09', 1, 1, 13.00, '', '13645678897', '丈八六路一号', NULL, '爪爪', '订单量较多，暂时无法接单', NULL, '2023-12-03 13:35:03', '2023-11-14 22:14:00', 0, '2023-12-03 13:23:55', 1, 0, 0);
INSERT INTO `orders` VALUES (89, '1701582077636', 6, 1, 1, '2023-12-03 13:41:18', '2023-12-03 13:41:23', 1, 2, 57.00, '', '13645678897', '丈八六路一号', NULL, '爪爪', '用户取消', NULL, '2023-12-03 13:41:30', '2023-12-03 14:41:00', 0, NULL, 1, 0, 0);
INSERT INTO `orders` VALUES (90, '1701582151351', 5, 1, 1, '2023-12-03 13:42:31', '2023-12-03 13:42:33', 1, 1, 146.00, '', '13645678897', '丈八六路一号', NULL, '爪爪', NULL, NULL, NULL, '2023-12-03 14:42:00', 0, '2023-12-02 09:20:15', 2, 0, 0);
INSERT INTO `orders` VALUES (91, '1701763315720', 6, 1, 1, '2023-12-05 16:01:56', '2023-12-05 16:01:58', 1, 2, 95.00, '', '13645678897', '丈八六路一号', NULL, '爪爪', '用户取消', NULL, '2023-12-05 16:02:53', '2023-12-05 17:01:00', 0, NULL, 1, 0, 0);
INSERT INTO `orders` VALUES (92, '1701785277479', 5, 1, 1, '2023-12-05 22:07:57', '2023-12-05 22:07:58', 1, 1, 13.00, '', '13645678897', '丈八六路一号', NULL, '爪爪', NULL, NULL, NULL, '2023-12-05 23:07:00', 0, '2023-12-05 22:09:33', 1, 0, 0);
INSERT INTO `orders` VALUES (93, '1701440339303', 5, 1, 1, '2023-12-01 22:18:59', '2023-12-01 22:19:00', 1, 1, 184.00, '', '13645678897', '丈八六路一号', NULL, '爪爪', NULL, NULL, NULL, '2023-12-01 23:18:00', 0, '2023-12-02 09:20:21', 2, 0, 0);
INSERT INTO `orders` VALUES (94, '1701440359792', 5, 1, 1, '2023-12-01 22:19:20', '2023-12-01 22:19:21', 1, 1, 45.00, '', '13645678897', '丈八六路一号', NULL, '爪爪', NULL, NULL, NULL, '2023-12-01 23:19:00', 0, '2023-12-02 09:20:20', 1, 0, 0);
INSERT INTO `orders` VALUES (95, '1701440377071', 5, 1, 1, '2023-12-01 22:19:37', '2023-12-01 22:19:38', 1, 1, 480.50, '', '13645678897', '丈八六路一号', NULL, '爪爪', NULL, NULL, NULL, '2023-12-01 23:19:00', 0, '2023-12-02 09:20:19', 6, 0, 0);
INSERT INTO `orders` VALUES (96, '1701479993978', 5, 1, 1, '2023-12-02 09:19:54', '2023-12-02 09:19:55', 1, 1, 480.50, '', '13645678897', '丈八六路一号', NULL, '爪爪', NULL, NULL, NULL, '2023-12-01 23:19:00', 0, '2023-12-02 09:20:17', 6, 0, 0);
INSERT INTO `orders` VALUES (97, '1701480004609', 5, 1, 1, '2023-12-02 09:20:05', '2023-12-02 09:20:07', 1, 1, 480.50, '', '13645678897', '丈八六路一号', NULL, '爪爪', NULL, NULL, NULL, '2023-12-01 23:20:00', 0, '2023-12-02 09:20:16', 6, 0, 0);
INSERT INTO `orders` VALUES (98, '1701480092139', 5, 1, 1, '2023-12-02 09:21:32', '2023-12-02 09:21:32', 1, 1, 92.00, '', '13645678897', '丈八六路一号', NULL, '爪爪', NULL, NULL, NULL, '2023-12-02 10:21:00', 0, '2023-12-02 09:21:50', 2, 0, 0);
INSERT INTO `orders` VALUES (99, '1701480133835', 5, 1, 1, '2023-12-02 09:22:14', '2023-12-02 09:22:16', 1, 1, 52.00, '', '13645678897', '丈八六路一号', NULL, '爪爪', NULL, NULL, NULL, '2023-12-02 10:22:00', 0, '2023-12-03 09:23:36', 2, 0, 0);
INSERT INTO `orders` VALUES (100, '1701480155234', 5, 1, 1, '2023-12-02 09:22:35', '2023-12-02 09:22:36', 1, 1, 941.00, '', '13645678897', '丈八六路一号', NULL, '爪爪', NULL, NULL, NULL, '2023-12-02 10:22:00', 0, '2023-12-03 09:23:35', 9, 0, 0);
INSERT INTO `orders` VALUES (101, '1701566595888', 5, 1, 1, '2023-12-03 09:23:16', '2023-12-03 09:23:18', 1, 1, 388.00, '', '13645678897', '丈八六路一号', NULL, '爪爪', NULL, NULL, NULL, '2023-12-02 10:23:00', 0, '2023-12-03 09:23:34', 8, 0, 0);
INSERT INTO `orders` VALUES (102, '1701566631291', 5, 1, 1, '2023-12-03 09:23:51', '2023-12-03 09:23:52', 1, 1, 95.00, '', '13645678897', '丈八六路一号', NULL, '爪爪', NULL, NULL, NULL, '2023-12-03 10:23:00', 0, '2023-12-04 09:24:40', 1, 0, 0);
INSERT INTO `orders` VALUES (103, '1701653068944', 5, 1, 1, '2023-12-04 09:24:29', '2023-12-04 09:24:30', 1, 1, 476.00, '', '13645678897', '丈八六路一号', NULL, '爪爪', NULL, NULL, NULL, '2023-12-04 10:24:00', 0, '2023-12-04 09:24:38', 5, 0, 0);
INSERT INTO `orders` VALUES (104, '1701786365612', 5, 1, 1, '2023-12-05 22:26:06', '2023-12-05 22:26:06', 1, 1, 95.00, '', '13645678897', '丈八六路一号', NULL, '爪爪', NULL, NULL, NULL, '2023-12-05 23:26:00', 0, '2023-12-05 22:26:19', 1, 0, 0);
INSERT INTO `orders` VALUES (105, '1701961743673', 5, 1, 1, '2023-12-07 23:09:04', '2023-12-07 23:09:05', 1, 1, 126.00, '', '13645678897', '丈八六路一号', NULL, '爪爪', NULL, NULL, NULL, '2023-12-07 00:09:00', 0, '2023-12-12 17:42:59', 1, 0, 0);
INSERT INTO `orders` VALUES (106, '1701961766026', 5, 1, 1, '2023-12-07 23:09:26', '2023-12-07 23:09:27', 1, 1, 126.00, '', '13645678897', '丈八六路一号', NULL, '爪爪', NULL, NULL, NULL, '2023-12-07 00:09:00', 0, '2023-12-12 17:42:58', 1, 0, 0);
INSERT INTO `orders` VALUES (107, '1701961792345', 5, 1, 1, '2023-12-07 23:09:52', '2023-12-07 23:09:53', 1, 1, 145.00, '', '13645678897', '丈八六路一号', NULL, '爪爪', NULL, NULL, NULL, '2023-12-07 00:09:00', 0, NULL, 4, 0, 0);
INSERT INTO `orders` VALUES (108, '1701961801301', 5, 1, 1, '2023-12-07 23:10:01', '2023-12-07 23:10:03', 1, 1, 311.00, '', '13645678897', '丈八六路一号', NULL, '爪爪', NULL, NULL, NULL, '2023-12-07 00:10:00', 0, '2023-12-07 23:10:26', 3, 0, 0);
INSERT INTO `orders` VALUES (109, '1702004659732', 5, 1, 1, '2023-12-08 11:04:20', '2023-12-08 11:04:46', 1, 1, 309.00, '', '13645678897', '丈八六路一号', NULL, '爪爪', NULL, NULL, NULL, '2023-12-08 12:03:00', 0, '2023-12-08 12:57:18', 7, 0, 0);
INSERT INTO `orders` VALUES (110, '1702011398638', 5, 1, 1, '2023-12-08 12:56:39', '2023-12-08 12:56:40', 1, 1, 25.00, '', '13645678897', '丈八六路一号', NULL, '爪爪', NULL, NULL, NULL, '2023-12-08 13:56:00', 0, '2023-12-12 17:42:58', 1, 0, 0);
INSERT INTO `orders` VALUES (111, '1702014586810', 6, 1, 1, '2023-12-08 13:49:47', '2023-12-08 13:49:51', 1, 2, 25.00, '', '13645678897', '丈八六路一号', NULL, '爪爪', '用户取消', NULL, '2023-12-10 13:24:50', '2023-12-08 14:49:00', 0, NULL, 1, 0, 0);
INSERT INTO `orders` VALUES (112, '1702184841467', 6, 1, 1, '2023-12-10 13:07:21', '2023-12-10 13:07:34', 1, 1, 176.00, '', '13645678897', '丈八六路一号', NULL, '爪爪', 'test', NULL, '2023-12-10 13:25:38', '2023-12-10 14:07:00', 0, '2023-12-10 13:09:06', 4, 0, 0);
INSERT INTO `orders` VALUES (113, '1702204395250', 5, 1, 1, '2023-12-10 18:33:15', '2023-12-10 18:33:17', 1, 1, 518.00, '', '13645678897', '丈八六路一号', NULL, '爪爪', NULL, NULL, NULL, '2023-12-10 19:33:00', 0, '2023-12-10 18:33:25', 3, 0, 0);
INSERT INTO `orders` VALUES (114, '1702204431068', 5, 1, 1, '2023-12-10 18:33:51', '2023-12-10 18:33:52', 1, 1, 46.90, '', '13645678897', '丈八六路一号', NULL, '爪爪', NULL, NULL, NULL, '2023-12-10 19:33:00', 0, '2023-12-12 17:42:58', 1, 0, 0);
INSERT INTO `orders` VALUES (115, '1702374087851', 5, 1, 1, '2023-12-12 17:41:28', '2023-12-12 17:41:30', 1, 1, 57.00, '', '13645678897', '丈八六路一号', NULL, '爪爪', NULL, NULL, NULL, '2023-12-12 18:41:00', 0, '2023-12-12 17:42:58', 1, 0, 0);
INSERT INTO `orders` VALUES (116, '1702374224027', 2, 1, 1, '2023-12-12 17:43:44', '2023-12-12 17:43:45', 1, 1, 44.80, '', '13645678897', '丈八六路一号', NULL, '爪爪', NULL, NULL, NULL, '2023-12-12 18:43:00', 0, NULL, 4, 0, 0);
INSERT INTO `orders` VALUES (117, '1702374308104', 3, 1, 1, '2023-12-12 17:45:08', '2023-12-12 17:45:09', 1, 1, 406.00, '', '13645678897', '丈八六路一号', NULL, '爪爪', NULL, NULL, NULL, '2023-12-12 18:45:00', 0, NULL, 1, 0, 0);
INSERT INTO `orders` VALUES (118, '1702374342000', 4, 1, 1, '2023-12-12 17:45:42', '2023-12-12 17:45:47', 1, 1, 175.00, '', '13645678897', '丈八六路一号', NULL, '爪爪', NULL, NULL, NULL, '2023-12-12 18:45:00', 0, NULL, 1, 0, 0);
INSERT INTO `orders` VALUES (119, '1702380799901', 3, 1, 1, '2023-12-12 19:33:20', '2023-12-12 19:33:21', 1, 1, 575.00, '', '13645678897', '丈八六路一号', NULL, '爪爪', NULL, NULL, NULL, '2023-12-12 20:33:00', 0, NULL, 2, 0, 0);
INSERT INTO `orders` VALUES (120, '1702382698679', 3, 1, 1, '2023-12-12 20:04:59', '2023-12-12 20:05:01', 1, 1, 406.00, '', '13645678897', '丈八六路一号', NULL, '爪爪', NULL, NULL, NULL, '2023-12-12 21:04:00', 0, NULL, 1, 0, 0);
INSERT INTO `orders` VALUES (121, '1702382728537', 4, 1, 1, '2023-12-12 20:05:29', '2023-12-12 20:05:29', 1, 1, 57.00, '', '13645678897', '丈八六路一号', NULL, '爪爪', NULL, NULL, NULL, '2023-12-12 21:05:00', 0, NULL, 1, 0, 0);
INSERT INTO `orders` VALUES (122, '1702388226271', 6, 1, 1, '2023-12-12 21:37:06', '2023-12-12 21:37:07', 1, 2, 406.00, '', '13645678897', '丈八六路一号', NULL, '爪爪', '用户取消', NULL, '2023-12-12 21:37:24', '2023-12-12 22:37:00', 0, NULL, 1, 0, 0);
INSERT INTO `orders` VALUES (123, '1702388249006', 3, 1, 1, '2023-12-12 21:37:29', '2023-12-12 21:37:30', 1, 1, 406.00, '', '13645678897', '丈八六路一号', NULL, '爪爪', NULL, NULL, NULL, '2023-12-12 22:37:00', 0, NULL, 1, 0, 0);
INSERT INTO `orders` VALUES (124, '1702388422026', 2, 1, 1, '2023-12-12 21:40:22', '2023-12-12 21:40:24', 1, 1, 406.00, '', '13645678897', '丈八六路一号', NULL, '爪爪', NULL, NULL, NULL, '2023-12-12 22:40:00', 0, NULL, 1, 0, 0);
INSERT INTO `orders` VALUES (125, '1702389421351', 2, 1, 1, '2023-12-12 21:57:01', '2023-12-12 21:57:03', 1, 1, 406.00, '', '13645678897', '丈八六路一号', NULL, '爪爪', NULL, NULL, NULL, '2023-12-12 22:56:00', 0, NULL, 1, 0, 0);
INSERT INTO `orders` VALUES (126, '1702546856912', 5, 1, 1, '2023-12-14 17:40:57', '2023-12-14 17:40:58', 1, 1, 518.00, '', '13645678897', '丈八六路一号', NULL, '爪爪', NULL, NULL, NULL, '2023-12-14 18:40:00', 0, '2023-12-14 17:41:14', 3, 0, 0);
INSERT INTO `orders` VALUES (127, '1702603066524', 2, 1, 1, '2023-12-15 09:17:47', '2023-12-15 09:17:50', 1, 1, 207.00, '', '13645678897', '丈八六路一号', NULL, '爪爪', NULL, NULL, NULL, '2023-12-15 10:17:00', 0, NULL, 1, 0, 0);
INSERT INTO `orders` VALUES (128, '1702707937682', 2, 1, 1, '2023-12-16 14:25:38', '2023-12-16 14:25:40', 1, 1, 17.00, '', '13645678897', '丈八六路一号', NULL, '爪爪', NULL, NULL, NULL, '2023-12-16 15:25:00', 0, NULL, 1, 0, 0);
INSERT INTO `orders` VALUES (129, '1703214255354', 2, 1, 1, '2023-12-22 11:04:15', '2023-12-22 11:04:16', 1, 1, 406.00, '', '13645678897', '丈八六路一号', NULL, '爪爪', NULL, NULL, NULL, '2023-12-22 12:04:00', 0, NULL, 1, 0, 0);
INSERT INTO `orders` VALUES (130, '1703739870259', 3, 1, 1, '2023-12-28 13:04:30', '2023-12-28 13:04:31', 1, 1, 26.99, '', '13645678897', '丈八六路一号', NULL, '爪爪', NULL, NULL, NULL, '2023-12-28 14:04:00', 0, NULL, 1, 0, 0);
INSERT INTO `orders` VALUES (131, '1703739899989', 3, 1, 1, '2023-12-28 13:05:00', '2023-12-28 13:05:01', 1, 1, 26.99, '', '13645678897', '丈八六路一号', NULL, '爪爪', NULL, NULL, NULL, '2023-12-28 14:04:00', 0, NULL, 1, 0, 0);
INSERT INTO `orders` VALUES (132, '1706183570664', 2, 1, 1, '2024-01-25 19:52:51', '2024-01-25 19:52:58', 1, 1, 207.00, '', '13645678897', '丈八六路一号', NULL, '爪爪', NULL, NULL, NULL, '2024-01-25 20:52:00', 0, NULL, 1, 0, 0);
INSERT INTO `orders` VALUES (133, '1711603965056', 2, 1, 1, '2024-03-28 13:32:45', '2024-03-28 13:32:46', 1, 1, 46.90, '', '13645678897', '丈八六路一号', NULL, '爪爪', NULL, NULL, NULL, '2024-03-28 14:32:00', 0, NULL, 1, 0, 0);

-- ----------------------------
-- Table structure for setmeal
-- ----------------------------
DROP TABLE IF EXISTS `setmeal`;
CREATE TABLE `setmeal`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `category_id` bigint(20) NOT NULL COMMENT '菜品分类id',
  `name` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '套餐名称',
  `price` decimal(10, 2) NOT NULL COMMENT '套餐价格',
  `status` int(11) NULL DEFAULT 1 COMMENT '售卖状态 0:停售 1:起售',
  `description` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '描述信息',
  `image` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '图片',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
  `create_user` bigint(20) NULL DEFAULT NULL COMMENT '创建人',
  `update_user` bigint(20) NULL DEFAULT NULL COMMENT '修改人',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `idx_setmeal_name`(`name`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 10 CHARACTER SET = utf8 COLLATE = utf8_bin COMMENT = '套餐' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of setmeal
-- ----------------------------
INSERT INTO `setmeal` VALUES (5, 15, '商务套餐', 200.00, 1, '', 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/dc03fad5-0b4d-4264-8223-0ca700ad0dfd.png', '2023-08-11 11:10:50', '2023-08-11 11:10:50', 1, 1);
INSERT INTO `setmeal` VALUES (6, 13, '人气套餐', 399.00, 1, '好吃便宜', 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/532eea35-dce8-412b-a062-97c084885545.png', '2023-08-16 20:08:02', '2023-08-27 13:49:55', 1, 1);
INSERT INTO `setmeal` VALUES (7, 13, '东坡肘子', 50.00, 1, '东坡肘子肉', 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/b3273a85-4e84-4de4-b528-19386fd6e630.png', '2023-08-18 08:23:21', '2023-12-03 12:58:54', 1, 1);
INSERT INTO `setmeal` VALUES (8, 13, '水煮鱼套餐', 60.00, 1, '经典蜀味水煮鱼', 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/c2a67941-508d-4fde-add6-bc2440935da0.png', '2023-12-03 13:09:22', '2023-12-10 18:12:36', 1, 1);
INSERT INTO `setmeal` VALUES (9, 25, '汉堡五件套', 39.90, 1, '聚划算', 'https://sky-take-out-stringzhua.oss-cn-hangzhou.aliyuncs.com/5f519597-233f-46cb-9281-6b6440939bb4.jpg', '2023-12-10 18:29:47', '2024-03-28 13:32:19', 1, 1);

-- ----------------------------
-- Table structure for setmeal_dish
-- ----------------------------
DROP TABLE IF EXISTS `setmeal_dish`;
CREATE TABLE `setmeal_dish`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `setmeal_id` bigint(20) NULL DEFAULT NULL COMMENT '套餐id',
  `dish_id` bigint(20) NULL DEFAULT NULL COMMENT '菜品id',
  `name` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '菜品名称 （冗余字段）',
  `price` decimal(10, 2) NULL DEFAULT NULL COMMENT '菜品单价（冗余字段）',
  `copies` int(11) NULL DEFAULT NULL COMMENT '菜品份数',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 41 CHARACTER SET = utf8 COLLATE = utf8_bin COMMENT = '套餐菜品关系' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of setmeal_dish
-- ----------------------------
INSERT INTO `setmeal_dish` VALUES (16, 5, 62, '金汤酸菜牛蛙', 88.00, 1);
INSERT INTO `setmeal_dish` VALUES (23, 6, 55, '蒜蓉娃娃菜', 18.00, 1);
INSERT INTO `setmeal_dish` VALUES (24, 6, 64, '馋嘴牛蛙', 88.00, 1);
INSERT INTO `setmeal_dish` VALUES (25, 6, 62, '金汤酸菜牛蛙', 88.00, 1);
INSERT INTO `setmeal_dish` VALUES (26, 7, 59, '东坡肘子', 138.00, 1);
INSERT INTO `setmeal_dish` VALUES (27, 7, 55, '蒜蓉娃娃菜', 18.00, 1);
INSERT INTO `setmeal_dish` VALUES (28, 7, 49, '米饭', 6.00, 1);
INSERT INTO `setmeal_dish` VALUES (29, 7, 48, '雪花啤酒', 4.00, 1);
INSERT INTO `setmeal_dish` VALUES (30, 7, 46, '王老吉', 6.00, 1);
INSERT INTO `setmeal_dish` VALUES (31, 7, 68, '鸡蛋汤', 4.00, 1);
INSERT INTO `setmeal_dish` VALUES (32, 8, 53, '蜀味水煮草鱼', 38.00, 1);
INSERT INTO `setmeal_dish` VALUES (33, 8, 49, '米饭', 6.00, 1);
INSERT INTO `setmeal_dish` VALUES (34, 8, 71, '北冰洋', 3.50, 1);
INSERT INTO `setmeal_dish` VALUES (35, 8, 69, '平菇豆腐', 6.00, 1);
INSERT INTO `setmeal_dish` VALUES (36, 9, 76, '巨无霸汉堡', 29.90, 1);
INSERT INTO `setmeal_dish` VALUES (37, 9, 77, '冰柠可乐', 3.00, 1);
INSERT INTO `setmeal_dish` VALUES (38, 9, 78, '炸鸡', 20.00, 1);
INSERT INTO `setmeal_dish` VALUES (39, 9, 80, '双排鸡柳汉堡', 7.90, 1);
INSERT INTO `setmeal_dish` VALUES (40, 9, 81, '薯条', 3.90, 1);

-- ----------------------------
-- Table structure for shopping_cart
-- ----------------------------
DROP TABLE IF EXISTS `shopping_cart`;
CREATE TABLE `shopping_cart`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `name` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '商品名称',
  `image` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '图片',
  `user_id` bigint(20) NOT NULL COMMENT '主键',
  `dish_id` bigint(20) NULL DEFAULT NULL COMMENT '菜品id',
  `setmeal_id` bigint(20) NULL DEFAULT NULL COMMENT '套餐id',
  `dish_flavor` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '口味',
  `number` int(11) NOT NULL DEFAULT 1 COMMENT '数量',
  `amount` decimal(10, 2) NOT NULL COMMENT '金额',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_bin COMMENT = '购物车' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of shopping_cart
-- ----------------------------

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `openid` varchar(45) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '微信用户唯一标识',
  `name` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '姓名',
  `phone` varchar(11) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '手机号',
  `sex` varchar(2) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '性别',
  `id_number` varchar(18) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '身份证号',
  `avatar` varchar(500) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '头像',
  `create_time` datetime NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8 COLLATE = utf8_bin COMMENT = '用户信息' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES (1, 'okP6E64uoh_z7XvlDFDmmDKkUhLI', 'Stringzhua', '15891678338', '', NULL, NULL, '2023-08-17 13:52:05');
INSERT INTO `user` VALUES (2, 'okP6E64uoh_z7XvlDFDmmDKkUh', '张三', '13582769566', NULL, NULL, NULL, '2023-12-06 16:45:59');
INSERT INTO `user` VALUES (3, 'gdgfhfhtgbdfbbgf', '李四', '15897643526', NULL, NULL, NULL, '2023-12-06 00:26:46');
INSERT INTO `user` VALUES (4, 'fcsdfsfsdfs', '王五', '15891678332', NULL, NULL, NULL, '2023-12-10 18:37:50');

SET FOREIGN_KEY_CHECKS = 1;