-
Notifications
You must be signed in to change notification settings - Fork 2
Expand file tree
/
Copy pathdb_cms.sql
More file actions
97 lines (71 loc) · 9.39 KB
/
db_cms.sql
File metadata and controls
97 lines (71 loc) · 9.39 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
/*
SQLyog 企业版 - MySQL GUI v8.14
MySQL - 5.5.54 : Database - db_cms
*********************************************************************
*/
/*!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*/`db_cms` /*!40100 DEFAULT CHARACTER SET utf8 */;
USE `db_cms`;
/*Table structure for table `t_arctype` */
DROP TABLE IF EXISTS `t_arctype`;
CREATE TABLE `t_arctype` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`typeName` varchar(100) DEFAULT NULL,
`sortNo` int(11) DEFAULT NULL,
`keywords` varchar(400) DEFAULT NULL,
`description` varchar(1000) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8;
/*Data for the table `t_arctype` */
insert into `t_arctype`(`id`,`typeName`,`sortNo`,`keywords`,`description`) values (1,'Java基础',1,NULL,'55'),(2,'网页基础',2,'121','s '),(4,'Java建站',3,NULL,'6'),(5,'Java爬虫',4,NULL,'99'),(6,'网站SEO',9,NULL,NULL),(7,'广告联盟',6,NULL,NULL),(8,'Gakki',8,NULL,NULL);
/*Table structure for table `t_article` */
DROP TABLE IF EXISTS `t_article`;
CREATE TABLE `t_article` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(100) DEFAULT NULL,
`publishDate` datetime DEFAULT NULL,
`content` text,
`summary` varchar(500) DEFAULT NULL,
`titleColor` varchar(100) DEFAULT NULL,
`click` int(11) DEFAULT NULL,
`isRecommend` tinyint(4) DEFAULT NULL,
`isSlide` int(11) DEFAULT NULL,
`slideImage` varchar(100) DEFAULT NULL,
`typeId` int(11) DEFAULT NULL,
`keyWords` varchar(100) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `FK_t_article` (`typeId`),
CONSTRAINT `FK_t_article` FOREIGN KEY (`typeId`) REFERENCES `t_arctype` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=69 DEFAULT CHARSET=utf8;
/*Data for the table `t_article` */
insert into `t_article`(`id`,`title`,`publishDate`,`content`,`summary`,`titleColor`,`click`,`isRecommend`,`isSlide`,`slideImage`,`typeId`,`keyWords`) values (1,'测试java基础1','2016-01-02 00:00:00','测试java基础 内容','测试摘要','black',11,1,0,NULL,1,NULL),(2,'测试java基础1','2016-01-04 00:00:00','测试java基础 内容','测试摘要','black',15,0,1,'1.jpg',1,NULL),(3,'测试java基础2','2016-01-02 00:00:00','测试java基础 内容','测试摘要','black',10,0,0,NULL,1,NULL),(4,'测试java基础3','2016-01-02 00:00:00','测试java基础 内容','测试摘要','black',10,0,0,NULL,1,NULL),(5,'测试java基础4','2016-01-02 00:00:00','测试java基础 内容','测试摘要','black',10,0,0,NULL,1,NULL),(6,'测试java基础5','2016-01-02 00:00:00','测试java基础 内容','测试摘要','black',10,1,0,NULL,1,NULL),(7,'测试java基础6','2016-01-02 00:00:00','测试java基础 内容','测试摘要','black',10,0,0,NULL,1,NULL),(8,'测试java基础7','2016-01-02 00:00:00','测试java基础 内容','测试摘要','black',10,0,0,NULL,1,NULL),(9,'测试java基础8','2016-01-02 00:00:00','测试java基础 内容','测试摘要','black',10,1,0,NULL,1,NULL),(10,'测试网页基础1','2016-01-02 00:00:00','测试网页基础 内容','测试摘要','black',12,0,0,NULL,2,NULL),(11,'测试网页基础2','2016-01-02 00:00:00','测试网页基础 内容','测试摘要','black',13,0,0,NULL,2,NULL),(12,'测试网页基础3','2016-01-02 00:00:00','测试网页基础 内容','测试摘要','black',11,1,0,NULL,2,NULL),(13,'测试网页基础4','2016-03-02 02:01:30','测试网页基础 内容','测试摘要','black',49,0,1,'2.jpg',2,'1 s是'),(14,'测试网页基础5','2016-01-02 00:00:00','测试网页基础 内容','测试摘要','black',10,1,0,NULL,2,NULL),(15,'测试网页基础6','2016-01-02 00:00:00','测试网页基础 内容','测试摘要','black',11,0,0,NULL,2,NULL),(17,'测试网页基础8','2016-01-02 00:00:00','测试网页基础 内容','测试摘要','black',13,0,0,NULL,2,NULL),(18,'网页Java建站基础1','2016-04-02 00:00:00','网页Java建站基础 内容','测试摘要','black',20,1,0,NULL,4,NULL),(19,'网页Java建站基础4','2016-01-02 00:00:00','网页Java建站基础 内容','测试摘要','black',10,0,0,NULL,4,NULL),(20,'网页Java建站基础3','2016-01-04 00:00:00','网页Java建站基础 内容','测试摘要','black',11,1,0,NULL,4,NULL),(21,'网页Java建站基础4','2016-01-02 00:00:00','网页Java建站基础 内容','测试摘要','black',11,0,1,'4.jpg',4,NULL),(22,'网页Java建站基础5','2016-01-02 00:00:00','网页Java建站基础 内容','测试摘要','black',10,1,0,NULL,4,NULL),(23,'网页Java建站基础6','2016-01-02 00:00:00','网页Java建站基础 内容','测试摘要','black',10,0,0,NULL,4,NULL),(24,'网页Java建站基础7','2016-01-02 00:00:00','网页Java建站基础 内容','测试摘要','black',10,1,0,NULL,4,NULL),(25,'网页Java建站基础8','2016-01-02 00:00:00','网页Java建站基础 内容','测试摘要','black',10,0,0,NULL,4,NULL),(26,'Java爬虫基础1','2016-01-02 00:00:00','Java爬虫基础 内容','测试摘要','black',10,0,0,NULL,5,NULL),(27,'Java爬虫基础5','2016-01-02 00:00:00','Java爬虫基础 内容','测试摘要','black',11,0,0,NULL,5,NULL),(28,'Java爬虫基础3','2016-01-02 00:00:00','Java爬虫基础 内容','测试摘要','black',11,0,0,NULL,5,NULL),(29,'Java爬虫基础5','2016-01-02 00:00:00','Java爬虫基础 内容','测试摘要','black',12,0,0,NULL,5,NULL),(30,'Java爬虫基础5','2016-01-02 00:00:00','Java爬虫基础 内容','测试摘要','black',11,0,0,NULL,5,NULL),(31,'Java爬虫基础6','2016-01-02 00:00:00','Java爬虫基础 内容','测试摘要','black',11,0,0,NULL,5,NULL),(32,'Java爬虫基础7','2016-01-02 00:00:00','Java爬虫基础 内容','测试摘要','black',11,0,1,'3.jpg',5,NULL),(33,'Java爬虫基础8','2016-01-02 00:00:00','Java爬虫基础 内容','测试摘要','black',11,0,0,NULL,5,NULL),(34,'网站SEO1','2016-01-02 00:00:00','网站SEO 内容','测试摘要','black',11,0,0,NULL,6,NULL),(35,'网站SEO6','2016-01-02 00:00:00','网站SEO 内容','测试摘要','black',11,0,0,NULL,6,NULL),(36,'网站SEO3','2016-01-02 00:00:00','网站SEO 内容','测试摘要','black',11,0,0,NULL,6,NULL),(37,'网站SEO6','2016-01-02 00:00:00','网站SEO 内容','测试摘要','black',11,0,1,'5.jpg',6,NULL),(38,'网站SEO6','2016-01-02 00:00:00','网站SEO 内容','测试摘要','black',11,0,0,NULL,6,NULL),(39,'网站SEO6','2016-01-02 00:00:00','网站SEO 内容','测试摘要','black',11,0,0,NULL,6,NULL),(40,'网站SEO7','2016-01-02 00:00:00','网站SEO 内容','测试摘要','black',11,0,0,NULL,6,NULL),(41,'网站SEO8','2016-01-02 00:00:00','网站SEO 内容','测试摘要','black',11,0,0,NULL,6,NULL),(42,'广告联盟1','2016-01-02 00:00:00','广告联盟 内容','测试摘要','black',11,0,0,NULL,7,NULL),(43,'广告联盟7','2016-01-02 00:00:00','广告联盟 内容','测试摘要','black',10,0,0,NULL,7,NULL),(44,'广告联盟3','2016-01-02 00:00:00','广告联盟 内容','测试摘要','black',10,0,0,NULL,7,NULL),(45,'广告联盟7','2016-01-02 00:00:00','广告联盟 内容','测试摘要','black',10,0,0,NULL,7,NULL),(46,'广告联盟7','2016-01-02 00:00:00','广告联盟 内容','测试摘要','black',10,0,0,NULL,7,NULL),(47,'广告联盟7','2016-01-02 00:00:00','广告联盟 内容','测试摘要','black',10,0,0,NULL,7,NULL),(48,'广告联盟7','2016-01-02 00:00:00','广告联盟 内容','测试摘要','black',10,0,0,NULL,7,NULL),(49,'广告联盟8','2016-01-02 00:00:00','广告联盟 内容','测试摘要','black',10,0,0,NULL,7,NULL),(50,'21',NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,8,NULL),(58,'11',NULL,'<p>21321<br/></p>','21','',0,0,0,NULL,1,''),(59,'32',NULL,'<p>21321<br/></p>','dsafda','#FF0000',0,1,1,'20161029085937.jpg',1,'ha ha'),(68,'修改测试','2018-04-20 17:18:22','<p>阿实施的方式大幅法师打发的是</p><p><img src=\"/static/userImages/20180419/1524129182273063410.jpg\" title=\"1524129182273063410.jpg\" alt=\"hu.jpg\" width=\"756\" height=\"1088\"/><br/></p>','gakki','#3381FF',9,1,1,'20180419051308.png',8,'Gakki ');
/*Table structure for table `t_link` */
DROP TABLE IF EXISTS `t_link`;
CREATE TABLE `t_link` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(100) DEFAULT NULL,
`url` varchar(200) DEFAULT NULL,
`sortNo` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;
/*Data for the table `t_link` */
insert into `t_link`(`id`,`name`,`url`,`sortNo`) values (1,'测试1','http://www.java1234.com',1),(2,'测试2','http://www.java1234.com',2),(3,'测试3','http://www.java1234.com',3),(4,'测试4','http://www.java1234.com',4),(7,'测试2','http://www.wuvole.com',7),(9,'Linux','http://www.wuvole.com',9);
/*Table structure for table `t_manager` */
DROP TABLE IF EXISTS `t_manager`;
CREATE TABLE `t_manager` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`userName` varchar(10) DEFAULT NULL,
`password` varchar(100) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
/*Data for the table `t_manager` */
insert into `t_manager`(`id`,`userName`,`password`) values (1,'gakki','7afe71dc32ca3f3ada0d7ff19d6c44fe');
/*!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 */;