text: /*
  Navicat MySQL Data Transfer
  
  Source Server         : mysql
  Source Server Version : 80021
  Source Host           : localhost:3306
  Source Database       : myblog
  
  Target Server Type    : MYSQL
  Target Server Version : 80021
  File Encoding         : 65001
  
  Date: 2021-03-24 17:50:10
  */
  
  SET FOREIGN_KEY_CHECKS=0;
  
  -- ----------------------------
  -- Table structure for t_blog
  -- ----------------------------
  DROP TABLE IF EXISTS `t_blog`;
  CREATE TABLE `t_blog` (
    `id` bigint NOT NULL AUTO_INCREMENT,
    `appreciation` bit(1) NOT NULL,
    `commentabled` bit(1) NOT NULL,
    `content` longtext CHARACTER SET utf8 COLLATE utf8_general_ci,
    `create_time` datetime DEFAULT NULL,
    `description` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
    `first_picture` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
    `flag` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
    `published` bit(1) NOT NULL,
    `recommend` bit(1) NOT NULL,
    `share_statement` bit(1) NOT NULL,
    `title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
    `update_time` datetime DEFAULT NULL,
    `views` int DEFAULT NULL,
    `type_id` bigint DEFAULT NULL,
    `user_id` bigint DEFAULT NULL,
    `comment_count` int DEFAULT NULL,
    PRIMARY KEY (`id`) USING BTREE,
    KEY `FK292449gwg5yf7ocdlmswv9w4j` (`type_id`) USING BTREE,
    KEY `FK8ky5rrsxh01nkhctmo7d48p82` (`user_id`) USING BTREE,
    CONSTRAINT `FK292449gwg5yf7ocdlmswv9w4j` FOREIGN KEY (`type_id`) REFERENCES `t_type` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
    CONSTRAINT `FK8ky5rrsxh01nkhctmo7d48p82` FOREIGN KEY (`user_id`) REFERENCES `t_user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
  ) ENGINE=InnoDB AUTO_INCREMENT=62 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
  
  -- ----------------------------
  -- Records of t_blog
  -- ----------------------------
  
  -- ----------------------------
  -- Table structure for t_comment
  -- ----------------------------
  DROP TABLE IF EXISTS `t_comment`;
  CREATE TABLE `t_comment` (
    `id` bigint NOT NULL AUTO_INCREMENT,
    `nickname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
    `email` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
    `content` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
    `avatar` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
    `create_time` datetime DEFAULT NULL,
    `blog_id` bigint DEFAULT NULL,
    `parent_comment_id` bigint DEFAULT NULL,
    `admin_comment` bit(1) NOT NULL,
    PRIMARY KEY (`id`) USING BTREE
  ) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
  
  -- ----------------------------
  -- Records of t_comment
  -- ----------------------------
  
  -- ----------------------------
  -- Table structure for t_friend
  -- ----------------------------
  DROP TABLE IF EXISTS `t_friend`;
  CREATE TABLE `t_friend` (
    `id` bigint NOT NULL AUTO_INCREMENT,
    `blogaddress` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
    `blogname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
    `create_time` datetime DEFAULT NULL,
    `pictureaddress` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
    PRIMARY KEY (`id`) USING BTREE
  ) ENGINE=InnoDB AUTO_INCREMENT=58 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
  
  -- ----------------------------
  -- Records of t_friend
  -- ----------------------------
  
  -- ----------------------------
  -- Table structure for t_message
  -- ----------------------------
  DROP TABLE IF EXISTS `t_message`;
  CREATE TABLE `t_message` (
    `id` bigint NOT NULL AUTO_INCREMENT,
    `nickname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
    `email` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
    `content` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
    `avatar` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
    `create_time` datetime DEFAULT NULL,
    `parent_message_id` bigint DEFAULT NULL,
    `admin_message` bit(1) NOT NULL,
    PRIMARY KEY (`id`) USING BTREE
  ) ENGINE=InnoDB AUTO_INCREMENT=100 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
  
  -- ----------------------------
  -- Records of t_message
  -- ----------------------------
  
  -- ----------------------------
  -- Table structure for t_picture
  -- ----------------------------
  DROP TABLE IF EXISTS `t_picture`;
  CREATE TABLE `t_picture` (
    `id` bigint NOT NULL AUTO_INCREMENT,
    `pictureaddress` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
    `picturedescription` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
    `picturename` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
    `picturetime` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
    PRIMARY KEY (`id`) USING BTREE
  ) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
  
  -- ----------------------------
  -- Records of t_picture
  -- ----------------------------
  
  -- ----------------------------
  -- Table structure for t_type
  -- ----------------------------
  DROP TABLE IF EXISTS `t_type`;
  CREATE TABLE `t_type` (
    `id` bigint NOT NULL AUTO_INCREMENT,
    `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
    PRIMARY KEY (`id`) USING BTREE
  ) ENGINE=InnoDB AUTO_INCREMENT=58 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
  
  -- ----------------------------
  -- Records of t_type
  -- ----------------------------
  
  -- ----------------------------
  -- Table structure for t_user
  -- ----------------------------
  DROP TABLE IF EXISTS `t_user`;
  CREATE TABLE `t_user` (
    `id` bigint NOT NULL AUTO_INCREMENT,
    `avatar` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
    `create_time` datetime DEFAULT NULL,
    `email` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
    `nickname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
    `password` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
    `type` int DEFAULT NULL,
    `update_time` datetime DEFAULT NULL,
    `username` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
    PRIMARY KEY (`id`) USING BTREE
  ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
  
  -- ----------------------------
  -- Records of t_user
  -- ----------------------------
  INSERT INTO `t_user` VALUES ('1', 'https://i0.hdslb.com/bfs/sycp/creative_img/202103/604910c5c04d09aff317958330000135.jpg', '2021-03-21 11:09:00', '2637185783@qq.com', '质疑', 'e10adc3949ba59abbe56e057f20f883e', '1', '2021-03-21 11:09:09', 'admin');
  