-
Notifications
You must be signed in to change notification settings - Fork 0
/
vblog.sql
195 lines (179 loc) · 12.8 KB
/
vblog.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
create database vblog;
use vblog;
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for category
-- ----------------------------
DROP TABLE IF EXISTS `category`;
CREATE TABLE `category` (
`id` bigint(32) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
`name` varchar(512) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '标题',
`content` text COLLATE utf8mb4_unicode_ci COMMENT '内容描述',
`summary` text COLLATE utf8mb4_unicode_ci,
`icon` varchar(128) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '图标',
`post_count` int(11) unsigned DEFAULT '0' COMMENT '该分类的内容数量',
`order_num` int(11) DEFAULT NULL COMMENT '排序编码',
`parent_id` bigint(32) unsigned DEFAULT NULL COMMENT '父级分类的ID',
`meta_keywords` varchar(256) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'SEO关键字',
`meta_description` varchar(256) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'SEO描述内容',
`created` datetime DEFAULT NULL COMMENT '创建日期',
`modified` datetime DEFAULT NULL,
`status` tinyint(2) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Records of category
-- ----------------------------
INSERT INTO `category` VALUES ('1', '提问', null, null, null, '0', null, null, null, null, '2020-04-28 22:36:48', null, '0');
INSERT INTO `category` VALUES ('2', '分享', null, null, null, '0', null, null, null, null, '2020-04-28 22:36:48', null, '0');
INSERT INTO `category` VALUES ('3', '讨论', null, null, null, '0', null, null, null, null, '2020-04-28 22:36:48', null, '0');
INSERT INTO `category` VALUES ('4', '建议', null, null, null, '0', null, null, null, null, '2020-04-28 22:36:48', null, '0');
-- ----------------------------
-- Table structure for comment
-- ----------------------------
DROP TABLE IF EXISTS `comment`;
CREATE TABLE `comment` (
`id` bigint(32) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
`content` longtext COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '评论的内容',
`parent_id` bigint(32) DEFAULT NULL COMMENT '回复的评论ID',
`post_id` bigint(32) NOT NULL COMMENT '评论的内容ID',
`user_id` bigint(32) NOT NULL COMMENT '评论的用户ID',
`vote_up` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '“顶”的数量',
`vote_down` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '“踩”的数量',
`level` tinyint(2) unsigned NOT NULL DEFAULT '0' COMMENT '置顶等级',
`status` tinyint(2) DEFAULT NULL COMMENT '评论的状态',
`created` datetime NOT NULL COMMENT '评论的时间',
`modified` datetime DEFAULT NULL COMMENT '评论的更新时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Records of comment
-- ----------------------------
INSERT INTO `comment` VALUES ('1', '老铁666 ~ ', null, 1, 1, '0', 0, 0, null, '2021-02-04 22:36:48', '2021-02-04 22:36:48');
INSERT INTO `comment` VALUES ('2', '真棒 ~ ', null, 2, 2, '0', 0, 0, null, '2021-02-02 22:36:48', '2021-02-02 22:36:48');
INSERT INTO `comment` VALUES ('3', '卧槽！', null, 3, 2, '0', 0, 0, null, '2021-02-05 07:36:48', '2021-02-05 07:36:48');
INSERT INTO `comment` VALUES ('4', '分享了！', null, 1, 3, '0', 0, 0, null, '2021-02-01 22:36:48', '2021-02-01 22:36:48');
-- ----------------------------
-- Table structure for post
-- ----------------------------
DROP TABLE IF EXISTS `post`;
CREATE TABLE `post` (
`id` bigint(32) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
`title` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '标题',
`content` longtext COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '内容',
`edit_mode` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0' COMMENT '编辑模式：html可视化，markdown ..',
`category_id` bigint(32) DEFAULT NULL,
`user_id` bigint(32) DEFAULT NULL COMMENT '用户ID',
`vote_up` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '支持人数',
`vote_down` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '反对人数',
`view_count` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '访问量',
`comment_count` int(11) NOT NULL DEFAULT '0' COMMENT '评论数量',
`recommend` tinyint(1) DEFAULT NULL COMMENT '是否为精华',
`level` tinyint(2) NOT NULL DEFAULT '0' COMMENT '置顶等级',
`status` tinyint(2) DEFAULT NULL COMMENT '状态',
`created` datetime DEFAULT NULL COMMENT '创建日期',
`modified` datetime DEFAULT NULL COMMENT '最后更新日期',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Records of post
-- ----------------------------
INSERT INTO `post` VALUES ('1', 'Github上最值得学习的100个Java开源项目，涵盖各种技术栈！', ' 你有多久没好好学习一个开源项目了？\n\n你是否经常为找不到好的开源项目而烦恼？\n\n你是否为不知道怎么入手去看一个开源项目？\n\n你是否想看别人的项目学习笔记？\n\n你是否想跟着别人的项目搭建过程一步一步跟着做项目？\n\n为了让更多Java的开发者能更容易找到值得学习的开源项目，我搭建了这个Java开源学习网站，宗旨梳理Java知识，共享开源项目笔记。来瞧一瞧：\n\nimg[//image-1300566513.cos.ap-guangzhou.myqcloud.com/upload/images/20200414/473f73a3eb6f471e8154620a9c1d5306.png] \n\n网站截图中可以看出，点击筛选条件组合之后，再点击搜索就会搜索出对应的开源项目。\n\n比如打开renren-fast项目，可以看到具体项目的信息，以及模块解析。\n\nimg[//image-1300566513.cos.ap-guangzhou.myqcloud.com/upload/images/20200414/f74740692dab4d9c937cd56336ead1b4.png]\n\n这样，学习一个开源项目就不再费劲，每天学习一个开源项目，在不知不觉中提升技术水平！目前网站已经收录了近100个开源项目，让Java不再难懂！\n\n直接扫公众号下方的二维码，回复关键字【网站】即可获得网站的域名地址！\n\nimg[//image-1300566513.cos.ap-guangzhou.myqcloud.com/upload/images/20200414/f58f7c6d038c4dfb99bd9cf40935392e.png]\n\n关注上方的公众号二维码\n\n回复【网站】即可获取项目域名地址。\n', '0', '1', '1', '0', '0', '5', '2', '1', '1', null, '2020-04-28 14:41:41', '2020-04-28 14:41:41');
INSERT INTO `post` VALUES ('2', '关注公众号：MarkerHub，一起学习Java', '关注学习：\n\nimg[//image-1300566513.cos.ap-guangzhou.myqcloud.com/upload/images/20200414/f58f7c6d038c4dfb99bd9cf40935392e.png] ', '0', '1', '1', '0', '0', '3', '1', '1', '1', null, '2020-04-28 14:55:16', '2020-04-28 14:55:16');
INSERT INTO `post` VALUES ('3', '111111111111', '1222222222222222', '0', '1', '1', '0', '0', '1', '1', '0', '0', null, '2020-04-28 14:55:48', '2020-04-28 14:55:48');
INSERT INTO `post` VALUES ('4', '厉害', '3333', '0', '1', '1', '0', '0', '1', '1', '0', '0', null, '2020-04-28 14:55:48', '2020-04-28 14:55:48');
-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
`id` bigint(32) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
`username` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '昵称',
`password` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '密码',
`email` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '邮件',
`mobile` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '手机电话',
`point` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '积分',
`sign` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '个性签名',
`gender` varchar(16) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '性别',
`wechat` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '微信号',
`vip_level` int(32) DEFAULT NULL COMMENT 'vip等级',
`birthday` datetime DEFAULT NULL COMMENT '生日',
`avatar` varchar(256) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '头像',
`post_count` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '内容数量',
`comment_count` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '评论数量',
`status` tinyint(2) NOT NULL DEFAULT '0' COMMENT '状态',
`lasted` datetime DEFAULT NULL COMMENT '最后的登陆时间',
`created` datetime NOT NULL COMMENT '创建日期',
`modified` datetime DEFAULT NULL COMMENT '最后修改时间',
PRIMARY KEY (`id`),
UNIQUE KEY `username` (`username`) USING BTREE,
UNIQUE KEY `email` (`email`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES ('1', 'MarkerHub', '96e79218965eb72c92a549dd5a330112', '[email protected]', null, '0', '关注公众号：MarkerHub，一起学Java！！', '0', null, '0', null, '/res/images/avatar/default.png', '0', '0', '0', '2020-04-28 14:54:11', '2020-04-28 14:37:24', null);
INSERT INTO `user` VALUES ('2', 'test007', '96e79218965eb72c92a549dd5a330112', '[email protected]', null, '0', null, '0', null, '0', null, '/res/images/avatar/default.png', '0', '0', '0', null, '2020-04-28 14:45:07', null);
INSERT INTO `user` VALUES ('3', 'test004', '96e79218965eb72c92a549dd5a330112', '[email protected]', null, '0', null, '0', null, '0', null, '/res/images/avatar/default.png', '0', '0', '0', null, '2020-04-28 14:48:26', null);
INSERT INTO `user` VALUES ('4', 'test005', '96e79218965eb72c92a549dd5a330112', '[email protected]', null, '0', null, '0', null, '0', null, '/res/images/avatar/default.png', '0', '0', '0', null, '2020-04-28 14:48:26', null);
INSERT INTO `user` VALUES ('5', 'test00756', '96e79218965eb72c92a549dd5a330112', '[email protected]', null, '0', null, '0', null, '0', null, '/res/images/avatar/default.png', '0', '0', '0', null, '2020-04-28 14:53:49', null);
-- ----------------------------
-- Table structure for user_action
-- ----------------------------
DROP TABLE IF EXISTS `user_action`;
CREATE TABLE `user_action` (
`id` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`user_id` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '用户ID',
`action` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '动作类型',
`point` int(11) DEFAULT NULL COMMENT '得分',
`post_id` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '关联的帖子ID',
`comment_id` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '关联的评论ID',
`created` datetime DEFAULT NULL,
`modified` datetime DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Records of user_action
-- ----------------------------
-- ----------------------------
-- Table structure for user_collection
-- ----------------------------
DROP TABLE IF EXISTS `user_collection`;
CREATE TABLE `user_collection` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`user_id` bigint(20) NOT NULL,
`post_id` bigint(20) NOT NULL,
`post_user_id` bigint(20) NOT NULL,
`created` datetime NOT NULL,
`modified` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Records of user_collection
-- ----------------------------
INSERT INTO `user_collection` VALUES ('1', '1', '1', '1', '2020-02-28 14:53:49', '2020-04-28 14:53:49');
INSERT INTO `user_collection` VALUES ('2', '1', '2', '1', '2020-02-28 14:53:49', '2020-04-28 14:53:49');
INSERT INTO `user_collection` VALUES ('3', '1', '3', '1', '2020-02-28 14:53:49', '2020-04-28 14:53:49');
-- ----------------------------
-- Table structure for user_message
-- ----------------------------
DROP TABLE IF EXISTS `user_message`;
CREATE TABLE `user_message` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`from_user_id` bigint(20) COMMENT '发送消息的用户ID',
`to_user_id` bigint(20) NOT NULL COMMENT '接收消息的用户ID',
`post_id` bigint(20) DEFAULT NULL COMMENT '消息可能关联的帖子',
`comment_id` bigint(20) DEFAULT NULL COMMENT '消息可能关联的评论',
`content` text COLLATE utf8mb4_unicode_ci,
`type` tinyint(2) DEFAULT NULL COMMENT '消息类型',
`created` datetime NOT NULL,
`modified` datetime DEFAULT NULL,
`status` int(11) DEFAULT 0,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Records of user_message
-- ----------------------------
INSERT INTO `user_message` VALUES ('1', '2', '1', '1', '1', '评论了评论', '2', '2020-02-28 14:53:49', null, 0);
INSERT INTO `user_message` VALUES ('2', null, '1', null, null, '这是系统消息！', '0','2020-02-28 14:53:49', null, 0);
INSERT INTO `user_message` VALUES ('3', '3', '1', '1', '1', '3号评论了你的文章', '1','2020-02-28 14:53:49', null, 0);