seodescription text NOT NULL COMMENT '版块seo描述',
supe_pushsetting text NOT NULL COMMENT 'supe推送设置，序列化存放设置数据，格式为一个数组。',
modrecommend text NOT NULL COMMENT '版主推荐规则', threadplugin text NOT NULL COMMENT '特殊主题插件数据',
extra TEXT NOT NULL,
jointype tinyint(1) NOT NULL default '0' COMMENT '加入群组方式 -1为关闭，0为公开， 2邀请',
gviewperm tinyint(1) unsigned NOT NULL default '0' COMMENT '群组浏览权限 0:仅成员 1:所有用户',
membernum smallint(6) unsigned NOT NULL default '0' COMMENT '群组成员数', dateline int(10) unsigned NOT NULL default '0' COMMENT '群组创建时间',
lastupdate int(10) unsigned NOT NULL default '0' COMMENT '群组最后更新时间', activity int(10) unsigned NOT NULL default '0' COMMENT '群组活跃度',
founderuid mediumint(8) unsigned NOT NULL default '0' COMMENT '群组创始人UID', foundername varchar(255) NOT NULL default COMMENT '群组创始人名称', banner varchar(255) NOT NULL default COMMENT '群组头图片',
groupnum smallint(6) unsigned NOT NULL default '0' COMMENT '分类下的群组数量', commentitem TEXT NOT NULL, relatedgroup TEXT NOT NULL,
picstyle tinyint(1) NOT NULL default '0' COMMENT '帖子列表是否以图片形式显示 0:否 1:是',
widthauto tinyint(1) NOT NULL default '0' COMMENT '默认是否宽屏 0:全局 -1:宽屏 1:窄屏',
PRIMARY KEY (fid),
KEY membernum (membernum), KEY dateline (dateline),
KEY lastupdate (lastupdate), KEY activity (activity)
) ENGINE=MyISAM COMMENT='版块扩展表';
DROP TABLE IF EXISTS pre_forum_forum_threadtable; CREATE TABLE pre_forum_forum_threadtable (
`fid` smallint(6) unsigned NOT NULL COMMENT '版块id',
`threadtableid` smallint(6) unsigned NOT NULL COMMENT 'thread分区id', `threads` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '主题数', `posts` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '帖子数', PRIMARY KEY (`fid`,`threadtableid`)
) ENGINE=MyISAM COMMENT='版块存档信息';
DROP TABLE IF EXISTS pre_forum_forumrecommend; CREATE TABLE pre_forum_forumrecommend (
fid mediumint(8) unsigned NOT NULL default '0' COMMENT '版块id',
tid mediumint(8) unsigned NOT NULL COMMENT '帖子id', typeid smallint(6) NOT NULL COMMENT '是否含有附件图片', displayorder tinyint(1) NOT NULL COMMENT '推荐顺序', `subject` char(80) NOT NULL COMMENT '推荐主题标题', author char(15) NOT NULL COMMENT '推荐主题作者',
authorid mediumint(8) NOT NULL COMMENT '推荐主题作者id', moderatorid mediumint(8) NOT NULL COMMENT '推荐管理人员id', expiration int(10) unsigned NOT NULL COMMENT '推荐主题有效期', position tinyint(1) NOT NULL default '0' COMMENT '显示位置', highlight tinyint(1) NOT NULL default '0' COMMENT '高亮颜色',
aid mediumint(8) unsigned NOT NULL default '0' COMMENT '附件ID', filename char(100) NOT NULL default COMMENT '附件文件', PRIMARY KEY (tid),
KEY displayorder (fid,displayorder), KEY position (position)
) ENGINE=MyISAM COMMENT='版主推荐表';
DROP TABLE IF EXISTS pre_forum_imagetype; CREATE TABLE pre_forum_imagetype (
typeid smallint(6) unsigned NOT NULL auto_increment COMMENT '分类id', available tinyint(1) NOT NULL default '0' COMMENT '是否启用', `name` char(20) NOT NULL COMMENT '分类名称',
`type` enum('smiley','icon','avatar') NOT NULL default 'smiley' COMMENT '分类类型\\n(smiley:表情 icon:图标 avatar:头像)',
displayorder tinyint(3) NOT NULL default '0' COMMENT '分类顺序', `directory` char(100) NOT NULL COMMENT '图片目录', PRIMARY KEY (typeid)
) ENGINE=MyISAM COMMENT='图片 表情 头像等 分类';
DROP TABLE IF EXISTS pre_forum_medal; CREATE TABLE pre_forum_medal (
medalid smallint(6) unsigned NOT NULL auto_increment COMMENT '勋章id', `name` varchar(50) NOT NULL default COMMENT '勋章名称', available tinyint(1) NOT NULL default '0' COMMENT '是否启用', image varchar(255) NOT NULL default COMMENT '勋章图片', `type` tinyint(1) NOT NULL default '0' COMMENT '勋章类型',
displayorder tinyint(3) NOT NULL default '0' COMMENT '勋章显示顺序', description varchar(255) NOT NULL COMMENT '勋章描述',
expiration smallint(6) unsigned NOT NULL default '0' COMMENT '勋章有效期', permission mediumtext NOT NULL COMMENT '勋章获得条件表达式',
`credit` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '勋章购买使用积分', `price` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT '勋章价格',
PRIMARY KEY (medalid),
KEY displayorder (displayorder),
KEY `available` (`available`,`displayorder`) ) ENGINE=MyISAM COMMENT='勋章表';
DROP TABLE IF EXISTS pre_forum_medallog; CREATE TABLE pre_forum_medallog (
id mediumint(8) unsigned NOT NULL auto_increment COMMENT '记录id',
uid mediumint(8) unsigned NOT NULL default '0' COMMENT '勋章拥有着用户id', medalid smallint(6) unsigned NOT NULL default '0' COMMENT '勋章id', `type` tinyint(1) NOT NULL default '0' COMMENT '勋章类型id',
dateline int(10) unsigned NOT NULL default '0' COMMENT '颁发时间id', expiration int(10) unsigned NOT NULL default '0' COMMENT '有效期id', `status` tinyint(1) NOT NULL default '0' COMMENT '勋章状态id', PRIMARY KEY (id), KEY `type` (`type`),
KEY `status` (`status`,expiration), KEY uid (uid,medalid,`type`), KEY `dateline` (`dateline`)
) ENGINE=MyISAM COMMENT='勋章日志表';
DROP TABLE IF EXISTS pre_common_member_magic; CREATE TABLE pre_common_member_magic (
uid mediumint(8) unsigned NOT NULL default '0' COMMENT '用户uid', magicid smallint(6) unsigned NOT NULL default '0' COMMENT '道具id', num smallint(6) unsigned NOT NULL default '0' COMMENT '拥有数量', PRIMARY KEY (uid,magicid)
) ENGINE=MyISAM COMMENT='用户道具数据表';
DROP TABLE IF EXISTS pre_common_member_medal; CREATE TABLE pre_common_member_medal ( uid mediumint(8) unsigned NOT NULL, medalid smallint(6) unsigned NOT NULL, PRIMARY KEY (uid,medalid)
) ENGINE=MyISAM COMMENT='用户勋章数据表';
DROP TABLE IF EXISTS pre_forum_memberrecommend; CREATE TABLE pre_forum_memberrecommend (
tid mediumint(8) unsigned NOT NULL COMMENT '主题ID',
recommenduid mediumint(8) unsigned NOT NULL COMMENT '推荐会员ID',
dateline int(10) unsigned NOT NULL COMMENT '推荐时间', KEY tid (tid),
KEY uid (recommenduid)
) ENGINE=MyISAM COMMENT='用户推荐表';
DROP TABLE IF EXISTS pre_forum_moderator; CREATE TABLE pre_forum_moderator (
uid mediumint(8) unsigned NOT NULL default '0' COMMENT '会员id', fid mediumint(8) unsigned NOT NULL default '0' COMMENT '论坛id', displayorder tinyint(3) NOT NULL default '0' COMMENT '显示顺序', inherited tinyint(1) NOT NULL default '0' COMMENT '是否继承', PRIMARY KEY (uid,fid)
) ENGINE=MyISAM COMMENT='版主表';
DROP TABLE IF EXISTS pre_forum_modwork; CREATE TABLE pre_forum_modwork (
uid mediumint(8) unsigned NOT NULL default '0' COMMENT '会员id', modaction char(3) NOT NULL default COMMENT '动作',
dateline date NOT NULL default '2006-01-01' COMMENT '时间段',
count smallint(6) unsigned NOT NULL default '0' COMMENT '登录次数', posts smallint(6) unsigned NOT NULL default '0' COMMENT '发表数', KEY uid (uid,dateline)
) ENGINE=MyISAM COMMENT='论坛管理统计表';
DROP TABLE IF EXISTS pre_common_mytask; CREATE TABLE pre_common_mytask (
uid mediumint(8) unsigned NOT NULL COMMENT '用户Uid', username char(15) NOT NULL default COMMENT '用户名', taskid smallint(6) unsigned NOT NULL COMMENT '任务id',
`status` tinyint(1) NOT NULL default '0' COMMENT '任务状态\\n(-1:失败 0:进行中 1:已完成)',
csc char(255) NOT NULL default COMMENT '任务进度',
dateline int(10) unsigned NOT NULL default '0' COMMENT '申请任务时间', PRIMARY KEY (uid,taskid), KEY parter (taskid,dateline)
) ENGINE=MyISAM COMMENT='我的任务表';
DROP TABLE IF EXISTS pre_forum_onlinelist; CREATE TABLE pre_forum_onlinelist (
groupid smallint(6) unsigned NOT NULL default '0' COMMENT '会员组id',