```[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 = 1
AVG_ROW_LENGTH = 1
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 = 1
AVG_ROW_LENGTH = 1
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 = 1
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 = 1
AVG_ROW_LENGTH = 1
CHARACTER SET utf8
COLLATE utf8_general_ci
COMMENT = '專題';
```
