/*
SQLyog Ultimate v8.32
MySQL - 5.7.23 : Database - my_blog_db
*********************************************************************
*/
/*!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*/`my_blog_db` /*!40100 DEFAULT CHARACTER SET utf8 */;
USE `my_blog_db`;
/*Table structure for table `generator_test` */
DROP TABLE IF EXISTS `generator_test`;
CREATE TABLE `generator_test` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
`test` varchar(100) NOT NULL COMMENT '测试字段',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*Data for the table `generator_test` */
/*Table structure for table `jdbc_test` */
DROP TABLE IF EXISTS `jdbc_test`;
CREATE TABLE `jdbc_test` (
`type` varchar(100) DEFAULT NULL COMMENT '类型',
`name` varchar(100) DEFAULT NULL COMMENT '名称'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*Data for the table `jdbc_test` */
insert into `jdbc_test`(`type`,`name`) values ('com.zaxxer.hikari.HikariDataSource','hikari数据源'),('org.apache.commons.dbcp2.BasicDataSource','dbcp2数据源'),('test','测试类'),('类别2','测试类2');
/*Table structure for table `tb_admin_user` */
DROP TABLE IF EXISTS `tb_admin_user`;
CREATE TABLE `tb_admin_user` (
`admin_user_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '管理员id',
`login_user_name` varchar(50) NOT NULL COMMENT '管理员登陆名称',
`login_password` varchar(50) NOT NULL COMMENT '管理员登陆密码',
`nick_name` varchar(50) NOT NULL COMMENT '管理员显示昵称',
`locked` tinyint(4) DEFAULT '0' COMMENT '是否锁定 0未锁定 1已锁定无法登陆',
PRIMARY KEY (`admin_user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
/*Data for the table `tb_admin_user` */
insert into `tb_admin_user`(`admin_user_id`,`login_user_name`,`login_password`,`nick_name`,`locked`) values (1,'admin','e10adc3949ba59abbe56e057f20f883e','超级管理员',0);
/*Table structure for table `tb_blog` */
DROP TABLE IF EXISTS `tb_blog`;
CREATE TABLE `tb_blog` (
`blog_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '博客表主键id',
`blog_title` varchar(200) NOT NULL COMMENT '博客标题',
`blog_sub_url` varchar(200) NOT NULL COMMENT '博客自定义路径url',
`blog_cover_image` varchar(200) NOT NULL COMMENT '博客封面图',
`blog_content` mediumtext NOT NULL COMMENT '博客内容',
`blog_category_id` int(11) NOT NULL COMMENT '博客分类id',
`blog_category_name` varchar(50) NOT NULL COMMENT '博客分类(冗余字段)',
`blog_tags` varchar(200) NOT NULL COMMENT '博客标签',
`blog_status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '0-草稿 1-发布',
`blog_views` bigint(20) NOT NULL DEFAULT '0' COMMENT '阅读量',
`enable_comment` tinyint(4) NOT NULL DEFAULT '0' COMMENT '0-允许评论 1-不允许评论',
`is_deleted` tinyint(4) NOT NULL DEFAULT '0' COMMENT '是否删除 0=否 1=是',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '添加时间',
`update_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '修改时间',
PRIMARY KEY (`blog_id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;
/*Data for the table `tb_blog` */
insert into `tb_blog`(`blog_id`,`blog_title`,`blog_sub_url`,`blog_cover_image`,`blog_content`,`blog_category_id`,`blog_category_name`,`blog_tags`,`blog_status`,`blog_views`,`enable_comment`,`is_deleted`,`create_time`,`update_time`) values (1,'我是十三','about','/admin/dist/img/rand/33.jpg','## About me\n\n我是十三,一名Java开发者,技术一般,经历平平,但是也一直渴望进步,同时也努力活着,为了人生不留遗憾,也希望能够一直做着自己喜欢的事情,得闲时分享心得、分享一些浅薄的经验,等以后老得不能再老了,就说故事已经讲完了,不去奢求圆满。\n\n相信浏览这段话的你也知道,学习是一件极其枯燥而无聊的过程,甚至有时候显得很无助,我也想告诉你,成长就是这样一件残酷的事情,任何成功都不是一蹴而就,需要坚持、需要付出、需要你的毅力,短期可能看不到收获,因为破茧成蝶所耗费的时间不是一天。\n\n## Contact\n\n- 我的邮箱:2449207463@qq.com\n- QQ技术交流群:796794009\n- 我的网站:http://13blog.site\n\n## Quote\n\n- Steve Jobs\n\n> Stay hungry,Stay foolish\n\n- Kahlil Gibran\n\n>The FIRST TIME WHEN I saw her being meek that she might attain height.<br>\nThe SECOND TIME WHEN I saw her limping BEFORE the crippled.<br>\nThe third TIME WHEN she was given TO choose BETWEEN the hard AND the easy, AND she chose the easy.<br>\nThe fourth TIME WHEN she COMMITTED a wrong, AND comforted herself that others also COMMIT wrong.<br>\nThe fifth TIME WHEN she forbore FOR weakness, AND attributed her patience TO strength.<br>\nThe sixth TIME WHEN she despised the ugliness of a face, AND knew NOT that it was ONE of her own masks.<br>\nAND the seventh TIME WHEN she sang a song of praise, AND deemed it a virtue.',20,'About','世界上有一个很可爱的人,现在这个人就在看这句话',1,220,0,1,'2017-03-12 00:31:15','2018-11-12 00:31:15'),(2,'文章总目录','','/admin/dist/img/rand/13.jpg','<h2 id=\"springboot2\">23 个实验带你轻松玩转 Spring Boot</h2>\n\n- [**开篇词:《23 个实验带你轻松玩转 Spring Boot》导读**](https://www.shiyanlou.com/courses/1274)\n- [第02课:Spring Boot 项目开发环境搭建](https://www.shiyanlou.com/courses/1274)\n- [第03课:快速构建 Spring Boot 应用](https://www.shiyanlou.com/courses/1274)\n- [第04课:Spring Boot 基础功能开发](https://www.shiyanlou.com/courses/1274)\n- [第05课:Spring Boot 项目开发之 web 项目开发讲解](https://www.shiyanlou.com/courses/1274)\n- [第06课:Spring Boot 整合 JSP 开发 web 项目](https://www.shiyanlou.com/courses/1274)\n- [第07课:模板引擎介绍及 Spring Boot 整合 Thymeleaf](https://www.shiyanlou.com/courses/1274)\n- [第08课:Thymeleaf 语法详解](https://www.shiyanlou.com/courses/1274)\n- [第09课:FreeMarker 模板引擎整合使用教程](https://www.shiyanlou.com/courses/1274)\n- [第10课:Spring Boot 处理文件上传及路径回显](https://www.shiyanlou.com/courses/1274)\n- [第11课:Spring Boot 自动配置数据源及操作数据库](https://www.shiyanlou.com/courses/1274)\n- [第12课:Spring Boot 整合 Druid 数据源](https://www.shiyanlou.com/courses/1274)\n- [第13课:Spring Boot 整合 MyBatis 操作数据库](https://www.shiyanlou.com/courses/1274)\n- [第14课:Spring Boot 中的事务处理](https://www.shiyanlou.com/courses/1274)\n- [第15课:Spring Boot 整合 Redis 操作缓存模块](https://www.shiyanlou.com/courses/1274)\n- [第16课:Spring Boot 项目开发之实现定时任务](https://www.shiyanlou.com/courses/1274)\n- [第17课:Spring Boot 自定义错误页面](https://www.shiyanlou.com/courses/1274)\n- [第18课:Spring Boot 集成 Swagger 生成接口文档](https://www.shiyanlou.com/courses/1274)\n- [第19课:Spring Boot 项目打包部署介绍](https://www.shiyanlou.com/courses/1274)\n- [第20课:Spring Boot Admin 介绍及整合使用](https://www.shiyanlou.com/courses/1274)\n- [第21课:Spring Boot 资讯管理信息系统开发实战(一)](https://www.shiyanlou.com/courses/1274)\n- [第22课:Spring Boot 资讯管理信息系统开发实战(二)](https://www.shiyanlou.com/courses/1274)\n- [第23课:Spring Boot 资讯管理信息系统开发实战(三)](https://www.shiyanlou.com/courses/1274)\n- [第24课:Spring Boot 资讯管理信息系统开发实战