-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathchenfu.sql
196 lines (175 loc) · 15.7 KB
/
chenfu.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
/*
Navicat Premium Data Transfer
Source Server : moye
Source Server Type : MySQL
Source Server Version : 80030 (8.0.30)
Source Host : localhost:3306
Source Schema : chenfu
Target Server Type : MySQL
Target Server Version : 80030 (8.0.30)
File Encoding : 65001
Date: 18/03/2023 17:19:24
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for announcement
-- ----------------------------
DROP TABLE IF EXISTS `announcement`;
CREATE TABLE `announcement` (
`title` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '公告标题(长度不能超过30个字符)',
`content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '公告内容(最长1000字)',
`publisher_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '公告发布时间',
`search_id` int(32) UNSIGNED ZEROFILL NOT NULL AUTO_INCREMENT COMMENT '查找时用的唯一id',
PRIMARY KEY (`search_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of announcement
-- ----------------------------
INSERT INTO `announcement` VALUES ('开展内容整改专项行动', '作为平台企业，我们应当认真履行好企业主体责任，对网民负责、对社会负责。我们将组织全公司进行学习，全方位提高员工的思想觉悟，把对主体责任的认识作为企业纪律铁条，贯彻到日常工作中去。除了开展整改专项行动以外，我们还将主动配合有关部门加强对用户的正面引导和规范管理，制作和传播弘扬主旋律、正能量的内容，与行业内各平台一起推动行业健康发展，共同维护网络信息传播秩序，营造积极健康、风清气正的网络空间。', '2023-03-01 10:22:37', 00000000000000000000000000000001);
INSERT INTO `announcement` VALUES ('关于开展抵制<<原神>>工作报告', '“我们的文化不是拿去让你们随便用的，这不好笑。”\r\n\r\n他们觉得丘丘人是反派，所以被妖魔化，借鉴他们的舞蹈是在将他们印第安人妖魔化。\r\n\r\n参考借鉴是属于正常的创作范围，就拿创作灵感来说，本身就需要有一个参考的范围。\r\n\r\n而印第安人的祭拜行为其实就很适合展开联想和思考，并不是歧视，反而更像是一种思考和借鉴。', '2023-03-01 10:35:15', 00000000000000000000000000000002);
-- ----------------------------
-- Table structure for newwork
-- ----------------------------
DROP TABLE IF EXISTS `newwork`;
CREATE TABLE `newwork` (
`works` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '发表作品(唯一，防止抄袭)',
`works_describe` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '作品描述',
`appoint` int NOT NULL DEFAULT 0 COMMENT '点赞数',
`author_id` int(32) UNSIGNED ZEROFILL NOT NULL COMMENT '用户唯一id,用于识别用户',
`work_id` int(32) UNSIGNED ZEROFILL NOT NULL AUTO_INCREMENT COMMENT '作品唯一id,查找时唯一id',
`created_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '信息创建时间',
PRIMARY KEY (`work_id`) USING BTREE,
UNIQUE INDEX `work_unique`(`works` ASC) USING BTREE COMMENT '保证作品唯一'
) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of newwork
-- ----------------------------
INSERT INTO `newwork` VALUES ('/files/01130_9049698068.jpg', '孤独摇滚', 517, 00000000000000000000000000000004, 00000000000000000000000000000001, '2023-03-07 11:29:18');
INSERT INTO `newwork` VALUES ('/files/145250_17005731512.jpg', '牵着我的手', 33, 00000000000000000000000000000003, 00000000000000000000000000000002, '2023-03-07 11:29:18');
INSERT INTO `newwork` VALUES ('/files/16467_76799064315.jpg', '又生了个女儿~', 98, 00000000000000000000000000000001, 00000000000000000000000000000003, '2023-03-07 11:29:18');
INSERT INTO `newwork` VALUES ('/files/223136_49612231063.jpg', '都市龙娘', 211, 00000000000000000000000000000005, 00000000000000000000000000000004, '2023-03-07 11:29:18');
INSERT INTO `newwork` VALUES ('/files/f3baeca8589392d2923e6e65a37b245.jpg', '少女与海', 89, 00000000000000000000000000000002, 00000000000000000000000000000005, '2023-03-07 11:29:18');
-- ----------------------------
-- Table structure for newwork_like
-- ----------------------------
DROP TABLE IF EXISTS `newwork_like`;
CREATE TABLE `newwork_like` (
`user_id` int(32) UNSIGNED ZEROFILL NOT NULL COMMENT '点赞用户id',
`work_id` int(32) UNSIGNED ZEROFILL NOT NULL COMMENT '点赞作品id',
`created_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '信息创建时间',
PRIMARY KEY (`user_id`, `work_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of newwork_like
-- ----------------------------
INSERT INTO `newwork_like` VALUES (00000000000000000000000000000003, 00000000000000000000000000000003, '2023-03-07 11:30:45');
INSERT INTO `newwork_like` VALUES (00000000000000000000000000000004, 00000000000000000000000000000003, '2023-03-07 11:30:45');
INSERT INTO `newwork_like` VALUES (00000000000000000000000000000005, 00000000000000000000000000000001, '2023-03-18 17:12:08');
INSERT INTO `newwork_like` VALUES (00000000000000000000000000000005, 00000000000000000000000000000004, '2023-03-18 17:12:30');
INSERT INTO `newwork_like` VALUES (00000000000000000000000000000005, 00000000000000000000000000000005, '2023-03-18 17:12:25');
-- ----------------------------
-- Table structure for requirebox
-- ----------------------------
DROP TABLE IF EXISTS `requirebox`;
CREATE TABLE `requirebox` (
`title` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '需求标题',
`describe_require` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '需求描述',
`describe_image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '需求描述图,可以为空',
`money` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '价格范围',
`tag` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '需求类型',
`calendar` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '截稿日期',
`id` int(32) UNSIGNED ZEROFILL NOT NULL COMMENT '用户唯一id,用于识别用户',
`created_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '信息创建时间',
`search_id` int(32) UNSIGNED ZEROFILL NOT NULL AUTO_INCREMENT COMMENT '查找时唯一id',
PRIMARY KEY (`search_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of requirebox
-- ----------------------------
INSERT INTO `requirebox` VALUES ('看看我家宝宝', '新接回来的女宝，画成萝莉少女御姐都可以。想吃一口饭饭', '/files/QQ图片20230221141946.png', '50-1500', '自设/OC', '2023-05-01', 00000000000000000000000000000001, '2023-03-07 11:32:03', 00000000000000000000000000000001);
INSERT INTO `requirebox` VALUES ('黑白露肩头像', '两张人物头像，露肩膀，古风一男一女，头部需要简单的装饰，无需背景。会买断，价格可洽谈', '', '50-100', '头像', '2023-03-01', 00000000000000000000000000000002, '2023-03-07 11:32:03', 00000000000000000000000000000002);
INSERT INTO `requirebox` VALUES ('bl古风双人氛围插', '国风插画，需要多张，要擅长国风的，需要试稿', '/files/85044_44453568709.jpg', '100-200', '插画', '2023-03-01', 00000000000000000000000000000003, '2023-03-07 11:32:03', 00000000000000000000000000000003);
-- ----------------------------
-- Table structure for session
-- ----------------------------
DROP TABLE IF EXISTS `session`;
CREATE TABLE `session` (
`created_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '对话发表时间',
`source_id` int(32) UNSIGNED ZEROFILL NOT NULL COMMENT '发话方唯一id',
`target_id` int(32) UNSIGNED ZEROFILL NOT NULL COMMENT '目标方唯一id',
`content` json NOT NULL COMMENT '对话内容',
`search_id` int(32) UNSIGNED ZEROFILL NOT NULL AUTO_INCREMENT COMMENT '查找时唯一id',
PRIMARY KEY (`search_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 229 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of session
-- ----------------------------
-- ----------------------------
-- Table structure for showcase
-- ----------------------------
DROP TABLE IF EXISTS `showcase`;
CREATE TABLE `showcase` (
`works` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '推荐作品',
`author_comment` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '作者留言',
`price` decimal(10, 2) NOT NULL COMMENT '作品价格(初价)',
`sold_num` int NOT NULL COMMENT '已出售数量',
`id` int(32) UNSIGNED ZEROFILL NOT NULL COMMENT '用户唯一id,用于识别用户',
`created_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '用户信息创建时间',
`search_id` int(32) UNSIGNED ZEROFILL NOT NULL AUTO_INCREMENT COMMENT '查找时唯一id',
PRIMARY KEY (`search_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of showcase
-- ----------------------------
INSERT INTO `showcase` VALUES ('/files/122045_64565599030.jpg', '精美立绘固定价', 230.00, 25, 00000000000000000000000000000001, '2023-03-07 11:34:05', 00000000000000000000000000000001);
INSERT INTO `showcase` VALUES ('/files/132848_12887677513.jpg', 'live2D,不急的可以进来', 1500.00, 23, 00000000000000000000000000000002, '2023-03-07 11:34:05', 00000000000000000000000000000002);
INSERT INTO `showcase` VALUES ('/files/chenfuworks.jpg', '下单1h出成品图', 998.00, 100, 00000000000000000000000000000003, '2023-03-07 11:34:05', 00000000000000000000000000000003);
INSERT INTO `showcase` VALUES ('/files/QQ图片20230221141919.jpg', '出图快，并附赠live2D', 778.00, 50, 00000000000000000000000000000004, '2023-03-07 11:34:05', 00000000000000000000000000000004);
INSERT INTO `showcase` VALUES ('/files/QQ图片20230221141932.jpg', '私信留言要求，24小时内回复，价格商定', 211.00, 25, 00000000000000000000000000000005, '2023-03-07 11:34:05', 00000000000000000000000000000005);
-- ----------------------------
-- Table structure for trends
-- ----------------------------
DROP TABLE IF EXISTS `trends`;
CREATE TABLE `trends` (
`id` int(32) UNSIGNED ZEROFILL NOT NULL COMMENT '用户唯一id,用于识别用户',
`submited_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '用户发动态时间',
`user_recommend` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '用户留言',
`user_photos` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '用户发表图片，可以为多张或空',
`search_id` int(10) UNSIGNED ZEROFILL NOT NULL AUTO_INCREMENT COMMENT '查找时唯一id',
PRIMARY KEY (`search_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of trends
-- ----------------------------
INSERT INTO `trends` VALUES (00000000000000000000000000000001, '2023-02-22 15:32:52', '又生了两个女儿', '/files/16467_76799064315.jpg;/files/132848_12887677513.jpg', 0000000001);
INSERT INTO `trends` VALUES (00000000000000000000000000000002, '2023-02-22 16:27:41', '回收旧立绘，旧live2D，旧动图', NULL, 0000000002);
INSERT INTO `trends` VALUES (00000000000000000000000000000003, '2023-02-22 16:22:08', '完结撒花✿✿ヽ(°▽°)ノ✿完结撒花✿✿ヽ(°▽°)ノ✿完结撒花✿✿ヽ(°▽°)ノ✿完结撒花✿✿ヽ(°▽°)ノ✿完结撒花✿✿ヽ(°▽°)ノ✿完结撒花✿✿ヽ(°▽°)ノ✿完结撒花✿✿ヽ(°▽°)ノ✿完结撒花✿✿ヽ(°▽°)ノ✿完结撒花✿✿ヽ(°▽°)ノ✿完结撒花✿✿ヽ(°▽°)ノ✿完结撒花✿✿ヽ(°▽°)ノ✿完结撒花✿✿ヽ(°▽°)ノ✿完结撒花✿✿ヽ(°▽°)ノ✿', '/files/1515_8654509424.jpg', 0000000003);
-- ----------------------------
-- Table structure for user_login
-- ----------------------------
DROP TABLE IF EXISTS `user_login`;
CREATE TABLE `user_login` (
`password` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '用户输入密码',
`phone` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '用户注册手机号码的哈希值',
`profile` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '用户头像',
`created_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '账号创建时间',
`modify_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '最后一次修改时间',
`token` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '令牌',
`salt` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '盐值',
`username` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '用户名(初始值为随机值，用户自行更改)',
`id` int(32) UNSIGNED ZEROFILL NOT NULL AUTO_INCREMENT COMMENT '用户唯一id',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `unique_token`(`token` ASC) USING BTREE COMMENT 'token唯一',
UNIQUE INDEX `unique_phone`(`phone` ASC) USING BTREE COMMENT 'phone唯一'
) ENGINE = InnoDB AUTO_INCREMENT = 30 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of user_login
-- ----------------------------
INSERT INTO `user_login` VALUES ('a784259af7381de02157b0e097668db5', '19820482808', '/files/4a4139a84e437c3a90821c87265340c5.jpg', '2023-02-28 21:14:10', '2023-03-13 14:00:36', 'bd37d3e98f086d6683655f2469b611f7', 'de34f0f880ee09d56a2df39b53e9534b', '沉浮1', 00000000000000000000000000000001);
INSERT INTO `user_login` VALUES ('350a7623174a8c86b1b107e97f293344', '19820482807', '/files/chenfuProfile.jpg', '2023-02-28 21:14:28', '2023-03-05 22:31:57', '712b606ca1216d2e6f33d391bd36e4b3', '930096f0c63a9ded00517d0f777d7b97', '沉浮2', 00000000000000000000000000000002);
INSERT INTO `user_login` VALUES ('91f404b4421bd7f5c0388753cdcf1fe8', '19820482806', '/files/ca2797d24566adfa7d3f6b04b7a1deb4.webp', '2023-02-28 21:14:41', '2023-03-05 22:32:09', 'c3969c0cfefe471de7f9d43ed22a3b4a', '77e932ae9524b0a0b6b1d2633458a5d0', '沉浮3', 00000000000000000000000000000003);
INSERT INTO `user_login` VALUES ('784e413312e2b37c20e3367f06665d93', '19820482809', '/files/b2d8197fb7606bc37383dc876487e846.png', '2023-03-05 22:29:44', '2023-03-05 22:32:17', '172e8eb73785bea8df382b382ab74f65', '2d986b41382f99a9ad4fe27847471bfa', '沉浮4', 00000000000000000000000000000004);
INSERT INTO `user_login` VALUES ('6b0a6a8183b70fffcd957718013ae2b1', '19820482810', '/files/沉浮兔.png', '2023-03-02 16:31:31', '2023-03-05 22:32:21', '4b653abd1540370f78cc8090509cebf5', '95136de22897b1998ab3efa1522868c0', '沉浮5', 00000000000000000000000000000005);
INSERT INTO `user_login` VALUES ('048e74208ede897328ecd27b96aa3623', '19820482811', '/files/d866fab7a9aa13fa86b2fd7619f9153c.jpg', '2023-03-13 12:11:14', '2023-03-13 12:57:28', '358c4e42bc98c8774b41396a9f60a1ed', '3c628fb490d9ee5320d66ba8e7a9744f', '112233', 00000000000000000000000000000029);
SET FOREIGN_KEY_CHECKS = 1;