cloud-printing-api
/
cloud_printing2.sql

/*
 Navicat Premium Data Transfer

 Source Server         : 小皮
 Source Server Type    : MySQL
 Source Server Version : 80012
 Source Host           : localhost:3306
 Source Schema         : cloud_printing2

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

 Date: 24/04/2022 12:02:36
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for address
-- ----------------------------
DROP TABLE IF EXISTS `address`;
CREATE TABLE `address`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `address` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `name` varchar(11) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT '姓名',
  `phone_number` varchar(11) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT '联系电话',
  `default_address` int(1) NULL DEFAULT NULL COMMENT '1：是，0否',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `fk_address_wx_user_1`(`user_id`) USING BTREE,
  CONSTRAINT `fk_address_wx_user_1` FOREIGN KEY (`user_id`) REFERENCES `wx_user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of address
-- ----------------------------
INSERT INTO `address` VALUES (1, 1, '清风阁2521', 'cjh', '13899996665', 1);
INSERT INTO `address` VALUES (2, 1, '清风阁2521', '蔡佳煌', '13790838659', 0);

-- ----------------------------
-- Table structure for clerk
-- ----------------------------
DROP TABLE IF EXISTS `clerk`;
CREATE TABLE `clerk`  (
  `user_id` int(11) NOT NULL,
  `store_id` int(11) NOT NULL,
  PRIMARY KEY (`user_id`, `store_id`) USING BTREE,
  INDEX `fk_clerk_store_1`(`store_id`) USING BTREE,
  CONSTRAINT `fk_clerk_store_1` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `fk_clerk_user_1` FOREIGN KEY (`user_id`) REFERENCES `user` (`user_id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of clerk
-- ----------------------------
INSERT INTO `clerk` VALUES (8, 1);
INSERT INTO `clerk` VALUES (9, 2);

-- ----------------------------
-- Table structure for commodity
-- ----------------------------
DROP TABLE IF EXISTS `commodity`;
CREATE TABLE `commodity`  (
  `commodity` int(11) NOT NULL AUTO_INCREMENT COMMENT '商品主键',
  `store_id` int(11) NULL DEFAULT NULL COMMENT '外键，门店id',
  `specifications_id` int(11) NULL DEFAULT NULL COMMENT '商品规格外键',
  `image` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT '图片',
  `commodity_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '商品名称',
  `is_show` int(11) NULL DEFAULT NULL COMMENT '是否显示,1:是，0：否',
  `sort` int(4) NULL DEFAULT NULL COMMENT '排序，最大9999',
  `is_multi_specification` int(1) NULL DEFAULT NULL COMMENT '0:单规格 1：多规格',
  PRIMARY KEY (`commodity`) USING BTREE,
  INDEX `fk_commodity_store_1`(`store_id`) USING BTREE,
  INDEX `fk_commodity_specifications_1`(`specifications_id`) USING BTREE,
  CONSTRAINT `fk_commodity_specifications_1` FOREIGN KEY (`specifications_id`) REFERENCES `specifications` (`specifications_id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `fk_commodity_store_1` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 26 CHARACTER SET = utf8 COLLATE = utf8_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of commodity
-- ----------------------------
INSERT INTO `commodity` VALUES (1, 1, NULL, '/upload/commodity/1c6d764e-e628-4ea6-b1cc-503a46f9b81d.jpg', 'A4黑白打印', 1, 1, 0);
INSERT INTO `commodity` VALUES (2, 1, 1, '/upload/commodity/85c02c26-c018-4697-8059-81f7ec20308a.jpeg', '打印', 1, 1, 1);
INSERT INTO `commodity` VALUES (14, 2, NULL, '/upload/commodity/faa29477-3aa6-4c03-b73b-7358aafb26f5.jpg', 'asd', 0, 1, 0);
INSERT INTO `commodity` VALUES (15, 1, NULL, '/upload/commodity/faa29477-3aa6-4c03-b73b-7358aafb26f5.jpg', 'asd', 0, 1, 0);
INSERT INTO `commodity` VALUES (16, 2, NULL, '/upload/commodity/16297cc5-4987-4d84-b30f-43b4f1569cae.jpg', 'asd', 0, 1, 0);
INSERT INTO `commodity` VALUES (19, 1, NULL, '', 'asd', 0, 1, 0);
INSERT INTO `commodity` VALUES (20, 1, 1, '', 'asd', 0, 1, 1);
INSERT INTO `commodity` VALUES (21, 1, NULL, '', 'ads', 0, 1, 0);
INSERT INTO `commodity` VALUES (26, 2, 1, '/upload/commodity/3b4560cb-86b1-44cb-a536-fa288102e662.jpg', '打印', 1, 1, 1);

-- ----------------------------
-- Table structure for commodity_details
-- ----------------------------
DROP TABLE IF EXISTS `commodity_details`;
CREATE TABLE `commodity_details`  (
  `commodity_details_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '商品详情主键',
  `commodity` int(11) NOT NULL COMMENT '商品外键',
  `price` decimal(10, 2) NOT NULL COMMENT '商品价格',
  `sales` int(11) NULL DEFAULT 0 COMMENT '销量',
  `stock` int(11) NOT NULL COMMENT '库存',
  `cost` decimal(10, 2) NOT NULL COMMENT '成本价',
  `introduction` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '简介',
  PRIMARY KEY (`commodity_details_id`) USING BTREE,
  INDEX `fk_commodity_details_commodity_1`(`commodity`) USING BTREE,
  CONSTRAINT `fk_commodity_details_commodity_1` FOREIGN KEY (`commodity`) REFERENCES `commodity` (`commodity`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 36 CHARACTER SET = utf8 COLLATE = utf8_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of commodity_details
-- ----------------------------
INSERT INTO `commodity_details` VALUES (1, 1, 0.25, 500, 78749, 0.10, 'A4黑白打印');
INSERT INTO `commodity_details` VALUES (2, 2, 0.25, 500, 67673, 0.10, 'A4黑白打印');
INSERT INTO `commodity_details` VALUES (3, 2, 0.50, 243, 4578, 0.25, 'A4彩色打印');
INSERT INTO `commodity_details` VALUES (4, 2, 0.50, 138, 572, 0.25, 'A3黑白打印');
INSERT INTO `commodity_details` VALUES (5, 2, 1.00, 96, 0, 0.50, 'A3彩色打印');
INSERT INTO `commodity_details` VALUES (12, 14, 0.00, 0, 0, 0.00, '');
INSERT INTO `commodity_details` VALUES (13, 15, 0.00, 0, 0, 0.00, '');
INSERT INTO `commodity_details` VALUES (14, 16, 22.00, 0, 12312, 12.00, '');
INSERT INTO `commodity_details` VALUES (16, 19, 123.00, 0, 123, 123.00, '');
INSERT INTO `commodity_details` VALUES (17, 20, 1.00, 0, 321, 2.00, '');
INSERT INTO `commodity_details` VALUES (18, 20, 213.00, 0, 123213, 2.00, '');
INSERT INTO `commodity_details` VALUES (19, 20, 112.00, 0, 123, 2.00, '');
INSERT INTO `commodity_details` VALUES (20, 20, 213.00, 0, 132, 2.00, '');
INSERT INTO `commodity_details` VALUES (22, 21, 0.00, 0, 0, 0.00, '');
INSERT INTO `commodity_details` VALUES (33, 26, 0.25, 0, 9988, 0.10, '');
INSERT INTO `commodity_details` VALUES (34, 26, 0.50, 0, 9999, 0.20, '');
INSERT INTO `commodity_details` VALUES (35, 26, 0.50, 0, 9998, 0.20, '');
INSERT INTO `commodity_details` VALUES (36, 26, 1.00, 0, 9999, 0.50, '');

-- ----------------------------
-- Table structure for details_value
-- ----------------------------
DROP TABLE IF EXISTS `details_value`;
CREATE TABLE `details_value`  (
  `commodity_details_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '商品详情外键',
  `group_value_id` int(11) NOT NULL COMMENT '规格组值的外键',
  PRIMARY KEY (`commodity_details_id`, `group_value_id`) USING BTREE,
  INDEX `fk_details_value_group_value_1`(`group_value_id`) USING BTREE,
  CONSTRAINT `fk_details_value_commodity_details_1` FOREIGN KEY (`commodity_details_id`) REFERENCES `commodity_details` (`commodity_details_id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `fk_details_value_group_value_1` FOREIGN KEY (`group_value_id`) REFERENCES `group_value` (`group_value_id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 36 CHARACTER SET = utf8 COLLATE = utf8_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of details_value
-- ----------------------------
INSERT INTO `details_value` VALUES (2, 1);
INSERT INTO `details_value` VALUES (4, 1);
INSERT INTO `details_value` VALUES (17, 1);
INSERT INTO `details_value` VALUES (18, 1);
INSERT INTO `details_value` VALUES (33, 1);
INSERT INTO `details_value` VALUES (34, 1);
INSERT INTO `details_value` VALUES (3, 2);
INSERT INTO `details_value` VALUES (5, 2);
INSERT INTO `details_value` VALUES (19, 2);
INSERT INTO `details_value` VALUES (20, 2);
INSERT INTO `details_value` VALUES (35, 2);
INSERT INTO `details_value` VALUES (36, 2);
INSERT INTO `details_value` VALUES (2, 3);
INSERT INTO `details_value` VALUES (3, 3);
INSERT INTO `details_value` VALUES (17, 3);
INSERT INTO `details_value` VALUES (19, 3);
INSERT INTO `details_value` VALUES (33, 3);
INSERT INTO `details_value` VALUES (35, 3);
INSERT INTO `details_value` VALUES (4, 4);
INSERT INTO `details_value` VALUES (5, 4);
INSERT INTO `details_value` VALUES (18, 4);
INSERT INTO `details_value` VALUES (20, 4);
INSERT INTO `details_value` VALUES (34, 4);
INSERT INTO `details_value` VALUES (36, 4);

-- ----------------------------
-- Table structure for evaluate
-- ----------------------------
DROP TABLE IF EXISTS `evaluate`;
CREATE TABLE `evaluate`  (
  `evaluate_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '评价表主键',
  `comment` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT '评价内容',
  `image` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT '评价图片列表',
  `rate` int(1) NOT NULL COMMENT '评分',
  `create_time` datetime(0) NOT NULL COMMENT '评价时间',
  PRIMARY KEY (`evaluate_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 16 CHARACTER SET = utf8 COLLATE = utf8_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of evaluate
-- ----------------------------
INSERT INTO `evaluate` VALUES (1, 'asdasd', '[\"/upload/evaluateImage/07ebaf18-ea36-4d75-8f4e-455a59cda415.jpg\",\"/upload/evaluateImage/ba6c8250-5f41-4a73-be68-f201160df1a8.png\",\"/upload/evaluateImage/5838f7e5-3c9c-44c5-876c-72828cd1bc6b.jpeg\",\"/upload/evaluateImage/b559b09d-38d0-4afb-a401-96c9c42e9cb2.png\",\"/upload/evaluateImage/da66e9f1-916b-4eff-9721-d345202624b9.png\"]', 5, '2022-03-09 21:29:37');
INSERT INTO `evaluate` VALUES (2, 'asdasdad', '[\"/upload/evaluateImage/efa21557-8520-4277-8c1e-5195314528a4.jpg\",\"/upload/evaluateImage/a34e5b33-d613-4a0d-ac53-2838e3964f04.png\",\"/upload/evaluateImage/6e40404e-8d03-43d2-b33f-bc6425fc849b.jpeg\"]', 5, '2022-03-09 21:40:14');
INSERT INTO `evaluate` VALUES (3, 'qwqwewqwqeeqwqewqewewqeqweqw', '[\"/upload/evaluateImage/94058ae7-f894-4998-b2ea-a08f31bbb14f.png\",\"/upload/evaluateImage/e9266ee8-3306-467c-a1fa-67bcc038e5cf.png\"]', 5, '2022-03-09 21:42:17');
INSERT INTO `evaluate` VALUES (4, 'asddsa', '[\"/upload/evaluateImage/f850f2c5-4441-4395-a749-6553282acae0.png\",\"/upload/evaluateImage/61978c9f-bef6-450f-a9b5-86c1b6700b4f.png\"]', 5, '2022-03-09 21:45:56');
INSERT INTO `evaluate` VALUES (5, 'asdads', '[\"/upload/evaluateImage/05ceb01c-3286-481d-9a49-14510288b31f.jpeg\",\"/upload/evaluateImage/b31e7f47-16b5-4185-8c30-07fd64e151a8.png\",\"/upload/evaluateImage/48ba14de-5811-4de2-8047-3c1fea83e8d0.png\"]', 5, '2022-03-12 13:52:04');
INSERT INTO `evaluate` VALUES (6, 'asdas', '[]', 5, '2022-03-12 13:54:30');
INSERT INTO `evaluate` VALUES (7, 'asdasd', '[\"/upload/evaluateImage/65b027ab-0489-42ae-a080-698f7c11ac74.png\"]', 4, '2022-03-15 19:59:27');
INSERT INTO `evaluate` VALUES (8, '很好', '[\"/upload/evaluateImage/54efc15c-e3ab-47c0-9895-325e680019fa.jpeg\",\"/upload/evaluateImage/62b0332e-0c4e-46ec-815a-93cc7809173d.png\",\"/upload/evaluateImage/a8415b9d-a08b-40f7-87d3-49f4f9360e67.png\"]', 5, '2022-04-16 16:36:29');
INSERT INTO `evaluate` VALUES (9, '好', '[\"/upload/evaluateImage/003a35bc-ac8e-489d-bada-82fec40ff023.jpg\",\"/upload/evaluateImage/b88200e4-04b7-45b0-a463-4de6f82cc089.png\",\"/upload/evaluateImage/f9fc159b-744b-4cbf-ba77-818c3688020a.jpeg\",\"/upload/evaluateImage/b954e025-b643-4f33-b9e3-5081baec48d5.png\"]', 5, '2022-04-17 20:33:30');
INSERT INTO `evaluate` VALUES (10, '好', '[\"/upload/evaluateImage/86318a79-9ce8-4632-8b6b-a7fc6019912f.png\",\"/upload/evaluateImage/4a7a5d25-b01c-4fd7-ae43-defd2a68acbc.png\"]', 4, '2022-04-18 21:51:04');
INSERT INTO `evaluate` VALUES (11, '哈', '[\"/upload/evaluateImage/302f01a6-6f13-4aa4-a6e3-8a125a3b506c.jpg\",\"/upload/evaluateImage/54e2acbf-7b42-4a86-a61b-d29a1ee19dd4.png\",\"/upload/evaluateImage/37ed151d-a783-43e8-9323-a97e029022d8.jpeg\"]', 4, '2022-04-19 21:56:52');
INSERT INTO `evaluate` VALUES (12, '按时', '[\"/upload/evaluateImage/53c5774b-4246-48f3-98d6-2e38104825a7.jpeg\",\"/upload/evaluateImage/451ab914-e92b-4342-b730-da1ff981707a.png\"]', 4, '2022-04-20 19:35:45');
INSERT INTO `evaluate` VALUES (13, 'hao', '[\"/upload/evaluateImage/44cc96f2-d25a-4b4c-ae77-8eaf379ff900.jpeg\",\"/upload/evaluateImage/8f192fe5-df56-44a1-b598-befcf8986c11.png\",\"/upload/evaluateImage/cc032e3c-7736-4c42-9560-bf733fd6b298.png\"]', 5, '2022-04-21 22:00:48');
INSERT INTO `evaluate` VALUES (14, 'hh', '[\"/upload/evaluateImage/f006ea9d-7f3f-489c-a8f4-bddd06196491.png\",\"/upload/evaluateImage/8bdc9965-3b01-4afd-88d6-50a250120cfd.png\"]', 5, '2022-04-21 22:21:38');
INSERT INTO `evaluate` VALUES (15, 'h  ', '[\"/upload/evaluateImage/e0961acc-3890-4beb-b33c-3c10b49dc4f2.png\",\"/upload/evaluateImage/31fe2745-7da9-4332-9279-647cb96931d8.png\",\"/upload/evaluateImage/5503a9e9-864d-410e-80c4-93eaaf9f0b02.png\"]', 4, '2022-04-21 22:35:33');
INSERT INTO `evaluate` VALUES (16, 'h ', '[\"/upload/evaluateImage/f16f4c26-0b67-4bbc-8506-42a8f0175473.png\",\"/upload/evaluateImage/96e0602f-3a63-46df-80c1-524e31fb7801.png\"]', 4, '2022-04-22 09:52:32');

-- ----------------------------
-- Table structure for group_value
-- ----------------------------
DROP TABLE IF EXISTS `group_value`;
CREATE TABLE `group_value`  (
  `group_value_id` int(11) NOT NULL AUTO_INCREMENT,
  `type_group_id` int(11) NOT NULL COMMENT '商品类型 值外键',
  `group_value_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT '值名称',
  PRIMARY KEY (`group_value_id`) USING BTREE,
  INDEX `fk_group_value_type_group_1`(`type_group_id`) USING BTREE,
  CONSTRAINT `fk_group_value_type_group_1` FOREIGN KEY (`type_group_id`) REFERENCES `type_group` (`type_group_id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 96 CHARACTER SET = utf8 COLLATE = utf8_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of group_value
-- ----------------------------
INSERT INTO `group_value` VALUES (1, 1, '黑白');
INSERT INTO `group_value` VALUES (2, 1, '彩色');
INSERT INTO `group_value` VALUES (3, 2, 'A4');
INSERT INTO `group_value` VALUES (4, 2, 'A3');

-- ----------------------------
-- Table structure for order_commodity
-- ----------------------------
DROP TABLE IF EXISTS `order_commodity`;
CREATE TABLE `order_commodity`  (
  `order_commodity` int(11) NOT NULL AUTO_INCREMENT COMMENT '订单商品表主键',
  `order_id` int(20) NOT NULL,
  `commodity_details_id` int(11) NOT NULL COMMENT '商品详情外键',
  `quantity` int(11) NOT NULL COMMENT '商品数量',
  `unit_price` decimal(10, 2) NOT NULL COMMENT '商品单价',
  PRIMARY KEY (`order_commodity`) USING BTREE,
  INDEX `fk_order_commondity_order_1`(`order_id`) USING BTREE,
  INDEX `fk_order_commondity_commodity_details_1`(`commodity_details_id`) USING BTREE,
  CONSTRAINT `fk_order_commondity_commodity_details_1` FOREIGN KEY (`commodity_details_id`) REFERENCES `commodity_details` (`commodity_details_id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `fk_order_commondity_order_1` FOREIGN KEY (`order_id`) REFERENCES `store_order` (`order_id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 127 CHARACTER SET = utf8 COLLATE = utf8_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of order_commodity
-- ----------------------------
INSERT INTO `order_commodity` VALUES (33, 31, 2, 1, 0.25);
INSERT INTO `order_commodity` VALUES (34, 32, 1, 1, 0.25);
INSERT INTO `order_commodity` VALUES (35, 33, 3, 4, 0.50);
INSERT INTO `order_commodity` VALUES (36, 34, 2, 1, 0.25);
INSERT INTO `order_commodity` VALUES (37, 35, 2, 1, 0.25);
INSERT INTO `order_commodity` VALUES (38, 36, 2, 10, 0.25);
INSERT INTO `order_commodity` VALUES (39, 37, 2, 1, 0.25);
INSERT INTO `order_commodity` VALUES (40, 38, 1, 1, 0.25);
INSERT INTO `order_commodity` VALUES (41, 39, 1, 1, 0.25);
INSERT INTO `order_commodity` VALUES (42, 40, 1, 1, 0.25);
INSERT INTO `order_commodity` VALUES (43, 41, 1, 1, 0.25);
INSERT INTO `order_commodity` VALUES (44, 42, 2, 1, 0.25);
INSERT INTO `order_commodity` VALUES (45, 42, 3, 1, 0.50);
INSERT INTO `order_commodity` VALUES (46, 43, 2, 1, 0.25);
INSERT INTO `order_commodity` VALUES (47, 44, 1, 1, 0.25);
INSERT INTO `order_commodity` VALUES (48, 44, 2, 1, 0.25);
INSERT INTO `order_commodity` VALUES (49, 45, 2, 1, 0.25);
INSERT INTO `order_commodity` VALUES (50, 46, 1, 1, 0.25);
INSERT INTO `order_commodity` VALUES (51, 47, 2, 1, 0.25);
INSERT INTO `order_commodity` VALUES (52, 48, 1, 1, 0.25);
INSERT INTO `order_commodity` VALUES (53, 49, 1, 1, 0.25);
INSERT INTO `order_commodity` VALUES (54, 50, 2, 1, 0.25);
INSERT INTO `order_commodity` VALUES (55, 51, 2, 1, 0.25);
INSERT INTO `order_commodity` VALUES (56, 51, 1, 1, 0.25);
INSERT INTO `order_commodity` VALUES (57, 52, 2, 1, 0.25);
INSERT INTO `order_commodity` VALUES (58, 53, 2, 1, 0.25);
INSERT INTO `order_commodity` VALUES (59, 53, 1, 1, 0.25);
INSERT INTO `order_commodity` VALUES (60, 54, 1, 1, 0.25);
INSERT INTO `order_commodity` VALUES (61, 55, 1, 1, 0.25);
INSERT INTO `order_commodity` VALUES (62, 56, 1, 1, 0.25);
INSERT INTO `order_commodity` VALUES (63, 56, 2, 1, 0.25);
INSERT INTO `order_commodity` VALUES (64, 57, 2, 1, 0.25);
INSERT INTO `order_commodity` VALUES (65, 58, 2, 1, 0.25);
INSERT INTO `order_commodity` VALUES (66, 59, 1, 1, 0.25);
INSERT INTO `order_commodity` VALUES (67, 59, 2, 2, 0.25);
INSERT INTO `order_commodity` VALUES (68, 60, 1, 1, 0.25);
INSERT INTO `order_commodity` VALUES (69, 61, 2, 1, 0.25);
INSERT INTO `order_commodity` VALUES (70, 62, 2, 2, 0.25);
INSERT INTO `order_commodity` VALUES (71, 62, 1, 1, 0.25);
INSERT INTO `order_commodity` VALUES (72, 63, 2, 1, 0.25);
INSERT INTO `order_commodity` VALUES (73, 64, 2, 1, 0.25);
INSERT INTO `order_commodity` VALUES (74, 65, 2, 1, 0.25);
INSERT INTO `order_commodity` VALUES (75, 66, 33, 1, 0.25);
INSERT INTO `order_commodity` VALUES (76, 67, 33, 1, 0.25);
INSERT INTO `order_commodity` VALUES (77, 68, 1, 1, 0.25);
INSERT INTO `order_commodity` VALUES (78, 69, 1, 1, 0.25);
INSERT INTO `order_commodity` VALUES (79, 70, 33, 1, 0.25);
INSERT INTO `order_commodity` VALUES (80, 71, 33, 10, 0.25);
INSERT INTO `order_commodity` VALUES (81, 72, 35, 1, 0.50);
INSERT INTO `order_commodity` VALUES (82, 73, 2, 1, 0.25);
INSERT INTO `order_commodity` VALUES (83, 74, 2, 10, 0.25);
INSERT INTO `order_commodity` VALUES (84, 75, 1, 1, 0.25);
INSERT INTO `order_commodity` VALUES (85, 76, 1, 1, 0.25);
INSERT INTO `order_commodity` VALUES (86, 77, 1, 1, 0.25);
INSERT INTO `order_commodity` VALUES (87, 77, 2, 1, 0.25);
INSERT INTO `order_commodity` VALUES (88, 78, 1, 1, 0.25);
INSERT INTO `order_commodity` VALUES (89, 78, 2, 2, 0.25);
INSERT INTO `order_commodity` VALUES (90, 79, 1, 1, 0.25);
INSERT INTO `order_commodity` VALUES (91, 80, 2, 1, 0.25);
INSERT INTO `order_commodity` VALUES (92, 81, 2, 1, 0.25);
INSERT INTO `order_commodity` VALUES (93, 81, 1, 2, 0.25);
INSERT INTO `order_commodity` VALUES (94, 82, 2, 1, 0.25);
INSERT INTO `order_commodity` VALUES (95, 83, 2, 1, 0.25);
INSERT INTO `order_commodity` VALUES (96, 84, 2, 1, 0.25);
INSERT INTO `order_commodity` VALUES (97, 85, 2, 1, 0.25);
INSERT INTO `order_commodity` VALUES (98, 86, 2, 60, 0.25);
INSERT INTO `order_commodity` VALUES (99, 87, 2, 10, 0.25);
INSERT INTO `order_commodity` VALUES (100, 88, 2, 1, 0.25);
INSERT INTO `order_commodity` VALUES (101, 88, 1, 1, 0.25);
INSERT INTO `order_commodity` VALUES (102, 89, 2, 10, 0.25);
INSERT INTO `order_commodity` VALUES (103, 90, 2, 10, 0.25);
INSERT INTO `order_commodity` VALUES (104, 91, 2, 10, 0.25);
INSERT INTO `order_commodity` VALUES (105, 92, 2, 10, 0.25);
INSERT INTO `order_commodity` VALUES (106, 93, 2, 1, 0.25);
INSERT INTO `order_commodity` VALUES (107, 94, 2, 10, 0.25);
INSERT INTO `order_commodity` VALUES (108, 95, 2, 1, 0.25);
INSERT INTO `order_commodity` VALUES (109, 96, 2, 1, 0.25);
INSERT INTO `order_commodity` VALUES (110, 97, 2, 10, 0.25);
INSERT INTO `order_commodity` VALUES (111, 98, 2, 10, 0.25);
INSERT INTO `order_commodity` VALUES (112, 99, 2, 10, 0.25);
INSERT INTO `order_commodity` VALUES (113, 100, 33, 1, 0.25);
INSERT INTO `order_commodity` VALUES (114, 101, 2, 10, 0.25);
INSERT INTO `order_commodity` VALUES (115, 102, 2, 10, 0.25);
INSERT INTO `order_commodity` VALUES (116, 103, 2, 1, 0.25);
INSERT INTO `order_commodity` VALUES (117, 104, 2, 10, 0.25);
INSERT INTO `order_commodity` VALUES (118, 105, 2, 10, 0.25);
INSERT INTO `order_commodity` VALUES (119, 106, 2, 1, 0.25);
INSERT INTO `order_commodity` VALUES (120, 107, 2, 1, 0.25);
INSERT INTO `order_commodity` VALUES (121, 108, 2, 1, 0.25);
INSERT INTO `order_commodity` VALUES (122, 109, 2, 1, 0.25);
INSERT INTO `order_commodity` VALUES (123, 110, 1, 10, 0.25);
INSERT INTO `order_commodity` VALUES (124, 111, 2, 1, 0.25);
INSERT INTO `order_commodity` VALUES (125, 112, 2, 1, 0.25);
INSERT INTO `order_commodity` VALUES (126, 113, 2, 2, 0.25);
INSERT INTO `order_commodity` VALUES (127, 114, 2, 1, 0.25);

-- ----------------------------
-- Table structure for order_status
-- ----------------------------
DROP TABLE IF EXISTS `order_status`;
CREATE TABLE `order_status`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `order_id` int(20) NOT NULL,
  `change_type` int(1) NULL DEFAULT NULL COMMENT '1：待商家完成打印，\r\n2：自提订单待取件，\r\n3：配送订单待配送，\r\n4：交易完成，\r\n5：退款中，\r\n6：已退款，',
  `change_message` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `change_time` datetime(0) NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP(0),
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `fk_order_status_store_order_1`(`order_id`) USING BTREE,
  CONSTRAINT `fk_order_status_store_order_1` FOREIGN KEY (`order_id`) REFERENCES `store_order` (`order_id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 266 CHARACTER SET = utf8 COLLATE = utf8_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of order_status
-- ----------------------------
INSERT INTO `order_status` VALUES (2, 31, 1, '用户下单', '2022-02-25 20:59:01');
INSERT INTO `order_status` VALUES (3, 32, 1, '用户下单', '2022-02-25 20:59:01');
INSERT INTO `order_status` VALUES (4, 33, 1, '用户下单', '2022-02-25 20:59:01');
INSERT INTO `order_status` VALUES (5, 34, 1, '用户下单', '2022-02-25 20:59:01');
INSERT INTO `order_status` VALUES (6, 35, 1, '用户下单', '2022-02-25 20:59:01');
INSERT INTO `order_status` VALUES (7, 36, 1, '用户下单', '2022-02-25 20:59:01');
INSERT INTO `order_status` VALUES (8, 37, 1, '用户下单', '2022-02-25 20:59:01');
INSERT INTO `order_status` VALUES (9, 38, 1, '用户下单', '2022-02-25 20:59:01');
INSERT INTO `order_status` VALUES (10, 39, 1, '用户下单', '2022-02-25 20:59:01');
INSERT INTO `order_status` VALUES (11, 40, 1, '用户下单', '2022-02-25 20:59:01');
INSERT INTO `order_status` VALUES (12, 41, 1, '用户下单', '2022-02-25 20:59:01');
INSERT INTO `order_status` VALUES (13, 42, 4, '用户下单', '2022-02-27 23:31:49');
INSERT INTO `order_status` VALUES (14, 37, 3, '打印完成，待配送', '2022-03-01 22:33:17');
INSERT INTO `order_status` VALUES (15, 43, 1, '用户下单', '2022-03-02 20:23:18');
INSERT INTO `order_status` VALUES (16, 44, 1, '用户下单', '2022-03-02 20:23:45');
INSERT INTO `order_status` VALUES (17, 45, 1, '用户下单', '2022-03-03 18:20:49');
INSERT INTO `order_status` VALUES (18, 45, 2, '打印完成，代取件', '2022-03-03 18:21:31');
INSERT INTO `order_status` VALUES (19, 46, 1, '用户下单', '2022-03-03 18:22:12');
INSERT INTO `order_status` VALUES (20, 47, 1, '用户下单', '2022-03-03 18:22:27');
INSERT INTO `order_status` VALUES (21, 46, 3, '打印完成，待配送', '2022-03-03 18:25:15');
INSERT INTO `order_status` VALUES (22, 47, -1, '用户申请退款', '2022-03-03 18:44:21');
INSERT INTO `order_status` VALUES (23, 46, 4, '订单完成', '2022-03-03 18:47:16');
INSERT INTO `order_status` VALUES (24, 45, 4, '订单完成', '2022-03-03 18:47:48');
INSERT INTO `order_status` VALUES (25, 48, 1, '用户下单', '2022-03-03 18:49:44');
INSERT INTO `order_status` VALUES (26, 48, 2, '打印完成，代取件', '2022-03-03 18:49:54');
INSERT INTO `order_status` VALUES (27, 48, 4, '订单完成', '2022-03-03 18:50:09');
INSERT INTO `order_status` VALUES (28, 49, 1, '用户下单', '2022-03-03 18:52:19');
INSERT INTO `order_status` VALUES (29, 49, 2, '打印完成，代取件', '2022-03-03 18:52:37');
INSERT INTO `order_status` VALUES (30, 49, 4, '订单完成', '2022-03-03 18:52:41');
INSERT INTO `order_status` VALUES (31, 49, -1, '用户申请退款', '2022-03-03 18:56:21');
INSERT INTO `order_status` VALUES (32, 44, 2, '打印完成，代取件', '2022-03-04 16:38:06');
INSERT INTO `order_status` VALUES (33, 43, 3, '打印完成，待配送', '2022-03-04 16:38:10');
INSERT INTO `order_status` VALUES (34, 36, 3, '打印完成，待配送', '2022-03-04 22:03:33');
INSERT INTO `order_status` VALUES (35, 34, 2, '打印完成，代取件', '2022-03-04 22:03:37');
INSERT INTO `order_status` VALUES (36, 32, 2, '打印完成，代取件', '2022-03-04 22:34:01');
INSERT INTO `order_status` VALUES (37, 35, 3, '打印完成，待配送', '2022-03-04 22:34:13');
INSERT INTO `order_status` VALUES (38, 33, 2, '打印完成，代取件', '2022-03-04 22:34:13');
INSERT INTO `order_status` VALUES (39, 31, 2, '打印完成，代取件', '2022-03-04 22:34:24');
INSERT INTO `order_status` VALUES (40, 36, 4, '配送完成', '2022-03-04 22:51:17');
INSERT INTO `order_status` VALUES (41, 35, 4, '配送完成', '2022-03-04 22:51:25');
INSERT INTO `order_status` VALUES (42, 37, 4, '配送完成', '2022-03-04 22:58:02');
INSERT INTO `order_status` VALUES (43, 40, 4, '配送完成', '2022-03-04 22:58:14');
INSERT INTO `order_status` VALUES (44, 41, 4, '配送完成', '2022-03-04 22:58:14');
INSERT INTO `order_status` VALUES (45, 50, 1, '用户下单', '2022-03-05 15:39:19');
INSERT INTO `order_status` VALUES (46, 51, 1, '用户下单', '2022-03-05 15:41:01');
INSERT INTO `order_status` VALUES (47, 51, 2, '打印完成，代取件', '2022-03-05 16:02:06');
INSERT INTO `order_status` VALUES (48, 50, 2, '打印完成，代取件', '2022-03-05 16:02:06');
INSERT INTO `order_status` VALUES (49, 52, 1, '用户下单', '2022-03-05 16:35:46');
INSERT INTO `order_status` VALUES (50, 52, 3, '打印完成，待配送', '2022-03-05 16:35:59');
INSERT INTO `order_status` VALUES (51, 52, 4, '配送完成', '2022-03-05 16:36:24');
INSERT INTO `order_status` VALUES (52, 52, 5, '订单完成', '2022-03-05 16:43:36');
INSERT INTO `order_status` VALUES (53, 51, 5, '订单完成', '2022-03-05 16:43:42');
INSERT INTO `order_status` VALUES (54, 53, 1, '用户下单', '2022-03-05 20:03:49');
INSERT INTO `order_status` VALUES (55, 53, 2, '打印完成，代取件', '2022-03-05 20:04:57');
INSERT INTO `order_status` VALUES (56, 53, 5, '订单完成', '2022-03-05 20:06:53');
INSERT INTO `order_status` VALUES (57, 53, -1, '用户申请退款,原因:打印错误', '2022-03-05 20:27:19');
INSERT INTO `order_status` VALUES (58, 52, -1, '用户申请退款,原因:qweqwsadasd', '2022-03-05 20:39:19');
INSERT INTO `order_status` VALUES (59, 53, -2, '商家同意退款', '2022-03-06 09:49:26');
INSERT INTO `order_status` VALUES (60, 47, -3, '商家拒绝退款', '2022-03-06 09:50:47');
INSERT INTO `order_status` VALUES (61, 49, -2, '商家同意退款', '2022-03-06 10:08:12');
INSERT INTO `order_status` VALUES (62, 52, -3, '商家拒绝退款', '2022-03-06 10:08:22');
INSERT INTO `order_status` VALUES (63, 38, 4, '订单完成超过48小时，自动确定', '2022-03-06 17:48:44');
INSERT INTO `order_status` VALUES (64, 39, 4, '订单完成超过48小时，自动确定', '2022-03-06 17:48:44');
INSERT INTO `order_status` VALUES (65, 42, 4, '订单完成超过48小时，自动确定', '2022-03-06 17:48:44');
INSERT INTO `order_status` VALUES (66, 44, 4, '订单完成超过48小时，自动确定', '2022-03-06 17:48:44');
INSERT INTO `order_status` VALUES (67, 45, 4, '订单完成超过48小时，自动确定', '2022-03-06 17:48:44');
INSERT INTO `order_status` VALUES (68, 46, 4, '订单完成超过48小时，自动确定', '2022-03-06 17:48:44');
INSERT INTO `order_status` VALUES (69, 48, 4, '订单完成超过48小时，自动确定', '2022-03-06 17:48:44');
INSERT INTO `order_status` VALUES (70, 54, 1, '用户下单', '2022-03-06 20:53:42');
INSERT INTO `order_status` VALUES (71, 55, 1, '用户下单', '2022-03-06 20:54:04');
INSERT INTO `order_status` VALUES (72, 54, -1, '用户申请退款,原因:文件上传错了', '2022-03-06 20:54:21');
INSERT INTO `order_status` VALUES (73, 54, -2, '商家同意退款', '2022-03-06 20:55:03');
INSERT INTO `order_status` VALUES (74, 55, -1, '用户申请退款,原因:驱蚊器翁无群', '2022-03-06 20:55:22');
INSERT INTO `order_status` VALUES (75, 55, 1, '用户取消申请退款', '2022-03-07 16:07:15');
INSERT INTO `order_status` VALUES (76, 55, -1, '用户申请退款,原因:asd', '2022-03-07 16:08:48');
INSERT INTO `order_status` VALUES (77, 55, 1, '用户取消申请退款', '2022-03-07 16:08:54');
INSERT INTO `order_status` VALUES (78, 55, 2, '打印完成，代取件', '2022-03-07 16:10:14');
INSERT INTO `order_status` VALUES (79, 55, 5, '订单完成', '2022-03-07 16:10:19');
INSERT INTO `order_status` VALUES (80, 55, -1, '用户申请退款,原因:asd', '2022-03-07 16:10:58');
INSERT INTO `order_status` VALUES (81, 55, -3, '商家拒绝退款', '2022-03-07 16:11:11');
INSERT INTO `order_status` VALUES (82, 56, 1, '用户下单', '2022-03-07 16:34:25');
INSERT INTO `order_status` VALUES (83, 57, 1, '用户下单', '2022-03-07 16:37:11');
INSERT INTO `order_status` VALUES (84, 58, 1, '用户下单', '2022-03-07 16:45:39');
INSERT INTO `order_status` VALUES (85, 59, 1, '用户下单', '2022-03-07 16:46:10');
INSERT INTO `order_status` VALUES (86, 60, 1, '用户下单', '2022-03-08 16:48:04');
INSERT INTO `order_status` VALUES (87, 60, 2, '打印完成，代取件', '2022-03-08 16:49:14');
INSERT INTO `order_status` VALUES (88, 59, 2, '打印完成，代取件', '2022-03-08 16:49:19');
INSERT INTO `order_status` VALUES (89, 60, 5, '订单完成', '2022-03-08 16:49:31');
INSERT INTO `order_status` VALUES (90, 61, 1, '用户下单', '2022-03-08 17:01:33');
INSERT INTO `order_status` VALUES (91, 61, 3, '打印完成，待配送', '2022-03-08 17:02:35');
INSERT INTO `order_status` VALUES (92, 61, 4, '配送完成', '2022-03-08 17:02:40');
INSERT INTO `order_status` VALUES (93, 31, 5, '订单完成超过48小时，自动确定', '2022-03-08 18:00:01');
INSERT INTO `order_status` VALUES (94, 32, 5, '订单完成超过48小时，自动确定', '2022-03-08 18:00:01');
INSERT INTO `order_status` VALUES (95, 33, 5, '订单完成超过48小时，自动确定', '2022-03-08 18:00:01');
INSERT INTO `order_status` VALUES (96, 34, 5, '订单完成超过48小时，自动确定', '2022-03-08 18:00:01');
INSERT INTO `order_status` VALUES (97, 35, 5, '订单完成超过48小时，自动确定', '2022-03-08 18:00:02');
INSERT INTO `order_status` VALUES (98, 36, 5, '订单完成超过48小时，自动确定', '2022-03-08 18:00:02');
INSERT INTO `order_status` VALUES (99, 37, 5, '订单完成超过48小时，自动确定', '2022-03-08 18:00:02');
INSERT INTO `order_status` VALUES (100, 38, 5, '订单完成超过48小时，自动确定', '2022-03-08 18:00:02');
INSERT INTO `order_status` VALUES (101, 39, 5, '订单完成超过48小时，自动确定', '2022-03-08 18:00:02');
INSERT INTO `order_status` VALUES (102, 40, 5, '订单完成超过48小时，自动确定', '2022-03-08 18:00:02');
INSERT INTO `order_status` VALUES (103, 41, 5, '订单完成超过48小时，自动确定', '2022-03-08 18:00:02');
INSERT INTO `order_status` VALUES (104, 42, 5, '订单完成超过48小时，自动确定', '2022-03-08 18:00:02');
INSERT INTO `order_status` VALUES (105, 44, 5, '订单完成超过48小时，自动确定', '2022-03-08 18:00:02');
INSERT INTO `order_status` VALUES (106, 45, 5, '订单完成超过48小时，自动确定', '2022-03-08 18:00:02');
INSERT INTO `order_status` VALUES (107, 46, 5, '订单完成超过48小时，自动确定', '2022-03-08 18:00:02');
INSERT INTO `order_status` VALUES (108, 48, 5, '订单完成超过48小时，自动确定', '2022-03-08 18:00:02');
INSERT INTO `order_status` VALUES (109, 50, 5, '订单完成超过48小时，自动确定', '2022-03-08 18:00:02');
INSERT INTO `order_status` VALUES (110, 61, 5, '订单完成', '2022-03-08 19:34:24');
INSERT INTO `order_status` VALUES (111, 62, 1, '用户下单', '2022-03-08 21:38:05');
INSERT INTO `order_status` VALUES (112, 63, 1, '用户下单', '2022-03-08 21:55:26');
INSERT INTO `order_status` VALUES (113, 61, 6, '用户评价', '2022-03-09 21:29:37');
INSERT INTO `order_status` VALUES (114, 60, 6, '用户评价', '2022-03-09 21:40:14');
INSERT INTO `order_status` VALUES (115, 59, 5, '订单完成', '2022-03-09 21:42:07');
INSERT INTO `order_status` VALUES (116, 59, 6, '用户评价', '2022-03-09 21:42:17');
INSERT INTO `order_status` VALUES (117, 64, 1, '用户下单', '2022-03-09 21:45:00');
INSERT INTO `order_status` VALUES (118, 64, 2, '打印完成，代取件', '2022-03-09 21:45:09');
INSERT INTO `order_status` VALUES (119, 64, 5, '订单完成', '2022-03-09 21:45:35');
INSERT INTO `order_status` VALUES (120, 64, 6, '用户评价', '2022-03-09 21:45:56');
INSERT INTO `order_status` VALUES (121, 65, 1, '用户下单', '2022-03-12 12:35:31');
INSERT INTO `order_status` VALUES (122, 66, 1, '用户下单', '2022-03-12 12:35:44');
INSERT INTO `order_status` VALUES (123, 67, 1, '用户下单', '2022-03-12 12:36:20');
INSERT INTO `order_status` VALUES (124, 68, 1, '用户下单', '2022-03-12 12:36:33');
INSERT INTO `order_status` VALUES (125, 69, 1, '用户下单', '2022-03-12 12:36:45');
INSERT INTO `order_status` VALUES (126, 70, 1, '用户下单', '2022-03-12 12:36:57');
INSERT INTO `order_status` VALUES (127, 71, 1, '用户下单', '2022-03-12 12:46:07');
INSERT INTO `order_status` VALUES (128, 72, 1, '用户下单', '2022-03-12 12:46:23');
INSERT INTO `order_status` VALUES (129, 73, 1, '用户下单', '2022-03-12 13:46:13');
INSERT INTO `order_status` VALUES (130, 74, 1, '用户下单', '2022-03-12 13:46:32');
INSERT INTO `order_status` VALUES (131, 75, 1, '用户下单', '2022-03-12 13:46:48');
INSERT INTO `order_status` VALUES (132, 76, 1, '用户下单', '2022-03-12 13:47:06');
INSERT INTO `order_status` VALUES (133, 77, 1, '用户下单', '2022-03-12 13:47:19');
INSERT INTO `order_status` VALUES (134, 78, 1, '用户下单', '2022-03-12 13:48:58');
INSERT INTO `order_status` VALUES (135, 78, 2, '打印完成，代取件', '2022-03-12 13:51:38');
INSERT INTO `order_status` VALUES (136, 77, 2, '打印完成，代取件', '2022-03-12 13:51:38');
INSERT INTO `order_status` VALUES (137, 78, 5, '订单完成', '2022-03-12 13:51:45');
INSERT INTO `order_status` VALUES (138, 77, 5, '订单完成', '2022-03-12 13:51:52');
INSERT INTO `order_status` VALUES (139, 78, 6, '用户评价', '2022-03-12 13:52:04');
INSERT INTO `order_status` VALUES (140, 77, -1, '用户申请退款,原因:asdasd', '2022-03-12 13:52:22');
INSERT INTO `order_status` VALUES (141, 77, 5, '用户取消申请退款', '2022-03-12 13:52:31');
INSERT INTO `order_status` VALUES (142, 77, -1, '用户申请退款,原因:asd', '2022-03-12 13:52:40');
INSERT INTO `order_status` VALUES (143, 77, -2, '商家同意退款', '2022-03-12 13:53:13');
INSERT INTO `order_status` VALUES (144, 76, 2, '打印完成，代取件', '2022-03-12 13:53:29');
INSERT INTO `order_status` VALUES (145, 76, 5, '订单完成', '2022-03-12 13:53:34');
INSERT INTO `order_status` VALUES (146, 76, -1, '用户申请退款,原因:asdasdasd', '2022-03-12 13:53:39');
INSERT INTO `order_status` VALUES (147, 76, -3, '商家拒绝退款', '2022-03-12 13:53:44');
INSERT INTO `order_status` VALUES (148, 75, 3, '打印完成，待配送', '2022-03-12 13:54:01');
INSERT INTO `order_status` VALUES (149, 75, 4, '配送完成', '2022-03-12 13:54:04');
INSERT INTO `order_status` VALUES (150, 75, 5, '订单完成', '2022-03-12 13:54:16');
INSERT INTO `order_status` VALUES (151, 75, 6, '用户评价', '2022-03-12 13:54:30');
INSERT INTO `order_status` VALUES (152, 79, 1, '用户下单', '2022-03-15 19:36:46');
INSERT INTO `order_status` VALUES (153, 79, 2, '打印完成，代取件', '2022-03-15 19:37:05');
INSERT INTO `order_status` VALUES (154, 79, 5, '订单完成', '2022-03-15 19:37:17');
INSERT INTO `order_status` VALUES (155, 79, 6, '用户评价', '2022-03-15 19:59:27');
INSERT INTO `order_status` VALUES (156, 80, 1, '用户下单', '2022-03-15 20:27:45');
INSERT INTO `order_status` VALUES (157, 80, 2, '打印完成，代取件', '2022-03-15 20:45:16');
INSERT INTO `order_status` VALUES (158, 80, 5, '订单完成超过48小时，自动确定', '2022-04-06 18:00:00');
INSERT INTO `order_status` VALUES (159, 81, 1, '用户下单', '2022-04-06 19:29:57');
INSERT INTO `order_status` VALUES (160, 82, 1, '用户下单', '2022-04-09 18:31:19');
INSERT INTO `order_status` VALUES (161, 83, 1, '用户下单', '2022-04-09 18:31:52');
INSERT INTO `order_status` VALUES (162, 83, 2, '打印完成，代取件', '2022-04-14 22:39:51');
INSERT INTO `order_status` VALUES (163, 84, 1, '用户下单', '2022-04-14 22:53:11');
INSERT INTO `order_status` VALUES (164, 85, 1, '用户下单', '2022-04-15 00:01:14');
INSERT INTO `order_status` VALUES (165, 86, 1, '用户下单', '2022-04-16 16:28:44');
INSERT INTO `order_status` VALUES (166, 86, 2, '打印完成，代取件', '2022-04-16 16:35:40');
INSERT INTO `order_status` VALUES (167, 86, 5, '订单完成', '2022-04-16 16:36:01');
INSERT INTO `order_status` VALUES (168, 86, 6, '用户评价', '2022-04-16 16:36:29');
INSERT INTO `order_status` VALUES (169, 87, 1, '用户下单', '2022-04-16 16:38:28');
INSERT INTO `order_status` VALUES (170, 87, 3, '打印完成，待配送', '2022-04-16 16:39:30');
INSERT INTO `order_status` VALUES (171, 87, 4, '配送完成', '2022-04-16 16:39:58');
INSERT INTO `order_status` VALUES (172, 87, 5, '订单完成', '2022-04-16 16:40:15');
INSERT INTO `order_status` VALUES (173, 87, -1, '用户申请退款,原因:打印错了', '2022-04-16 16:40:36');
INSERT INTO `order_status` VALUES (174, 87, -3, '商家拒绝退款', '2022-04-16 16:41:03');
INSERT INTO `order_status` VALUES (175, 88, 1, '用户下单', '2022-04-16 22:39:51');
INSERT INTO `order_status` VALUES (176, 89, 1, '用户下单', '2022-04-17 17:35:02');
INSERT INTO `order_status` VALUES (177, 83, 5, '订单完成超过48小时，自动确定', '2022-04-17 18:00:00');
INSERT INTO `order_status` VALUES (178, 90, 1, '用户下单', '2022-04-17 20:27:27');
INSERT INTO `order_status` VALUES (179, 90, 2, '打印完成，代取件', '2022-04-17 20:32:54');
INSERT INTO `order_status` VALUES (180, 90, 5, '订单完成', '2022-04-17 20:33:11');
INSERT INTO `order_status` VALUES (181, 90, 6, '用户评价', '2022-04-17 20:33:30');
INSERT INTO `order_status` VALUES (182, 91, 1, '用户下单', '2022-04-17 20:35:03');
INSERT INTO `order_status` VALUES (183, 91, 3, '打印完成，待配送', '2022-04-17 20:36:09');
INSERT INTO `order_status` VALUES (184, 91, 4, '配送完成', '2022-04-17 20:36:25');
INSERT INTO `order_status` VALUES (185, 91, 5, '订单完成', '2022-04-17 20:36:39');
INSERT INTO `order_status` VALUES (186, 91, -1, '用户申请退款,原因:打印错了', '2022-04-17 20:36:51');
INSERT INTO `order_status` VALUES (187, 91, -2, '商家同意退款', '2022-04-17 20:37:19');
INSERT INTO `order_status` VALUES (188, 92, 1, '用户下单', '2022-04-18 21:46:24');
INSERT INTO `order_status` VALUES (189, 92, 2, '打印完成，代取件', '2022-04-18 21:50:35');
INSERT INTO `order_status` VALUES (190, 89, 2, '打印完成，代取件', '2022-04-18 21:50:35');
INSERT INTO `order_status` VALUES (191, 92, 5, '订单完成', '2022-04-18 21:50:50');
INSERT INTO `order_status` VALUES (192, 92, 6, '用户评价', '2022-04-18 21:51:04');
INSERT INTO `order_status` VALUES (193, 93, 1, '用户下单', '2022-04-18 21:52:09');
INSERT INTO `order_status` VALUES (194, 93, 3, '打印完成，待配送', '2022-04-18 21:52:24');
INSERT INTO `order_status` VALUES (195, 93, 4, '配送完成', '2022-04-18 21:52:40');
INSERT INTO `order_status` VALUES (196, 93, 5, '订单完成', '2022-04-18 21:52:51');
INSERT INTO `order_status` VALUES (197, 93, -1, '用户申请退款,原因:打印错了', '2022-04-18 21:52:58');
INSERT INTO `order_status` VALUES (198, 93, -3, '商家拒绝退款', '2022-04-18 21:53:18');
INSERT INTO `order_status` VALUES (199, 94, 1, '用户下单', '2022-04-18 22:20:18');
INSERT INTO `order_status` VALUES (200, 95, 1, '用户下单', '2022-04-18 22:20:55');
INSERT INTO `order_status` VALUES (201, 96, 1, '用户下单', '2022-04-18 22:21:38');
INSERT INTO `order_status` VALUES (202, 97, 1, '用户下单', '2022-04-19 21:54:10');
INSERT INTO `order_status` VALUES (203, 97, 2, '打印完成，代取件', '2022-04-19 21:56:23');
INSERT INTO `order_status` VALUES (204, 97, 5, '订单完成', '2022-04-19 21:56:37');
INSERT INTO `order_status` VALUES (205, 97, 6, '用户评价', '2022-04-19 21:56:52');
INSERT INTO `order_status` VALUES (206, 98, 1, '用户下单', '2022-04-19 21:57:22');
INSERT INTO `order_status` VALUES (207, 98, 3, '打印完成，待配送', '2022-04-19 21:57:38');
INSERT INTO `order_status` VALUES (208, 98, 4, '配送完成', '2022-04-19 21:57:53');
INSERT INTO `order_status` VALUES (209, 98, 5, '订单完成', '2022-04-19 21:58:08');
INSERT INTO `order_status` VALUES (210, 98, -1, '用户申请退款,原因:打印错了', '2022-04-19 21:58:15');
INSERT INTO `order_status` VALUES (211, 98, -3, '商家拒绝退款', '2022-04-19 21:58:31');
INSERT INTO `order_status` VALUES (212, 99, 1, '用户下单', '2022-04-19 22:10:35');
INSERT INTO `order_status` VALUES (213, 100, 1, '用户下单', '2022-04-20 11:52:13');
INSERT INTO `order_status` VALUES (214, 101, 1, '用户下单', '2022-04-20 11:53:03');
INSERT INTO `order_status` VALUES (215, 102, 1, '用户下单', '2022-04-20 19:34:04');
INSERT INTO `order_status` VALUES (216, 102, 2, '打印完成，代取件', '2022-04-20 19:35:17');
INSERT INTO `order_status` VALUES (217, 102, 5, '订单完成', '2022-04-20 19:35:33');
INSERT INTO `order_status` VALUES (218, 102, 6, '用户评价', '2022-04-20 19:35:45');
INSERT INTO `order_status` VALUES (219, 103, 1, '用户下单', '2022-04-20 19:36:08');
INSERT INTO `order_status` VALUES (220, 103, 3, '打印完成，待配送', '2022-04-20 19:36:29');
INSERT INTO `order_status` VALUES (221, 103, 4, '配送完成', '2022-04-20 19:36:43');
INSERT INTO `order_status` VALUES (222, 103, 5, '订单完成', '2022-04-20 19:36:57');
INSERT INTO `order_status` VALUES (223, 103, -1, '用户申请退款,原因:打印错了', '2022-04-20 19:37:04');
INSERT INTO `order_status` VALUES (224, 103, -2, '商家同意退款', '2022-04-20 19:37:21');
INSERT INTO `order_status` VALUES (225, 89, 5, '订单完成超过48小时，自动确定', '2022-04-21 18:00:00');
INSERT INTO `order_status` VALUES (226, 104, 1, '用户下单', '2022-04-21 21:51:59');
INSERT INTO `order_status` VALUES (227, 105, 1, '用户下单', '2022-04-21 21:57:59');
INSERT INTO `order_status` VALUES (228, 105, 2, '打印完成，代取件', '2022-04-21 22:00:19');
INSERT INTO `order_status` VALUES (229, 105, 5, '订单完成', '2022-04-21 22:00:33');
INSERT INTO `order_status` VALUES (230, 105, 6, '用户评价', '2022-04-21 22:00:48');
INSERT INTO `order_status` VALUES (231, 106, 1, '用户下单', '2022-04-21 22:01:23');
INSERT INTO `order_status` VALUES (232, 106, 3, '打印完成，待配送', '2022-04-21 22:01:40');
INSERT INTO `order_status` VALUES (233, 106, 4, '配送完成', '2022-04-21 22:01:51');
INSERT INTO `order_status` VALUES (234, 106, 5, '订单完成', '2022-04-21 22:02:07');
INSERT INTO `order_status` VALUES (235, 107, 1, '用户下单', '2022-04-21 22:08:01');
INSERT INTO `order_status` VALUES (236, 108, 1, '用户下单', '2022-04-21 22:19:06');
INSERT INTO `order_status` VALUES (237, 108, 2, '打印完成，代取件', '2022-04-21 22:21:04');
INSERT INTO `order_status` VALUES (238, 108, 5, '订单完成', '2022-04-21 22:21:23');
INSERT INTO `order_status` VALUES (239, 108, 6, '用户评价', '2022-04-21 22:21:38');
INSERT INTO `order_status` VALUES (240, 109, 1, '用户下单', '2022-04-21 22:22:16');
INSERT INTO `order_status` VALUES (241, 109, 3, '打印完成，待配送', '2022-04-21 22:22:46');
INSERT INTO `order_status` VALUES (242, 109, 4, '配送完成', '2022-04-21 22:22:58');
INSERT INTO `order_status` VALUES (243, 109, 5, '订单完成', '2022-04-21 22:23:18');
INSERT INTO `order_status` VALUES (244, 109, -1, '用户申请退款,原因:asd', '2022-04-21 22:23:31');
INSERT INTO `order_status` VALUES (245, 109, -2, '商家同意退款', '2022-04-21 22:23:52');
INSERT INTO `order_status` VALUES (246, 110, 1, '用户下单', '2022-04-21 22:33:23');
INSERT INTO `order_status` VALUES (247, 110, 2, '打印完成，代取件', '2022-04-21 22:35:04');
INSERT INTO `order_status` VALUES (248, 110, 5, '订单完成', '2022-04-21 22:35:17');
INSERT INTO `order_status` VALUES (249, 110, 6, '用户评价', '2022-04-21 22:35:33');
INSERT INTO `order_status` VALUES (250, 111, 1, '用户下单', '2022-04-21 22:35:57');
INSERT INTO `order_status` VALUES (251, 111, 3, '打印完成，待配送', '2022-04-21 22:36:07');
INSERT INTO `order_status` VALUES (252, 111, 4, '配送完成', '2022-04-21 22:36:17');
INSERT INTO `order_status` VALUES (253, 111, 5, '订单完成', '2022-04-21 22:36:27');
INSERT INTO `order_status` VALUES (254, 111, -1, '用户申请退款,原因:dayads', '2022-04-21 22:36:38');
INSERT INTO `order_status` VALUES (255, 111, -2, '商家同意退款', '2022-04-21 22:37:00');
INSERT INTO `order_status` VALUES (256, 112, 1, '用户下单', '2022-04-21 22:59:51');
INSERT INTO `order_status` VALUES (257, 113, 1, '用户下单', '2022-04-22 09:50:45');
INSERT INTO `order_status` VALUES (258, 113, 2, '打印完成，代取件', '2022-04-22 09:52:12');
INSERT INTO `order_status` VALUES (259, 113, 5, '订单完成', '2022-04-22 09:52:24');
INSERT INTO `order_status` VALUES (260, 113, 6, '用户评价', '2022-04-22 09:52:32');
INSERT INTO `order_status` VALUES (261, 114, 1, '用户下单', '2022-04-22 09:52:52');
INSERT INTO `order_status` VALUES (262, 114, 3, '打印完成，待配送', '2022-04-22 09:53:05');
INSERT INTO `order_status` VALUES (263, 114, 4, '配送完成', '2022-04-22 09:53:15');
INSERT INTO `order_status` VALUES (264, 114, 5, '订单完成', '2022-04-22 09:53:24');
INSERT INTO `order_status` VALUES (265, 114, -1, '用户申请退款,原因:h ', '2022-04-22 09:53:32');
INSERT INTO `order_status` VALUES (266, 114, -2, '商家同意退款', '2022-04-22 09:53:52');

-- ----------------------------
-- Table structure for permission
-- ----------------------------
DROP TABLE IF EXISTS `permission`;
CREATE TABLE `permission`  (
  `permission_id` int(11) NOT NULL AUTO_INCREMENT,
  `permission_code` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `permission_name` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `father_id` int(11) NULL DEFAULT NULL,
  `path` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `is_menu` int(11) NULL DEFAULT NULL COMMENT '是否为菜单1：是 2：按钮3：页面 ',
  `sort` int(11) NULL DEFAULT NULL,
  `icon` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT 'element图标',
  PRIMARY KEY (`permission_id`) USING BTREE,
  UNIQUE INDEX `permission_code`(`permission_code`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 45 CHARACTER SET = utf8 COLLATE = utf8_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of permission
-- ----------------------------
INSERT INTO `permission` VALUES (1, 'systemManagement', '系统管理', 0, '/systemManagement', 1, 2, 'el-icon-setting');
INSERT INTO `permission` VALUES (2, 'storeManagement', '门店管理', 0, '/storeManagement', 1, 3, 'el-icon-s-shop');
INSERT INTO `permission` VALUES (3, 'commodityManagement', '商品管理', 0, '/commodityManagement', 1, 4, 'el-icon-shopping-bag-1');
INSERT INTO `permission` VALUES (4, 'orderManagement', '订单管理', 0, '/orderManagement', 1, 5, 'el-icon-s-order');
INSERT INTO `permission` VALUES (5, 'systemManagement:userManagement', '用户管理', 1, '/systemManagement/userManagement', 1, 3, NULL);
INSERT INTO `permission` VALUES (6, 'systemManagement:roleManagement', '角色管理', 1, '/systemManagement/roleManagement', 1, 2, NULL);
INSERT INTO `permission` VALUES (7, 'systemManagement:menuManagement', '菜单管理', 1, '/systemManagement/menuManagement', 1, 1, NULL);
INSERT INTO `permission` VALUES (9, 'storeManagement:storeList', '门店列表', 2, '/storeManagement/storeList', 1, 2, NULL);
INSERT INTO `permission` VALUES (10, 'dataDisplay', '首页', 0, '/dataDisplay/index', 1, 1, 'el-icon-s-data');
INSERT INTO `permission` VALUES (11, 'storeManagement:clerkManagement', '店员管理', 2, '/storeManagement/clerkManagement', 1, 3, NULL);
INSERT INTO `permission` VALUES (12, 'commodityManagement:commodityRule', '商品规格', 3, '/commodityManagement/commodityRule', 1, 1, NULL);
INSERT INTO `permission` VALUES (13, 'commodityManagement:manageGoods', '管理商品', 3, '/commodityManagement/manageGoods', 1, 1, NULL);
INSERT INTO `permission` VALUES (14, 'orderManagement:order', '订单', 4, '/orderManagement/order', 1, 1, NULL);
INSERT INTO `permission` VALUES (22, 'addMenu', '新增菜单', 7, '', 2, 1, '');
INSERT INTO `permission` VALUES (23, 'updateMenu', '修改菜单', 7, '', 2, 1, '');
INSERT INTO `permission` VALUES (24, 'deleteMenu', '删除菜单', 7, '', 2, 1, '');
INSERT INTO `permission` VALUES (28, 'addUser', '新增用户', 5, '', 2, 1, '');
INSERT INTO `permission` VALUES (29, 'updateUser', '修改用户', 5, '', 2, 1, '');
INSERT INTO `permission` VALUES (30, 'deleteUser', '删除用户', 5, '', 2, 1, '');
INSERT INTO `permission` VALUES (31, 'addRole', '新增角色', 6, '', 2, 1, '');
INSERT INTO `permission` VALUES (32, 'updateRole', '修改角色', 6, '', 2, 1, '');
INSERT INTO `permission` VALUES (33, 'deleteRole', '删除角色', 6, '', 2, 1, '');
INSERT INTO `permission` VALUES (34, 'addStore', '新增门店', 9, '', 2, 1, '');
INSERT INTO `permission` VALUES (35, 'updateStore', '修改门店', 9, '', 2, 1, '');
INSERT INTO `permission` VALUES (37, 'deleteStore', '删除门店', 9, '', 2, 1, '');
INSERT INTO `permission` VALUES (38, 'addClerk', '新增店员', 11, '', 2, 1, '');
INSERT INTO `permission` VALUES (39, 'deleteClerk', '删除店员', 11, '', 2, 1, '');
INSERT INTO `permission` VALUES (40, 'addRule', '新增商品规格', 12, '', 2, 1, '');
INSERT INTO `permission` VALUES (41, 'updateRule', '修改商品规格', 12, '', 2, 1, '');
INSERT INTO `permission` VALUES (42, 'deleteRule', '删除商品规格', 12, '', 2, 1, '');
INSERT INTO `permission` VALUES (45, 'orderManagement:evaluationManagement', '评价管理', 4, '/orderManagement/evaluationManagement', 1, 1, '');

-- ----------------------------
-- Table structure for role
-- ----------------------------
DROP TABLE IF EXISTS `role`;
CREATE TABLE `role`  (
  `role_id` int(11) NOT NULL AUTO_INCREMENT,
  `role_name` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  PRIMARY KEY (`role_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 9 CHARACTER SET = utf8 COLLATE = utf8_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of role
-- ----------------------------
INSERT INTO `role` VALUES (1, '超级管理员');
INSERT INTO `role` VALUES (2, '店长');
INSERT INTO `role` VALUES (3, '员工');

-- ----------------------------
-- Table structure for role_permission
-- ----------------------------
DROP TABLE IF EXISTS `role_permission`;
CREATE TABLE `role_permission`  (
  `role_id` int(11) NOT NULL,
  `permission_id` int(11) NOT NULL,
  PRIMARY KEY (`role_id`, `permission_id`) USING BTREE,
  INDEX `fk_role_has_permission_permission1`(`permission_id`) USING BTREE,
  INDEX `fk_role_has_permission_role1`(`role_id`) USING BTREE,
  CONSTRAINT `fk_role_permission_permission_1` FOREIGN KEY (`permission_id`) REFERENCES `permission` (`permission_id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `fk_role_permission_role_1` FOREIGN KEY (`role_id`) REFERENCES `role` (`role_id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of role_permission
-- ----------------------------
INSERT INTO `role_permission` VALUES (1, 1);
INSERT INTO `role_permission` VALUES (1, 2);
INSERT INTO `role_permission` VALUES (2, 2);
INSERT INTO `role_permission` VALUES (1, 3);
INSERT INTO `role_permission` VALUES (2, 3);
INSERT INTO `role_permission` VALUES (3, 3);
INSERT INTO `role_permission` VALUES (1, 4);
INSERT INTO `role_permission` VALUES (2, 4);
INSERT INTO `role_permission` VALUES (3, 4);
INSERT INTO `role_permission` VALUES (1, 5);
INSERT INTO `role_permission` VALUES (1, 6);
INSERT INTO `role_permission` VALUES (1, 7);
INSERT INTO `role_permission` VALUES (1, 9);
INSERT INTO `role_permission` VALUES (2, 9);
INSERT INTO `role_permission` VALUES (1, 10);
INSERT INTO `role_permission` VALUES (1, 11);
INSERT INTO `role_permission` VALUES (2, 11);
INSERT INTO `role_permission` VALUES (1, 12);
INSERT INTO `role_permission` VALUES (2, 12);
INSERT INTO `role_permission` VALUES (3, 12);
INSERT INTO `role_permission` VALUES (1, 13);
INSERT INTO `role_permission` VALUES (2, 13);
INSERT INTO `role_permission` VALUES (3, 13);
INSERT INTO `role_permission` VALUES (1, 14);
INSERT INTO `role_permission` VALUES (2, 14);
INSERT INTO `role_permission` VALUES (3, 14);
INSERT INTO `role_permission` VALUES (1, 22);
INSERT INTO `role_permission` VALUES (1, 23);
INSERT INTO `role_permission` VALUES (1, 24);
INSERT INTO `role_permission` VALUES (1, 28);
INSERT INTO `role_permission` VALUES (1, 29);
INSERT INTO `role_permission` VALUES (1, 30);
INSERT INTO `role_permission` VALUES (1, 31);
INSERT INTO `role_permission` VALUES (1, 32);
INSERT INTO `role_permission` VALUES (1, 33);
INSERT INTO `role_permission` VALUES (1, 34);
INSERT INTO `role_permission` VALUES (1, 35);
INSERT INTO `role_permission` VALUES (2, 35);
INSERT INTO `role_permission` VALUES (1, 37);
INSERT INTO `role_permission` VALUES (1, 38);
INSERT INTO `role_permission` VALUES (2, 38);
INSERT INTO `role_permission` VALUES (1, 39);
INSERT INTO `role_permission` VALUES (2, 39);
INSERT INTO `role_permission` VALUES (1, 40);
INSERT INTO `role_permission` VALUES (2, 40);
INSERT INTO `role_permission` VALUES (3, 40);
INSERT INTO `role_permission` VALUES (1, 41);
INSERT INTO `role_permission` VALUES (1, 42);
INSERT INTO `role_permission` VALUES (1, 45);
INSERT INTO `role_permission` VALUES (2, 45);
INSERT INTO `role_permission` VALUES (3, 45);

-- ----------------------------
-- Table structure for specifications
-- ----------------------------
DROP TABLE IF EXISTS `specifications`;
CREATE TABLE `specifications`  (
  `specifications_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '商品规格主键',
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT '规格名称',
  PRIMARY KEY (`specifications_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 16 CHARACTER SET = utf8 COLLATE = utf8_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of specifications
-- ----------------------------
INSERT INTO `specifications` VALUES (1, '纸张');

-- ----------------------------
-- Table structure for store
-- ----------------------------
DROP TABLE IF EXISTS `store`;
CREATE TABLE `store`  (
  `store_id` int(11) NOT NULL AUTO_INCREMENT,
  `shopowner_id` int(11) NOT NULL COMMENT '外键，门店拥有者id',
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '门店名称',
  `phone` varchar(11) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '电话',
  `validtime_start` time(0) NULL DEFAULT NULL,
  `validtime_end` time(0) NULL DEFAULT NULL COMMENT 'validTimeEnd',
  `is_show` int(1) NULL DEFAULT NULL COMMENT '是否显示，0：不显示，1：显示',
  `delivery` int(1) NULL DEFAULT NULL COMMENT '否有有送货上门，0：没有，1：有',
  `freight` decimal(10, 0) NULL DEFAULT NULL COMMENT '运费',
  PRIMARY KEY (`store_id`) USING BTREE,
  INDEX `fk_store_user_1`(`shopowner_id`) USING BTREE,
  CONSTRAINT `fk_store_user_1` FOREIGN KEY (`shopowner_id`) REFERENCES `user` (`user_id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8 COLLATE = utf8_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of store
-- ----------------------------
INSERT INTO `store` VALUES (1, 2, '男饭一楼', '13899998888', '08:00:00', '20:00:00', 1, 1, 2);
INSERT INTO `store` VALUES (2, 7, '广软印务中心', '13588887777', '08:00:00', '20:30:00', 1, 0, 3);

-- ----------------------------
-- Table structure for store_order
-- ----------------------------
DROP TABLE IF EXISTS `store_order`;
CREATE TABLE `store_order`  (
  `order_id` int(20) NOT NULL AUTO_INCREMENT COMMENT '订单主键',
  `user_id` int(11) NOT NULL COMMENT '微信用户外键',
  `store_id` int(11) NOT NULL COMMENT '门店id外键',
  `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `status` int(1) NOT NULL COMMENT '1：待商家完成打印，\r\n2：自提订单待取件，\r\n3：配送订单待配送，\r\n4：交易完成，\r\n-1：退款中，\r\n-2：已退款，',
  `is_self_mention` int(1) NOT NULL COMMENT '是否是自提 1：是 0：否',
  `address_id` int(11) NULL DEFAULT NULL COMMENT '地址外键',
  `number` varchar(11) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT '订单编号',
  `order_remarks` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT '订单备注',
  `merchant_remarks` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT '商家备注',
  `file_url` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT '附件链接',
  `file_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '附件真实名称',
  `order_contacts` varchar(11) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '联系人',
  `phone_number` varchar(11) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '联系电话',
  `all_price` decimal(10, 2) NOT NULL COMMENT '总价钱',
  `page_number` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '页码范围',
  `evaluate_id` int(11) NULL DEFAULT NULL,
  PRIMARY KEY (`order_id`) USING BTREE,
  INDEX `fk_store_order_store_1`(`store_id`) USING BTREE,
  INDEX `fk_store_order_address_1`(`address_id`) USING BTREE,
  INDEX `fk_store_order_evaluate_1`(`evaluate_id`) USING BTREE,
  INDEX `fk_store_order_wx_user_1`(`user_id`) USING BTREE,
  CONSTRAINT `fk_store_order_address_1` FOREIGN KEY (`address_id`) REFERENCES `address` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `fk_store_order_evaluate_1` FOREIGN KEY (`evaluate_id`) REFERENCES `evaluate` (`evaluate_id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `fk_store_order_store_1` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `fk_store_order_wx_user_1` FOREIGN KEY (`user_id`) REFERENCES `wx_user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 114 CHARACTER SET = utf8 COLLATE = utf8_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of store_order
-- ----------------------------
INSERT INTO `store_order` VALUES (31, 1, 1, '2022-02-24 09:09:09', 5, 1, NULL, '24-2', '', NULL, NULL, NULL, '佳煌', '13544445555', 0.25, '0', NULL);
INSERT INTO `store_order` VALUES (32, 1, 1, '2022-02-24 15:09:32', 5, 1, NULL, '24-3', '', NULL, '/upload/order-file/2022/02/24/a063e90e-f4fd-424b-886f-38bded154abe.doc', '广州大学华软软件学院毕业实习鉴定表（一式两份） - 副本.doc', '佳煌', '13544445555', 0.25, '0', NULL);
INSERT INTO `store_order` VALUES (33, 1, 1, '2022-02-24 15:09:48', 5, 1, NULL, '24-4', '', NULL, '/upload/order-file/2022/02/24/4cc52eca-b842-4638-98a6-872f24dbd475.doc', '广州大学华软软件学院毕业实习鉴定表（一式两份） - 副本.doc', '佳煌', '13544445555', 2.00, '0', NULL);
INSERT INTO `store_order` VALUES (34, 1, 1, '2022-02-24 17:58:18', 5, 1, NULL, '24-5', '', NULL, NULL, NULL, '佳煌', '13544445555', 0.25, '0', NULL);
INSERT INTO `store_order` VALUES (35, 1, 1, '2022-02-25 19:01:02', 5, 0, 1, '25-1', '', NULL, '/upload/order-file/2022/02/25/f31edfb4-a382-484e-857b-c55bef3eab68.pdf', 'a.pdf', NULL, NULL, 4.25, '0', NULL);
INSERT INTO `store_order` VALUES (36, 1, 1, '2022-02-25 19:10:42', 5, 0, 1, '25-2', '', NULL, '/upload/order-file/2022/02/25/f4d735b9-17c5-4fa1-928b-32922f23d960.pdf', 'a.pdf', NULL, NULL, 6.50, '0', NULL);
INSERT INTO `store_order` VALUES (37, 1, 1, '2022-02-25 19:11:44', 5, 0, 1, '25-3', '', NULL, NULL, NULL, NULL, NULL, 4.25, '0', NULL);
INSERT INTO `store_order` VALUES (38, 1, 1, '2022-02-25 19:16:05', 5, 1, NULL, '25-4', '', NULL, NULL, NULL, '佳煌', '13544445555', 0.25, '0', NULL);
INSERT INTO `store_order` VALUES (39, 1, 1, '2022-02-25 19:16:13', 5, 1, NULL, '25-5', '', NULL, NULL, NULL, '佳煌', '13544445555', 0.25, '0', NULL);
INSERT INTO `store_order` VALUES (40, 1, 1, '2022-02-25 19:16:22', 5, 0, 1, '25-6', '', NULL, NULL, NULL, NULL, NULL, 2.25, '0', NULL);
INSERT INTO `store_order` VALUES (41, 1, 1, '2022-02-25 19:16:30', 5, 0, 1, '25-7', '', NULL, NULL, NULL, NULL, NULL, 2.25, '0', NULL);
INSERT INTO `store_order` VALUES (42, 1, 1, '2022-02-27 23:31:49', 5, 1, NULL, '27-1', '', 'asd', NULL, NULL, '佳煌', '13544445555', 0.75, '0', NULL);
INSERT INTO `store_order` VALUES (43, 1, 1, '2022-03-02 20:23:18', 3, 0, 1, '02-1', '', NULL, '/upload/order-file/2022/03/02/e3573c0a-7d00-4403-9ff4-f1b989c37ab5.pdf', 'a.pdf', NULL, NULL, 2.25, '0', NULL);
INSERT INTO `store_order` VALUES (44, 1, 1, '2022-03-02 20:23:45', 5, 1, NULL, '02-2', '', NULL, '/upload/order-file/2022/03/02/b2313081-9125-4f1f-8293-1e5ddd64e286.pdf', 'a.pdf', '佳煌', '13544445555', 0.50, '0', NULL);
INSERT INTO `store_order` VALUES (45, 1, 1, '2022-03-03 18:20:49', 5, 1, NULL, '03-1', '', NULL, '/upload/order-file/2022/03/03/fc6e4979-0aab-4339-8058-a6b8a575afaa.doc', '广州大学华软软件学院毕业实习鉴定表（一式两份） - 副本.doc', '佳煌', '13544445555', 0.25, '0', NULL);
INSERT INTO `store_order` VALUES (46, 1, 1, '2022-03-03 18:22:12', 5, 0, 2, '03-2', '', NULL, '/upload/order-file/2022/03/03/5a98a8ac-60f2-4596-ae92-150094d20c90.doc', '广州大学华软软件学院本科生毕业论文（设计）规范化要求—重点版.doc', NULL, NULL, 2.25, '0', NULL);
INSERT INTO `store_order` VALUES (47, 1, 1, '2022-03-03 18:22:27', -3, 1, NULL, '03-3', '', NULL, '/upload/order-file/2022/03/03/c088b59d-07ac-44d9-8b78-76ae5010af18.pdf', 'a.pdf', '佳煌', '13544445555', 0.25, '0', NULL);
INSERT INTO `store_order` VALUES (48, 1, 1, '2022-03-03 18:49:44', 5, 1, NULL, '03-4', '', 'asd', '/upload/order-file/2022/03/03/e0e81d69-0827-4188-83de-e765884b22e6.jpg', '3.jpg', '佳煌', '13544445555', 0.25, '0', NULL);
INSERT INTO `store_order` VALUES (49, 1, 1, '2022-03-03 18:52:19', -2, 1, NULL, '03-5', '', 'asdasdasdasd', '/upload/order-file/2022/03/03/7a109ed7-a5fc-44c8-b5a7-79aa7d74c57f.pdf', 'a.pdf', '佳煌', '13544445555', 0.25, '0', NULL);
INSERT INTO `store_order` VALUES (50, 1, 1, '2022-03-05 15:39:19', 5, 1, NULL, '05-1', '', NULL, '/upload/order-file/2022/03/05/4d9673d3-67c6-4c6d-b48e-d576e1c7bd18.pdf', 'a.pdf', '佳煌', '13544445555', 0.25, '0', NULL);
INSERT INTO `store_order` VALUES (51, 1, 1, '2022-03-05 15:41:01', 5, 1, NULL, '05-2', '', NULL, '/upload/order-file/2022/03/05/41471d29-77d4-4cf7-8e95-7cbf94d28689.pdf', 'a.pdf', '佳煌', '13544445555', 0.50, '0', NULL);
INSERT INTO `store_order` VALUES (52, 1, 1, '2022-03-05 16:35:46', -3, 0, 2, '05-3', '', NULL, '/upload/order-file/2022/03/05/794cc273-592e-4a6a-9fb0-049c86444fb0.pdf', 'a.pdf', NULL, NULL, 2.25, '0', NULL);
INSERT INTO `store_order` VALUES (53, 1, 1, '2022-03-05 20:03:49', -2, 1, NULL, '05-4', '', 'asd', '/upload/order-file/2022/03/05/8c9612de-ddef-4404-935b-a9d52d35b74c.pdf', 'a.pdf', '佳煌', '13544445555', 0.50, '0', NULL);
INSERT INTO `store_order` VALUES (54, 1, 1, '2022-03-06 20:53:42', -2, 1, NULL, '06-1', '', NULL, '/upload/order-file/2022/03/06/03d1c49e-14b8-4627-a8f8-bda4db6b203c.pdf', 'a.pdf', '佳煌', '13544445555', 0.25, '0', NULL);
INSERT INTO `store_order` VALUES (55, 1, 1, '2022-03-06 20:54:04', -3, 1, NULL, '06-2', '', NULL, '/upload/order-file/2022/03/06/e252e00a-c2f3-4784-9b59-e9e7873a95d9.pdf', 'a.pdf', '佳煌', '13544445555', 0.25, '0', NULL);
INSERT INTO `store_order` VALUES (56, 1, 1, '2022-03-07 16:34:25', 1, 1, NULL, '07-1', '', NULL, '/upload/order-file/2022/03/07/dd484636-1b3f-4146-ab50-593956946466.jpg', '3.jpg', '佳煌', '13544445555', 0.50, '0', NULL);
INSERT INTO `store_order` VALUES (57, 1, 1, '2022-03-07 16:37:11', 1, 1, NULL, '07-2', '', NULL, '/upload/order-file/2022/03/07/2ae136dd-fb5a-452d-b87b-a7bbbafc83d9.pdf', 'a.pdf', '佳煌', '13544445555', 0.25, '0', NULL);
INSERT INTO `store_order` VALUES (58, 1, 1, '2022-03-07 16:45:39', 1, 1, NULL, '07-3', '', NULL, '/upload/order-file/2022/03/07/06635831-cd42-45de-a590-8ea5652eac30.pdf', 'a.pdf', '佳煌', '13544445555', 0.25, '0', NULL);
INSERT INTO `store_order` VALUES (59, 1, 1, '2022-03-07 16:46:10', 5, 1, NULL, '07-4', '', NULL, '/upload/order-file/2022/03/07/8c2dadfe-c190-450d-825e-c2f04f337251.pdf', 'a.pdf', '佳煌', '13544445555', 0.75, '0', 3);
INSERT INTO `store_order` VALUES (60, 1, 1, '2022-03-08 16:48:04', 5, 1, NULL, '08-1', '', NULL, '/upload/order-file/2022/03/08/9eae21c8-95a6-4621-b329-35b719b45d3e.doc', '1840225104蔡佳煌_广州大学华软软件学院毕业实习鉴定表（一式两份）.doc', '蔡佳煌', '13790838659', 0.25, '0', 2);
INSERT INTO `store_order` VALUES (61, 1, 1, '2022-03-08 17:01:33', 5, 0, 1, '08-2', '', NULL, '/upload/order-file/2022/03/08/b180ad66-15bb-43a1-9749-807534d79c1c.doc', '1840225104蔡佳煌_广州大学华软软件学院毕业实习鉴定表（一式两份）.doc', NULL, NULL, 2.25, '0', 1);
INSERT INTO `store_order` VALUES (62, 1, 1, '2022-03-08 21:38:05', 1, 1, NULL, '08-3', '', NULL, 'wxfile://tmp_508862cd956e8a7abba192f4f07b578faac52fd419aa326127cd0c4b41d42e18.docx', '校园云打印系统的设计与实现-答辩稿2.docx', '蔡佳煌', '13790838659', 0.75, '0', NULL);
INSERT INTO `store_order` VALUES (63, 1, 1, '2022-03-08 21:55:26', 1, 1, NULL, '08-4', '', NULL, '/upload/order-file/2022/03/08/e72aec14-d2ce-41b7-8f88-b8e143e1294d.doc', '广州大学华软软件学院毕业实习鉴定表（一式两份） - 副本.doc', '蔡佳煌', '13790838659', 0.25, '0', NULL);
INSERT INTO `store_order` VALUES (64, 1, 1, '2022-03-09 21:45:00', 5, 1, NULL, '09-1', '', NULL, '/upload/order-file/2022/03/09/4959511f-b76d-4630-9ffe-b266f8b73379.pdf', 'a.pdf', '蔡佳煌', '13790838659', 0.25, '0', 4);
INSERT INTO `store_order` VALUES (65, 1, 1, '2022-03-12 12:35:31', 1, 1, NULL, '12-1', '', NULL, '/upload/order-file/2022/03/12/cc46d580-3eeb-4833-a8a5-787b1bd53876.doc', '1840225104蔡佳煌_广州大学华软软件学院毕业实习鉴定表（一式两份）.doc', '蔡佳煌', '13790838659', 0.25, '0', NULL);
INSERT INTO `store_order` VALUES (66, 1, 2, '2022-03-12 12:35:44', 1, 1, NULL, '12-2', '', NULL, '/upload/order-file/2022/03/12/1e1e0626-4b18-434e-a178-0df803aaeed8.pdf', 'a.pdf', '蔡佳煌', '13790838659', 0.25, '0', NULL);
INSERT INTO `store_order` VALUES (67, 1, 2, '2022-03-12 12:36:20', 1, 1, NULL, '12-1', '', NULL, '/upload/order-file/2022/03/12/ed7400a4-12f2-49b5-b532-f23a0ee55477.doc', '1840225104蔡佳煌_广州大学华软软件学院毕业实习鉴定表（一式两份）.doc', '蔡佳煌', '13790838659', 0.25, '0', NULL);
INSERT INTO `store_order` VALUES (68, 1, 1, '2022-03-12 12:36:33', 1, 1, NULL, '12-1', '', NULL, '/upload/order-file/2022/03/12/57c90054-b92e-48ed-afe7-1dabfcccccd5.pdf', 'cloud-printing-back_qd.pdf', '蔡佳煌', '13790838659', 0.25, '0', NULL);
INSERT INTO `store_order` VALUES (69, 1, 1, '2022-03-12 12:36:45', 1, 1, NULL, '12-2', '', NULL, '/upload/order-file/2022/03/12/9dc862d1-e070-4811-abca-e0986de15a33.doc', '1840225104蔡佳煌_广州大学华软软件学院毕业实习鉴定表（一式两份）.doc', '蔡佳煌', '13790838659', 0.25, '0', NULL);
INSERT INTO `store_order` VALUES (70, 1, 2, '2022-03-12 12:36:57', 1, 1, NULL, '12-2', '', NULL, '/upload/order-file/2022/03/12/2a73429b-c349-41d1-b4fb-20fd62098f6a.doc', '1840225104蔡佳煌_广州大学华软软件学院毕业实习鉴定表（一式两份）.doc', '蔡佳煌', '13790838659', 0.25, '0', NULL);
INSERT INTO `store_order` VALUES (71, 1, 2, '2022-03-12 12:46:07', 1, 1, NULL, '12-3', '', NULL, '/upload/order-file/2022/03/12/cb5d31ed-bb72-42ec-be6b-d88c0a092b2e.doc', '1840225104蔡佳煌_广州大学华软软件学院毕业实习鉴定表（一式两份）.doc', '蔡佳煌', '13790838659', 2.50, '0', NULL);
INSERT INTO `store_order` VALUES (72, 1, 2, '2022-03-12 12:46:23', 1, 1, NULL, '12-4', '', NULL, '/upload/order-file/2022/03/12/5a41c808-7ee2-4289-ab93-4329771481c7.pdf', 'a.pdf', '蔡佳煌', '13790838659', 0.50, '0', NULL);
INSERT INTO `store_order` VALUES (73, 1, 1, '2022-03-12 13:46:13', 1, 1, NULL, '12-3', '', NULL, '/upload/order-file/2022/03/12/a722e8be-8c0e-41a1-83f2-642ffa1fa7d6.pdf', 'a.pdf', '蔡佳煌', '13790838659', 0.25, '0', NULL);
INSERT INTO `store_order` VALUES (74, 1, 1, '2022-03-12 13:46:32', 1, 0, 2, '12-4', '', NULL, '/upload/order-file/2022/03/12/3f5d2288-5961-4cd4-8a7c-ae036c43d0a3.pdf', 'a.pdf', NULL, NULL, 4.50, '0', NULL);
INSERT INTO `store_order` VALUES (75, 1, 1, '2022-03-12 13:46:48', 5, 0, 2, '12-5', '', NULL, '/upload/order-file/2022/03/12/9b0c5919-3bd4-4b82-a1c5-0e6428ebcd9e.doc', '1840225104蔡佳煌_广州大学华软软件学院毕业实习鉴定表（一式两份）.doc', NULL, NULL, 2.25, '0', 6);
INSERT INTO `store_order` VALUES (76, 1, 1, '2022-03-12 13:47:06', -3, 1, NULL, '12-6', '', NULL, '/upload/order-file/2022/03/12/7f7313ca-aac3-4276-b9fd-0eabe539dba8.pdf', 'a.pdf', '蔡佳煌', '13790838659', 0.25, '0', NULL);
INSERT INTO `store_order` VALUES (77, 1, 1, '2022-03-12 13:47:19', -2, 1, NULL, '12-7', '', NULL, '/upload/order-file/2022/03/12/b61d6bb6-4733-461d-840a-4e85acbfda96.doc', '1840225104蔡佳煌_广州大学华软软件学院毕业实习鉴定表（一式两份）.doc', '蔡佳煌', '13790838659', 0.50, '0', NULL);
INSERT INTO `store_order` VALUES (78, 1, 1, '2022-03-12 13:48:58', 5, 1, NULL, '12-8', '', NULL, '/upload/order-file/2022/03/12/c77af0b2-d030-49de-9be0-5b4c0f0cdbaf.pdf', 'cloud-printing-back_qd.pdf', '蔡佳煌', '13790838659', 0.75, '0', 5);
INSERT INTO `store_order` VALUES (79, 1, 1, '2022-03-15 19:36:46', 5, 1, NULL, '15-1', '', NULL, '/upload/order-file/2022/03/15/9df67d6d-a6c4-426e-903b-0b9f06a56a46.doc', '1840225104蔡佳煌_广州大学华软软件学院毕业实习鉴定表（一式两份）.doc', '蔡佳煌', '13790838659', 0.25, '0', 7);
INSERT INTO `store_order` VALUES (80, 4, 1, '2022-03-15 20:27:45', 5, 1, NULL, '15-2', '', NULL, '/upload/order-file/2022/03/15/acdece66-bd7b-4dfe-af0e-16677f646f58.doc', '广州大学华软软件学院毕业实习鉴定表（一式两份）.doc', '豪', '14718076931', 0.25, '0', NULL);
INSERT INTO `store_order` VALUES (81, 1, 1, '2022-04-06 19:29:57', 1, 1, NULL, '06-1', '', NULL, '/upload/order-file/2022/04/06/db1ba456-e3b5-4d36-b826-e1e7efd5ad52.docx', '1840225104蔡佳煌_校园云打印系统的设计与实现-答辩稿02.docx', '蔡佳煌', '13790838659', 0.75, '0', NULL);
INSERT INTO `store_order` VALUES (82, 1, 1, '2022-04-09 18:31:19', 1, 1, NULL, '09-1', '', NULL, '/upload/order-file/2022/04/09/e02ccfd9-464f-41d2-98c9-c5b4576685a5.docx', '1840225104蔡佳煌_校园云打印系统的设计与实现-答辩稿02.docx', '蔡佳煌', '13790838659', 0.25, '0', NULL);
INSERT INTO `store_order` VALUES (83, 1, 1, '2022-04-09 18:31:52', 5, 1, NULL, '09-2', '', NULL, '/upload/order-file/2022/04/09/04e18e17-16c2-4714-b5bf-bcd0aef56653.docx', '1840225104蔡佳煌_校园云打印系统的设计与实现-答辩稿02.docx', '蔡佳煌', '13790838659', 0.25, '0', NULL);
INSERT INTO `store_order` VALUES (84, 1, 1, '2022-04-14 22:53:11', 1, 1, NULL, '14-1', '', NULL, '/upload/order-file/2022/04/14/aebdb5f3-29fa-4170-bea6-c3b1f384f9c8.docx', '1840225104蔡佳煌_校园云打印系统的设计与实现-答辩稿02.docx', '蔡佳煌', '13790838659', 0.25, '0', NULL);
INSERT INTO `store_order` VALUES (85, 1, 1, '2022-04-15 00:01:14', 1, 1, NULL, '15-2', '', NULL, '/upload/order-file/2022/04/15/5c04a274-a02c-4efc-966c-f3a883bdf5db.docx', '1840225104蔡佳煌 校园云打印系统的设计与实现 .docx', '蔡佳煌', '13790838659', 0.25, '0', NULL);
INSERT INTO `store_order` VALUES (86, 1, 1, '2022-04-16 16:28:44', 5, 1, NULL, '16-1', '', NULL, '/upload/order-file/2022/04/16/40528d88-5a73-46d3-a65f-c0e12e450722.docx', '1840225104蔡佳煌 校园云打印系统的设计与实现 .docx', '蔡佳煌', '13790838659', 15.00, '0', 8);
INSERT INTO `store_order` VALUES (87, 1, 1, '2022-04-16 16:38:28', -3, 0, 1, '16-2', '', NULL, '/upload/order-file/2022/04/16/c291f807-e24e-41f5-8e92-bed16a7867b9.pdf', 'cloud-printing-back_qd.pdf', NULL, NULL, 4.50, '0', NULL);
INSERT INTO `store_order` VALUES (88, 1, 1, '2022-04-16 22:39:51', 1, 1, NULL, '16-3', '', NULL, '/upload/order-file/2022/04/16/a491309c-3291-4de8-aba7-be636f501ba6.pdf', 'cloud-printing-back_qd.pdf', '蔡佳煌', '13790838659', 0.50, '0', NULL);
INSERT INTO `store_order` VALUES (89, 1, 1, '2022-04-17 17:35:02', 5, 1, NULL, '17-1', '', NULL, '/upload/order-file/2022/04/17/198c4fc3-b1e3-4347-84bf-19b61df3b4da.pdf', 'cloud-printing-back_qd.pdf', '蔡佳煌', '13790838659', 2.50, '0', NULL);
INSERT INTO `store_order` VALUES (90, 1, 1, '2022-04-17 20:27:27', 5, 1, NULL, '17-2', '', NULL, '/upload/order-file/2022/04/17/759a0052-5559-41db-b452-78f2ec60c1d2.pdf', 'cloud-printing-back_qd.pdf', '蔡佳煌', '13790838659', 2.50, '0', 9);
INSERT INTO `store_order` VALUES (91, 1, 1, '2022-04-17 20:35:03', -2, 0, 2, '17-3', '', NULL, '/upload/order-file/2022/04/17/d6a3ba36-532c-437a-bf3e-6b2708556c00.doc', '广州大学华软软件学院本科生毕业论文（设计）规范化要求—重点版.doc', NULL, NULL, 4.50, '0', NULL);
INSERT INTO `store_order` VALUES (92, 1, 1, '2022-04-18 21:46:24', 5, 1, NULL, '18-1', '', NULL, '/upload/order-file/2022/04/18/1076ccc0-4325-4034-bcf9-92c6d2cb7e45.pdf', 'cloud-printing-back_qd.pdf', '蔡佳煌', '13790838659', 2.50, '0', 10);
INSERT INTO `store_order` VALUES (93, 1, 1, '2022-04-18 21:52:09', -3, 0, 2, '18-2', '', NULL, '/upload/order-file/2022/04/18/fbccd7fb-40ba-4233-941c-dd15a55ec03d.pdf', 'cloud-printing-back_qd.pdf', NULL, NULL, 2.25, '0', NULL);
INSERT INTO `store_order` VALUES (94, 1, 1, '2022-04-18 22:20:18', 1, 1, NULL, '18-3', '', NULL, '/upload/order-file/2022/04/18/97a976a0-d360-4855-ac4e-5fdeb87292bf.docx', '1840225104蔡佳煌 校园云打印系统的设计与实现 .docx', '蔡佳煌', '13790838659', 2.50, '0', NULL);
INSERT INTO `store_order` VALUES (95, 1, 1, '2022-04-18 22:20:55', 1, 1, NULL, '18-4', '', NULL, '/upload/order-file/2022/04/18/489009a3-ad95-4578-9d53-f088dbdf02f3.doc', '广州大学华软软件学院本科生毕业论文（设计）规范化要求—重点版.doc', '蔡佳煌', '13790838659', 0.25, '0', NULL);
INSERT INTO `store_order` VALUES (96, 1, 1, '2022-04-18 22:21:38', 1, 1, NULL, '18-5', '', NULL, '/upload/order-file/2022/04/18/05db5325-dae2-40f0-8547-77a2fd1bdcdb.doc', '广州大学华软软件学院本科生毕业论文（设计）规范化要求—重点版.doc', '蔡佳煌', '13790838659', 0.25, '0', NULL);
INSERT INTO `store_order` VALUES (97, 1, 1, '2022-04-19 21:54:10', 5, 1, NULL, '19-1', '', NULL, '/upload/order-file/2022/04/19/bbfb6eb6-f34e-4ffb-b543-0752043764d0.doc', '广州大学华软软件学院本科生毕业论文（设计）规范化要求—重点版.doc', '蔡佳煌', '13790838659', 2.50, '0', 11);
INSERT INTO `store_order` VALUES (98, 1, 1, '2022-04-19 21:57:22', -3, 0, 2, '19-2', '', NULL, '/upload/order-file/2022/04/19/0ab23dc9-664d-4493-9fc8-d4d6d75a86b7.pdf', 'cloud-printing-back_qd.pdf', NULL, NULL, 4.50, '0', NULL);
INSERT INTO `store_order` VALUES (99, 1, 1, '2022-04-19 22:10:35', 1, 1, NULL, '19-3', '', NULL, '/upload/order-file/2022/04/19/321a4a15-a8b3-4018-b770-c9ed41f40ba5.doc', '广州大学华软软件学院本科生毕业论文（设计）规范化要求—重点版.doc', '蔡佳煌', '13790838659', 2.50, '0', NULL);
INSERT INTO `store_order` VALUES (100, 1, 2, '2022-04-20 11:52:13', 1, 1, NULL, '20-1', '', NULL, '/upload/order-file/2022/04/20/48897458-d775-482e-8d04-df853569141a.doc', '广州大学华软软件学院本科生毕业论文（设计）规范化要求—重点版.doc', '蔡佳煌', '13790838659', 0.25, '0', NULL);
INSERT INTO `store_order` VALUES (101, 1, 1, '2022-04-20 11:53:03', 1, 1, NULL, '20-1', '', NULL, '/upload/order-file/2022/04/20/eb81f9e6-6f2e-421c-8d1d-3c6013b83127.doc', '广州大学华软软件学院本科生毕业论文（设计）规范化要求—重点版.doc', '蔡佳煌', '13790838659', 2.50, '0', NULL);
INSERT INTO `store_order` VALUES (102, 1, 1, '2022-04-20 19:34:04', 5, 1, NULL, '20-2', '', NULL, '/upload/order-file/2022/04/20/234e7b34-04a1-49b1-8f5f-a17739545aec.pdf', 'cloud-printing-back_qd.pdf', '蔡佳煌', '13790838659', 2.50, '0', 12);
INSERT INTO `store_order` VALUES (103, 1, 1, '2022-04-20 19:36:08', -2, 0, 2, '20-3', '', NULL, '/upload/order-file/2022/04/20/b6c27e34-f8a5-4682-acc5-7e151d7e909b.pdf', 'cloud-printing-back_qd.pdf', NULL, NULL, 2.25, '0', NULL);
INSERT INTO `store_order` VALUES (104, 1, 1, '2022-04-21 21:51:59', 1, 1, NULL, '21-1', '', NULL, '/upload/order-file/2022/04/21/a0619a39-715c-4376-b930-932fe629a8b3.pdf', 'cloud-printing-back_qd.pdf', '蔡佳煌', '13790838659', 2.50, '0', NULL);
INSERT INTO `store_order` VALUES (105, 1, 1, '2022-04-21 21:57:59', 5, 1, NULL, '21-2', '', NULL, '/upload/order-file/2022/04/21/fb3bb986-9131-4af6-a0ba-b3cc0b4172ae.pdf', 'cloud-printing-back_qd.pdf', '蔡佳煌', '13790838659', 2.50, '0', 13);
INSERT INTO `store_order` VALUES (106, 1, 1, '2022-04-21 22:01:23', 5, 0, 2, '21-3', '', NULL, '/upload/order-file/2022/04/21/e3727066-73e1-407c-ab57-b77eadba4b88.pdf', 'cloud-printing-back_qd.pdf', NULL, NULL, 2.25, '0', NULL);
INSERT INTO `store_order` VALUES (107, 1, 1, '2022-04-21 22:08:01', 1, 1, NULL, '21-4', '', NULL, '/upload/order-file/2022/04/21/797f78ee-bc88-47d9-b3c6-2825e986bc2f.pdf', 'cloud-printing-back_qd.pdf', '蔡佳煌', '13790838659', 0.25, '0', NULL);
INSERT INTO `store_order` VALUES (108, 1, 1, '2022-04-21 22:19:06', 5, 1, NULL, '21-5', '', NULL, '/upload/order-file/2022/04/21/9a5e2ba7-a7ff-4933-9040-308be6a160cd.pdf', 'cloud-printing-back_qd.pdf', '蔡佳煌', '13790838659', 0.25, '0', 14);
INSERT INTO `store_order` VALUES (109, 1, 1, '2022-04-21 22:22:16', -2, 0, 2, '21-6', '', NULL, '/upload/order-file/2022/04/21/ee5bbc46-de77-4e19-b607-c63a1ec6c516.docx', '1840225104蔡佳煌 校园云打印系统的设计与实现 .docx', NULL, NULL, 2.25, '0', NULL);
INSERT INTO `store_order` VALUES (110, 1, 1, '2022-04-21 22:33:23', 5, 1, NULL, '21-7', '', NULL, '/upload/order-file/2022/04/21/6be56f10-934e-40db-826e-be46fe009d6f.pdf', 'cloud-printing-back_qd.pdf', '蔡佳煌', '13790838659', 2.50, '0', 15);
INSERT INTO `store_order` VALUES (111, 1, 1, '2022-04-21 22:35:57', -2, 0, 2, '21-8', '', NULL, '/upload/order-file/2022/04/21/2ef29401-5b5c-4e75-9419-276b1f3d7728.pdf', 'cloud-printing-back_qd.pdf', NULL, NULL, 2.25, '0', NULL);
INSERT INTO `store_order` VALUES (112, 1, 1, '2022-04-21 22:59:51', 1, 1, NULL, '21-9', '', NULL, '/upload/order-file/2022/04/21/45acdf47-5664-40ac-93dc-766025460b60.doc', '1840225104蔡佳煌_广州大学华软软件学院毕业实习鉴定表（一式两份） - 副本.doc', '蔡佳煌', '13790838659', 0.25, '0', NULL);
INSERT INTO `store_order` VALUES (113, 1, 1, '2022-04-22 09:50:45', 5, 1, NULL, '22-1', '', NULL, '/upload/order-file/2022/04/22/cca167b4-a211-4ec0-9b96-209359398be9.doc', '1840225104蔡佳煌_广州大学华软软件学院毕业实习鉴定表（一式两份） - 副本.doc', '蔡佳煌a', '13790838659', 0.50, '0', 16);
INSERT INTO `store_order` VALUES (114, 1, 1, '2022-04-22 09:52:52', -2, 0, 1, '22-2', '', NULL, '/upload/order-file/2022/04/22/5969a464-7d09-411e-a8ef-0640dfd20c11.doc', '1840225104蔡佳煌_广州大学华软软件学院毕业实习鉴定表（一式两份） - 副本.doc', NULL, NULL, 2.25, '0', NULL);

-- ----------------------------
-- Table structure for type_group
-- ----------------------------
DROP TABLE IF EXISTS `type_group`;
CREATE TABLE `type_group`  (
  `type_group_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '商品类型 值主键',
  `specifications_id` int(11) NOT NULL COMMENT '商品规格外键',
  `type_group_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '规格小组名称',
  PRIMARY KEY (`type_group_id`) USING BTREE,
  INDEX `fk_type_group_specifications_1`(`specifications_id`) USING BTREE,
  CONSTRAINT `fk_type_group_specifications_1` FOREIGN KEY (`specifications_id`) REFERENCES `specifications` (`specifications_id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 48 CHARACTER SET = utf8 COLLATE = utf8_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of type_group
-- ----------------------------
INSERT INTO `type_group` VALUES (1, 1, '颜色');
INSERT INTO `type_group` VALUES (2, 1, '尺寸');

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user`  (
  `user_id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `password` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `salt` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `sex` varchar(1) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  PRIMARY KEY (`user_id`) USING BTREE,
  UNIQUE INDEX `username`(`username`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 23 CHARACTER SET = utf8 COLLATE = utf8_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES (1, 'admin', '0ceee0943648fdb25109198e7385d5c0', 'f41cba1f7dd04793822b32da8b009058', '男');
INSERT INTO `user` VALUES (2, 'nanfan1', 'c68817a9cd9ebdae9d81849e78b1c1d7', 'a6fa099159a9428b812b59ef25720dc9', '男');
INSERT INTO `user` VALUES (7, 'ywzx1', '48c0091f5c6b6968085db4b12c80f3f2', '16e52182cb0f4b2c99e6a97e00526be4', '男');
INSERT INTO `user` VALUES (8, 'yg1', '9c0cbf2b6a65079c0d0c33345e9e523c', 'd8b74a42d50d4137b9dfb6fa653d6d3c', '男');
INSERT INTO `user` VALUES (9, 'yg2', '76a69ce8c767d0ffb3425a0ea86f15e8', 'ec6d22b73ce5456db88ffc8cb899e335', '男');
INSERT INTO `user` VALUES (23, 'test', 'b50049c0de12877010685dd5cd7ce4f0', 'a3f755eaa5dd4b258f91fa94c380185f', '男');

-- ----------------------------
-- Table structure for user_role
-- ----------------------------
DROP TABLE IF EXISTS `user_role`;
CREATE TABLE `user_role`  (
  `user_id` int(11) NOT NULL,
  `role_id` int(11) NOT NULL,
  PRIMARY KEY (`user_id`, `role_id`) USING BTREE,
  INDEX `fk_user_has_role_role1`(`role_id`) USING BTREE,
  INDEX `fk_user_has_role_user`(`user_id`) USING BTREE,
  CONSTRAINT `fk_user_role_role_1` FOREIGN KEY (`role_id`) REFERENCES `role` (`role_id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `fk_user_role_user_1` FOREIGN KEY (`user_id`) REFERENCES `user` (`user_id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of user_role
-- ----------------------------
INSERT INTO `user_role` VALUES (1, 1);
INSERT INTO `user_role` VALUES (2, 2);
INSERT INTO `user_role` VALUES (7, 2);
INSERT INTO `user_role` VALUES (8, 3);
INSERT INTO `user_role` VALUES (9, 3);
INSERT INTO `user_role` VALUES (23, 3);

-- ----------------------------
-- Table structure for wx_user
-- ----------------------------
DROP TABLE IF EXISTS `wx_user`;
CREATE TABLE `wx_user`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `nick_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '昵称',
  `gender` int(1) NULL DEFAULT NULL COMMENT '0:男,1:女',
  `avatar_url` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT '头像',
  `phone_number` varchar(11) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '手机号码',
  `openid` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '用户在当前小程序的唯一标识',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `openid`(`openid`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE = utf8_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of wx_user
-- ----------------------------
INSERT INTO `wx_user` VALUES (1, '蔡佳煌', 0, '/upload/wxUserAvatar/3f332510-6b18-4510-b6ac-69fa765414f8.jpg', '13790838659', 'oQgt55OKg6OiiDDKtMVCpGu2vWBc');
INSERT INTO `wx_user` VALUES (3, '雪糕', 0, '/upload/wxUserAvatar/559eea55-a2db-417f-9319-c3c2cd366ba7.png', NULL, 'oQgt55FYK8n2S5mRiAiwGhk9S4Z4');
INSERT INTO `wx_user` VALUES (4, '豪', 0, '/upload/wxUserAvatar/5e93c0fe-245d-448f-bdbd-885b7891defa.png', NULL, 'oQgt55EhtLh15idNY3bGwJwdaTxo');

SET FOREIGN_KEY_CHECKS = 1;