portal.sql
5.7 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
--
-- 表的结构 `cmf_portal_category`
--
CREATE TABLE IF NOT EXISTS `cmf_portal_category` (
`id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '分类id',
`parent_id` bigint(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT '分类父id',
`post_count` bigint(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT '分类文章数',
`status` tinyint(3) UNSIGNED NOT NULL DEFAULT '1' COMMENT '状态,1:发布,0:不发布',
`delete_time` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '删除时间',
`list_order` float NOT NULL DEFAULT '10000' COMMENT '排序',
`name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '分类名称',
`description` varchar(255) NOT NULL DEFAULT '' COMMENT '分类描述',
`path` varchar(255) NOT NULL DEFAULT '' COMMENT '分类层级关系路径',
`seo_title` varchar(100) NOT NULL DEFAULT '',
`seo_keywords` varchar(255) NOT NULL DEFAULT '',
`seo_description` varchar(255) NOT NULL DEFAULT '',
`list_tpl` varchar(50) NOT NULL DEFAULT '' COMMENT '分类列表模板',
`one_tpl` varchar(50) NOT NULL DEFAULT '' COMMENT '分类文章页模板',
`more` text COMMENT '扩展属性',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='portal应用 文章分类表';
-- --------------------------------------------------------
--
-- 表的结构 `cmf_portal_category_post`
--
CREATE TABLE IF NOT EXISTS `cmf_portal_category_post` (
`id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
`post_id` bigint(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT '文章id',
`category_id` bigint(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT '分类id',
`list_order` float NOT NULL DEFAULT '10000' COMMENT '排序',
`status` tinyint(3) UNSIGNED NOT NULL DEFAULT '1' COMMENT '状态,1:发布;0:不发布',
PRIMARY KEY (`id`),
KEY `term_taxonomy_id` (`category_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='portal应用 分类文章对应表';
-- --------------------------------------------------------
--
-- 表的结构 `cmf_portal_post`
--
CREATE TABLE IF NOT EXISTS `cmf_portal_post` (
`id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
`parent_id` bigint(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT '父级id',
`post_type` tinyint(3) UNSIGNED NOT NULL DEFAULT '1' COMMENT '类型,1:文章;2:页面',
`post_format` tinyint(3) UNSIGNED NOT NULL DEFAULT '1' COMMENT '内容格式;1:html;2:md',
`user_id` bigint(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT '发表者用户id',
`post_status` tinyint(3) UNSIGNED NOT NULL DEFAULT '1' COMMENT '状态;1:已发布;0:未发布;',
`comment_status` tinyint(3) UNSIGNED NOT NULL DEFAULT '1' COMMENT '评论状态;1:允许;0:不允许',
`is_top` tinyint(3) UNSIGNED NOT NULL DEFAULT '0' COMMENT '是否置顶;1:置顶;0:不置顶',
`recommended` tinyint(3) UNSIGNED NOT NULL DEFAULT '0' COMMENT '是否推荐;1:推荐;0:不推荐',
`post_hits` bigint(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT '查看数',
`post_like` bigint(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT '点赞数',
`comment_count` bigint(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT '评论数',
`create_time` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '创建时间',
`update_time` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '更新时间',
`published_time` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '发布时间',
`delete_time` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '删除时间',
`post_title` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'post标题',
`post_keywords` varchar(150) NOT NULL DEFAULT '' COMMENT 'seo keywords',
`post_excerpt` varchar(500) NOT NULL DEFAULT '' COMMENT 'post摘要',
`post_source` varchar(150) NOT NULL DEFAULT '' COMMENT '转载文章的来源',
`post_content` text COMMENT '文章内容',
`post_content_filtered` text COMMENT '处理过的文章内容',
`more` text COMMENT '扩展属性,如缩略图;格式为json',
PRIMARY KEY (`id`),
KEY `type_status_date` (`post_type`,`post_status`,`create_time`,`id`),
KEY `parent_id` (`parent_id`),
KEY `user_id` (`user_id`),
KEY `create_time` (`create_time`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='portal应用 文章表' ROW_FORMAT=COMPACT;
-- --------------------------------------------------------
--
-- 表的结构 `cmf_portal_tag`
--
CREATE TABLE IF NOT EXISTS `cmf_portal_tag` (
`id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '分类id',
`status` tinyint(3) UNSIGNED NOT NULL DEFAULT '1' COMMENT '状态,1:发布,0:不发布',
`recommended` tinyint(3) UNSIGNED NOT NULL DEFAULT '0' COMMENT '是否推荐;1:推荐;0:不推荐',
`post_count` bigint(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT '标签文章数',
`name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '标签名称',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='portal应用 文章标签表';
-- --------------------------------------------------------
--
-- 表的结构 `cmf_portal_tag_post`
--
CREATE TABLE IF NOT EXISTS `cmf_portal_tag_post` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`tag_id` bigint(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT '标签 id',
`post_id` bigint(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT '文章 id',
`status` tinyint(3) UNSIGNED NOT NULL DEFAULT '1' COMMENT '状态,1:发布;0:不发布',
PRIMARY KEY (`id`),
KEY `post_id` (`post_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='portal应用 标签文章对应表';
-- --------------------------------------------------------
-- 增缩略图字段
ALTER TABLE `cmf_portal_post` ADD `thumbnail` VARCHAR(100) NOT NULL DEFAULT '' COMMENT '缩略图' AFTER `post_source`;
ALTER TABLE `cmf_portal_post` ADD `post_favorites` INT UNSIGNED NOT NULL DEFAULT '0' COMMENT '收藏数' AFTER `post_hits`;