Начало Каталог Помощ
Регистрация Вход
0210467
/
app-AgricultureSmart
0
0
Разклонения 0
Файлове Задачи 0 Заявки за сливане 0 Уики
ИН на ревизия: d42841f27b
Клонове Маркери
app-Agriculture...
/
fruit_farmer.sql

fruit_farmer.sql 58 KB
История Директен файл

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421 
  1. /*
    2. 

  2.  Navicat Premium Data Transfer
    3. 

  3. 

  4.  Source Server         : 熊浩毅
    5. 

  5.  Source Server Type    : MySQL
    6. 

  6.  Source Server Version : 80033
    7. 

  7.  Source Host           : localhost:3306
    8. 

  8.  Source Schema         : fruit_farmer
    9. 

  9. 

  10.  Target Server Type    : MySQL
    11. 

  11.  Target Server Version : 80033
    12. 

  12.  File Encoding         : 65001
    13. 

  13. 

  14.  Date: 06/05/2024 00:10:51
    15. 

  15. */
    16. 

  16. 

  17. SET NAMES utf8mb4;
    18. 

  18. SET FOREIGN_KEY_CHECKS = 0;
    19. 

  19. 

  20. -- ----------------------------
    21. 

  21. -- Table structure for address
    22. 

  22. -- ----------------------------
    23. 

  23. DROP TABLE IF EXISTS `address`;
    24. 

  24. CREATE TABLE `address`  (
    25. 

  25.   `id` int NOT NULL AUTO_INCREMENT COMMENT '地址id',
    26. 

  26.   `user_id` int NOT NULL COMMENT '用户id',
    27. 

  27.   `address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '地址',
    28. 

  28.   `door_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '门牌号',
    29. 

  29.   `phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '收货电话',
    30. 

  30.   `recipient_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '收货人姓名',
    31. 

  31.   PRIMARY KEY (`id`) USING BTREE,
    32. 

  32.   INDEX `user_id`(`user_id` ASC) USING BTREE,
    33. 

  33.   CONSTRAINT `address_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
    34. 

  34. ) ENGINE = InnoDB AUTO_INCREMENT = 12 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '用户地址表' ROW_FORMAT = Dynamic;
    35. 

  35. 

  36. -- ----------------------------
    37. 

  37. -- Records of address
    38. 

  38. -- ----------------------------
    39. 

  39. INSERT INTO `address` VALUES (9, 2, '江西财经大学枫林园', '2#524', '12345678910', '瑶妹');
    40. 

  40. INSERT INTO `address` VALUES (10, 1, '江西省南昌市经济开发区双港西大街绿地悦公馆', '5#2701', '18779165101', '小淮');
    41. 

  41. INSERT INTO `address` VALUES (11, 1, '江西省南昌市经济开发区枫林大道江西财经大学', '2栋424', '18779165101', '小淮');
    42. 

  42. 

  43. -- ----------------------------
    44. 

  44. -- Table structure for admin
    45. 

  45. -- ----------------------------
    46. 

  46. DROP TABLE IF EXISTS `admin`;
    47. 

  47. CREATE TABLE `admin`  (
    48. 

  48.   `id` int NOT NULL AUTO_INCREMENT COMMENT 'ID',
    49. 

  49.   `username` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '用户名',
    50. 

  50.   `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '密码',
    51. 

  51.   `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '姓名',
    52. 

  52.   `avatar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '头像',
    53. 

  53.   `role` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '角色标识',
    54. 

  54.   `phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '电话',
    55. 

  55.   `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '邮箱',
    56. 

  56.   PRIMARY KEY (`id`) USING BTREE
    57. 

  57. ) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '管理员' ROW_FORMAT = DYNAMIC;
    58. 

  58. 

  59. -- ----------------------------
    60. 

  60. -- Records of admin
    61. 

  61. -- ----------------------------
    62. 

  62. INSERT INTO `admin` VALUES (1, 'admin', 'admin', '超级管理员', 'http://118.89.54.252:8714/files/1697438073596-avatar.png', 'ADMIN', '13677889922', 'admin@xm.com');
    63. 

  63. INSERT INTO `admin` VALUES (2, '熊浩毅', '123', '熊浩毅超级管理员', 'http://118.89.54.252:8714/files/1697438073596-avatar.png', 'ADMIN', '18779165101', '3132710967@qq.com');
    64. 

  64. INSERT INTO `admin` VALUES (3, '任瑶', '123', '任瑶超级管理员', 'http://118.89.54.252:8714/files/1697438073596-avatar.png', 'ADMIN', NULL, NULL);
    65. 

  65. INSERT INTO `admin` VALUES (4, '詹志炜', '123', '詹志炜超级管理员', NULL, 'ADMIN', NULL, NULL);
    66. 

  66. 

  67. -- ----------------------------
    68. 

  68. -- Table structure for adminstore
    69. 

  69. -- ----------------------------
    70. 

  70. DROP TABLE IF EXISTS `adminstore`;
    71. 

  71. CREATE TABLE `adminstore`  (
    72. 

  72.   `id` int NOT NULL AUTO_INCREMENT COMMENT 'ID',
    73. 

  73.   `username` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '用户名',
    74. 

  74.   `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '密码',
    75. 

  75.   `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '姓名',
    76. 

  76.   `avatar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '头像',
    77. 

  77.   `role` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '角色标识',
    78. 

  78.   `phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '电话',
    79. 

  79.   `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '邮箱',
    80. 

  80.   `address` int NULL DEFAULT NULL COMMENT '店铺地址id',
    81. 

  81.   `store_id` int NULL DEFAULT NULL COMMENT '店铺id',
    82. 

  82.   PRIMARY KEY (`id`) USING BTREE
    83. 

  83. ) ENGINE = InnoDB AUTO_INCREMENT = 9 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '店铺管理员' ROW_FORMAT = DYNAMIC;
    84. 

  84. 

  85. -- ----------------------------
    86. 

  86. -- Records of adminstore
    87. 

  87. -- ----------------------------
    88. 

  88. INSERT INTO `adminstore` VALUES (1, '熊浩毅', '123', '淮店主', NULL, 'STOREKEEPER', '18779165101', '3132710967@qq.com', NULL, NULL);
    89. 

  89. INSERT INTO `adminstore` VALUES (2, '任瑶', '123', '瑶店主', NULL, 'STOREKEEPER', NULL, NULL, NULL, NULL);
    90. 

  90. INSERT INTO `adminstore` VALUES (5, '淮', '123', '熊浩毅', NULL, 'STOREKEEPER', NULL, NULL, NULL, NULL);
    91. 

  91. INSERT INTO `adminstore` VALUES (6, 'admin', 'admin', '淮店主', NULL, 'STOREKEEPER', NULL, NULL, NULL, 1);
    92. 

  92. INSERT INTO `adminstore` VALUES (8, 'xhy', '123', '陌店主', NULL, 'STOREKEEPER', NULL, NULL, NULL, 2);
    93. 

  93. 

  94. -- ----------------------------
    95. 

  95. -- Table structure for audits
    96. 

  96. -- ----------------------------
    97. 

  97. DROP TABLE IF EXISTS `audits`;
    98. 

  98. CREATE TABLE `audits`  (
    99. 

  99.   `id` int NOT NULL AUTO_INCREMENT COMMENT 'id',
    100. 

  100.   `store_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '店铺地址',
    101. 

  101.   `idcard` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '身份证',
    102. 

  102.   `business_license` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '营业执照url',
    103. 

  103.   `reason` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '申请理由',
    104. 

  104.   `pics_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '市区营业图片',
    105. 

  105.   `camera_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '监控地址',
    106. 

  106.   `store_id` int NULL DEFAULT NULL COMMENT '店铺申请人id用adminstore的id',
    107. 

  107.   `keeper_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '店铺主名称',
    108. 

  108.   `state` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '审核状态',
    109. 

  109.   `admin_id` int NULL DEFAULT NULL COMMENT '申请的管理员id',
    110. 

  110.   PRIMARY KEY (`id`) USING BTREE
    111. 

  111. ) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '申请审核表' ROW_FORMAT = Dynamic;
    112. 

  112. 

  113. -- ----------------------------
    114. 

  114. -- Records of audits
    115. 

  115. -- ----------------------------
    116. 

  116. INSERT INTO `audits` VALUES (2, '山西省长治市潞城区啊啊啊', '', 'http://localhost:2441/files/1713517958135-head.jpg', '我要赚米了', 'http://69b89r4952.yicp.fun//files/1713457745729-head.jpg', NULL, NULL, '熊浩毅', '正在审核', 2);
    117. 

  117. INSERT INTO `audits` VALUES (3, '北京市市辖区西城区阎王庙', '', 'http://localhost:2441/files/1713535491555-A_header1.png', '想抓泥鳅', '', NULL, NULL, '熊浩毅', '正在审核', 2);
    118. 

  118. INSERT INTO `audits` VALUES (4, '北京市市辖区东城区河道去', '', 'http://localhost:2441/files/1714821774309-Screenshot_2024-05-02-21-06-24-38_b84839d832046b3.jpg', '想开一家店铺', 'http://69b89r4952.yicp.fun//files/1714821765185-b036f756ce66b4ccd87f60688b1b400.png', NULL, NULL, '熊浩毅', '审核通过', 6);
    119. 

  119. INSERT INTO `audits` VALUES (5, '北京市市辖区东城区河道去', '', 'http://localhost:2441/files/1714821774309-Screenshot_2024-05-02-21-06-24-38_b84839d832046b3.jpg', '想开一家店铺', 'http://69b89r4952.yicp.fun//files/1714821765185-b036f756ce66b4ccd87f60688b1b400.png', NULL, NULL, '熊浩毅', '正在审核', NULL);
    120. 

  120. 

  121. -- ----------------------------
    122. 

  122. -- Table structure for notice
    123. 

  123. -- ----------------------------
    124. 

  124. DROP TABLE IF EXISTS `notice`;
    125. 

  125. CREATE TABLE `notice`  (
    126. 

  126.   `id` int NOT NULL AUTO_INCREMENT COMMENT 'ID',
    127. 

  127.   `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '标题',
    128. 

  128.   `content` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '内容',
    129. 

  129.   `time` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '创建时间',
    130. 

  130.   `user` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '创建人',
    131. 

  131.   PRIMARY KEY (`id`) USING BTREE
    132. 

  132. ) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '公告信息表' ROW_FORMAT = DYNAMIC;
    133. 

  133. 

  134. -- ----------------------------
    135. 

  135. -- Records of notice
    136. 

  136. -- ----------------------------
    137. 

  137. INSERT INTO `notice` VALUES (1, '系统介绍', '本系统提供店铺管理，店铺致力于助农帮农的', '2024-4-01', 'admin');
    138. 

  138. INSERT INTO `notice` VALUES (2, '店铺报表', '所有功能都已完成，可以正常使用', '2024-4-01', 'admin');
    139. 

  139. INSERT INTO `notice` VALUES (3, '订单管理', '今天天气很不错，可以出去一起玩了', '2024-4-01', 'admin');
    140. 

  140. INSERT INTO `notice` VALUES (4, '订单报表', '自2024年4月16日起开始进行项目开发', '2024-04-16', 'admin');
    141. 

  141. INSERT INTO `notice` VALUES (5, '果园监控', '果园中监控的播放实时查看监控视频', NULL, NULL);
    142. 

  142. INSERT INTO `notice` VALUES (6, '虫害识别', '上传图片，识别图片', NULL, NULL);
    143. 

  143. INSERT INTO `notice` VALUES (7, '系统大数据可视化', '全网数据系统可视化界面大图', NULL, NULL);
    144. 

  144. 

  145. -- ----------------------------
    146. 

  146. -- Table structure for orders
    147. 

  147. -- ----------------------------
    148. 

  148. DROP TABLE IF EXISTS `orders`;
    149. 

  149. CREATE TABLE `orders`  (
    150. 

  150.   `id` int NOT NULL AUTO_INCREMENT COMMENT 'id',
    151. 

  151.   `bid_pay` decimal(10, 2) NULL DEFAULT NULL COMMENT '实付金额',
    152. 

  152.   `origin_pay` decimal(10, 2) NULL DEFAULT NULL COMMENT '应付金额',
    153. 

  153.   `user_id` int NULL DEFAULT NULL COMMENT '下单用户id',
    154. 

  154.   `address_id` int NULL DEFAULT NULL COMMENT '收货地址id',
    155. 

  155.   `time_pre` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '预计送达时间',
    156. 

  156.   `time_order` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '下单时间',
    157. 

  157.   `order_state` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '订单状态',
    158. 

  158.   `order_remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '订单备注',
    159. 

  159.   `trans_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '交易单号',
    160. 

  160.   `order_products_lists` json NULL COMMENT '购买清单：商品id，商品名称，商品数量',
    161. 

  161.   `store_id` int NULL DEFAULT NULL COMMENT '购买的店铺',
    162. 

  162.   PRIMARY KEY (`id`) USING BTREE,
    163. 

  163.   INDEX `user_id`(`user_id` ASC) USING BTREE,
    164. 

  164.   INDEX `address_id`(`address_id` ASC) USING BTREE,
    165. 

  165.   CONSTRAINT `orders_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
    166. 

  166.   CONSTRAINT `orders_ibfk_2` FOREIGN KEY (`address_id`) REFERENCES `address` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
    167. 

  167. ) ENGINE = InnoDB AUTO_INCREMENT = 60 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '订单表' ROW_FORMAT = Dynamic;
    168. 

  168. 

  169. -- ----------------------------
    170. 

  170. -- Records of orders
    171. 

  171. -- ----------------------------
    172. 

  172. INSERT INTO `orders` VALUES (2, 12.00, 15.00, 1, 9, '2024-05-01 17:29:09', '2024-05-01 17:28:58', '已送达', '无', '123441', '[{\"cost\": 100, \"count\": 2, \"productId\": 1}]', 1);
    173. 

  173. INSERT INTO `orders` VALUES (4, 15.00, 20.00, 1, 9, '2024-05-01 17:29:09', '2024-05-01 17:28:58', '已完成', NULL, '1785602302519369728', '[{\"count\": 3, \"productName\": \"菠萝\"}]', 1);
    174. 

  174. INSERT INTO `orders` VALUES (5, 15.00, 20.00, 1, 9, '2024-05-01 17:52:21', '2024-05-01 17:52:10', '待送达', NULL, '1785608140906676224', '[{\"count\": 3, \"productName\": \"菠萝\"}]', 2);
    175. 

  175. INSERT INTO `orders` VALUES (6, 15.00, 20.00, 1, 9, '2024-05-01 17:54:11', '2024-05-01 17:54:00', '待送达', NULL, '1785608603626479616', '[{\"count\": 3, \"productName\": \"菠萝\"}]', 2);
    176. 

  176. INSERT INTO `orders` VALUES (7, 15.00, 20.00, 1, 9, '2024-05-01 17:56:13', '2024-05-01 17:56:01', '待送达', NULL, '1785609111808364544', '[{\"count\": 12, \"productName\": \"芒果\"}]', 2);
    177. 

  177. INSERT INTO `orders` VALUES (8, 15.00, 20.00, 1, 9, '2024-05-01 17:59:22', '2024-05-01 17:59:11', '待送达', NULL, '1785609907618824192', '[{\"count\": 12, \"productName\": \"芒果\"}, {\"count\": 12, \"productName\": \"芒果\"}]', 2);
    178. 

  178. INSERT INTO `orders` VALUES (9, 15.00, 20.00, 1, 9, '2024-05-01 19:51:55', '2024-05-01 19:51:44', '已送达', NULL, '1785638230222807040', '[{\"count\": 12, \"productName\": \"A芒果\"}, {\"count\": 12, \"productName\": \"B芒果\"}]', 1);
    179. 

  179. INSERT INTO `orders` VALUES (10, 15.00, 20.00, 1, 9, '2024-05-01 19:54:07', '2024-05-01 19:53:56', '已送达', '挑大一点的芒果谢谢', '1785638785309581312', '[{\"count\": 12, \"productName\": \"芒果\"}, {\"count\": 12, \"productName\": \"芒果\"}]', 1);
    180. 

  180. INSERT INTO `orders` VALUES (11, 150.00, 200.00, 1, 9, '2024-05-01 21:23:11', '2024-05-01 21:23:00', '已送达', NULL, '1785661197862363136', '[{\"count\": 31, \"productName\": \"草莓\"}, {\"count\": 12, \"productName\": \"桃子\"}]', 1);
    181. 

  181. INSERT INTO `orders` VALUES (12, 15.00, 20.00, 1, 9, '2024-05-01 22:34:13', '2024-05-01 22:34:02', '已送达', '挑大一点的芒果谢谢', '1785679074241925120', '[{\"id\": null, \"count\": 12, \"productName\": \"西瓜\", \"productIcons\": null, \"productState\": null, \"productTypes\": null, \"productTypeIds\": null, \"productBidPrice\": null, \"productSellPrice\": null}, {\"id\": null, \"count\": 12, \"productName\": \"菠萝\", \"productIcons\": null, \"productState\": null, \"productTypes\": null, \"productTypeIds\": null, \"productBidPrice\": null, \"productSellPrice\": null}]', 1);
    182. 

  182. INSERT INTO `orders` VALUES (13, 15.00, 20.00, 1, 9, '2024-05-02 09:46:44', '2024-05-02 09:46:33', '待送达', NULL, '1785848318325805056', '[{\"id\": null, \"count\": 12, \"productName\": \"A芒果\", \"productIcons\": null, \"productState\": null, \"productTypes\": null, \"productTypeIds\": null, \"productBidPrice\": null, \"productSellPrice\": null}, {\"id\": null, \"count\": 12, \"productName\": \"B芒果\", \"productIcons\": null, \"productState\": null, \"productTypes\": null, \"productTypeIds\": null, \"productBidPrice\": null, \"productSellPrice\": null}]', 2);
    183. 

  183. INSERT INTO `orders` VALUES (14, 15.00, 20.00, 1, 9, '2024-05-02 09:51:34', '2024-05-02 09:51:23', '已送达', '挑大一点的芒果谢谢', '1785849536808861696', '[{\"id\": null, \"count\": 12, \"productName\": \"西瓜\", \"productIcons\": null, \"productState\": null, \"productTypes\": null, \"productTypeIds\": null, \"productBidPrice\": null, \"productSellPrice\": null}, {\"id\": null, \"count\": 12, \"productName\": \"菠萝\", \"productIcons\": null, \"productState\": null, \"productTypes\": null, \"productTypeIds\": null, \"productBidPrice\": null, \"productSellPrice\": null}]', 1);
    184. 

  184. INSERT INTO `orders` VALUES (15, 15.00, 2000.00, 1, 9, '2024-05-02 11:25:11', '2024-05-02 11:25:00', '已送达', NULL, '1785873096671621120', '[{\"id\": null, \"count\": 12, \"productName\": \"西瓜\", \"productIcons\": null, \"productState\": null, \"productTypes\": null, \"productTypeIds\": null, \"productBidPrice\": null, \"productSellPrice\": null}, {\"id\": null, \"count\": 12, \"productName\": \"菠萝\", \"productIcons\": null, \"productState\": null, \"productTypes\": null, \"productTypeIds\": null, \"productBidPrice\": null, \"productSellPrice\": null}]', 1);
    185. 

  185. INSERT INTO `orders` VALUES (16, 15.00, 20.00, 1, 9, '2024-05-02 13:22:59', '2024-05-02 13:22:48', '已送达', NULL, '1785902741223763968', '[{\"id\": null, \"count\": 12, \"productName\": \"芒果\", \"productIcons\": null, \"productState\": null, \"productTypes\": null, \"productTypeIds\": null, \"productBidPrice\": null, \"productSellPrice\": null}, {\"id\": null, \"count\": 12, \"productName\": \"芒果\", \"productIcons\": null, \"productState\": null, \"productTypes\": null, \"productTypeIds\": null, \"productBidPrice\": null, \"productSellPrice\": null}]', 1);
    186. 

  186. INSERT INTO `orders` VALUES (17, 15.00, 20.00, 1, 9, '2024-05-02 14:01:32', '2024-05-02 14:01:21', '已送达', '送个草莓，备注了哈', '1785912440925057024', '[{\"id\": null, \"count\": 12, \"productName\": \"芒果\", \"productIcons\": null, \"productState\": null, \"productTypes\": null, \"productTypeIds\": null, \"productBidPrice\": null, \"productSellPrice\": null}, {\"id\": null, \"count\": 12, \"productName\": \"芒果\", \"productIcons\": null, \"productState\": null, \"productTypes\": null, \"productTypeIds\": null, \"productBidPrice\": null, \"productSellPrice\": null}]', 1);
    187. 

  187. INSERT INTO `orders` VALUES (18, 15.00, 20.00, 2, 9, '2024-05-04 18:13:37', '2024-05-04 18:13:26', '已送达', '挑大一点的芒果谢谢', '1786700658255654912', '[{\"id\": null, \"count\": 12, \"storeId\": null, \"productName\": \"J芒果\", \"productIcons\": null, \"productState\": null, \"productTypes\": null, \"productTypeIds\": null, \"productBidPrice\": null, \"productSellPrice\": null}, {\"id\": null, \"count\": 12, \"storeId\": null, \"productName\": \"F芒果\", \"productIcons\": null, \"productState\": null, \"productTypes\": null, \"productTypeIds\": null, \"productBidPrice\": null, \"productSellPrice\": null}]', 1);
    188. 

  188. INSERT INTO `orders` VALUES (19, 15.00, 20.00, 2, 9, '2024-05-04 18:20:15', '2024-05-04 18:20:04', '已送达', '挑大一点的果谢谢', '1786702324937904128', '[{\"id\": null, \"count\": 12, \"storeId\": null, \"productName\": \"J芒果\", \"productIcons\": null, \"productState\": null, \"productTypes\": null, \"productTypeIds\": null, \"productBidPrice\": null, \"productSellPrice\": null}, {\"id\": null, \"count\": 12, \"storeId\": null, \"productName\": \"F芒果\", \"productIcons\": null, \"productState\": null, \"productTypes\": null, \"productTypeIds\": null, \"productBidPrice\": null, \"productSellPrice\": null}]', 1);
    189. 

  189. INSERT INTO `orders` VALUES (20, 15.00, 20.00, 2, 9, '2024-05-04 18:21:27', '2024-05-04 18:21:16', '已送达', '挑大一点的果谢谢', '1786702629847027712', '[{\"id\": null, \"count\": 12, \"storeId\": null, \"productName\": \"J芒果\", \"productIcons\": null, \"productState\": null, \"productTypes\": null, \"productTypeIds\": null, \"productBidPrice\": null, \"productSellPrice\": null}, {\"id\": null, \"count\": 12, \"storeId\": null, \"productName\": \"F芒果\", \"productIcons\": null, \"productState\": null, \"productTypes\": null, \"productTypeIds\": null, \"productBidPrice\": null, \"productSellPrice\": null}]', 1);
    190. 

  190. INSERT INTO `orders` VALUES (21, 15.00, 20.00, 1, 9, '2024-05-04 18:24:40', '2024-05-04 18:24:29', '已送达', '挑大一点的果谢谢', '1786703438068342784', '[{\"id\": null, \"count\": 12, \"storeId\": null, \"productName\": \"樱桃\", \"productIcons\": null, \"productState\": null, \"productTypes\": null, \"productTypeIds\": null, \"productBidPrice\": null, \"productSellPrice\": null}, {\"id\": null, \"count\": 12, \"storeId\": null, \"productName\": \"F芒果\", \"productIcons\": null, \"productState\": null, \"productTypes\": null, \"productTypeIds\": null, \"productBidPrice\": null, \"productSellPrice\": null}]', 1);
    191. 

  191. INSERT INTO `orders` VALUES (22, 15.00, 20.00, 1, 9, '2024-05-04 18:28:54', '2024-05-04 18:28:43', '已送达', '挑大一点的果谢谢', '1786704500854726656', '[{\"id\": null, \"count\": 12, \"storeId\": null, \"productName\": \"樱桃\", \"productIcons\": null, \"productState\": null, \"productTypes\": null, \"productTypeIds\": null, \"productBidPrice\": null, \"productSellPrice\": null}, {\"id\": null, \"count\": 12, \"storeId\": null, \"productName\": \"F芒果\", \"productIcons\": null, \"productState\": null, \"productTypes\": null, \"productTypeIds\": null, \"productBidPrice\": null, \"productSellPrice\": null}]', 1);
    192. 

  192. INSERT INTO `orders` VALUES (39, 77.00, 81.50, 1, 9, '2024-05-04 23:12:45', '2024-05-04 23:12:34', '已送达', '无', '1786775937246347264', '[{\"id\": 38, \"count\": 2, \"amount\": 44, \"storeId\": null, \"productName\": \"test\", \"productIcons\": null, \"productState\": null, \"productTypes\": null, \"productTypeIds\": null, \"productBidPrice\": null, \"productSellPrice\": null}, {\"id\": 36, \"count\": 3, \"amount\": 33, \"storeId\": null, \"productName\": \"AAA\", \"productIcons\": null, \"productState\": null, \"productTypes\": null, \"productTypeIds\": null, \"productBidPrice\": null, \"productSellPrice\": null}]', 1);
    193. 

  193. INSERT INTO `orders` VALUES (41, 18.00, 22.50, 1, 9, '2024-05-05 01:42:00', '2024-05-05 01:41:49', '已送达', '无', '1786813497158934528', '[{\"id\": null, \"count\": 1, \"amount\": 18, \"storeId\": null, \"productName\": \"山竹\", \"productIcons\": \"http://localhost:2441/files/1714785980375-Screenshot_2024-05-02-21-05-05-49_b84839d832046b3.jpg\", \"productState\": null, \"productTypes\": null, \"productTypeIds\": null, \"productBidPrice\": null, \"productSellPrice\": null}]', 1);
    194. 

  194. INSERT INTO `orders` VALUES (42, 10.00, 14.50, 1, 9, '2024-05-05 01:48:39', '2024-05-05 01:48:28', '已送达', '无', '1786815170015203328', '[{\"id\": null, \"count\": 10, \"amount\": 10, \"storeId\": null, \"productName\": \"过期西红柿\", \"productIcons\": \"http://localhost:2441/files/1714813550094-Screenshot_2024-05-02-21-07-42-10_b84839d832046b3.jpg\", \"productState\": null, \"productTypes\": null, \"productTypeIds\": null, \"productBidPrice\": null, \"productSellPrice\": null}]', 1);
    195. 

  195. INSERT INTO `orders` VALUES (43, 93.00, 97.50, 1, 9, '2024-05-05 04:04:08', '2024-05-05 04:03:57', '已送达', '无', '1786849265512476672', '[{\"id\": null, \"count\": 5, \"amount\": 5, \"storeId\": null, \"productName\": \"过期西红柿\", \"productIcons\": \"http://localhost:2441/files/1714813550094-Screenshot_2024-05-02-21-07-42-10_b84839d832046b3.jpg\", \"productState\": null, \"productTypes\": null, \"productTypeIds\": null, \"productBidPrice\": null, \"productSellPrice\": null}, {\"id\": null, \"count\": 6, \"amount\": 72, \"storeId\": null, \"productName\": \"蓝莓\", \"productIcons\": \"http://localhost:2441/files/1714813349319-Screenshot_2024-05-02-21-06-24-38_b84839d832046b3.jpg\", \"productState\": null, \"productTypes\": null, \"productTypeIds\": null, \"productBidPrice\": null, \"productSellPrice\": null}, {\"id\": null, \"count\": 2, \"amount\": 16, \"storeId\": null, \"productName\": \"香蕉\", \"productIcons\": \"http://localhost:2441/files/1714786280828-Screenshot_2024-05-02-21-09-00-63_b84839d832046b3.jpg\", \"productState\": null, \"productTypes\": null, \"productTypeIds\": null, \"productBidPrice\": null, \"productSellPrice\": null}]', 1);
    196. 

  196. INSERT INTO `orders` VALUES (44, 45.00, 49.50, 1, 9, '2024-05-05 10:13:45', '2024-05-05 10:13:34', '已送达', '无', '1786942281925296128', '[{\"id\": null, \"count\": 9, \"amount\": 9, \"storeId\": null, \"productName\": \"过期西红柿\", \"productIcons\": \"http://localhost:2441/files/1714813550094-Screenshot_2024-05-02-21-07-42-10_b84839d832046b3.jpg\", \"productState\": null, \"productTypes\": null, \"productTypeIds\": null, \"productBidPrice\": null, \"productSellPrice\": null}, {\"id\": null, \"count\": 3, \"amount\": 36, \"storeId\": null, \"productName\": \"蓝莓\", \"productIcons\": \"http://localhost:2441/files/1714813349319-Screenshot_2024-05-02-21-06-24-38_b84839d832046b3.jpg\", \"productState\": null, \"productTypes\": null, \"productTypeIds\": null, \"productBidPrice\": null, \"productSellPrice\": null}]', 1);
    197. 

  197. INSERT INTO `orders` VALUES (45, 13.00, 17.50, 1, 9, '2024-05-05 10:25:23', '2024-05-05 10:25:12', '已送达', '无', '1786945209717260288', '[{\"id\": null, \"count\": 1, \"amount\": 1, \"storeId\": null, \"productName\": \"过期西红柿\", \"productIcons\": \"http://localhost:2441/files/1714813550094-Screenshot_2024-05-02-21-07-42-10_b84839d832046b3.jpg\", \"productState\": null, \"productTypes\": null, \"productTypeIds\": null, \"productBidPrice\": null, \"productSellPrice\": null}, {\"id\": null, \"count\": 1, \"amount\": 12, \"storeId\": null, \"productName\": \"蓝莓\", \"productIcons\": \"http://localhost:2441/files/1714813349319-Screenshot_2024-05-02-21-06-24-38_b84839d832046b3.jpg\", \"productState\": null, \"productTypes\": null, \"productTypeIds\": null, \"productBidPrice\": null, \"productSellPrice\": null}]', 1);
    198. 

  198. INSERT INTO `orders` VALUES (46, 2.00, 6.50, 1, 9, '2024-05-05 11:24:48', '2024-05-05 11:24:37', '已送达', '无', '1786960164466229248', '[{\"id\": null, \"count\": 2, \"amount\": 2, \"storeId\": null, \"productName\": \"蛋白质\", \"productIcons\": \"http://localhost:2441/files/1714875999629-七星瓢虫.jpg\", \"productState\": null, \"productTypes\": null, \"productTypeIds\": null, \"productBidPrice\": null, \"productSellPrice\": null}]', 1);
    199. 

  199. INSERT INTO `orders` VALUES (47, 3.00, 7.50, 1, 9, '2024-05-05 11:39:05', '2024-05-05 11:38:54', '已送达', '无', '1786963756455591936', '[{\"id\": null, \"count\": 3, \"amount\": 3, \"storeId\": null, \"productName\": \"蛋白质\", \"productIcons\": \"http://localhost:2441/files/1714875999629-七星瓢虫.jpg\", \"productState\": null, \"productTypes\": null, \"productTypeIds\": null, \"productBidPrice\": null, \"productSellPrice\": null}]', 1);
    200. 

  200. INSERT INTO `orders` VALUES (48, 217.00, 221.50, 1, 9, '2024-05-05 13:52:21', '2024-05-05 13:52:10', '已送达', '无', '1786997294240382976', '[{\"id\": null, \"count\": 1, \"amount\": 8, \"storeId\": null, \"productName\": \"香蕉\", \"productIcons\": \"http://localhost:2441/files/1714786280828-Screenshot_2024-05-02-21-09-00-63_b84839d832046b3.jpg\", \"productState\": null, \"productTypes\": null, \"productTypeIds\": null, \"productBidPrice\": null, \"productSellPrice\": null}, {\"id\": null, \"count\": 1, \"amount\": 12, \"storeId\": null, \"productName\": \"蓝莓\", \"productIcons\": \"http://localhost:2441/files/1714813349319-Screenshot_2024-05-02-21-06-24-38_b84839d832046b3.jpg\", \"productState\": null, \"productTypes\": null, \"productTypeIds\": null, \"productBidPrice\": null, \"productSellPrice\": null}, {\"id\": null, \"count\": 1, \"amount\": 1, \"storeId\": null, \"productName\": \"过期西红柿\", \"productIcons\": \"http://localhost:2441/files/1714813550094-Screenshot_2024-05-02-21-07-42-10_b84839d832046b3.jpg\", \"productState\": null, \"productTypes\": null, \"productTypeIds\": null, \"productBidPrice\": null, \"productSellPrice\": null}, {\"id\": null, \"count\": 4, \"amount\": 196, \"storeId\": null, \"productName\": \"榴莲\", \"productIcons\": \"http://localhost:2441/files/1714786024110-Screenshot_2024-05-02-21-07-06-36_b84839d832046b3.jpg\", \"productState\": null, \"productTypes\": null, \"productTypeIds\": null, \"productBidPrice\": null, \"productSellPrice\": null}]', 1);
    201. 

  201. INSERT INTO `orders` VALUES (49, 2.00, 6.50, 1, 9, '2024-05-05 13:58:20', '2024-05-05 13:58:09', '已送达', '无', '1786998799987130368', '[{\"id\": null, \"count\": 2, \"amount\": 2, \"storeId\": null, \"productName\": \"过期西红柿\", \"productIcons\": \"http://localhost:2441/files/1714813550094-Screenshot_2024-05-02-21-07-42-10_b84839d832046b3.jpg\", \"productState\": null, \"productTypes\": null, \"productTypeIds\": null, \"productBidPrice\": null, \"productSellPrice\": null}]', 1);
    202. 

  202. INSERT INTO `orders` VALUES (50, 36.00, 40.50, 1, 9, '2024-05-05 13:59:19', '2024-05-05 13:59:08', '已送达', '无', '1786999047887273984', '[{\"id\": null, \"count\": 2, \"amount\": 36, \"storeId\": null, \"productName\": \"波罗蜜\", \"productIcons\": \"http://localhost:2441/files/1714809345969-Screenshot_2024-05-02-21-15-29-99_860bc48c3aad114.jpg\", \"productState\": null, \"productTypes\": null, \"productTypeIds\": null, \"productBidPrice\": null, \"productSellPrice\": null}]', 1);
    203. 

  203. INSERT INTO `orders` VALUES (51, 5.00, 9.50, 1, 9, '2024-05-05 14:06:06', '2024-05-05 14:05:55', '已送达', '无', '1787000753161256960', '[{\"id\": null, \"count\": 3, \"amount\": 3, \"storeId\": null, \"productName\": \"蛋白质\", \"productIcons\": \"http://localhost:2441/files/1714875999629-七星瓢虫.jpg\", \"productState\": null, \"productTypes\": null, \"productTypeIds\": null, \"productBidPrice\": null, \"productSellPrice\": null}, {\"id\": null, \"count\": 2, \"amount\": 2, \"storeId\": null, \"productName\": \"过期西红柿\", \"productIcons\": \"http://localhost:2441/files/1714813550094-Screenshot_2024-05-02-21-07-42-10_b84839d832046b3.jpg\", \"productState\": null, \"productTypes\": null, \"productTypeIds\": null, \"productBidPrice\": null, \"productSellPrice\": null}]', 1);
    204. 

  204. INSERT INTO `orders` VALUES (52, 2.00, 6.50, 1, 9, '2024-05-05 21:14:01', '2024-05-05 21:13:50', '已送达', '无', '1787108444185673728', '[{\"id\": null, \"count\": 1, \"amount\": 1, \"storeId\": null, \"productName\": \"蛋白质\", \"productIcons\": \"http://localhost:2441/files/1714875999629-七星瓢虫.jpg\", \"productState\": null, \"productTypes\": null, \"productTypeIds\": null, \"productBidPrice\": null, \"productSellPrice\": null}, {\"id\": null, \"count\": 1, \"amount\": 1, \"storeId\": null, \"productName\": \"过期西红柿\", \"productIcons\": \"http://localhost:2441/files/1714813550094-Screenshot_2024-05-02-21-07-42-10_b84839d832046b3.jpg\", \"productState\": null, \"productTypes\": null, \"productTypeIds\": null, \"productBidPrice\": null, \"productSellPrice\": null}]', 1);
    205. 

  205. INSERT INTO `orders` VALUES (53, 70.00, 74.50, 1, 9, '2024-05-05 21:15:27', '2024-05-05 21:15:16', '已送达', '无', '1787108806024085504', '[{\"id\": null, \"count\": 1, \"amount\": 49, \"storeId\": null, \"productName\": \"榴莲\", \"productIcons\": \"http://localhost:2441/files/1714786024110-Screenshot_2024-05-02-21-07-06-36_b84839d832046b3.jpg\", \"productState\": null, \"productTypes\": null, \"productTypeIds\": null, \"productBidPrice\": null, \"productSellPrice\": null}, {\"id\": null, \"count\": 1, \"amount\": 9, \"storeId\": null, \"productName\": \"小芒\", \"productIcons\": \"http://localhost:2441/files/1714786075887-Screenshot_2024-05-02-21-10-15-83_b84839d832046b3.jpg\", \"productState\": null, \"productTypes\": null, \"productTypeIds\": null, \"productBidPrice\": null, \"productSellPrice\": null}, {\"id\": null, \"count\": 1, \"amount\": 12, \"storeId\": null, \"productName\": \"猕猴桃\", \"productIcons\": \"http://localhost:2441/files/1714786133267-Screenshot_2024-05-02-21-11-12-63_b84839d832046b3.JPG\", \"productState\": null, \"productTypes\": null, \"productTypeIds\": null, \"productBidPrice\": null, \"productSellPrice\": null}]', 1);
    206. 

  206. INSERT INTO `orders` VALUES (54, 583.00, 587.50, 1, 9, '2024-05-05 21:39:00', '2024-05-05 21:38:49', '已送达', '无', '1787114730889531392', '[{\"id\": 40, \"count\": 2, \"amount\": 2, \"storeId\": null, \"productName\": \"蛋白质\", \"productIcons\": \"http://localhost:2441/files/1714875999629-七星瓢虫.jpg\", \"productState\": null, \"productTypes\": null, \"productTypeIds\": null, \"productBidPrice\": null, \"productSellPrice\": null}, {\"id\": 35, \"count\": 2, \"amount\": 2, \"storeId\": null, \"productName\": \"过期西红柿\", \"productIcons\": \"http://localhost:2441/files/1714813550094-Screenshot_2024-05-02-21-07-42-10_b84839d832046b3.jpg\", \"productState\": null, \"productTypes\": null, \"productTypeIds\": null, \"productBidPrice\": null, \"productSellPrice\": null}, {\"id\": 33, \"count\": 2, \"amount\": 36, \"storeId\": null, \"productName\": \"波罗蜜\", \"productIcons\": \"http://localhost:2441/files/1714809345969-Screenshot_2024-05-02-21-15-29-99_860bc48c3aad114.jpg\", \"productState\": null, \"productTypes\": null, \"productTypeIds\": null, \"productBidPrice\": null, \"productSellPrice\": null}, {\"id\": 32, \"count\": 1, \"amount\": 8, \"storeId\": null, \"productName\": \"香蕉\", \"productIcons\": \"http://localhost:2441/files/1714786280828-Screenshot_2024-05-02-21-09-00-63_b84839d832046b3.jpg\", \"productState\": null, \"productTypes\": null, \"productTypeIds\": null, \"productBidPrice\": null, \"productSellPrice\": null}, {\"id\": 34, \"count\": 3, \"amount\": 36, \"storeId\": null, \"productName\": \"蓝莓\", \"productIcons\": \"http://localhost:2441/files/1714813349319-Screenshot_2024-05-02-21-06-24-38_b84839d832046b3.jpg\", \"productState\": null, \"productTypes\": null, \"productTypeIds\": null, \"productBidPrice\": null, \"productSellPrice\": null}, {\"id\": 31, \"count\": 4, \"amount\": 36, \"storeId\": null, \"productName\": \"提子\", \"productIcons\": \"http://localhost:2441/files/1714786205791-Screenshot_2024-05-02-21-16-23-36_860bc48c3aad114.JPG\", \"productState\": null, \"productTypes\": null, \"productTypeIds\": null, \"productBidPrice\": null, \"productSellPrice\": null}, {\"id\": 28, \"count\": 1, \"amount\": 24, \"storeId\": null, \"productName\": \"车厘子-J\", \"productIcons\": \"http://localhost:2441/files/1714786103827-Screenshot_2024-05-02-21-10-26-38_b84839d832046b3.jpg\", \"productState\": null, \"productTypes\": null, \"productTypeIds\": null, \"productBidPrice\": null, \"productSellPrice\": null}, {\"id\": 27, \"count\": 1, \"amount\": 9, \"storeId\": null, \"productName\": \"小芒\", \"productIcons\": \"http://localhost:2441/files/1714786075887-Screenshot_2024-05-02-21-10-15-83_b84839d832046b3.jpg\", \"productState\": null, \"productTypes\": null, \"productTypeIds\": null, \"productBidPrice\": null, \"productSellPrice\": null}, {\"id\": 29, \"count\": 2, \"amount\": 24, \"storeId\": null, \"productName\": \"猕猴桃\", \"productIcons\": \"http://localhost:2441/files/1714786133267-Screenshot_2024-05-02-21-11-12-63_b84839d832046b3.JPG\", \"productState\": null, \"productTypes\": null, \"productTypeIds\": null, \"productBidPrice\": null, \"productSellPrice\": null}, {\"id\": 26, \"count\": 6, \"amount\": 294, \"storeId\": null, \"productName\": \"榴莲\", \"productIcons\": \"http://localhost:2441/files/1714786024110-Screenshot_2024-05-02-21-07-06-36_b84839d832046b3.jpg\", \"productState\": null, \"productTypes\": null, \"productTypeIds\": null, \"productBidPrice\": null, \"productSellPrice\": null}, {\"id\": 25, \"count\": 2, \"amount\": 36, \"storeId\": null, \"productName\": \"山竹\", \"productIcons\": \"http://localhost:2441/files/1714785980375-Screenshot_2024-05-02-21-05-05-49_b84839d832046b3.jpg\", \"productState\": null, \"productTypes\": null, \"productTypeIds\": null, \"productBidPrice\": null, \"productSellPrice\": null}, {\"id\": 24, \"count\": 2, \"amount\": 10, \"storeId\": null, \"productName\": \"小番茄\", \"productIcons\": \"http://localhost:2441/files/1714785914229-Screenshot_2024-05-02-21-04-09-31_b84839d832046b3.jpg\", \"productState\": null, \"productTypes\": null, \"productTypeIds\": null, \"productBidPrice\": null, \"productSellPrice\": null}, {\"id\": 23, \"count\": 2, \"amount\": 16, \"storeId\": null, \"productName\": \"火龙果\", \"productIcons\": \"http://localhost:2441/files/1714785888936-Screenshot_2024-05-02-21-03-10-05_b84839d832046b3.jpg\", \"productState\": null, \"productTypes\": null, \"productTypeIds\": null, \"productBidPrice\": null, \"productSellPrice\": null}, {\"id\": 5, \"count\": 2, \"amount\": 16, \"storeId\": null, \"productName\": \"小西瓜\", \"productIcons\": \"http://localhost:2441/files/1714786379151-b036f756ce66b4ccd87f60688b1b400.png\", \"productState\": null, \"productTypes\": null, \"productTypeIds\": null, \"productBidPrice\": null, \"productSellPrice\": null}, {\"id\": 2, \"count\": 2, \"amount\": 16, \"storeId\": null, \"productName\": \"西瓜\", \"productIcons\": \"http://localhost:2441/files/1714786385863-Screenshot_2024-05-02-21-04-45-17_b84839d832046b3.jpg\", \"productState\": null, \"productTypes\": null, \"productTypeIds\": null, \"productBidPrice\": null, \"productSellPrice\": null}, {\"id\": 1, \"count\": 2, \"amount\": 18, \"storeId\": null, \"productName\": \"雪梨\", \"productIcons\": \"http://localhost:2441/files/1714786417947-Screenshot_2024-05-02-21-14-05-47_860bc48c3aad114.jpg\", \"productState\": null, \"productTypes\": null, \"productTypeIds\": null, \"productBidPrice\": null, \"productSellPrice\": null}]', 1);
    207. 

  207. INSERT INTO `orders` VALUES (55, 2.00, 6.50, 1, 9, '2024-05-05 22:14:47', '2024-05-05 22:14:36', '待送达', '无', '1787123734789345280', '[{\"id\": 40, \"count\": 1, \"amount\": 1, \"storeId\": null, \"productName\": \"蛋白质\", \"productIcons\": \"http://localhost:2441/files/1714875999629-七星瓢虫.jpg\", \"productState\": null, \"productTypes\": null, \"productTypeIds\": null, \"productBidPrice\": null, \"productSellPrice\": null}, {\"id\": 35, \"count\": 1, \"amount\": 1, \"storeId\": null, \"productName\": \"过期西红柿\", \"productIcons\": \"http://localhost:2441/files/1714813550094-Screenshot_2024-05-02-21-07-42-10_b84839d832046b3.jpg\", \"productState\": null, \"productTypes\": null, \"productTypeIds\": null, \"productBidPrice\": null, \"productSellPrice\": null}]', 1);
    208. 

  208. INSERT INTO `orders` VALUES (56, 10.00, 14.50, 1, 9, '2024-05-05 23:19:01', '2024-05-05 23:18:50', '待送达', '无', '1787139900668760064', '[{\"id\": 40, \"count\": 1, \"amount\": 1, \"storeId\": null, \"productName\": \"蛋白质\", \"productIcons\": \"http://localhost:2441/files/1714875999629-七星瓢虫.jpg\", \"productState\": null, \"productTypes\": null, \"productTypeIds\": null, \"productBidPrice\": null, \"productSellPrice\": null}, {\"id\": 35, \"count\": 1, \"amount\": 1, \"storeId\": null, \"productName\": \"过期西红柿\", \"productIcons\": \"http://69b89r4952.yicp.fun//files/1714813550094-Screenshot_2024-05-02-21-07-42-10_b84839d832046b3.jpg\", \"productState\": null, \"productTypes\": null, \"productTypeIds\": null, \"productBidPrice\": null, \"productSellPrice\": null}, {\"id\": 32, \"count\": 1, \"amount\": 8, \"storeId\": null, \"productName\": \"香蕉\", \"productIcons\": \"http://localhost:2441/files/1714786280828-Screenshot_2024-05-02-21-09-00-63_b84839d832046b3.jpg\", \"productState\": null, \"productTypes\": null, \"productTypeIds\": null, \"productBidPrice\": null, \"productSellPrice\": null}]', 1);
    209. 

  209. INSERT INTO `orders` VALUES (57, 68.00, 72.50, 1, 9, '2024-05-05 23:26:30', '2024-05-05 23:26:19', '待送达', '无', '1787141782715879424', '[{\"id\": 46, \"count\": 1, \"amount\": 3, \"storeId\": null, \"productName\": null, \"productIcons\": \"http://localhost:2441/files/1714921712566-tudou.png\", \"productState\": null, \"productTypes\": null, \"productTypeIds\": null, \"productBidPrice\": null, \"productSellPrice\": null}, {\"id\": 45, \"count\": 1, \"amount\": 7, \"storeId\": null, \"productName\": \"黄瓜\", \"productIcons\": \"http://localhost:2441/files/1714921675182-huanggua.png\", \"productState\": null, \"productTypes\": null, \"productTypeIds\": null, \"productBidPrice\": null, \"productSellPrice\": null}, {\"id\": 43, \"count\": 1, \"amount\": 6, \"storeId\": null, \"productName\": \"胡萝卜\", \"productIcons\": \"http://localhost:2441/files/1714921586737-huluobo.png\", \"productState\": null, \"productTypes\": null, \"productTypeIds\": null, \"productBidPrice\": null, \"productSellPrice\": null}, {\"id\": 42, \"count\": 1, \"amount\": 2, \"storeId\": null, \"productName\": \"大蒜\", \"productIcons\": \"http://localhost:2441/files/1714921544128-dasuan.png\", \"productState\": null, \"productTypes\": null, \"productTypeIds\": null, \"productBidPrice\": null, \"productSellPrice\": null}, {\"id\": 44, \"count\": 1, \"amount\": 29, \"storeId\": null, \"productName\": \"香菇\", \"productIcons\": \"http://localhost:2441/files/1714921614437-xianggu.png\", \"productState\": null, \"productTypes\": null, \"productTypeIds\": null, \"productBidPrice\": null, \"productSellPrice\": null}, {\"id\": 35, \"count\": 1, \"amount\": 1, \"storeId\": null, \"productName\": \"过期西红柿\", \"productIcons\": \"http://localhost:2441/files/1714813550094-Screenshot_2024-05-02-21-07-42-10_b84839d832046b3.jpg\", \"productState\": null, \"productTypes\": null, \"productTypeIds\": null, \"productBidPrice\": null, \"productSellPrice\": null}, {\"id\": 34, \"count\": 1, \"amount\": 12, \"storeId\": null, \"productName\": \"蓝莓\", \"productIcons\": \"http://localhost:2441/files/1714813349319-Screenshot_2024-05-02-21-06-24-38_b84839d832046b3.jpg\", \"productState\": null, \"productTypes\": null, \"productTypeIds\": null, \"productBidPrice\": null, \"productSellPrice\": null}, {\"id\": 32, \"count\": 1, \"amount\": 8, \"storeId\": null, \"productName\": \"香蕉\", \"productIcons\": \"http://localhost:2441/files/1714786280828-Screenshot_2024-05-02-21-09-00-63_b84839d832046b3.jpg\", \"productState\": null, \"productTypes\": null, \"productTypeIds\": null, \"productBidPrice\": null, \"productSellPrice\": null}]', 1);
    210. 

  210. INSERT INTO `orders` VALUES (58, 21.00, 25.50, 1, 9, '2024-05-05 23:41:23', '2024-05-05 23:41:12', '待送达', '无', '1787145529126932480', '[{\"id\": 33, \"count\": 1, \"amount\": 18, \"storeId\": null, \"productName\": \"波罗蜜\", \"productIcons\": \"http://localhost:2441/files/1714809345969-Screenshot_2024-05-02-21-15-29-99_860bc48c3aad114.jpg\", \"productState\": null, \"productTypes\": null, \"productTypeIds\": null, \"productBidPrice\": null, \"productSellPrice\": null}, {\"id\": 41, \"count\": 1, \"amount\": 3, \"storeId\": null, \"productName\": \"菠菜\", \"productIcons\": \"http://localhost:2441/files/1714921510640-bocai.png\", \"productState\": null, \"productTypes\": null, \"productTypeIds\": null, \"productBidPrice\": null, \"productSellPrice\": null}]', 1);
    211. 

  211. INSERT INTO `orders` VALUES (59, 26.00, 30.50, 1, 9, '2024-05-05 23:41:57', '2024-05-05 23:41:46', '待送达', '无', '1787145674367291392', '[{\"id\": 33, \"count\": 1, \"amount\": 18, \"storeId\": null, \"productName\": \"波罗蜜\", \"productIcons\": \"http://localhost:2441/files/1714809345969-Screenshot_2024-05-02-21-15-29-99_860bc48c3aad114.jpg\", \"productState\": null, \"productTypes\": null, \"productTypeIds\": null, \"productBidPrice\": null, \"productSellPrice\": null}, {\"id\": 32, \"count\": 1, \"amount\": 8, \"storeId\": null, \"productName\": \"香蕉\", \"productIcons\": \"http://localhost:2441/files/1714786280828-Screenshot_2024-05-02-21-09-00-63_b84839d832046b3.jpg\", \"productState\": null, \"productTypes\": null, \"productTypeIds\": null, \"productBidPrice\": null, \"productSellPrice\": null}]', 1);
    212. 

  212. 

  213. -- ----------------------------
    214. 

  214. -- Table structure for product
    215. 

  215. -- ----------------------------
    216. 

  216. DROP TABLE IF EXISTS `product`;
    217. 

  217. CREATE TABLE `product`  (
    218. 

  218.   `id` int NOT NULL AUTO_INCREMENT COMMENT 'id',
    219. 

  219.   `product_state` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '产品状态',
    220. 

  220.   `product_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '产品名称',
    221. 

  221.   `product_icons` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '产品图标url',
    222. 

  222.   `product_type_ids` json NULL COMMENT '产品类型ids',
    223. 

  223.   `product_bid_price` decimal(10, 2) NULL DEFAULT NULL COMMENT '定价',
    224. 

  224.   `product_sell_price` decimal(10, 2) NULL DEFAULT NULL COMMENT '实付价格',
    225. 

  225.   PRIMARY KEY (`id`) USING BTREE
    226. 

  226. ) ENGINE = InnoDB AUTO_INCREMENT = 47 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
    227. 

  227. 

  228. -- ----------------------------
    229. 

  229. -- Records of product
    230. 

  230. -- ----------------------------
    231. 

  231. INSERT INTO `product` VALUES (1, 'SOLDOUT', '雪梨', 'http://localhost:2441/files/1714786417947-Screenshot_2024-05-02-21-14-05-47_860bc48c3aad114.jpg', '[1, 3, 4]', 25.00, 9.00);
    232. 

  232. INSERT INTO `product` VALUES (2, 'SALE', '西瓜', 'http://localhost:2441/files/1714786385863-Screenshot_2024-05-02-21-04-45-17_b84839d832046b3.jpg', '[1, 3]', 12.00, 8.00);
    233. 

  233. INSERT INTO `product` VALUES (5, 'SALE', '小西瓜', 'http://localhost:2441/files/1714786379151-b036f756ce66b4ccd87f60688b1b400.png', '[1, 3]', 10.00, 8.00);
    234. 

  234. INSERT INTO `product` VALUES (23, 'SALE', '火龙果', 'http://localhost:2441/files/1714785888936-Screenshot_2024-05-02-21-03-10-05_b84839d832046b3.jpg', '[1, 3]', 10.00, 8.00);
    235. 

  235. INSERT INTO `product` VALUES (24, 'SALE', '小番茄', 'http://localhost:2441/files/1714785914229-Screenshot_2024-05-02-21-04-09-31_b84839d832046b3.jpg', '[3, 4]', 5.00, 5.00);
    236. 

  236. INSERT INTO `product` VALUES (25, 'SALE', '山竹', 'http://localhost:2441/files/1714785980375-Screenshot_2024-05-02-21-05-05-49_b84839d832046b3.jpg', '[1, 3]', 20.00, 18.00);
    237. 

  237. INSERT INTO `product` VALUES (26, 'SOLDOUT', '榴莲', 'http://localhost:2441/files/1714786024110-Screenshot_2024-05-02-21-07-06-36_b84839d832046b3.jpg', '[3, 4]', 59.00, 49.00);
    238. 

  238. INSERT INTO `product` VALUES (27, 'SOLDOUT', '小芒', 'http://localhost:2441/files/1714786075887-Screenshot_2024-05-02-21-10-15-83_b84839d832046b3.jpg', '[1, 3]', 9.00, 9.00);
    239. 

  239. INSERT INTO `product` VALUES (28, 'SALE', '车厘子-J', 'http://localhost:2441/files/1714786103827-Screenshot_2024-05-02-21-10-26-38_b84839d832046b3.jpg', '[1, 3]', 25.00, 24.00);
    240. 

  240. INSERT INTO `product` VALUES (29, 'SALE', '猕猴桃', 'http://localhost:2441/files/1714786133267-Screenshot_2024-05-02-21-11-12-63_b84839d832046b3.JPG', '[1, 3]', 14.00, 12.00);
    241. 

  241. INSERT INTO `product` VALUES (31, 'SALE', '提子', 'http://localhost:2441/files/1714786205791-Screenshot_2024-05-02-21-16-23-36_860bc48c3aad114.JPG', '[1, 3]', 10.00, 9.00);
    242. 

  242. INSERT INTO `product` VALUES (32, 'SALE', '香蕉', 'http://localhost:2441/files/1714786280828-Screenshot_2024-05-02-21-09-00-63_b84839d832046b3.jpg', '[1, 3]', 9.00, 8.00);
    243. 

  243. INSERT INTO `product` VALUES (33, 'SALE', '波罗蜜', 'http://localhost:2441/files/1714809345969-Screenshot_2024-05-02-21-15-29-99_860bc48c3aad114.jpg', '[1, 6]', 20.00, 18.00);
    244. 

  244. INSERT INTO `product` VALUES (34, 'SALE', '蓝莓', 'http://localhost:2441/files/1714813349319-Screenshot_2024-05-02-21-06-24-38_b84839d832046b3.jpg', '[5]', 15.00, 12.00);
    245. 

  245. INSERT INTO `product` VALUES (35, 'SALE', '过期西红柿', 'http://localhost:2441/files/1714813550094-Screenshot_2024-05-02-21-07-42-10_b84839d832046b3.jpg', '[6]', 12.00, 1.00);
    246. 

  246. INSERT INTO `product` VALUES (40, 'SALE', '蛋白质', 'http://localhost:2441/files/1714875999629-七星瓢虫.jpg', '[3]', 1.00, 1.00);
    247. 

  247. INSERT INTO `product` VALUES (41, 'SALE', '菠菜', 'http://localhost:2441/files/1714921510640-bocai.png', '[2, 5]', 5.00, 3.00);
    248. 

  248. INSERT INTO `product` VALUES (42, 'SALE', '大蒜', 'http://localhost:2441/files/1714921544128-dasuan.png', '[2, 4]', 4.00, 2.00);
    249. 

  249. INSERT INTO `product` VALUES (43, 'SALE', '胡萝卜', 'http://localhost:2441/files/1714921586737-huluobo.png', '[6, 2]', 12.00, 6.00);
    250. 

  250. INSERT INTO `product` VALUES (44, 'SALE', '香菇', 'http://localhost:2441/files/1714921614437-xianggu.png', '[6]', 35.00, 29.00);
    251. 

  251. INSERT INTO `product` VALUES (45, 'SOLDOUT', '黄瓜', 'http://localhost:2441/files/1714921675182-huanggua.png', '[2, 1]', 8.00, 7.00);
    252. 

  252. INSERT INTO `product` VALUES (46, 'SALE', '土豆', 'http://localhost:2441/files/1714921712566-tudou.png', '[3]', 4.00, 3.00);
    253. 

  253. 

  254. -- ----------------------------
    255. 

  255. -- Table structure for product_type
    256. 

  256. -- ----------------------------
    257. 

  257. DROP TABLE IF EXISTS `product_type`;
    258. 

  258. CREATE TABLE `product_type`  (
    259. 

  259.   `id` int NOT NULL AUTO_INCREMENT COMMENT 'id',
    260. 

  260.   `product_type_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '产品类型名称',
    261. 

  261.   PRIMARY KEY (`id`) USING BTREE
    262. 

  262. ) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
    263. 

  263. 

  264. -- ----------------------------
    265. 

  265. -- Records of product_type
    266. 

  266. -- ----------------------------
    267. 

  267. INSERT INTO `product_type` VALUES (1, '水果');
    268. 

  268. INSERT INTO `product_type` VALUES (2, '蔬菜');
    269. 

  269. INSERT INTO `product_type` VALUES (3, '活动每日促销好礼');
    270. 

  270. INSERT INTO `product_type` VALUES (4, '每周限购特价');
    271. 

  271. INSERT INTO `product_type` VALUES (5, '大棚蔬菜');
    272. 

  272. INSERT INTO `product_type` VALUES (6, '优质农产品');
    273. 

  273. 

  274. -- ----------------------------
    275. 

  275. -- Table structure for sale_statement
    276. 

  276. -- ----------------------------
    277. 

  277. DROP TABLE IF EXISTS `sale_statement`;
    278. 

  278. CREATE TABLE `sale_statement`  (
    279. 

  279.   `id` int NOT NULL AUTO_INCREMENT COMMENT 'id',
    280. 

  280.   `shop_id` int NOT NULL COMMENT '店铺id',
    281. 

  281.   `count` int NULL DEFAULT NULL COMMENT '商品数量',
    282. 

  282.   `time_over` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '完成时间',
    283. 

  283.   `product_id` int NULL DEFAULT NULL COMMENT '商品id',
    284. 

  284.   `amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '金额',
    285. 

  285.   PRIMARY KEY (`id`, `shop_id`) USING BTREE
    286. 

  286. ) ENGINE = InnoDB AUTO_INCREMENT = 64 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '销量表' ROW_FORMAT = Dynamic;
    287. 

  287. 

  288. -- ----------------------------
    289. 

  289. -- Records of sale_statement
    290. 

  290. -- ----------------------------
    291. 

  291. INSERT INTO `sale_statement` VALUES (1, 1, 10, '2024-01-30', 1, 150.00);
    292. 

  292. INSERT INTO `sale_statement` VALUES (2, 1, 5, '2024-02-28', 2, 30.00);
    293. 

  293. INSERT INTO `sale_statement` VALUES (3, 1, 12, '2024-03-02', 1, 200.00);
    294. 

  294. INSERT INTO `sale_statement` VALUES (4, 1, 10, '2024-04-30', 2, 150.00);
    295. 

  295. INSERT INTO `sale_statement` VALUES (5, 1, 10, '2024-05-30', 2, 150.00);
    296. 

  296. INSERT INTO `sale_statement` VALUES (6, 1, 10, '2024-02-30', 2, 450.00);
    297. 

  297. INSERT INTO `sale_statement` VALUES (7, 1, 10, '2024-05-30', 2, 900.00);
    298. 

  298. INSERT INTO `sale_statement` VALUES (8, 1, 10, '2024-08-30', 2, 500.00);
    299. 

  299. INSERT INTO `sale_statement` VALUES (9, 1, 10, '2024-04-30', 1, 500.00);
    300. 

  300. INSERT INTO `sale_statement` VALUES (10, 1, 1, '2024-04-05 01:16:56', 23, 11.00);
    301. 

  301. INSERT INTO `sale_statement` VALUES (11, 1, 1, '2024-04-05 01:16:56', 24, 22.00);
    302. 

  302. INSERT INTO `sale_statement` VALUES (12, 1, 1, '2024-04-05 01:16:56', 25, 11.00);
    303. 

  303. INSERT INTO `sale_statement` VALUES (13, 1, 2, '2024-04-05 01:16:56', 26, 44.00);
    304. 

  304. INSERT INTO `sale_statement` VALUES (14, 1, 3, '2024-04-05 01:16:56', 27, 33.00);
    305. 

  305. INSERT INTO `sale_statement` VALUES (15, 1, 12, '2024-04-05 01:16:56', 31, 150.00);
    306. 

  306. INSERT INTO `sale_statement` VALUES (16, 1, 12, '2024-04-05 01:16:56', 32, 150.00);
    307. 

  307. INSERT INTO `sale_statement` VALUES (17, 1, 12, '2024-04-05 01:16:56', 33, 450.00);
    308. 

  308. INSERT INTO `sale_statement` VALUES (18, 1, 12, '2024-04-05 01:16:56', 34, 900.00);
    309. 

  309. INSERT INTO `sale_statement` VALUES (19, 1, 12, '2024-04-05 01:16:56', 1, 500.00);
    310. 

  310. INSERT INTO `sale_statement` VALUES (21, 1, 1, '2024-05-05 01:53:29', 1, 18.00);
    311. 

  311. INSERT INTO `sale_statement` VALUES (22, 1, 10, '2024-05-05 01:55:57', 1, 18.00);
    312. 

  312. INSERT INTO `sale_statement` VALUES (23, 1, 9, '2024-05-05 10:18:22', NULL, 9.00);
    313. 

  313. INSERT INTO `sale_statement` VALUES (24, 1, 3, '2024-05-05 10:18:22', NULL, 36.00);
    314. 

  314. INSERT INTO `sale_statement` VALUES (25, 1, 1, '2024-05-05 10:25:30', NULL, 1.00);
    315. 

  315. INSERT INTO `sale_statement` VALUES (26, 1, 1, '2024-05-05 10:25:30', NULL, 12.00);
    316. 

  316. INSERT INTO `sale_statement` VALUES (27, 1, 5, '2024-05-05 21:20:55', NULL, 5.00);
    317. 

  317. INSERT INTO `sale_statement` VALUES (28, 1, 6, '2024-05-05 21:20:55', NULL, 72.00);
    318. 

  318. INSERT INTO `sale_statement` VALUES (29, 1, 2, '2024-05-05 21:20:55', NULL, 16.00);
    319. 

  319. INSERT INTO `sale_statement` VALUES (30, 1, 1, '2024-05-05 21:23:14', NULL, 49.00);
    320. 

  320. INSERT INTO `sale_statement` VALUES (31, 1, 1, '2024-05-05 21:23:14', NULL, 9.00);
    321. 

  321. INSERT INTO `sale_statement` VALUES (32, 1, 1, '2024-05-05 21:23:14', NULL, 12.00);
    322. 

  322. INSERT INTO `sale_statement` VALUES (33, 1, 1, '2024-05-05 21:23:27', NULL, 1.00);
    323. 

  323. INSERT INTO `sale_statement` VALUES (34, 1, 1, '2024-05-05 21:23:27', NULL, 1.00);
    324. 

  324. INSERT INTO `sale_statement` VALUES (35, 1, 2, '2024-05-05 21:32:50', NULL, 2.00);
    325. 

  325. INSERT INTO `sale_statement` VALUES (36, 1, 3, '2024-05-05 21:33:14', NULL, 3.00);
    326. 

  326. INSERT INTO `sale_statement` VALUES (37, 1, 2, '2024-05-05 21:33:14', NULL, 2.00);
    327. 

  327. INSERT INTO `sale_statement` VALUES (38, 1, 2, '2024-05-05 21:33:17', NULL, 36.00);
    328. 

  328. INSERT INTO `sale_statement` VALUES (39, 1, 2, '2024-05-05 21:33:18', NULL, 2.00);
    329. 

  329. INSERT INTO `sale_statement` VALUES (40, 1, 2, '2024-05-05 21:33:18', NULL, 2.00);
    330. 

  330. INSERT INTO `sale_statement` VALUES (41, 1, 1, '2024-05-05 21:33:18', NULL, 8.00);
    331. 

  331. INSERT INTO `sale_statement` VALUES (42, 1, 3, '2024-05-05 21:33:18', NULL, 3.00);
    332. 

  332. INSERT INTO `sale_statement` VALUES (43, 1, 1, '2024-05-05 21:33:19', NULL, 12.00);
    333. 

  333. INSERT INTO `sale_statement` VALUES (44, 1, 1, '2024-05-05 21:33:19', NULL, 1.00);
    334. 

  334. INSERT INTO `sale_statement` VALUES (45, 1, 3, '2024-05-05 21:33:19', NULL, 3.00);
    335. 

  335. INSERT INTO `sale_statement` VALUES (46, 1, 4, '2024-05-05 21:33:19', NULL, 196.00);
    336. 

  336. INSERT INTO `sale_statement` VALUES (47, 1, 2, '2024-05-05 21:33:19', NULL, 2.00);
    337. 

  337. INSERT INTO `sale_statement` VALUES (48, 1, 2, '2024-05-05 21:39:38', 40, 2.00);
    338. 

  338. INSERT INTO `sale_statement` VALUES (49, 1, 2, '2024-05-05 21:39:38', 35, 2.00);
    339. 

  339. INSERT INTO `sale_statement` VALUES (50, 1, 2, '2024-05-05 21:39:38', 33, 36.00);
    340. 

  340. INSERT INTO `sale_statement` VALUES (51, 1, 1, '2024-05-05 21:39:38', 32, 8.00);
    341. 

  341. INSERT INTO `sale_statement` VALUES (52, 1, 3, '2024-05-05 21:39:38', 34, 36.00);
    342. 

  342. INSERT INTO `sale_statement` VALUES (53, 1, 4, '2024-05-05 21:39:38', 31, 36.00);
    343. 

  343. INSERT INTO `sale_statement` VALUES (54, 1, 1, '2024-05-05 21:39:38', 28, 24.00);
    344. 

  344. INSERT INTO `sale_statement` VALUES (55, 1, 1, '2024-05-05 21:39:38', 27, 9.00);
    345. 

  345. INSERT INTO `sale_statement` VALUES (56, 1, 2, '2024-05-05 21:39:38', 29, 24.00);
    346. 

  346. INSERT INTO `sale_statement` VALUES (57, 1, 6, '2024-05-05 21:39:38', 26, 294.00);
    347. 

  347. INSERT INTO `sale_statement` VALUES (58, 1, 2, '2024-05-05 21:39:38', 25, 36.00);
    348. 

  348. INSERT INTO `sale_statement` VALUES (59, 1, 2, '2024-05-05 21:39:38', 24, 10.00);
    349. 

  349. INSERT INTO `sale_statement` VALUES (60, 1, 2, '2024-05-05 21:39:38', 23, 16.00);
    350. 

  350. INSERT INTO `sale_statement` VALUES (61, 1, 2, '2024-05-05 21:39:38', 5, 16.00);
    351. 

  351. INSERT INTO `sale_statement` VALUES (62, 1, 2, '2024-05-05 21:39:38', 2, 16.00);
    352. 

  352. INSERT INTO `sale_statement` VALUES (63, 1, 2, '2024-05-05 21:39:38', 1, 18.00);
    353. 

  353. 

  354. -- ----------------------------
    355. 

  355. -- Table structure for store
    356. 

  356. -- ----------------------------
    357. 

  357. DROP TABLE IF EXISTS `store`;
    358. 

  358. CREATE TABLE `store`  (
    359. 

  359.   `id` int NOT NULL AUTO_INCREMENT COMMENT 'id',
    360. 

  360.   `owner_id` int NULL DEFAULT NULL COMMENT '店铺主id',
    361. 

  361.   `products_ids` json NULL COMMENT '产品列表ids',
    362. 

  362.   `address_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '地址列表id',
    363. 

  363.   `product_type_ids` json NULL COMMENT '产品类型ids',
    364. 

  364.   `store_pic_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '店铺展示图片',
    365. 

  365.   `store_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '店铺名称',
    366. 

  366.   PRIMARY KEY (`id`) USING BTREE,
    367. 

  367.   INDEX `owner_id`(`owner_id` ASC) USING BTREE,
    368. 

  368.   CONSTRAINT `store_ibfk_1` FOREIGN KEY (`owner_id`) REFERENCES `adminstore` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
    369. 

  369. ) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
    370. 

  370. 

  371. -- ----------------------------
    372. 

  372. -- Records of store
    373. 

  373. -- ----------------------------
    374. 

  374. INSERT INTO `store` VALUES (1, 1, '[1, 2, 5, 6, 7, 8, 14, 15, 16, 17, 18, 19, 20, 21, 23, 24, 25, 26, 27, 28, 29, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46]', '9', '[1, 2, 3, 4, 5, 6]', 'http://localhost:2441/files/1714889318659-scenes.png', '淮铺水果');
    375. 

  375. INSERT INTO `store` VALUES (2, 1, '[1, 2, 5, 6, 7, 8, 14, 15, 16, 17, 18, 19, 20, 21, 23, 24, 25, 26, 27, 28, 29, 31, 32, 33, 34, 35, 36]', '10', '[1, 2, 3]', 'http://localhost:2441/files/1714889474353-head2.jpg', '淮铺蔬菜');
    376. 

  376. 

  377. -- ----------------------------
    378. 

  378. -- Table structure for user
    379. 

  379. -- ----------------------------
    380. 

  380. DROP TABLE IF EXISTS `user`;
    381. 

  381. CREATE TABLE `user`  (
    382. 

  382.   `id` int NOT NULL AUTO_INCREMENT COMMENT '用户id',
    383. 

  383.   `username` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '用户名',
    384. 

  384.   `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '密码',
    385. 

  385.   `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '用户昵称',
    386. 

  386.   `avatar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '头像网址',
    387. 

  387.   `role` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '用户类型',
    388. 

  388.   `sex` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '性别',
    389. 

  389.   `phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '手机号',
    390. 

  390.   `account` decimal(10, 2) NULL DEFAULT NULL COMMENT '金额',
    391. 

  391.   `openid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT 'openid',
    392. 

  392.   `address_ids` json NULL COMMENT '用户地址ids',
    393. 

  393.   PRIMARY KEY (`id`) USING BTREE
    394. 

  394. ) ENGINE = InnoDB AUTO_INCREMENT = 20 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '客户表' ROW_FORMAT = Dynamic;
    395. 

  395. 

  396. -- ----------------------------
    397. 

  397. -- Records of user
    398. 

  398. -- ----------------------------
    399. 

  399. INSERT INTO `user` VALUES (1, 'user', '123', '爱喝茶的小淮', NULL, 'USER', '男', '18779165101', 7451.00, '1243214213', '[1, 2, 3]');
    400. 

  400. INSERT INTO `user` VALUES (2, 'user2', '123', '喝奶茶的瑶妹', NULL, 'USER', '男', '18779165101', 9934.00, NULL, NULL);
    401. 

  401. INSERT INTO `user` VALUES (3, 'user3', '123', '爱运动的尧', NULL, 'USER', '男', '18779165101', 99999.00, NULL, '[1, 2]');
    402. 

  402. INSERT INTO `user` VALUES (17, '淮小瑞1708502748', 'oYA-Q58ysBMJZymzkAQpBRx_Isc0', '淮小瑞1708502748', NULL, 'USER', NULL, NULL, 0.00, 'oYA-Q58ysBMJZymzkAQpBRx_Isc0', NULL);
    403. 

  403. INSERT INTO `user` VALUES (18, '星河夜', '123', '荡漾', NULL, 'USER', '男', '18970940117', 99999.00, NULL, '[3]');
    404. 

  404. 

  405. -- ----------------------------
    406. 

  406. -- Table structure for video
    407. 

  407. -- ----------------------------
    408. 

  408. DROP TABLE IF EXISTS `video`;
    409. 

  409. CREATE TABLE `video`  (
    410. 

  410.   `id` int NOT NULL COMMENT 'id',
    411. 

  411.   `video_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '视频名称',
    412. 

  412.   `video_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT ' 视频存储路径',
    413. 

  413.   `video_uuid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '视频UUID',
    414. 

  414.   PRIMARY KEY (`id`) USING BTREE
    415. 

  415. ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '视频表' ROW_FORMAT = Dynamic;
    416. 

  416. 

  417. -- ----------------------------
    418. 

  418. -- Records of video
    419. 

  419. -- ----------------------------
    420. 

  420. 

  421. SET FOREIGN_KEY_CHECKS = 1;
    422.