/*
 Navicat Premium Data Transfer

 Source Server         : 本地
 Source Server Type    : MySQL
 Source Server Version : 50737
 Source Host           : localhost:3306
 Source Schema         : idle_goods

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

 Date: 19/05/2022 12:52:04
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for admin
-- ----------------------------
DROP TABLE IF EXISTS `admin`;
CREATE TABLE `admin` (
  `id` char(4) NOT NULL,
  `name` varchar(50) DEFAULT NULL,
  `phone` char(11) DEFAULT NULL,
  `address` varchar(100) DEFAULT NULL,
  `is_delete` tinyint(4) DEFAULT '0',
  `sex` char(2) DEFAULT NULL,
  `wechat` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of admin
-- ----------------------------
BEGIN;
INSERT INTO `admin` (`id`, `name`, `phone`, `address`, `is_delete`, `sex`, `wechat`) VALUES ('1001', '徐晓晓', '13111111122', '海珠北区E-101', NULL, '女', '13111111111');
COMMIT;

-- ----------------------------
-- Table structure for goods
-- ----------------------------
DROP TABLE IF EXISTS `goods`;
CREATE TABLE `goods` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(20) DEFAULT NULL,
  `described` varchar(100) DEFAULT NULL,
  `price` varchar(10) DEFAULT NULL,
  `buy_price` varchar(10) DEFAULT NULL,
  `uid` char(12) NOT NULL,
  `status` int(11) DEFAULT '1',
  `degree` varchar(20) DEFAULT NULL,
  `category_id` int(11) DEFAULT NULL,
  `publish_time` varchar(50) DEFAULT NULL,
  `imgs` varchar(255) DEFAULT NULL,
  `pickup_place` varchar(30) DEFAULT NULL,
  `is_delete` tinyint(1) DEFAULT '0',
  `stock` int(11) DEFAULT '1',
  `total_sum` int(11) DEFAULT '1',
  `cancel_reason` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `uid` (`uid`),
  KEY `category_id` (`category_id`),
  KEY `degree_index` (`degree`,`status`),
  KEY `title_index` (`title`),
  CONSTRAINT `goods_ibfk_1` FOREIGN KEY (`uid`) REFERENCES `user` (`id`),
  CONSTRAINT `goods_ibfk_2` FOREIGN KEY (`category_id`) REFERENCES `goods_category` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=102 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of goods
-- ----------------------------
BEGIN;
INSERT INTO `goods` (`id`, `title`, `described`, `price`, `buy_price`, `uid`, `status`, `degree`, `category_id`, `publish_time`, `imgs`, `pickup_place`, `is_delete`, `stock`, `total_sum`, `cancel_reason`) VALUES (1, '优衣库纯棉t恤', '100%棉 实体店购入', '10', '79', '201810214719', 1, '全新', 5, '2022-03-23 20:28:01', '2203161630_pinkt.png', '海珠南区D栋11楼', 0, 1, 1, '自主下架');
INSERT INTO `goods` (`id`, `title`, `described`, `price`, `buy_price`, `uid`, `status`, `degree`, `category_id`, `publish_time`, `imgs`, `pickup_place`, `is_delete`, `stock`, `total_sum`, `cancel_reason`) VALUES (2, '《活着》', '书本 京东自营购入 无读书痕迹', '5', '50', '201810214719', 1, '九成新', 2, '2022-03-16 21:35:00', '220316233302_live1.png,220316233302_live2.png,220316233302_live3.png', '海珠校区教学楼904', 0, 1, 1, NULL);
INSERT INTO `goods` (`id`, `title`, `described`, `price`, `buy_price`, `uid`, `status`, `degree`, `category_id`, `publish_time`, `imgs`, `pickup_place`, `is_delete`, `stock`, `total_sum`, `cancel_reason`) VALUES (3, '小清新双肩背包', '旗舰店购入 保存的很好 就背过4-5次', '30', '189', '201810214705', 1, '九成新', 1, '2022-03-17 12:19:00', 'myback1.png,myback2.png,myback3.png,myback4.png', '海珠校区D-11楼', 0, 1, 1, NULL);
INSERT INTO `goods` (`id`, `title`, `described`, `price`, `buy_price`, `uid`, `status`, `degree`, `category_id`, `publish_time`, `imgs`, `pickup_place`, `is_delete`, `stock`, `total_sum`, `cancel_reason`) VALUES (4, 'nike双肩包', '实体店购入 保真 保养得好', '50', '499', '201810214707', 2, '九成新', 1, '2022-03-17 12:19:00', 'img.png,img_1.png,img_2.png,img_3.png', '海珠校区北区6-110', 0, 1, 1, NULL);
INSERT INTO `goods` (`id`, `title`, `described`, `price`, `buy_price`, `uid`, `status`, `degree`, `category_id`, `publish_time`, `imgs`, `pickup_place`, `is_delete`, `stock`, `total_sum`, `cancel_reason`) VALUES (5, '篮球', '毕业离校出了 用了一学期', '20', '178', '201810214729', 1, '六成新', 7, '2022-03-17 12:19:00', 'img.png,img_1.png,img_2.png,img_3.png', '海珠校区北区6-107', 0, 1, 1, NULL);
INSERT INTO `goods` (`id`, `title`, `described`, `price`, `buy_price`, `uid`, `status`, `degree`, `category_id`, `publish_time`, `imgs`, `pickup_place`, `is_delete`, `stock`, `total_sum`, `cancel_reason`) VALUES (6, '所有男人的梦', '发光奥特曼 免费送(被女朋友骂了T.T)', '0.99', '12', '201810214729', 1, '九九新', 8, '2022-03-17 12:19:00', 'img_4.png,img_5.png,img_6.png,img_7.png', '海珠校区北区6-106', 0, 1, 1, NULL);
INSERT INTO `goods` (`id`, `title`, `described`, `price`, `buy_price`, `uid`, `status`, `degree`, `category_id`, `publish_time`, `imgs`, `pickup_place`, `is_delete`, `stock`, `total_sum`, `cancel_reason`) VALUES (8, '奥特曼神光棒', '超级酷炫黑', '4.99', '25', '201810214719', 2, '仅使用过一两次', 8, '2022-03-23 20:29:09', 'Snipaste_2022-03-20_20-02-20.png,Snipaste_2022-03-20_20-02-52.png,Snipaste_2022-03-20_20-03-05.png', '海珠南区D栋11楼', 0, 1, 1, NULL);
INSERT INTO `goods` (`id`, `title`, `described`, `price`, `buy_price`, `uid`, `status`, `degree`, `category_id`, `publish_time`, `imgs`, `pickup_place`, `is_delete`, `stock`, `total_sum`, `cancel_reason`) VALUES (9, '床上书桌 可折叠', '可以调整倾斜程度', '10', '59.9', '201810214705', 1, '9成新', 1, '2022-03-20 22:29:01', 'Snipaste_2022-03-20_22-28-27.png,Snipaste_2022-03-20_22-28-36.png,Snipaste_2022-03-20_22-28-43.png', '海珠南区D栋11楼', 0, 1, 1, NULL);
INSERT INTO `goods` (`id`, `title`, `described`, `price`, `buy_price`, `uid`, `status`, `degree`, `category_id`, `publish_time`, `imgs`, `pickup_place`, `is_delete`, `stock`, `total_sum`, `cancel_reason`) VALUES (10, '《Netty实战》', '有少量划痕', '20', '69', '201810214705', 1, '仅使用过一两次', 2, '2022-03-20 22:31:52', 'Snipaste_2022-03-20_22-30-37.png,Snipaste_2022-03-20_22-30-48.png', '海珠南区D栋11楼', 0, 1, 1, NULL);
INSERT INTO `goods` (`id`, `title`, `described`, `price`, `buy_price`, `uid`, `status`, `degree`, `category_id`, `publish_time`, `imgs`, `pickup_place`, `is_delete`, `stock`, `total_sum`, `cancel_reason`) VALUES (11, '防晒伞', '毕业了懒得带走', '5', '49', '201810214705', 1, '9成新', 4, '2022-03-20 22:35:27', 'Snipaste_2022-03-20_22-34-31.png,Snipaste_2022-03-20_22-34-46.png,Snipaste_2022-03-20_22-34-24.png,Snipaste_2022-03-20_22-34-13.png', '海珠南区D栋11楼', 0, 1, 1, '商品违规');
INSERT INTO `goods` (`id`, `title`, `described`, `price`, `buy_price`, `uid`, `status`, `degree`, `category_id`, `publish_time`, `imgs`, `pickup_place`, `is_delete`, `stock`, `total_sum`, `cancel_reason`) VALUES (12, '防晒伞 独特', '毕业了懒得带走', '20', '89', '201810214705', 2, '仅使用过一两次', 4, '2022-03-20 22:37:00', 'Snipaste_2022-03-20_22-35-55.png,Snipaste_2022-03-20_22-36-15.png', '海珠南区D栋11楼', 0, 1, 1, NULL);
INSERT INTO `goods` (`id`, `title`, `described`, `price`, `buy_price`, `uid`, `status`, `degree`, `category_id`, `publish_time`, `imgs`, `pickup_place`, `is_delete`, `stock`, `total_sum`, `cancel_reason`) VALUES (13, '座椅可爱靠垫', '放椅子上靠着非常舒服', '8.88', '40', '201810214705', 1, '8成新', 4, '2022-03-20 22:38:58', 'Snipaste_2022-03-20_22-37-45.png,Snipaste_2022-03-20_22-38-07.png,Snipaste_2022-03-20_22-37-54.png', '海珠南区D栋11楼', 0, 1, 1, NULL);
INSERT INTO `goods` (`id`, `title`, `described`, `price`, `buy_price`, `uid`, `status`, `degree`, `category_id`, `publish_time`, `imgs`, `pickup_place`, `is_delete`, `stock`, `total_sum`, `cancel_reason`) VALUES (14, '芙丽芳丝洗面奶', '全新 包装未拆', '50', '168', '201810214632', 2, '全新', 3, '2022-03-21 15:11:47', 'Snipaste_2022-03-21_09-53-22.png,Snipaste_2022-03-21_09-53-33.png,Snipaste_2022-03-21_09-54-02.png', '海珠南区D栋11楼', 0, 1, 1, NULL);
INSERT INTO `goods` (`id`, `title`, `described`, `price`, `buy_price`, `uid`, `status`, `degree`, `category_id`, `publish_time`, `imgs`, `pickup_place`, `is_delete`, `stock`, `total_sum`, `cancel_reason`) VALUES (15, '瑜伽垫 粉紫色', '在宿舍用刚刚好 很舒服', '5', '49.9', '201810214632', 2, '9成新', 7, '2022-03-21 15:12:43', 'Snipaste_2022-03-21_09-51-56.png,Snipaste_2022-03-21_09-52-25.png,Snipaste_2022-03-21_09-52-45.png', '海珠南区D栋11楼', 0, 1, 1, NULL);
INSERT INTO `goods` (`id`, `title`, `described`, `price`, `buy_price`, `uid`, `status`, `degree`, `category_id`, `publish_time`, `imgs`, `pickup_place`, `is_delete`, `stock`, `total_sum`, `cancel_reason`) VALUES (16, '芙丽芳丝泡沫洗面奶', '全新 包装未拆', '49', '', '201810214632', 1, '全新', 3, '2022-03-21 15:15:17', 'Snipaste_2022-03-21_15-14-17.png,Snipaste_2022-03-21_15-14-39.png', '海珠南区D栋11楼', 0, 1, 1, '违规商品');
INSERT INTO `goods` (`id`, `title`, `described`, `price`, `buy_price`, `uid`, `status`, `degree`, `category_id`, `publish_time`, `imgs`, `pickup_place`, `is_delete`, `stock`, `total_sum`, `cancel_reason`) VALUES (17, 'nike发带', '带包装 保证正品', '10', '30', '201910274901', 1, '全新', 7, '2022-04-10 23:12:31', 'Snipaste_2022-03-22_15-38-04.png,Snipaste_2022-03-22_15-38-18.png', '海珠校区8-709', 0, 1, 1, '');
INSERT INTO `goods` (`id`, `title`, `described`, `price`, `buy_price`, `uid`, `status`, `degree`, `category_id`, `publish_time`, `imgs`, `pickup_place`, `is_delete`, `stock`, `total_sum`, `cancel_reason`) VALUES (18, '黑色斜挎包', '只背过三四次 没有瑕疵', '40', '200', '201910274901', 1, '9成新', 1, '2022-04-10 23:13:31', 'Snipaste_2022-03-22_15-38-39.png,Snipaste_2022-03-22_15-38-53.png,Snipaste_2022-03-22_15-39-02.png,Snipaste_2022-03-22_15-39-10.png', '海珠校区8-709', 0, 1, 1, '');
INSERT INTO `goods` (`id`, `title`, `described`, `price`, `buy_price`, `uid`, `status`, `degree`, `category_id`, `publish_time`, `imgs`, `pickup_place`, `is_delete`, `stock`, `total_sum`, `cancel_reason`) VALUES (19, '眼影/卧蚕笔', '超级好用 买多了一支出', '10', '25', '201910214718', 1, '全新', 3, '2022-04-10 23:16:02', 'Snipaste_2022-04-10_23-09-49.png,Snipaste_2022-04-10_23-09-31.png,Snipaste_2022-04-10_23-09-07.png', '海珠校区北区6-119', 0, 1, 1, '');
INSERT INTO `goods` (`id`, `title`, `described`, `price`, `buy_price`, `uid`, `status`, `degree`, `category_id`, `publish_time`, `imgs`, `pickup_place`, `is_delete`, `stock`, `total_sum`, `cancel_reason`) VALUES (20, '橘朵大地色眼影盘', '这类型颜色自己有了', '20', '75', '201910214718', 1, '仅使用过一两次', 3, '2022-04-10 23:17:43', 'Snipaste_2022-04-10_23-08-42.png,Snipaste_2022-04-10_23-08-17.png,Snipaste_2022-04-10_23-08-24.png', '海珠校区北区6-119', 0, 1, 1, '');
INSERT INTO `goods` (`id`, `title`, `described`, `price`, `buy_price`, `uid`, `status`, `degree`, `category_id`, `publish_time`, `imgs`, `pickup_place`, `is_delete`, `stock`, `total_sum`, `cancel_reason`) VALUES (21, '粉扑收纳架', '很省空间 但是一直在我这里吃灰', '2', '18', '201910274902', 1, '9成新', 3, '2022-04-10 23:18:51', 'Snipaste_2022-04-10_23-06-56.png,Snipaste_2022-04-10_23-06-47.png,Snipaste_2022-04-10_23-06-41.png', '海珠校区8-109', 0, 1, 1, '');
INSERT INTO `goods` (`id`, `title`, `described`, `price`, `buy_price`, `uid`, `status`, `degree`, `category_id`, `publish_time`, `imgs`, `pickup_place`, `is_delete`, `stock`, `total_sum`, `cancel_reason`) VALUES (22, '尔木萄粉扑', '有三个 一个3元 可直接联系', '3', '10', '201710274902', 2, '全新', 3, '2022-04-10 23:27:30', 'Snipaste_2022-04-10_23-06-14.png,Snipaste_2022-04-10_23-05-59.png,Snipaste_2022-04-10_23-05-48.png', '海珠校区7-109', 0, 1, 1, '');
INSERT INTO `goods` (`id`, `title`, `described`, `price`, `buy_price`, `uid`, `status`, `degree`, `category_id`, `publish_time`, `imgs`, `pickup_place`, `is_delete`, `stock`, `total_sum`, `cancel_reason`) VALUES (23, '《天才在左》', '阅读过2次 无阅读痕迹', '5', '45', '201810214719', 2, '9成新', 1, '2022-04-10 23:28:51', 'Snipaste_2022-04-10_23-05-11.png,Snipaste_2022-04-10_23-05-04.png,Snipaste_2022-04-10_23-04-58.png', '海珠南区D栋11楼', 0, 1, 1, '');
INSERT INTO `goods` (`id`, `title`, `described`, `price`, `buy_price`, `uid`, `status`, `degree`, `category_id`, `publish_time`, `imgs`, `pickup_place`, `is_delete`, `stock`, `total_sum`, `cancel_reason`) VALUES (24, '多功能煮锅', '用过两三次 毕业了出', '40', '189', '201810214719', 2, '8成新', 4, '2022-04-10 23:29:56', 'Snipaste_2022-04-10_22-59-21.png,Snipaste_2022-04-10_22-59-34.png,Snipaste_2022-04-10_22-59-40.png', '海珠南区D栋11楼', 0, 1, 1, '');
INSERT INTO `goods` (`id`, `title`, `described`, `price`, `buy_price`, `uid`, `status`, `degree`, `category_id`, `publish_time`, `imgs`, `pickup_place`, `is_delete`, `stock`, `total_sum`, `cancel_reason`) VALUES (25, '三排插可爱', '毕业了出', '10', '38', '201810214719', 2, '8成新', 4, '2022-04-10 23:31:11', 'Snipaste_2022-04-10_23-00-29.png,Snipaste_2022-04-10_23-01-02.png,Snipaste_2022-04-10_23-01-02.png,Snipaste_2022-04-10_23-00-45.png', '海珠南区D栋11楼', 0, 1, 1, '');
INSERT INTO `goods` (`id`, `title`, `described`, `price`, `buy_price`, `uid`, `status`, `degree`, `category_id`, `publish_time`, `imgs`, `pickup_place`, `is_delete`, `stock`, `total_sum`, `cancel_reason`) VALUES (26, '超级凉爽', '一直用着 毕业不带走', '30', '112', '201810214719', 1, '8成新', 4, '2022-04-10 23:32:27', 'Snipaste_2022-04-10_23-02-03.png,Snipaste_2022-04-10_23-02-03.png,Snipaste_2022-04-10_23-02-13.png', '海珠南区D栋11楼', 0, 1, 1, '');
INSERT INTO `goods` (`id`, `title`, `described`, `price`, `buy_price`, `uid`, `status`, `degree`, `category_id`, `publish_time`, `imgs`, `pickup_place`, `is_delete`, `stock`, `total_sum`, `cancel_reason`) VALUES (27, '《被讨厌的勇气》', '已读完 无阅读痕迹', '15', '65', '201810214719', 2, '仅使用过一两次', 1, '2022-04-10 23:33:48', 'Snipaste_2022-04-10_23-04-26.png,Snipaste_2022-04-10_23-04-35.png', '海珠南区D栋11楼', 0, 1, 1, '');
INSERT INTO `goods` (`id`, `title`, `described`, `price`, `buy_price`, `uid`, `status`, `degree`, `category_id`, `publish_time`, `imgs`, `pickup_place`, `is_delete`, `stock`, `total_sum`, `cancel_reason`) VALUES (28, '从你的全世界路过', '非常好的书 读过几次了', '2', '48', '201810214719', 2, '有轻微瑕疵', 1, '2022-04-10 23:34:25', 'Snipaste_2022-04-10_23-03-58.png,Snipaste_2022-04-10_23-04-10.png', '海珠南区D栋11楼', 0, 1, 1, '');
INSERT INTO `goods` (`id`, `title`, `described`, `price`, `buy_price`, `uid`, `status`, `degree`, `category_id`, `publish_time`, `imgs`, `pickup_place`, `is_delete`, `stock`, `total_sum`, `cancel_reason`) VALUES (29, '水杯 免费送', '全新 带包装', '1', '15', '201810214719', 2, '全新', 4, '2022-04-10 23:35:14', 'Snipaste_2022-04-10_23-01-20.png,Snipaste_2022-04-10_23-01-36.png', '海珠南区D栋11楼', 0, 1, 1, '');
INSERT INTO `goods` (`id`, `title`, `described`, `price`, `buy_price`, `uid`, `status`, `degree`, `category_id`, `publish_time`, `imgs`, `pickup_place`, `is_delete`, `stock`, `total_sum`, `cancel_reason`) VALUES (30, '火锅漏勺', '烫粉必备', '2', '13', '201810214719', 2, '8成新', 6, '2022-04-10 23:36:24', 'Snipaste_2022-04-10_23-03-17.png,Snipaste_2022-04-10_23-03-10.png,Snipaste_2022-04-10_23-03-25.png', '海珠南区D栋11楼', 0, 1, 1, '');
INSERT INTO `goods` (`id`, `title`, `described`, `price`, `buy_price`, `uid`, `status`, `degree`, `category_id`, `publish_time`, `imgs`, `pickup_place`, `is_delete`, `stock`, `total_sum`, `cancel_reason`) VALUES (31, '拖鞋 全新', '超柔软拖鞋 质量很好', '10', '25', '201810214719', 3, '全新', 4, '2022-04-12 14:23:39', 'Snipaste_2022-04-10_23-38-45.png,Snipaste_2022-04-10_23-39-24.png', '海珠南区D栋11楼', 1, 1, 1, '自主下架');
INSERT INTO `goods` (`id`, `title`, `described`, `price`, `buy_price`, `uid`, `status`, `degree`, `category_id`, `publish_time`, `imgs`, `pickup_place`, `is_delete`, `stock`, `total_sum`, `cancel_reason`) VALUES (32, '棕褐色染发剂', '没拆封过 这款很好不伤头发', '45', '99', '201810214719', 2, '全新', 3, '2022-04-12 14:24:29', 'Snipaste_2022-04-10_23-42-36.png,Snipaste_2022-04-10_23-42-26.png', '海珠南区D栋11楼', 0, 1, 1, '');
INSERT INTO `goods` (`id`, `title`, `described`, `price`, `buy_price`, `uid`, `status`, `degree`, `category_id`, `publish_time`, `imgs`, `pickup_place`, `is_delete`, `stock`, `total_sum`, `cancel_reason`) VALUES (33, '110cm抱枕', '很舒服 很干净', '20', '130', '202020215201', 1, '全新', 4, '2022-04-12 14:25:42', 'Snipaste_2022-04-10_23-39-34.png,Snipaste_2022-04-10_23-39-40.png,Snipaste_2022-04-10_23-39-56.png', '海珠校区7-509', 0, 1, 1, '');
INSERT INTO `goods` (`id`, `title`, `described`, `price`, `buy_price`, `uid`, `status`, `degree`, `category_id`, `publish_time`, `imgs`, `pickup_place`, `is_delete`, `stock`, `total_sum`, `cancel_reason`) VALUES (34, '兔子摆件', '在宿舍不适合用 租房可以', '100', '218', '202020215201', 1, '9成新', 6, '2022-04-12 14:26:32', 'Snipaste_2022-04-10_23-40-20.png,Snipaste_2022-04-10_23-40-27.png,Snipaste_2022-04-10_23-40-36.png', '海珠校区7-509', 0, 1, 1, '');
INSERT INTO `goods` (`id`, `title`, `described`, `price`, `buy_price`, `uid`, `status`, `degree`, `category_id`, `publish_time`, `imgs`, `pickup_place`, `is_delete`, `stock`, `total_sum`, `cancel_reason`) VALUES (35, '40码白色拖鞋', '纯白色 不是米色', '5', '25', '202020215201', 1, '全新', 4, '2022-04-12 14:27:22', 'Snipaste_2022-04-10_23-40-59.png', '海珠校区7-509', 0, 1, 1, '');
INSERT INTO `goods` (`id`, `title`, `described`, `price`, `buy_price`, `uid`, `status`, `degree`, `category_id`, `publish_time`, `imgs`, `pickup_place`, `is_delete`, `stock`, `total_sum`, `cancel_reason`) VALUES (36, '红白格子长裤', '裤长102 拖地裤', '25', '78', '201710274902', 1, '全新', 5, '2022-04-12 14:28:26', 'Snipaste_2022-04-10_23-41-43.png,Snipaste_2022-04-10_23-41-51.png,Snipaste_2022-04-10_23-41-33.png', '海珠校区7-109', 0, 1, 1, '');
INSERT INTO `goods` (`id`, `title`, `described`, `price`, `buy_price`, `uid`, `status`, `degree`, `category_id`, `publish_time`, `imgs`, `pickup_place`, `is_delete`, `stock`, `total_sum`, `cancel_reason`) VALUES (37, '38码粉色拖鞋', '淡粉色+一点荧光', '7', '25', '201710274902', 1, '全新', 4, '2022-04-12 14:28:56', 'Snipaste_2022-04-10_23-41-08.png', '海珠校区7-109', 0, 1, 1, '');
INSERT INTO `goods` (`id`, `title`, `described`, `price`, `buy_price`, `uid`, `status`, `degree`, `category_id`, `publish_time`, `imgs`, `pickup_place`, `is_delete`, `stock`, `total_sum`, `cancel_reason`) VALUES (38, '36码淡紫色拖鞋', '很好看的颜色 少女心max', '9', '25', '201810214632', 1, '全新', 5, '2022-04-12 14:29:45', 'Snipaste_2022-04-10_23-41-13.png', '海珠南区D栋11楼', 0, 1, 1, '');
INSERT INTO `goods` (`id`, `title`, `described`, `price`, `buy_price`, `uid`, `status`, `degree`, `category_id`, `publish_time`, `imgs`, `pickup_place`, `is_delete`, `stock`, `total_sum`, `cancel_reason`) VALUES (39, '针织条纹长袖', '质量超级好 针线做工都很nice', '10', '79', '202010340105', 1, '9成新', 5, '2022-04-12 14:40:01', 'Snipaste_2022-04-12_14-30-52.png', '海珠校区B-112', 0, 1, 1, '');
INSERT INTO `goods` (`id`, `title`, `described`, `price`, `buy_price`, `uid`, `status`, `degree`, `category_id`, `publish_time`, `imgs`, `pickup_place`, `is_delete`, `stock`, `total_sum`, `cancel_reason`) VALUES (40, 'v领黑色长袖', '有点假两件的样子', '20', '109', '202010340105', 2, '全新', 5, '2022-04-12 14:40:27', 'Snipaste_2022-04-12_14-31-03.png', '海珠校区B-112', 0, 1, 1, '');
INSERT INTO `goods` (`id`, `title`, `described`, `price`, `buy_price`, `uid`, `status`, `degree`, `category_id`, `publish_time`, `imgs`, `pickup_place`, `is_delete`, `stock`, `total_sum`, `cancel_reason`) VALUES (41, '民族风卫衣', '男友风的一个卫衣', '13', '68', '202010340105', 1, '9成新', 5, '2022-04-12 14:40:56', 'Snipaste_2022-04-12_14-31-09.png', '海珠校区B-112', 0, 1, 1, '');
INSERT INTO `goods` (`id`, `title`, `described`, `price`, `buy_price`, `uid`, `status`, `degree`, `category_id`, `publish_time`, `imgs`, `pickup_place`, `is_delete`, `stock`, `total_sum`, `cancel_reason`) VALUES (42, '西装外套', '适合小个子 袖子比较短', '43', '129', '202010340106', 1, '仅使用过一两次', 5, '2022-04-12 14:41:43', 'Snipaste_2022-04-12_14-31-17.png', '海珠校区B-113', 0, 1, 1, '');
INSERT INTO `goods` (`id`, `title`, `described`, `price`, `buy_price`, `uid`, `status`, `degree`, `category_id`, `publish_time`, `imgs`, `pickup_place`, `is_delete`, `stock`, `total_sum`, `cancel_reason`) VALUES (43, '超软糯卫衣', '可以来宿舍试穿', '98', '378', '202010340106', 1, '全新', 5, '2022-04-12 14:42:11', 'Snipaste_2022-04-12_14-31-24.png', '海珠校区B-113', 0, 1, 1, '');
INSERT INTO `goods` (`id`, `title`, `described`, `price`, `buy_price`, `uid`, `status`, `degree`, `category_id`, `publish_time`, `imgs`, `pickup_place`, `is_delete`, `stock`, `total_sum`, `cancel_reason`) VALUES (44, '汉服正版', '超好看的颜色', '189', '598', '202010340106', 2, '仅使用过一两次', 5, '2022-04-12 14:42:51', 'Snipaste_2022-04-12_14-31-35.png', '海珠校区B-113', 0, 1, 1, '');
INSERT INTO `goods` (`id`, `title`, `described`, `price`, `buy_price`, `uid`, `status`, `degree`, `category_id`, `publish_time`, `imgs`, `pickup_place`, `is_delete`, `stock`, `total_sum`, `cancel_reason`) VALUES (45, '古装衣服', '适合小个子160-', '178', '478', '202010340106', 1, '仅使用过一两次', 4, '2022-04-12 14:43:20', 'Snipaste_2022-04-12_14-31-44.png', '海珠校区B-113', 0, 1, 1, '');
INSERT INTO `goods` (`id`, `title`, `described`, `price`, `buy_price`, `uid`, `status`, `degree`, `category_id`, `publish_time`, `imgs`, `pickup_place`, `is_delete`, `stock`, `total_sum`, `cancel_reason`) VALUES (46, '半身裙 超显瘦', '高个子来168+', '20', '88', '202010340107', 2, '仅使用过一两次', 5, '2022-04-12 14:44:08', 'Snipaste_2022-04-12_14-32-00.png', '海珠校区B-114', 0, 1, 1, '');
INSERT INTO `goods` (`id`, `title`, `described`, `price`, `buy_price`, `uid`, `status`, `degree`, `category_id`, `publish_time`, `imgs`, `pickup_place`, `is_delete`, `stock`, `total_sum`, `cancel_reason`) VALUES (47, '松糕鞋38码', '绿色很正 和图片一样', '30', '89', '202010340107', 1, '全新', 7, '2022-04-12 14:44:37', 'Snipaste_2022-04-12_14-32-28.png', '海珠校区B-114', 0, 1, 1, '');
INSERT INTO `goods` (`id`, `title`, `described`, `price`, `buy_price`, `uid`, `status`, `degree`, `category_id`, `publish_time`, `imgs`, `pickup_place`, `is_delete`, `stock`, `total_sum`, `cancel_reason`) VALUES (48, '厨房置物架', '租房必备', '5', '30', '202010340109', 1, '9成新', 6, '2022-04-12 14:45:21', 'Snipaste_2022-04-12_14-33-33.png', '海珠校区B-116', 0, 1, 1, '');
INSERT INTO `goods` (`id`, `title`, `described`, `price`, `buy_price`, `uid`, `status`, `degree`, `category_id`, `publish_time`, `imgs`, `pickup_place`, `is_delete`, `stock`, `total_sum`, `cancel_reason`) VALUES (49, '抽纸盒', '没有挂钩自己买一个吧', '1', '19', '202010340109', 1, '8成新', 6, '2022-04-12 14:45:52', 'Snipaste_2022-04-12_14-33-48.png', '海珠校区B-116', 0, 1, 1, '');
INSERT INTO `goods` (`id`, `title`, `described`, `price`, `buy_price`, `uid`, `status`, `degree`, `category_id`, `publish_time`, `imgs`, `pickup_place`, `is_delete`, `stock`, `total_sum`, `cancel_reason`) VALUES (50, '运动鞋36码', '松糕鞋', '5', '98', '202010340109', 1, '8成新', 7, '2022-04-12 14:46:21', 'Snipaste_2022-04-12_14-32-38.png', '海珠校区B-116', 0, 1, 1, '');
INSERT INTO `goods` (`id`, `title`, `described`, `price`, `buy_price`, `uid`, `status`, `degree`, `category_id`, `publish_time`, `imgs`, `pickup_place`, `is_delete`, `stock`, `total_sum`, `cancel_reason`) VALUES (51, '蘸料架', '承重力很好', '4', '35', '202010340104', 1, '8成新', 6, '2022-04-12 14:47:11', 'Snipaste_2022-04-12_14-33-28.png', '海珠校区B-111', 0, 1, 1, '');
INSERT INTO `goods` (`id`, `title`, `described`, `price`, `buy_price`, `uid`, `status`, `degree`, `category_id`, `publish_time`, `imgs`, `pickup_place`, `is_delete`, `stock`, `total_sum`, `cancel_reason`) VALUES (52, '厨房收纳五件套', '厨房必备 租房快来入手', '30', '79', '202010340104', 1, '仅使用过一两次', 6, '2022-04-12 14:47:56', 'Snipaste_2022-04-12_14-33-10.png', '海珠校区B-111', 0, 1, 1, '');
INSERT INTO `goods` (`id`, `title`, `described`, `price`, `buy_price`, `uid`, `status`, `degree`, `category_id`, `publish_time`, `imgs`, `pickup_place`, `is_delete`, `stock`, `total_sum`, `cancel_reason`) VALUES (53, '木勺', '安全材质 不会发霉', '100', '188', '202010340104', 3, '全新', 6, '2022-04-12 14:49:01', 'Snipaste_2022-04-12_14-32-47.png', '海珠校区B-111', 0, 1, 1, '不卫生');
INSERT INTO `goods` (`id`, `title`, `described`, `price`, `buy_price`, `uid`, `status`, `degree`, `category_id`, `publish_time`, `imgs`, `pickup_place`, `is_delete`, `stock`, `total_sum`, `cancel_reason`) VALUES (54, '厨房收纳架', '有三层 可以放很多东西', '20', '98', '202010340101', 1, '8成新', 6, '2022-04-12 14:49:51', 'Snipaste_2022-04-12_14-33-02.png', '海珠校区B-509', 0, 1, 1, '');
INSERT INTO `goods` (`id`, `title`, `described`, `price`, `buy_price`, `uid`, `status`, `degree`, `category_id`, `publish_time`, `imgs`, `pickup_place`, `is_delete`, `stock`, `total_sum`, `cancel_reason`) VALUES (55, '奥特曼项链', '按一下会发光', '2', '14', '201810214719', 1, '仅使用过一两次', 8, '2022-04-12 14:56:11', 'Snipaste_2022-04-12_14-51-26.png', '海珠南区D栋11楼', 0, 1, 1, '');
INSERT INTO `goods` (`id`, `title`, `described`, `price`, `buy_price`, `uid`, `status`, `degree`, `category_id`, `publish_time`, `imgs`, `pickup_place`, `is_delete`, `stock`, `total_sum`, `cancel_reason`) VALUES (56, '哑铃10kg', '可调整重量', '79', '189', '201810214719', 3, '9成新', 7, '2022-04-12 14:56:45', 'Snipaste_2022-04-12_14-54-58.png', '海珠南区D栋11楼', 1, 1, 1, '自主下架');
INSERT INTO `goods` (`id`, `title`, `described`, `price`, `buy_price`, `uid`, `status`, `degree`, `category_id`, `publish_time`, `imgs`, `pickup_place`, `is_delete`, `stock`, `total_sum`, `cancel_reason`) VALUES (57, '儿童玩具 安全', '本来想送给侄女的', '54', '109', '201810214719', 2, '全新', 8, '2022-04-12 14:57:25', 'Snipaste_2022-04-12_14-51-32.png', '海珠南区D栋11楼', 0, 1, 1, '');
INSERT INTO `goods` (`id`, `title`, `described`, `price`, `buy_price`, `uid`, `status`, `degree`, `category_id`, `publish_time`, `imgs`, `pickup_place`, `is_delete`, `stock`, `total_sum`, `cancel_reason`) VALUES (58, '女生哑铃2kg', '颜色很好看', '30', '78', '201810214705', 1, '全新', 7, '2022-04-12 14:58:31', 'Snipaste_2022-04-12_14-55-04.png', '海珠南区D栋11楼', 0, 1, 1, '');
INSERT INTO `goods` (`id`, `title`, `described`, `price`, `buy_price`, `uid`, `status`, `degree`, `category_id`, `publish_time`, `imgs`, `pickup_place`, `is_delete`, `stock`, `total_sum`, `cancel_reason`) VALUES (59, '四驱车', '可做一个5岁男童', '59', '356', '201810214705', 1, '9成新', 8, '2022-04-12 14:59:10', 'Snipaste_2022-04-12_14-51-42.png', '海珠南区D栋11楼', 0, 1, 1, '');
INSERT INTO `goods` (`id`, `title`, `described`, `price`, `buy_price`, `uid`, `status`, `degree`, `category_id`, `publish_time`, `imgs`, `pickup_place`, `is_delete`, `stock`, `total_sum`, `cancel_reason`) VALUES (60, '玩偶正品', '没拆封', '99', '188', '202010340105', 2, '全新', 8, '2022-04-12 14:59:55', 'Snipaste_2022-04-12_14-51-59.png', '海珠校区B-112', 0, 1, 1, '');
INSERT INTO `goods` (`id`, `title`, `described`, `price`, `buy_price`, `uid`, `status`, `degree`, `category_id`, `publish_time`, `imgs`, `pickup_place`, `is_delete`, `stock`, `total_sum`, `cancel_reason`) VALUES (61, '小哑铃1kg', '小孩子可以用', '2', '23', '202010340105', 1, '8成新', 7, '2022-04-12 15:00:28', 'Snipaste_2022-04-12_14-54-52.png', '海珠校区B-112', 0, 1, 1, '');
INSERT INTO `goods` (`id`, `title`, `described`, `price`, `buy_price`, `uid`, `status`, `degree`, `category_id`, `publish_time`, `imgs`, `pickup_place`, `is_delete`, `stock`, `total_sum`, `cancel_reason`) VALUES (62, '荣耀手环', '全新 可监测心跳等', '100', '256', '202010340105', 2, '全新', 7, '2022-04-12 15:01:12', 'Snipaste_2022-04-12_14-54-32.png', '海珠校区B-112', 0, 1, 1, '');
INSERT INTO `goods` (`id`, `title`, `described`, `price`, `buy_price`, `uid`, `status`, `degree`, `category_id`, `publish_time`, `imgs`, `pickup_place`, `is_delete`, `stock`, `total_sum`, `cancel_reason`) VALUES (63, '可爱小羊玩偶', '60cm左右', '40', '59', '202010340101', 1, '全新', 8, '2022-04-12 15:02:24', 'Snipaste_2022-04-12_14-52-08.png', '海珠校区B-509', 0, 1, 1, '');
INSERT INTO `goods` (`id`, `title`, `described`, `price`, `buy_price`, `uid`, `status`, `degree`, `category_id`, `publish_time`, `imgs`, `pickup_place`, `is_delete`, `stock`, `total_sum`, `cancel_reason`) VALUES (64, '电脑椅', '用了一学期', '30', '239', '202010340101', 2, '8成新', 6, '2022-04-12 15:02:50', 'Snipaste_2022-04-12_14-53-52.png', '海珠校区B-509', 0, 1, 1, '');
INSERT INTO `goods` (`id`, `title`, `described`, `price`, `buy_price`, `uid`, `status`, `degree`, `category_id`, `publish_time`, `imgs`, `pickup_place`, `is_delete`, `stock`, `total_sum`, `cancel_reason`) VALUES (65, '草绿色短袖', '针织的', '10', '45', '201810214719', 2, '9成新', 5, '2022-04-12 15:03:40', 'Snipaste_2022-04-12_14-54-06.png', '海珠南区D栋11楼', 0, 1, 1, '');
INSERT INTO `goods` (`id`, `title`, `described`, `price`, `buy_price`, `uid`, `status`, `degree`, `category_id`, `publish_time`, `imgs`, `pickup_place`, `is_delete`, `stock`, `total_sum`, `cancel_reason`) VALUES (66, '碎花裙', '170到脚裸', '40', '145', '201810214719', 1, '9成新', 5, '2022-04-12 15:04:08', 'Snipaste_2022-04-12_14-52-27.png', '海珠南区D栋11楼', 0, 1, 1, '');
INSERT INTO `goods` (`id`, `title`, `described`, `price`, `buy_price`, `uid`, `status`, `degree`, `category_id`, `publish_time`, `imgs`, `pickup_place`, `is_delete`, `stock`, `total_sum`, `cancel_reason`) VALUES (67, '半身牛仔裙', '170长度刚好', '20', '79', '201810214719', 1, '全新', 5, '2022-04-12 15:04:30', 'Snipaste_2022-04-12_14-52-31.png', '海珠南区D栋11楼', 0, 1, 1, '');
INSERT INTO `goods` (`id`, `title`, `described`, `price`, `buy_price`, `uid`, `status`, `degree`, `category_id`, `publish_time`, `imgs`, `pickup_place`, `is_delete`, `stock`, `total_sum`, `cancel_reason`) VALUES (68, '玩偶', '正品', '99', '299', '201810214719', 2, '全新', 8, '2022-04-12 15:04:53', 'Snipaste_2022-04-12_14-52-51.png', '海珠南区D栋11楼', 0, 1, 1, '');
INSERT INTO `goods` (`id`, `title`, `described`, `price`, `buy_price`, `uid`, `status`, `degree`, `category_id`, `publish_time`, `imgs`, `pickup_place`, `is_delete`, `stock`, `total_sum`, `cancel_reason`) VALUES (69, '碎花裙', '绿色', '10', '45', '202010340109', 2, '9成新', 5, '2022-04-12 15:05:41', 'Snipaste_2022-04-12_14-52-58.png', '海珠校区B-116', 0, 1, 1, '');
INSERT INTO `goods` (`id`, `title`, `described`, `price`, `buy_price`, `uid`, `status`, `degree`, `category_id`, `publish_time`, `imgs`, `pickup_place`, `is_delete`, `stock`, `total_sum`, `cancel_reason`) VALUES (70, '猪仔玩偶', '70cm左右', '20', '102', '202010340109', 1, '9成新', 8, '2022-04-12 15:06:08', 'Snipaste_2022-04-12_14-53-09.png', '海珠校区B-116', 0, 1, 1, '');
INSERT INTO `goods` (`id`, `title`, `described`, `price`, `buy_price`, `uid`, `status`, `degree`, `category_id`, `publish_time`, `imgs`, `pickup_place`, `is_delete`, `stock`, `total_sum`, `cancel_reason`) VALUES (71, '办公椅', '很舒服', '30', '109', '202010340109', 2, '9成新', 6, '2022-04-12 15:06:31', 'Snipaste_2022-04-12_14-53-58.png', '海珠校区B-116', 0, 1, 1, '');
INSERT INTO `goods` (`id`, `title`, `described`, `price`, `buy_price`, `uid`, `status`, `degree`, `category_id`, `publish_time`, `imgs`, `pickup_place`, `is_delete`, `stock`, `total_sum`, `cancel_reason`) VALUES (72, '男鞋44码', '全新全新', '100', '', '202010340104', 1, '全新', 5, '2022-04-16 22:22:29', 'Snipaste_2022-04-16_22-09-24.png', '白云校区B-111', 0, 1, 1, '');
INSERT INTO `goods` (`id`, `title`, `described`, `price`, `buy_price`, `uid`, `status`, `degree`, `category_id`, `publish_time`, `imgs`, `pickup_place`, `is_delete`, `stock`, `total_sum`, `cancel_reason`) VALUES (73, '短袖XL', '仅试穿', '20', '', '202010340104', 1, '全新', 5, '2022-04-16 22:22:57', 'Snipaste_2022-04-16_22-09-32.png', '海珠校区B-111', 0, 1, 1, '');
INSERT INTO `goods` (`id`, `title`, `described`, `price`, `buy_price`, `uid`, `status`, `degree`, `category_id`, `publish_time`, `imgs`, `pickup_place`, `is_delete`, `stock`, `total_sum`, `cancel_reason`) VALUES (74, '男鞋40', '爸爸可以穿', '99', '', '202010340101', 1, '全新', 7, '2022-04-16 22:24:31', 'Snipaste_2022-04-16_22-09-59.png', '白云校区B-509', 0, 1, 1, '');
INSERT INTO `goods` (`id`, `title`, `described`, `price`, `buy_price`, `uid`, `status`, `degree`, `category_id`, `publish_time`, `imgs`, `pickup_place`, `is_delete`, `stock`, `total_sum`, `cancel_reason`) VALUES (75, '精致项链', '戴过一星期', '50', '', '202010340107', 1, '9成新', 5, '2022-04-16 22:29:25', 'Snipaste_2022-04-16_22-11-07.png', '白云校区B-114', 0, 1, 1, '');
INSERT INTO `goods` (`id`, `title`, `described`, `price`, `buy_price`, `uid`, `status`, `degree`, `category_id`, `publish_time`, `imgs`, `pickup_place`, `is_delete`, `stock`, `total_sum`, `cancel_reason`) VALUES (76, '牛仔裤', '170穿起来如图', '20', '', '202010340107', 1, '全新', 5, '2022-04-16 22:30:22', 'Snipaste_2022-04-16_22-11-28.png,Snipaste_2022-04-16_22-11-46.png', '海珠校区B-114', 0, 1, 1, '');
INSERT INTO `goods` (`id`, `title`, `described`, `price`, `buy_price`, `uid`, `status`, `degree`, `category_id`, `publish_time`, `imgs`, `pickup_place`, `is_delete`, `stock`, `total_sum`, `cancel_reason`) VALUES (77, '盲盒', '已拆开', '18', '', '202010340107', 2, '全新', 8, '2022-04-16 22:30:43', 'Snipaste_2022-04-16_22-11-55.png', '海珠校区B-114', 0, 1, 1, '');
INSERT INTO `goods` (`id`, `title`, `described`, `price`, `buy_price`, `uid`, `status`, `degree`, `category_id`, `publish_time`, `imgs`, `pickup_place`, `is_delete`, `stock`, `total_sum`, `cancel_reason`) VALUES (78, '女鞋', '精致小姐姐来', '40', '', '202010340107', 1, '9成新', 5, '2022-04-16 22:31:06', 'Snipaste_2022-04-16_22-12-21.png', '海珠校区B-114', 0, 1, 1, '');
INSERT INTO `goods` (`id`, `title`, `described`, `price`, `buy_price`, `uid`, `status`, `degree`, `category_id`, `publish_time`, `imgs`, `pickup_place`, `is_delete`, `stock`, `total_sum`, `cancel_reason`) VALUES (79, '解压神器', '很可爱 3个一起出了', '5', '', '202010340107', 1, '全新', 8, '2022-04-16 22:31:30', 'Snipaste_2022-04-16_22-12-55.png', '海珠校区B-114', 0, 1, 1, '');
INSERT INTO `goods` (`id`, `title`, `described`, `price`, `buy_price`, `uid`, `status`, `degree`, `category_id`, `publish_time`, `imgs`, `pickup_place`, `is_delete`, `stock`, `total_sum`, `cancel_reason`) VALUES (80, '干皮遮瑕', '油皮别买', '59', '', '202010340107', 1, '全新', 3, '2022-04-16 22:31:58', 'Snipaste_2022-04-16_22-13-12.png', '海珠校区B-114', 0, 1, 1, '');
INSERT INTO `goods` (`id`, `title`, `described`, `price`, `buy_price`, `uid`, `status`, `degree`, `category_id`, `publish_time`, `imgs`, `pickup_place`, `is_delete`, `stock`, `total_sum`, `cancel_reason`) VALUES (81, '适乐肤', '凑单买的', '58', '120', '201810214719', 1, '全新', 3, '2022-04-16 22:33:09', 'Snipaste_2022-04-16_22-13-34.png', '海珠南区D栋11楼', 0, 1, 1, '');
INSERT INTO `goods` (`id`, `title`, `described`, `price`, `buy_price`, `uid`, `status`, `degree`, `category_id`, `publish_time`, `imgs`, `pickup_place`, `is_delete`, `stock`, `total_sum`, `cancel_reason`) VALUES (82, '盲盒', '已经拆了', '15', '', '201810214719', 1, '全新', 8, '2022-04-16 22:33:26', 'Snipaste_2022-04-16_22-13-42.png', '海珠南区D栋11楼', 0, 1, 1, '自主下架');
INSERT INTO `goods` (`id`, `title`, `described`, `price`, `buy_price`, `uid`, `status`, `degree`, `category_id`, `publish_time`, `imgs`, `pickup_place`, `is_delete`, `stock`, `total_sum`, `cancel_reason`) VALUES (83, '冰袋', '有两个 一个5元', '5', '', '201810214719', 1, '全新', 4, '2022-04-16 22:34:11', 'Snipaste_2022-04-16_22-13-58.png,Snipaste_2022-04-16_22-14-03.png', '海珠南区D栋11楼', 0, 1, 1, '');
INSERT INTO `goods` (`id`, `title`, `described`, `price`, `buy_price`, `uid`, `status`, `degree`, `category_id`, `publish_time`, `imgs`, `pickup_place`, `is_delete`, `stock`, `total_sum`, `cancel_reason`) VALUES (84, '除蟑螂', '有五六个，一个2元', '2', '', '201810214719', 1, '全新', 4, '2022-04-16 22:34:40', 'Snipaste_2022-04-16_22-14-24.png', '海珠南区D栋11楼', 0, 1, 1, '');
INSERT INTO `goods` (`id`, `title`, `described`, `price`, `buy_price`, `uid`, `status`, `degree`, `category_id`, `publish_time`, `imgs`, `pickup_place`, `is_delete`, `stock`, `total_sum`, `cancel_reason`) VALUES (85, '《狼王梦》', '看过一次', '49', '', '202120215202', 1, '全新', 2, '2022-04-16 22:35:41', 'Snipaste_2022-04-16_22-19-35.png', '海珠校区B-109', 0, 1, 1, '');
INSERT INTO `goods` (`id`, `title`, `described`, `price`, `buy_price`, `uid`, `status`, `degree`, `category_id`, `publish_time`, `imgs`, `pickup_place`, `is_delete`, `stock`, `total_sum`, `cancel_reason`) VALUES (86, '摆件', '粉色小花', '19', '', '202120215202', 1, '全新', 6, '2022-04-16 22:36:04', 'Snipaste_2022-04-16_22-14-36.png', '海珠校区B-109', 0, 1, 1, '');
INSERT INTO `goods` (`id`, `title`, `described`, `price`, `buy_price`, `uid`, `status`, `degree`, `category_id`, `publish_time`, `imgs`, `pickup_place`, `is_delete`, `stock`, `total_sum`, `cancel_reason`) VALUES (87, '笔记本', '3本一起出了', '8', '', '202120215202', 2, '全新', 1, '2022-04-16 22:36:34', 'Snipaste_2022-04-16_22-15-41.png', '海珠校区B-109', 0, 1, 1, '');
INSERT INTO `goods` (`id`, `title`, `described`, `price`, `buy_price`, `uid`, `status`, `degree`, `category_id`, `publish_time`, `imgs`, `pickup_place`, `is_delete`, `stock`, `total_sum`, `cancel_reason`) VALUES (88, '支架', '可以用来放平板', '3', '', '202120215202', 1, '9成新', 6, '2022-04-16 22:37:03', 'Snipaste_2022-04-16_22-16-49.png', '海珠校区B-109', 0, 1, 1, '');
INSERT INTO `goods` (`id`, `title`, `described`, `price`, `buy_price`, `uid`, `status`, `degree`, `category_id`, `publish_time`, `imgs`, `pickup_place`, `is_delete`, `stock`, `total_sum`, `cancel_reason`) VALUES (89, '小说', '很好', '12', '', '202120215202', 1, '全新', 2, '2022-04-16 22:37:27', 'Snipaste_2022-04-16_22-16-18.png', '海珠校区B-109', 0, 1, 1, '');
INSERT INTO `goods` (`id`, `title`, `described`, `price`, `buy_price`, `uid`, `status`, `degree`, `category_id`, `publish_time`, `imgs`, `pickup_place`, `is_delete`, `stock`, `total_sum`, `cancel_reason`) VALUES (90, '收纳盒', '装过白糖', '1', '', '201810214705', 1, '8成新', 6, '2022-04-16 22:38:52', 'Snipaste_2022-04-16_22-17-05.png', '海珠南区D栋11楼', 0, 1, 1, '');
INSERT INTO `goods` (`id`, `title`, `described`, `price`, `buy_price`, `uid`, `status`, `degree`, `category_id`, `publish_time`, `imgs`, `pickup_place`, `is_delete`, `stock`, `total_sum`, `cancel_reason`) VALUES (91, '中性笔', '三个颜色都有', '3', '', '201810214707', 2, '全新', 1, '2022-04-16 22:40:21', 'Snipaste_2022-04-16_22-18-58.png', '海珠北区6110', 0, 1, 1, '');
INSERT INTO `goods` (`id`, `title`, `described`, `price`, `buy_price`, `uid`, `status`, `degree`, `category_id`, `publish_time`, `imgs`, `pickup_place`, `is_delete`, `stock`, `total_sum`, `cancel_reason`) VALUES (92, '便利贴', '三本100张', '2', '', '201810214707', 2, '全新', 1, '2022-04-16 22:40:57', 'Snipaste_2022-04-16_22-20-58.png', '白云北区6110', 0, 1, 1, '');
INSERT INTO `goods` (`id`, `title`, `described`, `price`, `buy_price`, `uid`, `status`, `degree`, `category_id`, `publish_time`, `imgs`, `pickup_place`, `is_delete`, `stock`, `total_sum`, `cancel_reason`) VALUES (93, '衣架杆', '可以放宿舍阳台', '12', '', '201810214719', 3, '全新', 4, '2022-04-16 22:42:24', 'Snipaste_2022-04-16_22-20-38.png', '海珠南区D栋11楼', 0, 1, 1, '自主下架');
INSERT INTO `goods` (`id`, `title`, `described`, `price`, `buy_price`, `uid`, `status`, `degree`, `category_id`, `publish_time`, `imgs`, `pickup_place`, `is_delete`, `stock`, `total_sum`, `cancel_reason`) VALUES (94, '晾衣服', '宿舍收纳神奇', '6', '', '201810214719', 1, '全新', 4, '2022-04-16 22:42:44', 'Snipaste_2022-04-16_22-21-39.png', '海珠南区D栋11楼', 0, 1, 1, '');
INSERT INTO `goods` (`id`, `title`, `described`, `price`, `buy_price`, `uid`, `status`, `degree`, `category_id`, `publish_time`, `imgs`, `pickup_place`, `is_delete`, `stock`, `total_sum`, `cancel_reason`) VALUES (95, '《人世间》', '没拆封过', '20', '49', '201810214719', 1, '全新', 2, '2022-05-12 21:23:48', 'Snipaste_2022-04-16_22-21-31.png', '海珠南区D栋11楼', 0, 1, 1, '');
INSERT INTO `goods` (`id`, `title`, `described`, `price`, `buy_price`, `uid`, `status`, `degree`, `category_id`, `publish_time`, `imgs`, `pickup_place`, `is_delete`, `stock`, `total_sum`, `cancel_reason`) VALUES (96, '衣架*10', '无痕迹衣架', '5', '', '201810214707', 1, '全新', 4, '2022-04-16 22:44:10', 'Snipaste_2022-04-16_22-21-18.png', '海珠北区6110', 0, 1, 1, '');
INSERT INTO `goods` (`id`, `title`, `described`, `price`, `buy_price`, `uid`, `status`, `degree`, `category_id`, `publish_time`, `imgs`, `pickup_place`, `is_delete`, `stock`, `total_sum`, `cancel_reason`) VALUES (97, '捏捏乐', '解压神奇', '2', '', '201810214707', 2, '全新', 4, '2022-04-16 22:44:34', 'Snipaste_2022-04-16_22-12-55.png', '海珠北区6110', 0, 1, 1, '');
INSERT INTO `goods` (`id`, `title`, `described`, `price`, `buy_price`, `uid`, `status`, `degree`, `category_id`, `publish_time`, `imgs`, `pickup_place`, `is_delete`, `stock`, `total_sum`, `cancel_reason`) VALUES (98, '运动鞋40码', '好穿', '99', '299', '201810214729', 1, '全新', 7, '2022-05-12 20:36:15', 'Snipaste_2022-05-12_19-58-45.png,Snipaste_2022-05-12_19-59-39.png,Snipaste_2022-05-12_19-59-51.png', '海珠北区6110', 0, 1, 1, '');
INSERT INTO `goods` (`id`, `title`, `described`, `price`, `buy_price`, `uid`, `status`, `degree`, `category_id`, `publish_time`, `imgs`, `pickup_place`, `is_delete`, `stock`, `total_sum`, `cancel_reason`) VALUES (99, '黑色水杯', '全新', '2', '10', '201810214719', 1, '全新', 4, '2022-05-12 21:06:16', 'Snipaste_2022-05-12_20-01-06.png', '海珠南区D栋11楼', 0, 1, 1, '');
INSERT INTO `goods` (`id`, `title`, `described`, `price`, `buy_price`, `uid`, `status`, `degree`, `category_id`, `publish_time`, `imgs`, `pickup_place`, `is_delete`, `stock`, `total_sum`, `cancel_reason`) VALUES (100, '杯子', '白色', '5', '9', '201810214719', 1, '全新', 4, '2022-05-12 21:41:46', 'Snipaste_2022-05-12_20-01-19.png,Snipaste_2022-05-12_20-01-06.png', '海珠南区D栋11楼', 0, 1, 1, '');
INSERT INTO `goods` (`id`, `title`, `described`, `price`, `buy_price`, `uid`, `status`, `degree`, `category_id`, `publish_time`, `imgs`, `pickup_place`, `is_delete`, `stock`, `total_sum`, `cancel_reason`) VALUES (101, '36鞋子', '全新', '20', '100', '201810214719', 3, '全新', 7, '2022-05-12 21:41:28', 'Snipaste_2022-05-12_19-59-51.png', '海珠南区D栋11楼', 0, 1, 1, '商品标题违规');
COMMIT;

-- ----------------------------
-- Table structure for goods_category
-- ----------------------------
DROP TABLE IF EXISTS `goods_category`;
CREATE TABLE `goods_category` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of goods_category
-- ----------------------------
BEGIN;
INSERT INTO `goods_category` (`id`, `name`) VALUES (1, '学习用品');
INSERT INTO `goods_category` (`id`, `name`) VALUES (2, '书籍');
INSERT INTO `goods_category` (`id`, `name`) VALUES (3, '美妆护肤');
INSERT INTO `goods_category` (`id`, `name`) VALUES (4, '日用品');
INSERT INTO `goods_category` (`id`, `name`) VALUES (5, '服饰');
INSERT INTO `goods_category` (`id`, `name`) VALUES (6, '家具用品');
INSERT INTO `goods_category` (`id`, `name`) VALUES (7, '运动用品');
INSERT INTO `goods_category` (`id`, `name`) VALUES (8, '玩具');
COMMIT;

-- ----------------------------
-- Table structure for login
-- ----------------------------
DROP TABLE IF EXISTS `login`;
CREATE TABLE `login` (
  `id` char(12) NOT NULL,
  `password` varchar(20) NOT NULL,
  `is_delete` tinyint(1) DEFAULT '0',
  `status` int(11) DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of login
-- ----------------------------
BEGIN;
INSERT INTO `login` (`id`, `password`, `is_delete`, `status`) VALUES ('1001', '123456', 0, 2);
INSERT INTO `login` (`id`, `password`, `is_delete`, `status`) VALUES ('201710274902', '123456', 0, 1);
INSERT INTO `login` (`id`, `password`, `is_delete`, `status`) VALUES ('201810214632', '123456', 0, 1);
INSERT INTO `login` (`id`, `password`, `is_delete`, `status`) VALUES ('201810214705', '123456', 0, 1);
INSERT INTO `login` (`id`, `password`, `is_delete`, `status`) VALUES ('201810214707', '123456', 0, 1);
INSERT INTO `login` (`id`, `password`, `is_delete`, `status`) VALUES ('201810214719', '123456', 0, 1);
INSERT INTO `login` (`id`, `password`, `is_delete`, `status`) VALUES ('201810214729', '123456', 0, 1);
INSERT INTO `login` (`id`, `password`, `is_delete`, `status`) VALUES ('201910214718', '123456', 0, 1);
INSERT INTO `login` (`id`, `password`, `is_delete`, `status`) VALUES ('201910214719', '123456', 0, 1);
INSERT INTO `login` (`id`, `password`, `is_delete`, `status`) VALUES ('201910274901', '123456', 0, 1);
INSERT INTO `login` (`id`, `password`, `is_delete`, `status`) VALUES ('201910274902', '123456', 0, 1);
INSERT INTO `login` (`id`, `password`, `is_delete`, `status`) VALUES ('202010340101', '123456', 0, 1);
INSERT INTO `login` (`id`, `password`, `is_delete`, `status`) VALUES ('202010340102', '123456', 0, 1);
INSERT INTO `login` (`id`, `password`, `is_delete`, `status`) VALUES ('202010340103', '123456', 0, 1);
INSERT INTO `login` (`id`, `password`, `is_delete`, `status`) VALUES ('202010340104', '123456', 0, 1);
INSERT INTO `login` (`id`, `password`, `is_delete`, `status`) VALUES ('202010340105', '123456', 0, 1);
INSERT INTO `login` (`id`, `password`, `is_delete`, `status`) VALUES ('202010340106', '123456', 0, 1);
INSERT INTO `login` (`id`, `password`, `is_delete`, `status`) VALUES ('202010340107', '123456', 0, 1);
INSERT INTO `login` (`id`, `password`, `is_delete`, `status`) VALUES ('202010340108', '123456', 0, 1);
INSERT INTO `login` (`id`, `password`, `is_delete`, `status`) VALUES ('202010340109', '123456', 0, 1);
INSERT INTO `login` (`id`, `password`, `is_delete`, `status`) VALUES ('202020215201', '123456', 0, 1);
INSERT INTO `login` (`id`, `password`, `is_delete`, `status`) VALUES ('202120215201', '123456', 0, 1);
INSERT INTO `login` (`id`, `password`, `is_delete`, `status`) VALUES ('202120215202', '123456', 0, 1);
COMMIT;

-- ----------------------------
-- Table structure for orders
-- ----------------------------
DROP TABLE IF EXISTS `orders`;
CREATE TABLE `orders` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `order_id` varchar(30) NOT NULL,
  `goods_id` int(11) NOT NULL,
  `price` varchar(10) DEFAULT NULL,
  `status` int(11) DEFAULT '0' COMMENT '0未付款、1已付款、2未取货、3已取货、4交易完毕',
  `buyer_id` char(12) DEFAULT NULL,
  `solder_id` char(12) DEFAULT NULL,
  `buy_time` varchar(20) DEFAULT NULL,
  `pay_time` varchar(20) DEFAULT NULL,
  `pickup_time` varchar(20) DEFAULT NULL,
  `is_delete` tinyint(1) DEFAULT '0',
  `is_evaluate` tinyint(1) DEFAULT '0',
  `evaluate_content` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `goods_id` (`goods_id`),
  KEY `buyer_solder_index` (`buyer_id`,`solder_id`,`status`)
) ENGINE=InnoDB AUTO_INCREMENT=45 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of orders
-- ----------------------------
BEGIN;
INSERT INTO `orders` (`id`, `order_id`, `goods_id`, `price`, `status`, `buyer_id`, `solder_id`, `buy_time`, `pay_time`, `pickup_time`, `is_delete`, `is_evaluate`, `evaluate_content`) VALUES (10, '220412131253201810214719', 22, '3', 1, '201810214719', '201710274902', '2022-04-12 13:12:53', '', '', 0, 0, '');
INSERT INTO `orders` (`id`, `order_id`, `goods_id`, `price`, `status`, `buyer_id`, `solder_id`, `buy_time`, `pay_time`, `pickup_time`, `is_delete`, `is_evaluate`, `evaluate_content`) VALUES (11, '220412131306201810214719', 12, '20', 4, '201810214719', '201810214705', '2022-04-12 13:13:06', '2022-04-12 15:22:25', '2022-04-16 18:06:55', 0, 1, '很好的一个商品');
INSERT INTO `orders` (`id`, `order_id`, `goods_id`, `price`, `status`, `buyer_id`, `solder_id`, `buy_time`, `pay_time`, `pickup_time`, `is_delete`, `is_evaluate`, `evaluate_content`) VALUES (12, '220412131313201810214719', 15, '5', 2, '201810214719', '201810214632', '2022-04-12 13:13:13', '2022-04-16 22:57:57', '', 0, 0, '');
INSERT INTO `orders` (`id`, `order_id`, `goods_id`, `price`, `status`, `buyer_id`, `solder_id`, `buy_time`, `pay_time`, `pickup_time`, `is_delete`, `is_evaluate`, `evaluate_content`) VALUES (13, '220412131326201810214719', 18, '40', 5, '201810214719', '201910274901', '2022-04-12 13:13:26', '2022-04-12 15:22:25', '', 0, 0, '');
INSERT INTO `orders` (`id`, `order_id`, `goods_id`, `price`, `status`, `buyer_id`, `solder_id`, `buy_time`, `pay_time`, `pickup_time`, `is_delete`, `is_evaluate`, `evaluate_content`) VALUES (14, '220412131339201810214729', 30, '2', 2, '201810214729', '201810214719', '2022-04-12 13:13:39', '2022-04-12 13:17:57', '', 0, 0, '');
INSERT INTO `orders` (`id`, `order_id`, `goods_id`, `price`, `status`, `buyer_id`, `solder_id`, `buy_time`, `pay_time`, `pickup_time`, `is_delete`, `is_evaluate`, `evaluate_content`) VALUES (15, '220412131352201810214729', 27, '15', 4, '201810214729', '201810214719', '2022-04-12 13:13:52', '2022-04-12 13:16:39', '2022-04-12 13:18:05', 0, 1, '很好，书本很新。');
INSERT INTO `orders` (`id`, `order_id`, `goods_id`, `price`, `status`, `buyer_id`, `solder_id`, `buy_time`, `pay_time`, `pickup_time`, `is_delete`, `is_evaluate`, `evaluate_content`) VALUES (16, '220412131406201810214705', 29, '1', 2, '201810214705', '201810214719', '2022-04-12 13:14:06', '2022-04-12 15:25:53', '', 0, 0, '');
INSERT INTO `orders` (`id`, `order_id`, `goods_id`, `price`, `status`, `buyer_id`, `solder_id`, `buy_time`, `pay_time`, `pickup_time`, `is_delete`, `is_evaluate`, `evaluate_content`) VALUES (17, '220412131432201810214705', 23, '5', 3, '201810214705', '201810214719', '2022-04-12 13:14:32', '2022-04-12 13:16:37', '2022-04-12 13:18:07', 0, 0, '');
INSERT INTO `orders` (`id`, `order_id`, `goods_id`, `price`, `status`, `buyer_id`, `solder_id`, `buy_time`, `pay_time`, `pickup_time`, `is_delete`, `is_evaluate`, `evaluate_content`) VALUES (18, '220412131712201810214705', 25, '10', 2, '201810214705', '201810214719', '2022-04-12 13:17:12', '2022-04-16 22:38:05', '', 0, 0, '');
INSERT INTO `orders` (`id`, `order_id`, `goods_id`, `price`, `status`, `buyer_id`, `solder_id`, `buy_time`, `pay_time`, `pickup_time`, `is_delete`, `is_evaluate`, `evaluate_content`) VALUES (19, '220412131717201810214705', 8, '4.99', 3, '201810214705', '201810214719', '2022-04-12 13:17:17', '2022-04-12 15:25:51', '2022-04-16 23:44:44', 0, 0, '');
INSERT INTO `orders` (`id`, `order_id`, `goods_id`, `price`, `status`, `buyer_id`, `solder_id`, `buy_time`, `pay_time`, `pickup_time`, `is_delete`, `is_evaluate`, `evaluate_content`) VALUES (20, '220412131735201810214705', 28, '2', 3, '201810214705', '201810214719', '2022-04-12 13:17:35', '2022-04-16 22:38:03', '2022-04-16 23:44:42', 0, 0, '');
INSERT INTO `orders` (`id`, `order_id`, `goods_id`, `price`, `status`, `buyer_id`, `solder_id`, `buy_time`, `pay_time`, `pickup_time`, `is_delete`, `is_evaluate`, `evaluate_content`) VALUES (21, '220412150143202010340101', 57, '54', 1, '202010340101', '201810214719', '2022-04-12 15:01:43', '', '', 0, 0, '');
INSERT INTO `orders` (`id`, `order_id`, `goods_id`, `price`, `status`, `buyer_id`, `solder_id`, `buy_time`, `pay_time`, `pickup_time`, `is_delete`, `is_evaluate`, `evaluate_content`) VALUES (22, '220412151927201810214719', 69, '10', 3, '201810214719', '202010340109', '2022-04-12 15:19:27', '2022-04-12 16:12:20', '2022-04-12 16:12:23', 0, 0, '');
INSERT INTO `orders` (`id`, `order_id`, `goods_id`, `price`, `status`, `buyer_id`, `solder_id`, `buy_time`, `pay_time`, `pickup_time`, `is_delete`, `is_evaluate`, `evaluate_content`) VALUES (23, '220412151939201810214719', 4, '50', 2, '201810214719', '201810214707', '2022-04-12 15:19:39', '2022-04-16 22:39:38', '', 0, 0, '');
INSERT INTO `orders` (`id`, `order_id`, `goods_id`, `price`, `status`, `buyer_id`, `solder_id`, `buy_time`, `pay_time`, `pickup_time`, `is_delete`, `is_evaluate`, `evaluate_content`) VALUES (24, '220412151944201810214719', 46, '20', 4, '201810214719', '202010340107', '2022-04-12 15:19:44', '2022-04-12 15:21:57', '2022-04-16 21:11:30', 0, 1, '很好的商品');
INSERT INTO `orders` (`id`, `order_id`, `goods_id`, `price`, `status`, `buyer_id`, `solder_id`, `buy_time`, `pay_time`, `pickup_time`, `is_delete`, `is_evaluate`, `evaluate_content`) VALUES (25, '220412152038201810214719', 62, '100', 1, '201810214719', '202010340105', '2022-04-12 15:20:38', '', '', 0, 0, '');
INSERT INTO `orders` (`id`, `order_id`, `goods_id`, `price`, `status`, `buyer_id`, `solder_id`, `buy_time`, `pay_time`, `pickup_time`, `is_delete`, `is_evaluate`, `evaluate_content`) VALUES (26, '220412152042201810214719', 64, '30', 4, '201810214719', '202010340101', '2022-04-12 15:20:42', '2022-04-12 15:21:28', '2022-04-12 15:21:31', 0, 1, '很好很新');
INSERT INTO `orders` (`id`, `order_id`, `goods_id`, `price`, `status`, `buyer_id`, `solder_id`, `buy_time`, `pay_time`, `pickup_time`, `is_delete`, `is_evaluate`, `evaluate_content`) VALUES (27, '220416220655202010340104', 60, '99', 1, '202010340104', '202010340105', '2022-04-16 22:06:55', '', '', 0, 0, '');
INSERT INTO `orders` (`id`, `order_id`, `goods_id`, `price`, `status`, `buyer_id`, `solder_id`, `buy_time`, `pay_time`, `pickup_time`, `is_delete`, `is_evaluate`, `evaluate_content`) VALUES (28, '220416220703202010340104', 55, '2', 5, '202010340104', '201810214719', '2022-04-16 22:07:03', '', '', 0, 0, '');
INSERT INTO `orders` (`id`, `order_id`, `goods_id`, `price`, `status`, `buyer_id`, `solder_id`, `buy_time`, `pay_time`, `pickup_time`, `is_delete`, `is_evaluate`, `evaluate_content`) VALUES (29, '220416222314202010340104', 65, '10', 1, '202010340104', '201810214719', '2022-04-16 22:23:14', '', '', 0, 0, '');
INSERT INTO `orders` (`id`, `order_id`, `goods_id`, `price`, `status`, `buyer_id`, `solder_id`, `buy_time`, `pay_time`, `pickup_time`, `is_delete`, `is_evaluate`, `evaluate_content`) VALUES (30, '220416222952202010340107', 71, '30', 1, '202010340107', '202010340109', '2022-04-16 22:29:52', '', '', 0, 0, '');
INSERT INTO `orders` (`id`, `order_id`, `goods_id`, `price`, `status`, `buyer_id`, `solder_id`, `buy_time`, `pay_time`, `pickup_time`, `is_delete`, `is_evaluate`, `evaluate_content`) VALUES (31, '220416223219201810214719', 77, '18', 1, '201810214719', '202010340107', '2022-04-16 22:32:19', '', '', 0, 0, '');
INSERT INTO `orders` (`id`, `order_id`, `goods_id`, `price`, `status`, `buyer_id`, `solder_id`, `buy_time`, `pay_time`, `pickup_time`, `is_delete`, `is_evaluate`, `evaluate_content`) VALUES (32, '220416223229201810214719', 63, '40', 5, '201810214719', '202010340101', '2022-04-16 22:32:29', '', '', 0, 0, '');
INSERT INTO `orders` (`id`, `order_id`, `goods_id`, `price`, `status`, `buyer_id`, `solder_id`, `buy_time`, `pay_time`, `pickup_time`, `is_delete`, `is_evaluate`, `evaluate_content`) VALUES (33, '220416223503202120215202', 82, '15', 5, '202120215202', '201810214719', '2022-04-16 22:35:03', '', '', 0, 0, '');
INSERT INTO `orders` (`id`, `order_id`, `goods_id`, `price`, `status`, `buyer_id`, `solder_id`, `buy_time`, `pay_time`, `pickup_time`, `is_delete`, `is_evaluate`, `evaluate_content`) VALUES (34, '220416224120201810214707', 68, '99', 3, '201810214707', '201810214719', '2022-04-16 22:41:20', '2022-04-16 22:41:53', '2022-05-12 21:43:47', 0, 0, '');
INSERT INTO `orders` (`id`, `order_id`, `goods_id`, `price`, `status`, `buyer_id`, `solder_id`, `buy_time`, `pay_time`, `pickup_time`, `is_delete`, `is_evaluate`, `evaluate_content`) VALUES (35, '220416224130201810214707', 32, '45', 2, '201810214707', '201810214719', '2022-04-16 22:41:30', '2022-04-16 22:41:51', '', 0, 0, '');
INSERT INTO `orders` (`id`, `order_id`, `goods_id`, `price`, `status`, `buyer_id`, `solder_id`, `buy_time`, `pay_time`, `pickup_time`, `is_delete`, `is_evaluate`, `evaluate_content`) VALUES (36, '220416224134201810214707', 24, '40', 3, '201810214707', '201810214719', '2022-04-16 22:41:34', '2022-04-16 22:43:15', '2022-05-12 21:26:55', 0, 0, '');
INSERT INTO `orders` (`id`, `order_id`, `goods_id`, `price`, `status`, `buyer_id`, `solder_id`, `buy_time`, `pay_time`, `pickup_time`, `is_delete`, `is_evaluate`, `evaluate_content`) VALUES (37, '220416225716201810214719', 14, '50', 3, '201810214719', '201810214632', '2022-04-16 22:57:16', '2022-04-16 22:57:55', '2022-05-12 21:28:33', 0, 0, '');
INSERT INTO `orders` (`id`, `order_id`, `goods_id`, `price`, `status`, `buyer_id`, `solder_id`, `buy_time`, `pay_time`, `pickup_time`, `is_delete`, `is_evaluate`, `evaluate_content`) VALUES (38, '220512212142201810214719', 97, '2', 5, '201810214719', '201810214707', '2022-05-12 21:21:42', '', '', 0, 0, '');
INSERT INTO `orders` (`id`, `order_id`, `goods_id`, `price`, `status`, `buyer_id`, `solder_id`, `buy_time`, `pay_time`, `pickup_time`, `is_delete`, `is_evaluate`, `evaluate_content`) VALUES (39, '220512212727201810214719', 40, '20', 1, '201810214719', '202010340105', '2022-05-12 21:27:27', '', '', 0, 0, '');
INSERT INTO `orders` (`id`, `order_id`, `goods_id`, `price`, `status`, `buyer_id`, `solder_id`, `buy_time`, `pay_time`, `pickup_time`, `is_delete`, `is_evaluate`, `evaluate_content`) VALUES (40, '220512213612201810214719', 92, '2', 2, '201810214719', '201810214707', '2022-05-12 21:36:12', '2022-05-12 21:37:47', '', 0, 0, '');
INSERT INTO `orders` (`id`, `order_id`, `goods_id`, `price`, `status`, `buyer_id`, `solder_id`, `buy_time`, `pay_time`, `pickup_time`, `is_delete`, `is_evaluate`, `evaluate_content`) VALUES (41, '220512213649201810214719', 97, '2', 2, '201810214719', '201810214707', '2022-05-12 21:36:49', '2022-05-12 21:37:46', '', 0, 0, '');
INSERT INTO `orders` (`id`, `order_id`, `goods_id`, `price`, `status`, `buyer_id`, `solder_id`, `buy_time`, `pay_time`, `pickup_time`, `is_delete`, `is_evaluate`, `evaluate_content`) VALUES (42, '220512213718201810214719', 91, '3', 2, '201810214719', '201810214707', '2022-05-12 21:37:18', '2022-05-12 21:37:44', '', 0, 0, '');
INSERT INTO `orders` (`id`, `order_id`, `goods_id`, `price`, `status`, `buyer_id`, `solder_id`, `buy_time`, `pay_time`, `pickup_time`, `is_delete`, `is_evaluate`, `evaluate_content`) VALUES (43, '220512214033201810214719', 87, '8', 1, '201810214719', '202120215202', '2022-05-12 21:40:33', '', '', 0, 0, '');
INSERT INTO `orders` (`id`, `order_id`, `goods_id`, `price`, `status`, `buyer_id`, `solder_id`, `buy_time`, `pay_time`, `pickup_time`, `is_delete`, `is_evaluate`, `evaluate_content`) VALUES (44, '220512214406201810214719', 44, '189', 1, '201810214719', '202010340106', '2022-05-12 21:44:06', '', '', 0, 0, '');
COMMIT;

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `id` char(12) NOT NULL,
  `real_name` varchar(20) DEFAULT NULL,
  `sex` char(2) NOT NULL,
  `phone` char(12) DEFAULT NULL,
  `wechat` varchar(30) DEFAULT NULL,
  `is_active` tinyint(1) DEFAULT '1',
  `category` varchar(200) DEFAULT NULL,
  `pickup_place` varchar(50) DEFAULT NULL,
  `described` varchar(100) DEFAULT NULL,
  `show_attention` tinyint(1) DEFAULT '1',
  `show_collection` tinyint(1) DEFAULT '1',
  `avater` varchar(100) DEFAULT NULL,
  `prohibit_attention` tinyint(1) DEFAULT '0',
  `prohibit_collection` tinyint(1) DEFAULT '0',
  `fans` int(11) DEFAULT '0',
  `attentions` int(11) DEFAULT '0',
  `is_delete` tinyint(1) DEFAULT '0',
  `name` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of user
-- ----------------------------
BEGIN;
INSERT INTO `user` (`id`, `real_name`, `sex`, `phone`, `wechat`, `is_active`, `category`, `pickup_place`, `described`, `show_attention`, `show_collection`, `avater`, `prohibit_attention`, `prohibit_collection`, `fans`, `attentions`, `is_delete`, `name`) VALUES ('201710274902', '吴徐茜', '女', '13928192911', '13928192911', 1, NULL, '海珠校区7-109', '这个人很懒~什么都没留下', 1, 1, 'head.jpeg', 0, 0, 0, 0, 0, '吴徐茜');
INSERT INTO `user` (`id`, `real_name`, `sex`, `phone`, `wechat`, `is_active`, `category`, `pickup_place`, `described`, `show_attention`, `show_collection`, `avater`, `prohibit_attention`, `prohibit_collection`, `fans`, `attentions`, `is_delete`, `name`) VALUES ('201810214632', '郑晓燕', '女', '13111111111', '131111111111', 1, NULL, '海珠南区D栋11楼', '这个人很懒~什么都没留下', 1, 1, 'img_4.png', 0, 0, 1, 0, 0, '郑晓燕');
INSERT INTO `user` (`id`, `real_name`, `sex`, `phone`, `wechat`, `is_active`, `category`, `pickup_place`, `described`, `show_attention`, `show_collection`, `avater`, `prohibit_attention`, `prohibit_collection`, `fans`, `attentions`, `is_delete`, `name`) VALUES ('201810214705', '陈惠珊', '女', '13111111111', '13111111111', 1, '2,4,5', '海珠南区D栋11楼', '这个人很懒~什么都没留下', 1, 1, 'img_6.png', 0, 0, 1, 1, 0, '陈惠珊');
INSERT INTO `user` (`id`, `real_name`, `sex`, `phone`, `wechat`, `is_active`, `category`, `pickup_place`, `described`, `show_attention`, `show_collection`, `avater`, `prohibit_attention`, `prohibit_collection`, `fans`, `attentions`, `is_delete`, `name`) VALUES ('201810214707', '陈敏新', '男', '13111111111', '13111111111', 0, '1,5', '海珠北区6110', '这个人很懒~什么都没留下', 1, 1, 'head.jpeg', 0, 0, 2, 0, 0, '陈敏新');
INSERT INTO `user` (`id`, `real_name`, `sex`, `phone`, `wechat`, `is_active`, `category`, `pickup_place`, `described`, `show_attention`, `show_collection`, `avater`, `prohibit_attention`, `prohibit_collection`, `fans`, `attentions`, `is_delete`, `name`) VALUES ('201810214719', '林乐娜', '女', '131111111111', 'lena-7u', 1, '1,2,4,7', '海珠南区D栋11楼', 'hello~~', 1, 1, 'img_9.png', 0, 1, 5, 3, 0, 'lena');
INSERT INTO `user` (`id`, `real_name`, `sex`, `phone`, `wechat`, `is_active`, `category`, `pickup_place`, `described`, `show_attention`, `show_collection`, `avater`, `prohibit_attention`, `prohibit_collection`, `fans`, `attentions`, `is_delete`, `name`) VALUES ('201810214729', '许嘉志', '男', '13111111111', 'jazh-8i', 1, '1,3', '海珠北区6110', '这个人很懒~什么都没留下', 1, 1, 'img_4.png', 0, 0, 1, 1, 0, '许尔摩斯');
INSERT INTO `user` (`id`, `real_name`, `sex`, `phone`, `wechat`, `is_active`, `category`, `pickup_place`, `described`, `show_attention`, `show_collection`, `avater`, `prohibit_attention`, `prohibit_collection`, `fans`, `attentions`, `is_delete`, `name`) VALUES ('201910214718', '徐琪', '女', '13112345433', '13112345433', 1, NULL, '海珠校区北区6-119', 'nothing', 1, 1, 'head.jpeg', 0, 0, 0, 0, 0, '徐琪');
INSERT INTO `user` (`id`, `real_name`, `sex`, `phone`, `wechat`, `is_active`, `category`, `pickup_place`, `described`, `show_attention`, `show_collection`, `avater`, `prohibit_attention`, `prohibit_collection`, `fans`, `attentions`, `is_delete`, `name`) VALUES ('201910214719', '徐晓华', '女', '13112345433', '13112345433', 1, NULL, '海珠校区北区6-109', 'nothing', 1, 1, 'img_10.png', 0, 0, 0, 1, 0, '徐晓华');
INSERT INTO `user` (`id`, `real_name`, `sex`, `phone`, `wechat`, `is_active`, `category`, `pickup_place`, `described`, `show_attention`, `show_collection`, `avater`, `prohibit_attention`, `prohibit_collection`, `fans`, `attentions`, `is_delete`, `name`) VALUES ('201910274901', '许小华', '男', '13728192911', '13728192911', 1, NULL, '海珠校区8-709', '这个人很懒~什么都没留下', 1, 1, 'head.jpeg', 0, 0, 0, 0, 0, '许小华');
INSERT INTO `user` (`id`, `real_name`, `sex`, `phone`, `wechat`, `is_active`, `category`, `pickup_place`, `described`, `show_attention`, `show_collection`, `avater`, `prohibit_attention`, `prohibit_collection`, `fans`, `attentions`, `is_delete`, `name`) VALUES ('201910274902', '许小花', '女', '13728192911', '13728192911', 1, NULL, '海珠校区8-109', '这个人很懒~什么都没留下', 1, 1, 'head.jpeg', 0, 0, 0, 0, 0, '许小花');
INSERT INTO `user` (`id`, `real_name`, `sex`, `phone`, `wechat`, `is_active`, `category`, `pickup_place`, `described`, `show_attention`, `show_collection`, `avater`, `prohibit_attention`, `prohibit_collection`, `fans`, `attentions`, `is_delete`, `name`) VALUES ('202010340101', '陈曦', '男', '13728123911', '13728123911', 1, NULL, '海珠校区B-509', '这个人很懒~什么都没留下', 1, 1, 'head.jpeg', 0, 0, 0, 0, 0, '陈曦');
INSERT INTO `user` (`id`, `real_name`, `sex`, `phone`, `wechat`, `is_active`, `category`, `pickup_place`, `described`, `show_attention`, `show_collection`, `avater`, `prohibit_attention`, `prohibit_collection`, `fans`, `attentions`, `is_delete`, `name`) VALUES ('202010340102', '陈锡强', '男', '13928192911', '13928192911', 1, NULL, '海珠校区B-109', '这个人很懒~什么都没留下', 1, 1, 'head.jpeg', 0, 0, 0, 0, 0, '陈锡强');
INSERT INTO `user` (`id`, `real_name`, `sex`, `phone`, `wechat`, `is_active`, `category`, `pickup_place`, `described`, `show_attention`, `show_collection`, `avater`, `prohibit_attention`, `prohibit_collection`, `fans`, `attentions`, `is_delete`, `name`) VALUES ('202010340103', '徐启生', '男', '13928192911', '13928192911', 1, NULL, '海珠校区B-110', '这个人很懒~什么都没留下', 1, 1, 'head.jpeg', 0, 0, 0, 0, 0, '徐启生');
INSERT INTO `user` (`id`, `real_name`, `sex`, `phone`, `wechat`, `is_active`, `category`, `pickup_place`, `described`, `show_attention`, `show_collection`, `avater`, `prohibit_attention`, `prohibit_collection`, `fans`, `attentions`, `is_delete`, `name`) VALUES ('202010340104', '张启轩', '男', '13928192911', '13928192911', 1, NULL, '海珠校区B-111', '这个人很懒~什么都没留下', 1, 1, 'head.jpeg', 0, 0, 0, 0, 0, '张启轩');
INSERT INTO `user` (`id`, `real_name`, `sex`, `phone`, `wechat`, `is_active`, `category`, `pickup_place`, `described`, `show_attention`, `show_collection`, `avater`, `prohibit_attention`, `prohibit_collection`, `fans`, `attentions`, `is_delete`, `name`) VALUES ('202010340105', '林科琪', '女', '13928192911', '13928192911', 1, NULL, '海珠校区B-112', '这个人很懒~什么都没留下', 1, 1, 'head.jpeg', 0, 0, 0, 0, 0, '林科琪');
INSERT INTO `user` (`id`, `real_name`, `sex`, `phone`, `wechat`, `is_active`, `category`, `pickup_place`, `described`, `show_attention`, `show_collection`, `avater`, `prohibit_attention`, `prohibit_collection`, `fans`, `attentions`, `is_delete`, `name`) VALUES ('202010340106', '黄渠祺', '女', '13928192911', '13928192911', 1, NULL, '海珠校区B-113', '这个人很懒~什么都没留下', 1, 1, 'head.jpeg', 0, 0, 0, 0, 0, '黄渠祺');
INSERT INTO `user` (`id`, `real_name`, `sex`, `phone`, `wechat`, `is_active`, `category`, `pickup_place`, `described`, `show_attention`, `show_collection`, `avater`, `prohibit_attention`, `prohibit_collection`, `fans`, `attentions`, `is_delete`, `name`) VALUES ('202010340107', '徐曼', '女', '13928192911', '13928192911', 1, NULL, '海珠校区B-114', '这个人很懒~什么都没留下', 1, 1, 'head.jpeg', 0, 0, 0, 0, 0, '徐曼');
INSERT INTO `user` (`id`, `real_name`, `sex`, `phone`, `wechat`, `is_active`, `category`, `pickup_place`, `described`, `show_attention`, `show_collection`, `avater`, `prohibit_attention`, `prohibit_collection`, `fans`, `attentions`, `is_delete`, `name`) VALUES ('202010340108', '莫笑巧', '女', '13928192911', '13928192911', 1, NULL, '海珠校区B-115', '这个人很懒~什么都没留下', 1, 1, 'head.jpeg', 0, 0, 0, 0, 0, '莫笑巧');
INSERT INTO `user` (`id`, `real_name`, `sex`, `phone`, `wechat`, `is_active`, `category`, `pickup_place`, `described`, `show_attention`, `show_collection`, `avater`, `prohibit_attention`, `prohibit_collection`, `fans`, `attentions`, `is_delete`, `name`) VALUES ('202010340109', '方希', '女', '13928192911', '13928192911', 1, NULL, '海珠校区B-116', '这个人很懒~什么都没留下', 1, 1, 'head.jpeg', 0, 0, 1, 0, 0, '方希');
INSERT INTO `user` (`id`, `real_name`, `sex`, `phone`, `wechat`, `is_active`, `category`, `pickup_place`, `described`, `show_attention`, `show_collection`, `avater`, `prohibit_attention`, `prohibit_collection`, `fans`, `attentions`, `is_delete`, `name`) VALUES ('202020215201', '伍能新', '男', '13728123911', '13728123911', 1, NULL, '海珠校区7-509', '这个人很懒~什么都没留下', 1, 1, 'head.jpeg', 0, 0, 0, 1, 0, '伍能新');
INSERT INTO `user` (`id`, `real_name`, `sex`, `phone`, `wechat`, `is_active`, `category`, `pickup_place`, `described`, `show_attention`, `show_collection`, `avater`, `prohibit_attention`, `prohibit_collection`, `fans`, `attentions`, `is_delete`, `name`) VALUES ('202120215201', '徐喜奇', '男', '13728123911', '13728123911', 1, NULL, '海珠校区B-509', '这个人很懒~什么都没留下', 1, 1, 'head.jpeg', 0, 0, 0, 0, 0, '徐喜奇');
INSERT INTO `user` (`id`, `real_name`, `sex`, `phone`, `wechat`, `is_active`, `category`, `pickup_place`, `described`, `show_attention`, `show_collection`, `avater`, `prohibit_attention`, `prohibit_collection`, `fans`, `attentions`, `is_delete`, `name`) VALUES ('202120215202', '林思贤', '男', '13928192911', '13928192911', 1, NULL, '海珠校区B-109', '这个人很懒~什么都没留下', 1, 1, 'head.jpeg', 0, 0, 0, 1, 0, '林思贤');
COMMIT;

-- ----------------------------
-- Table structure for user_attention
-- ----------------------------
DROP TABLE IF EXISTS `user_attention`;
CREATE TABLE `user_attention` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` char(12) NOT NULL,
  `att_uid` char(12) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `uid` (`uid`),
  KEY `att_uid` (`att_uid`),
  CONSTRAINT `user_attention_ibfk_1` FOREIGN KEY (`uid`) REFERENCES `user` (`id`),
  CONSTRAINT `user_attention_ibfk_2` FOREIGN KEY (`att_uid`) REFERENCES `user` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of user_attention
-- ----------------------------
BEGIN;
INSERT INTO `user_attention` (`id`, `uid`, `att_uid`) VALUES (8, '201810214719', '201810214705');
INSERT INTO `user_attention` (`id`, `uid`, `att_uid`) VALUES (9, '201810214719', '201810214632');
INSERT INTO `user_attention` (`id`, `uid`, `att_uid`) VALUES (11, '202020215201', '201810214719');
INSERT INTO `user_attention` (`id`, `uid`, `att_uid`) VALUES (12, '201810214705', '201810214719');
INSERT INTO `user_attention` (`id`, `uid`, `att_uid`) VALUES (13, '201810214729', '201810214719');
INSERT INTO `user_attention` (`id`, `uid`, `att_uid`) VALUES (14, '201910214719', '201810214719');
INSERT INTO `user_attention` (`id`, `uid`, `att_uid`) VALUES (15, '202120215202', '201810214719');
INSERT INTO `user_attention` (`id`, `uid`, `att_uid`) VALUES (17, '201810214719', '201810214729');
COMMIT;

-- ----------------------------
-- Table structure for user_collection
-- ----------------------------
DROP TABLE IF EXISTS `user_collection`;
CREATE TABLE `user_collection` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` char(12) DEFAULT NULL,
  `gid` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `uid` (`uid`),
  KEY `gid` (`gid`),
  CONSTRAINT `user_collection_ibfk_1` FOREIGN KEY (`uid`) REFERENCES `user` (`id`),
  CONSTRAINT `user_collection_ibfk_2` FOREIGN KEY (`gid`) REFERENCES `goods` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of user_collection
-- ----------------------------
BEGIN;
INSERT INTO `user_collection` (`id`, `uid`, `gid`) VALUES (4, '201810214632', 10);
INSERT INTO `user_collection` (`id`, `uid`, `gid`) VALUES (5, '201810214632', 8);
INSERT INTO `user_collection` (`id`, `uid`, `gid`) VALUES (6, '201810214729', 6);
INSERT INTO `user_collection` (`id`, `uid`, `gid`) VALUES (7, '201810214729', 13);
INSERT INTO `user_collection` (`id`, `uid`, `gid`) VALUES (8, '201810214729', 15);
INSERT INTO `user_collection` (`id`, `uid`, `gid`) VALUES (11, '201810214719', 1);
INSERT INTO `user_collection` (`id`, `uid`, `gid`) VALUES (12, '201810214729', 2);
INSERT INTO `user_collection` (`id`, `uid`, `gid`) VALUES (15, '201810214719', 22);
INSERT INTO `user_collection` (`id`, `uid`, `gid`) VALUES (17, '201810214719', 12);
INSERT INTO `user_collection` (`id`, `uid`, `gid`) VALUES (18, '201810214729', 30);
INSERT INTO `user_collection` (`id`, `uid`, `gid`) VALUES (19, '201810214705', 8);
INSERT INTO `user_collection` (`id`, `uid`, `gid`) VALUES (20, '202020215201', 66);
INSERT INTO `user_collection` (`id`, `uid`, `gid`) VALUES (21, '201810214719', 63);
INSERT INTO `user_collection` (`id`, `uid`, `gid`) VALUES (22, '201810214719', 49);
INSERT INTO `user_collection` (`id`, `uid`, `gid`) VALUES (24, '201810214719', 44);
INSERT INTO `user_collection` (`id`, `uid`, `gid`) VALUES (25, '201810214719', 40);
INSERT INTO `user_collection` (`id`, `uid`, `gid`) VALUES (26, '201810214719', 60);
INSERT INTO `user_collection` (`id`, `uid`, `gid`) VALUES (27, '202010340104', 55);
INSERT INTO `user_collection` (`id`, `uid`, `gid`) VALUES (28, '201810214719', 96);
INSERT INTO `user_collection` (`id`, `uid`, `gid`) VALUES (29, '201810214719', 95);
INSERT INTO `user_collection` (`id`, `uid`, `gid`) VALUES (31, '201810214719', 76);
INSERT INTO `user_collection` (`id`, `uid`, `gid`) VALUES (32, '201810214719', 99);
COMMIT;

-- ----------------------------
-- Table structure for user_distribution
-- ----------------------------
DROP TABLE IF EXISTS `user_distribution`;
CREATE TABLE `user_distribution` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `to_uid` char(12) DEFAULT NULL COMMENT '收件人',
  `sent_uid` char(12) DEFAULT NULL COMMENT '售出者',
  `run_uid` char(12) DEFAULT NULL COMMENT '配送人',
  `money` varchar(10) DEFAULT NULL COMMENT '配送费',
  `publish_time` varchar(20) DEFAULT NULL COMMENT '发布时间',
  `take_time` varchar(20) DEFAULT NULL COMMENT '接单时间',
  `send_time` varchar(20) DEFAULT NULL COMMENT '配送时间',
  `content` varchar(255) DEFAULT NULL COMMENT '备注',
  `status` int(11) DEFAULT NULL,
  `is_delete` tinyint(1) DEFAULT NULL,
  `sent_address` varchar(255) DEFAULT NULL COMMENT '取货地址',
  `to_address` varchar(255) DEFAULT NULL COMMENT '送货地址',
  `order_id` int(11) DEFAULT NULL COMMENT '订单id',
  PRIMARY KEY (`id`),
  KEY `to_uid` (`to_uid`),
  KEY `sent_uid` (`sent_uid`),
  KEY `run_uid` (`run_uid`),
  CONSTRAINT `user_distribution_ibfk_1` FOREIGN KEY (`to_uid`) REFERENCES `user` (`id`),
  CONSTRAINT `user_distribution_ibfk_2` FOREIGN KEY (`sent_uid`) REFERENCES `user` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of user_distribution
-- ----------------------------
BEGIN;
INSERT INTO `user_distribution` (`id`, `to_uid`, `sent_uid`, `run_uid`, `money`, `publish_time`, `take_time`, `send_time`, `content`, `status`, `is_delete`, `sent_address`, `to_address`, `order_id`) VALUES (5, '201810214719', '201810214705', '201810214705', '2', '2022-04-16 16:00:20', '2022-04-16 17:59:33', '2022-04-16 18:12:33', '只有晚上在宿舍。好的', 3, 0, '海珠南区D栋11楼', '海珠南区D栋11楼', 11);
INSERT INTO `user_distribution` (`id`, `to_uid`, `sent_uid`, `run_uid`, `money`, `publish_time`, `take_time`, `send_time`, `content`, `status`, `is_delete`, `sent_address`, `to_address`, `order_id`) VALUES (7, '201810214719', '202010340107', '201810214729', '2', '2022-04-16 16:03:14', '2022-04-16 17:27:41', '2022-04-16 21:11:30', '周二晚上送达', 3, 0, '海珠校区B-114', '海珠南区D栋11楼', 24);
INSERT INTO `user_distribution` (`id`, `to_uid`, `sent_uid`, `run_uid`, `money`, `publish_time`, `take_time`, `send_time`, `content`, `status`, `is_delete`, `sent_address`, `to_address`, `order_id`) VALUES (8, '201810214729', '201810214719', '201810214719', '2', '2022-04-16 17:45:26', '2022-05-12 21:45:18', '', '周二送达', 2, 0, '海珠南区D栋11楼', '海珠北区6110', 14);
INSERT INTO `user_distribution` (`id`, `to_uid`, `sent_uid`, `run_uid`, `money`, `publish_time`, `take_time`, `send_time`, `content`, `status`, `is_delete`, `sent_address`, `to_address`, `order_id`) VALUES (9, '201810214705', '201810214719', '201810214719', '8', '2022-04-16 17:58:25', '2022-04-16 23:44:13', '', '明天中午送达', 2, 0, '海珠南区D栋11楼', '海珠南区D栋11楼', 16);
INSERT INTO `user_distribution` (`id`, `to_uid`, `sent_uid`, `run_uid`, `money`, `publish_time`, `take_time`, `send_time`, `content`, `status`, `is_delete`, `sent_address`, `to_address`, `order_id`) VALUES (10, '201810214705', '201810214719', '201810214719', '2', '2022-04-16 17:58:26', '2022-04-16 23:33:01', '2022-04-16 23:44:44', '周日送', 3, 0, '海珠南区D栋11楼', '海珠南区D栋11楼', 19);
INSERT INTO `user_distribution` (`id`, `to_uid`, `sent_uid`, `run_uid`, `money`, `publish_time`, `take_time`, `send_time`, `content`, `status`, `is_delete`, `sent_address`, `to_address`, `order_id`) VALUES (11, '201810214705', '201810214719', '201810214719', '2', '2022-04-16 22:39:04', '2022-05-12 21:29:06', '', '', 2, 0, '海珠南区D栋11楼', '海珠南区D栋11楼', 18);
INSERT INTO `user_distribution` (`id`, `to_uid`, `sent_uid`, `run_uid`, `money`, `publish_time`, `take_time`, `send_time`, `content`, `status`, `is_delete`, `sent_address`, `to_address`, `order_id`) VALUES (12, '201810214705', '201810214719', '201810214719', '2', '2022-04-16 22:39:05', '2022-04-16 23:43:58', '2022-04-16 23:44:42', '已送达', 3, 0, '海珠南区D栋11楼', '海珠南区D栋11楼', 20);
INSERT INTO `user_distribution` (`id`, `to_uid`, `sent_uid`, `run_uid`, `money`, `publish_time`, `take_time`, `send_time`, `content`, `status`, `is_delete`, `sent_address`, `to_address`, `order_id`) VALUES (13, '201810214707', '201810214719', '201810214719', '2', '2022-04-16 22:43:39', '2022-04-16 23:32:57', '', '中午12-13点送达', 2, 0, '海珠南区D栋11楼', '海珠北区6110', 36);
INSERT INTO `user_distribution` (`id`, `to_uid`, `sent_uid`, `run_uid`, `money`, `publish_time`, `take_time`, `send_time`, `content`, `status`, `is_delete`, `sent_address`, `to_address`, `order_id`) VALUES (14, '201810214707', '201810214719', '', '2', '2022-04-16 22:43:40', '', '', '', 1, 0, '海珠南区D栋11楼', '海珠北区6110', 34);
INSERT INTO `user_distribution` (`id`, `to_uid`, `sent_uid`, `run_uid`, `money`, `publish_time`, `take_time`, `send_time`, `content`, `status`, `is_delete`, `sent_address`, `to_address`, `order_id`) VALUES (15, '201810214707', '201810214719', '201810214729', '2', '2022-04-16 22:43:42', '2022-04-16 23:20:40', '', '周三送到', 2, 0, '海珠南区D栋11楼', '海珠北区6110', 35);
INSERT INTO `user_distribution` (`id`, `to_uid`, `sent_uid`, `run_uid`, `money`, `publish_time`, `take_time`, `send_time`, `content`, `status`, `is_delete`, `sent_address`, `to_address`, `order_id`) VALUES (16, '201810214719', '201810214707', '', '2', '2022-04-16 22:56:22', '', '', '', 1, 0, '海珠校区北区6-110', '海珠南区D栋11楼', 23);
INSERT INTO `user_distribution` (`id`, `to_uid`, `sent_uid`, `run_uid`, `money`, `publish_time`, `take_time`, `send_time`, `content`, `status`, `is_delete`, `sent_address`, `to_address`, `order_id`) VALUES (17, '201810214719', '201810214632', '201810214729', '2', '2022-04-16 22:58:12', '2022-04-16 23:20:34', '2022-05-12 21:28:33', '周三送达', 3, 0, '海珠南区D栋11楼', '海珠南区D栋11楼', 37);
INSERT INTO `user_distribution` (`id`, `to_uid`, `sent_uid`, `run_uid`, `money`, `publish_time`, `take_time`, `send_time`, `content`, `status`, `is_delete`, `sent_address`, `to_address`, `order_id`) VALUES (18, '201810214719', '201810214632', '', '5', '2022-05-12 21:25:55', '', '', '希望快速送达', 1, 0, '海珠南区D栋11楼', '海珠南区D栋11楼', 12);
INSERT INTO `user_distribution` (`id`, `to_uid`, `sent_uid`, `run_uid`, `money`, `publish_time`, `take_time`, `send_time`, `content`, `status`, `is_delete`, `sent_address`, `to_address`, `order_id`) VALUES (19, '201810214719', '201810214707', '', '10', '2022-05-12 21:43:06', '', '', '', 1, 0, '白云北区6110', '海珠南区D栋11楼', 40);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;