/*
 Navicat Premium Data Transfer

 Source Server         : origin
 Source Server Type    : MySQL
 Source Server Version : 50650
 Source Host           : 121.4.37.37:3306
 Source Schema         : pangbo

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

 Date: 04/09/2023 13:45:27
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for admin
-- ----------------------------
DROP TABLE IF EXISTS `admin`;
CREATE TABLE `admin`  (
  `adminId` int(11) NOT NULL AUTO_INCREMENT,
  `adminName` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `adminPassword` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `adminImg` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `adminAuthority` tinyint(4) NULL DEFAULT 1,
  `type` tinyint(1) NOT NULL DEFAULT 1,
  PRIMARY KEY (`adminId`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of admin
-- ----------------------------
INSERT INTO `admin` VALUES (1, '温迪', '123456wd', 'https://gimg2.baidu.com/image_search/src=http%3A%2F%2Fsafe-img.xhscdn.com%2Fbw1%2F02c3bd99-9dfb-4ac1-882b-7947f2c5de00%3FimageView2%2F2%2Fw%2F1080%2Fformat%2Fjpg&refer=http%3A%2F%2Fsafe-img.xhscdn.com&app=2002&size=f9999,10000&q=a80&n=0&g=0n&fmt=auto?sec=1690938775&t=a2443272aee74961b0cd4b60b8ccac8f', 1, 1);
INSERT INTO `admin` VALUES (2, '钟离', '123456zl', 'https://gimg2.baidu.com/image_search/src=http%3A%2F%2Fimg.nga.178.com%2Fattachments%2Fmon_202107%2F23%2Fl2Q2o-c7cnZ12T3cSrt-rt.jpg&refer=http%3A%2F%2Fimg.nga.178.com&app=2002&size=f9999,10000&q=a80&n=0&g=0n&fmt=auto?sec=1690941980&t=73346a63023b5312a97de4f77bb93215', 1, 1);
INSERT INTO `admin` VALUES (3, '雷电影', '123456ldy', 'https://i0.hdslb.com/bfs/archive/624b76eea4e6d8cbf9602a4ae65dab9e3adc9198.jpg', 1, 1);
INSERT INTO `admin` VALUES (4, '纳西妲', '123456nxd', 'https://gimg2.baidu.com/image_search/src=http%3A%2F%2Fci.xiaohongshu.com%2Ffe07431a-44bd-0207-b0b9-38ff9be59d2d%3FimageView2%2F2%2Fw%2F1080%2Fformat%2Fjpg&refer=http%3A%2F%2Fci.xiaohongshu.com&app=2002&size=f9999,10000&q=a80&n=0&g=0n&fmt=auto?sec=1690942056&t=3e51c265d839468e0c5560a5ec8cb278', 1, 1);
INSERT INTO `admin` VALUES (5, '芙宁娜', '123456fkls', 'https://pic.rmb.bdstatic.com/bjh/49b311d144f87239be36bb44d9d045443818.jpeg@h_1280', 1, 1);

-- ----------------------------
-- Table structure for dish
-- ----------------------------
DROP TABLE IF EXISTS `dish`;
CREATE TABLE `dish`  (
  `dishId` int(11) NOT NULL AUTO_INCREMENT,
  `dishName` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `dishPrice` double(5, 2) NULL DEFAULT NULL,
  `quantityLeft` int(11) NULL DEFAULT 0,
  `dishDescription` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `d_merId` int(11) NULL DEFAULT NULL COMMENT '外键，对应商家主键',
  `dishImg` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`dishId`) USING BTREE,
  INDEX `d_merId`(`d_merId`) USING BTREE,
  CONSTRAINT `dish_ibfk_1` FOREIGN KEY (`d_merId`) REFERENCES `merchat` (`merId`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 70 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of dish
-- ----------------------------
INSERT INTO `dish` VALUES (5, '黄焖鸡（小份）', 17.00, 9957, 'delicious！', 1, 'http://wx.lingchangxiaoyuan.com/attachment/images/2/2021/09/e8E8JL8N3788zH8DMmJ3Nn1DFtT3jJ.jpg');
INSERT INTO `dish` VALUES (6, '黄焖猪蹄（小份）', 17.00, 9957, '好吃', 1, 'http://wx.lingchangxiaoyuan.com/attachment/images/2/2021/09/MY0Z1ZgojOrOO100yW1VYLzjvzqO0K.jpg');
INSERT INTO `dish` VALUES (7, '黄焖鸡（大份）', 23.00, 9957, '好好吃', 1, 'http://wx.lingchangxiaoyuan.com/attachment/images/2/2021/09/TIg88bT8tZci048lTZlgtl8800SHCF.jpg');
INSERT INTO `dish` VALUES (8, '黄焖酥肉', 15.00, 9957, '好吃好吃', 1, 'http://wx.lingchangxiaoyuan.com/attachment/images/2/2021/11/OstG15tAGgaPoXSpZgsYsX5f5q4pAF.jpg');
INSERT INTO `dish` VALUES (9, '砂锅丸子汤', 15.00, 9957, '好吃好吃好吃', 3, 'http://wx.lingchangxiaoyuan.com/attachment/images/2/2021/11/U7U1QSECEbCqyr0R3zQyS0588qScB0.jpg');
INSERT INTO `dish` VALUES (11, '老干妈蛋炒饭', 16.00, 9957, '好吃好吃好吃好吃好吃', 1, 'https://oss.heidoucms.com/images/506/2022/04/SQl1b9TE5LLUZmDh1dDep9W9MelqHw.jpg');
INSERT INTO `dish` VALUES (12, '火山石肉肠炒饭', 17.00, 9957, '确实好吃', 1, 'https://oss.heidoucms.com/images/506/2022/04/hi0ng7LUKGz20T00ikkAhhY7la7KH0.jpg');
INSERT INTO `dish` VALUES (14, '青城山腊肠炒饭', 20.00, 9957, '非常的美味', 4, 'https://oss.heidoucms.com/images/506/2022/04/e33Pn7UUbsqUMNswTq7TnNEteW4twB.jpg');
INSERT INTO `dish` VALUES (17, '海苔肉松炸鸡', 25.00, 9957, '非常的美味', 5, 'https://oss.heidoucms.com/images/506/2022/11/Wjlzfk6o6Ebxo0q0rmOO60WOJ6OTkj.jpeg');
INSERT INTO `dish` VALUES (18, '韩式年糕', 7.00, 9957, '有点好吃', 5, 'https://oss.heidoucms.com/images/506/2022/10/FYvqi1yZe1BO6WiwvE1yHhbB17672y.jpg');
INSERT INTO `dish` VALUES (19, '韩式小腿', 19.00, 9957, '非常的美味', 5, 'https://oss.heidoucms.com/images/506/2022/10/IFLQF5fvG3iLtjlTzVqItJNz3VlLfj.jpeg');
INSERT INTO `dish` VALUES (20, '香酥无骨炸鸡', 25.00, 9957, '有点好吃', 5, 'https://oss.heidoucms.com/images/506/2022/10/dWSCHSIpwsxAPLKPkIphKYYkIpkQWw.jpg');
INSERT INTO `dish` VALUES (21, '韩式鸡翅', 27.00, 9957, '非常的美味', 5, 'https://oss.heidoucms.com/images/506/2022/10/ddFpfbtFfbxdtdaQDNIxwBbRdCTtoc.jpg');
INSERT INTO `dish` VALUES (23, '炸鸡半只', 17.00, 9957, '有点好吃', 6, 'http://wx.lingchangxiaoyuan.com/attachment/images/2/2022/11/j4Poeog26VTZ6OvvN6GKP2N2POBno6.jpeg');
INSERT INTO `dish` VALUES (24, '酥酥大鸡排', 7.00, 9957, '非常的美味', 6, 'http://wx.lingchangxiaoyuan.com/attachment/images/2/2021/03/X3A0oBB433Aa540BA3F23u23W3FL0O.jpg');
INSERT INTO `dish` VALUES (25, '鸭屎芥末豪华单人套餐', 27.00, 9957, '有点好吃', 6, 'https://oss.heidoucms.com/images/506/2023/06/EWZYrxAcxrc022sc1x11QZuGA1m4qa.jpeg');
INSERT INTO `dish` VALUES (26, '大胃王套餐', 23.00, 9957, '非常的美味', 6, 'http://wx.lingchangxiaoyuan.com/attachment/images/2/2021/03/U1QhMIH1TM7ihqi1H8txztS9CzZq7m.jpg');
INSERT INTO `dish` VALUES (27, '鑫韩体验套餐', 22.00, 9957, '有点好吃', 6, 'http://wx.lingchangxiaoyuan.com/attachment/images/2/2021/03/YS0sgslt8L077ZQB8Ebs373H5BjQ83.jpg');
INSERT INTO `dish` VALUES (29, '素食主义者套餐', 18.00, 9957, '非常的美味', 7, 'https://img1.baidu.com/it/u=4160655291,4026558193&fm=253&fmt=auto&app=138&f=JPEG?w=500&h=330');
INSERT INTO `dish` VALUES (30, '荤素搭配套餐', 23.00, 9957, '好吃好吃好吃', 7, 'https://img1.baidu.com/it/u=4160655291,4026558193&fm=253&fmt=auto&app=138&f=JPEG?w=500&h=330');
INSERT INTO `dish` VALUES (31, '贡菜', 4.00, 9957, '非常的新鲜', 7, 'https://oss.heidoucms.com/images/506/2023/06/AWRG8ewFehH5I0oHrI0G2wJRYYKrqy.png');
INSERT INTO `dish` VALUES (32, '泡面', 3.00, 9957, '好吃好吃好吃', 7, 'https://img2.baidu.com/it/u=2642184852,4284217728&fm=253&fmt=auto&app=138&f=JPEG?w=500&h=505');
INSERT INTO `dish` VALUES (33, '腐竹', 3.00, 9957, '非常的新鲜', 7, 'https://img1.baidu.com/it/u=690818373,1679046530&fm=253&fmt=auto&app=138&f=JPEG?w=500&h=500');
INSERT INTO `dish` VALUES (35, '超值单人餐', 21.00, 9957, '非常的新鲜', 8, 'http://beidouwm.oss-cn-hangzhou.aliyuncs.com/images/4/2023/05/hCaDC9ZcZLIzR5V8AoC6qRrDca6xOa.jpg');
INSERT INTO `dish` VALUES (36, '无年糕套餐', 26.00, 9957, '非常的新鲜', 8, 'http://beidouwm.oss-cn-hangzhou.aliyuncs.com/images/4/2023/05/F62aIup1KIrQ7opuBa7irn6BPKUIbi.jpg');
INSERT INTO `dish` VALUES (37, '单人组合餐', 27.00, 9957, '好吃好吃好吃', 8, 'http://beidouwm.oss-cn-hangzhou.aliyuncs.com/images/4/2023/05/EnaenMwmqS8MmPM8NmFwmT4nVV4qn4.jpg');
INSERT INTO `dish` VALUES (38, '翅根爱好者', 28.00, 9957, '确实好吃', 8, 'http://beidouwm.oss-cn-hangzhou.aliyuncs.com/images/4/2023/05/vj9HHKqr3z153X5q39HkRyXyH50KXJ.jpg');
INSERT INTO `dish` VALUES (39, '红薯爱好者', 28.00, 9957, '非常的新鲜', 8, 'http://beidouwm.oss-cn-hangzhou.aliyuncs.com/images/4/2023/05/oDo71W47x6fpUTO3Wo6pt3D7O3zxtZ.jpg');
INSERT INTO `dish` VALUES (41, '干豇豆烧肉', 14.00, 9957, '好吃好吃好吃', 9, 'https://oss.heidoucms.com/images/512/2022/10/W4UbqVb6C10c46cUVuC1t69tCbJ18u.jpg');
INSERT INTO `dish` VALUES (42, '红烧肥肠', 14.00, 9957, '非常的新鲜', 9, 'https://oss.heidoucms.com/images/512/2022/10/CSXZ8xDspmx3d0C1eXc0907ced8X1M.jpg');
INSERT INTO `dish` VALUES (43, '黄豆红烧肉', 12.00, 9957, '好吃好吃好吃', 9, 'https://oss.heidoucms.com/images/512/2022/10/s5ZZZ5jum6kEE6DMueMGBej5mJMzg6.jpg');
INSERT INTO `dish` VALUES (44, '毛豆鸡腿肉', 13.00, 9957, '好吃好吃好吃', 9, 'https://oss.heidoucms.com/images/506/2023/05/EG3923c33C22G866gbp1AJoZ3OpBB2.jpeg');
INSERT INTO `dish` VALUES (45, '干锅麻辣排骨', 14.00, 9957, '确实好吃', 9, 'https://oss.heidoucms.com/images/512/2022/10/DZYZp1DcgzQq66112pgD11GC5KBDQd.jpg');
INSERT INTO `dish` VALUES (47, '番茄鸡蛋木桶饭', 17.00, 9957, '好吃好吃好吃', 10, 'https://wx.lingchangxiaoyuan.com/attachment/images/2/2022/12/TAYDb2MzX4yAIG7az2o0MWYNiL72EL.jpeg');
INSERT INTO `dish` VALUES (48, '鱼香肉丝木桶饭', 18.00, 9957, '非常的新鲜', 10, 'https://wx.lingchangxiaoyuan.com/attachment/images/2/2022/12/bVKmdq4M43vHhH13dMuVhZwDZz83Pu.jpeg');
INSERT INTO `dish` VALUES (49, '青椒炒蛋木桶饭', 16.00, 9957, '确实好吃', 10, 'https://wx.lingchangxiaoyuan.com/attachment/images/2/2022/12/lyDJc84r4CJ2j2neE4j4CyQqQDh3D2.jpeg');
INSERT INTO `dish` VALUES (50, '香干炒肉丝木桶饭', 19.00, 9957, '确实好吃', 10, 'https://wx.lingchangxiaoyuan.com/attachment/images/2/2022/12/X3g8Zk4PK3kkm3OZd6638WqkspD6Ub.jpeg');
INSERT INTO `dish` VALUES (51, '青椒肉丝木桶饭·', 19.00, 9957, '非常的新鲜', 10, 'https://wx.lingchangxiaoyuan.com/attachment/images/2/2022/12/wG3oG8ZOsnGgG8888F82AAGgLng982.jpeg');
INSERT INTO `dish` VALUES (53, '现炒肉丝', 13.00, 9957, '确实好吃', 11, 'https://oss.heidoucms.com/images/506/2023/06/B5RZ9iPR3lp0rN4ml0A8d4P0794892.jpg');
INSERT INTO `dish` VALUES (54, '小煎肉', 14.00, 9957, '确实好吃', 11, 'https://oss.heidoucms.com/images/506/2023/06/hE3nnSHU36NrgEGTGuUNnnUAhNaTGB.jpeg');
INSERT INTO `dish` VALUES (55, '花菜炒回锅肉', 20.00, 9957, '好吃好吃好吃好吃好吃', 11, 'https://oss.heidoucms.com/images/506/2023/05/zHhPUZnEujOU8OLOUT4QlionDQPQIQ.jpeg');
INSERT INTO `dish` VALUES (56, '荷兰豆炒回锅肉', 20.00, 9957, '确实好吃', 11, 'https://oss.heidoucms.com/images/506/2023/05/Dq3dFApp21134q220red2rQ1QDzJr0.jpeg');
INSERT INTO `dish` VALUES (57, '花菜炒腊肉', 22.00, 9957, '非常的新鲜', 11, 'https://oss.heidoucms.com/images/506/2023/05/Y1vIZOipi6JvDyP4MJD41I1vzwIOdj.jpeg');
INSERT INTO `dish` VALUES (61, '雪花鸡排饭', 13.00, 9957, '确实好吃', 12, 'https://oss.heidoucms.com/images/506/2023/04/x99rzrRfzf9P6cC9lZp4eFHlqwDiId.jpg');
INSERT INTO `dish` VALUES (62, '招牌烤肉拌饭', 16.00, 9957, '好吃好吃好吃', 12, 'https://oss.heidoucms.com/images/506/2023/03/d9MJT36pO3Q2762O9RVrOQ3WrOo9x3.jpg');
INSERT INTO `dish` VALUES (63, '奶香芝士烤肉饭', 16.00, 9957, '确实好吃', 12, 'https://oss.heidoucms.com/images/506/2023/03/L6JO1WypW1HjJ1O6rloJJ6a4awgY4l.jpg');
INSERT INTO `dish` VALUES (64, '咖喱烤肉饭', 16.00, 9957, '好吃好吃好吃', 12, 'https://oss.heidoucms.com/images/506/2023/03/BPGGvUNNtPOXYn30Xy3UMyCVzmUmxY.jpg');
INSERT INTO `dish` VALUES (65, '番茄烤肉饭', 16.00, 9957, '非常的新鲜', 12, 'https://oss.heidoucms.com/images/506/2023/03/o2qZglil37w99ZG73iy349LQnwWYnQ.jpeg');
INSERT INTO `dish` VALUES (69, '12', 12.00, 9957, '12', 1, NULL);

-- ----------------------------
-- Table structure for merchat
-- ----------------------------
DROP TABLE IF EXISTS `merchat`;
CREATE TABLE `merchat`  (
  `merId` int(11) NOT NULL AUTO_INCREMENT,
  `merName` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `merPassword` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `merImg` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `m_addressId` int(11) NULL DEFAULT NULL,
  `merAuthority` tinyint(4) NULL DEFAULT 2,
  `type` tinyint(1) NOT NULL DEFAULT 2,
  PRIMARY KEY (`merId`) USING BTREE,
  INDEX `merchatAddress`(`m_addressId`) USING BTREE,
  CONSTRAINT `merchatAddress` FOREIGN KEY (`m_addressId`) REFERENCES `multiaddress` (`addressId`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 62 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of merchat
-- ----------------------------
INSERT INTO `merchat` VALUES (1, '猎鹿人餐馆', '123456', 'http://p0.meituan.net/deal/8f94b2462c1fc079e6d3452c30467ba524386.jpg', 1, 2, 2);
INSERT INTO `merchat` VALUES (3, '烤肉饭店', '12345', 'https://oss.heidoucms.com/images/506/2023/04/B2c2LNKKLK5PHd2COOEacLJZk9rpha.jpg', 2, 2, 2);
INSERT INTO `merchat` VALUES (4, '暴龙酱汁炒饭', '12345', 'https://oss.heidoucms.com/images/506/2023/04/b4nm7F7CD6307HHNHHSC7n0QoI7Co4.jpg', 3, 2, 2);
INSERT INTO `merchat` VALUES (5, '多滋韩式炸鸡汉堡', '12345', 'https://oss.heidoucms.com/images/506/2023/04/YlL3E4IatAaq44q91X9txXAfI9VaP9.jpg', 4, 2, 2);
INSERT INTO `merchat` VALUES (6, '鑫韩大师炸鸡汉堡', '12345', 'https://oss.heidoucms.com/images/506/2022/11/d1cCkubmKkCC0uctatUXPXPV1Q6uPt.jpeg', 5, 2, 2);
INSERT INTO `merchat` VALUES (7, '曹氏热卤 现捞', '12345', 'https://oss.heidoucms.com/images/506/2023/04/cSFs2zF321RS6H1Dz2Q2q6uoZ6K51U.jpg', 6, 2, 2);
INSERT INTO `merchat` VALUES (8, '北村韩屋韩式炸鸡', '12345', 'https://oss.heidoucms.com/images/506/2023/04/jkeC4cluqkNanu99ZnAlJ4HaznXYey.jpg', 9, 2, 2);
INSERT INTO `merchat` VALUES (9, '椒灶小碗菜', '12345', 'https://oss.heidoucms.com/images/506/2023/04/OCqCcRNr1R1R0Q80r2rVv2CZrkw0V4.jpg', 7, 2, 2);
INSERT INTO `merchat` VALUES (10, '炒饭熊~拼一碗木桶饭', '12345', 'https://oss.heidoucms.com/images/506/2023/06/LRQFD4VG47AArzkQkik6PG47AMKmKp.jpg', 8, 2, 2);
INSERT INTO `merchat` VALUES (11, '顺利轩木桶饭', '12345', 'https://oss.heidoucms.com/images/506/2023/02/UwvZe5wrwb4WVP5wI5Vi5chH1pGgvH.jpg', 10, 2, 2);
INSERT INTO `merchat` VALUES (12, '张秀梅烤肉拌饭', '12345', 'https://oss.heidoucms.com/images/506/2023/04/SjDJLhaDzP7D7SzVUj419U5VVjov9U.jpg', 11, 2, 2);
INSERT INTO `merchat` VALUES (13, '港式海鲜炒饭', '12345', 'https://oss.heidoucms.com/images/506/2023/04/tJ15KSnBmmxND1jbRL2H1HNRZRenNH.jpg', 12, 2, 2);
INSERT INTO `merchat` VALUES (14, '冒菜西施大学城店', '12345', 'https://oss.heidoucms.com/images/506/2023/06/u9JJqVZvsihuQEZ8s9VrdpvUdVPpdV.jpg', 13, 2, 2);
INSERT INTO `merchat` VALUES (15, '舌尖疯狂在成都（小碗', '12345', 'https://oss.heidoucms.com/images/506/2023/06/UNIdD3peP7ZE7kdEIHEQ67ih97kx3h.jpg', 14, 2, 2);
INSERT INTO `merchat` VALUES (16, '日式牛肉饭+鸡叉骨', '12345', 'https://oss.heidoucms.com/images/506/2023/06/q39s13yZgx2b9ZB3y3581XyFKob3Bb.jpg', 15, 2, 2);
INSERT INTO `merchat` VALUES (17, '原点点餐系统', '1234512345', 'https://oss.heidoucms.com/images/506/2023/05/IJYjuuj3VBtjJJxJ3y4XJJj4UxJyxV.jpg', 14, 2, 2);
INSERT INTO `merchat` VALUES (18, '辛小牛-梅菜扣肉', '12345', 'https://oss.heidoucms.com/images/506/2023/05/PrWs24Uc244u4ruRUu4PupwVE6cdTC.jpg', 12, 2, 2);
INSERT INTO `merchat` VALUES (19, '豪吃点8号店', '12345', 'https://oss.heidoucms.com/images/506/2023/05/Vi2IeVvxivvA6xfitFX2xnyXyXNVie.jpg', 12, 2, 2);
INSERT INTO `merchat` VALUES (20, '椰耶椰子', '12345', 'https://oss.heidoucms.com/images/506/2023/05/lS1rs84GwK6GgZZuzlC6g4SFG8jGZl.jpg', 13, 2, 2);
INSERT INTO `merchat` VALUES (21, '茶百道（公园π）', '12345', 'https://oss.heidoucms.com/images/506/2023/04/kJtJQnlnL39Aj19qTaJWCjTmMDWJjJ.jpg', 13, 2, 2);
INSERT INTO `merchat` VALUES (22, '杨国福麻辣烫', '12345', 'https://oss.heidoucms.com/images/506/2022/11/vZ03TjIWE2eFcVFhPbF6bHZ20V3W2Z.jpg', 14, 2, 2);
INSERT INTO `merchat` VALUES (23, '蔡大胖炸洋芋', '12345', 'https://oss.heidoucms.com/images/506/2022/08/WgdXZWJfCVF0QEGzWn4E4M49Jwe4gm.jpg', 14, 2, 2);
INSERT INTO `merchat` VALUES (24, '滋味小香锅·特色泡椒', '12345', 'https://oss.heidoucms.com/images/506/2023/05/eLlilic7E7ccxCiolExfc7O7CfOg7e.jpg', 15, 2, 2);
INSERT INTO `merchat` VALUES (25, '黑眼熊寿司&日式便当', '12345', 'https://oss.heidoucms.com/images/506/2023/04/Ch1W1b63DsOEdMjSMBzb1hmAevsRm3.jpg', 8, 2, 2);
INSERT INTO `merchat` VALUES (26, '煨制猪肘饭·戎串串', '12345', 'https://oss.heidoucms.com/images/506/2023/04/N23c3V6NsCcNy696911M1F191k2MYy.jpg', 14, 2, 2);
INSERT INTO `merchat` VALUES (27, '古茗（公园π）', '12345', 'https://oss.heidoucms.com/images/506/2023/04/cOONbVQZ3Yje8VfQy3IObINi3QJ83H.jpg', 1, 2, 2);
INSERT INTO `merchat` VALUES (28, '糖糖家肥牛饭', '12345', 'https://oss.heidoucms.com/images/506/2023/04/N6eL2LC0EL9bejEe2CCU99VeE9V02l.jpg', 1, 2, 2);
INSERT INTO `merchat` VALUES (29, '大吉和牛排手作意面', '12345', 'https://oss.heidoucms.com/images/506/2023/04/x6m659lmunf6k6bn2f3NF2z69ZFn5N.jpg', 2, 2, 2);
INSERT INTO `merchat` VALUES (30, '牛佰滋·手作牛肉汉堡', '12345', 'https://oss.heidoucms.com/images/506/2023/04/Yc9Zzc7QUD3uUO3Ue3Rmo44oJqQQEU.jpg', 4, 2, 2);
INSERT INTO `merchat` VALUES (31, '蜀九香干锅', '12345', 'https://oss.heidoucms.com/images/506/2023/04/QvEJVUWjvJw6j386e38zpGGuW85gJe.jpg', 3, 2, 2);
INSERT INTO `merchat` VALUES (32, '牦牛道·泡椒牛肉米线', '12345', 'https://oss.heidoucms.com/images/506/2023/03/S4OLzQoNtg0vVQmlom4ROtoQGlqQ00.jpg', 2, 2, 2);
INSERT INTO `merchat` VALUES (33, '老麻抄手+周记羊肉米', '12345', 'https://oss.heidoucms.com/images/506/2022/11/MZ8FALKf6KI0r7yB6QEfKaiQk6k8BI.jpg', 5, 2, 2);
INSERT INTO `merchat` VALUES (34, '美妙时刻功夫煎饼', '12345', 'https://oss.heidoucms.com/images/506/2022/11/F8CG9JP2V8dG81cOX2dgVdB8NGJZ2P.jpg', 6, 2, 2);
INSERT INTO `merchat` VALUES (35, '陈多多（公园π）', '12345', 'https://oss.heidoucms.com/images/506/2023/04/Qp4ZKpTonn1t0OQro3KHkvN3xK1ohO.jpg', 7, 2, 2);
INSERT INTO `merchat` VALUES (37, '疆粉儿·新疆炒米粉', '12345', 'https://oss.heidoucms.com/images/506/2023/04/Fgh7n7UuuGhhNbBsnDBd9puz59Hh3P.jpg', 8, 2, 2);
INSERT INTO `merchat` VALUES (38, '十七味螺蛳粉', '12345', 'https://oss.heidoucms.com/images/506/2022/08/C76q2ptE76642R267QZR7pnT2e4p06.jpg', 4, 2, 2);
INSERT INTO `merchat` VALUES (39, '卡麦滋炸鸡汉堡', '12345', 'https://oss.heidoucms.com/images/506/2022/08/AeG2rDEKbBKHU2DQ2tEW2Wb9dk2u2W.jpg', 3, 2, 2);
INSERT INTO `merchat` VALUES (41, '二妹大碗卤肉饭', '12345', 'https://oss.heidoucms.com/images/506/2023/05/Pu5I0Bo0zOZp03u6uRoI683i70VBBu.jpg', 2, 2, 2);
INSERT INTO `merchat` VALUES (42, '詹记均州烧腊', '12345', 'https://oss.heidoucms.com/images/506/2022/05/CW514LLapM4wA6MwJ3LM65Pw6al54P.jpg', 8, 2, 2);
INSERT INTO `merchat` VALUES (43, '五花筒·口水鸡·椒麻', '12345', 'https://oss.heidoucms.com/images/506/2023/02/noL64NF3n4hAWO439QLw39WNQojwFo.jpg', 7, 2, 2);
INSERT INTO `merchat` VALUES (44, '三顾冒菜', '12345', 'https://oss.heidoucms.com/images/506/2021/12/wu9kEUvezk18MKT6T6MU8EVJ9EJncu.jpeg', 5, 2, 2);
INSERT INTO `merchat` VALUES (45, '卷了个饼', '12345', 'https://oss.heidoucms.com/images/506/2021/12/cR48JMxJ6Je8MDqea1Kx98k81ljXE6.jpg', 6, 2, 2);
INSERT INTO `merchat` VALUES (46, '超凡炸鸡', '12345', 'https://oss.heidoucms.com/images/506/2021/11/VeIV5VyISMlmVLulILm82m8vMi8avw.jpg', 7, 2, 2);
INSERT INTO `merchat` VALUES (47, '欧尼炸鸡', '12345', 'https://oss.heidoucms.com/images/506/2022/07/A6P6OoZ62QPR22Mnn512RY211Z7p4P.jpeg', 8, 2, 2);
INSERT INTO `merchat` VALUES (48, '叫了只炸鸡', '12345', 'https://oss.heidoucms.com/images/506/2023/04/l9wiw06o182JWJI68VO0Qz29iM4182.jpg', 9, 2, 2);
INSERT INTO `merchat` VALUES (49, '库迪咖啡（公园π）', '12345', 'https://oss.heidoucms.com/images/506/2023/04/h4gg1YOMdG5MK4mZ4ks554M54lIVll.jpg', 10, 2, 2);
INSERT INTO `merchat` VALUES (50, 'Gooben炸鸡', '12345', 'https://oss.heidoucms.com/images/506/2023/04/zs66vYsfzi1NZwFfCA2fM1CWlRrYVI.jpg', 11, 2, 2);
INSERT INTO `merchat` VALUES (51, '书亦烧仙草', '12345', 'https://oss.heidoucms.com/images/506/2023/02/VB3zXHoQuRJ1WMiMu2zH2jK2uCJcIQ.jpeg', 12, 2, 2);
INSERT INTO `merchat` VALUES (52, '德克士', '12345', 'https://oss.heidoucms.com/images/506/2023/04/ktJG3pzbbxWkBAq6ezwGe3356vPjVE.jpg', 13, 2, 2);
INSERT INTO `merchat` VALUES (60, 'lhj', 'lhj', NULL, NULL, 2, 2);
INSERT INTO `merchat` VALUES (61, '123456', '123456', NULL, NULL, 2, 2);

-- ----------------------------
-- Table structure for multiaddress
-- ----------------------------
DROP TABLE IF EXISTS `multiaddress`;
CREATE TABLE `multiaddress`  (
  `addressId` int(11) NOT NULL AUTO_INCREMENT,
  `region` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `street` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `detailAddress` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`addressId`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 17 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of multiaddress
-- ----------------------------
INSERT INTO `multiaddress` VALUES (1, '蒙德', '蒙德城', '猎鹿人餐馆');
INSERT INTO `multiaddress` VALUES (2, '蒙德', '猫尾酒馆', '七号桌');
INSERT INTO `multiaddress` VALUES (3, '蒙德', '猫尾酒馆', '九号桌');
INSERT INTO `multiaddress` VALUES (4, '蒙德', '猫尾酒馆', '六号桌');
INSERT INTO `multiaddress` VALUES (5, '蒙德', '猫尾酒馆', '十号桌');
INSERT INTO `multiaddress` VALUES (6, '蒙德', '猫尾酒馆', '十一号桌');
INSERT INTO `multiaddress` VALUES (7, '璃月', '璃月城', '万民堂');
INSERT INTO `multiaddress` VALUES (8, '璃月', '璃月城', '琉璃亭');
INSERT INTO `multiaddress` VALUES (9, '璃月', '璃月城', '新月轩');
INSERT INTO `multiaddress` VALUES (10, '须弥', '须弥城', '兰巴德酒馆');
INSERT INTO `multiaddress` VALUES (11, '须弥', '须弥城', '普斯帕咖啡馆');
INSERT INTO `multiaddress` VALUES (12, '稻妻', '稻妻城', '木漏茶室');
INSERT INTO `multiaddress` VALUES (13, '稻妻', '稻妻城', '志村屋');
INSERT INTO `multiaddress` VALUES (14, '蒙德', '蒙德城', '天使的馈赠');
INSERT INTO `multiaddress` VALUES (15, '蒙德', '奔狼领', '塞西莉亚苗圃');

-- ----------------------------
-- Table structure for news
-- ----------------------------
DROP TABLE IF EXISTS `news`;
CREATE TABLE `news`  (
  `newsId` int(11) NOT NULL AUTO_INCREMENT,
  `newsContent` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `time` datetime NOT NULL,
  `uewId` int(11) NOT NULL,
  `mewId` int(11) NOT NULL,
  PRIMARY KEY (`newsId`) USING BTREE,
  INDEX `n_user`(`uewId`) USING BTREE,
  INDEX `n_mar`(`mewId`) USING BTREE,
  CONSTRAINT `n_mar` FOREIGN KEY (`mewId`) REFERENCES `merchat` (`merId`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `n_user` FOREIGN KEY (`uewId`) REFERENCES `user` (`userId`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 35 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of news
-- ----------------------------
INSERT INTO `news` VALUES (1, '好吃', '2023-07-03 10:05:45', 2, 1);
INSERT INTO `news` VALUES (4, '好吃的很', '2023-07-03 10:06:20', 4, 1);
INSERT INTO `news` VALUES (6, '好吃的很!!!!!', '2023-07-03 10:23:32', 2, 1);
INSERT INTO `news` VALUES (7, '好吃的很好吃的很', '2023-07-03 10:23:48', 2, 1);
INSERT INTO `news` VALUES (8, '好吃的很好吃的很好吃的很好吃的很', '2023-07-03 10:24:53', 2, 1);
INSERT INTO `news` VALUES (9, '好吃的很好吃的很', '2023-07-03 10:25:02', 2, 1);
INSERT INTO `news` VALUES (10, '好吃的很好吃的很好吃的很好吃的很', '2023-07-03 10:26:08', 4, 1);
INSERT INTO `news` VALUES (11, '的很好吃的很好', '2023-07-03 14:44:47', 4, 1);
INSERT INTO `news` VALUES (13, '巴适得很', '2023-07-03 16:16:50', 4, 1);
INSERT INTO `news` VALUES (16, 'asGV安慰谁给他', '2023-07-04 22:21:45', 4, 4);
INSERT INTO `news` VALUES (17, '搜嘎女人提货人', '2023-07-04 22:25:06', 4, 1);
INSERT INTO `news` VALUES (18, '埃尔法违规', '2023-07-04 22:25:51', 4, 17);
INSERT INTO `news` VALUES (19, '阿尔法哇瑟发完', '2023-07-04 22:53:02', 4, 12);
INSERT INTO `news` VALUES (20, '沙发二十日嘎我二哥', '2023-07-04 22:53:23', 4, 17);
INSERT INTO `news` VALUES (21, '这网站不错', '2023-07-06 01:31:09', 4, 17);
INSERT INTO `news` VALUES (22, '这家管子还行', '2023-07-06 01:31:31', 4, 7);
INSERT INTO `news` VALUES (23, '确实不错', '2023-07-06 04:27:20', 1, 17);
INSERT INTO `news` VALUES (24, '优化也不错', '2023-07-06 04:36:52', 1, 17);
INSERT INTO `news` VALUES (25, '挺好吃的', '2023-07-06 09:11:32', 5, 17);
INSERT INTO `news` VALUES (26, '实惠，价格也不贵', '2023-07-06 09:11:39', 6, 5);
INSERT INTO `news` VALUES (27, 'as', '2023-07-06 10:52:25', 1, 17);
INSERT INTO `news` VALUES (28, '天地银行特点', '2023-07-06 10:52:34', 1, 6);
INSERT INTO `news` VALUES (29, '123', '2023-07-06 13:34:27', 2, 17);
INSERT INTO `news` VALUES (30, '123', '2023-07-06 13:34:34', 2, 3);
INSERT INTO `news` VALUES (31, '默认发送给点餐系统', '2023-07-06 13:38:00', 2, 17);
INSERT INTO `news` VALUES (32, '所有的数据均来自数据库merchat表', '2023-07-06 13:38:20', 2, 3);
INSERT INTO `news` VALUES (33, '瓦达', '2023-07-09 23:42:11', 1, 17);
INSERT INTO `news` VALUES (34, '非常好吃', '2023-07-09 23:42:33', 1, 8);

-- ----------------------------
-- Table structure for order_dish
-- ----------------------------
DROP TABLE IF EXISTS `order_dish`;
CREATE TABLE `order_dish`  (
  `orderID` int(11) NULL DEFAULT NULL,
  `dishID` int(11) NULL DEFAULT NULL,
  `quantityOrdered` int(11) NULL DEFAULT 0,
  `time` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '插入判断的标准，time来自后端',
  INDEX `orderID`(`orderID`) USING BTREE,
  INDEX `dishID`(`dishID`) USING BTREE,
  CONSTRAINT `order_dish_ibfk_1` FOREIGN KEY (`orderID`) REFERENCES `orders` (`orderId`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `order_dish_ibfk_2` FOREIGN KEY (`dishID`) REFERENCES `dish` (`dishId`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of order_dish
-- ----------------------------
INSERT INTO `order_dish` VALUES (10, 5, 20, '2023-07-05 00:52:57');
INSERT INTO `order_dish` VALUES (10, 5, 20, '2023-07-05 00:52:57');
INSERT INTO `order_dish` VALUES (10, 6, 20, '2023-07-05 00:52:57');
INSERT INTO `order_dish` VALUES (10, 7, 20, '2023-07-05 00:52:57');
INSERT INTO `order_dish` VALUES (10, 7, 10, '2023-07-05 00:52:57');
INSERT INTO `order_dish` VALUES (11, 5, 20, '2023-07-05 00:56:47');
INSERT INTO `order_dish` VALUES (11, 5, 20, '2023-07-05 00:56:47');
INSERT INTO `order_dish` VALUES (11, 6, 20, '2023-07-05 00:56:47');
INSERT INTO `order_dish` VALUES (11, 7, 20, '2023-07-05 00:56:47');
INSERT INTO `order_dish` VALUES (11, 7, 10, '2023-07-05 00:56:47');
INSERT INTO `order_dish` VALUES (12, 11, 3, '2023-07-05 22:57:08');
INSERT INTO `order_dish` VALUES (12, 11, 3, '2023-07-05 22:57:08');
INSERT INTO `order_dish` VALUES (12, 11, 3, '2023-07-05 22:57:08');
INSERT INTO `order_dish` VALUES (13, 11, 3, '2023-07-05 23:28:49');
INSERT INTO `order_dish` VALUES (13, 11, 3, '2023-07-05 23:28:49');
INSERT INTO `order_dish` VALUES (23, 5, 2, '2023-07-06 00:58:38');
INSERT INTO `order_dish` VALUES (23, 5, 2, '2023-07-06 00:58:38');
INSERT INTO `order_dish` VALUES (23, 5, 2, '2023-07-06 00:58:38');
INSERT INTO `order_dish` VALUES (23, 5, 2, '2023-07-06 00:58:38');
INSERT INTO `order_dish` VALUES (23, 5, 2, '2023-07-06 00:58:38');
INSERT INTO `order_dish` VALUES (24, 11, 2, '2023-07-06 09:10:06');
INSERT INTO `order_dish` VALUES (24, 11, 2, '2023-07-06 09:10:06');
INSERT INTO `order_dish` VALUES (25, 6, 2, '2023-07-06 10:51:33');
INSERT INTO `order_dish` VALUES (26, 6, 3, '2023-07-06 13:31:35');
INSERT INTO `order_dish` VALUES (26, 6, 3, '2023-07-06 13:31:35');
INSERT INTO `order_dish` VALUES (27, 7, 1, '2023-07-06 13:33:23');
INSERT INTO `order_dish` VALUES (27, 7, 1, '2023-07-06 13:33:23');
INSERT INTO `order_dish` VALUES (27, 7, 1, '2023-07-06 13:33:23');
INSERT INTO `order_dish` VALUES (28, 7, 1, '2023-07-06 13:36:34');
INSERT INTO `order_dish` VALUES (28, 7, 1, '2023-07-06 13:36:34');
INSERT INTO `order_dish` VALUES (28, 7, 1, '2023-07-06 13:36:34');

-- ----------------------------
-- Table structure for orders
-- ----------------------------
DROP TABLE IF EXISTS `orders`;
CREATE TABLE `orders`  (
  `orderId` int(11) NOT NULL AUTO_INCREMENT,
  `o_userId` int(11) NOT NULL,
  `o_merId` int(11) NOT NULL,
  `o_addressId` int(11) NOT NULL,
  `time` datetime NULL DEFAULT CURRENT_TIMESTAMP,
  `totalPrice` double(6, 2) NULL DEFAULT NULL,
  `status` enum('0','1') CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0',
  PRIMARY KEY (`orderId`) USING BTREE,
  INDEX `userOrder`(`o_userId`) USING BTREE,
  INDEX `merchatOrder`(`o_merId`) USING BTREE,
  INDEX `orderAddress`(`o_addressId`) USING BTREE,
  CONSTRAINT `merchatOrder` FOREIGN KEY (`o_merId`) REFERENCES `merchat` (`merId`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `orderAddress` FOREIGN KEY (`o_addressId`) REFERENCES `multiaddress` (`addressId`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `userOrder` FOREIGN KEY (`o_userId`) REFERENCES `user` (`userId`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 29 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of orders
-- ----------------------------
INSERT INTO `orders` VALUES (4, 2, 1, 1, '2023-07-03 10:48:50', 380.00, '1');
INSERT INTO `orders` VALUES (5, 2, 1, 1, '2023-07-03 11:11:56', 380.00, '0');
INSERT INTO `orders` VALUES (10, 2, 1, 1, '2023-07-05 00:52:57', 1710.00, '1');
INSERT INTO `orders` VALUES (11, 2, 1, 1, '2023-07-05 00:56:47', 1710.00, '0');
INSERT INTO `orders` VALUES (12, 2, 1, 1, '2023-07-05 22:57:08', 144.00, '0');
INSERT INTO `orders` VALUES (13, 2, 1, 1, '2023-07-05 23:28:49', 96.00, '0');
INSERT INTO `orders` VALUES (14, 1, 1, 11, '2023-07-05 23:35:40', 114.00, '1');
INSERT INTO `orders` VALUES (15, 1, 1, 11, '2023-07-05 23:35:56', 514.00, '1');
INSERT INTO `orders` VALUES (16, 1, 1, 11, '2023-07-05 23:36:59', 19.00, '1');
INSERT INTO `orders` VALUES (20, 6, 3, 9, '2023-07-05 23:41:53', 11.00, '0');
INSERT INTO `orders` VALUES (21, 6, 4, 9, '2023-07-05 23:42:57', 50.00, '0');
INSERT INTO `orders` VALUES (22, 6, 1, 1, '2023-07-05 23:44:01', 40.00, '0');
INSERT INTO `orders` VALUES (23, 2, 1, 1, '2023-07-06 00:58:38', 170.00, '1');
INSERT INTO `orders` VALUES (24, 1, 1, 4, '2023-07-06 09:10:06', 64.00, '1');
INSERT INTO `orders` VALUES (25, 1, 1, 4, '2023-07-06 10:51:33', 34.00, '0');
INSERT INTO `orders` VALUES (26, 2, 1, 1, '2023-07-06 13:31:35', 102.00, '0');
INSERT INTO `orders` VALUES (27, 2, 1, 1, '2023-07-06 13:33:23', 69.00, '0');
INSERT INTO `orders` VALUES (28, 2, 1, 1, '2023-07-06 13:36:34', 69.00, '0');

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user`  (
  `userId` int(11) NOT NULL AUTO_INCREMENT,
  `userName` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `userPassword` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `userImg` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `u_addressId` int(11) NULL DEFAULT NULL,
  `userAuthority` tinyint(4) NULL DEFAULT 2,
  `type` tinyint(1) NULL DEFAULT 3,
  PRIMARY KEY (`userId`) USING BTREE,
  INDEX `userAddress`(`u_addressId`) USING BTREE,
  CONSTRAINT `userAddress` FOREIGN KEY (`u_addressId`) REFERENCES `multiaddress` (`addressId`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 35 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES (1, '卡芙卡', '12345', '	https://img1.baidu.com/it/u=474361924,4279238272&fm=253&fmt=auto&app=120&f=JPEG?w=500&h=570', 4, 2, 3);
INSERT INTO `user` VALUES (2, '可莉', '1234567', 'https://i02piccdn.sogoucdn.com/ffe5c9856baa96a9', 1, 2, 3);
INSERT INTO `user` VALUES (3, 'DIONA', '12345', '	https://i03piccdn.sogoucdn.com/720a3a4154878bb6', 3, 2, 3);
INSERT INTO `user` VALUES (4, '兰极', '12346', 'https://i02piccdn.sogoucdn.com/5dfcafdfdfa4e18c', 1, 2, 3);
INSERT INTO `user` VALUES (5, '芙宁娜', '123', 'https://pic.rmb.bdstatic.com/bjh/49b311d144f87239be36bb44d9d045443818.jpeg@h_1280', 1, 2, 3);
INSERT INTO `user` VALUES (6, 'Azinya', '12345', 'https://img1.baidu.com/it/u=3979391043,266749828&fm=253&app=138&size=w931&n=0&f=JPEG&fmt=auto?sec=1688662800&t=c509dcb39d818e5b50f08a494b142333', 10, 2, 3);
INSERT INTO `user` VALUES (9, 'DIONA', '123456', '	https://i02piccdn.sogoucdn.com/2ab4ae45a7bb08da', 6, 2, 3);
INSERT INTO `user` VALUES (32, 'lj', 'lj', NULL, NULL, 2, 3);
INSERT INTO `user` VALUES (34, '123456', '123456', NULL, NULL, 2, 3);

SET FOREIGN_KEY_CHECKS = 1;