validate text NOT NULL COMMENT '验证数据的正则表达式', PRIMARY KEY (fieldid)
) ENGINE=MyISAM COMMENT='个人信息扩展表';
DROP TABLE IF EXISTS pre_common_member_security; CREATE TABLE pre_common_member_security (
securityid mediumint(8) unsigned NOT NULL auto_increment COMMENT '审核项id', uid mediumint(8) unsigned NOT NULL default '0' COMMENT '会员id', username varchar(255) NOT NULL default COMMENT '用户名',
fieldid varchar(255) NOT NULL default COMMENT 'profile字段标志符', oldvalue text NOT NULL COMMENT '旧的profile字段值', newvalue text NOT NULL COMMENT '新的profile字段值',
dateline int(10) unsigned NOT NULL default '0' COMMENT '提交日期', PRIMARY KEY (securityid), KEY uid (uid, fieldid), KEY dateline (dateline)
) ENGINE=MyISAM COMMENT='个人信息修改审核';
DROP TABLE IF EXISTS pre_common_member_validate; CREATE TABLE pre_common_member_validate (
uid mediumint(8) unsigned NOT NULL default '0' COMMENT '会员id', submitdate int(10) unsigned NOT NULL default '0' COMMENT '提交日期', moddate int(10) unsigned NOT NULL default '0' COMMENT '审核日期', admin varchar(15) NOT NULL default COMMENT '管理员名',
submittimes tinyint(3) unsigned NOT NULL default '0' COMMENT '提交的次数', `status` tinyint(1) NOT NULL default '0' COMMENT '状态', message text NOT NULL COMMENT '注册原因', remark text NOT NULL COMMENT '管理员留言', PRIMARY KEY (uid), KEY `status` (`status`)
) ENGINE=MyISAM COMMENT='用户审核表';
DROP TABLE IF EXISTS pre_common_member_crime; CREATE TABLE pre_common_member_crime (
cid mediumint(8) unsigned NOT NULL auto_increment COMMENT '自增id',
uid mediumint(8) unsigned NOT NULL default '0' COMMENT '被惩罚操作的用户id',
operatorid mediumint(8) unsigned NOT NULL default '0' COMMENT '进行惩罚操作的用户id',
operator varchar(15) NOT NULL COMMENT '进行惩罚操作的用户名', `action` tinyint(5) NOT NULL COMMENT '惩罚行为', reason text NOT NULL COMMENT '惩罚理由',
dateline int(10) unsigned NOT NULL default '0' COMMENT '惩罚操作时间', PRIMARY KEY (cid),
KEY uid (uid,`action`,dateline)
) ENGINE=MyISAM COMMENT='用户惩罚操作表';
DROP TABLE IF EXISTS pre_common_member_grouppm; CREATE TABLE pre_common_member_grouppm (
uid mediumint(8) unsigned NOT NULL default '0' COMMENT '会员id',
gpmid smallint(6) unsigned NOT NULL auto_increment COMMENT '消息id', status tinyint(1) NOT NULL default '0' COMMENT '0=未读 1=已读 -1=删除', dateline int(10) unsigned NOT NULL default '0' COMMENT '阅读时间', PRIMARY KEY (uid, gpmid)
) ENGINE=MyISAM COMMENT='群发短消息用户记录表';
DROP TABLE IF EXISTS pre_common_grouppm; CREATE TABLE pre_common_grouppm (
id smallint(6) unsigned NOT NULL auto_increment COMMENT '消息id', authorid mediumint(8) unsigned NOT NULL default '0' COMMENT '作者id', author varchar(15) NOT NULL default COMMENT '作者姓名',
dateline int(10) unsigned NOT NULL default '0' COMMENT '时间', message text NOT NULL COMMENT '消息',
numbers mediumint(8) unsigned NOT NULL default '0' COMMENT '数量', PRIMARY KEY (id)
) ENGINE=MyISAM COMMENT='群发短消息表';
DROP TABLE IF EXISTS pre_common_myapp; CREATE TABLE pre_common_myapp (
appid mediumint(8) unsigned NOT NULL default '0' COMMENT '应用id', appname varchar(60) NOT NULL default COMMENT '应用名称',
narrow tinyint(1) NOT NULL default '0' COMMENT '是否显示为窄的profile box',
flag tinyint(1) NOT NULL default '0' COMMENT '应用状态（黑白名单、默认应用等）', version mediumint(8) unsigned NOT NULL default '0' COMMENT '应用版本号',
userpanelarea tinyint(1) NOT NULL default '0' COMMENT 'userabout显示区域、1主区、2、副区、3应用区',
canvastitle varchar(60) NOT NULL default COMMENT 'canvas页面标题', fullscreen tinyint(1) NOT NULL default '0' COMMENT '是否是全屏应用',
displayuserpanel tinyint(1) NOT NULL default '0' COMMENT '是否显示应用右侧的用户菜单',
displaymethod tinyint(1) NOT NULL default '0' COMMENT '显示方式（iframe/myml）', displayorder smallint(6) unsigned NOT NULL default '0' COMMENT '显示顺序', appstatus tinyint(2) NOT NULL default '0' COMMENT '标识应用1:新、2:热',
iconstatus tinyint(2) NOT NULL default '0' COMMENT '应用图标是否已下载到本地。-1：失
败；0：未下载；1：已下载',
icondowntime int(10) unsigned NOT NULL default '0' COMMENT '应用图标下载到本地时间',
PRIMARY KEY (appid),
KEY flag (flag,displayorder)
) ENGINE=MyISAM COMMENT='漫游应用表';
DROP TABLE IF EXISTS pre_common_myinvite; CREATE TABLE pre_common_myinvite (
id mediumint(8) unsigned NOT NULL auto_increment COMMENT '邀请id', typename varchar(100) NOT NULL default COMMENT '邀请名称', appid mediumint(8) NOT NULL default '0' COMMENT '应用id',
`type` tinyint(1) NOT NULL default '0' COMMENT '类型(request 邀请/invite 请求)', fromuid mediumint(8) unsigned NOT NULL default '0' COMMENT '邀请者id', touid mediumint(8) unsigned NOT NULL default '0' COMMENT '接收者id', myml text NOT NULL COMMENT '邀请内容',
dateline int(10) unsigned NOT NULL default '0' COMMENT '发送邀请的时间戳', `hash` int(10) unsigned NOT NULL default '0' COMMENT 'hash标记', PRIMARY KEY (id), KEY `hash` (`hash`), KEY uid (touid,dateline)
) ENGINE=MyISAM COMMENT='用户邀请表';
DROP TABLE IF EXISTS pre_common_nav; CREATE TABLE pre_common_nav (
id smallint(6) unsigned NOT NULL auto_increment COMMENT '项目id',
parentid smallint(6) unsigned NOT NULL default '0' COMMENT '父 id(navtype=0)', `name` varchar(255) NOT NULL COMMENT '导航名称', title varchar(255) NOT NULL COMMENT '导航说明', url varchar(255) NOT NULL COMMENT '导航链接',
identifier varchar(255) NOT NULL COMMENT '链接标识/相关ID',
target tinyint(1) NOT NULL default '0' COMMENT '目标框架\\n(0:本窗口 1:新窗口)',
`type` tinyint(1) NOT NULL default '0' COMMENT '类型 0 系统 1 自定义 3 插件 4 频道',
available tinyint(1) NOT NULL default '0' COMMENT '是否可用', displayorder tinyint(3) NOT NULL COMMENT '显示顺序',
highlight tinyint(1) NOT NULL default '0' COMMENT '样式(navtype=0)',
`level` tinyint(1) NOT NULL default '0' COMMENT '使用等级\\n(0:游客 1:会员 2:版主 3:管理员)',
`subtype` tinyint(1) NOT NULL DEFAULT '0' COMMENT '二级导航样式(navtype=0) 顶部导航位置(navtype=4)',
`subcols` tinyint(1) NOT NULL DEFAULT '0' COMMENT '横排一行显示的条目数
(navtype=0)',
`icon` varchar(255) NOT NULL COMMENT '图标地址(navtype=1、3)', `subname` varchar(255) NOT NULL COMMENT '副导航名称(navtype=1)', `suburl` varchar(255) NOT NULL COMMENT '副导航地址(navtype=1)',
`navtype` tinyint(1) NOT NULL default '0' COMMENT '导航类型\\n(0:主导航 1:底部导航 2:家园导航 3:快捷导航 4:顶部导航)',
logo varchar(255) NOT NULL COMMENT '自定义 Logo', PRIMARY KEY (id),
KEY `navtype` (`navtype`)
) ENGINE=MyISAM COMMENT='自定义导航栏表';
DROP TABLE IF EXISTS pre_common_onlinetime; CREATE TABLE pre_common_onlinetime (
uid mediumint(8) unsigned NOT NULL DEFAULT '0',
thismonth smallint(6) unsigned NOT NULL DEFAULT '0' COMMENT '本月在线时间', total mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT '总在线时间', lastupdate int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (uid)
) ENGINE=MyISAM COMMENT='在线时间表';
DROP TABLE IF EXISTS pre_common_regip; CREATE TABLE pre_common_regip (
ip char(15) NOT NULL default COMMENT 'IP地址',
dateline int(10) unsigned NOT NULL default '0' COMMENT '限制时间', count smallint(6) NOT NULL default '0' COMMENT '限制数量', KEY ip (ip)
) ENGINE=MyISAM COMMENT='注册IP限制表';
DROP TABLE IF EXISTS pre_common_secquestion; CREATE TABLE pre_common_secquestion (
id smallint(6) unsigned NOT NULL auto_increment COMMENT '验证问题id', `type` tinyint(1) unsigned NOT NULL COMMENT '验证问题类型', question text NOT NULL COMMENT '验证问题',
answer varchar(255) NOT NULL COMMENT '问题答案', PRIMARY KEY (id)
) ENGINE=MyISAM COMMENT='验证问题数据表';
DROP TABLE IF EXISTS pre_common_session; CREATE TABLE pre_common_session (
sid char(6) NOT NULL default COMMENT 'sid',
ip1 tinyint(3) unsigned NOT NULL default '0' COMMENT 'IP段', ip2 tinyint(3) unsigned NOT NULL default '0' COMMENT 'IP段',