text: /*
  Navicat MySQL Data Transfer
  
  Source Server         : mysql
  Source Server Version : 80016
  Source Host           : localhost:3306
  Source Database       : blog
  
  Target Server Type    : MYSQL
  Target Server Version : 80016
  File Encoding         : 65001
  
  Date: 2020-07-03 18:54:58
  */
  
  SET FOREIGN_KEY_CHECKS=0;
  
  -- ----------------------------
  -- Table structure for blog_article
  -- ----------------------------
  DROP TABLE IF EXISTS `blog_article`;
  CREATE TABLE `blog_article` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `tag_id` int(10) unsigned DEFAULT '0' COMMENT '标签ID',
    `title` varchar(100) DEFAULT '' COMMENT '文章标题',
    `desc` varchar(255) DEFAULT '' COMMENT '简述',
    `content` text,
    `created_on` int(11) DEFAULT NULL,
    `created_by` varchar(100) DEFAULT '' COMMENT '创建人',
    `modified_on` int(10) unsigned DEFAULT '0' COMMENT '修改时间',
    `modified_by` varchar(255) DEFAULT '' COMMENT '修改人',
    `deleted_on` int(10) unsigned DEFAULT '0',
    `state` tinyint(3) unsigned DEFAULT '1' COMMENT '状态0为禁用、1为启用',
    `cover_image_url` varchar(255) Default '' COMMENT '封面图片地址',
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='文章管理';
  
  -- ----------------------------
  -- Records of blog_article
  -- ----------------------------
  
  -- ----------------------------
  -- Table structure for blog_auth
  -- ----------------------------
  DROP TABLE IF EXISTS `blog_auth`;
  CREATE TABLE `blog_auth` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `username` varchar(50) DEFAULT '' COMMENT '账号',
    `password` varchar(50) DEFAULT '' COMMENT '密码',
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
  
  -- ----------------------------
  -- Records of blog_auth
  -- ----------------------------
  INSERT INTO `blog_auth` VALUES ('1', 'test', 'test123');
  
  -- ----------------------------
  -- Table structure for blog_tag
  -- ----------------------------
  DROP TABLE IF EXISTS `blog_tag`;
  CREATE TABLE `blog_tag` (
    `id` int(10) NOT NULL AUTO_INCREMENT,
    `name` varchar(100) DEFAULT '' COMMENT '标签名称',
    `created_on` int(10) unsigned DEFAULT '0' COMMENT '创建时间',
    `created_by` varchar(100) DEFAULT '' COMMENT '创建人',
    `modified_on` int(10) unsigned DEFAULT '0' COMMENT '修改时间',
    `modified_by` varchar(100) DEFAULT '' COMMENT '修改人',
    `deleted_on` int(10) unsigned DEFAULT '0',
    `state` tinyint(3) unsigned DEFAULT '1' COMMENT '状态0为禁用、1位启用',
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='文章标签管理';
  
  -- ----------------------------
  -- Records of blog_tag
  -- ----------------------------
  INSERT INTO `blog_tag` VALUES ('2', '2', '1593772020', 'test', '0', '', '0', '1');
  INSERT INTO `blog_tag` VALUES ('3', '1', '1593773402', 'test', '0', '', '0', '1');
  