ip3 tinyint(3) unsigned NOT NULL default '0' COMMENT 'IP段', ip4 tinyint(3) unsigned NOT NULL default '0' COMMENT 'IP段',
uid mediumint(8) unsigned NOT NULL default '0' COMMENT '会员id', username char(15) NOT NULL default COMMENT '会员名',
groupid smallint(6) unsigned NOT NULL default '0' COMMENT '会员组', invisible tinyint(1) NOT NULL default '0' COMMENT '是否隐身登录',
`action` tinyint(1) unsigned NOT NULL default '0' COMMENT '当前动作', lastactivity int(10) unsigned NOT NULL default '0' COMMENT '最后活动时间',
lastolupdate int(10) unsigned NOT NULL default '0' COMMENT '在线时间最后更新', fid mediumint(8) unsigned NOT NULL default '0' COMMENT '论坛id', tid mediumint(8) unsigned NOT NULL default '0' COMMENT '主题id', UNIQUE KEY sid (sid), KEY uid (uid)
) ENGINE=MEMORY COMMENT='会员认证表';
DROP TABLE IF EXISTS pre_common_setting; CREATE TABLE pre_common_setting (
skey varchar(255) NOT NULL default COMMENT '变量名', svalue text NOT NULL COMMENT '值', PRIMARY KEY (skey)
) ENGINE=MyISAM COMMENT='设置表';
DROP TABLE IF EXISTS pre_common_smiley; CREATE TABLE pre_common_smiley (
id smallint(6) unsigned NOT NULL auto_increment COMMENT '表情id', typeid smallint(6) unsigned NOT NULL COMMENT '表情分类 id', displayorder tinyint(1) NOT NULL default '0' COMMENT '显示顺序',
`type` enum('smiley','stamp','stamplist') NOT NULL default 'smiley' COMMENT '类型', `code` varchar(30) NOT NULL default COMMENT '标记', url varchar(30) NOT NULL default COMMENT '路径', PRIMARY KEY (id),
KEY `type` (`type`, displayorder)
) ENGINE=MyISAM COMMENT='表情表';
DROP TABLE IF EXISTS pre_common_stat; CREATE TABLE pre_common_stat (
daytime int(10) unsigned NOT NULL default '0' COMMENT '时间', login int(10) unsigned NOT NULL default '0' COMMENT '登陆',
mobilelogin int(10) unsigned NOT NULL default '0' COMMENT '手机登陆',
connectlogin int(10) unsigned NOT NULL default '0' COMMENT 'QQConnect登陆', register int(10) unsigned NOT NULL default '0' COMMENT '注册',
invite int(10) unsigned NOT NULL default '0' COMMENT '邀请',
appinvite int(10) unsigned NOT NULL default '0' COMMENT '应用邀请', doing int(10) unsigned NOT NULL default '0' COMMENT '记录', blog int(10) unsigned NOT NULL default '0' COMMENT '日志', pic int(10) unsigned NOT NULL default '0' COMMENT '图片', poll int(10) unsigned NOT NULL default '0' COMMENT '投票', activity int(10) unsigned NOT NULL default '0' COMMENT '活动', `share` int(10) unsigned NOT NULL default '0' COMMENT '分享', thread int(10) unsigned NOT NULL default '0' COMMENT '主题',
docomment int(10) unsigned NOT NULL default '0' COMMENT '记录评论', blogcomment int(10) unsigned NOT NULL default '0' COMMENT '日志评论', piccomment int(10) unsigned NOT NULL default '0' COMMENT '图片评论', sharecomment int(10) unsigned NOT NULL default '0' COMMENT '分享评论', reward int(10) unsigned NOT NULL default '0' COMMENT '悬赏', debate int(10) unsigned NOT NULL default '0' COMMENT '辩论', trade int(10) unsigned NOT NULL default '0' COMMENT '商品', `group` int(10) unsigned NOT NULL default '0' COMMENT '群组',
groupjoin int(10) unsigned NOT NULL default '0' COMMENT '参与群组', groupthread int(10) unsigned NOT NULL default '0' COMMENT '群组主题', grouppost int(10) unsigned NOT NULL default '0' COMMENT '群组回复', post int(10) unsigned NOT NULL default '0' COMMENT '主题回复', wall int(10) unsigned NOT NULL default '0' COMMENT '留言', poke int(10) unsigned NOT NULL default '0' COMMENT '打招呼', click int(10) unsigned NOT NULL default '0' COMMENT '表态',
sendpm int(10) unsigned NOT NULL default '0' COMMENT '发送PM', friend int(10) unsigned NOT NULL default '0' COMMENT '成为好友', addfriend int(10) unsigned NOT NULL default '0' COMMENT '好友请求', PRIMARY KEY (daytime)
) ENGINE=MyISAM COMMENT='趋势统计';
DROP TABLE IF EXISTS pre_common_statuser; CREATE TABLE pre_common_statuser (
uid mediumint(8) unsigned NOT NULL default '0', daytime int(10) unsigned NOT NULL default '0',
`type` char(20) NOT NULL default COMMENT '各种用户行为如：invite、register、login...', KEY uid (uid)
) ENGINE=MyISAM COMMENT='统计用户表';
DROP TABLE IF EXISTS pre_common_style; CREATE TABLE pre_common_style (
styleid smallint(6) unsigned NOT NULL auto_increment COMMENT '风格id', `name` varchar(20) NOT NULL default COMMENT '风格名称',
available tinyint(1) NOT NULL default '1' COMMENT '风格是否可用',
templateid smallint(6) unsigned NOT NULL default '0' COMMENT '对应模板id', extstyle varchar(255) NOT NULL default COMMENT '配色', PRIMARY KEY (styleid)
) ENGINE=MyISAM COMMENT='风格表';
DROP TABLE IF EXISTS pre_common_stylevar; CREATE TABLE pre_common_stylevar (
stylevarid smallint(6) unsigned NOT NULL auto_increment COMMENT '风格变量id', styleid smallint(6) unsigned NOT NULL default '0' COMMENT '风格id', variable text NOT NULL COMMENT '变量名', substitute text NOT NULL COMMENT '变量赋值', PRIMARY KEY (stylevarid), KEY styleid (styleid)
) ENGINE=MyISAM COMMENT='风格变量表';
DROP TABLE IF EXISTS pre_common_syscache; CREATE TABLE pre_common_syscache (
cname varchar(32) NOT NULL COMMENT '缓存名称',
`ctype` tinyint(3) unsigned NOT NULL COMMENT '缓存类型 0=value, serialize=1', dateline int(10) unsigned NOT NULL COMMENT '缓存生成时间', `data` mediumblob NOT NULL COMMENT '缓存数据', PRIMARY KEY (cname)
) ENGINE=MyISAM COMMENT='缓存数据表';
DROP TABLE IF EXISTS pre_common_template; CREATE TABLE pre_common_template (
templateid smallint(6) unsigned NOT NULL auto_increment COMMENT '模板id', `name` varchar(30) NOT NULL default COMMENT '名称', `directory` varchar(100) NOT NULL default COMMENT '目录', copyright varchar(100) NOT NULL default COMMENT '版权', PRIMARY KEY (templateid)
) ENGINE=MyISAM COMMENT='模板表';
DROP TABLE IF EXISTS pre_common_usergroup; CREATE TABLE pre_common_usergroup (
groupid smallint(6) unsigned NOT NULL auto_increment COMMENT '会员组id', radminid tinyint(3) NOT NULL default '0' COMMENT '关联关管理组',
`type` enum('system','special','member') NOT NULL default 'member' COMMENT '类型', system varchar(255) NOT NULL default 'private' COMMENT '会员是否可以自由进出',
grouptitle varchar(255) NOT NULL default COMMENT '组头衔',
creditshigher int(10) NOT NULL default '0' COMMENT '该组的积分上限', creditslower int(10) NOT NULL default '0' COMMENT '该组的积分下限', stars tinyint(3) NOT NULL default '0' COMMENT '星星数量', color varchar(255) NOT NULL default COMMENT '组头衔颜色',
icon varchar(255) NOT NULL default ,
allowvisit tinyint(1) NOT NULL default '0' COMMENT '允许访问',
allowsendpm tinyint(1) NOT NULL default '1' COMMENT '是否允许发送短信息', allowinvite tinyint(1) NOT NULL default '0' COMMENT '允许使用邀请注册',
allowmailinvite tinyint(1) NOT NULL default '0' COMMENT '允许通过论坛邮件系统发送邀请码',
maxinvitenum tinyint(3) unsigned NOT NULL default '0' COMMENT '最大邀请码拥有数量', inviteprice smallint(6) unsigned NOT NULL default '0' COMMENT '邀请码购买价格', maxinviteday smallint(6) unsigned NOT NULL default '0' COMMENT '邀请码有效期', PRIMARY KEY (groupid),
KEY creditsrange (creditshigher,creditslower) ) ENGINE=MyISAM COMMENT='用户组表';
DROP TABLE IF EXISTS pre_common_usergroup_field; CREATE TABLE pre_common_usergroup_field (
groupid smallint(6) unsigned NOT NULL COMMENT '会员组id',
readaccess tinyint(3) unsigned NOT NULL default '0' COMMENT '阅读权限', allowpost tinyint(1) NOT NULL default '0' COMMENT '允许发帖', allowreply tinyint(1) NOT NULL default '0' COMMENT '允许回复',
allowpostpoll tinyint(1) NOT NULL default '0' COMMENT '允许发表投票', allowpostreward tinyint(1) NOT NULL default '0' COMMENT '允许发表悬赏', allowposttrade tinyint(1) NOT NULL default '0' COMMENT '允许发表交易', allowpostactivity tinyint(1) NOT NULL default '0' COMMENT '允许发表活动', allowdirectpost tinyint(1) NOT NULL default '0' COMMENT '是否需要审核', allowgetattach tinyint(1) NOT NULL default '0' COMMENT '允许下载附件', allowgetimage tinyint(1) NOT NULL default '0' COMMENT '允许查看图片', allowpostattach tinyint(1) NOT NULL default '0' COMMENT '允许上传附件', allowpostimage tinyint(1) NOT NULL default '0' COMMENT '允许上传图片', allowvote tinyint(1) NOT NULL default '0' COMMENT '允许参与投票', allowsearch tinyint(1) NOT NULL default '0' COMMENT '允许搜索',
allowcstatus tinyint(1) NOT NULL default '0' COMMENT '允许自定义头衔', allowinvisible tinyint(1) NOT NULL default '0' COMMENT '允许隐身登录', allowtransfer tinyint(1) NOT NULL default '0' COMMENT '允许积分转帐',
allowsetreadperm tinyint(1) NOT NULL default '0' COMMENT '允许设置阅读权限', allowsetattachperm tinyint(1) NOT NULL default '0' COMMENT '允许设置附件权限', allowposttag tinyint(1) NOT NULL default '0' COMMENT '允许使用标签',
allowhidecode tinyint(1) NOT NULL default '0' COMMENT '允许使用hide代码', allowhtml tinyint(1) NOT NULL default '0' COMMENT '允许使用html',