/* SQLyog Ultimate v12.08 (64 bit) MySQL - 5.7.31 : Database - yeblog ********************************************************************* */ /*!40101 SET NAMES utf8 */; /*!40101 SET SQL_MODE=''*/; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; CREATE DATABASE /*!32312 IF NOT EXISTS*/`yeblog` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_bin */; USE `yeblog`; /*Table structure for table `t_article` */ DROP TABLE IF EXISTS `t_article`; CREATE TABLE `t_article` ( `id` int(11) NOT NULL AUTO_INCREMENT, `category_id` int(11) DEFAULT NULL, `title` varchar(200) COLLATE utf8mb4_bin NOT NULL, `abstract_text` varchar(150) COLLATE utf8mb4_bin NOT NULL, `keywords` varchar(150) COLLATE utf8mb4_bin DEFAULT NULL, `views` int(11) NOT NULL DEFAULT '0', `status` tinyint(4) NOT NULL DEFAULT '0', `create_time` datetime NOT NULL, `update_time` datetime NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin; /*Data for the table `t_article` */ insert into `t_article`(`id`,`category_id`,`title`,`abstract_text`,`keywords`,`views`,`status`,`create_time`,`update_time`) values (1,NULL,'Hello, YeBlog','这是一篇 sample','',0,1,'2020-11-15 16:54:05','2020-11-15 16:54:05'); /*Table structure for table `t_article_comment` */ DROP TABLE IF EXISTS `t_article_comment`; CREATE TABLE `t_article_comment` ( `id` int(11) NOT NULL AUTO_INCREMENT, `article_id` int(11) NOT NULL COMMENT '所属 article', `author` varchar(20) COLLATE utf8mb4_bin NOT NULL COMMENT '评论者昵称', `parent_id` int(11) DEFAULT NULL COMMENT '层id', `reply_to_id` int(11) DEFAULT NULL COMMENT '回复id', `reply_to` varchar(20) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '被回复人', `content` varchar(300) COLLATE utf8mb4_bin NOT NULL COMMENT '评论内容', `admin` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否为博主: 1代表是', `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '审核状态: 1(已审核)/0(未审核)', `email` varchar(320) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '留言人邮箱', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin; /*Data for the table `t_article_comment` */ /*Table structure for table `t_article_content` */ DROP TABLE IF EXISTS `t_article_content`; CREATE TABLE `t_article_content` ( `id` int(11) NOT NULL COMMENT '文章ID', `md` mediumtext COLLATE utf8mb4_bin NOT NULL COMMENT '文章内容 MD格式', `html` mediumtext COLLATE utf8mb4_bin NOT NULL COMMENT '文章内容 HTML格式', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin; /*Data for the table `t_article_content` */ insert into `t_article_content`(`id`,`md`,`html`) values (1,'YeBlog是一个基于 Springboot 和 Vue 的前后端分离博客项目。后台文章编辑使用 Markdown。\n项目地址\n- 前台展示:[yeblog/web](https://github.com/yeyeck/yeblog-web)\n- 后台管理:[yeblog/admin](https://github.com/yeyeck/admin)\n- 后端:[yeblog-backend](https://github.com/yeyeck/yeblog-backend)\n\n# C\n```c\n# include\n\nint main()\n{\n print(\"Hello, World!\");\n return 0;\n}\n```\n\n# java\n```java\nclass HelloWorld {\n public static void main(String[] args){\n System.out.println(\"Hello, World\");\n }\n}\n```\n# Python\n```python\ndef sum(a, b):\n return a + b\nprint(\"sum of 1+2: \", sum(1, 2))\n``` \n# HTML\n```html\n
\n yeblog\n
\n\n\n```\n# Katex\n$x^2 + y^2 = z^2$','

YeBlog是一个基于 Springboot 和 Vue 的前后端分离博客项目。后台文章编辑使用 Markdown。
\n项目地址

\n\n

C

\n
# include<stadio.h>\n\nint main()\n{\n print("Hello, World!");\n return 0;\n}\n
\n

java

\n
class HelloWorld {\n public static void main(String[] args){\n System.out.println("Hello, World");\n }\n}\n
\n

Python

\n
def sum(a, b):\n return a + b\nprint("sum of 1+2: ", sum(1, 2))\n
\n

HTML

\n
<div>\n <a href="www.yeyeck.com">yeblog</a>\n</div>\n<script>\n$("#id").click(function(){\n consolo.log("Hello, World!")\n})\n</script>\n<style>\n.yeblog {\n width: 120px;\n height: 120px;\n padding: 0 0 0 0;\n}\n</style>\n
\n

Katex

\n

x2+y2=z2x^2 + y^2 = z^2x2+y2=z2

\n'); /*Table structure for table `t_article_label` */ DROP TABLE IF EXISTS `t_article_label`; CREATE TABLE `t_article_label` ( `article_id` int(11) NOT NULL, `label_id` int(11) NOT NULL, PRIMARY KEY (`article_id`,`label_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin; /*Data for the table `t_article_label` */ /*Table structure for table `t_category` */ DROP TABLE IF EXISTS `t_category`; CREATE TABLE `t_category` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(50) COLLATE utf8mb4_bin NOT NULL, `create_time` date NOT NULL, `update_time` date NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin; /*Data for the table `t_category` */ /*Table structure for table `t_label` */ DROP TABLE IF EXISTS `t_label`; CREATE TABLE `t_label` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(20) COLLATE utf8mb4_bin DEFAULT NULL, `create_time` date NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `NAME` (`name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin; /*Data for the table `t_label` */ /*Table structure for table `t_link` */ DROP TABLE IF EXISTS `t_link`; CREATE TABLE `t_link` ( `id` int(11) NOT NULL AUTO_INCREMENT, `label` varchar(20) COLLATE utf8mb4_bin NOT NULL, `type` enum('footer','friend','navigation') COLLATE utf8mb4_bin NOT NULL, `link` varchar(200) COLLATE utf8mb4_bin NOT NULL, `new_blank` tinyint(1) NOT NULL DEFAULT '1', `order_num` tinyint(4) NOT NULL, `create_time` datetime NOT NULL, `update_time` datetime NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin; /*Data for the table `t_link` */ /*Table structure for table `t_settings` */ DROP TABLE IF EXISTS `t_settings`; CREATE TABLE `t_settings` ( `id` tinyint(4) NOT NULL, `json_value` json NOT NULL, `update_time` datetime NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin; /*Data for the table `t_settings` */ insert into `t_settings`(`id`,`json_value`,`update_time`) values (1,'{\"domain\": \"\", \"keywords\": \"JAVA, VUE, SpringBoot, 前后端分离\", \"psRecord\": \"\", \"siteName\": \"YeBlog\", \"subTitle\": \"个人博客\", \"icpRecord\": \"\", \"description\": \"YeBlog————一个简单轻量的个人博客\", \"psRecordUrl\": \"\", \"icpRecordUrl\": \"\"}','2020-08-27 06:35:34'),(3,'{\"host\": \"\", \"opened\": false, \"password\": \"\", \"username\": \"\"}','2020-07-17 07:02:25'); /*Table structure for table `t_user` */ DROP TABLE IF EXISTS `t_user`; CREATE TABLE `t_user` ( `id` int(11) NOT NULL AUTO_INCREMENT, `username` varchar(80) COLLATE utf8mb4_bin NOT NULL, `nickname` varchar(32) COLLATE utf8mb4_bin DEFAULT NULL, `password` varchar(32) COLLATE utf8mb4_bin NOT NULL, `salt` varchar(32) COLLATE utf8mb4_bin NOT NULL, `role` enum('admin','author','member') COLLATE utf8mb4_bin NOT NULL, `create_time` date NOT NULL, `update_time` date NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `username` (`username`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin; /*Data for the table `t_user` */ insert into `t_user`(`id`,`username`,`nickname`,`password`,`salt`,`role`,`create_time`,`update_time`) values (1,'Admin','Admin','1c76569fbdadeb7c8dab65f63689f780','06e99747674d4c4e9af14db0a8e66d5b','admin','2020-11-15','2020-11-15'); /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;