Cyan_tribune
/
tribune.sql

/*
SQLyog 企业版 - MySQL GUI v8.14
MySQL - 5.5.40 : Database - tale
*********************************************************************
*/

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

USE `tale`;

/*Table structure for table `t_attach` */

DROP TABLE IF EXISTS `t_attach`;

CREATE TABLE `t_attach` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `fname` varchar(100) NOT NULL DEFAULT '',
  `ftype` varchar(50) DEFAULT '',
  `fkey` varchar(100) NOT NULL DEFAULT '',
  `author_id` int(10) DEFAULT NULL,
  `created` int(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

/*Data for the table `t_attach` */

insert  into `t_attach`(`id`,`fname`,`ftype`,`fkey`,`author_id`,`created`) values (1,'1.jpeg','image','/upload/2017/06/t93vgdj6o8irgo87ds56u0ou0s.jpeg',1,1496816096);

/*Table structure for table `t_collect` */

DROP TABLE IF EXISTS `t_collect`;

CREATE TABLE `t_collect` (
  `collect_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `author_id` int(10) DEFAULT NULL,
  `contents_id` int(10) DEFAULT NULL,
  `created` date DEFAULT '2020-02-14',
  PRIMARY KEY (`collect_id`),
  KEY `slug` (`contents_id`)
) ENGINE=InnoDB AUTO_INCREMENT=51 DEFAULT CHARSET=utf8;

/*Data for the table `t_collect` */

insert  into `t_collect`(`collect_id`,`author_id`,`contents_id`,`created`) values (1,1,1,'2020-02-14'),(37,7,21,'2020-04-14'),(38,7,15,'2020-04-14'),(39,7,27,'2020-04-14'),(40,7,22,'2020-04-14'),(41,7,16,'2020-04-14'),(42,7,18,'2020-04-14'),(43,7,28,'2020-04-14'),(44,1,28,'2020-04-14'),(45,1,21,'2020-04-14'),(46,1,22,'2020-04-14'),(47,1,26,'2020-04-14'),(48,7,32,'2020-04-14'),(49,13,21,'2020-04-14'),(50,7,34,'2020-04-14');

/*Table structure for table `t_comments` */

DROP TABLE IF EXISTS `t_comments`;

CREATE TABLE `t_comments` (
  `coid` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `cid` int(10) unsigned DEFAULT '0',
  `created` date DEFAULT '2020-01-01',
  `author_id` int(10) DEFAULT '1',
  `content` text,
  `status` int(16) DEFAULT '0',
  PRIMARY KEY (`coid`),
  KEY `cid` (`cid`),
  KEY `created` (`created`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8;

/*Data for the table `t_comments` */

insert  into `t_comments`(`coid`,`cid`,`created`,`author_id`,`content`,`status`) values (2,1,'2020-01-01',1,'大撒大撒',1),(3,1,'2020-02-14',1,'你说的真好',1),(11,15,'2020-04-13',7,'妈哎！说的太好了 啪啪啪',1),(12,16,'2020-04-13',1,'说得好',1),(16,21,'2020-04-14',13,'哈哈哈',1);

/*Table structure for table `t_contents` */

DROP TABLE IF EXISTS `t_contents`;

CREATE TABLE `t_contents` (
  `cid` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(200) DEFAULT NULL,
  `created` date DEFAULT '2020-01-01',
  `content` text COMMENT '内容文字',
  `author_id` int(10) unsigned DEFAULT '1',
  `type_id` int(16) DEFAULT '1',
  `status` int(10) DEFAULT '1',
  `collectcount` int(10) DEFAULT '0',
  PRIMARY KEY (`cid`),
  KEY `created` (`created`)
) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8;

/*Data for the table `t_contents` */

insert  into `t_contents`(`cid`,`title`,`created`,`content`,`author_id`,`type_id`,`status`,`collectcount`) values (1,'你好！世界','2020-01-01','hello!My World',1,3,1,3),(15,'《如果这都不算爱》','2020-04-01','## 第一章 —— Java 多线程技能\r\n\r\n线程技术点：\r\n\r\n',1,3,1,1),(16,'《是不是爱就应该》','2020-04-01','## 第一章 —— Java 多线程技能\r\n\r\n线程技术点：\r\n\r\n',1,1,1,2),(18,'《我有什么好悲哀》','2020-04-07','## 第一章 —— Java 多线程技能\r\n\r\n线程技术点：\r\n\r\n',1,1,1,5),(21,'《人人都献出一份爱》','2020-04-11','## 第一章 —— Java 多线程技能\r\n\r\n线程技术点：\r\n\r\n',1,3,1,8),(22,'《世界终将变成美好的明天》','2020-04-12','## 第一章 —— Java 多线程技能\r\n\r\n线程技术点：\r\n\r\n## 第一章 —— Java 多线程技能\r\n\r\n线程技术点：\r\n\r\n## 第一章 —— Java 多线程技能\r\n\r\n线程技术点：\r\n\r\n## 第一章 —— Java 多线程技能\r\n\r\n线程技术点：\r\n\r\n## 第一章 —— Java 多线程技能\r\n\r\n线程技术点：\r\n\r\n## 第一章 —— Java 多线程技能\r\n\r\n线程技术点：\r\n\r\n## 第一章 —— Java 多线程技能\r\n\r\n线程技术点：\r\n\r\n',1,1,1,2),(26,'《我和你心连心》','2020-04-12','## 第一章 —— Java 多线程技能\r\n\r\n线程技术点：\r\n\r\n## 第一章 —— Java 多线程技能\r\n\r\n线程技术点：\r\n\r\n## 第一章 —— Java 多线程技能\r\n\r\n线程技术点：\r\n\r\n## 第一章 —— Java 多线程技能\r\n\r\n线程技术点：\r\n\r\n## 第一章 —— Java 多线程技能\r\n\r\n线程技术点：\r\n\r\n',1,1,1,3),(36,'《好消息！好消息！浙江温州》','2020-04-14','好消息！好消息！浙江温州江南皮革厂倒闭啦！',1,3,0,0);

/*Table structure for table `t_logs` */

DROP TABLE IF EXISTS `t_logs`;

CREATE TABLE `t_logs` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `action` varchar(100) DEFAULT NULL,
  `data` varchar(2000) DEFAULT NULL,
  `author_id` int(10) DEFAULT NULL,
  `ip` varchar(20) DEFAULT NULL,
  `created` int(10) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8;

/*Data for the table `t_logs` */

insert  into `t_logs`(`id`,`action`,`data`,`author_id`,`ip`,`created`) values (1,'登录后台',NULL,1,'0:0:0:0:0:0:0:1',1496815277),(2,'登录后台',NULL,1,'0:0:0:0:0:0:0:1',1496815280),(3,'登录后台',NULL,1,'0:0:0:0:0:0:0:1',1496815318),(4,'登录后台',NULL,1,'0:0:0:0:0:0:0:1',1496815398),(5,'登录后台',NULL,1,'0:0:0:0:0:0:0:1',1496815482),(6,'登录后台',NULL,1,'0:0:0:0:0:0:0:1',1496815492),(7,'保存系统设置','{\"site_keywords\":\"Blog\",\"site_description\":\"SpringBoot+Mybatis+thymeleaf 搭建的 Java 博客系统\",\"site_title\":\"Blog\",\"site_theme\":\"default\",\"allow_install\":\"\"}',1,'0:0:0:0:0:0:0:1',1496815955),(8,'保存系统设置','{\"site_keywords\":\"Blog\",\"site_description\":\"SpringBoot+Mybatis+thymeleaf 搭建的 Java 博客系统\",\"site_title\":\"Blog\",\"site_theme\":\"default\",\"allow_install\":\"\"}',1,'0:0:0:0:0:0:0:1',1496815964),(9,'登录后台',NULL,1,'0:0:0:0:0:0:0:1',1496989015),(10,'登录后台',NULL,1,'0:0:0:0:0:0:0:1',1496989366),(11,'登录后台',NULL,1,'0:0:0:0:0:0:0:1',1497317863),(12,'保存系统设置','{\"social_zhihu\":\"https://www.zhihu.com/people/tian-zhisheng/activities\",\"social_github\":\"https://github.com/zhisheng17\",\"social_twitter\":\"\",\"social_weibo\":\"\"}',1,'0:0:0:0:0:0:0:1',1497318696),(13,'修改个人信息','{\"uid\":1,\"email\":\"1041218129@qq.com\",\"screenName\":\"admin\"}',1,'0:0:0:0:0:0:0:1',1497319220),(14,'登录后台',NULL,1,'0:0:0:0:0:0:0:1',1497319856),(15,'登录后台',NULL,1,'127.0.0.1',1497321561),(16,'登录后台',NULL,1,'127.0.0.1',1497322738),(17,'登录后台',NULL,1,'0:0:0:0:0:0:0:1',1497323446),(18,'删除文章','2',1,'0:0:0:0:0:0:0:1',1497323495),(19,'登录后台',NULL,1,'0:0:0:0:0:0:0:1',1497427641),(20,'登录后台',NULL,1,'0:0:0:0:0:0:0:1',1497428250),(21,'登录后台',NULL,1,'0:0:0:0:0:0:0:1',1497428290),(22,'登录后台',NULL,1,'0:0:0:0:0:0:0:1',1497428556),(23,'登录后台',NULL,1,'0:0:0:0:0:0:0:1',1497674581),(24,'修改个人信息','{\"uid\":1,\"email\":\"1041218129@qq.com\",\"screenName\":\"admin\"}',1,'0:0:0:0:0:0:0:1',1497674690),(25,'登录后台',NULL,1,'0:0:0:0:0:0:0:1',1497676623),(26,'登录后台',NULL,1,'0:0:0:0:0:0:0:1',1497683817),(27,'登录后台',NULL,1,'0:0:0:0:0:0:0:1',1497685128),(28,'登录后台',NULL,1,'127.0.0.1',1497689032);

/*Table structure for table `t_setting` */

DROP TABLE IF EXISTS `t_setting`;

CREATE TABLE `t_setting` (
  `id` int(10) unsigned NOT NULL,
  `site_name` varchar(50) DEFAULT NULL,
  `site_content` varchar(50) DEFAULT NULL,
  `site_keywords` varchar(50) DEFAULT NULL,
  `site_theme` varchar(50) DEFAULT NULL,
  `social_weibo` varchar(50) DEFAULT NULL,
  `social_zhihu` varchar(50) DEFAULT NULL,
  `social_github` varchar(50) DEFAULT NULL,
  `social_titwer` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `t_setting` */

insert  into `t_setting`(`id`,`site_name`,`site_content`,`site_keywords`,`site_theme`,`social_weibo`,`social_zhihu`,`social_github`,`social_titwer`) values (1,'cyan论坛','一个基于springboot+layui+mybatis+mysql开发的论坛','cyan',NULL,'可乐XZXS','anixtey','https://github.com/anixtey',NULL);

/*Table structure for table `t_type` */

DROP TABLE IF EXISTS `t_type`;

CREATE TABLE `t_type` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) DEFAULT NULL,
  `status` int(10) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

/*Data for the table `t_type` */

insert  into `t_type`(`id`,`name`,`status`) values (1,'编程',0),(2,'音乐',0),(3,'公告',0),(4,'新闻',0),(5,'军事',0),(6,'娱乐',0);

/*Table structure for table `t_users` */

DROP TABLE IF EXISTS `t_users`;

CREATE TABLE `t_users` (
  `uid` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `username` varchar(32) DEFAULT NULL,
  `password` varchar(64) DEFAULT NULL,
  `email` varchar(200) DEFAULT NULL,
  `created` date DEFAULT NULL,
  `role` int(10) unsigned DEFAULT '0',
  `name` varchar(50) DEFAULT NULL,
  `sign` text,
  `achieve` int(10) DEFAULT '0',
  PRIMARY KEY (`uid`),
  UNIQUE KEY `name` (`username`),
  UNIQUE KEY `mail` (`email`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8;

/*Data for the table `t_users` */

insert  into `t_users`(`uid`,`username`,`password`,`email`,`created`,`role`,`name`,`sign`,`achieve`) values (1,'admin','990517wq','1972844352@qq.com','2020-01-01',0,'子玄','白茶清欢无旁事,我在等风也在等你',25),(7,'admina','990517wq','123456789@qq.com','2020-04-09',1,'无价之宝',NULL,5),(12,'anixte','123456789q','1234569@qq.com','2020-04-14',1,'子轩的二三',NULL,0),(13,'anixtey','123456789q','12345678999@qq.com','2020-04-14',1,'哈哈哈哈',NULL,2);

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