text: /*
  SQLyog Professional v12.08 (64 bit)
  MySQL - 5.5.62 : Database - myblog
  *********************************************************************
  */
  
  
  /*!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*/`myblog` /*!40100 DEFAULT CHARACTER SET utf8mb4 */;
  
  USE `myblog`;
  
  /*Table structure for table `t_blog` */
  
  DROP TABLE IF EXISTS `t_blog`;
  
  CREATE TABLE `t_blog` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT,
    `title` varchar(255) NOT NULL,
    `content` longtext NOT NULL,
    `view` int(11) NOT NULL,
    `flag` varchar(255) NOT NULL,
    `first_picture` varchar(255) NOT NULL,
    `discription` varchar(255) NOT NULL,
    `create_time` datetime NOT NULL,
    `update_time` datetime NOT NULL,
    `appreciate` bit(1) NOT NULL,
    `recommend` bit(1) NOT NULL,
    `comment` bit(1) NOT NULL,
    `publish` bit(1) NOT NULL,
    `share` bit(1) NOT NULL,
    `type_id` bigint(20) NOT NULL,
    `user_id` bigint(20) NOT NULL,
    PRIMARY KEY (`id`),
    KEY `type_id` (`type_id`),
    KEY `user_id` (`user_id`),
    CONSTRAINT `t_blog_ibfk_1` FOREIGN KEY (`type_id`) REFERENCES `t_type` (`id`),
    CONSTRAINT `t_blog_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `t_user` (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4;
  
  /*Data for the table `t_blog` */
  
  insert  into `t_blog`(`id`,`title`,`content`,`view`,`flag`,`first_picture`,`discription`,`create_time`,`update_time`,`appreciate`,`recommend`,`comment`,`publish`,`share`,`type_id`,`user_id`) values (1,'你好','你好呀',1,'原创','123','123','2020-09-01 14:32:27','2020-09-01 14:32:32','','','','','',1,1);
  
  /*Table structure for table `t_comment` */
  
  DROP TABLE IF EXISTS `t_comment`;
  
  CREATE TABLE `t_comment` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT,
    `nickname` varchar(255) NOT NULL,
    `email` varchar(255) NOT NULL,
    `content` varchar(255) NOT NULL,
    `avatar` varchar(255) NOT NULL,
    `create_time` datetime NOT NULL,
    `blog_id` bigint(20) NOT NULL,
    `parent_comment_id` bigint(20) NOT NULL,
    `admin_comment` bit(1) NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
  
  /*Data for the table `t_comment` */
  
  /*Table structure for table `t_type` */
  
  DROP TABLE IF EXISTS `t_type`;
  
  CREATE TABLE `t_type` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT,
    `name` varchar(255) NOT NULL,
    PRIMARY KEY (`id`) USING BTREE
  ) ENGINE=InnoDB AUTO_INCREMENT=60 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
  
  /*Data for the table `t_type` */
  
  insert  into `t_type`(`id`,`name`) values (1,'java'),(2,'css'),(3,'jqurey');
  
  /*Table structure for table `t_user` */
  
  DROP TABLE IF EXISTS `t_user`;
  
  CREATE TABLE `t_user` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT,
    `username` varchar(20) NOT NULL,
    `nickname` varchar(20) NOT NULL,
    `password` varchar(255) NOT NULL,
    `avatar` varchar(255) NOT NULL,
    `eamil` varchar(255) NOT NULL,
    `type` int(11) NOT NULL,
    `createtime` datetime NOT NULL,
    `updatetime` datetime NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4;
  
  /*Data for the table `t_user` */
  
  insert  into `t_user`(`id`,`username`,`nickname`,`password`,`avatar`,`eamil`,`type`,`createtime`,`updatetime`) values (1,'admin','admin','123456','https://unsplash.it/100/100?image=1005','1234586@qq.com',1,'2020-08-30 19:10:54','2020-08-30 19:10:58');
  
  /*!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 */;
  