cms-看点咨询项目中的数据库建表语句:
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for cms_article
-- ----------------------------
DROP TABLE IF EXISTS `cms_article`;
CREATE TABLE `cms_article` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`author` varchar(255) DEFAULT NULL,
`clickTimes` int(11) DEFAULT NULL,
`content` text,
`publishDate` date DEFAULT NULL,
`title` varchar(255) DEFAULT NULL,
`category_id` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INC
