   `article_id` int(10) unsigned NOT NULL,
   `category_id` int(10) unsigned NOT NULL,
   PRIMARY KEY (`article_category_id`),
-  KEY `cms_article_category_article_id` (`article_id`),
-  KEY `cms_article_category_category_id` (`category_id`),
-  CONSTRAINT `cms_article_category_article_id` FOREIGN KEY (`article_id`) REFERENCES `cms_article` (`article_id`) ON DELETE CASCADE ON UPDATE CASCADE,
-  CONSTRAINT `cms_article_category_category_id` FOREIGN KEY (`category_id`) REFERENCES `cms_category` (`category_id`) ON DELETE CASCADE ON UPDATE CASCADE
+  KEY `cms_article_category_article_id` (`article_id`) USING BTREE COMMENT '文章id索引',
+  KEY `cms_article_category_category_id` (`category_id`) USING BTREE COMMENT '类目id索引'
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='文章类目表';
 
 -- ----------------------------

  `ctime` bigint(20) unsigned NOT NULL COMMENT '创建时间',
  `orders` bigint(20) unsigned NOT NULL COMMENT '排序',
  PRIMARY KEY (`article_id`),
  KEY `cms_article_orders` (`orders`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='文章表';

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

  `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 COMMENT '创建时间',
  PRIMARY KEY (`comment_id`),
  KEY `cms_comment_article_id` (`article_id`),
  KEY `cms_comment_pid` (`pid`),
