时间:2021-07-01 10:21:17 帮助过:7人阅读
CREATE TABLE `votes` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`ip` varchar(250) NOT NULL,
·uid· int(11) NOT NULL,
`vid` int(11) NOT NULL,
`fstcreate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8
CREATE TABLE `article` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`article_title` varchar(250) NOT NULL,
`article_type` int(11) NOT NULL,
`article_content` longtext NOT NULL,
`article_author` varchar(50) NOT NULL,
`article_click_count` int(11) NOT NULL DEFAULT '0',
`status` int(11) NOT NULL DEFAULT '0',
`likes` int(11) DEFAULT '0',
`unlikes` int(11) DEFAULT '0',
`fstcreate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`lastmodify` datetime DEFAULT NULL,
PRIMARY KEY (`id`),
FULLTEXT KEY `fulltext_article_title` (`article_title`,`article_content`,`key_words`)
) ENGINE=MyISAM AUTO_INCREMENT=119 DEFAULT CHARSET=utf8 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC COMMENT='文章表'