sendcredits tinyint(1) NOT NULL default '0' COMMENT '转出积分字段', receivecredits tinyint(1) NOT NULL default '0' COMMENT '接受积分字段', send int(10) unsigned NOT NULL default '0' COMMENT '转出积分', receive int(10) unsigned NOT NULL default '0' COMMENT '接受积分', dateline int(10) unsigned NOT NULL default '0' COMMENT '转帐日期', operation char(3) NOT NULL default COMMENT '操作', KEY uid (uid,dateline)
) ENGINE=MyISAM COMMENT='转帐记录表';
DROP TABLE IF EXISTS pre_forum_debate; CREATE TABLE pre_forum_debate (
tid mediumint(8) unsigned NOT NULL default '0' COMMENT '主题id', uid mediumint(8) unsigned NOT NULL default '0' COMMENT '发起人id', starttime int(10) unsigned NOT NULL default '0' COMMENT '开始时间', endtime int(10) unsigned NOT NULL default '0' COMMENT '结束时间',
affirmdebaters mediumint(8) unsigned NOT NULL default '0' COMMENT '正方辩论人数', negadebaters mediumint(8) unsigned NOT NULL default '0' COMMENT '反方辩论人数', affirmvotes mediumint(8) unsigned NOT NULL default '0' COMMENT '正方得票数', negavotes mediumint(8) unsigned NOT NULL default '0' COMMENT '反方得票数', umpire varchar(15) NOT NULL default COMMENT '裁判用户名',
winner tinyint(1) NOT NULL default '0' COMMENT '获胜方\\n(0:平局 1:为正方 2:为反方)\\n裁判评判结果',
bestdebater varchar(50) NOT NULL default COMMENT '最佳辩手用户名', affirmpoint text NOT NULL COMMENT '正方观点', negapoint text NOT NULL COMMENT '反方观点',
umpirepoint text NOT NULL COMMENT '裁判观点，裁判结束辩论时填写', affirmvoterids text NOT NULL COMMENT '正方投票人的 id 集合', negavoterids text NOT NULL COMMENT '反方投票人的 id 集合',
affirmreplies mediumint(8) unsigned NOT NULL COMMENT '正方回复次数，用来翻页', negareplies mediumint(8) unsigned NOT NULL COMMENT '反方回复次数，用来翻页', PRIMARY KEY (tid), KEY uid (uid,starttime)
) ENGINE=MyISAM COMMENT='辩论主题表';
DROP TABLE IF EXISTS pre_forum_debatepost; CREATE TABLE pre_forum_debatepost (
pid int(10) unsigned NOT NULL default '0' COMMENT '帖子id',
stand tinyint(1) NOT NULL default '0' COMMENT '立场\\n(0:中立 1:正方 2:为反方)', tid mediumint(8) unsigned NOT NULL default '0' COMMENT '主题id', uid mediumint(8) unsigned NOT NULL default '0' COMMENT '发起人id', dateline int(10) unsigned NOT NULL default '0' COMMENT '发表的时间', voters mediumint(10) unsigned NOT NULL default '0' COMMENT '投票人数',
voterids text NOT NULL COMMENT '投票人的 id 集合', PRIMARY KEY (pid), KEY pid (pid,stand), KEY tid (tid,uid)
) ENGINE=MyISAM COMMENT='辩论帖子表';
DROP TABLE IF EXISTS pre_forum_faq; CREATE TABLE pre_forum_faq (
id smallint(6) NOT NULL auto_increment COMMENT '帮助id',
fpid smallint(6) unsigned NOT NULL default '0' COMMENT '帮助父id', displayorder tinyint(3) NOT NULL default '0' COMMENT '排序', identifier varchar(20) NOT NULL COMMENT '帮助标识', keyword varchar(50) NOT NULL COMMENT '帮助关键词', title varchar(50) NOT NULL COMMENT '帮助标题', message text NOT NULL COMMENT '帮助内容', PRIMARY KEY (id),
KEY displayplay (displayorder)
) ENGINE=MyISAM COMMENT='论坛帮助表';
DROP TABLE IF EXISTS pre_forum_postcache; CREATE TABLE pre_forum_postcache ( pid int(10) unsigned NOT NULL,
comment text NOT NULL COMMENT '点评内容缓存', rate text NOT NULL COMMENT '评分情况缓存', dateline int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (pid), KEY dateline (dateline)
) ENGINE=MyISAM COMMENT='论坛帖子缓存表';
DROP TABLE IF EXISTS pre_home_favorite; CREATE TABLE pre_home_favorite (
favid mediumint(8) unsigned NOT NULL auto_increment COMMENT '收藏id', uid mediumint(8) unsigned NOT NULL default '0' COMMENT '会员id',
id mediumint(8) unsigned NOT NULL default '0', idtype varchar(255) NOT NULL default ,
spaceuid mediumint(8) unsigned NOT NULL default '0' COMMENT '空间会员id', title varchar(255) NOT NULL default COMMENT '标题', description text NOT NULL COMMENT '简介', dateline int(10) unsigned NOT NULL default '0', PRIMARY KEY (favid), KEY idtype (id,idtype),
KEY uid (uid,idtype,dateline)
) ENGINE=MyISAM COMMENT='收藏表';
DROP TABLE IF EXISTS pre_forum_forum; CREATE TABLE pre_forum_forum (
fid mediumint(8) unsigned NOT NULL auto_increment COMMENT '论坛id', fup mediumint(8) unsigned NOT NULL default '0' COMMENT '上级论坛id',
`type` enum('group','forum','sub') NOT NULL default 'forum' COMMENT '类型\\n(group:分类 forum:普通论坛 sub:子论坛)',
`name` char(50) NOT NULL default COMMENT '名称',
`status` tinyint(1) NOT NULL default '0' COMMENT '显示状态\\n(0:隐藏 1:正常 3:群组)', displayorder smallint(6) NOT NULL default '0' COMMENT '显示顺序', styleid smallint(6) unsigned NOT NULL default '0' COMMENT '风格id',
threads mediumint(8) unsigned NOT NULL default '0' COMMENT '主题数量', posts mediumint(8) unsigned NOT NULL default '0' COMMENT '帖子数量',
todayposts mediumint(8) unsigned NOT NULL default '0' COMMENT '今日发帖数量', lastpost char(110) NOT NULL default COMMENT '最后发表',
domain char(15) NOT NULL default COMMENT '绑定的二级域名',
allowsmilies tinyint(1) NOT NULL default '0' COMMENT '允许使用表情', allowhtml tinyint(1) NOT NULL default '0' COMMENT '允许使用html', allowbbcode tinyint(1) NOT NULL default '0' COMMENT '允许bbcode', allowimgcode tinyint(1) NOT NULL default '0' COMMENT '允许img',
allowmediacode tinyint(1) NOT NULL default '0' COMMENT '允许使用多媒体代码', allowanonymous tinyint(1) NOT NULL default '0' COMMENT '允许匿名',
allowpostspecial smallint(6) unsigned NOT NULL default '0' COMMENT '允许发表特殊主题',
allowspecialonly tinyint(1) unsigned NOT NULL default '0' COMMENT '只允许发表特殊主题',
allowappend tinyint(1) unsigned NOT NULL default '0' COMMENT '是否开启帖子补充', alloweditrules tinyint(1) NOT NULL default '0' COMMENT '允许版主修改论坛规则', allowfeed tinyint(1) NOT NULL default '1' COMMENT '允许推送动态,默认推送广播', allowside tinyint(1) NOT NULL default '0' COMMENT '显示边栏',
recyclebin tinyint(1) NOT NULL default '0' COMMENT '是否启用回收站', modnewposts tinyint(1) NOT NULL default '0' COMMENT '是否审核发帖', jammer tinyint(1) NOT NULL default '0' COMMENT '是否启用干扰码',
disablewatermark tinyint(1) NOT NULL default '0' COMMENT '是否图片附件增加水印', inheritedmod tinyint(1) NOT NULL default '0' COMMENT '本论坛或分类版主的权力继承到下级论坛',
autoclose smallint(6) NOT NULL default '0' COMMENT '自动关闭主题',
forumcolumns tinyint(3) unsigned NOT NULL default '0' COMMENT '增加论坛水平横排设置',
catforumcolumns tinyint(3) unsigned NOT NULL default '0' COMMENT '增加分区版块水平横排设置',
threadcaches tinyint(1) NOT NULL default '0' COMMENT '主题缓存功能设置',
alloweditpost tinyint(1) unsigned NOT NULL default '1' COMMENT '允许编辑帖子', `simple` tinyint(1) unsigned NOT NULL default '0' COMMENT '只显示子版块',
modworks tinyint(1) unsigned NOT NULL default '0' COMMENT '本版有待处理的管理事项', allowglobalstick tinyint(1) NOT NULL default '1' COMMENT '是否显示全局置顶', level smallint(6) NOT NULL default '0' COMMENT '群组等级',
commoncredits int(10) unsigned NOT NULL default '0' COMMENT '群组公共积分', `archive` tinyint(1) NOT NULL default '0' COMMENT '是否有存档表',
recommend smallint(6) unsigned NOT NULL default '0' COMMENT '推荐到的版块',
favtimes mediumint(8) unsigned NOT NULL default '0' COMMENT '版块或群组的收藏次数', sharetimes mediumint(8) unsigned NOT NULL default '0' COMMENT '版块或群组的分享次数',
disablethumb tinyint(1) NOT NULL default '0' COMMENT '是否添加缩略图', disablecollect tinyint(1) NOT NULL default '0' COMMENT '禁止淘帖', PRIMARY KEY (fid),
KEY forum (`status`,`type`,displayorder), KEY fup_type (`fup`,`type`,displayorder), KEY fup (fup)
) ENGINE=MyISAM COMMENT='版块表';
DROP TABLE IF EXISTS pre_forum_forumfield; CREATE TABLE pre_forum_forumfield (
fid mediumint(8) unsigned NOT NULL default '0' COMMENT '版块id', description text NOT NULL COMMENT '解释说明',
`password` varchar(12) NOT NULL default COMMENT '私密论坛密码', icon varchar(255) NOT NULL default COMMENT '图标',
redirect varchar(255) NOT NULL default COMMENT 'URL转发',
attachextensions varchar(255) NOT NULL default COMMENT '允许上传附件类型', creditspolicy mediumtext NOT NULL COMMENT '版块积分策略', formulaperm text NOT NULL COMMENT '版块权限表达式',
moderators text NOT NULL COMMENT '版主列表，格式:admin', rules text NOT NULL COMMENT '版块规则',
threadtypes text NOT NULL COMMENT '主题分类，序列化存放的设置，格式为一个数组', threadsorts text NOT NULL COMMENT '分类信息，序列化存放的设置，格式为一个数组', viewperm text NOT NULL COMMENT '阅读权限, 格式: 1 4 5', postperm text NOT NULL COMMENT '发表权限, 格式: 1 4 5', replyperm text NOT NULL COMMENT '回复权限, 格式: 1 4 5',
getattachperm text NOT NULL COMMENT '下载附件权限, 格式: 1 4 5', postattachperm text NOT NULL COMMENT '上传附件权限, 格式: 1 4 5', postimageperm text NOT NULL COMMENT '上传图片权限, 格式: 1 4 5',
spviewperm text NOT NULL COMMENT '不受限于版权权限表达式, 格式: 1 4 5', seotitle text NOT NULL COMMENT '版块seo标题', keywords text NOT NULL COMMENT '版块seo关键词',