```[sql]
CREATE TABLE nc_cms_article (
article_id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '文章编号',
title VARCHAR(255) NOT NULL COMMENT '文章标题',
class_id INT(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '文章分类编号',
short_title VARCHAR(50) NOT NULL DEFAULT '' COMMENT '文章短标题',
source VARCHAR(50) NOT NULL DEFAULT '' COMMENT '文章来源',
url VARCHAR(255) NOT NULL DEFAULT '' COMMENT '文章来源链接',
author VARCHAR(50) NOT NULL COMMENT '文章作者',
summary VARCHAR(140) NOT NULL DEFAULT '' COMMENT '文章摘要',
content TEXT NOT NULL COMMENT '文章正文',
image VARCHAR(255) NOT NULL DEFAULT '' COMMENT '文章标题图片',
keyword VARCHAR(255) NOT NULL DEFAULT '' COMMENT '文章关键字',
article_id_array VARCHAR(255) NOT NULL DEFAULT '' COMMENT '相关文章',
click INT(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '文章点击量',
sort TINYINT(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '文章排序0-255',
commend_flag TINYINT(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '文章推荐标志0-未推荐，1-已推荐',
comment_flag TINYINT(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT '文章是否允许评论1-允许，0-不允许',
status TINYINT(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT '0-草稿、1-待审核、2-已发布、-1-回收站',
attachment_path TEXT NOT NULL COMMENT '文章附件路径',
tag VARCHAR(255) NOT NULL DEFAULT '' COMMENT '文章标签',
comment_count INT(10) UNSIGNED NOT NULL COMMENT '文章评论数',
share_count INT(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '文章分享数',
publisher_name VARCHAR(50) NOT NULL COMMENT '发布者用户名 ',
uid INT(10) UNSIGNED NOT NULL COMMENT '发布者编号',
last_comment_time INT(11) DEFAULT 0 COMMENT '最新评论时间',
public_time INT(11) DEFAULT 0 COMMENT '发布时间',
create_time INT(11) DEFAULT 0 COMMENT '文章发布时间',
modify_time INT(11) DEFAULT 0 COMMENT '文章修改时间',
PRIMARY KEY (article_id)
)
ENGINE = INNODB
AUTO_INCREMENT = 18
AVG_ROW_LENGTH = 6553
CHARACTER SET utf8
COLLATE utf8_general_ci
COMMENT = 'CMS文章表';
CREATE TABLE nc_cms_article_class (
class_id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '分类编号 ',
pid INT(11) NOT NULL DEFAULT 0 COMMENT '上级分类',
name VARCHAR(50) NOT NULL COMMENT '分类名称',
sort INT(11) DEFAULT NULL,
PRIMARY KEY (class_id)
)
ENGINE = INNODB
AUTO_INCREMENT = 8
AVG_ROW_LENGTH = 1170
CHARACTER SET utf8
COLLATE utf8_general_ci
COMMENT = 'cms文章分类表';
CREATE TABLE nc_cms_comment (
comment_id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '评论编号',
text VARCHAR(2000) NOT NULL COMMENT '评论内容',
uid INT(10) UNSIGNED NOT NULL COMMENT '评论人编号',
quote_comment_id INT(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '评论引用',
up INT(10) UNSIGNED NOT NULL COMMENT '点赞数量',
comment_time INT(10) UNSIGNED NOT NULL COMMENT '评论时间',
PRIMARY KEY (comment_id)
)
ENGINE = INNODB
AUTO_INCREMENT = 1
AVG_ROW_LENGTH = 8192
CHARACTER SET utf8
COLLATE utf8_general_ci
COMMENT = 'CMS评论表';
CREATE TABLE nc_cms_topic (
topic_id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '专题编号',
instance_id INT(10) NOT NULL DEFAULT 0 COMMENT '店铺ID',
title VARCHAR(255) NOT NULL COMMENT '专题标题',
image VARCHAR(255) NOT NULL DEFAULT '' COMMENT '专题封面',
status TINYINT(1) NOT NULL DEFAULT 0 COMMENT '专题状态 0草稿 1发布',
content TEXT NOT NULL COMMENT '专题内容',
create_time INT(11) DEFAULT 0 COMMENT '创建时间',
modify_time INT(11) DEFAULT 0 COMMENT '修改时间',
PRIMARY KEY (topic_id)
)
ENGINE = INNODB
AUTO_INCREMENT = 3
CHARACTER SET utf8
COLLATE utf8_general_ci
COMMENT = '专题';
```
