个人博客系统(vue+springboot+mysql8.x).zip

/* Navicat Premium Data Transfer Source Server : mysql Source Server Type : MySQL Source Server Version : 80018 (8.0.18) Source Host : 47.118.194.212:3306 Source Schema : blog Target Server Type : MySQL Target Server Version : 80018 (8.0.18) File Encoding : 65001 Date: 09/05/2023 11:25:14 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for article -- ---------------------------- DROP TABLE IF EXISTS `article`; CREATE TABLE `article` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id', `user_id` int(11) NOT NULL COMMENT '用户ID', `sort_id` int(11) NOT NULL COMMENT '分类ID', `label_id` int(11) NOT NULL COMMENT '标签ID', `article_cover` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '封面', `article_title` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '博文标题', `article_content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '博文内容', `view_count` int(11) NOT NULL DEFAULT 0 COMMENT '浏览量', `like_count` int(11) NOT NULL DEFAULT 0 COMMENT '点赞数', `view_status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '是否可见[0:否，1:是]', `password` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '密码', `recommend_status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否推荐[0:否，1:是]', `comment_status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '是否启用评论[0:否，1:是]', `create_time` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `update_time` datetime NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '最终修改时间', `update_by` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '最终修改人', `deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否启用[0:未删除，1:已删除]', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '文章表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of article -- ---------------------------- INSERT INTO `article` VALUES (1, 1, 1, 1, 'http://jiulixingkong.oss-cn-hangzhou.aliyuncs.com/blog/helo.png', '小王子', '#### 小王子和玫瑰\n就算世界上有一万多和你一模一样的花，你也是我独一无二的玫瑰。\n\n#### 小王子和狐狸\n你驯养了我，你和我之间建立起了羁绊\n\n**星星**\n人们眼里的星星并不都一样。对旅行的人来说，星星是向导。对别的人来说，\n星星只是些小亮光。对另外一些学者来说，星星就是他们探讨的学问。对我所遇见的那个\n你知道吗，人在特别悲伤的时候就喜欢看日落，有一天我看了四十四次日落。\n\n附注\n[https://baike.baidu.com/item/%E5%B0%8F%E7%8E%8B%E5%AD%90/270?fr=aladdin](小王子百科)', 108, 0, 1, NULL, 1, 1, '2023-03-24 21:36:12', '2023-05-08 21:32:04', 'hello', 0); INSERT INTO `article` VALUES (2, 1, 2, 2, 'http://jiulixingkong.oss-cn-hangzhou.aliyuncs.com/blog/helo.png', '你的名字', '即使我忘记你的姓名，忘记你的样子，但我不会忘记我爱你，你的过去梦中的我依稀参与，所以你的未来我愿奉陪到底我和你的那些回忆，你不会比我铭记;我爱你的那些证据，却变成公开秘密;给你写的那本日记，已经被搁浅代替', 44, 0, 1, NULL, 0, 1, '2023-03-22 22:11:15', '2023-05-08 21:34:43', 'Sar', 0); INSERT INTO `article` VALUES (3, 1, 1, 1, 'http://jiulixingkong.oss-cn-hangzhou.aliyuncs.com/blog/helo.png', '去你的岛', '有一天，我的床破窗飞行，来到了一个无人的岛**粗体**', 54, 0, 1, NULL, 0, 1, '2023-03-08 15:10:18', '2023-05-08 15:20:21', 'hello', 0); INSERT INTO `article` VALUES (4, 1, 3, 4, 'http://jiulixingkong.oss-cn-hangzhou.aliyuncs.com/blog/1589665325711042c4c7c0e4ff4c6868.jpeg', '很任性', '花开的时候最珍贵，\n花落了就枯萎', 51, 0, 1, NULL, 0, 1, '2023-04-09 16:13:22', '2023-05-05 13:40:35', NULL, 1); INSERT INTO `article` VALUES (5, 1, 3, 4, 'http://jiulixingkong.oss-cn-hangzhou.aliyuncs.com/blog/rBUCgGRUdZGANYKQAAGBku2nBu0510.jpg', '湖人vs勇士', '1v1战平', 7, 0, 1, NULL, 1, 1, '2023-05-05 13:30:03', '2023-05-08 23:38:06', NULL, 0); INSERT INTO `article` VALUES (6, 1, 3, 5, 'http://jiulixingkong.oss-cn-hangzhou.aliyuncs.com/blog/rBUCgGRUdZGANYKQAAGBku2nBu0510.jpg', '勇士能否卫冕', '***我觉得可以你们觉得呢***', 2, 0, 1, NULL, 1, 1, '2023-05-05 13:36:26', '2023-05-07 20:11:31', NULL, 0); INSERT INTO `article` VALUES (7, 1, 1, 3, 'http://jiulixingkong.oss-cn-hangzhou.aliyuncs.com/blog/caefe0bdc80b02e81c5768a365021399(1).jpg', '活着', '余华的小说活着，写尽了人世间的疾苦', 2, 0, 1, NULL, 0, 1, '2023-05-05 13:43:11', '2023-05-05 13:43:58', NULL, 0); -- ---------------------------- -- Table structure for comment -- ---------------------------- DROP TABLE IF EXISTS `comment`; CREATE TABLE `comment` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id', `source` int(11) NOT NULL COMMENT '评论来源标识', `parent_comment_id` int(11) NOT NULL DEFAULT 0 COMMENT '父评论ID', `user_id` int(11) NOT NULL COMMENT '发表用户ID', `floor_comment_id` int(11) NULL DEFAULT NULL COMMENT '楼层评论ID', `parent_user_id` int(11) NULL DEFAULT NULL COMMENT '父发表用户名ID', `like_count` int(11) NOT NULL DEFAULT 0 COMMENT '点赞数', `comment_content` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '评论内容', `comment_info` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '评论额外信息', `create_time` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否启用[0:未删除，1:已删除]', PRIMARY KEY (`id`) USING BTREE, INDEX `source`(`source` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 19 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '文章评论表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of comment -- ---------------------------- INSERT INTO `comment` VALUES (1, 1, 0, 1, NULL, NULL, 0, '你好', NULL, '2023-03-17 12:44:45', 0); INSERT INTO `comment` VALUES (2, 1, 1, 1, 1, 1, 0, '你好', NULL, '2023-03-09 12:44:53', 0); INSERT INTO `comment` VALUES (3, 1, 2, 1, 1, 1, 0, '你好', NULL, '2023-03-09 12:44:58', 1); INSERT INTO `comment` VALUES (4, 1, 3, 1, 1, 1, 0, '你好', NULL, '2023-03-01 12:45:12', 0); INSERT INTO `comment` VALUES (5, 0, 0, 1, NULL, NULL, 0, '[捂嘴][皱眉][皱眉][奋斗][奋斗][奋斗][奋斗][奋斗][奋斗][奋斗][奋斗][可怜][可怜][可怜][可怜][可怜][奋斗][奋斗][奋斗][奋斗][奋斗][可怜][可怜][可怜][可怜][可怜][可怜][呲牙][呲牙][呲牙][呲牙][呲牙][呲牙][呲牙][呲牙]', NULL, '2023-03-01 12:45:58', 1); INSERT INTO `comment` VALUES (6, 1, 0, 1, NULL, NULL, 0, 'hello', NULL, '2023-04-01 08:27:10', 0); INSERT INTO `comment` VALUES (7, 1, 0, 1, NULL, NULL, 0, 'hello', NULL, '2023-03-01 08:28:27', 0); INSERT INTO `comment` VALUES (8, 1, 0, 1, NULL, NULL, 0, '加密工具类', NULL, '2023-04-01 08:36:14', 1); INSERT INTO `comment` VALUES (9, 3, 0, 1, NULL, NULL, 0, '嗯哼', NULL, '2023-04-01 08:43:14', 1); INSERT INTO `comment` VALUES (10, 4, 0, 1, NULL, NULL, 0, '[捂嘴][鼓掌][烦恼][吐舌]', NULL, '2023-04-09 16:29:51', 1); INSERT INTO `comment` VALUES (11, 4, 0, 1, NULL, NULL, 0, '<Sar,http://jiulixingkong.oss-cn-hangzhou.aliyuncs.com/blog/bg1.jpg>', NULL, '2023-04-09 16:30:07', 1); INSERT INTO `comment` VALUES (12, 0, 0, 1, NULL, NULL, 0, '<Sar,http://jiulixingkong.os