displayorder tinyint(3) NOT NULL default '0' COMMENT '显示顺序', title varchar(30) NOT NULL default COMMENT '组名称', url varchar(30) NOT NULL default COMMENT '图例URL' ) ENGINE=MyISAM COMMENT='在线列表定制';
DROP TABLE IF EXISTS pre_forum_order; CREATE TABLE pre_forum_order (
orderid char(32) NOT NULL default COMMENT '订单号id', `status` char(3) NOT NULL default COMMENT '状态',
buyer char(50) NOT NULL default COMMENT '购买者姓名',
admin char(15) NOT NULL default COMMENT '补单管理员姓名',
uid mediumint(8) unsigned NOT NULL default '0' COMMENT '购买者id', amount int(10) unsigned NOT NULL default '0' COMMENT '数量', price float(7,2) unsigned NOT NULL default '0.00' COMMENT '价格',
submitdate int(10) unsigned NOT NULL default '0' COMMENT '提交日期', confirmdate int(10) unsigned NOT NULL default '0' COMMENT '确认日期', email char(40) NOT NULL default COMMENT '购买时的Email', ip char(15) NOT NULL default COMMENT '购买时的IP', UNIQUE KEY orderid (orderid), KEY submitdate (submitdate), KEY uid (uid,submitdate)
) ENGINE=MyISAM COMMENT='订单信息表';
DROP TABLE IF EXISTS pre_forum_groupfield; CREATE TABLE pre_forum_groupfield (
fid mediumint(8) unsigned NOT NULL default '0' COMMENT '群组关联fid', privacy tinyint(1) unsigned NOT NULL default '0' COMMENT '群组隐私设置', dateline int(10) unsigned NOT NULL default '0' COMMENT '缓存生成时间', type varchar(255) NOT NULL COMMENT '缓存类型', data text NOT NULL COMMENT '缓存数据',
UNIQUE KEY types (fid,type), KEY fid (fid), KEY type (type)
) ENGINE = MyISAM COMMENT='群组扩展信息缓存';
DROP TABLE IF EXISTS pre_forum_groupinvite; CREATE TABLE pre_forum_groupinvite (
fid MEDIUMINT( 8 ) UNSIGNED NOT NULL default '0' COMMENT '群组id', uid MEDIUMINT( 8 ) UNSIGNED NOT NULL default '0' COMMENT '邀请人id',
inviteuid MEDIUMINT( 8 ) UNSIGNED NOT NULL default '0' COMMENT '被邀请人id', dateline INT( 10 ) UNSIGNED NOT NULL default '0' COMMENT '邀请时间',
UNIQUE KEY ids (fid,inviteuid), KEY dateline (dateline)
) ENGINE = MYISAM COMMENT='群组邀请';
DROP TABLE IF EXISTS pre_forum_groupuser; CREATE TABLE pre_forum_groupuser (
fid MEDIUMINT( 8 ) UNSIGNED NOT NULL default '0' COMMENT '群组关联fid', uid MEDIUMINT( 8 ) UNSIGNED NOT NULL default '0' COMMENT '成员id', username CHAR( 15 ) NOT NULL COMMENT '成员名',
level TINYINT( 3 ) UNSIGNED NOT NULL default '0' COMMENT '成员等级\\n(0:待审核 1:群主 2:副群主 3:明星成员 4:普通成员)',
threads MEDIUMINT( 8 ) UNSIGNED NOT NULL default '0' COMMENT '成员主题数', replies MEDIUMINT( 8 ) UNSIGNED NOT NULL default '0' COMMENT '成员回复数', joindateline INT( 10 ) UNSIGNED NOT NULL default '0' COMMENT '成员加入群组时间', lastupdate INT( 10 ) UNSIGNED NOT NULL default '0' COMMENT '成员最后活动时间', privacy TINYINT( 1 ) UNSIGNED NOT NULL default '0' COMMENT '成员隐私设置', PRIMARY KEY (fid,uid),
KEY uid_lastupdate (uid,lastupdate), KEY userlist (fid,level,lastupdate)
) ENGINE = MYISAM COMMENT='群组成员';
DROP TABLE IF EXISTS pre_common_plugin; CREATE TABLE pre_common_plugin (
pluginid smallint(6) unsigned NOT NULL auto_increment COMMENT '插件id', available tinyint(1) NOT NULL default '0' COMMENT '是否启用',
adminid tinyint(1) unsigned NOT NULL default '0' COMMENT '管理员id', `name` varchar(40) NOT NULL default COMMENT '名称',
identifier varchar(40) NOT NULL default COMMENT '唯一标识符', description varchar(255) NOT NULL default COMMENT '解释说明', datatables varchar(255) NOT NULL default COMMENT '插件数据表', `directory` varchar(100) NOT NULL default COMMENT '插件目录', copyright varchar(100) NOT NULL default COMMENT '版权信息', modules text NOT NULL COMMENT '插件信息',
version varchar(20) NOT NULL default COMMENT '插件版本', PRIMARY KEY (pluginid),
UNIQUE KEY identifier (identifier)
) ENGINE=MyISAM COMMENT='插件表';
DROP TABLE IF EXISTS pre_common_pluginvar; CREATE TABLE pre_common_pluginvar (
pluginvarid mediumint(8) unsigned NOT NULL auto_increment COMMENT '插件变量id',
pluginid smallint(6) unsigned NOT NULL default '0' COMMENT '插件id', displayorder tinyint(3) NOT NULL default '0' COMMENT '显示顺序', title varchar(100) NOT NULL default COMMENT '名称',
description varchar(255) NOT NULL default COMMENT '解释说明', variable varchar(40) NOT NULL default COMMENT '变量名', `type` varchar(20) NOT NULL default 'text' COMMENT '类型', `value` text NOT NULL COMMENT '值', extra text NOT NULL COMMENT '附加', PRIMARY KEY (pluginvarid), KEY pluginid (pluginid)
) ENGINE=MyISAM COMMENT='插件变量表';
DROP TABLE IF EXISTS pre_forum_thread_moderate; CREATE TABLE pre_forum_thread_moderate (
id int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'ID',
status tinyint(3) NOT NULL default '0' COMMENT '状态 0 审核中，1 已忽略', `dateline` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (id),
KEY status (status, dateline)
) ENGINE=MyISAM COMMENT='主题审核数据表';
DROP TABLE IF EXISTS pre_forum_post_moderate; CREATE TABLE pre_forum_post_moderate (
id int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'ID',
status tinyint(3) NOT NULL default '0' COMMENT '状态 0 审核中，1 已忽略', `dateline` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (id),
KEY status (status, dateline)
) ENGINE=MyISAM COMMENT='帖子审核数据表';
DROP TABLE IF EXISTS pre_home_blog_moderate; CREATE TABLE pre_home_blog_moderate (
id int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'ID',
status tinyint(3) NOT NULL default '0' COMMENT '状态 0 审核中，1 已忽略', `dateline` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (id),
KEY status (status, dateline)
) ENGINE=MyISAM COMMENT='日志审核数据表';
DROP TABLE IF EXISTS pre_home_pic_moderate;
CREATE TABLE pre_home_pic_moderate (
id int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'ID',
status tinyint(3) NOT NULL default '0' COMMENT '状态 0 审核中，1 已忽略', `dateline` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (id),
KEY status (status, dateline)
) ENGINE=MyISAM COMMENT='图片审核数据表';
DROP TABLE IF EXISTS pre_home_doing_moderate; CREATE TABLE pre_home_doing_moderate (
id int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'ID',
status tinyint(3) NOT NULL default '0' COMMENT '状态 0 审核中，1 已忽略', `dateline` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (id),
KEY status (status, dateline)
) ENGINE=MyISAM COMMENT='记录审核数据表';
DROP TABLE IF EXISTS pre_home_share_moderate; CREATE TABLE pre_home_share_moderate (
id int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'ID',
status tinyint(3) NOT NULL default '0' COMMENT '状态 0 审核中，1 已忽略', `dateline` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (id),
KEY status (status, dateline)
) ENGINE=MyISAM COMMENT='分享审核数据表';
DROP TABLE IF EXISTS pre_portal_article_moderate; CREATE TABLE pre_portal_article_moderate (
id int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'ID',
status tinyint(3) NOT NULL default '0' COMMENT '状态 0 审核中，1 已忽略', `dateline` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (id),
KEY status (status, dateline)
) ENGINE=MyISAM COMMENT='文章审核数据表';
DROP TABLE IF EXISTS pre_home_comment_moderate; CREATE TABLE pre_home_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 已忽略',