Discuz! X2.5数据库字典

KEY uid (uid)

) ENGINE=MyISAM COMMENT='附件表';

DROP TABLE IF EXISTS pre_forum_attachment_4; CREATE TABLE pre_forum_attachment_4 (

aid mediumint(8) unsigned NOT NULL COMMENT '附件id',

tid mediumint(8) unsigned NOT NULL default '0' COMMENT '主题id', pid int(10) unsigned NOT NULL default '0' COMMENT '帖子id',

uid mediumint(8) unsigned NOT NULL default '0' COMMENT '会员id', dateline int(10) unsigned NOT NULL default '0' COMMENT '上传时间', filename varchar(255) NOT NULL default COMMENT '原文件名',

filesize int(10) unsigned NOT NULL default '0' COMMENT '文件大小', attachment varchar(255) NOT NULL default COMMENT '服务器路径',

remote tinyint(1) unsigned NOT NULL default '0' COMMENT '是否远程附件', description varchar(255) NOT NULL COMMENT '说明',

readperm tinyint(3) unsigned NOT NULL default '0' COMMENT '阅读权限', price smallint(6) unsigned NOT NULL default '0' COMMENT '附件价格', isimage tinyint(1) NOT NULL default '0' COMMENT '是否图片',

width smallint(6) unsigned NOT NULL default '0' COMMENT '附件宽度', thumb tinyint(1) unsigned NOT NULL default '0' COMMENT '是否是缩率图', picid mediumint(8) NOT NULL default '0' COMMENT '相册图片ID ', PRIMARY KEY (aid), KEY tid (tid), KEY pid (pid), KEY uid (uid)

) ENGINE=MyISAM COMMENT='附件表';

DROP TABLE IF EXISTS pre_forum_attachment_5; CREATE TABLE pre_forum_attachment_5 (

aid mediumint(8) unsigned NOT NULL COMMENT '附件id',

tid mediumint(8) unsigned NOT NULL default '0' COMMENT '主题id', pid int(10) unsigned NOT NULL default '0' COMMENT '帖子id',

uid mediumint(8) unsigned NOT NULL default '0' COMMENT '会员id', dateline int(10) unsigned NOT NULL default '0' COMMENT '上传时间', filename varchar(255) NOT NULL default COMMENT '原文件名',

filesize int(10) unsigned NOT NULL default '0' COMMENT '文件大小', attachment varchar(255) NOT NULL default COMMENT '服务器路径',

remote tinyint(1) unsigned NOT NULL default '0' COMMENT '是否远程附件', description varchar(255) NOT NULL COMMENT '说明',

readperm tinyint(3) unsigned NOT NULL default '0' COMMENT '阅读权限', price smallint(6) unsigned NOT NULL default '0' COMMENT '附件价格', isimage tinyint(1) NOT NULL default '0' COMMENT '是否图片',

width smallint(6) unsigned NOT NULL default '0' COMMENT '附件宽度', thumb tinyint(1) unsigned NOT NULL default '0' COMMENT '是否是缩率图', picid mediumint(8) NOT NULL default '0' COMMENT '相册图片ID ', PRIMARY KEY (aid),

KEY tid (tid), KEY pid (pid), KEY uid (uid)

) ENGINE=MyISAM COMMENT='附件表';

DROP TABLE IF EXISTS pre_forum_attachment_6; CREATE TABLE pre_forum_attachment_6 (

aid mediumint(8) unsigned NOT NULL COMMENT '附件id',

tid mediumint(8) unsigned NOT NULL default '0' COMMENT '主题id', pid int(10) unsigned NOT NULL default '0' COMMENT '帖子id',

uid mediumint(8) unsigned NOT NULL default '0' COMMENT '会员id', dateline int(10) unsigned NOT NULL default '0' COMMENT '上传时间', filename varchar(255) NOT NULL default COMMENT '原文件名',

filesize int(10) unsigned NOT NULL default '0' COMMENT '文件大小', attachment varchar(255) NOT NULL default COMMENT '服务器路径',

remote tinyint(1) unsigned NOT NULL default '0' COMMENT '是否远程附件', description varchar(255) NOT NULL COMMENT '说明',

readperm tinyint(3) unsigned NOT NULL default '0' COMMENT '阅读权限', price smallint(6) unsigned NOT NULL default '0' COMMENT '附件价格', isimage tinyint(1) NOT NULL default '0' COMMENT '是否图片',

width smallint(6) unsigned NOT NULL default '0' COMMENT '附件宽度', thumb tinyint(1) unsigned NOT NULL default '0' COMMENT '是否是缩率图', picid mediumint(8) NOT NULL default '0' COMMENT '相册图片ID ', PRIMARY KEY (aid), KEY tid (tid), KEY pid (pid), KEY uid (uid)

) ENGINE=MyISAM COMMENT='附件表';

DROP TABLE IF EXISTS pre_forum_attachment_7; CREATE TABLE pre_forum_attachment_7 (

aid mediumint(8) unsigned NOT NULL COMMENT '附件id',

tid mediumint(8) unsigned NOT NULL default '0' COMMENT '主题id', pid int(10) unsigned NOT NULL default '0' COMMENT '帖子id',

uid mediumint(8) unsigned NOT NULL default '0' COMMENT '会员id', dateline int(10) unsigned NOT NULL default '0' COMMENT '上传时间', filename varchar(255) NOT NULL default COMMENT '原文件名',

filesize int(10) unsigned NOT NULL default '0' COMMENT '文件大小', attachment varchar(255) NOT NULL default COMMENT '服务器路径',

remote tinyint(1) unsigned NOT NULL default '0' COMMENT '是否远程附件', description varchar(255) NOT NULL COMMENT '说明',

readperm tinyint(3) unsigned NOT NULL default '0' COMMENT '阅读权限', price smallint(6) unsigned NOT NULL default '0' COMMENT '附件价格', isimage tinyint(1) NOT NULL default '0' COMMENT '是否图片',

width smallint(6) unsigned NOT NULL default '0' COMMENT '附件宽度', thumb tinyint(1) unsigned NOT NULL default '0' COMMENT '是否是缩率图',

picid mediumint(8) NOT NULL default '0' COMMENT '相册图片ID ', PRIMARY KEY (aid), KEY tid (tid), KEY pid (pid), KEY uid (uid)

) ENGINE=MyISAM COMMENT='附件表';

DROP TABLE IF EXISTS pre_forum_attachment_8; CREATE TABLE pre_forum_attachment_8 (

aid mediumint(8) unsigned NOT NULL COMMENT '附件id',

tid mediumint(8) unsigned NOT NULL default '0' COMMENT '主题id', pid int(10) unsigned NOT NULL default '0' COMMENT '帖子id',

uid mediumint(8) unsigned NOT NULL default '0' COMMENT '会员id', dateline int(10) unsigned NOT NULL default '0' COMMENT '上传时间', filename varchar(255) NOT NULL default COMMENT '原文件名',

filesize int(10) unsigned NOT NULL default '0' COMMENT '文件大小', attachment varchar(255) NOT NULL default COMMENT '服务器路径',

remote tinyint(1) unsigned NOT NULL default '0' COMMENT '是否远程附件', description varchar(255) NOT NULL COMMENT '说明',

readperm tinyint(3) unsigned NOT NULL default '0' COMMENT '阅读权限', price smallint(6) unsigned NOT NULL default '0' COMMENT '附件价格', isimage tinyint(1) NOT NULL default '0' COMMENT '是否图片',

width smallint(6) unsigned NOT NULL default '0' COMMENT '附件宽度', thumb tinyint(1) unsigned NOT NULL default '0' COMMENT '是否是缩率图', picid mediumint(8) NOT NULL default '0' COMMENT '相册图片ID ', PRIMARY KEY (aid), KEY tid (tid), KEY pid (pid), KEY uid (uid)

) ENGINE=MyISAM COMMENT='附件表';

DROP TABLE IF EXISTS pre_forum_attachment_9; CREATE TABLE pre_forum_attachment_9 (

aid mediumint(8) unsigned NOT NULL COMMENT '附件id',

tid mediumint(8) unsigned NOT NULL default '0' COMMENT '主题id', pid int(10) unsigned NOT NULL default '0' COMMENT '帖子id',

uid mediumint(8) unsigned NOT NULL default '0' COMMENT '会员id', dateline int(10) unsigned NOT NULL default '0' COMMENT '上传时间', filename varchar(255) NOT NULL default COMMENT '原文件名',

filesize int(10) unsigned NOT NULL default '0' COMMENT '文件大小', attachment varchar(255) NOT NULL default COMMENT '服务器路径',

remote tinyint(1) unsigned NOT NULL default '0' COMMENT '是否远程附件', description varchar(255) NOT NULL COMMENT '说明',

readperm tinyint(3) unsigned NOT NULL default '0' COMMENT '阅读权限', price smallint(6) unsigned NOT NULL default '0' COMMENT '附件价格', isimage tinyint(1) NOT NULL default '0' COMMENT '是否图片',

width smallint(6) unsigned NOT NULL default '0' COMMENT '附件宽度', thumb tinyint(1) unsigned NOT NULL default '0' COMMENT '是否是缩率图', picid mediumint(8) NOT NULL default '0' COMMENT '相册图片ID ', PRIMARY KEY (aid), KEY tid (tid), KEY pid (pid), KEY uid (uid)

) ENGINE=MyISAM COMMENT='附件表';

DROP TABLE IF EXISTS pre_forum_attachtype; CREATE TABLE pre_forum_attachtype (

id smallint(6) unsigned NOT NULL auto_increment COMMENT '类型id', fid mediumint(8) unsigned NOT NULL default '0' COMMENT '论坛id', extension char(12) NOT NULL default COMMENT '扩展名',

maxsize int(10) unsigned NOT NULL default '0' COMMENT '允许上传最大值', PRIMARY KEY (id), KEY fid (fid)

) ENGINE=MyISAM COMMENT='附件类型表';

DROP TABLE IF EXISTS pre_forum_bbcode; CREATE TABLE pre_forum_bbcode (

id mediumint(8) unsigned NOT NULL auto_increment COMMENT '代码id',

available tinyint(1) NOT NULL default '0' COMMENT '是否启用\\n(0:不启用 1:启用但不显示 2:启用并显示)',

tag varchar(100) NOT NULL default COMMENT '标签', icon varchar(255) NOT NULL COMMENT '图标', replacement text NOT NULL COMMENT '替换内容',

example varchar(255) NOT NULL default COMMENT '例子', explanation text NOT NULL COMMENT '解释说明',

params tinyint(1) unsigned NOT NULL default '1' COMMENT '参数个数', prompt text NOT NULL COMMENT '标签描述',

nest tinyint(3) unsigned NOT NULL default '1' COMMENT '嵌套层次', displayorder tinyint(3) NOT NULL default '0' COMMENT '显示顺序', perm text NOT NULL COMMENT '有权使用的用户组', PRIMARY KEY (id)

) ENGINE=MyISAM COMMENT='Discuz! 代码表';

DROP TABLE IF EXISTS pre_forum_creditslog; CREATE TABLE pre_forum_creditslog (

uid mediumint(8) unsigned NOT NULL default '0' COMMENT '会员id', fromto char(15) NOT NULL default COMMENT '来自/到',