30 lines
1.5 KiB
SQL
30 lines
1.5 KiB
SQL
CREATE TABLE `@cms@@zhubiao@` (
|
|
`id` mediumint(8) unsigned NOT NULL auto_increment,
|
|
`catid` smallint(5) unsigned NOT NULL DEFAULT '0',
|
|
`modelid` smallint(5) unsigned NOT NULL DEFAULT '0',
|
|
`checked` smallint(5) unsigned NOT NULL DEFAULT '0',
|
|
`title` varchar(255) NOT NULL DEFAULT '',
|
|
`thumb` varchar(255) NOT NULL DEFAULT '',
|
|
`linkurl` varchar(255) NOT NULL DEFAULT '',
|
|
`newstime` int(11) unsigned NOT NULL DEFAULT '0',
|
|
`pagetitle` varchar(255) NOT NULL DEFAULT '',
|
|
`keywords` varchar(255) NOT NULL DEFAULT '',
|
|
`description` varchar(255) NOT NULL DEFAULT '',
|
|
`pubid` bigint(15) unsigned NOT NULL DEFAULT '0',
|
|
`sort` tinyint(3) unsigned NOT NULL DEFAULT '0',
|
|
`userid` int(11) unsigned NOT NULL DEFAULT '0',
|
|
`username` char(20) NOT NULL DEFAULT '',
|
|
`addtime` int(10) unsigned NOT NULL DEFAULT '0',
|
|
`editortime` int(10) unsigned NOT NULL DEFAULT '0',
|
|
`is_good` int(11) NOT NULL DEFAULT '0' COMMENT '推荐',
|
|
`is_top` int(11) NOT NULL DEFAULT '0' COMMENT '置顶',
|
|
`views` int(11) NOT NULL DEFAULT '0' COMMENT '点击总数',
|
|
`goods` int(11) NOT NULL DEFAULT '0' COMMENT '点赞数',
|
|
`favs` int(11) NOT NULL DEFAULT '0' COMMENT '收藏数',
|
|
`comments` int(11) NOT NULL DEFAULT '0' COMMENT '评论数',
|
|
`viewtemp` int(11) NOT NULL DEFAULT '0' COMMENT '单独内容模板',
|
|
PRIMARY KEY (`id`),
|
|
KEY `checked` (`checked`),
|
|
KEY `catid` (`catid`),
|
|
KEY `sort` (`sort`)
|
|
) ENGINE=MyISAM COMMENT='@zhubiao_note@' DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci; |