mysql-cms.sql
3.94 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
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
SET FOREIGN_KEY_CHECKS = 0;
DROP TABLE IF EXISTS `cms_article`;
CREATE TABLE `cms_article` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`title` varchar(255) NOT NULL,
`model` char(32) DEFAULT NULL,
`seo_keywords` varchar(512) DEFAULT NULL,
`seo_describe` varchar(1024) DEFAULT NULL,
`keywords` varchar(512) DEFAULT NULL,
`column_id` char(32) DEFAULT NULL,
`source` varchar(512) DEFAULT NULL,
`is_promulgate` tinyint(1) DEFAULT NULL,
`is_top` tinyint(1) DEFAULT NULL,
`summary` varchar(512) DEFAULT NULL,
`page_url` varchar(255) DEFAULT NULL,
`status` tinyint(4) DEFAULT NULL,
`creater_id` varchar(64) DEFAULT NULL,
`create_time` bigint(20) DEFAULT NULL,
`promulgate_time` bigint(20) DEFAULT NULL,
`sequence` bigint(20) DEFAULT NULL,
`media_url` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET FOREIGN_KEY_CHECKS = 1;
SET FOREIGN_KEY_CHECKS = 0;
DROP TABLE IF EXISTS `cms_article_content`;
CREATE TABLE `cms_article_content` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`content` mediumtext,
`article_id` char(32) NOT NULL,
`creater_id` varchar(64) DEFAULT NULL,
`create_time` bigint(20) NOT NULL,
`page` int(11) NOT NULL,
`type` char(16) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET FOREIGN_KEY_CHECKS = 1;
/*
Navicat MySQL Data Transfer
Source Server : 127
Source Server Version : 50623
Source Host : localhost
Source Database : demo_st
Target Server Version : 50623
File Encoding : utf-8
Date: 04/14/2016 11:31:53 AM
*/
SET NAMES utf8;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for `cms_column`
-- ----------------------------
DROP TABLE IF EXISTS `cms_column`;
CREATE TABLE `cms_column` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`column_code` varchar(32) NOT NULL,
`name` varchar(128) NOT NULL,
`sequence` int(11) DEFAULT NULL,
`is_navigation` tinyint(1) DEFAULT NULL,
`target_url` varchar(255) DEFAULT NULL,
`is_publish` tinyint(1) DEFAULT NULL,
`home_model_id` char(32) DEFAULT NULL,
`list_model_id` char(32) DEFAULT NULL,
`parent_id` char(32) DEFAULT NULL,
`status` tinyint(4) DEFAULT NULL,
`creater_id` varchar(64) DEFAULT NULL,
`create_time` bigint(20) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10007 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of `cms_column`
-- ----------------------------
BEGIN;
INSERT INTO `cms_column` VALUES
('10004', 'jiangren', '匠人', '0', '1', null, '1', '0', '0', '0', '1', '', '1460532655677'),
('10005', 'xianchangzhaopian', '现场照片', '0', '1', null, '1', '0', '0', '0', '1', '', '1460600453575'),
('10006', 'meitibaodao', '媒体报道', '0', '1', null, '1', '0', '0', '0', '1', '', '1460600471869');
COMMIT;
SET FOREIGN_KEY_CHECKS = 1;
SET FOREIGN_KEY_CHECKS = 0;
DROP TABLE IF EXISTS `cms_mould`;
CREATE TABLE `cms_mould` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`name` char(30) DEFAULT NULL COMMENT '模板的名称',
`path` char(255) DEFAULT NULL COMMENT '模板的路径',
`type` int(11) DEFAULT NULL COMMENT '模板的类型',
`default_template` tinyint(1) DEFAULT NULL COMMENT '是否是默认模板',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- insert into `cms_mould`(`id`,`name`,`path`,`type`,`default_template`) values
-- ('077340ef44c040b385641128cc2674e4','联系我们模板','temps/contactus','4','0'),
-- ('11a67ad89d584bf4acea0d5a17fcfd6b','关于我们模板','temps/aboutus','4','0'),
-- ('13fafc32beb048878edf964f7702c1ef','文章页模板','temps/pub','2','0'),
-- ('650383dfa6f741f5afc355eac4ba8d64','公司动态模板','temps/news','4','0'),
-- ('6b9741afbf9c41d98433391867152409','动态列表页模板','temps/newslist','3','0'),
-- ('c3a0b1fc1ffe4df99a3321974a2d0f33','网站首页(服务介绍)模板','/index','4','0'),
-- ('d1cd3eb36584439d8e90c64f7b762808','案例展示页模板','/temps/case','4','0');
-- SET FOREIGN_KEY_CHECKS = 1;