/*
SQLyog Community v13.1.6 (64 bit)
MySQL - 5.5.47 : Database - springbootdata
*********************************************************************
*/

/*!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*/`springbootdata` /*!40100 DEFAULT CHARACTER SET utf8mb4 */;

USE `springbootdata`;

/*Table structure for table `中文用户表` */

DROP TABLE IF EXISTS `中文用户表`;

CREATE TABLE `中文用户表` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `姓名` varchar(20) DEFAULT NULL,
  `性别` int(11) DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4;

/*Data for the table `中文用户表` */

insert  into `中文用户表`(`ID`,`姓名`,`性别`) values 
(1,'zhangsi',0),
(2,'李四',0);

/*Table structure for table `t_article` */

DROP TABLE IF EXISTS `t_article`;

CREATE TABLE `t_article` (
  `id` int(20) NOT NULL AUTO_INCREMENT COMMENT '文章id',
  `title` varchar(200) DEFAULT NULL COMMENT '文章标题',
  `content` longtext COMMENT '文章内容',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

/*Data for the table `t_article` */

insert  into `t_article`(`id`,`title`,`content`) values 
(1,'Spring Boot基础入门','从入门到精通讲解...'),
(2,'Spring Cloud基础入门','从入门到精通讲解...');

/*Table structure for table `t_comment` */

DROP TABLE IF EXISTS `t_comment`;

CREATE TABLE `t_comment` (
  `id` int(20) NOT NULL AUTO_INCREMENT COMMENT '评论id',
  `content` longtext COMMENT '评论内容',
  `author` varchar(200) DEFAULT NULL COMMENT '评论作者',
  `a_id` int(20) DEFAULT NULL COMMENT '关联的文章id',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

/*Data for the table `t_comment` */

insert  into `t_comment`(`id`,`content`,`author`,`a_id`) values 
(1,'很全、很详细','狂奔的蜗牛',1),
(2,'赞一个','tom',1),
(3,'很详细','kitty',1),
(4,'很好，非常详细','张三',1),
(5,'很不错','张杨',2);

/*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(40) DEFAULT NULL,
  `password` varchar(40) DEFAULT NULL,
  `birthday` date DEFAULT NULL,
  `sex` varchar(10) DEFAULT '男',
  `city` varchar(50) DEFAULT NULL,
  `sign` varchar(50) DEFAULT NULL,
  `experience` int(11) DEFAULT NULL,
  `logins` int(11) DEFAULT NULL,
  `wealth` int(20) DEFAULT NULL,
  `classify` varchar(50) DEFAULT NULL,
  `score` int(11) DEFAULT NULL,
  `phone` varchar(20) DEFAULT NULL,
  `email` varchar(20) DEFAULT NULL,
  `remarks` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8mb4;

/*Data for the table `t_user` */

insert  into `t_user`(`id`,`username`,`password`,`birthday`,`sex`,`city`,`sign`,`experience`,`logins`,`wealth`,`classify`,`score`,`phone`,`email`,`remarks`) values 
(1,'张三',NULL,NULL,'男','深圳','签名-0',255,0,82830700,'作家',57,'18333217842','AMDIN@qq.com',NULL),
(2,'Jerry',NULL,'2021-10-30','女','深圳','签名-1',884,0,64928690,'词人',2130,'15766322312','user@qq.com',''),
(3,'汤姆','123','2021-10-30','女','东莞','签名-2',123,0,123,'划水123',123,'123123','admin@qq.com',''),
(4,'吴海',NULL,NULL,'男','揭阳市','没有能不能，只有想不想',10000,0,31211313,'Java开发工程师',21313,'15766329736','2420674058@qq.com','划水 ~'),
(5,'林小九',NULL,NULL,'女','清远市','我是一只猪头',10000,0,3123131,'设计师',31311,'18300152311','2018131225@qq.com','猪头 ing ~');

/*Table structure for table `teacher` */

DROP TABLE IF EXISTS `teacher`;

CREATE TABLE `teacher` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `jobno` varchar(20) DEFAULT NULL,
  `username` varchar(20) DEFAULT NULL,
  `age` int(11) DEFAULT NULL,
  `mobile` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4;

/*Data for the table `teacher` */

insert  into `teacher`(`id`,`jobno`,`username`,`age`,`mobile`) values 
(1,'001','tom',39,'13312345678'),
(2,'002','jerry',30,'13567834567'),
(3,'222','张大',NULL,NULL),
(4,'222','张大',NULL,NULL),
(5,'222','张大',NULL,NULL);

/*!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 */;