sql

已于 2023-08-11 17:45:10 修改
阅读量56 收藏
点赞数
文章标签： 学习
于 2023-06-30 11:39:25 首次发布
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/weixin_47296176/article/details/131460848
版权

/*
Navicat Premium Data Transfer

Source Server : localhost_3306
Source Server Type : MySQL
Source Server Version : 50735
Source Host : localhost:3306
Source Schema : sky_take_out

Target Server Type : MySQL
Target Server Version : 50735
File Encoding : 65001

Date: 11/08/2023 14:19:06
*/

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 = 5 CHARACTER SET = utf8 COLLATE = utf8_bin COMMENT = ‘地址簿’ ROW_FORMAT = Dynamic;

– Records of address_book

INSERT INTO address_book VALUES (3, 4, ‘tan’, ‘0’, ‘13423555754’, ‘44’, ‘广东省’, ‘4401’, ‘广州市’, ‘440114’, ‘花都区’, ‘赤泥镇广东培正学院’, ‘3’, 1);
INSERT INTO address_book VALUES (4, 4, ‘1122’, ‘0’, ‘13423555456’, ‘32’, ‘江苏省’, ‘3201’, ‘南京市’, ‘320102’, ‘玄武区’, ‘sas’, ‘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 = 24 CHARACTER SET = utf8 COLLATE = utf8_bin COMMENT = ‘菜品及套餐分类’ ROW_FORMAT = Dynamic;

– Records of category

INSERT INTO category VALUES (11, 1, ‘酒水饮料’, 10, 1, ‘2022-06-09 22:09:18’, ‘2022-06-09 22:09:18’, 1, 1);
INSERT INTO category VALUES (12, 1, ‘传统主食’, 9, 1, ‘2022-06-09 22:09:32’, ‘2022-06-09 22:18:53’, 1, 1);
INSERT INTO category VALUES (13, 2, ‘人气套餐’, 12, 1, ‘2022-06-09 22:11:38’, ‘2022-06-10 11:04:40’, 1, 1);
INSERT INTO category VALUES (15, 2, ‘商务套餐’, 13, 1, ‘2022-06-09 22:14:10’, ‘2022-06-10 11:04:48’, 1, 1);
INSERT INTO category VALUES (16, 1, ‘蜀味烤鱼’, 4, 1, ‘2022-06-09 22:15:37’, ‘2022-08-31 14:27:25’, 1, 1);
INSERT INTO category VALUES (17, 1, ‘蜀味牛蛙’, 5, 1, ‘2022-06-09 22:16:14’, ‘2022-08-31 14:39:44’, 1, 1);
INSERT INTO category VALUES (18, 1, ‘特色蒸菜’, 6, 1, ‘2022-06-09 22:17:42’, ‘2022-06-09 22:17:42’, 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, ‘汤类’, 12, 1, ‘2022-06-10 10:51:47’, ‘2023-07-27 09:58:19’, 1, 1);
INSERT INTO category VALUES (23, 1, ‘火锅’, 1, 1, ‘2023-07-27 10:02:55’, ‘2023-07-27 10:03:39’, 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 = 70 CHARACTER SET = utf8 COLLATE = utf8_bin COMMENT = ‘菜品’ ROW_FORMAT = Dynamic;

– Records of dish

INSERT INTO dish VALUES (46, ‘王老吉’, 11, 6.00, ‘https://sky-itcast.oss-cn-beijing.aliyuncs.com/41bfcacf-7ad4-4927-8b26-df366553a94c.png’, ‘’, 1, ‘2022-06-09 22:40:47’, ‘2022-06-09 22:40:47’, 1, 1);
INSERT INTO dish VALUES (47, ‘北冰洋’, 11, 4.00, ‘https://sky-itcast.oss-cn-beijing.aliyuncs.com/4451d4be-89a2-4939-9c69-3a87151cb979.png’, ‘还是小时候的味道’, 1, ‘2022-06-10 09:18:49’, ‘2022-06-10 09:18:49’, 1, 1);
INSERT INTO dish VALUES (48, ‘雪花啤酒’, 11, 4.00, ‘https://sky-itcast.oss-cn-beijing.aliyuncs.com/bf8cbfc1-04d2-40e8-9826-061ee41ab87c.png’, ‘’, 1, ‘2022-06-10 09:22:54’, ‘2023-07-31 17:21:31’, 1, 1);
INSERT INTO dish VALUES (49, ‘珍珠米饭’, 12, 5.00, ‘https://sky-itcast.oss-cn-beijing.aliyuncs.com/76752350-2121-44d2-b477-10791c23a8ec.png’, ‘精选五常大米’, 1, ‘2022-06-10 09:30:17’, ‘2023-07-31 17:20:07’, 1, 1);
INSERT INTO dish VALUES (50, ‘馒头’, 12, 1.00, ‘https://sky-itcast.oss-cn-beijing.aliyuncs.com/475cc599-8661-4899-8f9e-121dd8ef7d02.png’, ‘优质面粉’, 1, ‘2022-06-10 09:34:28’, ‘2022-06-10 09:34:28’, 1, 1);
INSERT INTO dish VALUES (51, ‘老坛酸菜鱼’, 20, 56.00, ‘https://sky-itcast.oss-cn-beijing.aliyuncs.com/4a9cefba-6a74-467e-9fde-6e687ea725d7.png’, ‘原料：汤，草鱼，酸菜’, 1, ‘2022-06-10 09:40:51’, ‘2023-07-28 10:40:53’, 1, 1);
INSERT INTO dish VALUES (52, ‘经典酸菜鮰鱼’, 20, 66.00, ‘https://sky-itcast.oss-cn-beijing.aliyuncs.com/5260ff39-986c-4a97-8850-2ec8c7583efc.png’, ‘原料：酸菜，江团，鮰鱼’, 1, ‘2022-06-10 09:46:02’, ‘2022-06-10 09:46:02’, 1, 1);
INSERT INTO dish VALUES (53, ‘蜀味水煮草鱼’, 20, 38.00, ‘https://sky-itcast.oss-cn-beijing.aliyuncs.com/a6953d5a-4c18-4b30-9319-4926ee77261f.png’, ‘原料：草鱼，汤’, 1, ‘2022-06-10 09:48:37’, ‘2022-06-10 09:48:37’, 1, 1);
INSERT INTO dish VALUES (54, ‘清炒小油菜’, 19, 18.00, ‘https://sky-itcast.oss-cn-beijing.aliyuncs.com/3613d38e-5614-41c2-90ed-ff175bf50716.png’, ‘原料：小油菜’, 1, ‘2022-06-10 09:51:46’, ‘2023-07-28 10:22:41’, 1, 1);
INSERT INTO dish VALUES (55, ‘蒜蓉娃娃菜’, 19, 18.00, ‘https://sky-itcast.oss-cn-beijing.aliyuncs.com/4879ed66-3860-4b28-ba14-306ac025fdec.png’, ‘原料：蒜，娃娃菜’, 1, ‘2022-06-10 09:53:37’, ‘2022-06-10 09:53:37’, 1, 1);
INSERT INTO dish VALUES (56, ‘清炒西兰花’, 19, 18.00, ‘https://sky-itcast.oss-cn-beijing.aliyuncs.com/e9ec4ba4-4b22-4fc8-9be0-4946e6aeb937.png’, ‘原料：西兰花’, 1, ‘2022-06-10 09:55:44’, ‘2022-06-10 09:55:44’, 1, 1);
INSERT INTO dish VALUES (57, ‘炝炒圆白菜’, 19, 18.00, ‘https://sky-itcast.oss-cn-beijing.aliyuncs.com/22f59feb-0d44-430e-a6cd-6a49f27453ca.png’, ‘原料：圆白菜’, 1, ‘2022-06-10 09:58:35’, ‘2022-06-10 09:58:35’, 1, 1);
INSERT INTO dish VALUES (58, ‘清蒸鲈鱼’, 18, 98.00, ‘https://sky-itcast.oss-cn-beijing.aliyuncs.com/c18b5c67-3b71-466c-a75a-e63c6449f21c.png’, ‘原料：鲈鱼’, 1, ‘2022-06-10 10:12:28’, ‘2022-06-10 10:12:28’, 1, 1);
INSERT INTO dish VALUES (59, ‘东坡肘子’, 18, 138.00, ‘https://sky-itcast.oss-cn-beijing.aliyuncs.com/a80a4b8c-c93e-4f43-ac8a-856b0d5cc451.png’, ‘原料：猪肘棒’, 1, ‘2022-06-10 10:24:03’, ‘2022-06-10 10:24:03’, 1, 1);
INSERT INTO dish VALUES (60, ‘梅菜扣肉’, 18, 58.00, ‘https://sky-itcast.oss-cn-beijing.aliyuncs.com/6080b118-e30a-4577-aab4-45042e3f88be.png’, ‘原料：猪肉，梅菜’, 1, ‘2022-06-10 10:26:03’, ‘2022-06-10 10:26:03’, 1, 1);
INSERT INTO dish VALUES (61, ‘剁椒鱼头’, 18, 66.00, ‘https://sky-itcast.oss-cn-beijing.aliyuncs.com/13da832f-ef2c-484d-8370-5934a1045a06.png’, ‘原料：鲢鱼，剁椒’, 1, ‘2022-06-10 10:28:54’, ‘2022-06-10 10:28:54’, 1, 1);
INSERT INTO dish VALUES (62, ‘金汤酸菜牛蛙’, 17, 88.00, ‘https://sky-itcast.oss-cn-beijing.aliyuncs.com/7694a5d8-7938-4e9d-8b9e-2075983a2e38.png’, ‘原料：鲜活牛蛙，酸菜’, 1, ‘2022-06-10 10:33:05’, ‘2022-06-10 10:33:05’, 1, 1);
INSERT INTO dish VALUES (63, ‘香锅牛蛙’, 17, 88.00, ‘https://sky-itcast.oss-cn-beijing.aliyuncs.com/f5ac8455-4793-450c-97ba-173795c34626.png’, ‘配料：鲜活牛蛙，莲藕，青笋’, 1, ‘2022-06-10 10:35:40’, ‘2022-06-10 10:35:40’, 1, 1);
INSERT INTO dish VALUES (64, ‘馋嘴牛蛙’, 17, 88.00, ‘https://sky-itcast.oss-cn-beijing.aliyuncs.com/7a55b845-1f2b-41fa-9486-76d187ee9ee1.png’, ‘配料：鲜活牛蛙，丝瓜，黄豆芽’, 1, ‘2022-06-10 10:37:52’, ‘2022-06-10 10:37:52’, 1, 1);
INSERT INTO dish VALUES (65, ‘草鱼2斤’, 16, 68.00, ‘https://sky-itcast.oss-cn-beijing.aliyuncs.com/b544d3ba-a1ae-4d20-a860-81cb5dec9e03.png’, ‘原料：草鱼，黄豆芽，莲藕’, 1, ‘2022-06-10 10:41:08’, ‘2022-06-10 10:41:08’, 1, 1);
INSERT INTO dish VALUES (66, ‘江团鱼2斤’, 16, 119.00, ‘https://sky-itcast.oss-cn-beijing.aliyuncs.com/a101a1e9-8f8b-47b2-afa4-1abd47ea0a87.png’, ‘配料：江团鱼，黄豆芽，莲藕’, 1, ‘2022-06-10 10:42:42’, ‘2022-06-10 10:42:42’, 1, 1);
INSERT INTO dish VALUES (67, ‘鮰鱼2斤’, 16, 72.00, ‘https://sky-itcast.oss-cn-beijing.aliyuncs.com/8cfcc576-4b66-4a09-ac68-ad5b273c2590.png’, ‘原料：鮰鱼，黄豆芽，莲藕’, 1, ‘2022-06-10 10:43:56’, ‘2022-06-10 10:43:56’, 1, 1);
INSERT INTO dish VALUES (68, ‘鸡蛋汤’, 21, 4.00, ‘https://sky-itcast.oss-cn-beijing.aliyuncs.com/c09a0ee8-9d19-428d-81b9-746221824113.png’, ‘配料：鸡蛋，紫菜’, 1, ‘2022-06-10 10:54:25’, ‘2022-06-10 10:54:25’, 1, 1);
INSERT INTO dish VALUES (69, ‘平菇豆腐汤’, 21, 6.00, ‘https://sky-itcast.oss-cn-beijing.aliyuncs.com/16d0a3d6-2253-4cfc-9b49-bf7bd9eb2ad2.png’, ‘配料：豆腐，平菇’, 1, ‘2022-06-10 10:55:02’, ‘2023-07-31 13:16:43’, 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 = 127 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 (86, 52, ‘忌口’, ‘[“不要葱”,“不要蒜”,“不要香菜”,“不要辣”]’);
INSERT INTO dish_flavor VALUES (87, 52, ‘辣度’, ‘[“不辣”,“微辣”,“中辣”,“重辣”]’);
INSERT INTO dish_flavor VALUES (92, 53, ‘忌口’, ‘[“不要葱”,“不要蒜”,“不要香菜”,“不要辣”]’);
INSERT INTO dish_flavor VALUES (93, 53, ‘辣度’, ‘[“不辣”,“微辣”,“中辣”,“重辣”]’);
INSERT INTO dish_flavor VALUES (94, 54, ‘忌口’, ‘[“不要葱”,“不要蒜”,“不要香菜”]’);
INSERT INTO dish_flavor VALUES (95, 56, ‘忌口’, ‘[“不要葱”,“不要蒜”,“不要香菜”,“不要辣”]’);
INSERT INTO dish_flavor VALUES (96, 57, ‘忌口’, ‘[“不要葱”,“不要蒜”,“不要香菜”,“不要辣”]’);
INSERT INTO dish_flavor VALUES (97, 60, ‘忌口’, ‘[“不要葱”,“不要蒜”,“不要香菜”,“不要辣”]’);
INSERT INTO dish_flavor VALUES (101, 66, ‘辣度’, ‘[“不辣”,“微辣”,“中辣”,“重辣”]’);
INSERT INTO dish_flavor VALUES (102, 67, ‘辣度’, ‘[“不辣”,“微辣”,“中辣”,“重辣”]’);
INSERT INTO dish_flavor VALUES (103, 65, ‘辣度’, ‘[“不辣”,“微辣”,“中辣”,“重辣”]’);
INSERT INTO dish_flavor VALUES (124, 51, ‘忌口’, ‘[“不要葱”,“不要蒜”,“不要香菜”,“不要辣”]’);
INSERT INTO dish_flavor VALUES (125, 51, ‘辣度’, ‘[“不辣”,“微辣”,“中辣”,“重辣”]’);
INSERT INTO dish_flavor VALUES (126, 49, ‘温度’, ‘[“热饮”,“常温”,“去冰”,“少冰”,“多冰”]’);

– 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 = 9 CHARACTER SET = utf8 COLLATE = utf8_bin COMMENT = ‘员工信息’ ROW_FORMAT = Dynamic;

– Records of employee

INSERT INTO employee VALUES (1, ‘管理员’, ‘admin’, ‘e10adc3949ba59abbe56e057f20f883e’, ‘13812312312’, ‘1’, ‘110101199001010047’, 1, ‘2022-02-15 15:51:20’, ‘2022-02-17 09:16:20’, 10, 1);
INSERT INTO employee VALUES (2, ‘2222’, ‘2’, ‘222222’, ‘222’, ‘22’, ‘22’, 1, NULL, NULL, NULL, NULL);
INSERT INTO employee VALUES (3, ‘thy’, ‘thy’, ‘9d93af1924bed79eb42e71a83ce1d021’, ‘12331122355’, ‘男’, ‘1234343’, 1, ‘2023-07-25 18:50:38’, ‘2023-08-02 13:06:22’, 10, 3);
INSERT INTO employee VALUES (4, ‘thy’, ‘thy2’, ‘e10adc3949ba59abbe56e057f20f883e’, ‘12331122355’, ‘男’, ‘1234343’, 1, ‘2023-07-25 19:02:18’, ‘2023-07-25 19:02:18’, 10, 10);
INSERT INTO employee VALUES (5, ‘thy’, ‘thy3’, ‘e10adc3949ba59abbe56e057f20f883e’, ‘12331122355’, ‘男’, ‘1234343’, 1, ‘2023-07-25 19:02:55’, ‘2023-07-25 19:02:55’, 10, 10);
INSERT INTO employee VALUES (6, ‘测试12222333’, ‘thycns’, ‘eb7fd88d47a7d034a498ca80827a641c’, ‘12345678918’, ‘1’, ‘440901199001010046’, 1, ‘2023-07-25 19:11:08’, ‘2023-07-26 15:10:49’, 10, 1);
INSERT INTO employee VALUES (7, ‘thy222’, ‘lisi’, ‘e10adc3949ba59abbe56e057f20f883e’, ‘13812312312’, ‘0’, ‘110102299001010047’, 1, ‘2023-07-26 10:24:52’, ‘2023-07-26 14:49:07’, 10, 1);
INSERT INTO employee VALUES (8, ‘lisan11’, ‘lisan2223’, ‘e10adc3949ba59abbe56e057f20f883e’, ‘13822312312’, ‘0’, ‘440981199001010047’, 1, ‘2023-07-26 10:31:37’, ‘2023-07-27 11:20:07’, 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 = 39 CHARACTER SET = utf8 COLLATE = utf8_bin COMMENT = ‘订单明细表’ ROW_FORMAT = Dynamic;

– Records of order_detail

INSERT INTO order_detail VALUES (5, ‘梅菜扣肉’, ‘https://sky-itcast.oss-cn-beijing.aliyuncs.com/6080b118-e30a-4577-aab4-45042e3f88be.png’, 4, 60, NULL, ‘不要蒜’, 1, 58.00);
INSERT INTO order_detail VALUES (6, ‘剁椒鱼头’, ‘https://sky-itcast.oss-cn-beijing.aliyuncs.com/13da832f-ef2c-484d-8370-5934a1045a06.png’, 4, 61, NULL, NULL, 1, 66.00);
INSERT INTO order_detail VALUES (7, ‘剁椒鱼头’, ‘https://sky-itcast.oss-cn-beijing.aliyuncs.com/13da832f-ef2c-484d-8370-5934a1045a06.png’, 5, 61, NULL, NULL, 1, 66.00);
INSERT INTO order_detail VALUES (8, ‘剁椒鱼头’, ‘https://sky-itcast.oss-cn-beijing.aliyuncs.com/13da832f-ef2c-484d-8370-5934a1045a06.png’, 6, 61, NULL, NULL, 1, 66.00);
INSERT INTO order_detail VALUES (9, ‘馒头’, ‘https://sky-itcast.oss-cn-beijing.aliyuncs.com/475cc599-8661-4899-8f9e-121dd8ef7d02.png’, 6, 50, NULL, NULL, 1, 1.00);
INSERT INTO order_detail VALUES (10, ‘珍珠米饭’, ‘https://sky-itcast.oss-cn-beijing.aliyuncs.com/76752350-2121-44d2-b477-10791c23a8ec.png’, 6, 49, NULL, ‘热饮’, 1, 5.00);
INSERT INTO order_detail VALUES (11, ‘炝炒圆白菜’, ‘https://sky-itcast.oss-cn-beijing.aliyuncs.com/22f59feb-0d44-430e-a6cd-6a49f27453ca.png’, 7, 57, NULL, ‘不要葱’, 1, 18.00);
INSERT INTO order_detail VALUES (12, ‘梅菜扣肉’, ‘https://sky-itcast.oss-cn-beijing.aliyuncs.com/6080b118-e30a-4577-aab4-45042e3f88be.png’, 8, 60, NULL, ‘不要葱’, 1, 58.00);
INSERT INTO order_detail VALUES (13, ‘梅菜扣肉’, ‘https://sky-itcast.oss-cn-beijing.aliyuncs.com/6080b118-e30a-4577-aab4-45042e3f88be.png’, 9, 60, NULL, ‘不要蒜’, 1, 58.00);
INSERT INTO order_detail VALUES (14, ‘剁椒鱼头’, ‘https://sky-itcast.oss-cn-beijing.aliyuncs.com/13da832f-ef2c-484d-8370-5934a1045a06.png’, 9, 61, NULL, NULL, 1, 66.00);
INSERT INTO order_detail VALUES (15, ‘梅菜扣肉’, ‘https://sky-itcast.oss-cn-beijing.aliyuncs.com/6080b118-e30a-4577-aab4-45042e3f88be.png’, 10, 60, NULL, ‘不要蒜’, 1, 58.00);
INSERT INTO order_detail VALUES (16, ‘剁椒鱼头’, ‘https://sky-itcast.oss-cn-beijing.aliyuncs.com/13da832f-ef2c-484d-8370-5934a1045a06.png’, 10, 61, NULL, NULL, 1, 66.00);
INSERT INTO order_detail VALUES (17, ‘鮰鱼2斤’, ‘https://sky-itcast.oss-cn-beijing.aliyuncs.com/8cfcc576-4b66-4a09-ac68-ad5b273c2590.png’, 11, 67, NULL, ‘不辣’, 1, 72.00);
INSERT INTO order_detail VALUES (18, ‘超值套餐’, ‘https://thy-i.oss-cn-beijing.aliyuncs.com/2023-07-28/25325c3f-4628-4e6e-8cbd-97f7d7ab59bc.png’, 12, NULL, 34, NULL, 1, 66.00);
INSERT INTO order_detail VALUES (19, ‘香锅牛蛙’, ‘https://sky-itcast.oss-cn-beijing.aliyuncs.com/f5ac8455-4793-450c-97ba-173795c34626.png’, 13, 63, NULL, NULL, 1, 88.00);
INSERT INTO order_detail VALUES (20, ‘炝炒圆白菜’, ‘https://sky-itcast.oss-cn-beijing.aliyuncs.com/22f59feb-0d44-430e-a6cd-6a49f27453ca.png’, 14, 57, NULL, ‘不要葱’, 1, 18.00);
INSERT INTO order_detail VALUES (21, ‘剁椒鱼头’, ‘https://sky-itcast.oss-cn-beijing.aliyuncs.com/13da832f-ef2c-484d-8370-5934a1045a06.png’, 15, 61, NULL, NULL, 1, 66.00);
INSERT INTO order_detail VALUES (22, ‘梅菜扣肉’, ‘https://sky-itcast.oss-cn-beijing.aliyuncs.com/6080b118-e30a-4577-aab4-45042e3f88be.png’, 15, 60, NULL, ‘不要葱’, 1, 58.00);
INSERT INTO order_detail VALUES (23, ‘东坡肘子’, ‘https://sky-itcast.oss-cn-beijing.aliyuncs.com/a80a4b8c-c93e-4f43-ac8a-856b0d5cc451.png’, 15, 59, NULL, NULL, 1, 138.00);
INSERT INTO order_detail VALUES (24, ‘清蒸鲈鱼’, ‘https://sky-itcast.oss-cn-beijing.aliyuncs.com/c18b5c67-3b71-466c-a75a-e63c6449f21c.png’, 15, 58, NULL, NULL, 1, 98.00);
INSERT INTO order_detail VALUES (25, ‘馋嘴牛蛙’, ‘https://sky-itcast.oss-cn-beijing.aliyuncs.com/7a55b845-1f2b-41fa-9486-76d187ee9ee1.png’, 16, 64, 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’, 17, 64, NULL, NULL, 1, 88.00);
INSERT INTO order_detail VALUES (27, ‘梅菜扣肉’, ‘https://sky-itcast.oss-cn-beijing.aliyuncs.com/6080b118-e30a-4577-aab4-45042e3f88be.png’, 18, 60, NULL, ‘不要葱’, 1, 58.00);
INSERT INTO order_detail VALUES (28, ‘炝炒圆白菜’, ‘https://sky-itcast.oss-cn-beijing.aliyuncs.com/22f59feb-0d44-430e-a6cd-6a49f27453ca.png’, 19, 57, NULL, ‘不要葱’, 1, 18.00);
INSERT INTO order_detail VALUES (29, ‘炝炒圆白菜’, ‘https://sky-itcast.oss-cn-beijing.aliyuncs.com/22f59feb-0d44-430e-a6cd-6a49f27453ca.png’, 20, 57, NULL, ‘不要葱’, 1, 18.00);
INSERT INTO order_detail VALUES (30, ‘剁椒鱼头’, ‘https://sky-itcast.oss-cn-beijing.aliyuncs.com/13da832f-ef2c-484d-8370-5934a1045a06.png’, 21, 61, NULL, NULL, 1, 66.00);
INSERT INTO order_detail VALUES (31, ‘剁椒鱼头’, ‘https://sky-itcast.oss-cn-beijing.aliyuncs.com/13da832f-ef2c-484d-8370-5934a1045a06.png’, 22, 61, NULL, NULL, 1, 66.00);
INSERT INTO order_detail VALUES (32, ‘东坡肘子’, ‘https://sky-itcast.oss-cn-beijing.aliyuncs.com/a80a4b8c-c93e-4f43-ac8a-856b0d5cc451.png’, 22, 59, NULL, NULL, 1, 138.00);
INSERT INTO order_detail VALUES (33, ‘清蒸鲈鱼’, ‘https://sky-itcast.oss-cn-beijing.aliyuncs.com/c18b5c67-3b71-466c-a75a-e63c6449f21c.png’, 22, 58, NULL, NULL, 1, 98.00);
INSERT INTO order_detail VALUES (34, ‘经典酸菜鮰鱼’, ‘https://sky-itcast.oss-cn-beijing.aliyuncs.com/5260ff39-986c-4a97-8850-2ec8c7583efc.png’, 22, 52, NULL, ‘不要葱,不辣’, 1, 66.00);
INSERT INTO order_detail VALUES (35, ‘鮰鱼2斤’, ‘https://sky-itcast.oss-cn-beijing.aliyuncs.com/8cfcc576-4b66-4a09-ac68-ad5b273c2590.png’, 23, 67, NULL, ‘不辣’, 1, 72.00);
INSERT INTO order_detail VALUES (36, ‘鮰鱼2斤’, ‘https://sky-itcast.oss-cn-beijing.aliyuncs.com/8cfcc576-4b66-4a09-ac68-ad5b273c2590.png’, 24, 67, NULL, ‘不辣’, 1, 72.00);
INSERT INTO order_detail VALUES (37, ‘炝炒圆白菜’, ‘https://sky-itcast.oss-cn-beijing.aliyuncs.com/22f59feb-0d44-430e-a6cd-6a49f27453ca.png’, 24, 57, NULL, ‘不要葱’, 1, 18.00);
INSERT INTO order_detail VALUES (38, ‘蒜蓉娃娃菜’, ‘https://sky-itcast.oss-cn-beijing.aliyuncs.com/4879ed66-3860-4b28-ba14-306ac025fdec.png’, 24, 55, NULL, NULL, 1, 18.00);

– 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 = 25 CHARACTER SET = utf8 COLLATE = utf8_bin COMMENT = ‘订单表’ ROW_FORMAT = Dynamic;

– Records of orders

INSERT INTO orders VALUES (4, ‘1690950866678’, 6, 4, 3, ‘2023-08-02 12:34:25’, NULL, 1, 0, 132.00, ‘’, ‘13423555754’, NULL, NULL, ‘tan’, ‘订单超时，自动取消’, NULL, ‘2023-08-04 14:29:30’, ‘2023-08-02 13:34:00’, 0, NULL, 2, 0, 0);
INSERT INTO orders VALUES (5, ‘1690976090527’, 5, 4, 3, ‘2023-08-02 19:34:51’, ‘2023-08-02 19:34:53’, 1, 1, 73.00, ‘’, ‘13423555754’, NULL, NULL, ‘tan’, NULL, NULL, NULL, ‘2023-08-02 20:34:00’, 0, NULL, 0, 0, 0);
INSERT INTO orders VALUES (6, ‘1690976231918’, 6, 4, 3, ‘2023-08-02 19:37:12’, ‘2023-08-02 19:37:20’, 1, 2, 81.00, ‘’, ‘13423555754’, NULL, NULL, ‘tan’, ‘用户取消’, NULL, ‘2023-08-03 12:11:38’, ‘2023-08-02 20:37:00’, 0, NULL, 3, 0, 0);
INSERT INTO orders VALUES (7, ‘1690976281464’, 6, 4, 3, ‘2023-08-02 19:38:01’, ‘2023-08-02 19:39:09’, 1, 2, 25.00, ‘’, ‘13423555754’, NULL, NULL, ‘tan’, ‘菜品已销售完，暂时无法接单’, NULL, NULL, ‘2023-08-02 20:38:00’, 0, NULL, 0, 0, 0);
INSERT INTO orders VALUES (8, ‘1691035785584’, 6, 4, 3, ‘2023-08-03 12:09:46’, ‘2023-08-03 12:09:47’, 1, 2, 65.00, ‘’, ‘13423555754’, NULL, NULL, ‘tan’, NULL, ‘菜品已销售完，暂时无法接单’, NULL, ‘2023-08-03 13:09:00’, 0, NULL, 0, 0, 0);
INSERT INTO orders VALUES (9, ‘1691036346623’, 6, 4, 3, ‘2023-08-03 12:19:07’, ‘2023-08-03 12:19:08’, 1, 2, 132.00, ‘’, ‘13423555754’, ‘广东省广州市花都区赤泥镇广东培正学院’, NULL, ‘tan’, ‘用户取消’, NULL, ‘2023-08-03 12:19:30’, ‘2023-08-03 13:19:00’, 0, NULL, 2, 0, 0);
INSERT INTO orders VALUES (10, ‘1691045026839’, 6, 4, 3, ‘2023-08-03 14:43:47’, ‘2023-08-03 14:43:48’, 1, 2, 132.00, ‘’, ‘13423555754’, ‘广东省广州市花都区赤泥镇广东培正学院’, NULL, ‘tan’, ‘用户取消’, NULL, ‘2023-08-03 14:44:03’, ‘2023-08-03 15:43:00’, 0, NULL, 0, 0, 0);
INSERT INTO orders VALUES (11, ‘1691071435313’, 5, 4, 3, ‘2023-08-03 22:03:55’, ‘2023-08-03 22:03:57’, 1, 1, 79.00, ‘’, ‘13423555754’, ‘广东省广州市花都区赤泥镇广东培正学院’, NULL, ‘tan’, NULL, NULL, NULL, ‘2023-08-03 23:03:00’, 0, NULL, 0, 0, 0);
INSERT INTO orders VALUES (12, ‘1691071492401’, 5, 4, 3, ‘2023-08-03 22:04:52’, ‘2023-08-03 22:04:54’, 1, 1, 73.00, ‘’, ‘13423555754’, ‘广东省广州市花都区赤泥镇广东培正学院’, NULL, ‘tan’, NULL, NULL, NULL, ‘2023-08-03 23:04:00’, 0, NULL, 0, 0, 0);
INSERT INTO orders VALUES (13, ‘1691115076787’, 5, 4, 3, ‘2023-08-04 10:11:17’, ‘2023-08-04 10:11:25’, 1, 1, 95.00, ‘’, ‘13423555754’, ‘广东省广州市花都区赤泥镇广东培正学院’, NULL, ‘tan’, NULL, NULL, NULL, ‘2023-08-04 11:11:00’, 0, NULL, 0, 0, 0);
INSERT INTO orders VALUES (14, ‘1691115167612’, 6, 4, 3, ‘2023-08-04 10:12:48’, NULL, 1, 0, 25.00, ‘’, ‘13423555754’, ‘广东省广州市花都区赤泥镇广东培正学院’, NULL, ‘tan’, ‘用户取消’, NULL, ‘2023-08-04 11:12:18’, ‘2023-08-04 11:11:00’, 0, NULL, 1, 0, 0);
INSERT INTO orders VALUES (15, ‘1691115310347’, 5, 4, 3, ‘2023-08-04 10:15:10’, ‘2023-08-04 10:15:12’, 1, 1, 370.00, ‘’, ‘13423555754’, ‘广东省广州市花都区赤泥镇广东培正学院’, NULL, ‘tan’, NULL, NULL, NULL, ‘2023-08-04 11:15:00’, 0, NULL, 0, 0, 0);
INSERT INTO orders VALUES (16, ‘1691298999802’, 5, 4, 3, ‘2023-08-06 13:16:40’, ‘2023-08-06 13:16:43’, 1, 1, 95.00, ‘’, ‘13423555754’, ‘广东省广州市花都区赤泥镇广东培正学院’, NULL, ‘tan’, NULL, NULL, NULL, ‘2023-08-06 14:16:00’, 0, NULL, 0, 0, 0);
INSERT INTO orders VALUES (17, ‘1691300188171’, 5, 4, 3, ‘2023-08-06 13:36:28’, ‘2023-08-06 13:36:29’, 1, 1, 95.00, ‘’, ‘13423555754’, ‘广东省广州市花都区赤泥镇广东培正学院’, NULL, ‘tan’, NULL, NULL, NULL, ‘2023-08-06 14:36:00’, 0, NULL, 0, 0, 0);
INSERT INTO orders VALUES (18, ‘1691300287592’, 5, 4, 3, ‘2023-08-06 13:38:08’, ‘2023-08-06 13:38:08’, 1, 1, 65.00, ‘’, ‘13423555754’, ‘广东省广州市花都区赤泥镇广东培正学院’, NULL, ‘tan’, NULL, NULL, NULL, ‘2023-08-06 14:38:00’, 0, NULL, 0, 0, 0);
INSERT INTO orders VALUES (19, ‘1691300451164’, 5, 4, 3, ‘2023-08-06 13:40:51’, ‘2023-08-06 13:40:52’, 1, 1, 25.00, ‘’, ‘13423555754’, ‘广东省广州市花都区赤泥镇广东培正学院’, NULL, ‘tan’, NULL, NULL, NULL, ‘2023-08-06 14:40:00’, 0, NULL, 0, 0, 0);
INSERT INTO orders VALUES (20, ‘1691300466078’, 5, 4, 3, ‘2023-08-06 13:41:06’, ‘2023-08-06 13:41:07’, 1, 1, 25.00, ‘’, ‘13423555754’, ‘广东省广州市花都区赤泥镇广东培正学院’, NULL, ‘tan’, NULL, NULL, NULL, ‘2023-08-06 14:41:00’, 0, NULL, 0, 0, 0);
INSERT INTO orders VALUES (21, ‘1691481616835’, 5, 4, 3, ‘2023-08-08 16:00:17’, ‘2023-08-08 16:00:20’, 1, 1, 73.00, ‘’, ‘13423555754’, ‘广东省广州市花都区赤泥镇广东培正学院’, NULL, ‘tan’, NULL, NULL, NULL, ‘2023-08-08 17:00:00’, 0, ‘2023-08-08 16:01:03’, 0, 0, 0);
INSERT INTO orders VALUES (22, ‘1691482182891’, 5, 4, 3, ‘2023-08-08 16:09:43’, ‘2023-08-08 16:09:44’, 1, 1, 378.00, ‘’, ‘13423555754’, ‘广东省广州市花都区赤泥镇广东培正学院’, NULL, ‘tan’, NULL, NULL, NULL, ‘2023-08-08 17:09:00’, 0, ‘2023-08-08 16:13:51’, 0, 0, 0);
INSERT INTO orders VALUES (23, ‘1691728265818’, 4, 4, 3, ‘2023-08-11 12:31:06’, ‘2023-08-11 12:31:10’, 1, 1, 79.00, ‘’, ‘13423555754’, ‘广东省广州市花都区赤泥镇广东培正学院’, NULL, ‘tan’, NULL, NULL, NULL, ‘2023-08-11 13:31:00’, 0, NULL, 0, 0, 0);
INSERT INTO orders VALUES (24, ‘1691728325867’, 6, 4, 3, ‘2023-08-11 12:32:06’, NULL, 1, 0, 117.00, ‘’, ‘13423555754’, ‘广东省广州市花都区赤泥镇广东培正学院’, NULL, ‘tan’, ‘订单超时，自动取消’, NULL, ‘2023-08-11 13:00:00’, ‘2023-08-11 13:32:00’, 0, NULL, 3, 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 = 38 CHARACTER SET = utf8 COLLATE = utf8_bin COMMENT = ‘套餐’ ROW_FORMAT = Dynamic;

– Records of setmeal

INSERT INTO setmeal VALUES (34, 13, ‘超值套餐’, 66.00, 1, ‘便宜实惠好吃绝绝子’, ‘https://thy-i.oss-cn-beijing.aliyuncs.com/2023-07-28/25325c3f-4628-4e6e-8cbd-97f7d7ab59bc.png’, ‘2023-07-28 14:58:35’, ‘2023-08-01 10:45:03’, 1, 1);
INSERT INTO setmeal VALUES (35, 15, ‘肉多的套餐’, 999.00, 1, ‘’, ‘https://thy-i.oss-cn-beijing.aliyuncs.com/2023-08-11/f3a1700a-0562-46b5-829a-3109f2f50152.png’, ‘2023-08-11 11:16:14’, ‘2023-08-11 12:23:25’, 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 = 73 CHARACTER SET = utf8 COLLATE = utf8_bin COMMENT = ‘套餐菜品关系’ ROW_FORMAT = Dynamic;

– Records of setmeal_dish

INSERT INTO setmeal_dish VALUES (60, 34, 68, ‘鸡蛋汤’, 4.00, 1);
INSERT INTO setmeal_dish VALUES (61, 34, 48, ‘雪花啤酒’, 4.00, 1);
INSERT INTO setmeal_dish VALUES (62, 34, 49, ‘珍珠米饭’, 99.00, 1);
INSERT INTO setmeal_dish VALUES (63, 34, 51, ‘老坛酸菜鱼’, 56.00, 1);
INSERT INTO setmeal_dish VALUES (64, 34, 55, ‘蒜蓉娃娃菜’, 18.00, 1);
INSERT INTO setmeal_dish VALUES (65, 34, 59, ‘东坡肘子’, 138.00, 1);
INSERT INTO setmeal_dish VALUES (66, 34, 64, ‘馋嘴牛蛙’, 88.00, 1);
INSERT INTO setmeal_dish VALUES (67, 34, 65, ‘草鱼2斤’, 68.00, 1);
INSERT INTO setmeal_dish VALUES (68, 35, 51, ‘老坛酸菜鱼’, 56.00, 1);
INSERT INTO setmeal_dish VALUES (69, 35, 61, ‘剁椒鱼头’, 66.00, 1);
INSERT INTO setmeal_dish VALUES (70, 35, 58, ‘清蒸鲈鱼’, 98.00, 1);
INSERT INTO setmeal_dish VALUES (71, 35, 59, ‘东坡肘子’, 138.00, 1);
INSERT INTO setmeal_dish VALUES (72, 35, 60, ‘梅菜扣肉’, 58.00, 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 = 5 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 (4, ‘oGvNz60sWfhKQ5TniSeuxJFGkxuI’, NULL, NULL, NULL, NULL, NULL, ‘2023-07-30 17:32:56’);

SET FOREIGN_KEY_CHECKS = 1;

weixin_47296176
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
Sql Server 2014 安装包
09-02
Sql Server 2014 安装包
基础篇：数据库 SQL 入门教程
热门推荐
LuciferLiu_DBA
09-12 32万+
超全SQL教程，收藏就完事了！
SQL主键
cxh200351的博客
03-27 9402
在SQL中主键是唯一标示表中每一行的列或一组列。 SQL可以使用PRIMARY KEY约束为表创建主键。 如果主键只包含一列，则可以将PRIMARY KEY约束定义为列约束 。 每个表只能有一个主键。 参与主键的所有列必须定义为NOT NULL。 在SQL中如果没有为这些列指定NOT NULL约束，SQL Server会自动为所有主键设置NOT NOLL 约束。 在创建主键时，SQL Server还会自动创建唯一的聚簇（如果指定，则为非聚集索引）。 以下实例创建一个包含主键的表，该主键包含一列
windows sql server 如何卸载干净？
ha_123_qq的博客
11-19 8万+
提示：文章写完后，目录可以自动生成，如何生成可参考右边的帮助文档 windows sql server 怎么卸载干净？前言一、windows sql server是什么？二、如何卸载干净1、关闭sql server服务2.到控制面板，卸载sql server3、删除磁盘里的安装文件4、清空注册表总结 前言 安装完windows sql server后，如果只在控制面板上卸载掉相关服务，可能会卸载不干净。 如果再次安装，及时提示你安装成功，但当你开始连接数据库的时候，有可能会导致连接不上，那怎么才能卸载干
sql语句中union的用法
weixin_42383680的博客
08-22 11万+
union联合的结果集不会有重复值，如果要有重复值，则使用union all union会自动压缩多个结果集合中重复的结果，使结果不会有重复行，union all 会将所有的结果共全部显示出来，不管是不是重复。 union：会对两个结果集进行并集操作，不包括重复行，同时进行默认规则的排序。 union all：对两个结果集进行并集操作，包括重复行，不会对结果进行排序。 1.sql Union用法 select 字段1 from 表名1 Union select 字段2 from 表名2.....
SQL server2019安装教程
夕目
02-17 9万+
下载必备 由于安装文件太大，所以没有办法上传，各位就请自行下载 安装步骤 点击sql2019安装包 选择基本 浏览安装到指定的位置，点击安装下载 下载完成之后就是这个界面,然后点击自定义 选择下一步 等待扫描完成后选择选择下一步 之后再选择第一个“执行SQL SERVER 2019 的全新安装”，然后点击下一步 勾选第一个 接受条款，继续下一步 在“实例功能”里面勾选你需要...
通过SqlCmd执行超大SQL文件
12-15
##通过sqlcmd执行sql文件 由于sql文件过大，超过了100M，再数据库的窗口执行，结果超出内存了，对于特别大的sql文件可以使用sqlcmd进行执行 ###1.打开cmd窗口 运行–cmd–进入到sql文件所在的文件夹。 如果是win7可...
oracle SQL查询工具
03-13
oracle SQL查询工具oracle SQL查询工具oracle SQL查询工具oracle SQL查询工具oracle SQL查询工具oracle SQL查询工具oracle SQL查询工具oracle SQL查询工具oracle SQL查询工具oracle SQL查询工具oracle SQL查询工具...
Microsoft SQL Server 2008 R2 SP1 Native Client
05-25
Microsoft SQL Server 2008 Native Client (SQL Server Native Client) 是单一动态链接库 (DLL)，其中包含 SQL OLE DB 提供者和 SQL ODBC 驱动程序。此链接库针对使用机器码 API (ODBC、OLE DB 和 ADO) 的应用程序...
sql search
04-01
非常好用的sql server 搜索工具。sql search sql search
FME学习之旅---day27
summer_corner的博客
05-17 241
我们付出一些成本，时间的或者其他，最终总能收获一些什么。
使用多实例学习进行乳腺癌组织病理学图像分类和定位
qq_47896523的博客
05-16 1235
乳腺癌是女性最主要的死亡原因，病理学家根据病理切片中观察到的各种视觉特征（例如细胞核的形态特征、细胞核的微观和宏观结构等）做出决定。计算机辅助诊断（CAD）系统可以帮助病理学家自动做出决策。卷积神经网络是最广泛使用的深度学习框架，用于学习图像类别之间的复杂判别特征。多年来，VGG16 [3] 和 ResNet18 [4] 等各种 CNN 架构在海量 ImageNet 数据集上产生了出色的结果。CNN 被用于医学图像以产生最先进的结果。为图像中存在的所有类别提供了定位信息。
WEB转Flutter基础学习笔记（内含vue和flutter对比）
小易不止于搬砖的博客
05-17 734
笔者是一名web前端，记录在转栈flutter时的学习笔记，内涵和vue的对比，能够辅助前端同学更容易理解flutter
引用实战学习
qiuzhiuser的博客
05-19 116
【代码】引用实战学习。
C语言查漏补缺学习【精简版】
qq_49288362的博客
05-18 716
逗号的组合关系是自左向右，所以左边的表达式会先计算，而右边的表达式的值就留下来作为逗号运算的结果。枚举类型名字通常并不真的使用，要用的是在大括号里的名字，因为它们就是常量符合，它们的类型是int,值则一次从0到n。当要传递的参数的类型比地址大的时候，这是常用的手段：既能用比较少的字节数传递值给参数，又能避免函数对外面的变量的修改。当需要一些可以排列起来的常量值时，定义枚举的意义就是给了这些常量的值的名字。16.*：是一个单目运算符，用来访问指针的值所表示的地址上的变量。
RustGUI学习（iced/iced_aw）之扩展小部件（十九）：如何使用context_menu部件来创建右击菜单？
用沸腾的热血，支付我们的人生吧！
05-15 100
本专栏是学习Rust的GUI库iced的合集，将介绍iced涉及的各个小部件分别介绍，最后会汇总为一个总的程序。iced是RustGUI中比较强大的一个，目前处于发展中（即版本可能会改变），本专栏基于版本0.12.1.
【学习笔记】后端（Ⅰ）—— NodeJS（Ⅱ）
最新发布
Eddie_hyh的博客
05-21 513
NodeJS（Ⅱ）
【AI学习】简单聊聊后训练（Post-Training）的重要性
bylander的博客
05-17 652
模型生成的输出质量比网上的大多数内容都要高。因此，让模型自己思考似乎更有道理，而不仅仅是训练来模仿网络上的内容。所以，我认为从第一性原理上来说，这是有说服力的。我会说，我们通过后训练取得了很多进步。
线性回归学习笔记
julyclj55555的博客
05-15 278
换句话说，多元线性回归可以有足够的精确性，但对于该精确性的合理解释会比较难，因为在多个属性中，可能有其中多组子属性的组合都能拟合到近似最优的模型效果，但对不同组的子属性的组合解释，会因为属性不同而有很大区别，这就是统计学家莱奥·布雷曼口中的“罗生门”（Rashomon）。它的值越大代表，拟合的结果越可信；将“罗生门”深挖一步，就是机器学习和统计学在认识论上的差异：统计学讲究的是“知其然，知其所以然”，它不仅要找出数据之间的关联性，还要挖出背后的因果性，给计算出的结果赋予令人信服的解释才是统计的核心。
ESCAPE sql
04-18
ESCAPE SQL是一种用于防止SQL注入攻击的技术。SQL注入攻击是指攻击者通过在用户输入的数据中插入恶意的SQL代码，从而绕过应用程序的输入验证，对数据库进行非法操作或者获取敏感信息。 为了防止SQL注入攻击，可以使用ESCAPE SQL技术来对用户输入的数据进行转义处理。具体而言，ESCAPE SQL技术会对特殊字符进行转义，使其不再被解释为SQL代码的一部分，而只是作为普通的文本进行处理。 常见的ESCAPE SQL技术包括： 1. 参数化查询：使用参数化查询可以将用户输入的数据作为参数传递给SQL语句，而不是将其直接拼接到SQL语句中。这样可以避免用户输入的数据被误解为SQL代码。 2. 使用预编译语句：预编译语句可以将SQL语句和参数分开处理，从而避免了SQL注入攻击。 3. 输入验证和过滤：对用户输入的数据进行验证和过滤，确保只有符合规定格式的数据才能被接受和使用。

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值