Discuz! X2.5数据库字典

来源：用户分享时间：2025/5/21 4:07:24 本文由

说明：文章内容仅供预览，部分内容可能不全，需要完整文档或者需要复制内容，请下载word后使用。下载word有问题请添加微信号:xxxxxxx或QQ：xxxxxx 处理（尽可能给您提供完整文档），感谢您的支持与谅解。

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 (