登录 注册
开源 企业版 高校版 私有云 模力方舟 模力方舟 AI 队友
richgiteeai
Watch
不关注 关注所有动态 仅关注版本发行动态 关注但不提醒动态
1 Star 18 Fork 3

Endurancer/SecondHandProject

代码 Issues 0 Pull Requests 0 Wiki 统计 流水线
服务
加入 Gitee
与超过 1400万 开发者一起发现、参与优秀开源项目，私有仓库也完全免费 ：）
免费加入
文件
该仓库未声明开源许可证文件（LICENSE），使用请关注具体项目描述及其代码上游依赖。
项目仓库所选许可证以仓库主分支所使用许可证为准
克隆/下载
secondhand.sql 21.95 KB
一键复制 编辑 原始数据 按行查看 历史
Endurancer 提交于 2025-01-14 19:53 +08:00 . update xm-assets.sql.
123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294
/*

 Navicat Premium Data Transfer



 Source Server         : localhost

 Source Server Type    : MySQL

 Source Server Version : 80040

 Source Host           : localhost:3306

 Source Schema         : secondhand



 Target Server Type    : MySQL

 Target Server Version : 80040

 File Encoding         : 65001



 Date: 13/01/2025 11:30:56

*/



SET NAMES utf8mb4;

SET FOREIGN_KEY_CHECKS = 0;



-- ----------------------------

-- Table structure for address

-- ----------------------------

DROP TABLE IF EXISTS `address`;

CREATE TABLE `address`  (

  `id` int NOT NULL AUTO_INCREMENT COMMENT 'ID',

  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '联系人',

  `address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '联系地址',

  `phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '联系电话',

  `user_id` int NULL DEFAULT NULL COMMENT '关联用户',

  PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '收货地址' ROW_FORMAT = DYNAMIC;



-- ----------------------------

-- Records of address

-- ----------------------------



-- ----------------------------

-- Table structure for admin

-- ----------------------------

DROP TABLE IF EXISTS `admin`;

CREATE TABLE `admin`  (

  `id` int NOT NULL AUTO_INCREMENT COMMENT 'ID',

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

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

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

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

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

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

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

  PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '管理员' ROW_FORMAT = DYNAMIC;



-- ----------------------------

-- Records of admin

-- ----------------------------

INSERT INTO `admin` VALUES (1, 'admin', 'admin', '管理员', 'http://localhost:9090/files/1697438073596-avatar.png', 'ADMIN', '13677889922', 'admin@xm.com');



-- ----------------------------

-- Table structure for category

-- ----------------------------

DROP TABLE IF EXISTS `category`;

CREATE TABLE `category`  (

  `id` int NOT NULL AUTO_INCREMENT COMMENT 'ID',

  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '名称',

  PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 12 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '分类' ROW_FORMAT = DYNAMIC;



-- ----------------------------

-- Records of category

-- ----------------------------

INSERT INTO `category` VALUES (1, '穿搭');

INSERT INTO `category` VALUES (2, '家居');

INSERT INTO `category` VALUES (3, '笔记本平板');

INSERT INTO `category` VALUES (4, '手机');

INSERT INTO `category` VALUES (5, '电动车');

INSERT INTO `category` VALUES (6, '自行车');

INSERT INTO `category` VALUES (7, '足球');

INSERT INTO `category` VALUES (8, '篮球');

INSERT INTO `category` VALUES (9, '乐器');

INSERT INTO `category` VALUES (10, '耳机音箱');

INSERT INTO `category` VALUES (11, '图书');



-- ----------------------------

-- Table structure for circles

-- ----------------------------

DROP TABLE IF EXISTS `circles`;

CREATE TABLE `circles`  (

  `id` int NOT NULL AUTO_INCREMENT COMMENT 'ID',

  `img` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '缩略图',

  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '名称',

  PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '圈子' ROW_FORMAT = DYNAMIC;



-- ----------------------------

-- Records of circles

-- ----------------------------

INSERT INTO `circles` VALUES (1, 'http://localhost:9090/files/1710666713388-全部.png', '全部');

INSERT INTO `circles` VALUES (2, 'http://localhost:9090/files/1710666813454-生活服务.png', '生活用品');

INSERT INTO `circles` VALUES (3, 'http://localhost:9090/files/1710753648228-书籍.png', '图书教材');

INSERT INTO `circles` VALUES (4, 'http://localhost:9090/files/1710746292837-音乐.png', '音乐');

INSERT INTO `circles` VALUES (5, 'http://localhost:9090/files/1710666820607-鼠标.png', '数码产品');



-- ----------------------------

-- Table structure for collect

-- ----------------------------

DROP TABLE IF EXISTS `collect`;

CREATE TABLE `collect`  (

  `id` int NOT NULL AUTO_INCREMENT COMMENT 'ID',

  `fid` int NULL DEFAULT NULL COMMENT '关联ID',

  `user_id` int NULL DEFAULT NULL COMMENT '收藏人ID',

  `module` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '模块',

  PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '收藏' ROW_FORMAT = DYNAMIC;



-- ----------------------------

-- Records of collect

-- ----------------------------



-- ----------------------------

-- Table structure for comment

-- ----------------------------

DROP TABLE IF EXISTS `comment`;

CREATE TABLE `comment`  (

  `id` int NOT NULL AUTO_INCREMENT COMMENT 'ID',

  `content` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '内容',

  `user_id` int NULL DEFAULT NULL COMMENT '评论人',

  `pid` int NULL DEFAULT NULL COMMENT '父级ID',

  `time` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '评论时间',

  `fid` int NULL DEFAULT NULL COMMENT '关联ID',

  `module` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '模块',

  `root_id` int NULL DEFAULT NULL COMMENT '根节点ID',

  PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 67 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '评论表' ROW_FORMAT = DYNAMIC;



-- ----------------------------

-- Records of comment

-- ----------------------------



-- ----------------------------

-- Table structure for feedback

-- ----------------------------

DROP TABLE IF EXISTS `feedback`;

CREATE TABLE `feedback`  (

  `id` int NOT NULL AUTO_INCREMENT COMMENT 'ID',

  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '主题',

  `content` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '内容',

  `phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '联系方式',

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

  `reply` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '回复',

  `createtime` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '创建时间',

  `user_id` int NULL DEFAULT NULL COMMENT '提交人ID',

  PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '反馈信息' ROW_FORMAT = DYNAMIC;



-- ----------------------------

-- Records of feedback

-- ----------------------------



-- ----------------------------

-- Table structure for goods

-- ----------------------------

DROP TABLE IF EXISTS `goods`;

CREATE TABLE `goods`  (

  `id` int NOT NULL AUTO_INCREMENT COMMENT 'ID',

  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '名称',

  `price` decimal(10, 2) NULL DEFAULT NULL COMMENT '价格',

  `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL COMMENT '详情',

  `address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '发货地址',

  `img` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '图片',

  `date` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '上架日期',

  `status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '审核状态',

  `category` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '分类',

  `user_id` int NULL DEFAULT NULL COMMENT '所属用户ID',

  `sale_status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '上架状态',

  `read_count` int NULL DEFAULT 0 COMMENT '浏览量',

  PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 19 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '二手商品' ROW_FORMAT = DYNAMIC;



-- ----------------------------

-- Records of goods

-- ----------------------------

INSERT INTO `goods` VALUES (2, '影石Insta360 Ace Pro运动相机8k徕卡摄像头', 1998.00, '<p><img src=\"https://img.alicdn.com/imgextra/i3/2208654990728/O1CN014fxPBV1HFTGmsusBp_!!2208654990728.png\" width=\"100%\"/><img src=\"http://localhost:9090/files/1710732191721-image.png\" contenteditable=\"false\" style=\"font-size: 14px; max-width: 100%;\" width=\"100%\"/></p><br/>', '安徽合肥', 'http://localhost:9090/files/1710732176479-微信截图_20240318112155.png', '2024-01-10', '通过', '耳机音箱', 4, '上架', 1);

INSERT INTO `goods` VALUES (3, 'SONY索尼WH-1000XM4/5头戴式无线蓝牙耳机主动降噪头戴4', 1999.00, '<p><img src=\"https://img.alicdn.com/imgextra/i2/2214661621088/O1CN01SJ2vWm1JuLmc8Migo_!!2214661621088-0-scmitem1000.jpg\" width=\"100%\"/><br/></p>', '安徽合肥', 'http://localhost:9090/files/1710732446620-微信截图_20240318112705.png', '2024-01-10', '通过', '耳机音箱', 4, '上架', 4);

INSERT INTO `goods` VALUES (4, '2022年卡塔尔世界杯足球官方正品5号专业训练比赛专用球儿童1355', 40.00, '<p><img src=\"https://img.alicdn.com/imgextra/i1/2616970884/O1CN01SPbEn61IOuwP1G1oE_!!2616970884.jpg\" width=\"100%\"/><img src=\"http://localhost:9090/files/1710732567587-image.png\" contenteditable=\"false\" style=\"font-size: 14px; max-width: 100%;\"/></p><br/>', '安徽合肥', 'http://localhost:9090/files/1710732543650-微信截图_20240318112858.png', '2024-01-10', '通过', '足球', 4, '上架', 2);

INSERT INTO `goods` VALUES (5, '足球五号初中生中考训练专用球', 199.00, '<p><img src=\"https://img.alicdn.com/imgextra/i2/2193975096/O1CN010RF9HT1nW1HJmulLe_!!2193975096-0-scmitem176000.jpg\" width=\"100%\"/><img src=\"http://localhost:9090/files/1710732634056-image.png\" contenteditable=\"false\" style=\"font-size: 14px; max-width: 100%;\"/></p><br/>', '安徽合肥', 'http://localhost:9090/files/1710732630892-微信截图_20240318113020.png', '2024-01-10', '通过', '足球', 4, '上架', 8);

INSERT INTO `goods` VALUES (6, '斯伯丁篮球官方正品中考学生专用7号成人橡胶室外篮球耐磨防滑', 199.00, '<p><img src=\"https://img.alicdn.com/imgextra/i4/2215726198477/O1CN01uDQHZo2CUWMouy2f0_!!2215726198477.jpg\" width=\"100%\"/><img src=\"https://img.alicdn.com/imgextra/i2/2215726198477/O1CN01suxVZE2CUWHaf2Ms0_!!2215726198477.jpg\" style=\"font-size: 14px;\" width=\"100%\"/><img src=\"http://localhost:9090/files/1710732721019-image.png\" contenteditable=\"false\" style=\"font-size: 14px; max-width: 100%;\"/></p><br/>', '安徽合肥', 'http://localhost:9090/files/1710732691542-微信截图_20240318113120.png', '2024-01-10', '通过', '篮球', 4, '上架', 6);

INSERT INTO `goods` VALUES (7, '震撼大师手工全单古典吉他', 1998.00, '<p><img src=\"https://img.alicdn.com/imgextra/i2/2289123357/O1CN01gFdEtC1afYLPtjh3X_!!2289123357.jpg\" width=\"100%\"/><img src=\"http://localhost:9090/files/1710732813613-image.png\" contenteditable=\"false\" style=\"font-size: 14px; max-width: 100%;\"/></p><br/>', '安徽合肥', 'http://localhost:9090/files/1710732810749-微信截图_20240318113309.png', '2024-01-10', '通过', '乐器', 4, '上架', 3);

INSERT INTO `goods` VALUES (8, '专业笛子初学者零基础竹笛入门苦竹f演奏级c调成人e儿童g横笛乐器', 199.00, '<p><img src=\"https://img.alicdn.com/imgextra/i1/2417340146/O1CN01nNji0v1CwugZ4snBM_!!2417340146.jpg\" width=\"100%\"/><img src=\"http://localhost:9090/files/1710732892032-image.png\" contenteditable=\"false\" style=\"font-size: 14px; max-width: 100%;\"/></p><br/>', '安徽合肥', 'http://localhost:9090/files/1710732896200-微信截图_20240318113443.png', '2024-01-10', '通过', '乐器', 4, '上架', 23);

INSERT INTO `goods` VALUES (9, 'kepma卡普马吉他卡玛民谣电箱d1c/a1c初学入门男女学生儿童木吉他', 648.00, '<p><img src=\"https://img.alicdn.com/imgextra/i1/850320452/O1CN01Me5Rvy1FD3xMD4EOK_!!850320452.jpg\" width=\"100%\"/><img src=\"http://localhost:9090/files/1710732996103-image.png\" contenteditable=\"false\" style=\"font-size: 14px; max-width: 100%;\"/></p><br/>', '安徽合肥', 'http://localhost:9090/files/1710733003156-微信截图_20240318113621.png', '2024-01-10', '通过', '乐器', 4, '上架', 57);

INSERT INTO `goods` VALUES (13, '品彩新年红半高领针', 199.00, '<div><img src=\"https://img30.360buyimg.com/sku/jfs/t1/99760/24/43651/54323/64e2cde4Fbece5bd3/ac96a198fb27780a.jpg\"/>	</div>\n<div><img src=\"https://img30.360buyimg.com/sku/jfs/t1/189762/23/36644/55229/64e2cde4F8786c6ee/8dadfcf2f1c54a99.jpg\"/>	</div>', '安徽合肥', 'http://localhost:9090/files/1704875358717-微信截图_20240110162417.png', '2024-01-10', '待审核', '穿搭', 4, '上架', 27);

INSERT INTO `goods` VALUES (15, '二手商品', 10.00, '<p><img src=\"http://localhost:9090/files/1708400286601-image.png\" style=\"max-width:100%;\" contenteditable=\"false\"/></p>', '东校区', 'http://localhost:9090/files/1708399512763-蛋糕.png', '2024-02-20', '通过', '耳机音箱', 4, '下架', 55);

INSERT INTO `goods` VALUES (16, '键盘', 200.00, '<p><img src=\"https://img.alicdn.com/imgextra/i4/2212972276013/O1CN013AucSC1uI0SlSDkvD_!!2212972276013.jpg\" width=\"100%\"/><img src=\"http://localhost:9090/files/1710756960569-image.png\" contenteditable=\"false\" style=\"font-size: 14px; max-width: 100%;\"/></p><br/>', '合肥', 'http://localhost:9090/files/1710756941461-微信截图_20240318181524.png', '2024-03-18', '通过', '笔记本平板', 5, '上架', 56);

INSERT INTO `goods` VALUES (17, '【官方正版】高等数学同济七版 教材上册+下册 同济大学高等数学第七版 大一课本高等数学第7版 高数考研数学教材 高等教育出版社', 30.00, '<p><img src=\"https://img.alicdn.com/imgextra/i2/101450072/O1CN01QxR1em1CP1Gj2vT4A-101450072.jpg\" width=\"100%\"/><img src=\"http://localhost:9090/files/1710756616895-image.png\" contenteditable=\"false\" style=\"font-size: 14px; max-width: 100%;\"/></p><br/>', '安徽合肥', 'http://localhost:9090/files/1710756599260-微信截图_20240318180909.png', '2024-03-18', '通过', '图书', 1, '上架', 2);

INSERT INTO `goods` VALUES (18, '新华正版】工程数学 线性代数第六版 高等教育出版社 线性代数同济六版6版 工程数学线性代数同济大学线代 考研数学教材用书', 28.00, '<p><img src=\"https://img.alicdn.com/imgextra/i3/101450072/O1CN01fT1YYK1CP19H32Ph4-101450072.jpg\" width=\"100%\"/><img src=\"http://localhost:9090/files/1710756841433-image.png\" contenteditable=\"false\" style=\"font-size: 14px; max-width: 100%;\"/></p><br/>', '安徽合肥', 'http://localhost:9090/files/1710756827594-微信截图_20240318180926.png', '2024-03-18', '通过', '图书', 1, '上架', 26);

INSERT INTO `goods` VALUES (19, '【官方正版】百年孤独 原著原版无删减中文译本 ', 39.60, '<p><img src=\"https://img.alicdn.com/imgextra/i3/2129856610/O1CN01z5eg4C1yhQfDUYBh7-2129856610.jpg\" width=\"100%\"/><img src=\"http://localhost:9090/files/1711418486618-image.png\" contenteditable=\"false\" style=\"font-size: 14px; max-width: 100%;\"/></p><br/>', '安徽省合肥市政务区111号', 'http://localhost:9090/files/1711418559078-微信截图_20240326100215.png', '2024-03-26', '通过', '图书', 1, '上架', 7);



-- ----------------------------

-- Table structure for help

-- ----------------------------

DROP TABLE IF EXISTS `help`;

CREATE TABLE `help`  (

  `id` int NOT NULL AUTO_INCREMENT COMMENT 'ID',

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

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

  `img` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '图片',

  `status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '状态',

  `user_id` int NULL DEFAULT NULL COMMENT '用户ID',

  `time` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '发布时间',

  `solved` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '是否解决',

  PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '求助信息' ROW_FORMAT = DYNAMIC;



-- ----------------------------

-- Records of help

-- ----------------------------



-- ----------------------------

-- Table structure for likes

-- ----------------------------

DROP TABLE IF EXISTS `likes`;

CREATE TABLE `likes`  (

  `id` int NOT NULL AUTO_INCREMENT COMMENT 'ID',

  `fid` int NULL DEFAULT NULL COMMENT '关联ID',

  `user_id` int NULL DEFAULT NULL COMMENT '点赞人ID',

  `module` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '模块',

  PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '点赞' ROW_FORMAT = DYNAMIC;



-- ----------------------------

-- Records of likes

-- ----------------------------



-- ----------------------------

-- Table structure for notice

-- ----------------------------

DROP TABLE IF EXISTS `notice`;

CREATE TABLE `notice`  (

  `id` int NOT NULL AUTO_INCREMENT COMMENT 'ID',

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

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

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

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

  PRIMARY KEY (`id`) USING BTREE

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



-- ----------------------------

-- Records of notice

-- ----------------------------

INSERT INTO `notice` VALUES (1, '今天系统正式上线，开始内测', '今天系统正式上线，开始内测', '2023-09-05', 'admin');

INSERT INTO `notice` VALUES (2, '所有功能都已完成，可以正常使用', '所有功能都已完成，可以正常使用', '2023-09-05', 'admin');

INSERT INTO `notice` VALUES (3, '今天天气很不错，可以出去一起玩了', '今天天气很不错，可以出去一起玩了', '2023-09-05', 'admin');



-- ----------------------------

-- Table structure for posts

-- ----------------------------

DROP TABLE IF EXISTS `posts`;

CREATE TABLE `posts`  (

  `id` int NOT NULL AUTO_INCREMENT COMMENT 'ID',

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

  `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL COMMENT '内容',

  `img` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '图片',

  `user_id` int NULL DEFAULT NULL COMMENT '用户ID',

  `time` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '发布时间',

  `circle` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '圈子',

  `descr` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '简介',

  `read_count` int NULL DEFAULT 0 COMMENT '浏览量',

  PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '帖子' ROW_FORMAT = DYNAMIC;



-- ----------------------------

-- Records of posts

-- ----------------------------



-- ----------------------------

-- Table structure for user

-- ----------------------------

DROP TABLE IF EXISTS `user`;

CREATE TABLE `user`  (

  `id` int NOT NULL AUTO_INCREMENT COMMENT 'ID',

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

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

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

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

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

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

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

  PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '用户信息' ROW_FORMAT = DYNAMIC;



-- ----------------------------

-- Records of user

-- ----------------------------



SET FOREIGN_KEY_CHECKS = 1;
Loading...
马建仓 AI 助手
尝试更多
代码解读
代码找茬
代码优化
1
https://gitee.com/Endurancer_Program/second-hand-project.git
git@gitee.com:Endurancer_Program/second-hand-project.git
Endurancer_Program
second-hand-project
SecondHandProject
master
点此查找更多帮助

搜索帮助

Git 命令在线学习 如何在 Gitee 导入 GitHub 仓库
Git 仓库基础操作
企业版和社区版功能对比
SSH 公钥设置
如何处理代码冲突
仓库体积过大，如何减小？
如何找回被删除的仓库数据
Gitee 产品配额说明
GitHub仓库快速导入Gitee及同步更新
什么是 Release（发行版）
将 PHP 项目自动发布到 packagist.org
评论
仓库举报
回到顶部