   `status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '状态(-1:审核不通过,0:未审核,1:已审核通过)',
   `ip` varchar(30) DEFAULT NULL COMMENT '评论人ip地址',
   `agent` varchar(200) DEFAULT NULL COMMENT '评论人终端信息',
-  `ctime` bigint(20) NOT NULL,
+  `ctime` bigint(20) NOT NULL COMMENT '创建时间',
   PRIMARY KEY (`comment_id`),
   KEY `cms_comment_article_id` (`article_id`),
   KEY `cms_comment_pid` (`pid`),

  `article_id` int(10) unsigned NOT NULL,
  `tag_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`article_tag_id`),
  KEY `cms_article_tag_article_id` (`article_id`),
  KEY `cms_article_tag_tag_id` (`tag_id`),
  CONSTRAINT `cms_article_tag_article_id` FOREIGN KEY (`article_id`) REFERENCES `cms_article` (`article_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `cms_article_tag_tag_id` FOREIGN KEY (`tag_id`) REFERENCES `cms_tag` (`tag_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='文章标签表';

-- ----------------------------

Navicat MySQL Data Transfer

Source Server         : localhost
Source Server Version : 50528
Source Host           : localhost:3306
Source Database       : zheng

Target Server Type    : MYSQL
Target Server Version : 50528
File Encoding         : 65001

Date: 2016-10-17 17:23:58
*/

SET FOREIGN_KEY_CHECKS=0;
