代码拉取完成，页面将自动刷新
同步操作将从 LiusCraft/校园二手交易平台 强制同步，此操作会覆盖自 Fork 仓库以来所做的任何修改，且无法恢复！！！
确定后同步将在后台操作，完成时将刷新页面，请耐心等待。
/*
Navicat Premium Data Transfer
Source Server : 127.0.0.1
Source Server Type : MySQL
Source Server Version : 80031
Source Host : localhost:3306
Source Schema : trading
Target Server Type : MySQL
Target Server Version : 80031
File Encoding : 65001
Date: 19/03/2023 10:28:42
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for category
-- ----------------------------
DROP TABLE IF EXISTS `category`;
CREATE TABLE `category` (
`id` int NOT NULL AUTO_INCREMENT,
`name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '分类名',
`description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '无描述' COMMENT '分类描述',
`deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '逻辑删除',
`gmt_create` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`gmt_modified` timestamp NULL DEFAULT NULL COMMENT '修改时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of category
-- ----------------------------
INSERT INTO `category` VALUES (2, '书籍', '专业书、小说、考试资料等', 0, '2023-03-10 21:08:18', NULL);
INSERT INTO `category` VALUES (3, '电子产品', '四级听力耳机、键盘、鼠标等', 0, '2023-03-10 21:08:53', NULL);
INSERT INTO `category` VALUES (4, '桌椅', '电竞椅、桌子、靠椅、可收纳桌', 0, '2023-03-10 21:09:35', NULL);
-- ----------------------------
-- Table structure for feedback
-- ----------------------------
DROP TABLE IF EXISTS `feedback`;
CREATE TABLE `feedback` (
`id` int NOT NULL AUTO_INCREMENT,
`user_id` int NOT NULL,
`context` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
`deleted` tinyint(1) NOT NULL DEFAULT 0,
PRIMARY KEY (`id`) USING BTREE,
INDEX `feedback_FK`(`user_id`) USING BTREE,
CONSTRAINT `feedback_FK` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for good
-- ----------------------------
DROP TABLE IF EXISTS `good`;
CREATE TABLE `good` (
`id` int NOT NULL AUTO_INCREMENT,
`name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '商品名',
`profile_display` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '事物展示图',
`description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '无描述' COMMENT '商品描述',
`count` int NOT NULL DEFAULT 1 COMMENT '商品数量',
`category_id` int NOT NULL DEFAULT 0 COMMENT '产品类别',
`hots` timestamp NULL DEFAULT NULL COMMENT '主动推荐，这里是设置推荐到期时间',
`user_id` int NOT NULL COMMENT '发布者id',
`deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '逻辑删除',
`gmt_create` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`gmt_modified` timestamp NULL DEFAULT NULL COMMENT '修改时间',
PRIMARY KEY (`id`) USING BTREE,
INDEX `goods_FK`(`category_id`) USING BTREE,
INDEX `goods_FK_1`(`user_id`) USING BTREE,
CONSTRAINT `goods_FK` FOREIGN KEY (`category_id`) REFERENCES `category` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
CONSTRAINT `goods_FK_1` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 43 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for luck_permission
-- ----------------------------
DROP TABLE IF EXISTS `luck_permission`;
CREATE TABLE `luck_permission` (
`id` int NOT NULL AUTO_INCREMENT,
`method` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
`route` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
`description` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '无描述',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `luck_permission_un_m_r`(`method`, `route`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 78 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of luck_permission
-- ----------------------------
INSERT INTO `luck_permission` VALUES (1, 'OPTIONS', '/luck-role-permissions', '无描述');
INSERT INTO `luck_permission` VALUES (2, 'DELETE', '/luck-role-permissions', '无描述');
INSERT INTO `luck_permission` VALUES (3, 'POST', '/luck-role-permissions', '无描述');
INSERT INTO `luck_permission` VALUES (4, 'TRACE', '/luck-role-permissions', '无描述');
INSERT INTO `luck_permission` VALUES (5, 'HEAD', '/luck-role-permissions', '无描述');
INSERT INTO `luck_permission` VALUES (6, 'PATCH', '/luck-role-permissions', '无描述');
INSERT INTO `luck_permission` VALUES (7, 'GET', '/luck-role-permissions', '无描述');
INSERT INTO `luck_permission` VALUES (8, 'PUT', '/luck-role-permissions', '无描述');
INSERT INTO `luck_permission` VALUES (10, 'PUT', '/goods', '无描述');
INSERT INTO `luck_permission` VALUES (11, 'HEAD', '/goods', '无描述');
INSERT INTO `luck_permission` VALUES (12, 'PATCH', '/goods', '无描述');
INSERT INTO `luck_permission` VALUES (13, 'DELETE', '/goods', '无描述');
INSERT INTO `luck_permission` VALUES (14, 'GET', '/goods', '无描述');
INSERT INTO `luck_permission` VALUES (15, 'POST', '/goods', '无描述');
INSERT INTO `luck_permission` VALUES (16, 'OPTIONS', '/goods', '无描述');
INSERT INTO `luck_permission` VALUES (17, 'TRACE', '/goods', '无描述');
INSERT INTO `luck_permission` VALUES (18, 'DELETE', '/orders', '用户订单管理接口');
INSERT INTO `luck_permission` VALUES (19, 'OPTIONS', '/orders', '用户订单管理接口');
INSERT INTO `luck_permission` VALUES (20, 'POST', '/orders', '用户订单管理接口');
INSERT INTO `luck_permission` VALUES (21, 'GET', '/orders', '用户订单管理接口');
INSERT INTO `luck_permission` VALUES (23, 'TRACE', '/orders', '用户订单管理接口');
INSERT INTO `luck_permission` VALUES (24, 'HEAD', '/orders', '用户订单管理接口');
INSERT INTO `luck_permission` VALUES (25, 'PATCH', '/orders', '用户订单管理接口');
INSERT INTO `luck_permission` VALUES (26, 'PUT', '/orders', '用户订单管理接口');
INSERT INTO `luck_permission` VALUES (27, 'PATCH', '/admin', '无描述');
INSERT INTO `luck_permission` VALUES (31, 'POST', '/admin', '无描述');
INSERT INTO `luck_permission` VALUES (33, 'OPTIONS', '/admin', '无描述');
INSERT INTO `luck_permission` VALUES (34, 'PUT', '/admin', '无描述');
INSERT INTO `luck_permission` VALUES (35, 'TRACE', '/admin', '无描述');
INSERT INTO `luck_permission` VALUES (38, 'GET', '/admin', '无描述');
INSERT INTO `luck_permission` VALUES (39, 'HEAD', '/admin', '无描述');
INSERT INTO `luck_permission` VALUES (42, 'DELETE', '/admin', '无描述');
INSERT INTO `luck_permission` VALUES (43, 'OPTIONS', '/feedback', '无描述');
INSERT INTO `luck_permission` VALUES (44, 'DELETE', '/feedback', '无描述');
INSERT INTO `luck_permission` VALUES (45, 'POST', '/feedback', '无描述');
INSERT INTO `luck_permission` VALUES (46, 'HEAD', '/feedback', '无描述');
INSERT INTO `luck_permission` VALUES (47, 'PATCH', '/feedback', '无描述');
INSERT INTO `luck_permission` VALUES (48, 'GET', '/feedback', '无描述');
INSERT INTO `luck_permission` VALUES (49, 'PUT', '/feedback', '无描述');
INSERT INTO `luck_permission` VALUES (50, 'TRACE', '/feedback', '无描述');
INSERT INTO `luck_permission` VALUES (51, 'PUT', '/admin/**', '无描述');
INSERT INTO `luck_permission` VALUES (52, 'PATCH', '/admin/**', '无描述');
INSERT INTO `luck_permission` VALUES (53, 'HEAD', '/admin/**', '无描述');
INSERT INTO `luck_permission` VALUES (54, 'DELETE', '/admin/**', '无描述');
INSERT INTO `luck_permission` VALUES (55, 'GET', '/goods/user/*', '无描述');
INSERT INTO `luck_permission` VALUES (56, 'GET', '/admin/**', '无描述');
INSERT INTO `luck_permission` VALUES (57, 'POST', '/admin/**', '无描述');
INSERT INTO `luck_permission` VALUES (58, 'GET', '/user/', '获取用户自己的信息');
INSERT INTO `luck_permission` VALUES (59, 'OPTIONS', '/admin/**', '无描述');
INSERT INTO `luck_permission` VALUES (60, 'TRACE', '/admin/**', '无描述');
INSERT INTO `luck_permission` VALUES (61, 'GET', '/luck-role-permissions/user', '无描述');
INSERT INTO `luck_permission` VALUES (62, 'POST', '/goods/**', '无描述');
INSERT INTO `luck_permission` VALUES (63, 'TRACE', '/goods/**', '无描述');
INSERT INTO `luck_permission` VALUES (64, 'OPTIONS', '/goods/**', '无描述');
INSERT INTO `luck_permission` VALUES (65, 'PUT', '/goods/**', '无描述');
INSERT INTO `luck_permission` VALUES (66, 'DELETE', '/goods/**', '无描述');
INSERT INTO `luck_permission` VALUES (67, 'HEAD', '/goods/**', '无描述');
INSERT INTO `luck_permission` VALUES (68, 'GET', '/goods/**', '无描述');
INSERT INTO `luck_permission` VALUES (69, 'PATCH', '/goods/**', '无描述');
INSERT INTO `luck_permission` VALUES (70, 'POST', '/orders/**', '用户订单管理接口');
INSERT INTO `luck_permission` VALUES (71, 'PATCH', '/orders/**', '用户订单管理接口');
INSERT INTO `luck_permission` VALUES (72, 'HEAD', '/orders/**', '用户订单管理接口');
INSERT INTO `luck_permission` VALUES (73, 'GET', '/orders/**', '用户订单管理接口');
INSERT INTO `luck_permission` VALUES (74, 'DELETE', '/orders/**', '用户订单管理接口');
INSERT INTO `luck_permission` VALUES (75, 'PUT', '/orders/**', '用户订单管理接口');
INSERT INTO `luck_permission` VALUES (76, 'TRACE', '/orders/**', '用户订单管理接口');
INSERT INTO `luck_permission` VALUES (77, 'OPTIONS', '/orders/**', '用户订单管理接口');
-- ----------------------------
-- Table structure for luck_role
-- ----------------------------
DROP TABLE IF EXISTS `luck_role`;
CREATE TABLE `luck_role` (
`id` int NOT NULL AUTO_INCREMENT,
`role_name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
`role_description` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '该角色无描述',
`role_ban` tinyint NOT NULL DEFAULT 0,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of luck_role
-- ----------------------------
INSERT INTO `luck_role` VALUES (1, 'SuperAdmin', '超级管理员，可访问luckPermissionAPI', 0);
INSERT INTO `luck_role` VALUES (2, '普通用户', '普通用户可上架商品与购买商品', 0);
-- ----------------------------
-- Table structure for luck_role_permission
-- ----------------------------
DROP TABLE IF EXISTS `luck_role_permission`;
CREATE TABLE `luck_role_permission` (
`role_id` int NOT NULL,
`permission_id` int NOT NULL,
`allow` tinyint NOT NULL DEFAULT 1,
INDEX `luck_role_permission_FK_1`(`permission_id`) USING BTREE,
INDEX `luck_role_permission_role_id_IDX`(`role_id`, `permission_id`, `allow`) USING BTREE,
CONSTRAINT `luck_role_permission_FK` FOREIGN KEY (`role_id`) REFERENCES `luck_role` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT,
CONSTRAINT `luck_role_permission_FK_1` FOREIGN KEY (`permission_id`) REFERENCES `luck_permission` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of luck_role_permission
-- ----------------------------
INSERT INTO `luck_role_permission` VALUES (1, 15, 1);
INSERT INTO `luck_role_permission` VALUES (1, 21, 1);
INSERT INTO `luck_role_permission` VALUES (1, 26, 1);
INSERT INTO `luck_role_permission` VALUES (1, 38, 1);
INSERT INTO `luck_role_permission` VALUES (1, 45, 1);
INSERT INTO `luck_role_permission` VALUES (1, 51, 1);
INSERT INTO `luck_role_permission` VALUES (1, 54, 1);
INSERT INTO `luck_role_permission` VALUES (1, 55, 1);
INSERT INTO `luck_role_permission` VALUES (1, 56, 1);
INSERT INTO `luck_role_permission` VALUES (1, 57, 1);
INSERT INTO `luck_role_permission` VALUES (1, 58, 1);
INSERT INTO `luck_role_permission` VALUES (1, 65, 1);
INSERT INTO `luck_role_permission` VALUES (1, 66, 1);
INSERT INTO `luck_role_permission` VALUES (1, 68, 1);
INSERT INTO `luck_role_permission` VALUES (1, 73, 1);
INSERT INTO `luck_role_permission` VALUES (1, 75, 1);
INSERT INTO `luck_role_permission` VALUES (2, 15, 1);
INSERT INTO `luck_role_permission` VALUES (2, 45, 1);
INSERT INTO `luck_role_permission` VALUES (2, 55, 1);
INSERT INTO `luck_role_permission` VALUES (2, 58, 1);
INSERT INTO `luck_role_permission` VALUES (2, 62, 1);
INSERT INTO `luck_role_permission` VALUES (2, 65, 1);
INSERT INTO `luck_role_permission` VALUES (2, 66, 1);
INSERT INTO `luck_role_permission` VALUES (2, 68, 1);
INSERT INTO `luck_role_permission` VALUES (2, 73, 1);
INSERT INTO `luck_role_permission` VALUES (2, 75, 1);
-- ----------------------------
-- Table structure for order
-- ----------------------------
DROP TABLE IF EXISTS `order`;
CREATE TABLE `order` (
`id` int NOT NULL AUTO_INCREMENT,
`good_id` int NOT NULL COMMENT '商品id',
`good_user_id` int NOT NULL,
`user_id` int NOT NULL COMMENT '购买者id',
`status` int NOT NULL DEFAULT 0 COMMENT '订单状态',
`count` int NOT NULL DEFAULT 1 COMMENT '购买数量',
`gmt_create` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`gmt_modified` timestamp NULL DEFAULT NULL COMMENT '修改时间',
`deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '逻辑删除',
PRIMARY KEY (`id`) USING BTREE,
INDEX `orders_FK`(`user_id`) USING BTREE,
INDEX `orders_FK_1`(`good_id`) USING BTREE,
CONSTRAINT `orders_FK` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
CONSTRAINT `orders_FK_1` FOREIGN KEY (`good_id`) REFERENCES `good` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 36 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
`id` int NOT NULL AUTO_INCREMENT,
`nickname` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '昵称',
`email` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '邮箱',
`password` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '密码',
`role_id` int NOT NULL DEFAULT 0 COMMENT '角色id',
`gmt_create` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`gmt_modified` timestamp NULL DEFAULT NULL COMMENT '修改时间',
`deleted` tinyint(1) NOT NULL DEFAULT 0,
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `user_un`(`email`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
SET FOREIGN_KEY_CHECKS = 1;
此处可能存在不合适展示的内容，页面不予展示。您可通过相关编辑功能自查并修改。
如您确认内容无涉及 不当用语 / 纯广告导流 / 暴力 / 低俗色情 / 侵权 / 盗版 / 虚假 / 无价值内容或违法国家有关法律法规的内容，可点击提交进行申诉，我们将尽快为您处理。
马建仓 AI 助手