/*
 Navicat Premium Dump SQL

 Source Server         : MySQL
 Source Server Type    : MySQL
 Source Server Version : 80039 (8.0.39)
 Source Host           : localhost:3306
 Source Schema         : taojin

 Target Server Type    : MySQL
 Target Server Version : 80039 (8.0.39)
 File Encoding         : 65001

 Date: 18/12/2024 02:01:56
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for cart_items
-- ----------------------------
DROP TABLE IF EXISTS `cart_items`;
CREATE TABLE `cart_items`  (
  `user_id` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '用户ID',
  `product_id` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '商品ID',
  `product_name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '商品名称',
  `product_image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '商品图片',
  `product_price` decimal(10, 2) NULL DEFAULT NULL COMMENT '商品价格',
  `quantity` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '数量',
  PRIMARY KEY (`user_id`, `product_id`) USING BTREE,
  INDEX `cart_items_ibfk_2`(`product_id` ASC) USING BTREE,
  CONSTRAINT `cart_items_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `cart_items_ibfk_2` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of cart_items
-- ----------------------------

-- ----------------------------
-- Table structure for categories
-- ----------------------------
DROP TABLE IF EXISTS `categories`;
CREATE TABLE `categories`  (
  `id` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '分类ID',
  `name` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '分类名称',
  `parent_id` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '父级分类ID',
  `auth` tinyint(1) NULL DEFAULT NULL COMMENT '0:任何人都可发商品，1:只有管理员可以发商品',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `parent_id`(`parent_id` ASC) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of categories
-- ----------------------------
INSERT INTO `categories` VALUES ('C001336702', '生鲜果蔬', 'C960800148', 0);
INSERT INTO `categories` VALUES ('C009087864', '内裤', 'C143342687', 0);
INSERT INTO `categories` VALUES ('C028635772', '手套', 'C293385376', 0);
INSERT INTO `categories` VALUES ('C030908238', '滋补养身', 'C960800148', 0);
INSERT INTO `categories` VALUES ('C049853687', '男士护理', 'C318066692', 0);
INSERT INTO `categories` VALUES ('C053762748', '腰带', 'C293385376', 0);
INSERT INTO `categories` VALUES ('C075493266', '香氛精油', 'C318066692', 0);
INSERT INTO `categories` VALUES ('C088455424', '丝袜', 'C143342687', 0);
INSERT INTO `categories` VALUES ('C105949356', '美容护肤', 'C318066692', 0);
INSERT INTO `categories` VALUES ('C131503752', '子子元素4', '0', 0);
INSERT INTO `categories` VALUES ('C143342687', '女装男装', '0', 0);
INSERT INTO `categories` VALUES ('C154348144', '子元素2', 'C617062557', 0);
INSERT INTO `categories` VALUES ('C192346214', '子子元素3', 'C154348144', 0);
INSERT INTO `categories` VALUES ('C203231563', '孕产必备', 'C901394629', 0);
INSERT INTO `categories` VALUES ('C240744702', '男士裤子', 'C143342687', 0);
INSERT INTO `categories` VALUES ('C272155753', '眼部彩妆', 'C318066692', 0);
INSERT INTO `categories` VALUES ('C272456456', '纸尿裤', 'C901394629', 0);
INSERT INTO `categories` VALUES ('C293385376', '鞋类箱包', '0', 0);
INSERT INTO `categories` VALUES ('C308002474', '宝宝奶粉', 'C901394629', 0);
INSERT INTO `categories` VALUES ('C318066692', '护肤彩妆', '0', 0);
INSERT INTO `categories` VALUES ('C324051545', '玩具', 'C901394629', 0);
INSERT INTO `categories` VALUES ('C348346069', '子元素', 'C617062557', 0);
INSERT INTO `categories` VALUES ('C363885263', '精品男包', 'C293385376', 0);
INSERT INTO `categories` VALUES ('C364725336', '男鞋', 'C293385376', 0);
INSERT INTO `categories` VALUES ('C371996850', '休闲零食', 'C960800148', 0);
INSERT INTO `categories` VALUES ('C440519372', '时尚男装', 'C143342687', 0);
INSERT INTO `categories` VALUES ('C550511329', '童鞋', 'C901394629', 0);
INSERT INTO `categories` VALUES ('C565318442', '子子元素1', 'C154348144', 0);
INSERT INTO `categories` VALUES ('C617062557', '父元素1', '0', 0);
INSERT INTO `categories` VALUES ('C618507421', '羽绒服', 'C143342687', 0);
INSERT INTO `categories` VALUES ('C627899101', '水产鲜肉', 'C960800148', 0);
INSERT INTO `categories` VALUES ('C682255933', '外套上衣', 'C143342687', 0);
INSERT INTO `categories` VALUES ('C705980686', '子元素3', 'C617062557', 0);
INSERT INTO `categories` VALUES ('C723502147', '女鞋', 'C293385376', 0);
INSERT INTO `categories` VALUES ('C738318225', '潮流女装', 'C143342687', 0);
INSERT INTO `categories` VALUES ('C748297065', '帽子', 'C293385376', 0);
INSERT INTO `categories` VALUES ('C751770044', '超值彩妆', 'C318066692', 0);
INSERT INTO `categories` VALUES ('C770547105', '辅食营养', 'C901394629', 0);
INSERT INTO `categories` VALUES ('C779018126', '牛奶饮料', 'C960800148', 0);
INSERT INTO `categories` VALUES ('C801059488', '潮流女包', 'C293385376', 0);
INSERT INTO `categories` VALUES ('C821165517', '毛衣', 'C143342687', 0);
INSERT INTO `categories` VALUES ('C845377919', '童装', 'C901394629', 0);
INSERT INTO `categories` VALUES ('C848695532', '美发造型', 'C318066692', 0);
INSERT INTO `categories` VALUES ('C886525946', '早教启蒙', 'C901394629', 0);
INSERT INTO `categories` VALUES ('C901394629', '母婴用品', '0', 0);
INSERT INTO `categories` VALUES ('C938837561', '父元素2', '0', 0);
INSERT INTO `categories` VALUES ('C955899316', '子子元素2', 'C154348144', 0);
INSERT INTO `categories` VALUES ('C960800148', '汇吃美食', '0', 0);
INSERT INTO `categories` VALUES ('C973169553', '性感内衣', 'C143342687', 0);
INSERT INTO `categories` VALUES ('C982063224', '旅行箱', 'C293385376', 0);

-- ----------------------------
-- Table structure for coins
-- ----------------------------
DROP TABLE IF EXISTS `coins`;
CREATE TABLE `coins`  (
  `user_id` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '用户ID',
  `coin_balance` bigint NOT NULL DEFAULT 0 COMMENT '淘金币余额',
  `last_update` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '最后更新时间',
  PRIMARY KEY (`user_id`) USING BTREE,
  CONSTRAINT `coins_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of coins
-- ----------------------------
INSERT INTO `coins` VALUES ('1000000000', 943, '2024-12-15 16:07:34');
INSERT INTO `coins` VALUES ('1000000001', 205, '2024-12-17 12:11:12');
INSERT INTO `coins` VALUES ('1000000002', 974, '2024-12-12 21:50:51');
INSERT INTO `coins` VALUES ('1000000003', 37, '2024-12-13 00:33:48');
INSERT INTO `coins` VALUES ('1000000004', 234, '2024-12-11 19:07:33');
INSERT INTO `coins` VALUES ('1000000005', 178, '2024-12-10 13:26:22');
INSERT INTO `coins` VALUES ('1000000006', 766, '2024-12-15 23:13:06');
INSERT INTO `coins` VALUES ('1000000007', 719, '2024-12-16 20:42:42');
INSERT INTO `coins` VALUES ('1000000008', 987, '2024-12-17 15:57:42');
INSERT INTO `coins` VALUES ('1000000009', 545, '2024-12-18 09:43:40');
INSERT INTO `coins` VALUES ('1000000010', 540, '2024-12-11 05:36:33');
INSERT INTO `coins` VALUES ('1000000011', 261, '2024-12-12 02:36:50');
INSERT INTO `coins` VALUES ('1000000012', 920, '2024-12-11 16:00:40');
INSERT INTO `coins` VALUES ('1000000013', 286, '2024-12-17 10:37:59');
INSERT INTO `coins` VALUES ('1000000014', 578, '2024-12-11 15:54:41');
INSERT INTO `coins` VALUES ('1000000015', 492, '2024-12-16 14:54:56');
INSERT INTO `coins` VALUES ('1000000016', 584, '2024-12-10 17:42:36');
INSERT INTO `coins` VALUES ('1000000017', 551, '2024-12-13 12:29:59');
INSERT INTO `coins` VALUES ('1000000018', 748, '2024-12-10 05:08:08');
INSERT INTO `coins` VALUES ('1000000019', 172, '2024-12-08 08:14:37');
INSERT INTO `coins` VALUES ('1000000020', 742, '2024-12-12 21:18:50');
INSERT INTO `coins` VALUES ('1000000021', 915, '2024-12-11 02:45:06');
INSERT INTO `coins` VALUES ('1000000022', 722, '2024-12-17 01:27:11');
INSERT INTO `coins` VALUES ('1000000024', 385, '2024-12-15 17:31:49');
INSERT INTO `coins` VALUES ('1000000025', 21, '2024-12-12 07:07:18');
INSERT INTO `coins` VALUES ('1000000026', 531, '2024-12-10 14:47:38');
INSERT INTO `coins` VALUES ('1000000027', 329, '2024-12-10 10:53:49');
INSERT INTO `coins` VALUES ('1000000028', 192, '2024-12-11 21:06:52');
INSERT INTO `coins` VALUES ('1000000029', 257, '2024-12-14 23:34:17');
INSERT INTO `coins` VALUES ('1000000030', 269, '2024-12-18 22:21:18');
INSERT INTO `coins` VALUES ('1000000031', 905, '2024-12-09 04:18:40');
INSERT INTO `coins` VALUES ('1000000032', 179, '2024-12-12 17:09:13');
INSERT INTO `coins` VALUES ('1000000033', 923, '2024-12-10 05:05:25');
INSERT INTO `coins` VALUES ('1000000034', 198, '2024-12-09 04:45:37');
INSERT INTO `coins` VALUES ('1000000035', 79, '2024-12-12 11:29:39');
INSERT INTO `coins` VALUES ('1000000036', 126, '2024-12-12 01:42:38');
INSERT INTO `coins` VALUES ('1000000037', 267, '2024-12-11 08:13:47');
INSERT INTO `coins` VALUES ('1000000038', 862, '2024-12-18 20:40:48');
INSERT INTO `coins` VALUES ('1000000039', 596, '2024-12-16 21:15:17');
INSERT INTO `coins` VALUES ('1000000040', 331, '2024-12-09 02:39:27');
INSERT INTO `coins` VALUES ('1000000041', 969, '2024-12-17 14:16:20');
INSERT INTO `coins` VALUES ('1000000042', 341, '2024-12-09 13:47:05');
INSERT INTO `coins` VALUES ('1000000043', 375, '2024-12-14 07:24:55');
INSERT INTO `coins` VALUES ('1000000044', 990, '2024-12-14 20:31:49');
INSERT INTO `coins` VALUES ('1000000045', 713, '2024-12-11 03:40:52');
INSERT INTO `coins` VALUES ('1000000046', 947, '2024-12-11 10:06:22');
INSERT INTO `coins` VALUES ('1000000047', 859, '2024-12-17 03:03:41');
INSERT INTO `coins` VALUES ('1000000048', 522, '2024-12-18 06:38:39');
INSERT INTO `coins` VALUES ('1000000049', 20, '2024-12-09 02:57:00');
INSERT INTO `coins` VALUES ('1000000050', 309, '2024-12-18 23:33:49');
INSERT INTO `coins` VALUES ('1000000051', 453, '2024-12-15 14:34:40');
INSERT INTO `coins` VALUES ('1000000053', 725, '2024-12-12 14:34:57');
INSERT INTO `coins` VALUES ('1000000054', 721, '2024-12-12 06:29:34');
INSERT INTO `coins` VALUES ('1000000055', 718, '2024-12-14 19:18:16');
INSERT INTO `coins` VALUES ('1000000056', 572, '2024-12-18 14:56:54');
INSERT INTO `coins` VALUES ('1000000057', 309, '2024-12-18 20:04:51');
INSERT INTO `coins` VALUES ('1000000058', 952, '2024-12-17 05:23:05');
INSERT INTO `coins` VALUES ('1000000059', 522, '2024-12-10 10:24:29');
INSERT INTO `coins` VALUES ('1000000060', 627, '2024-12-11 01:48:29');
INSERT INTO `coins` VALUES ('1000000061', 717, '2024-12-12 12:23:57');
INSERT INTO `coins` VALUES ('1000000062', 306, '2024-12-14 17:12:44');
INSERT INTO `coins` VALUES ('1000000063', 657, '2024-12-17 20:20:39');
INSERT INTO `coins` VALUES ('1000000064', 65, '2024-12-13 00:32:55');
INSERT INTO `coins` VALUES ('1000000065', 523, '2024-12-18 00:02:13');
INSERT INTO `coins` VALUES ('1000000066', 534, '2024-12-09 07:35:32');
INSERT INTO `coins` VALUES ('1000000067', 858, '2024-12-12 16:33:05');
INSERT INTO `coins` VALUES ('1000000068', 887, '2024-12-08 08:55:06');
INSERT INTO `coins` VALUES ('1000000069', 124, '2024-12-13 00:03:34');
INSERT INTO `coins` VALUES ('1000000070', 522, '2024-12-11 16:23:38');
INSERT INTO `coins` VALUES ('1000000071', 487, '2024-12-18 19:24:16');
INSERT INTO `coins` VALUES ('1000000072', 363, '2024-12-12 12:43:14');
INSERT INTO `coins` VALUES ('1000000073', 682, '2024-12-10 13:42:37');
INSERT INTO `coins` VALUES ('1000000074', 978, '2024-12-09 08:50:18');
INSERT INTO `coins` VALUES ('1000000075', 713, '2024-12-14 15:24:50');
INSERT INTO `coins` VALUES ('1000000076', 239, '2024-12-10 15:34:24');
INSERT INTO `coins` VALUES ('1000000077', 321, '2024-12-09 03:15:06');
INSERT INTO `coins` VALUES ('1000000078', 88, '2024-12-14 11:25:28');
INSERT INTO `coins` VALUES ('1000000079', 797, '2024-12-17 03:33:17');
INSERT INTO `coins` VALUES ('1000000080', 859, '2024-12-18 03:48:10');
INSERT INTO `coins` VALUES ('1000000081', 95, '2024-12-17 07:23:08');
INSERT INTO `coins` VALUES ('1000000082', 595, '2024-12-15 10:40:39');
INSERT INTO `coins` VALUES ('1000000083', 811, '2024-12-15 10:38:11');
INSERT INTO `coins` VALUES ('1000000084', 596, '2024-12-11 15:02:07');
INSERT INTO `coins` VALUES ('1000000085', 803, '2024-12-13 17:17:46');
INSERT INTO `coins` VALUES ('1000000086', 864, '2024-12-10 11:55:48');
INSERT INTO `coins` VALUES ('1000000087', 910, '2024-12-18 18:39:58');
INSERT INTO `coins` VALUES ('1000000088', 874, '2024-12-10 18:10:17');
INSERT INTO `coins` VALUES ('1000000089', 600, '2024-12-15 03:43:04');
INSERT INTO `coins` VALUES ('1000000090', 664, '2024-12-18 10:03:05');
INSERT INTO `coins` VALUES ('1000000091', 906, '2024-12-10 10:07:12');
INSERT INTO `coins` VALUES ('1000000092', 687, '2024-12-13 16:48:23');
INSERT INTO `coins` VALUES ('1000000093', 311, '2024-12-13 13:00:28');
INSERT INTO `coins` VALUES ('1000000094', 163, '2024-12-10 06:24:00');
INSERT INTO `coins` VALUES ('1000000095', 416, '2024-12-13 20:36:57');
INSERT INTO `coins` VALUES ('1000000096', 923, '2024-12-12 01:59:22');
INSERT INTO `coins` VALUES ('1000000097', 191, '2024-12-12 02:11:49');
INSERT INTO `coins` VALUES ('1000000098', 809, '2024-12-08 08:18:27');
INSERT INTO `coins` VALUES ('1000000099', 518, '2024-12-10 12:03:31');
INSERT INTO `coins` VALUES ('3232542664', 637, '2024-12-12 05:40:48');
INSERT INTO `coins` VALUES ('4144673812', 179, '2024-12-15 18:50:54');

-- ----------------------------
-- Table structure for favorites
-- ----------------------------
DROP TABLE IF EXISTS `favorites`;
CREATE TABLE `favorites`  (
  `user_id` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `product_id` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  PRIMARY KEY (`user_id`, `product_id`) USING BTREE,
  INDEX `product_id`(`product_id` ASC) USING BTREE,
  CONSTRAINT `favorites_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `favorites_ibfk_2` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of favorites
-- ----------------------------

-- ----------------------------
-- Table structure for order_details
-- ----------------------------
DROP TABLE IF EXISTS `order_details`;
CREATE TABLE `order_details`  (
  `order_id` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '订单ID',
  `product_id` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '商品ID',
  `quantity` double NULL DEFAULT NULL COMMENT '商品数量',
  `unit_price` decimal(10, 2) NULL DEFAULT NULL COMMENT '商品单价',
  `status` tinyint NULL DEFAULT NULL COMMENT '订单状态',
  `logistics` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '物流商',
  PRIMARY KEY (`order_id`, `product_id`) USING BTREE,
  INDEX `product_id`(`product_id` ASC) USING BTREE,
  CONSTRAINT `order_details_ibfk_1` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `order_details_ibfk_2` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of order_details
-- ----------------------------
INSERT INTO `order_details` VALUES ('O001605953', 'P100000010', 9, 78.55, 0, '邮侠');
INSERT INTO `order_details` VALUES ('O001605953', 'P100000021', 9, 55.75, -1, '邮侠');
INSERT INTO `order_details` VALUES ('O011046206', 'P100000006', 2, 23.30, 0, '邮侠');
INSERT INTO `order_details` VALUES ('O011046206', 'P100000018', 8, 27.99, 0, '邮侠');
INSERT INTO `order_details` VALUES ('O021555432', 'P100000024', 9, 90.99, -1, '邮侠');
INSERT INTO `order_details` VALUES ('O021555432', 'P100000035', 7, 35.49, 0, '邮侠');
INSERT INTO `order_details` VALUES ('O025491248', 'P100000039', 2, 55.50, 2, '邮侠');
INSERT INTO `order_details` VALUES ('O027488936', 'P100000008', 9, 60.99, 2, '邮侠');
INSERT INTO `order_details` VALUES ('O027488936', 'P100000022', 1, 44.10, -1, '邮侠');
INSERT INTO `order_details` VALUES ('O029615536', 'P100000012', 9, 25.50, 2, '邮侠');
INSERT INTO `order_details` VALUES ('O038862656', 'P100000032', 3, 78.80, 0, '邮侠');
INSERT INTO `order_details` VALUES ('O044942955', 'P100000017', 2, 49.99, 2, '邮侠');
INSERT INTO `order_details` VALUES ('O050869183', 'P100000013', 6, 18.75, 0, '邮侠');
INSERT INTO `order_details` VALUES ('O050869183', 'P100000024', 8, 90.99, 1, '邮侠');
INSERT INTO `order_details` VALUES ('O050869183', 'P100000035', 8, 35.49, 0, '邮侠');
INSERT INTO `order_details` VALUES ('O068538936', 'P100000015', 5, 15.20, 1, '邮侠');
INSERT INTO `order_details` VALUES ('O092404062', 'P100000001', 6, 12.25, 0, '邮侠');
INSERT INTO `order_details` VALUES ('O105708381', 'P100000036', 5, 99.99, 0, '邮侠');
INSERT INTO `order_details` VALUES ('O105708381', 'P329646113', 7, 111.00, 1, '邮侠');
INSERT INTO `order_details` VALUES ('O108333167', 'P100000023', 8, 49.99, 0, '邮侠');
INSERT INTO `order_details` VALUES ('O108333167', 'P100000025', 6, 32.45, 2, '邮侠');
INSERT INTO `order_details` VALUES ('O120100134', 'P100000030', 5, 19.99, 0, '邮侠');
INSERT INTO `order_details` VALUES ('O123212333', 'P100000037', 6, 15.99, 0, '邮侠');
INSERT INTO `order_details` VALUES ('O123254654', 'P100000029', 9, 99.25, 1, '邮侠');
INSERT INTO `order_details` VALUES ('O123491671', 'P100000023', 8, 49.99, 0, '邮侠');
INSERT INTO `order_details` VALUES ('O136548415', 'P643156284', 2, 11.00, 1, '邮侠');
INSERT INTO `order_details` VALUES ('O153668347', 'P100000015', 5, 15.20, 1, '邮侠');
INSERT INTO `order_details` VALUES ('O176368279', 'P401913208', 2, 1.00, 1, '邮侠');
INSERT INTO `order_details` VALUES ('O182425644', 'P329646113', 5, 111.00, 0, '邮侠');
INSERT INTO `order_details` VALUES ('O183442959', 'P100000011', 8, 15.99, 1, '邮侠');
INSERT INTO `order_details` VALUES ('O183442959', 'P321481548', 6, 6.00, 0, '邮侠');
INSERT INTO `order_details` VALUES ('O184329043', 'P100000010', 4, 78.55, 1, '邮侠');
INSERT INTO `order_details` VALUES ('O184329043', 'P643156284', 4, 11.00, 1, '邮侠');
INSERT INTO `order_details` VALUES ('O192517902', 'P100000004', 8, 65.80, 1, '邮侠');
INSERT INTO `order_details` VALUES ('O196027060', 'P100000023', 6, 49.99, 1, '邮侠');
INSERT INTO `order_details` VALUES ('O213553122', 'P100000014', 8, 13.49, 1, '邮侠');
INSERT INTO `order_details` VALUES ('O230981215', 'P100000009', 9, 23.80, 0, '邮侠');
INSERT INTO `order_details` VALUES ('O230981215', 'P100000015', 10, 15.20, -1, '邮侠');
INSERT INTO `order_details` VALUES ('O237237801', 'P100000006', 2, 23.30, 1, '邮侠');
INSERT INTO `order_details` VALUES ('O237237801', 'P100000029', 10, 99.25, 0, '邮侠');
INSERT INTO `order_details` VALUES ('O237237801', 'P329646113', 0, 111.00, 1, '邮侠');
INSERT INTO `order_details` VALUES ('O240904073', 'P100000017', 4, 49.99, 1, '邮侠');
INSERT INTO `order_details` VALUES ('O240904073', 'P100000028', 8, 35.75, 1, '邮侠');
INSERT INTO `order_details` VALUES ('O241242444', 'P100000021', 7, 55.75, -1, '邮侠');
INSERT INTO `order_details` VALUES ('O241242444', 'P100000026', 2, 85.49, -1, '邮侠');
INSERT INTO `order_details` VALUES ('O246473267', 'P100000005', 9, 77.99, 1, '邮侠');
INSERT INTO `order_details` VALUES ('O268161598', 'P100000035', 9, 35.49, 2, '邮侠');
INSERT INTO `order_details` VALUES ('O268486618', 'P100000017', 10, 49.99, 1, '邮侠');
INSERT INTO `order_details` VALUES ('O268486618', 'P100000031', 9, 50.75, 1, '邮侠');
INSERT INTO `order_details` VALUES ('O317112112', 'P100000036', 5, 99.99, 0, '邮侠');
INSERT INTO `order_details` VALUES ('O318243195', 'P100000003', 7, 40.75, 2, '邮侠');
INSERT INTO `order_details` VALUES ('O318686315', 'P100000019', 1, 11.50, -1, '邮侠');
INSERT INTO `order_details` VALUES ('O318686315', 'P100000023', 3, 49.99, 1, '邮侠');
INSERT INTO `order_details` VALUES ('O318686315', 'P100000032', 1, 78.80, 1, '邮侠');
INSERT INTO `order_details` VALUES ('O322959491', 'P100000011', 8, 15.99, -1, '邮侠');
INSERT INTO `order_details` VALUES ('O328561591', 'P100000024', 1, 90.99, 2, '邮侠');
INSERT INTO `order_details` VALUES ('O342227438', 'P100000007', 7, 11.99, 0, '邮侠');
INSERT INTO `order_details` VALUES ('O342227438', 'P100000015', 7, 15.20, -1, '邮侠');
INSERT INTO `order_details` VALUES ('O342227438', 'P100000035', 2, 35.49, -1, '邮侠');
INSERT INTO `order_details` VALUES ('O376397269', 'P100000012', 4, 25.50, 2, '邮侠');
INSERT INTO `order_details` VALUES ('O377726333', 'P100000012', 7, 25.50, 1, '邮侠');
INSERT INTO `order_details` VALUES ('O394789200', 'P100000015', 6, 15.20, 2, '邮侠');
INSERT INTO `order_details` VALUES ('O394789200', 'P100000033', 2, 30.75, 1, '邮侠');
INSERT INTO `order_details` VALUES ('O404609941', 'P100000030', 7, 19.99, -1, '邮侠');
INSERT INTO `order_details` VALUES ('O408048156', 'P100000011', 1, 15.99, 2, '邮侠');
INSERT INTO `order_details` VALUES ('O414812208', 'P100000035', 7, 35.49, 2, '邮侠');
INSERT INTO `order_details` VALUES ('O430549579', 'P100000008', 8, 60.99, 1, '邮侠');
INSERT INTO `order_details` VALUES ('O430549579', 'P100000029', 1, 99.25, 0, '邮侠');
INSERT INTO `order_details` VALUES ('O435686658', 'P100000036', 1, 99.99, 2, '邮侠');
INSERT INTO `order_details` VALUES ('O435686658', 'P378504525', 7, 1.00, 2, '邮侠');
INSERT INTO `order_details` VALUES ('O451986464', 'P100000023', 1, 49.99, 0, '邮侠');
INSERT INTO `order_details` VALUES ('O454324863', 'P100000006', 3, 23.30, 1, '邮侠');
INSERT INTO `order_details` VALUES ('O464185644', 'P100000035', 6, 35.49, 0, '邮侠');
INSERT INTO `order_details` VALUES ('O468813418', 'P100000019', 2, 11.50, -1, '邮侠');
INSERT INTO `order_details` VALUES ('O476654743', 'P100000016', 6, 19.75, -1, '邮侠');
INSERT INTO `order_details` VALUES ('O485567975', 'P100000024', 1, 90.99, 2, '邮侠');
INSERT INTO `order_details` VALUES ('O492100019', 'P100000024', 7, 90.99, 1, '邮侠');
INSERT INTO `order_details` VALUES ('O507865457', 'P100000007', 8, 11.99, -1, '邮侠');
INSERT INTO `order_details` VALUES ('O507865457', 'P100000016', 9, 19.75, -1, '邮侠');
INSERT INTO `order_details` VALUES ('O507865457', 'P100000017', 8, 49.99, -1, '邮侠');
INSERT INTO `order_details` VALUES ('O513440087', 'P643156284', 1, 11.00, 0, '邮侠');
INSERT INTO `order_details` VALUES ('O516046966', 'P100000017', 2, 49.99, -1, '邮侠');
INSERT INTO `order_details` VALUES ('O521853745', 'P100000002', 9, 20.00, 2, '邮侠');
INSERT INTO `order_details` VALUES ('O532044894', 'P321481548', 4, 6.00, 1, '邮侠');
INSERT INTO `order_details` VALUES ('O537086143', 'P100000013', 3, 18.75, 1, '邮侠');
INSERT INTO `order_details` VALUES ('O564861512', 'P100000008', 4, 60.99, -1, '邮侠');
INSERT INTO `order_details` VALUES ('O575377992', 'P100000015', 2, 15.20, 0, '邮侠');
INSERT INTO `order_details` VALUES ('O575377992', 'P100000027', 5, 75.25, 1, '邮侠');
INSERT INTO `order_details` VALUES ('O575377992', 'P100000035', 2, 35.49, 1, '邮侠');
INSERT INTO `order_details` VALUES ('O575579714', 'P100000005', 4, 77.99, 1, '邮侠');
INSERT INTO `order_details` VALUES ('O575579714', 'P100000017', 0, 49.99, 0, '邮侠');
INSERT INTO `order_details` VALUES ('O575579714', 'P100000037', 3, 15.99, -1, '邮侠');
INSERT INTO `order_details` VALUES ('O622570073', 'P100000025', 2, 32.45, 1, '邮侠');
INSERT INTO `order_details` VALUES ('O648239076', 'P100000013', 5, 18.75, 1, '邮侠');
INSERT INTO `order_details` VALUES ('O648239076', 'P100000025', 7, 32.45, 0, '邮侠');
INSERT INTO `order_details` VALUES ('O650720974', 'P100000009', 4, 23.80, 1, '邮侠');
INSERT INTO `order_details` VALUES ('O650720974', 'P100000027', 8, 75.25, 2, '邮侠');
INSERT INTO `order_details` VALUES ('O668158387', 'P100000038', 5, 60.25, -1, '邮侠');
INSERT INTO `order_details` VALUES ('O682340332', 'P100000001', 5, 12.25, 2, '邮侠');
INSERT INTO `order_details` VALUES ('O686345694', 'P100000002', 10, 20.00, 0, '邮侠');
INSERT INTO `order_details` VALUES ('O697129818', 'P577546284', 9, 51.00, 0, '邮侠');
INSERT INTO `order_details` VALUES ('O698582045', 'P100000023', 6, 49.99, 1, '邮侠');
INSERT INTO `order_details` VALUES ('O705655852', 'P100000036', 5, 99.99, 1, '邮侠');
INSERT INTO `order_details` VALUES ('O707968639', 'P100000036', 7, 99.99, 0, '邮侠');
INSERT INTO `order_details` VALUES ('O724391564', 'P100000026', 8, 85.49, 0, '邮侠');
INSERT INTO `order_details` VALUES ('O732731071', 'P100000004', 8, 65.80, 1, '邮侠');
INSERT INTO `order_details` VALUES ('O741657384', 'P100000005', 3, 77.99, 1, '邮侠');
INSERT INTO `order_details` VALUES ('O748528695', 'P100000007', 9, 11.99, 1, '邮侠');
INSERT INTO `order_details` VALUES ('O748528695', 'P100000028', 1, 35.75, 1, '邮侠');
INSERT INTO `order_details` VALUES ('O750528606', 'P643156284', 7, 11.00, -1, '邮侠');
INSERT INTO `order_details` VALUES ('O751406283', 'P100000003', 2, 40.75, 1, '邮侠');
INSERT INTO `order_details` VALUES ('O751406283', 'P321481548', 4, 6.00, -1, '邮侠');
INSERT INTO `order_details` VALUES ('O752094635', 'P100000008', 0, 60.99, 0, '邮侠');
INSERT INTO `order_details` VALUES ('O752094635', 'P100000022', 1, 44.10, 1, '邮侠');
INSERT INTO `order_details` VALUES ('O756056203', 'P378504525', 9, 1.00, 2, '邮侠');
INSERT INTO `order_details` VALUES ('O758491411', 'P100000039', 4, 55.50, -1, '邮侠');
INSERT INTO `order_details` VALUES ('O765753695', 'P468715484', 0, 10.00, 0, '邮侠');
INSERT INTO `order_details` VALUES ('O775522655', 'P100000006', 9, 23.30, 0, '邮侠');
INSERT INTO `order_details` VALUES ('O781890176', 'P100000003', 8, 40.75, -1, '邮侠');
INSERT INTO `order_details` VALUES ('O794556657', 'P100000027', 1, 75.25, 0, '邮侠');
INSERT INTO `order_details` VALUES ('O810134094', 'P643156284', 9, 11.00, 0, '邮侠');
INSERT INTO `order_details` VALUES ('O811216990', 'P100000023', 2, 49.99, 1, '邮侠');
INSERT INTO `order_details` VALUES ('O811216990', 'P100000026', 10, 85.49, 2, '邮侠');
INSERT INTO `order_details` VALUES ('O841321968', 'P100000003', 9, 40.75, 1, '邮侠');
INSERT INTO `order_details` VALUES ('O842906132', 'P100000001', 3, 12.25, 0, '邮侠');
INSERT INTO `order_details` VALUES ('O864752391', 'P378504525', 5, 1.00, 2, '邮侠');
INSERT INTO `order_details` VALUES ('O865886423', 'P100000004', 1, 65.80, 2, '邮侠');
INSERT INTO `order_details` VALUES ('O870927140', 'P100000023', 9, 49.99, 0, '邮侠');
INSERT INTO `order_details` VALUES ('O877738026', 'P100000004', 6, 65.80, 1, '邮侠');
INSERT INTO `order_details` VALUES ('O882308664', 'P100000013', 6, 18.75, -1, '邮侠');
INSERT INTO `order_details` VALUES ('O882308664', 'P100000020', 8, 44.20, 0, '邮侠');
INSERT INTO `order_details` VALUES ('O902654853', 'P100000027', 7, 75.25, 1, '邮侠');
INSERT INTO `order_details` VALUES ('O913781727', 'P100000013', 2, 18.75, 1, '邮侠');
INSERT INTO `order_details` VALUES ('O913781727', 'P100000014', 1, 13.49, -1, '邮侠');
INSERT INTO `order_details` VALUES ('O942376088', 'P100000020', 1, 44.20, -1, '邮侠');
INSERT INTO `order_details` VALUES ('O942376088', 'P321481548', 6, 6.00, 1, '邮侠');
INSERT INTO `order_details` VALUES ('O954147616', 'P100000007', 10, 11.99, 1, '邮侠');
INSERT INTO `order_details` VALUES ('O954147616', 'P100000016', 10, 19.75, 2, '邮侠');
INSERT INTO `order_details` VALUES ('O957216773', 'P100000033', 3, 30.75, 1, '邮侠');
INSERT INTO `order_details` VALUES ('O979736317', 'P100000001', 8, 12.25, 1, '邮侠');
INSERT INTO `order_details` VALUES ('O979736317', 'P100000015', 8, 15.20, 0, '邮侠');
INSERT INTO `order_details` VALUES ('O979736317', 'P100000018', 9, 27.99, 0, '邮侠');
INSERT INTO `order_details` VALUES ('O983370724', 'P100000019', 4, 11.50, 2, '邮侠');
INSERT INTO `order_details` VALUES ('O983370724', 'P100000022', 2, 44.10, 1, '邮侠');
INSERT INTO `order_details` VALUES ('O983370724', 'P100000024', 4, 90.99, 0, '邮侠');

-- ----------------------------
-- Table structure for orders
-- ----------------------------
DROP TABLE IF EXISTS `orders`;
CREATE TABLE `orders`  (
  `id` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '订单ID',
  `user_id` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '订单所属用户',
  `status` tinyint(1) NULL DEFAULT NULL COMMENT '0：待付款，1：已付款',
  `order_date` datetime NULL DEFAULT NULL COMMENT '订单日期',
  `payment_method` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '支付方式',
  `total_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '总金额',
  `shipping_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '订单配送地址',
  `shipping_status` tinyint(1) NULL DEFAULT NULL COMMENT '0：未付款，1：已送达，2：配送中',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `user_id`(`user_id` ASC) USING BTREE,
  CONSTRAINT `orders_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of orders
-- ----------------------------
INSERT INTO `orders` VALUES ('O001605953', '1000000075', 1, '2024-08-18 10:09:09', 'alipay', 1208.70, NULL, NULL);
INSERT INTO `orders` VALUES ('O011046206', '1000000008', 1, '2024-08-27 14:24:37', 'alipay', 270.52, NULL, NULL);
INSERT INTO `orders` VALUES ('O021555432', '1000000054', 1, '2024-11-28 11:18:12', 'alipay', 1067.34, NULL, NULL);
INSERT INTO `orders` VALUES ('O025491248', '1000000044', 1, '2024-12-07 10:05:17', 'alipay', 111.00, NULL, NULL);
INSERT INTO `orders` VALUES ('O027488936', '1000000076', 1, '2024-11-02 16:42:31', 'alipay', 593.01, NULL, NULL);
INSERT INTO `orders` VALUES ('O029615536', '1000000074', 1, '2024-12-01 12:11:15', 'alipay', 229.50, NULL, NULL);
INSERT INTO `orders` VALUES ('O038862656', '1000000042', 1, '2024-11-11 10:49:57', 'alipay', 236.40, NULL, NULL);
INSERT INTO `orders` VALUES ('O044942955', '1000000074', 1, '2024-08-15 17:51:54', 'alipay', 99.98, NULL, NULL);
INSERT INTO `orders` VALUES ('O050869183', '1000000011', 1, '2024-12-01 09:49:14', 'alipay', 1124.34, NULL, NULL);
INSERT INTO `orders` VALUES ('O068538936', '1000000061', 1, '2024-08-04 16:37:13', 'alipay', 76.00, NULL, NULL);
INSERT INTO `orders` VALUES ('O092404062', '1000000091', 1, '2024-09-20 17:47:29', 'alipay', 73.50, NULL, NULL);
INSERT INTO `orders` VALUES ('O105708381', '1000000051', 1, '2024-10-21 12:45:58', 'alipay', 1276.95, NULL, NULL);
INSERT INTO `orders` VALUES ('O108333167', '1000000042', 1, '2024-09-11 10:36:02', 'alipay', 594.62, NULL, NULL);
INSERT INTO `orders` VALUES ('O120100134', '1000000012', 1, '2024-10-12 11:44:01', 'alipay', 99.95, NULL, NULL);
INSERT INTO `orders` VALUES ('O123212333', '3232542664', 1, '2024-09-26 19:11:57', 'alipay', 95.94, NULL, NULL);
INSERT INTO `orders` VALUES ('O123254654', '7059898741', 1, '2024-09-26 19:11:57', 'alipay', 893.25, NULL, NULL);
INSERT INTO `orders` VALUES ('O123491671', '1000000048', 1, '2024-10-08 09:38:05', 'alipay', 399.92, NULL, NULL);
INSERT INTO `orders` VALUES ('O136548415', '3232542664', 1, '2024-09-26 19:11:57', 'alipay', 22.00, NULL, NULL);
INSERT INTO `orders` VALUES ('O153668347', '1000000055', 1, '2024-12-05 12:31:03', 'alipay', 76.00, NULL, NULL);
INSERT INTO `orders` VALUES ('O176368279', '1000000028', 1, '2024-10-20 15:13:48', 'alipay', 2.00, NULL, NULL);
INSERT INTO `orders` VALUES ('O182425644', '1000000012', 1, '2024-11-30 11:49:27', 'alipay', 555.00, NULL, NULL);
INSERT INTO `orders` VALUES ('O183442959', '1000000030', 1, '2024-11-16 13:15:59', 'alipay', 163.92, NULL, NULL);
INSERT INTO `orders` VALUES ('O184329043', '1000000058', 1, '2024-12-07 14:35:04', 'alipay', 358.20, NULL, NULL);
INSERT INTO `orders` VALUES ('O192517902', '1000000069', 1, '2024-08-13 10:14:09', 'alipay', 526.40, NULL, NULL);
INSERT INTO `orders` VALUES ('O196027060', '1000000085', 1, '2024-12-15 12:06:25', 'alipay', 299.94, NULL, NULL);
INSERT INTO `orders` VALUES ('O213553122', '1000000088', 1, '2024-12-09 12:17:41', 'alipay', 107.92, NULL, NULL);
INSERT INTO `orders` VALUES ('O230981215', '1000000088', 1, '2024-11-08 11:37:15', 'alipay', 366.20, NULL, NULL);
INSERT INTO `orders` VALUES ('O237237801', '1000000068', 1, '2024-10-21 13:21:13', 'alipay', 1039.10, NULL, NULL);
INSERT INTO `orders` VALUES ('O240904073', '1000000026', 1, '2024-12-15 12:49:52', 'alipay', 485.96, NULL, NULL);
INSERT INTO `orders` VALUES ('O241242444', '1000000043', 1, '2024-10-03 15:07:24', 'alipay', 561.23, NULL, NULL);
INSERT INTO `orders` VALUES ('O246473267', '1000000065', 1, '2024-11-08 11:55:11', 'alipay', 701.91, NULL, NULL);
INSERT INTO `orders` VALUES ('O268161598', '1000000017', 1, '2024-10-06 14:34:30', 'alipay', 319.41, NULL, NULL);
INSERT INTO `orders` VALUES ('O268486618', '1000000081', 1, '2024-11-01 16:21:10', 'alipay', 956.65, NULL, NULL);
INSERT INTO `orders` VALUES ('O317112112', '1000000062', 1, '2024-08-09 10:06:14', 'alipay', 499.95, NULL, NULL);
INSERT INTO `orders` VALUES ('O318243195', '1000000019', 1, '2024-10-15 11:14:35', 'alipay', 285.25, NULL, NULL);
INSERT INTO `orders` VALUES ('O318686315', '1000000020', 1, '2024-10-17 16:55:01', 'alipay', 240.27, NULL, NULL);
INSERT INTO `orders` VALUES ('O322959491', '1000000045', 1, '2024-12-07 14:27:01', 'alipay', 127.92, NULL, NULL);
INSERT INTO `orders` VALUES ('O328561591', '1000000061', 1, '2024-10-13 17:43:18', 'alipay', 90.99, NULL, NULL);
INSERT INTO `orders` VALUES ('O342227438', '1000000069', 1, '2024-11-23 12:44:12', 'alipay', 261.31, NULL, NULL);
INSERT INTO `orders` VALUES ('O376397269', '1000000082', 1, '2024-09-25 12:46:54', 'alipay', 102.00, NULL, NULL);
INSERT INTO `orders` VALUES ('O377726333', '7059898741', 1, '2024-12-12 11:44:03', 'alipay', 178.50, NULL, NULL);
INSERT INTO `orders` VALUES ('O394789200', '1000000042', 1, '2024-11-23 16:31:52', 'alipay', 152.70, NULL, NULL);
INSERT INTO `orders` VALUES ('O404609941', '1000000062', 1, '2024-08-15 12:58:41', 'alipay', 139.93, NULL, NULL);
INSERT INTO `orders` VALUES ('O408048156', '1000000087', 1, '2024-10-13 16:05:48', 'alipay', 15.99, NULL, NULL);
INSERT INTO `orders` VALUES ('O414812208', '1000000015', 1, '2024-11-12 14:45:40', 'alipay', 248.43, NULL, NULL);
INSERT INTO `orders` VALUES ('O430549579', '1000000069', 1, '2024-11-25 12:45:41', 'alipay', 587.17, NULL, NULL);
INSERT INTO `orders` VALUES ('O435686658', '1000000066', 1, '2024-11-15 14:32:25', 'alipay', 106.99, NULL, NULL);
INSERT INTO `orders` VALUES ('O451986464', '1000000021', 1, '2024-12-04 16:48:07', 'alipay', 49.99, NULL, NULL);
INSERT INTO `orders` VALUES ('O454324863', '1000000059', 1, '2024-09-04 17:24:45', 'alipay', 69.90, NULL, NULL);
INSERT INTO `orders` VALUES ('O464185644', '1000000069', 1, '2024-08-23 17:29:24', 'alipay', 212.94, NULL, NULL);
INSERT INTO `orders` VALUES ('O468813418', '1000000004', 1, '2024-10-07 10:04:53', 'alipay', 23.00, NULL, NULL);
INSERT INTO `orders` VALUES ('O476654743', '1000000070', 1, '2024-12-10 09:36:06', 'alipay', 118.50, NULL, NULL);
INSERT INTO `orders` VALUES ('O485567975', '1000000001', 1, '2024-08-09 15:41:43', 'alipay', 90.99, NULL, NULL);
INSERT INTO `orders` VALUES ('O492100019', '1000000068', 1, '2024-08-28 09:48:38', 'alipay', 636.93, NULL, NULL);
INSERT INTO `orders` VALUES ('O507865457', '1000000048', 1, '2024-08-31 17:16:28', 'alipay', 673.59, NULL, NULL);
INSERT INTO `orders` VALUES ('O513440087', '1000000091', 1, '2024-12-02 17:20:59', 'alipay', 11.00, NULL, NULL);
INSERT INTO `orders` VALUES ('O516046966', '1000000058', 1, '2024-09-12 14:17:16', 'alipay', 99.98, NULL, NULL);
INSERT INTO `orders` VALUES ('O521853745', '1000000039', 1, '2024-10-22 14:00:50', 'alipay', 180.00, NULL, NULL);
INSERT INTO `orders` VALUES ('O532044894', '1000000060', 1, '2024-11-30 11:39:24', 'alipay', 24.00, NULL, NULL);
INSERT INTO `orders` VALUES ('O537086143', '1000000076', 1, '2024-08-09 15:55:09', 'alipay', 56.25, NULL, NULL);
INSERT INTO `orders` VALUES ('O564861512', '1000000099', 1, '2024-09-10 14:31:54', 'alipay', 243.96, NULL, NULL);
INSERT INTO `orders` VALUES ('O575377992', '1000000067', 1, '2024-10-27 15:44:10', 'alipay', 477.63, NULL, NULL);
INSERT INTO `orders` VALUES ('O575579714', '1000000025', 1, '2024-11-17 09:24:39', 'alipay', 359.93, NULL, NULL);
INSERT INTO `orders` VALUES ('O622570073', '1000000037', 1, '2024-10-26 16:50:30', 'alipay', 64.90, NULL, NULL);
INSERT INTO `orders` VALUES ('O648239076', '1000000030', 1, '2024-11-30 10:39:13', 'alipay', 320.90, NULL, NULL);
INSERT INTO `orders` VALUES ('O650720974', '1000000073', 1, '2024-12-03 13:44:51', 'alipay', 697.20, NULL, NULL);
INSERT INTO `orders` VALUES ('O668158387', '1000000096', 1, '2024-08-18 13:27:54', 'alipay', 301.25, NULL, NULL);
INSERT INTO `orders` VALUES ('O682340332', '1000000038', 1, '2024-09-22 11:09:08', 'alipay', 61.25, NULL, NULL);
INSERT INTO `orders` VALUES ('O686345694', '1000000011', 1, '2024-11-17 10:18:26', 'alipay', 200.00, NULL, NULL);
INSERT INTO `orders` VALUES ('O697129818', '1000000092', 1, '2024-10-10 11:46:26', 'alipay', 459.00, NULL, NULL);
INSERT INTO `orders` VALUES ('O698582045', '1000000035', 1, '2024-10-01 13:10:23', 'alipay', 299.94, NULL, NULL);
INSERT INTO `orders` VALUES ('O705655852', '1000000066', 1, '2024-10-18 10:33:22', 'alipay', 499.95, NULL, NULL);
INSERT INTO `orders` VALUES ('O707968639', '1000000089', 1, '2024-08-12 16:34:58', 'alipay', 699.93, NULL, NULL);
INSERT INTO `orders` VALUES ('O724391564', '1000000091', 1, '2024-08-24 12:31:35', 'alipay', 683.92, NULL, NULL);
INSERT INTO `orders` VALUES ('O732731071', '1000000090', 1, '2024-09-04 09:06:01', 'alipay', 526.40, NULL, NULL);
INSERT INTO `orders` VALUES ('O741657384', '1000000051', 1, '2024-10-27 14:27:38', 'alipay', 233.97, NULL, NULL);
INSERT INTO `orders` VALUES ('O748528695', '1000000044', 1, '2024-09-12 12:08:41', 'alipay', 143.66, NULL, NULL);
INSERT INTO `orders` VALUES ('O750528606', '1000000066', 1, '2024-10-02 12:13:41', 'alipay', 77.00, NULL, NULL);
INSERT INTO `orders` VALUES ('O751406283', '1000000013', 1, '2024-11-22 10:41:27', 'alipay', 105.50, NULL, NULL);
INSERT INTO `orders` VALUES ('O752094635', '1000000004', 1, '2024-10-29 13:19:28', 'alipay', 44.10, NULL, NULL);
INSERT INTO `orders` VALUES ('O756056203', '1000000011', 1, '2024-08-29 10:21:59', 'alipay', 9.00, NULL, NULL);
INSERT INTO `orders` VALUES ('O758491411', '1000000080', 1, '2024-08-06 13:09:20', 'alipay', 222.00, NULL, NULL);
INSERT INTO `orders` VALUES ('O765753695', '1000000025', 1, '2024-09-02 11:04:58', 'alipay', 0.00, NULL, NULL);
INSERT INTO `orders` VALUES ('O775522655', '1000000046', 1, '2024-12-03 14:36:13', 'alipay', 209.70, NULL, NULL);
INSERT INTO `orders` VALUES ('O781890176', '1000000019', 1, '2024-09-11 09:04:27', 'alipay', 326.00, NULL, NULL);
INSERT INTO `orders` VALUES ('O794556657', '1000000016', 1, '2024-10-18 17:51:21', 'alipay', 75.25, NULL, NULL);
INSERT INTO `orders` VALUES ('O810134094', '1000000067', 1, '2024-11-09 15:35:35', 'alipay', 99.00, NULL, NULL);
INSERT INTO `orders` VALUES ('O811216990', '1000000048', 1, '2024-12-01 13:07:07', 'alipay', 954.88, NULL, NULL);
INSERT INTO `orders` VALUES ('O841321968', '1000000086', 1, '2024-11-22 11:53:54', 'alipay', 366.75, NULL, NULL);
INSERT INTO `orders` VALUES ('O842906132', '1000000087', 1, '2024-08-14 09:16:02', 'alipay', 36.75, NULL, NULL);
INSERT INTO `orders` VALUES ('O864752391', '1000000084', 1, '2024-10-15 17:13:43', 'alipay', 5.00, NULL, NULL);
INSERT INTO `orders` VALUES ('O865886423', '1000000079', 1, '2024-11-04 16:02:14', 'alipay', 65.80, NULL, NULL);
INSERT INTO `orders` VALUES ('O870927140', '1000000060', 1, '2024-09-06 16:13:19', 'alipay', 449.91, NULL, NULL);
INSERT INTO `orders` VALUES ('O877738026', '1000000015', 1, '2024-09-06 09:49:25', 'alipay', 394.80, NULL, NULL);
INSERT INTO `orders` VALUES ('O882308664', '1000000078', 1, '2024-12-15 12:36:10', 'alipay', 466.10, NULL, NULL);
INSERT INTO `orders` VALUES ('O902654853', '1000000038', 1, '2024-09-15 14:44:33', 'alipay', 526.75, NULL, NULL);
INSERT INTO `orders` VALUES ('O913781727', '1000000090', 1, '2024-12-01 14:39:34', 'alipay', 50.99, NULL, NULL);
INSERT INTO `orders` VALUES ('O942376088', '1000000048', 1, '2024-11-09 13:51:46', 'alipay', 80.20, NULL, NULL);
INSERT INTO `orders` VALUES ('O954147616', '1000000056', 1, '2024-12-04 13:16:58', 'alipay', 317.40, NULL, NULL);
INSERT INTO `orders` VALUES ('O957216773', '1000000036', 1, '2024-10-20 17:41:36', 'alipay', 92.25, NULL, NULL);
INSERT INTO `orders` VALUES ('O979736317', '1000000047', 1, '2024-09-09 17:51:16', 'alipay', 471.51, NULL, NULL);
INSERT INTO `orders` VALUES ('O983370724', '1000000078', 1, '2024-10-15 14:28:04', 'alipay', 498.16, NULL, NULL);

-- ----------------------------
-- Table structure for products
-- ----------------------------
DROP TABLE IF EXISTS `products`;
CREATE TABLE `products`  (
  `id` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '商品ID',
  `name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '商品名称',
  `description` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '商品信息',
  `image` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '商品图片路径',
  `price` decimal(10, 2) NOT NULL COMMENT '商品价格',
  `stock_quantity` bigint NULL DEFAULT NULL COMMENT '商品库存数量',
  `category_id` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '商品所属分类',
  `user_id` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '商品所属用户',
  `username` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '商品所属用户名',
  `status` tinyint(1) NULL DEFAULT NULL COMMENT '0:已禁用，-1：已删除，1：正常，2：违规',
  `sold` bigint(20) UNSIGNED ZEROFILL NULL DEFAULT NULL COMMENT '已售',
  `create_date` datetime NULL DEFAULT NULL COMMENT '商品创建时间',
  `update_date` datetime NULL DEFAULT NULL COMMENT '商品更新时间',
  `config` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '配置（Json格式）',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `user_id`(`user_id` ASC) USING BTREE,
  INDEX `category_id`(`category_id` ASC) USING BTREE,
  CONSTRAINT `products_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `products_ibfk_2` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of products
-- ----------------------------
INSERT INTO `products` VALUES ('P100000001', '商品1', '简短描述1', 'avatar/defaultImg.jpg', 19.99, 50, 'C049853687', '1000000001', '', 1, 00000000000000000010, '2024-09-16 02:53:04', '2024-09-16 02:53:04', '');
INSERT INTO `products` VALUES ('P100000002', '商品2', '简短描述2', 'avatar/defaultImg.jpg', 35.49, 100, 'C053762748', '1000000003', '', 0, 00000000000000000005, '2024-09-16 02:53:04', '2024-09-16 02:53:04', '');
INSERT INTO `products` VALUES ('P100000003', '商品3', '简短描述3', 'avatar/defaultImg.jpg', 12.25, 30, 'C075493266', '1000000005', '', 2, 00000000000000000000, '2024-09-16 02:53:04', '2024-09-16 02:53:04', '');
INSERT INTO `products` VALUES ('P100000004', '商品4', '简短描述4', 'avatar/defaultImg.jpg', 50.75, 25, 'C088455424', '1000000007', '', 2, 00000000000000000020, '2024-09-16 02:53:04', '2024-09-16 02:53:04', '');
INSERT INTO `products` VALUES ('P100000005', '商品5', '简短描述5', 'avatar/defaultImg.jpg', 99.99, 10, 'C105949356', '1000000009', '', 1, 00000000000000000015, '2024-09-16 02:53:04', '2024-09-16 02:53:04', '');
INSERT INTO `products` VALUES ('P100000006', '商品6', '简短描述6', 'avatar/defaultImg.jpg', 25.50, 60, 'C131503752', '1000000011', '', 1, 00000000000000000007, '2024-09-16 02:53:04', '2024-09-16 02:53:04', '');
INSERT INTO `products` VALUES ('P100000007', '商品7', '简短描述7', 'avatar/defaultImg.jpg', 44.10, 15, 'C049853687', '1000000013', '', 2, 00000000000000000002, '2024-09-16 02:53:04', '2024-09-16 02:53:04', '');
INSERT INTO `products` VALUES ('P100000008', '商品8', '简短描述8', 'avatar/defaultImg.jpg', 78.80, 80, 'C053762748', '1000000015', '', 1, 00000000000000000030, '2024-09-16 02:53:04', '2024-09-16 02:53:04', '');
INSERT INTO `products` VALUES ('P100000009', '商品9', '简短描述9', 'avatar/defaultImg.jpg', 15.99, 35, 'C075493266', '1000000017', '', 2, 00000000000000000012, '2024-09-16 02:53:04', '2024-09-16 02:53:04', '');
INSERT INTO `products` VALUES ('P100000010', '商品10', '简短描述10', 'avatar/defaultImg.jpg', 20.00, 45, 'C088455424', '1000000019', '', 1, 00000000000000000008, '2024-09-16 02:53:04', '2024-09-16 02:53:04', '');
INSERT INTO `products` VALUES ('P100000011', '商品11', '简短描述11', 'avatar/defaultImg.jpg', 30.75, 25, 'C105949356', '1000000020', '', 1, 00000000000000000009, '2024-09-16 02:53:04', '2024-09-16 02:53:04', '');
INSERT INTO `products` VALUES ('P100000012', '商品12', '简短描述12', 'avatar/defaultImg.jpg', 60.25, 40, 'C131503752', '1000000002', '', 2, 00000000000000000000, '2024-09-16 02:53:04', '2024-09-16 02:53:04', '');
INSERT INTO `products` VALUES ('P100000013', '商品13', '简短描述13', 'avatar/defaultImg.jpg', 18.75, 20, 'C049853687', '1000000004', '', 2, 00000000000000000006, '2024-09-16 02:53:04', '2024-09-16 02:53:04', '');
INSERT INTO `products` VALUES ('P100000014', '商品14', '简短描述14', 'avatar/defaultImg.jpg', 49.99, 55, 'C053762748', '1000000006', '', 1, 00000000000000000011, '2024-09-16 02:53:04', '2024-09-16 02:53:04', '');
INSERT INTO `products` VALUES ('P100000015', '商品15', '描述商品15', 'avatar/defaultImg.jpg', 29.99, 60, 'C075493266', '1000000008', '', 1, 00000000000000000014, '2024-09-16 02:53:04', '2024-09-16 02:53:04', '');
INSERT INTO `products` VALUES ('P100000016', '商品16', '描述商品16', 'avatar/defaultImg.jpg', 55.50, 80, 'C088455424', '1000000010', '', 1, 00000000000000000020, '2024-09-16 02:53:04', '2024-09-16 02:53:04', '');
INSERT INTO `products` VALUES ('P100000017', '商品17', '描述商品17', 'avatar/defaultImg.jpg', 40.75, 40, 'C105949356', '1000000012', '', 2, 00000000000000000008, '2024-09-16 02:53:04', '2024-09-16 02:53:04', '');
INSERT INTO `products` VALUES ('P100000018', '商品18', '描述商品18', 'avatar/defaultImg.jpg', 13.49, 35, 'C131503752', '1000000014', '', 2, 00000000000000000005, '2024-09-16 02:53:04', '2024-09-16 02:53:04', '');
INSERT INTO `products` VALUES ('P100000019', '商品19', '描述商品19', 'avatar/defaultImg.jpg', 90.99, 10, 'C049853687', '1000000016', '', 1, 00000000000000000022, '2024-09-16 02:53:04', '2024-09-16 02:53:04', '');
INSERT INTO `products` VALUES ('P100000020', '商品20', '描述商品20', 'avatar/defaultImg.jpg', 65.80, 50, 'C053762748', '1000000018', '', 1, 00000000000000000012, '2024-09-16 02:53:04', '2024-09-16 02:53:04', '');
INSERT INTO `products` VALUES ('P100000021', '商品21', '描述商品21', 'avatar/defaultImg.jpg', 15.20, 25, 'C075493266', '1000000020', '', 1, 00000000000000000007, '2024-09-16 02:53:04', '2024-09-16 02:53:04', '');
INSERT INTO `products` VALUES ('P100000022', '商品22', '描述商品22', 'avatar/defaultImg.jpg', 32.45, 70, 'C088455424', '1000000002', '', 1, 00000000000000000000, '2024-09-16 02:53:04', '2024-09-16 02:53:04', '');
INSERT INTO `products` VALUES ('P100000023', '商品23', '描述商品23', 'avatar/defaultImg.jpg', 77.99, 45, 'C105949356', '1000000004', '', 2, 00000000000000000009, '2024-09-16 02:53:04', '2024-09-16 02:53:04', '');
INSERT INTO `products` VALUES ('P100000024', '商品24', '描述商品24', 'avatar/defaultImg.jpg', 19.75, 20, 'C131503752', '1000000006', '', 1, 00000000000000000006, '2024-09-16 02:53:04', '2024-09-16 02:53:04', '');
INSERT INTO `products` VALUES ('P100000025', '商品25', '描述商品25', 'avatar/defaultImg.jpg', 85.49, 30, 'C049853687', '1000000008', '', 1, 00000000000000000018, '2024-09-16 02:53:04', '2024-09-16 02:53:04', '');
INSERT INTO `products` VALUES ('P100000026', '商品26', '描述商品26', 'avatar/defaultImg.jpg', 23.30, 15, 'C053762748', '1000000010', '', 2, 00000000000000000004, '2024-09-16 02:53:04', '2024-09-16 02:53:04', '');
INSERT INTO `products` VALUES ('P100000027', '商品27', '描述商品27', 'avatar/defaultImg.jpg', 49.99, 55, 'C075493266', '1000000012', '', 2, 00000000000000000003, '2024-09-16 02:53:04', '2024-09-16 02:53:04', '');
INSERT INTO `products` VALUES ('P100000028', '商品28', '描述商品28', 'avatar/defaultImg.jpg', 75.25, 65, 'C088455424', '1000000014', '', 1, 00000000000000000011, '2024-09-16 02:53:04', '2024-09-16 02:53:04', '');
INSERT INTO `products` VALUES ('P100000029', '商品29', '描述商品29', 'avatar/defaultImg.jpg', 11.99, 100, 'C105949356', '1000000016', '', 1, 00000000000000000002, '2024-09-16 02:53:04', '2024-09-16 02:53:04', '');
INSERT INTO `products` VALUES ('P100000030', '商品30', '描述商品30', 'avatar/defaultImg.jpg', 27.99, 40, 'C049853687', '1000000000', '', 1, 00000000000000000013, '2024-09-16 02:53:04', '2024-09-16 02:53:04', '');
INSERT INTO `products` VALUES ('P100000031', '商品31', '描述商品31', 'avatar/defaultImg.jpg', 35.75, 25, 'C053762748', '1000000001', '', 1, 00000000000000000008, '2024-09-16 02:53:04', '2024-09-16 02:53:04', '');
INSERT INTO `products` VALUES ('P100000032', '商品32', '描述商品32', 'avatar/defaultImg.jpg', 60.99, 15, 'C075493266', '1000000002', '', 2, 00000000000000000003, '2024-09-16 02:53:04', '2024-09-16 02:53:04', '');
INSERT INTO `products` VALUES ('P100000033', '商品33', '描述商品33', 'avatar/defaultImg.jpg', 11.50, 90, 'C088455424', '1000000003', '', 2, 00000000000000000000, '2024-09-16 02:53:04', '2024-09-16 02:53:04', '');
INSERT INTO `products` VALUES ('P100000034', '商品34', '描述商品34', 'avatar/defaultImg.jpg', 99.25, 30, 'C105949356', '1000000004', '', 1, 00000000000000000005, '2024-09-16 02:53:04', '2024-09-16 02:53:04', '');
INSERT INTO `products` VALUES ('P100000035', '商品35', '描述商品35', 'avatar/defaultImg.jpg', 23.80, 50, 'C131503752', '1000000000', '', 1, 00000000000000000011, '2024-09-16 02:53:04', '2024-09-16 02:53:04', '');
INSERT INTO `products` VALUES ('P100000036', '商品36', '描述商品36', 'avatar/defaultImg.jpg', 44.20, 45, 'C049853687', '1000000001', '', 2, 00000000000000000007, '2024-09-16 02:53:04', '2024-09-16 02:53:04', '');
INSERT INTO `products` VALUES ('P100000037', '商品37', '描述商品37', 'avatar/defaultImg.jpg', 78.55, 70, 'C053762748', '1000000002', '', 2, 00000000000000000020, '2024-09-16 02:53:04', '2024-09-16 02:53:04', '');
INSERT INTO `products` VALUES ('P100000038', '商品38', '描述商品38', 'avatar/defaultImg.jpg', 15.99, 35, 'C075493266', '1000000003', '', 1, 00000000000000000010, '2024-09-16 02:53:04', '2024-09-16 02:53:04', '');
INSERT INTO `products` VALUES ('P100000039', '商品39', '描述商品39', 'avatar/defaultImg.jpg', 55.75, 20, 'C088455424', '1000000004', '', 1, 00000000000000000009, '2024-09-16 02:53:04', '2024-09-16 02:53:04', '');
INSERT INTO `products` VALUES ('P306429331', 'NASI LEMAK', 'haochi', '202412/N8RyoCOEPD5Gp3r6HvIoCJsatTMREB.jpg', 100.00, 10, 'C030908238', '4144673812', '新世界的神', 1, 00000000000000000000, '2024-12-17 22:01:04', '2024-12-17 22:01:04', NULL);
INSERT INTO `products` VALUES ('P321481548', '龟苓膏', '好吃好吃 男女老少皆适宜', 'avatar/defaultImg.jpg', 6.00, 100, 'C030908238', '4144673812', '新世界的神', 1, 00000000000000000000, '2024-09-16 02:53:04', '2024-09-16 02:53:04', NULL);
INSERT INTO `products` VALUES ('P322168844', 'AK-47', 'LETS START WAR', 'avatar/defaultImg.jpg', 60000.00, 10, 'C154348144', '4144673812', '新世界的神', 2, 00000000000000000000, '2024-09-16 02:53:04', '2024-09-16 02:53:04', NULL);
INSERT INTO `products` VALUES ('P329646113', '啊啊啊', '111', 'avatar/defaultImg.jpg', 111.00, 111, 'C886525946', '4144673812', '新世界的神', 2, 00000000000000000000, '2024-12-14 23:47:08', '2024-12-14 23:47:08', NULL);
INSERT INTO `products` VALUES ('P378504525', 'aaaaa', '', 'avatar/defaultImg.jpg', 1.00, 5, 'C845377919', '4144673812', '新世界的神', 1, 00000000000000000000, '2024-09-16 02:46:36', '2024-09-16 02:46:36', '{\"活动\":\"最多送700元\",\"保障\":\"7天无理由退货\",\"选项\":[\"选项一\",\"选项二\",\"选项三\"]}');
INSERT INTO `products` VALUES ('P401913208', '棒棒糖', '一元一串的棒棒糖', 'avatar/defaultImg.jpg', 1.00, 5, 'C049853687', '4144673812', '新世界的神', 1, 00000000000000000000, '2024-09-16 14:01:47', '2024-09-16 14:01:47', NULL);
INSERT INTO `products` VALUES ('P468715484', '手枪玩具模型', '小孩爱玩的玩具', 'avatar/defaultImg.jpg', 10.00, 20, 'C154348144', '4144673812', '新世界的神', 1, 00000000000000000000, '2024-09-16 02:53:04', '2024-09-16 02:53:04', NULL);
INSERT INTO `products` VALUES ('P515678561', '农夫山泉', '天然饮用水，好喝健康', 'avatar/defaultImg.jpg', 2.00, 125, 'C154348144', '4144673812', '新世界的神', 1, 00000000000000000000, '2024-09-16 02:53:04', '2024-09-16 02:53:04', NULL);
INSERT INTO `products` VALUES ('P577546284', '精美闹钟', '适合大学生、上班族的美丽闹钟', 'avatar/defaultImg.jpg', 51.00, 25, 'C154348144', '4144673812', '新世界的神', 1, 00000000000000000000, '2024-09-16 02:53:04', '2024-09-16 02:53:04', NULL);
INSERT INTO `products` VALUES ('P577715094', 'aaa', NULL, 'avatar/defaultImg.jpg', 21.00, 25, 'C154348144', '4144673812', '新世界的神', 1, 00000000000000000000, '2024-09-16 02:53:04', '2024-09-16 02:53:04', NULL);
INSERT INTO `products` VALUES ('P643156284', '可爱袜子', '舒适易洗、拒绝脚臭', 'avatar/defaultImg.jpg', 11.00, 35, 'C154348144', '4144673812', '新世界的神', 1, 00000000000000000000, '2024-09-16 02:53:04', '2024-09-16 02:53:04', NULL);

-- ----------------------------
-- Table structure for reviews
-- ----------------------------
DROP TABLE IF EXISTS `reviews`;
CREATE TABLE `reviews`  (
  `order_id` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '订单ID',
  `product_id` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '商品ID',
  `user_id` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '用户ID',
  `username` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '用户名',
  `avatar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '用户头像',
  `rating` tinyint(1) NOT NULL COMMENT '评分',
  `comment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '评论内容',
  `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '图片',
  `good_count` bigint NULL DEFAULT NULL COMMENT '有用评论数量',
  `create_date` datetime NULL DEFAULT NULL COMMENT '评论日期',
  PRIMARY KEY (`order_id`, `user_id`, `product_id`) USING BTREE,
  INDEX `user_id`(`user_id` ASC) USING BTREE,
  INDEX `product_id`(`product_id` ASC) USING BTREE,
  CONSTRAINT `reviews_ibfk_1` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `reviews_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `reviews_ibfk_3` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of reviews
-- ----------------------------

-- ----------------------------
-- Table structure for user_addresses
-- ----------------------------
DROP TABLE IF EXISTS `user_addresses`;
CREATE TABLE `user_addresses`  (
  `id` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '地址ID',
  `user_id` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '用户ID',
  `recipient_name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '收件人姓名',
  `adress_line` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '详细地址',
  `city` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '城市',
  `state` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '省份',
  `postal_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '邮政编码',
  `phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '联系电话',
  PRIMARY KEY (`id`, `user_id`) USING BTREE,
  INDEX `user_id`(`user_id` ASC) USING BTREE,
  CONSTRAINT `user_addresses_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of user_addresses
-- ----------------------------
INSERT INTO `user_addresses` VALUES ('foUTyaQaer', '4144673812', '丘绎楦', 'beijing institute and technology campus', NULL, NULL, NULL, '15010901562');
INSERT INTO `user_addresses` VALUES ('MFH9mnISWy', '4144673812', '丘绎楦111', 'beijing institute and technology campus111', NULL, NULL, NULL, '15010901562');

-- ----------------------------
-- Table structure for users
-- ----------------------------
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users`  (
  `id` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '用户ID',
  `username` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '用户名',
  `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '用户密码',
  `email` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '用户邮箱',
  `phone` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '用户手机号',
  `avatar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '头像路径',
  `register_date` datetime NULL DEFAULT NULL COMMENT '用户注册日期',
  `last_login_date` datetime NULL DEFAULT NULL COMMENT '用户最后登录日期',
  `status` tinyint(1) NULL DEFAULT NULL COMMENT '0:已禁用，1:正常，',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `username`(`username` ASC) USING BTREE,
  UNIQUE INDEX `phone`(`phone` ASC) USING BTREE,
  UNIQUE INDEX `email`(`email` ASC) USING BTREE,
  INDEX `id`(`id` ASC) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of users
-- ----------------------------
INSERT INTO `users` VALUES ('1000000000', 'Marjorie Thompson', '0192023a7bbd73250516f069df18b500', 'thomarjorie@icloud.com', '18201237896', '/avatar/defaultImg.jpg', '2004-12-23 21:14:14', '2024-12-17 21:20:32', 1);
INSERT INTO `users` VALUES ('1000000001', 'Sean Mitchell', '0192023a7bbd73250516f069df18b500', 'semitchell@icloud.com', '18167239680', '/avatar/defaultImg.jpg', '2009-09-08 20:33:21', '2020-07-13 05:14:40', 1);
INSERT INTO `users` VALUES ('1000000002', 'Ishii Aoi', '0192023a7bbd73250516f069df18b500', 'aoishii726@outlook.com', '18178245945', '/avatar/defaultImg.jpg', '2002-02-24 14:53:01', '2024-04-05 08:48:14', 1);
INSERT INTO `users` VALUES ('1000000003', 'Annie Olson', '0192023a7bbd73250516f069df18b500', 'annieolson@gmail.com', '18168595146', '/avatar/defaultImg.jpg', '2005-01-23 04:37:15', '2008-11-13 21:52:07', 1);
INSERT INTO `users` VALUES ('1000000004', 'Bradley White', '0192023a7bbd73250516f069df18b500', 'bradley1@gmail.com', '18209444581', '/avatar/defaultImg.jpg', '2005-03-31 08:18:57', '2006-05-25 18:39:43', 1);
INSERT INTO `users` VALUES ('1000000005', 'Jiang Jialun', '0192023a7bbd73250516f069df18b500', 'jiang3@outlook.com', '18124917708', '/avatar/defaultImg.jpg', '2004-08-14 20:17:51', '2012-11-13 17:54:00', 1);
INSERT INTO `users` VALUES ('1000000006', 'Valerie Fisher', '0192023a7bbd73250516f069df18b500', 'valerie10@outlook.com', '18121029749', '/avatar/defaultImg.jpg', '2002-09-29 23:54:45', '2002-04-19 08:30:16', 1);
INSERT INTO `users` VALUES ('1000000007', '邱睿', '0192023a7bbd73250516f069df18b500', 'ruqiu@gmail.com', '18175058728', '/avatar/defaultImg.jpg', '2010-02-18 10:58:58', '2013-05-24 02:26:19', 1);
INSERT INTO `users` VALUES ('1000000008', 'Chang Shihan', '0192023a7bbd73250516f069df18b500', 'changshihan70@mail.com', '18188296937', '/avatar/defaultImg.jpg', '2023-09-16 17:23:47', '2016-08-24 19:43:21', 1);
INSERT INTO `users` VALUES ('1000000009', 'Liao Yunxi', '0192023a7bbd73250516f069df18b500', 'yliao4@hotmail.com', '18154030649', '/avatar/defaultImg.jpg', '2010-07-05 03:48:11', '2003-05-05 16:21:53', 1);
INSERT INTO `users` VALUES ('1000000010', 'Zhang Xiuying', '0192023a7bbd73250516f069df18b500', 'xiuying66@outlook.com', '18137495212', '/avatar/defaultImg.jpg', '2019-03-19 18:12:31', '2002-06-24 21:50:38', 1);
INSERT INTO `users` VALUES ('1000000011', '朱晓明', '0192023a7bbd73250516f069df18b500', 'xiaomingz9@gmail.com', '18209655393', '/avatar/defaultImg.jpg', '2004-02-24 01:41:25', '2023-09-09 07:14:42', 1);
INSERT INTO `users` VALUES ('1000000012', '高岚', '0192023a7bbd73250516f069df18b500', 'lang@icloud.com', '18156221430', '/avatar/defaultImg.jpg', '2004-05-07 15:57:23', '2011-02-16 21:11:47', 1);
INSERT INTO `users` VALUES ('1000000013', '高晓明', '0192023a7bbd73250516f069df18b500', 'gaxiaom@outlook.com', '18182235987', '/avatar/defaultImg.jpg', '2008-01-29 12:22:35', '2001-07-22 13:36:28', 1);
INSERT INTO `users` VALUES ('1000000014', 'Jessica Ryan', '0192023a7bbd73250516f069df18b500', 'jessicaryan@outlook.com', '18221503775', '/avatar/defaultImg.jpg', '2020-06-11 00:01:24', '2020-06-07 21:09:25', 1);
INSERT INTO `users` VALUES ('1000000015', '钟子异', '0192023a7bbd73250516f069df18b500', 'ziz08@gmail.com', '18207238080', '/avatar/defaultImg.jpg', '2006-05-11 04:37:18', '2017-08-20 15:04:11', 1);
INSERT INTO `users` VALUES ('1000000016', '史睿', '0192023a7bbd73250516f069df18b500', 'rus8@mail.com', '18205521225', '/avatar/defaultImg.jpg', '2005-03-06 00:07:52', '2010-05-01 08:33:04', 1);
INSERT INTO `users` VALUES ('1000000017', '曹震南', '0192023a7bbd73250516f069df18b500', 'zhc908@mail.com', '18159495179', '/avatar/defaultImg.jpg', '2005-06-12 11:23:52', '2024-12-08 11:22:09', 1);
INSERT INTO `users` VALUES ('1000000018', 'Yuen Yun Fat', '0192023a7bbd73250516f069df18b500', 'yuen1962@outlook.com', '18212620673', '/avatar/defaultImg.jpg', '2000-12-05 10:57:36', '2000-06-17 10:35:46', 1);
INSERT INTO `users` VALUES ('1000000019', '韦睿', '0192023a7bbd73250516f069df18b500', 'weirui@icloud.com', '18168075835', '/avatar/defaultImg.jpg', '2013-01-03 01:22:42', '2024-10-14 06:39:25', 1);
INSERT INTO `users` VALUES ('1000000020', 'Yao Xiuying', '0192023a7bbd73250516f069df18b500', 'yaox9@hotmail.com', '18140778805', '/avatar/defaultImg.jpg', '2019-04-17 15:44:21', '2011-05-10 16:44:23', 1);
INSERT INTO `users` VALUES ('1000000021', '孔杰宏', '0192023a7bbd73250516f069df18b500', 'kongji@outlook.com', '18111366398', '/avatar/defaultImg.jpg', '2020-02-17 08:38:23', '2005-04-11 13:10:25', 1);
INSERT INTO `users` VALUES ('1000000022', '邓宇宁', '0192023a7bbd73250516f069df18b500', 'dengyu45@hotmail.com', '18205965406', '/avatar/defaultImg.jpg', '2018-12-16 20:12:11', '2020-10-03 09:28:28', 1);
INSERT INTO `users` VALUES ('1000000023', '阎杰宏', '0192023a7bbd73250516f069df18b500', 'jiehongyan@mail.com', '18156179535', '/avatar/defaultImg.jpg', '2017-07-02 17:14:41', '2002-07-03 15:17:05', 1);
INSERT INTO `users` VALUES ('1000000024', '常嘉伦', '0192023a7bbd73250516f069df18b500', 'jialunchang@gmail.com', '18141204438', '/avatar/defaultImg.jpg', '2011-02-13 15:04:17', '2006-04-20 09:46:09', 1);
INSERT INTO `users` VALUES ('1000000025', 'Chung Chi Ming', '0192023a7bbd73250516f069df18b500', 'chimingchung@gmail.com', '18181293979', '/avatar/defaultImg.jpg', '2011-11-12 07:39:49', '2024-06-21 02:32:05', 1);
INSERT INTO `users` VALUES ('1000000026', 'Xu Lan', '0192023a7bbd73250516f069df18b500', 'lax80@outlook.com', '18141439526', '/avatar/defaultImg.jpg', '2001-09-21 12:56:57', '2000-02-02 07:08:24', 1);
INSERT INTO `users` VALUES ('1000000027', 'Yuen Siu Wai', '0192023a7bbd73250516f069df18b500', 'yuensw8@mail.com', '18175712875', '/avatar/defaultImg.jpg', '2009-06-02 00:45:15', '2016-06-12 08:02:54', 1);
INSERT INTO `users` VALUES ('1000000028', 'Yamamoto Ryota', '0192023a7bbd73250516f069df18b500', 'ryota825@icloud.com', '18123791501', '/avatar/defaultImg.jpg', '2018-08-29 19:20:11', '2023-06-29 10:02:21', 1);
INSERT INTO `users` VALUES ('1000000029', 'Yamamoto Nanami', '0192023a7bbd73250516f069df18b500', 'yana@icloud.com', '18215850316', '/avatar/defaultImg.jpg', '2019-04-13 15:47:00', '2012-11-06 15:56:13', 1);
INSERT INTO `users` VALUES ('1000000030', 'Endo Minato', '0192023a7bbd73250516f069df18b500', 'minatoendo6@icloud.com', '18149629506', '/avatar/defaultImg.jpg', '2010-09-09 01:38:33', '2019-02-03 02:28:29', 1);
INSERT INTO `users` VALUES ('1000000031', 'Hasegawa Akina', '0192023a7bbd73250516f069df18b500', 'hasegawa10@outlook.com', '18137255886', '/avatar/defaultImg.jpg', '2009-09-07 14:42:27', '2012-04-30 12:46:12', 1);
INSERT INTO `users` VALUES ('1000000032', 'Nakamura Aoshi', '0192023a7bbd73250516f069df18b500', 'aoshn9@yahoo.com', '18130799237', '/avatar/defaultImg.jpg', '2011-05-30 02:05:28', '2014-05-31 23:17:40', 1);
INSERT INTO `users` VALUES ('1000000033', 'Lau Yu Ling', '0192023a7bbd73250516f069df18b500', 'lauyuling1216@gmail.com', '18153313648', '/avatar/defaultImg.jpg', '2023-04-19 13:06:20', '2022-10-23 01:15:48', 1);
INSERT INTO `users` VALUES ('1000000034', 'Ralph Patel', '0192023a7bbd73250516f069df18b500', 'patelr@hotmail.com', '18115850437', '/avatar/defaultImg.jpg', '2002-10-03 18:17:12', '2007-05-31 11:40:34', 1);
INSERT INTO `users` VALUES ('1000000035', 'Nakamori Ayano', '0192023a7bbd73250516f069df18b500', 'nakamayano1967@outlook.com', '18173220211', '/avatar/defaultImg.jpg', '2021-02-25 14:53:32', '2000-06-08 07:57:59', 1);
INSERT INTO `users` VALUES ('1000000036', 'Manuel Smith', '0192023a7bbd73250516f069df18b500', 'manuel411@mail.com', '18168825555', '/avatar/defaultImg.jpg', '2002-01-05 12:40:56', '2012-08-26 19:35:27', 1);
INSERT INTO `users` VALUES ('1000000037', 'Anna Henderson', '0192023a7bbd73250516f069df18b500', 'hendersonan@gmail.com', '18156485013', '/avatar/defaultImg.jpg', '2016-05-20 15:19:29', '2015-03-06 06:08:13', 1);
INSERT INTO `users` VALUES ('1000000038', 'Rita Clark', '0192023a7bbd73250516f069df18b500', 'ritaclark128@mail.com', '18165064056', '/avatar/defaultImg.jpg', '2023-04-04 12:39:51', '2005-12-23 06:22:43', 1);
INSERT INTO `users` VALUES ('1000000039', 'Carl Torres', '0192023a7bbd73250516f069df18b500', 'tcarl1986@icloud.com', '18129681661', '/avatar/defaultImg.jpg', '2022-05-25 08:02:55', '2017-12-24 06:06:52', 1);
INSERT INTO `users` VALUES ('1000000040', 'Ichikawa Ayato', '0192023a7bbd73250516f069df18b500', 'aich@icloud.com', '18114695764', '/avatar/defaultImg.jpg', '2009-05-18 18:37:17', '2009-04-28 04:39:26', 1);
INSERT INTO `users` VALUES ('1000000041', 'Yeung Kwok Yin', '0192023a7bbd73250516f069df18b500', 'kyyeun53@icloud.com', '18125157963', '/avatar/defaultImg.jpg', '2012-01-05 08:20:26', '2000-02-25 09:11:10', 1);
INSERT INTO `users` VALUES ('1000000042', 'Jeff Payne', '0192023a7bbd73250516f069df18b500', 'paynej@gmail.com', '18197142361', '/avatar/defaultImg.jpg', '2021-11-19 02:35:30', '2006-05-30 14:28:53', 1);
INSERT INTO `users` VALUES ('1000000043', 'Harry Sanders', '0192023a7bbd73250516f069df18b500', 'harrysan6@icloud.com', '18182002924', '/avatar/defaultImg.jpg', '2009-09-18 16:15:53', '2011-05-03 19:46:23', 1);
INSERT INTO `users` VALUES ('1000000044', 'Lo Ka Ling', '0192023a7bbd73250516f069df18b500', 'lo6@gmail.com', '18114784726', '/avatar/defaultImg.jpg', '2023-03-01 14:58:22', '2018-11-16 13:26:22', 1);
INSERT INTO `users` VALUES ('1000000045', 'Rebecca Ross', '0192023a7bbd73250516f069df18b500', 'ross2@outlook.com', '18166341556', '/avatar/defaultImg.jpg', '2001-08-15 10:26:17', '2011-03-12 19:06:14', 1);
INSERT INTO `users` VALUES ('1000000046', 'John Garcia', '0192023a7bbd73250516f069df18b500', 'garcijohn@outlook.com', '18196966038', '/avatar/defaultImg.jpg', '2008-03-15 01:01:01', '2022-06-21 13:27:39', 1);
INSERT INTO `users` VALUES ('1000000047', 'Susan Patel', '0192023a7bbd73250516f069df18b500', 'susanpatel@outlook.com', '18220630907', '/avatar/defaultImg.jpg', '2006-09-24 05:41:40', '2018-04-05 16:13:26', 1);
INSERT INTO `users` VALUES ('1000000048', '戴詩涵', '0192023a7bbd73250516f069df18b500', 'daishihan@gmail.com', '18198833793', '/avatar/defaultImg.jpg', '2020-10-23 22:41:01', '2018-02-23 23:57:54', 1);
INSERT INTO `users` VALUES ('1000000049', 'Clifford Stewart', '0192023a7bbd73250516f069df18b500', 'clifford9@mail.com', '18175295805', '/avatar/defaultImg.jpg', '2022-02-13 01:40:51', '2013-02-17 10:36:35', 1);
INSERT INTO `users` VALUES ('1000000050', 'Yoshida Rena', '0192023a7bbd73250516f069df18b500', 'yoshidarena@gmail.com', '18163285429', '/avatar/defaultImg.jpg', '2022-06-13 17:29:58', '2014-09-24 10:19:18', 1);
INSERT INTO `users` VALUES ('1000000051', 'Zhao Lu', '0192023a7bbd73250516f069df18b500', 'luz402@outlook.com', '18142607643', '/avatar/defaultImg.jpg', '2016-10-30 09:08:32', '2024-07-23 11:27:38', 1);
INSERT INTO `users` VALUES ('1000000052', 'Jiang Zhiyuan', '0192023a7bbd73250516f069df18b500', 'jiangzhiyuan@yahoo.com', '18200785159', '/avatar/defaultImg.jpg', '2004-03-05 05:24:23', '2003-03-17 14:43:29', 1);
INSERT INTO `users` VALUES ('1000000053', 'Hsuan Kwok Kuen', '0192023a7bbd73250516f069df18b500', 'kkhsua@outlook.com', '18139846768', '/avatar/defaultImg.jpg', '2009-03-24 09:28:30', '2011-07-09 22:07:58', 1);
INSERT INTO `users` VALUES ('1000000054', 'Matsui Momoe', '0192023a7bbd73250516f069df18b500', 'matsuimomo@outlook.com', '18137972406', '/avatar/defaultImg.jpg', '2018-08-16 07:28:18', '2013-03-14 23:23:09', 1);
INSERT INTO `users` VALUES ('1000000055', 'Xue Xiaoming', '0192023a7bbd73250516f069df18b500', 'xuexiaoming@icloud.com', '18153778181', '/avatar/defaultImg.jpg', '2014-06-05 15:06:54', '2020-10-26 14:41:25', 1);
INSERT INTO `users` VALUES ('1000000056', 'Aoki Yota', '0192023a7bbd73250516f069df18b500', 'aoyota1@mail.com', '18112904722', '/avatar/defaultImg.jpg', '2022-12-14 03:20:49', '2014-08-12 08:06:49', 1);
INSERT INTO `users` VALUES ('1000000057', 'Fung Sze Yu', '0192023a7bbd73250516f069df18b500', 'funsz@gmail.com', '18201462122', '/avatar/defaultImg.jpg', '2004-07-13 13:24:31', '2002-12-02 12:24:45', 1);
INSERT INTO `users` VALUES ('1000000058', 'Miu Ching Wan', '0192023a7bbd73250516f069df18b500', 'chingwanmi@gmail.com', '18217388112', '/avatar/defaultImg.jpg', '2022-04-24 04:50:10', '2019-03-14 15:16:02', 1);
INSERT INTO `users` VALUES ('1000000059', 'Meng Xiuying', '0192023a7bbd73250516f069df18b500', 'mengxiuyi05@outlook.com', '18177267977', '/avatar/defaultImg.jpg', '2024-09-27 08:49:05', '2000-10-31 14:00:02', 1);
INSERT INTO `users` VALUES ('1000000060', 'Chiba Mio', '0192023a7bbd73250516f069df18b500', 'chiba104@yahoo.com', '18221563144', '/avatar/defaultImg.jpg', '2013-03-14 18:43:52', '2024-08-29 01:32:21', 1);
INSERT INTO `users` VALUES ('1000000061', 'Tao Sai Wing', '0192023a7bbd73250516f069df18b500', 'swtao86@yahoo.com', '18168153679', '/avatar/defaultImg.jpg', '2007-03-08 10:45:42', '2022-07-17 00:14:59', 1);
INSERT INTO `users` VALUES ('1000000062', '陶云熙', '0192023a7bbd73250516f069df18b500', 'yutao59@hotmail.com', '18159997425', '/avatar/defaultImg.jpg', '2003-08-05 10:28:24', '2003-08-03 19:22:38', 1);
INSERT INTO `users` VALUES ('1000000063', 'Heung Tak Wah', '0192023a7bbd73250516f069df18b500', 'takwahh1@icloud.com', '18151066845', '/avatar/defaultImg.jpg', '2001-04-14 19:15:15', '2000-02-07 22:44:45', 1);
INSERT INTO `users` VALUES ('1000000064', 'Hao Jialun', '0192023a7bbd73250516f069df18b500', 'haojialu@icloud.com', '18215076500', '/avatar/defaultImg.jpg', '2022-06-26 20:39:22', '2022-07-07 21:47:28', 1);
INSERT INTO `users` VALUES ('1000000065', 'Yan Jialun', '0192023a7bbd73250516f069df18b500', 'jiay@outlook.com', '18156301068', '/avatar/defaultImg.jpg', '2019-03-13 08:58:33', '2017-05-11 10:00:34', 1);
INSERT INTO `users` VALUES ('1000000066', 'Dong Yunxi', '0192023a7bbd73250516f069df18b500', 'yunxidong9@outlook.com', '18120396902', '/avatar/defaultImg.jpg', '2003-04-21 16:23:13', '2013-07-30 15:20:39', 1);
INSERT INTO `users` VALUES ('1000000067', 'Wu Lai Yan', '0192023a7bbd73250516f069df18b500', 'lywu9@mail.com', '18196073774', '/avatar/defaultImg.jpg', '2017-08-13 16:17:34', '2001-11-28 02:57:34', 1);
INSERT INTO `users` VALUES ('1000000068', 'Charlotte Brown', '0192023a7bbd73250516f069df18b500', 'brown1@mail.com', '18115793360', '/avatar/defaultImg.jpg', '2013-12-26 15:04:32', '2015-08-07 14:56:05', 1);
INSERT INTO `users` VALUES ('1000000069', 'Liang Ziyi', '0192023a7bbd73250516f069df18b500', 'liangziyi@outlook.com', '18112080356', '/avatar/defaultImg.jpg', '2000-06-04 09:43:53', '2010-04-11 16:18:38', 1);
INSERT INTO `users` VALUES ('1000000070', '史秀英', '0192023a7bbd73250516f069df18b500', 'shixiuyi1@icloud.com', '18169630507', '/avatar/defaultImg.jpg', '2023-07-29 17:46:33', '2019-09-12 01:34:07', 1);
INSERT INTO `users` VALUES ('1000000071', 'Siu Wai San', '0192023a7bbd73250516f069df18b500', 'siuwaisan2@icloud.com', '18139828132', '/avatar/defaultImg.jpg', '2021-05-07 09:10:53', '2013-10-09 03:50:37', 1);
INSERT INTO `users` VALUES ('1000000072', 'Gu Jialun', '0192023a7bbd73250516f069df18b500', 'gujialun1221@gmail.com', '18181917978', '/avatar/defaultImg.jpg', '2021-04-08 05:30:55', '2017-02-27 17:15:32', 1);
INSERT INTO `users` VALUES ('1000000073', 'Hara Kenta', '0192023a7bbd73250516f069df18b500', 'hara43@gmail.com', '18191349195', '/avatar/defaultImg.jpg', '2011-04-10 13:27:43', '2017-12-01 12:29:37', 1);
INSERT INTO `users` VALUES ('1000000074', 'Benjamin Mitchell', '0192023a7bbd73250516f069df18b500', 'mibenja06@outlook.com', '18117859550', '/avatar/defaultImg.jpg', '2017-09-06 12:28:11', '2006-02-18 08:23:16', 1);
INSERT INTO `users` VALUES ('1000000075', 'Hsuan Kwok Yin', '0192023a7bbd73250516f069df18b500', 'kyhs@hotmail.com', '18150749685', '/avatar/defaultImg.jpg', '2002-04-12 14:05:39', '2006-09-14 07:17:48', 1);
INSERT INTO `users` VALUES ('1000000076', 'Fong Hui Mei', '0192023a7bbd73250516f069df18b500', 'huimei1954@hotmail.com', '18134086261', '/avatar/defaultImg.jpg', '2005-09-13 08:23:34', '2014-11-14 13:18:51', 1);
INSERT INTO `users` VALUES ('1000000077', 'Connie Rose', '0192023a7bbd73250516f069df18b500', 'connie10@icloud.com', '18174281067', '/avatar/defaultImg.jpg', '2003-07-07 13:52:58', '2011-02-24 01:18:43', 1);
INSERT INTO `users` VALUES ('1000000078', 'Allen Cooper', '0192023a7bbd73250516f069df18b500', 'cooper58@gmail.com', '18205894620', '/avatar/defaultImg.jpg', '2022-08-09 08:03:48', '2024-01-01 01:29:25', 1);
INSERT INTO `users` VALUES ('1000000079', 'Allen Sanders', '0192023a7bbd73250516f069df18b500', 'sanders9@hotmail.com', '18129803149', '/avatar/defaultImg.jpg', '2004-09-02 13:30:41', '2015-06-19 09:24:37', 1);
INSERT INTO `users` VALUES ('1000000080', 'Stephen Ferguson', '0192023a7bbd73250516f069df18b500', 'stferguson1023@yahoo.com', '18187218179', '/avatar/defaultImg.jpg', '2009-05-17 06:58:10', '2019-04-19 21:30:55', 1);
INSERT INTO `users` VALUES ('1000000081', 'Sakurai Rin', '0192023a7bbd73250516f069df18b500', 'sakurai14@outlook.com', '18165740322', '/avatar/defaultImg.jpg', '2008-01-17 10:35:57', '2017-07-04 07:56:06', 1);
INSERT INTO `users` VALUES ('1000000082', '宋秀英', '0192023a7bbd73250516f069df18b500', 'sox@gmail.com', '18143850363', '/avatar/defaultImg.jpg', '2002-12-01 04:21:18', '2014-02-01 04:26:25', 1);
INSERT INTO `users` VALUES ('1000000083', 'Kevin Aguilar', '0192023a7bbd73250516f069df18b500', 'aguilkevin@outlook.com', '18197466327', '/avatar/defaultImg.jpg', '2015-06-16 05:51:48', '2018-01-10 04:09:46', 1);
INSERT INTO `users` VALUES ('1000000084', 'Abe Ryota', '0192023a7bbd73250516f069df18b500', 'ryotaa1106@gmail.com', '18211544748', '/avatar/defaultImg.jpg', '2002-05-01 20:20:18', '2020-11-28 04:51:38', 1);
INSERT INTO `users` VALUES ('1000000085', 'Cui Rui', '0192023a7bbd73250516f069df18b500', 'cr622@gmail.com', '18211900551', '/avatar/defaultImg.jpg', '2020-07-09 09:43:23', '2010-07-13 18:25:09', 1);
INSERT INTO `users` VALUES ('1000000086', 'Wu Rui', '0192023a7bbd73250516f069df18b500', 'wurui5@gmail.com', '18167221268', '/avatar/defaultImg.jpg', '2002-04-18 19:38:54', '2003-06-17 08:18:42', 1);
INSERT INTO `users` VALUES ('1000000087', 'Yue Ming', '0192023a7bbd73250516f069df18b500', 'ymin@icloud.com', '18131791865', '/avatar/defaultImg.jpg', '2019-05-04 15:06:17', '2009-03-28 21:22:46', 1);
INSERT INTO `users` VALUES ('1000000088', 'Gao Rui', '0192023a7bbd73250516f069df18b500', 'gao10@gmail.com', '18122489117', '/avatar/defaultImg.jpg', '2003-08-31 04:46:07', '2002-05-04 11:01:33', 1);
INSERT INTO `users` VALUES ('1000000089', 'Kathy Ferguson', '0192023a7bbd73250516f069df18b500', 'fergusonkathy106@outlook.com', '18214883524', '/avatar/defaultImg.jpg', '2007-11-11 14:34:19', '2020-05-30 08:29:30', 1);
INSERT INTO `users` VALUES ('1000000090', 'Okamoto Aoshi', '0192023a7bbd73250516f069df18b500', 'aoshi04@gmail.com', '18149808034', '/avatar/defaultImg.jpg', '2009-06-02 01:58:19', '2005-02-27 23:00:53', 1);
INSERT INTO `users` VALUES ('1000000091', 'Au Suk Yee', '0192023a7bbd73250516f069df18b500', 'au711@icloud.com', '18142633408', '/avatar/defaultImg.jpg', '2008-02-15 16:15:09', '2024-12-12 01:37:51', 1);
INSERT INTO `users` VALUES ('1000000092', 'Julia Henry', '0192023a7bbd73250516f069df18b500', 'henryj@outlook.com', '18159324651', '/avatar/defaultImg.jpg', '2024-04-05 17:14:53', '2010-02-05 10:25:53', 1);
INSERT INTO `users` VALUES ('1000000093', 'Shing Ho Yin', '0192023a7bbd73250516f069df18b500', 'shoyi@outlook.com', '18165863674', '/avatar/defaultImg.jpg', '2015-10-22 14:38:43', '2005-02-23 11:45:51', 1);
INSERT INTO `users` VALUES ('1000000094', 'Kong Xiaoming', '0192023a7bbd73250516f069df18b500', 'kxi@icloud.com', '18198748332', '/avatar/defaultImg.jpg', '2021-08-25 17:06:16', '2024-08-13 03:42:10', 1);
INSERT INTO `users` VALUES ('1000000095', 'Long Zitao', '0192023a7bbd73250516f069df18b500', 'lzitao1984@icloud.com', '18205848172', '/avatar/defaultImg.jpg', '2005-06-25 23:43:59', '2003-05-09 14:14:37', 1);
INSERT INTO `users` VALUES ('1000000096', 'Harold Murphy', '0192023a7bbd73250516f069df18b500', 'haroldmu511@icloud.com', '18140802580', '/avatar/defaultImg.jpg', '2003-05-24 03:56:37', '2003-09-10 23:31:36', 1);
INSERT INTO `users` VALUES ('1000000097', 'Don Alvarez', '0192023a7bbd73250516f069df18b500', 'alvarezd1996@gmail.com', '18200895273', '/avatar/defaultImg.jpg', '2008-11-12 13:28:32', '2015-05-21 04:55:52', 1);
INSERT INTO `users` VALUES ('1000000098', 'Janice Garza', '0192023a7bbd73250516f069df18b500', 'jgarz9@yahoo.com', '18206182611', '/avatar/defaultImg.jpg', '2011-07-25 21:09:19', '2000-11-16 18:42:47', 1);
INSERT INTO `users` VALUES ('1000000099', 'Chin Chieh Lun', '0192023a7bbd73250516f069df18b500', 'ccl@mail.com', '18118238657', '/avatar/defaultImg.jpg', '2011-08-27 21:00:53', '2021-09-04 07:37:38', 1);
INSERT INTO `users` VALUES ('3232542664', '啦啦啦', '0192023a7bbd73250516f069df18b500', NULL, '15010901561', '/avatar/defaultImg.jpg', '2024-10-11 11:18:57', '2024-10-11 11:18:59', 1);
INSERT INTO `users` VALUES ('4144673812', '新世界的神', '0192023a7bbd73250516f069df18b500', NULL, '15010901562', '/avatar/defaultImg.jpg', '2024-09-15 01:24:49', '2024-12-17 21:59:20', 1);
INSERT INTO `users` VALUES ('7059898741', 'yyt', '0192023a7bbd73250516f069df18b500', NULL, '18111111111', '/avatar/defaultImg.jpg', '2024-12-13 19:06:27', '2024-12-13 19:49:30', 1);

SET FOREIGN_KEY_CHECKS = 1;

# coin_balance变成有2位小数点
ALTER TABLE coins
MODIFY COLUMN coin_balance DECIMAL(10, 2) NOT NULL DEFAULT 0 COMMENT '淘金币余额';