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;