`dateline` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (id),
KEY idtype (idtype, status, dateline)
) ENGINE=MyISAM COMMENT='家园评论审核数据表';
DROP TABLE IF EXISTS pre_portal_comment_moderate; CREATE TABLE pre_portal_comment_moderate (
id int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'ID', idtype varchar(15) NOT NULL default COMMENT 'ID类型',
status tinyint(3) NOT NULL default '0' COMMENT '状态 0 审核中，1 已忽略', `dateline` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (id),
KEY idtype (idtype, status, dateline)
) ENGINE=MyISAM COMMENT='文章/专题评论审核数据表';
DROP TABLE IF EXISTS pre_forum_postlog; CREATE TABLE pre_forum_postlog (
`pid` int(10) unsigned NOT NULL DEFAULT '0',
`tid` mediumint(8) unsigned NOT NULL DEFAULT '0', `fid` smallint(6) unsigned NOT NULL DEFAULT '0', `uid` mediumint(8) unsigned NOT NULL DEFAULT '0', `action` char(10) NOT NULL DEFAULT ,
`dateline` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (pid, tid), KEY fid (fid), KEY uid (uid),
KEY dateline (dateline)
) ENGINE=MyISAM COMMENT='漫游帖子日志';
DROP TABLE IF EXISTS pre_forum_threadlog; CREATE TABLE pre_forum_threadlog (
`tid` mediumint(8) unsigned NOT NULL DEFAULT '0', `fid` smallint(6) unsigned NOT NULL DEFAULT '0', `uid` mediumint(8) unsigned NOT NULL DEFAULT '0', `otherid` smallint(6) unsigned NOT NULL DEFAULT '0', `action` char(10) NOT NULL,
`expiry` int(10) unsigned NOT NULL DEFAULT '0', `dateline` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (tid,fid,uid), KEY dateline (dateline)
) ENGINE=MyISAM COMMENT='漫游主题日志';
DROP TABLE IF EXISTS pre_forum_threadpreview; CREATE TABLE pre_forum_threadpreview (
tid mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT '主题ID', relay int(10) unsigned NOT NULL default '0' COMMENT '转播次数', content text NOT NULL COMMENT '主题内容预览', PRIMARY KEY (tid)
) ENGINE=MyISAM COMMENT='服务于广播';
DROP TABLE IF EXISTS pre_forum_poll; CREATE TABLE pre_forum_poll (
tid mediumint(8) unsigned NOT NULL default '0' COMMENT '主题id', overt tinyint(1) NOT NULL default '0' COMMENT '是否公开投票参与人', multiple tinyint(1) NOT NULL default '0' COMMENT '是否多选',
visible tinyint(1) NOT NULL default '0' COMMENT '是否投票后可见',
maxchoices tinyint(3) unsigned NOT NULL default '0' COMMENT '最大可选项数', expiration int(10) unsigned NOT NULL default '0' COMMENT '过期时间',
pollpreview varchar(255) NOT NULL default COMMENT '选项内容前两项预览', voters mediumint(8) unsigned NOT NULL default '0' COMMENT '投票人数', PRIMARY KEY (tid)
) ENGINE=MyISAM COMMENT='投票表';
DROP TABLE IF EXISTS pre_forum_pollvoter; CREATE TABLE pre_forum_pollvoter (
tid mediumint(8) unsigned NOT NULL default '0' COMMENT '主题id', uid mediumint(8) unsigned NOT NULL default '0' COMMENT '会员id', username varchar(15) NOT NULL default COMMENT '会员名', `options` text NOT NULL COMMENT '选项 \\t 分隔',
dateline int(10) unsigned NOT NULL default '0' COMMENT '发表时间', KEY tid (tid),
KEY uid (uid, dateline)
) ENGINE=MyISAM COMMENT='投票用户表';
DROP TABLE IF EXISTS pre_forum_polloption; CREATE TABLE pre_forum_polloption (
polloptionid int(10) unsigned NOT NULL auto_increment COMMENT '选项id', tid mediumint(8) unsigned NOT NULL default '0' COMMENT '主题id', votes mediumint(8) unsigned NOT NULL default '0' COMMENT '票数', displayorder tinyint(3) NOT NULL default '0' COMMENT '显示顺序', polloption varchar(80) NOT NULL default COMMENT '选项内容',
