Discuz X2.5 数据库字典官方压缩版

合集下载

相关主题

1、下载文档前请自行甄别文档内容的完整性，平台不提供额外的编辑、内容补充、找答案等附加服务。
2、"仅部分预览"的文档,不可在线预览部分如存在完整性等问题,可反馈申请退款(可完整预览的文档不适用该条件!)。
3、如文档侵犯您的权益，请联系客服反馈,我们会尽快为您处理(人工客服工作时间：9:00-18:30)。

-----pre_common_admingroup - 管理组表-----

admingid => '所属管理员分组ID'
alloweditpost => '是否允许编辑帖子'
alloweditpoll => '是否允许编辑投票'
allowstickthread => '是否允许置顶主题'
allowmodpost => '是否允许审核帖子'
allowdelpost => '是否允许删除帖子'
allowmassprune => '是否允许批量删帖'
allowrefund => '是否允许强制退款'
allowcensorword => '兼容性字段'
allowviewip => '是否允许查看IP'
allowbanip => '是否允许禁止IP'
allowedituser => '是否允许编辑用户'
allowmoduser => '是否允许审核用户'
allowbanuser => '是否允许禁止用户发言'
allowbanvisituser => '是否允许禁止用户访问'
allowpostannounce => '是否允许发布站点公告'
allowviewlog => '是否允许查看管理日志'
allowbanpost => '是否允许屏蔽帖子'
supe_allowpushthread => '兼容性字段'
allowhighlightthread => '是否允许高亮主题'
allowdigestthread => '是否允许精华主题'
allowrecommendthread => '是否允许推荐主题'
allowbumpthread => '是否允许提升主题'
allowclosethread => '是否允许关闭主题'
allowmovethread => '是否允许移动主题'
allowedittypethread => '是否允许编辑主题分类'
allowstampthread => '是否允许添加主题图章'
allowstamplist => '是否允许添加主题图标'
allowcopythread => '是否允许复制主题'
allowmergethread => '是否允许合并主题'
allowsplitthread => '是否允许分割主题'
allowrepairthread => '是否允许修复主题'
allowwarnpost => '是否允许警告帖子'
allowviewreport => '是否允许查看用户报告'
alloweditforum => '是否允许编辑版块'
allowremovereward => '是否允许移除悬赏'
allowedittrade => '是否允许编辑商品'
alloweditactivity => '是否允许管理活动报名者'
allowstickreply => '是否允许置顶回帖'
allowmanagearticle => '是否允许管理所有文章'
allowaddtopic => '是否允许创建专题'
allowmanagetopic => '是否允许管理专题'
allowdiy => '是否允许DIY'
allowclearrecycle => '是否允许删除回收站的帖子'
allowmanagetag => '是否允许管理标签'
alloweditusertag => '是否允许管理用户标签'
managefeed => '是否允许管理动态(feed)'
managedoing => '是否允许管理记录'
manageshare => '是否允许管理分享'
manageblog => '是否允许管理日志'
managealbum => '是否允许管理相册'
managecomment => '是否允许管理评论'
managemagiclog => '是否允许管理道具记录'
managereport => '是否允许管理举报'
managehotuser => '是否允许管理推荐成员'
managedefaultuser => '是否允许管理推荐好友'
managevideophoto => '是否允许管理视频认证'
managemagic => '是否允许管理道具'
manageclick => '是否允许管理表态动作'
allowmanagecollection => '是否允许管理淘专辑'

-----pre_common_adminnote - 后台留言表-----

id => '

后台留言id'
admin => '管理员姓名'
access => '哪组可以看到信息'
adminid => '管理员id'
dateline => '发表时间'
expiration => '过期时间'
message => '消息'

-----pre_common_advertisement - 广告数据表-----

advid => '广告id'
available => '是否启用'
type => '0' COMMENT '类型'
displayorder => '显示顺序'
title => '广告标题'
targets => '投放范围'
parameters text NOT NULL COMMENT '参数
序列化存放的数组数据',
code => '代码'
starttime => '开始时间'
endtime => '结束时间'

redits4 => '扩展4'
extcredits5 => '扩展5'
extcredits6 => '扩展6'
extcredits7 => '扩展7'
extcredits8 => '扩展8'
starttime => '周期开始时间'
dateline => '策略最后执行时间'

-----pre_common_credit_rule_log_field - 积分规则日志扩展表-----

clid => '策略日志ID'
uid => '策略日志所有者uid'
info => '记录信息防重'
user => '记录用户防重'
app => '记录应用防重'

-----pre_common_credit_rule - 积分规则表-----

rid => '规则ID'
rulename => '规则名称'
action => '规则action唯一KEY'
cycletype => '奖励周期0:一次;1:每天;2:整点;3:间隔分钟;4:不限;'
cycletime => '间隔时间'
rewardnum => '奖励次数'
norepeat => '是否去重1：去重;0：不去重'
extcredits1 => '扩展1'
extcredits2 => '扩展2'
extcredits3 => '扩展3'
extcredits4 => '扩展4'
extcredits5 => '扩展5'
extcredits6 => '扩展6'
extcredits7 => '扩展7'
extcredits8 => '扩展8'
fids => '记录自定义策略版块ID'

-----pre_common_cron - 计划任务表-----

cronid => '计划任务id'
available => '是否启用'
type => '类型'
name => '名称'
filename => '对应文件'
lastrun => '上次执行时间'
nextrun => '下次执行时间'
weekday => '周计划'
day => '0' COMMENT '日计划'
hour => '0' COMMENT '小时计划'
minute => '分计划'

-----pre_common_domain - 二级域名表-----

domain => '域名前缀'
domainroot => '二级域名后缀'
id => '对应对象id'
idtype => '对应对象类型subarea:分区、forum:版块、home:个人空间、group:群组、topic:专题、channel:频道'

-----pre_common_failedlogin - 失败登录表-----

ip => '失败IP'
username => '失败时的用户名'
count => '尝试次数'
lastupdate => '最后一次尝试时间'

-----pre_common_friendlink - 友情链接表-----

id => 'id'
displayorder => '显示顺序，正序'
name => '名称'
url => 'url'
description => '解释说明'
logo => 'logo'
type => '0'

-----pre_common_relatedlink - 关联链接表-----

id => 'id'
name => '名称'
url => 'url'
extent => '0'

-----pre_common_invite - 邀请表-----

id => 'ID'
uid => '邀请人'
code => '邀请码'
fuid => '受邀人UID'
fusername => '受邀人姓名'
type => '0' COMMENT '邮件邀请 1是0否'
email => '邀请Email'
inviteip => '邀请IP'
appid => '应用ID'
dateline => '邀请码生成时间'
endtime => '邀请码结束时间'
regdateline => '注册时间'
status => '1' COMMENT '邀请码状态'
orderid => '购买邀请码的订单号id'

-----pre_common_mailcron - 邮件计划任务表-----

touid => '对象UID'
email => '对象email地址'
sendtime => '发送时间'

-----pre_common_mailqueue - 邮件队列表-----

`subj

ect` => '邮件标题'
message => '邮件内容'
dateline => '添加时间'

-----pre_common_member - 用户主表-----

uid => '会员id'
email => '邮箱'
username => '用户名'
password => '密码'
status => '0' COMMENT '判断用户是否已经删除需要discuz程序加判断，并增加整体清理的功能。原home字段为flag'
emailstatus => 'email是否经过验证 home字段为emailcheck'
avatarstatus => '是否有头像 home字段为avatar'
videophotostatus => '视频认证状态 home'
adminid => '管理员id'
groupid => '会员组id'
groupexpiry => '用户组有效期'
extgroupids => '扩展用户组'
regdate => '注册时间'
credits => '总积分'
notifysound => '短信声音'
timeoffset => '时区校正'
newpm => '新短消息数量'
newprompt => '新提醒数目'
accessmasks => '标志'
allowadmincp => '标志'
onlyacceptfriendpm => '是否只接收好友短消息'
conisbind => '用户是否绑定QC'

-----pre_common_member_count - 用户统计表-----

uid => '会员id'
extcredits1 => '声望'
extcredits2 => '金钱'
extcredits3 => '扩展'
extcredits4 => '扩展'
extcredits5 => '扩展'
extcredits6 => '扩展'
extcredits7 => '扩展'
extcredits8 => '扩展'
friends => '好友个数 home'
posts => '帖子数'
threads => '主题数'
digestposts => '精华数'
doings => '记录数'
blogs => '日志数'
albums => '相册数'
sharings => '分享数'
attachsize => '上传附件占用的空间 home'
views => '空间查看数'
oltime => '在线时间'
todayattachs => '当天上传附件数'
todayattachsize => '当天上传附件容量'
feeds => '广播数'
follower => '听众数量'
following => '收听数量'
newfollower => '新增听众数量'

-----pre_common_member_field_forum - 用户论坛字段表-----

uid => '会员id'
publishfeed => '用户自定义发送哪些类型的feed(原字段为customaddfeed)'
customshow => '自定义帖子显示模式'
customstatus => '自定义头衔'
medals => '勋章信息'
sightml => '签名'
groupterms => '公共用户组'
authstr => '找回密码验证串'
groups => '用户所有群组'
attentiongroup => '用户偏好'

-----pre_common_member_field_home - 用户家园字段表-----

uid => '会员id'
videophoto => '视频认证照片地址 home'
spacename => '空间名称'
spacedescription => '空间简介'
domain => '空间绑定二级域名 home'
addsize => '额外授予的上传空间 home'
addfriend => '额外允许增加的好友数 home'
menunum => '应用显示个数'
theme => '空间风格主题 home'
spacecss => '个人空间自定义css home'
blockposition => '个人空间自定义模块位置及相关参数 home'
recentnote => '最近一次行为记录'
spacenote => '最近一次twitter'
privacy => 'home隐私设置(注意要和论坛发feed等开关的设置结合)'
feedfriend => '接受feed的好友缓

存'
acceptemail => '接受新通知邮件及设置邮件接收参数'
magicgift => '道具红包卡相关信息'
stickblogs => '置顶的日志ID'

-----pre_common_member_profile - 用户栏目表-----

uid => '会员id'
realname => '实名'
gender => '性别(0:保密 1:男 2:女)'
birthyear => '出生年'
birthmonth => '出生月'
birthday => '出生日'
constellation => '星座(根据生日自动计算)'
zodiac => '生肖(根据生日自动计算)'
telephone => '固定电话'
mobile => '手机'
idcardtype => '证件类型：身份证护照军官证等'
idcard => '证件号码'
address => '邮寄地址'
zipcode => '邮编'
nationality => '国籍'
birthprovince => '出生省份'
birthcity => '出生城市'
birthdist => '出生行政区/县'
birthcommunity => '出生小区'
resideprovince => '居住省份'
residecity => '居住城市'
residedist => '居住行政区/县'
residecommunity => '居住小区'
residesuite => '小区、写字楼门牌号'
graduateschool => '毕业学校'
company => ' 公司'
education => ' 学历'
occupation => ' 职业'
position => '职位'
revenue => ' 年收入'
affectivestatus => ' 情感状态'
lookingfor => ' 交友目的（交友类型）'
bloodtype => '血型'
height => ' 身高'
weight => ' 体重'
alipay => '支付宝帐号'
icq => 'ICQ'
qq => 'QQ'
yahoo => 'YAHOO'
msn => 'MSN'
taobao => '阿里旺旺'
site => '主页'
bio => '自我介绍来自论坛bio字段'
interest => '兴趣爱好'
field1 => '自定义字段1'
field2 => '自定义字段2'
field3 => '自定义字段3'
field4 => '自定义字段4'
field5 => '自定义字段5'
field6 => '自定义字段6'
field7 => '自定义字段7'
field8 => '自定义字段8'

-----pre_common_member_status - 用户状态表-----

uid => '会员id'
regip => '注册IP'
lastip => '最后登录IP'
lastvisit => '最后访问'
lastactivity => '最后活动'
lastpost => '最后发表'
lastsendmail => '上次发送email时间 home原字段为lastsend'
invisible => '是否隐身登录'
buyercredit => '买家信用等级及积分'
sellercredit => '卖家信用等级及积分'
favtimes => '个人空间收藏次数'
sharetimes => '个人空间分享次数'
profileprogress => '个人资料完成度'

-----pre_common_member_stat_field - 用户资料统计项-----

optionid => '资料统计项 id'
fieldid => '资料项字段标志符'
fieldvalue => '资料值'
hash => '由fieldid和fieldvalue生成的hash'
users => '对应用户数'
updatetime => '更新时间'

-----pre_common_member_action_log - 用户操作日志表-----

id => '记录id'
uid => '用户ID'
action => '0' COMMENT '操作代码'
dateline int(10) unsigned NOT NULL default '0',

-----pre_home_follow - 用户关注关系表-----

uid => '用户ID'
username => '用户名'
followuid => '被关注用户ID'
fusername

=> '被关注用户名称'
bkname => '用户备注'
status => '0' COMMENT '0:正常 1:特殊关注 -1:不能再关注此人'
mutual => '0:单向 1:已互相关注'
dateline int(10) unsigned NOT NULL default '0',

-----pre_home_follow_feed - 被关注者事件表-----

feedid => '自增id'
uid => '被关注者ID'
username => '被关注用户名'
tid => '帖子tid'
note => '转发理由'
dateline int(10) unsigned NOT NULL default '0',

-----pre_home_follow_feed_archiver - 被关注者事件存档-----

feedid => '自增id'
uid => '被关注者ID'
username => '被关注用户名'
tid => '帖子tid'
note => '转发理由'
dateline int(10) unsigned NOT NULL default '0',

-----pre_common_member_log - 漫游用户日志表-----

uid => '记录UID'
action => '记录动作'
dateline => '添加时间'

-----pre_common_member_verify - 用户认证表-----

uid => '会员id'
verify1 => '认证1: -1:被拒绝 0:待审核 1:审核通过'
verify2 => '认证2: -1:被拒绝 0:待审核 1:审核通过'
verify3 => '认证3: -1:被拒绝 0:待审核 1:审核通过'
verify4 => '认证4: -1:被拒绝 0:待审核 1:审核通过'
verify5 => '认证5: -1:被拒绝 0:待审核 1:审核通过'
verify6 => '实名认证: -1:被拒绝 0:待审核 1:审核通过'
verify7 => '视频认证: -1:被拒绝 0:待审核 1:审核通过'

-----pre_common_member_verify_info - 个人信息修改审核-----

vid => '审核id'
uid => '会员id'
username => '用户名'
verifytype => '审核类型0:资料审核, 1:认证1, 2:认证2, 3:认证3, 4:认证4, 5:认证5'
flag => '-1:被拒绝 0:待审核 1:审核通过'
field => '序列化存储变化值'
dateline => '提交日期'

-----pre_common_member_profile_setting - 个人信息扩展表-----

fieldid => 'profile字段标志符'
available => '是否可用'
invisible => '是否隐藏'
needverify => '是否需要审核'
title => '栏目标题'
description => '解释说明'
displayorder => '显示顺序'
required => '是否必填内容'
unchangeable => '不可修改'
showincard => '在名片中显示'
showinthread => '在帖子中显示'
showinregister => '是否在注册页面显示'
allowsearch => '是否可搜索'
formtype => '表单元素类型'
size => '内容最大长度'
choices => '选填内容'
validate => '验证数据的正则表达式'

-----pre_common_member_security - 个人信息修改审核-----

securityid => '审核项id'
uid => '会员id'
username => '用户名'
fieldid => 'profile字段标志符'
oldvalue => '旧的profile字段值'
newvalue => '新的profile字段值'
dateline => '提交日期'

-----pre_common_member_validate - 用户审核表-----

uid => '会员id'
submitdate => '提交日期'
moddate => '审核日期'
admin => '管理员名'
submittimes

=> '提交的次数'
status => '0' COMMENT '状态'
message => '注册原因'
remark => '管理员留言'

-----pre_common_member_crime - 用户惩罚操作表-----

cid => '自增id'
uid => '被惩罚操作的用户id'
operatorid => '进行惩罚操作的用户id'
operator => '进行惩罚操作的用户名'
action => '惩罚行为'
reason => '惩罚理由'
dateline => '惩罚操作时间'

-----pre_common_member_grouppm - 群发短消息用户记录表-----

uid => '会员id'
gpmid => '消息id'
status => '0=未读 1=已读 -1=删除'
dateline => '阅读时间'

-----pre_common_grouppm - 群发短消息表-----

id => '消息id'
authorid => '作者id'
author => '作者姓名'
dateline => '时间'
message => '消息'
numbers => '数量'

-----pre_common_myapp - 漫游应用表-----

appid => '应用id'
appname => '应用名称'
narrow => '是否显示为窄的profile box'
flag => '应用状态（黑白名单、默认应用等）'
version => '应用版本号'
userpanelarea => 'userabout显示区域、1主区、2、副区、3应用区'
canvastitle => 'canvas页面标题'
fullscreen => '是否是全屏应用'
displayuserpanel => '是否显示应用右侧的用户菜单'
displaymethod => '显示方式（iframe/myml）'
displayorder => '显示顺序'
appstatus => '标识应用1:新、2:热'
iconstatus => '应用图标是否已下载到本地。-1：失败；0：未下载；1：已下载'
icondowntime => '应用图标下载到本地时间'

-----pre_common_myinvite - 用户邀请表-----

id => '邀请id'
typename => '邀请名称'
appid => '应用id'
type => '0' COMMENT '类型(request 邀请/invite 请求)'
fromuid => '邀请者id'
touid => '接收者id'
myml => '邀请内容'
dateline => '发送邀请的时间戳'
hash => '0' COMMENT 'hash标记'

-----pre_common_nav - 自定义导航栏表-----

id => '项目id'
parentid => '父 id(navtype=0)'
name => '导航名称'
title => '导航说明'
url => '导航链接'
identifier => '链接标识/相关ID'
target => '目标框架(0:本窗口 1:新窗口)'
type => '0' COMMENT '类型 0 系统 1 自定义 3 插件 4 频道'
available => '是否可用'
displayorder => '显示顺序'
highlight => '样式(navtype=0)'
`level` => '使用等级(0:游客 1:会员 2:版主 3:管理员)'
subtype => '0' COMMENT '二级导航样式(navtype=0) 顶部导航位置(navtype=4)'
subcols => '0' COMMENT '横排一行显示的条目数(navtype=0)'
icon => '图标地址(navtype=1、3)'
subname => '副导航名称(navtype=1)'
suburl => '副导航地址(navtype=1)'
navtype =>'导航类型(0:主导航 1:底部导航 2:家园导航 3:快捷导航 4:顶部导航)'
logo => '自定义 Logo'

-----pre_common_onlinetime - 在线时间表-----

uid => 'UID'
thismonth => '本月在线时间'
total =>

'总在线时间'
lastupdate => '最后活动时间'

-----pre_common_regip - 注册IP限制表-----

ip => 'IP地址'
dateline => '限制时间'
count => '限制数量'

-----pre_common_secquestion - 验证问题数据表-----

id => '验证问题id'
type => '验证问题类型'
question => '验证问题'
answer => '问题答案'

-----pre_common_session - 站点在线活动表-----

sid => 'sid'
ip1 => 'IP段'
ip2 => 'IP段'
ip3 => 'IP段'
ip4 => 'IP段'
uid => '会员id'
username => '会员名'
groupid => '会员组'
invisible => '是否隐身登录'
action => '0' COMMENT '当前动作'
lastactivity => '最后活动时间'
lastolupdate => '在线时间最后更新'
fid => '论坛id'
tid => '主题id'

-----pre_common_setting - 设置表-----

skey => '变量名'
svalue => '值'

-----pre_common_smiley - 表情表-----

id => '表情id'
typeid => '表情分类 id'
displayorder => '显示顺序'
type => '类型'
code => '标记'
url => '路径'

-----pre_common_stat - 趋势统计-----

daytime => '时间'
login => '登陆'
mobilelogin => '手机登陆'
connectlogin => 'QQConnect登陆'
register => '注册'
invite => '邀请'
appinvite => '应用邀请'
doing => '记录'
blog => '日志'
pic => '图片'
poll => '投票'
activity => '活动'
share => '0' COMMENT '分享'
thread => '主题'
docomment => '记录评论'
blogcomment => '日志评论'
piccomment => '图片评论'
sharecomment => '分享评论'
reward => '悬赏'
debate => '辩论'
trade => '商品'
group => '0' COMMENT '群组'
groupjoin => '参与群组'
groupthread => '群组主题'
grouppost => '群组回复'
post => '主题回复'
wall => '留言'
poke => '打招呼'
click => '表态'
sendpm => '发送PM'
friend => '成为好友'
addfriend => '好友请求'

-----pre_common_statuser - 统计用户表-----

uid => 'UID'
daytime => '时间'
type => '各种用户行为如：invite、register、login...'

-----pre_common_style - 风格表-----

styleid => '风格id'
name => '风格名称'
available => '风格是否可用'
templateid => '对应模板id'
extstyle => '配色'

-----pre_common_stylevar - 风格变量表-----

stylevarid => '风格变量id'
styleid => '风格id'
variable => '变量名'
substitute => '变量赋值'

-----pre_common_syscache - 缓存数据表-----

cname => '缓存名称'
ctype => '缓存类型 0=value, serialize=1'
dateline => '缓存生成时间'
data => '缓存数据'

-----pre_common_template - 模板表-----

templateid => '模板id'
name => '名称'
directory => '目录'

copyright => '版权'

-----pre_common_usergroup - 用户组表-----

groupid => '会员

组id'
radminid => '关联关管理组'
type => '类型'
system => '会员是否可以自由进出'
grouptitle => '组头衔'
creditshigher => '该组的积分上限'
creditslower => '该组的积分下限'
stars => '星星数量'
color => '组头衔颜色'
icon varchar(255) NOT NULL default ,
allowvisit => '允许访问'
allowsendpm => '是否允许发送短信息'
allowinvite => '允许使用邀请注册'
allowmailinvite => '允许通过论坛邮件系统发送邀请码'
maxinvitenum => '最大邀请码拥有数量'
inviteprice => '邀请码购买价格'
maxinviteday => '邀请码有效期'

-----pre_common_usergroup_field - 会员用户组权限表-----

groupid => '会员组id'
readaccess => '阅读权限'
allowpost => '允许发帖'
allowreply => '允许回复'
allowpostpoll => '允许发表投票'
allowpostreward => '允许发表悬赏'
allowposttrade => '允许发表交易'
allowpostactivity => '允许发表活动'
allowdirectpost => '是否需要审核'
allowgetattach => '允许下载附件'
allowgetimage => '允许查看图片'
allowpostattach => '允许上传附件'
allowpostimage => '允许上传图片'
allowvote => '允许参与投票'
allowsearch => '允许搜索'
allowcstatus => '允许自定义头衔'
allowinvisible => '允许隐身登录'
allowtransfer => '允许积分转帐'
allowsetreadperm => '允许设置阅读权限'
allowsetattachperm => '允许设置附件权限'
allowposttag => '允许使用标签'
allowhidecode => '允许使用hide代码'
allowhtml => '允许使用html'
allowanonymous => '允许匿名发帖'
allowsigbbcode => '允许签名使用bbcode'
allowsigimgcode => '允许使用img'
allowmagics => '允许使用道具'
disableperiodctrl => '不受时间段限制'
reasonpm => '操作理由短信通知作者'
maxprice => '主题最大售价'
maxsigsize => '最大签名尺寸'
maxattachsize => '最大附件尺寸'
maxsizeperday => '每天最大附件总尺寸'
maxthreadsperhour => '每小时发主题数限制'
maxpostsperhour => '每小时发回帖数限制'
attachextensions => '允许发表的附件类型'
raterange => '评分范围'
mintradeprice => '交易最小积分'
maxtradeprice => '交易最大积分'
minrewardprice => '悬赏最小积分'
maxrewardprice => '悬赏最大积分'
magicsdiscount => '道具折扣'
maxmagicsweight => '道具负载最大值'
allowpostdebate => '允许发表辩论'
tradestick => '可商品推荐数'
exempt => '用户组表达式'
maxattachnum => '最大每天附件数量'
allowposturl => '是否允许发送含 url 内容'
allowrecommend => '是否允许评价主题'
allowpostrushreply => '允许发表抢楼帖'
maxfriendnum => '最多好友数'
maxspacesize => '空间大小'
allowcomment => '发表留言/评论'
allowcommentarticle => '发表文章的评论'
searchinterval => '两次搜索操作间隔'
searchignore => '是否免费搜索'
allowblog => '发表日志'
allowdoing => '发表

记录'
allowupload => '上传图片'
allowshare => '发布分享'
allowblogmod => '发表日志需要审核'
allowdoingmod => '发表记录需要审核'
allowuploadmod => '上传图片需要审核'
allowsharemod => '发布分享需要审核'
allowcss => '允许自定义CSS'
allowpoke => '允许打招呼'
allowfriend => '允许加好友'
allowclick => '允许表态'
allowmagic => '允许使用道具'
allowstat => '允许查看趋势统计'
allowstatdata => '允许查看统计数据报表'
videophotoignore => '视频认证限制'
allowviewvideophoto => '允许查看视频认证'
allowmyop => '允许使用应用'
magicdiscount => '购买道具折扣'
domainlength => '二级域名最短长度'
seccode => '发布操作需填验证码'
disablepostctrl => '发表是否受防灌水限制'
allowbuildgroup => '是否允许建立群组，0为不允许'
allowgroupdirectpost => '是否允许直接在群组中发帖'
allowgroupposturl => '是否允许在群组中发站外URL'
edittimelimit => '编辑帖子时间限制'
allowpostarticle => '允许发布文章'
allowdownlocalimg => '允许下载本地图片'
allowdownremoteimg => '允许下载远程图片'
allowpostarticlemod => '发布文章是否需要审核'
allowspacediyhtml => '允许自定义模块使用HTML'
allowspacediybbcode => '允许自定义模块使用BBCODE'
allowspacediyimgcode => '允许自定义模块使用[img]'
allowcommentpost => '允许帖子点评 0:禁止 1:楼主 2:回复 3:All'
allowcommentitem => '允许发表点评观点'
allowcommentreply => '允许发表回复点评'
allowreplycredit => '允许设置回帖奖励'
ignorecensor => '是否忽略要审核的关键字'
allowsendallpm => '是否不受“只接收好友短消息”设置的限制'
allowsendpmmaxnum => '24小时内允许发短消息的数量'
maximagesize => '相册中允许最大图片大小'
allowmediacode => '允许使用多媒体代码'
allowat => '允许@用户 0：禁止 n:发帖时@的数量'
allowsetpublishdate => '允许定时发布主题'
allowfollowcollection => '允许关注淘专辑数'
allowcommentcollection => '允许评论淘专辑'
allowcreatecollection => '允许创建淘专辑数'

-----pre_common_word - 词语过滤表-----

id => '词汇id'
admin => '管理员名'
type => '关键词分类'
find => '不良词语'
replacement => '替换内容'

-----pre_common_word_type - 词语过滤分类-----

id => '词语过滤分类id'
typename => '分类名称'

-----pre_common_tag - 标签表-----

tagid => '标签id'
tagname => '标签名'
status => '显示状态(0:正常 1:关闭 2:推荐 3:用户标签)'

-----pre_common_tagitem - 标签内容表-----

tagid => '标签id'
itemid => 'itemid'
idtype => '内容类型'

-----pre_forum_access - 访问权限表-----

uid => '会员id'
fid => '论坛id'
allowview => '允许浏览'

allowpost => '允许发表'
allowreply => '允许回复'
allowgetattach => '允许下载附件'
allowgetimage => '允许查看图片'
allowpostattach => '允许上传附件'
allowpostimage => '允许上传图片'
adminuser => '管理员id'
dateline => '时间'

-----pre_forum_activity - 活动表-----

tid => '主题id'
uid => '会员id'
aid => '主题图片id'
cost => '每人花销'
starttimefrom => '开始时间'
starttimeto => '结束时间'
place => '地点'
class => '类别'
gender => '性别'
number => '人数'
applynumber => '已参加人数'
expiration => '报名截止日期'
ufield => '用户定制项目'
credit => '需消耗的积分'

-----pre_forum_activityapply - 活动申请表-----

applyid => '申请id'
tid => '主题id'
username => '用户名'
uid => '会员id'
message => '消息'
verified => '是否审核通过(0:N 1:Y 2:需完善资料)'
dateline => '申请时间'
payment => '每人花销'
ufielddata => '用户定制项目数据'

-----pre_forum_announcement - 公告表-----

id => '公告id'
author => '作者姓名'
subject => '公告标题'
type => '公告类型(0:文字公告 1:网址链接)',
displayorder => '显示顺序'
starttime => '开始时间'
endtime => '结束时间'
message => '消息'
groups => '接受用户组'

-----pre_forum_threadimage - 主题图片表-----

tid => '0'
attachment => '服务器路径'
remote => '是否远程附件'

-----pre_forum_attachment - 附件索引表-----

aid => '附件id'
tid => '主题id'
pid => '帖子id'
uid => '会员id'
tableid => '附件表id'
downloads => '下载次数'

-----pre_forum_attachment_exif - Exif缓存表-----

aid => '附件id'
exif => 'exif信息'

-----pre_forum_attachment_unused - 未使用附件表-----

aid => '附件id'
uid => '会员id'
dateline => '上传时间'
filename => '原文件名'
filesize => '文件大小'
attachment => '服务器路径'
remote => '是否远程附件'
isimage => '是否图片'
width => '附件宽度'
thumb => '是否是缩率图'

-----pre_forum_attachment_0 - 附件表-----

aid => '附件id'
tid => '主题id'
pid => '帖子id'
uid => '会员id'
dateline => '上传时间'
filename => '原文件名'
filesize => '文件大小'
attachment => '服务器路径'
remote => '是否远程附件'
description => '说明'
readperm => '阅读权限'
price => '附件价格'
isimage => '是否图片'
width => '附件宽度'
thumb => '是否是缩率图'
picid => '相册图片ID '

-----pre_forum_attachment_1 - 附件表-----

aid => '附件id'
tid => '主题id'
pid => '帖子id'
uid => '会员id'
dateline => '上传时间'
filename => '原文件名'
filesize => '文件大小'
attachment => '服务器路径'
remote => '是否

远程附件'
description => '说明'
readperm => '阅读权限'
price => '附件价格'
isimage => '是否图片'
width => '附件宽度'
thumb => '是否是缩率图'
picid => '相册图片ID '

-----pre_forum_attachment_2 - 附件表-----

aid => '附件id'
tid => '主题id'
pid => '帖子id'
uid => '会员id'
dateline => '上传时间'
filename => '原文件名'
filesize => '文件大小'
attachment => '服务器路径'
remote => '是否远程附件'
description => '说明'
readperm => '阅读权限'
price => '附件价格'
isimage => '是否图片'
width => '附件宽度'
thumb => '是否是缩率图'
picid => '相册图片ID '

-----pre_forum_attachment_3 - 附件表-----

aid => '附件id'
tid => '主题id'
pid => '帖子id'
uid => '会员id'
dateline => '上传时间'
filename => '原文件名'
filesize => '文件大小'
attachment => '服务器路径'
remote => '是否远程附件'
description => '说明'
readperm => '阅读权限'
price => '附件价格'
isimage => '是否图片'
width => '附件宽度'
thumb => '是否是缩率图'
picid => '相册图片ID '

-----pre_forum_attachment_4 - 附件表-----

aid => '附件id'
tid => '主题id'
pid => '帖子id'
uid => '会员id'
dateline => '上传时间'
filename => '原文件名'
filesize => '文件大小'
attachment => '服务器路径'
remote => '是否远程附件'
description => '说明'
readperm => '阅读权限'
price => '附件价格'
isimage => '是否图片'
width => '附件宽度'
thumb => '是否是缩率图'
picid => '相册图片ID '

-----pre_forum_attachment_5 - 附件表-----

aid => '附件id'
tid => '主题id'
pid => '帖子id'
uid => '会员id'
dateline => '上传时间'
filename => '原文件名'
filesize => '文件大小'
attachment => '服务器路径'
remote => '是否远程附件'
description => '说明'
readperm => '阅读权限'
price => '附件价格'
isimage => '是否图片'
width => '附件宽度'
thumb => '是否是缩率图'
picid => '相册图片ID '

-----pre_forum_attachment_6 - 附件表-----

aid => '附件id'
tid => '主题id'
pid => '帖子id'
uid => '会员id'
dateline => '上传时间'
filename => '原文件名'
filesize => '文件大小'
attachment => '服务器路径'
remote => '是否远程附件'
description => '说明'
readperm => '阅读权限'
price => '附件价格'
isimage => '是否图片'
width => '附件宽度'
thumb => '是否是缩率图'
picid => '相册图片ID '

-----pre_forum_attachment_7 - 附件表-----

aid => '附件id'
tid => '主题id'
pid => '帖子id'
uid => '会员id'
dateline => '上传时间'
filename => '原文件名'
filesize => '文件大小'
attachment => '服务器路径'
remote => '是否远程附件'
description => '说明'
readperm => '阅读权限'
price => '

附件价格'
isimage => '是否图片'

width => '附件宽度'
thumb => '是否是缩率图'
picid => '相册图片ID '

-----pre_forum_attachment_8 - 附件表-----

aid => '附件id'
tid => '主题id'
pid => '帖子id'
uid => '会员id'
dateline => '上传时间'
filename => '原文件名'
filesize => '文件大小'
attachment => '服务器路径'
remote => '是否远程附件'
description => '说明'
readperm => '阅读权限'
price => '附件价格'
isimage => '是否图片'
width => '附件宽度'
thumb => '是否是缩率图'
picid => '相册图片ID '

-----pre_forum_attachment_9 - 附件表-----

aid => '附件id'
tid => '主题id'
pid => '帖子id'
uid => '会员id'
dateline => '上传时间'
filename => '原文件名'
filesize => '文件大小'
attachment => '服务器路径'
remote => '是否远程附件'
description => '说明'
readperm => '阅读权限'
price => '附件价格'
isimage => '是否图片'
width => '附件宽度'
thumb => '是否是缩率图'
picid => '相册图片ID '

-----pre_forum_attachtype - 附件类型表-----

id => '类型id'
fid => '论坛id'
extension => '扩展名'
maxsize => '允许上传最大值'

-----pre_forum_bbcode - Discuz! 代码表-----

id => '代码id'
available => '是否启用(0:不启用 1:启用但不显示 2:启用并显示)'
tag => '标签'
icon => '图标'
replacement => '替换内容'
example => '例子'
explanation => '解释说明'
params => '参数个数'
prompt => '标签描述'
nest => '嵌套层次'
displayorder => '显示顺序'
perm => '有权使用的用户组'

-----pre_forum_creditslog - 转帐记录表-----

uid => '会员id'
fromto => '来自/到'
sendcredits => '转出积分字段'
receivecredits => '接受积分字段'
send => '转出积分'
receive => '接受积分'
dateline => '转帐日期'
operation => '操作'

-----pre_forum_debate - 辩论主题表-----

tid => '主题id'
uid => '发起人id'
starttime => '开始时间'
endtime => '结束时间'
affirmdebaters => '正方辩论人数'
negadebaters => '反方辩论人数'
affirmvotes => '正方得票数'
negavotes => '反方得票数'
umpire => '裁判用户名'
winner => '获胜方(0:平局 1:为正方 2:为反方)裁判评判结果'
bestdebater => '最佳辩手用户名'
affirmpoint => '正方观点'
negapoint => '反方观点'
umpirepoint => '裁判观点，裁判结束辩论时填写'
affirmvoterids => '正方投票人的 id 集合'
negavoterids => '反方投票人的 id 集合'
affirmreplies => '正方回复次数，用来翻页'
negareplies => '反方回复次数，用来翻页'

-----pre_forum_debatepost - 辩论帖子表-----

pid => '帖子id'
stand => '立场(0:中立 1:正方 2:为反方)'
tid => '主题id'
uid => '发起人id'
dateline => '发

表的时间'
voters => '投票人数'
voterids => '投票人的 id 集合'

-----pre_forum_faq - 论坛帮助表-----

id => '帮助id'
fpid => '帮助父id'
displayorder => '排序'
identifier => '帮助标识'
keyword => '帮助关键词'
title => '帮助标题'
message => '帮助内容'

-----pre_forum_postcache - 论坛帖子缓存表-----

pid int(10) unsigned NOT NULL,
comment => '点评内容缓存'
rate => '评分情况缓存'
dateline => '缓存时间'

-----pre_home_favorite - 收藏表-----

favid => '收藏id'
uid => '会员id'
idtype => '收藏类型'
spaceuid => '空间会员id'
title => '标题'
description => '简介'
dateline => '时间'

-----pre_forum_forum - 版块表-----

fid => '论坛id'
fup => '上级论坛id'
type => '类型(group:分类 forum:普通论坛 sub:子论坛)'
name => '名称'
status => '显示状态(0:隐藏 1:正常 3:群组)'
displayorder => '显示顺序'
styleid => '风格id'
threads => '主题数量'
posts => '帖子数量'
todayposts => '今日发帖数量'
lastpost => '最后发表'
domain => '绑定的二级域名'
allowsmilies => '允许使用表情'
allowhtml => '允许使用html'
allowbbcode => '允许bbcode'
allowimgcode => '允许img'
allowmediacode => '允许使用多媒体代码'
allowanonymous => '允许匿名'
allowpostspecial => '允许发表特殊主题'
allowspecialonly => '只允许发表特殊主题'
allowappend => '是否开启帖子补充'
alloweditrules => '允许版主修改论坛规则'
allowfeed => '允许推送动态,默认推送广播'
allowside => '显示边栏'
recyclebin => '是否启用回收站'
modnewposts => '是否审核发帖'
jammer => '是否启用干扰码'
disablewatermark => '是否图片附件增加水印'
inheritedmod => '本论坛或分类版主的权力继承到下级论坛'
autoclose => '自动关闭主题'
forumcolumns => '增加论坛水平横排设置'
catforumcolumns => '增加分区版块水平横排设置'
threadcaches => '主题缓存功能设置'
alloweditpost => '允许编辑帖子'
simple => '0' COMMENT '只显示子版块'
modworks => '本版有待处理的管理事项'
allowglobalstick => '是否显示全局置顶'
level => '群组等级'
commoncredits => '群组公共积分'
archive => '0' COMMENT '是否有存档表'
recommend => '推荐到的版块'
favtimes => '版块或群组的收藏次数'
sharetimes => '版块或群组的分享次数'
disablethumb => '是否添加缩略图'
disablecollect => '禁止淘帖'

-----pre_forum_forumfield - 版块扩展表-----

fid => '版块id'
description => '解释说明'
password => '私密论坛密码'
icon => '图标'
redirect => 'URL转发'
attachextensions => '允许上传附件类型'
creditspolicy => '版块积分策略'
formulaperm => '版块权限表达式'
moderators => '版主列表，格式:admi

n'
rules => '版块规则'
threadtypes => '主题分类，序列化存放的设置，格式为一个数组'
threadsorts => '分类信息，序列化存放的设置，格式为一个数组'
viewperm => '阅读权限, 格式: 1 4 5'
postperm => '发表权限, 格式: 1 4 5'
replyperm => '回复权限, 格式: 1 4 5'
getattachperm => '下载附件权限, 格式: 1 4 5'
postattachperm => '上传附件权限, 格式: 1 4 5'
postimageperm => '上传图片权限, 格式: 1 4 5'
spviewperm => '不受限于版权权限表达式, 格式: 1 4 5'
seotitle => '版块seo标题'
keywords => '版块seo关键词'
seodescription => '版块seo描述'
supe_pushsetting => 'supe推送设置，序列化存放设置数据，格式为一个数组。'
modrecommend => '版主推荐规则'
threadplugin => '特殊主题插件数据'
jointype => '加入群组方式 -1为关闭，0为公开， 2邀请'
gviewperm => '群组浏览权限 0:仅成员 1:所有用户'
membernum => '群组成员数'
dateline => '群组创建时间'
lastupdate => '群组最后更新时间'
activity => '群组活跃度'
founderuid => '群组创始人UID'
foundername => '群组创始人名称'
banner => '群组头图片'
groupnum => '分类下的群组数量'
commentitem => ''
relatedgroup => ''
picstyle => '帖子列表是否以图片形式显示 0:否 1:是'
widthauto => '默认是否宽屏 0:全局 -1:宽屏 1:窄屏'

-----pre_forum_forum_threadtable - 版块存档信息-----

fid => '版块id'
threadtableid => 'thread分区id'
threads => '0' COMMENT '主题数'
posts => '0' COMMENT '帖子数'

-----pre_forum_forumrecommend - 版主推荐表-----

fid => '版块id'
tid => '帖子id'
typeid => '是否含有附件图片'
displayorder => '推荐顺序'
subject => '推荐主题标题'
author => '推荐主题作者'
authorid => '推荐主题作者id'
moderatorid => '推荐管理人员id'
expiration => '推荐主题有效期'
position => '显示位置'
highlight => '高亮颜色'
aid => '附件ID'
filename => '附件文件'

-----pre_forum_imagetype - 图片表情头像等分类-----

typeid => '分类id'
available => '是否启用'
name => '分类名称'
type => '分类类型(smiley:表情 icon:图标 avatar:头像)'
displayorder => '分类顺序'
directory => '图片目录'

-----pre_forum_medal - 勋章表-----

medalid => '勋章id'
name => '勋章名称'
available => '是否启用'
image => '勋章图片'
type => '0' COMMENT '勋章类型'
displayorder => '勋章显示顺序'
description => '勋章描述'
expiration => '勋章有效期'
permission => '勋章获得条件表达式'
credit => '0' COMMENT '勋章购买使用积分'
price => '0' COMMENT '勋章价格'

-----pre_forum_medallog - 勋章日志表-----

id => '记录id'
uid => '勋章拥有着用户id'
medalid => '勋章id'
type => '0' COMMENT '

勋章类型id'
dateline => '颁发时间id'
expiration => '有效期id'
status => '0' COMMENT '勋章状态id'

-----pre_common_member_magic - 用户道具数据表-----

uid => '用户uid'
magicid => '道具id'
num => '拥有数量'

-----pre_common_member_medal - 用户勋章数据表-----

uid => 'UID'
medalid => '勋章类型'

-----pre_forum_memberrecommend - 用户推荐表-----

tid => '主题ID'
recommenduid => '推荐会员ID'
dateline => '推荐时间'

-----pre_forum_moderator - 版主表-----

uid => '会员id'
fid => '论坛id'
displayorder => '显示顺序'
inherited => '是否继承'

-----pre_forum_modwork - 论坛管理统计表-----

uid => '会员id'
modaction => '动作'
dateline => '时间段'
count => '登录次数'
posts => '发表数'

-----pre_common_mytask - 我的任务表-----

uid => '用户Uid'
username => '用户名'
taskid => '任务id'
`status` => '任务状态(-1:失败 0:进行中 1:已完成)'
csc => '任务进度'
dateline => '申请任务时间'

-----pre_forum_onlinelist - 在线列表定制-----

groupid => '会员组id'
displayorder => '显示顺序'
title => '组名称'
url => '图例URL'

-----pre_forum_order - 订单信息表-----

orderid => '订单号id'
status => '状态'
buyer => '购买者姓名'
admin => '补单管理员姓名'
uid => '购买者id'
amount => '数量'
price => '价格'
submitdate => '提交日期'
confirmdate => '确认日期'
email => '购买时的Email'
ip => '购买时的IP'

-----pre_forum_groupfield - 群组扩展信息缓存-----

fid => '群组关联fid'
privacy => '群组隐私设置'
dateline => '缓存生成时间'
type => '缓存类型'
data => '缓存数据'

-----pre_forum_groupinvite - 群组邀请-----

fid => '群组id'
uid => '邀请人id'
inviteuid => '被邀请人id'
dateline => '邀请时间'

-----pre_forum_groupuser - 群组成员-----

fid => '群组关联fid'
uid => '成员id'
username => '成员名'
level => '成员等级(0:待审核 1:群主 2:副群主 3:明星成员 4:普通成员)'
threads => '成员主题数'
replies => '成员回复数'
joindateline => '成员加入群组时间'
lastupdate => '成员最后活动时间'
privacy => '成员隐私设置'

-----pre_common_plugin - 插件表-----

pluginid => '插件id'
available => '是否启用'
adminid => '管理员id'
name => '名称'
identifier => '唯一标识符'
description => '解释说明'
datatables => '插件数据表'
directory => '插件目录'
copyright => '版权信息'
modules => '插件信息'
version => '插件版本'

-----pre_common_pluginvar - 插件变量表-----

pluginvarid

=> '插件变量id'
pluginid => '插件id'
displayorder => '显示顺序'
title => '名称'
description => '解释说明'
variable => '变量名'
type => 'text' COMMENT '类型'
value => '值'
extra => '附加'

-----pre_forum_thread_moderate - 主题审核数据表-----

id => 'ID'
status => '状态 0 审核中，1 已忽略'
dateline => '0'

-----pre_forum_post_moderate - 帖子审核数据表-----

id => 'ID'
status => '状态 0 审核中，1 已忽略'
dateline => '0'

-----pre_home_blog_moderate - 日志审核数据表-----

id => 'ID'
status => '状态 0 审核中，1 已忽略'
dateline => '0'

-----pre_home_pic_moderate - 图片审核数据表-----

id => 'ID'
status => '状态 0 审核中，1 已忽略'
dateline => '0'

-----pre_home_doing_moderate - 记录审核数据表-----

id => 'ID'
status => '状态 0 审核中，1 已忽略'
dateline => '0'

-----pre_home_share_moderate - 分享审核数据表-----

id => 'ID'
status => '状态 0 审核中，1 已忽略'
dateline => '0'

-----pre_portal_article_moderate - 文章审核数据表-----

id => 'ID'
status => '状态 0 审核中，1 已忽略'
dateline => '0'

-----pre_home_comment_moderate - 家园评论审核数据表-----

id => 'ID'
idtype => 'ID类型'
status => '状态 0 审核中，1 已忽略'
dateline => '0'

-----pre_portal_comment_moderate - 文章/专题评论审核数据表-----

id => 'ID'
idtype => 'ID类型'
status => '状态 0 审核中，1 已忽略'
dateline => '0'

-----pre_forum_postlog - 漫游帖子日志-----

pid => '0'
tid => '0'
fid => '0'
uid => '0'
`action` char(10) NOT NULL DEFAULT ,
dateline => '0'

-----pre_forum_threadlog - 漫游主题日志-----

tid => '0'
fid => '0'
uid => '0'
otherid => '0'
`action` char(10) NOT NULL,
expiry => '0'
dateline => '0'

-----pre_forum_threadpreview - 服务于广播-----

tid => '主题ID'
relay => '转播次数'
content => '主题内容预览'

-----pre_forum_poll - 投票表-----

tid => '主题id'
overt => '是否公开投票参与人'
multiple => '是否多选'
visible => '是否投票后可见'
maxchoices => '最大可选项数'
expiration => '过期时间'
pollpreview => '选项内容前两项预览'
voters => '投票人数'

-----pre_forum_pollvoter - 投票用户表-----

tid => '主题id'
uid => '会员id'
username => '会员名'
options => '选项分隔'
dateline => '发表时间'

-----pre_forum_polloption - 投票选项表-----

polloptionid => '选项id'
tid => '主题id'
votes => '票数'
displayorder => '显示顺序'
polloption => '选项内容'

voterids => '投票人id'

-----pre_forum_post - 帖子表-----

pid => '帖子id'
fid => '论坛id'
tid => '主题id'
first => '0' COMMENT '是否是首贴'
author => '作者姓名'
authorid => '作者id'
subject => '标题'
dateline => '发表时间'
message => '消息'
useip => '发帖者IP'
invisible => '是否通过审核'
anonymous => '是否匿名'
usesig => '是否启用签名'
htmlon => '是否允许HTML'
bbcodeoff => '是否关闭BBCODE'
smileyoff => '是否关闭表情'
parseurloff => '是否允许粘贴URL'
attachment => '附件'
rate => '评分分数'
ratetimes => '评分次数'
status => '0' COMMENT '帖子状态'
tags => '新增字段，用于存放tag'
comment => '0' COMMENT '是否存在点评'
replycredit => '回帖获得积分记录'
position => '帖子位置信息'

-----pre_forum_postcomment - 点评帖子表-----

`id` => ''
tid => '0' COMMENT '主题ID'
pid => '0' COMMENT '帖子ID'
author => '作者'
authorid => '0' COMMENT '作者ID x1.5以后：0为游客　-1为观点'
dateline => '0' COMMENT '时间'
comment => '点评内容'
score => '0' COMMENT '是否包含点评观点'
useip => '发帖者IP'
rpid => '0' COMMENT '关联的帖子ID'

-----pre_forum_post_location - 帖子地理位置表-----

pid => '0'
tid => '0'
uid => '0'
mapx => ''
mapy => ''
location => ''

-----pre_forum_post_tableid - post分表协调表-----

pid => 'Post ID'

-----pre_forum_poststick - 回帖置顶表-----

tid => '所属主题TID'
pid => '回帖PID'
position => ''
dateline => '操作时间'

-----pre_forum_promotion - 论坛推广-----

ip => 'IP地址'
uid => '会员id'
username => '会员名'

-----pre_forum_ratelog - 帖子评分记录表-----

pid => '帖子id'
uid => '会员id'
username => '会员名'
extcredits => '评分字段'
dateline => '评分时间'
score => '分数'
reason => '操作理由'

-----pre_forum_relatedthread - 相关主题表-----

tid => '主题id'
type => '关键词类型'
expiration => '过期时间'
keywords => '关键字'
relatedthreads => '相关主题序列'

-----pre_forum_rsscache - rss缓存表-----

lastupdate => '最后更新时间'
fid => '论坛id'
tid => '主题id'
dateline => '发表时间'
forum => '论坛名称'
author => '作者'
subject => '标题'
description => '解释说明'
guidetype => '导读中的类型'

-----pre_forum_replycredit - 主题回帖获得积分规则表-----

tid => '主题tid'
extcredits => '单次回复奖励额度'
extcreditstype => '本规则下奖励积分的类型'
times => '回复奖励次数'
membertimes => '单个用户参与次数'
random => '用户设置的回帖奖励几率'

-----pre_common_searchindex - 搜索

缓存表-----

searchid => '缓存id'
srchmod => 'mod模块'
keywords => '关键字'
searchstring => '查找字符串'
useip => '搜索人IP'
uid => '会员id'
dateline => '搜索时间'
expiration => '过期时间'
threadsortid => '分类信息id'
num => '主题数量'
ids => '主题id序列'

-----pre_common_sphinxcounter - Sphinx 增量索引记录表-----

`indexid` tinyint(1) NOT NULL,
`maxid` int(10) NOT NULL,

-----pre_forum_spacecache - minispace缓存表-----

uid => '用户 uid'
variable => '缓存变量的名称'
value => '缓存变量的值'
expiration => '过期时间'

-----pre_forum_statlog - 版块统计日志表-----

logdate => '日志日期'
fid => '版块ID'
`type` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT '记录类型
value => '0' COMMENT '记录值'

-----pre_common_task - 论坛任务表-----

taskid => '任务id'
relatedtaskid smallint(6) unsigned NOT NULL default '0' COMMENT '依存任务id
必须完成依存任务才能申请该任务',
available => '是否启用'
name => '任务名称'
description => '任务描述'
icon => '任务图标'
applicants => '已申请任务人次'
achievers => '已完成任务人次'
tasklimits => '允许申请并完成该任务的人次上限'
applyperm => '允许申请任务的用户组id, 格式: 1 2 3'
scriptname => '任务脚本文件名'
starttime => '任务上线时间'
endtime => '任务下线时间'
period => '任务周期单位：小时默认为0表示一次性任务设置为24即1天表示日常任务'
periodtype => '任务间隔周期单位 0:小时 1:天 2:周 3:月'
reward => '奖励类型(credit:积分 magic:道具 medal:勋章 invite:邀请码 group:特殊用户组)'
prize => '奖品: 哪一个扩展积分, 道具id, 勋章id,邀请码有效期，特殊用户组id'
bonus int(10) NOT NULL default '0' COMMENT '奖品数量/有效期:
积分数量, 道具数量, 勋章有效期, 邀请码数量，特殊用户组有效期',
displayorder => '显示顺序'
version => '任务脚本版本号'

-----pre_common_taskvar - 论坛任务设置表-----

taskvarid => '任务变量id'
taskid => '任务id'
sort => '变量类别(apply:申请任务条件 complete:完成任务条件)'
name => '变量名称'
description => '变量描述'
variable => '变量名'
type => 'text' COMMENT '变量类型'
value => '变量值'

-----pre_forum_thread - 主题表-----

tid => '主题id'
fid => '上级论坛'
posttableid => '帖子表ID'
typeid => '主题分类id'
sortid => '分类信息id'
readperm => '阅读权限'
price => '价格'
author => '会员名'
authorid => '会员id'
subject => '标题'
dateline => '发表时间'
lastpost => '最后发表'
lastposter => '最后发表人id'
views => '浏览次数'
replies => '回复次数'
displayorder => '显示顺序'
highlight =>

'是否高亮'
digest => '是否精华'
rate => '是否评分'
special => '特殊主题,1:投票;2:商品;3:悬赏;4:活动;5:辩论贴;127:插件相关'
attachment => '附件,0无附件 1普通附件 2有图片附件'
moderated => '是否被管理员改动'
closed => '是否关闭'
stickreply => '是否有回帖置顶'
recommends => '推荐指数'
recommend_add => '支持人数'
recommend_sub => '反对人数'
heats => '主题热度值'
status smallint(6) unsigned NOT NULL default '0' ,
isgroup => '是否为群组帖子'
favtimes => '主题收藏次数'
sharetimes => '主题分享次数'
stamp => '-1' COMMENT '主题图章'
icon => '-1' COMMENT '主题图标'
pushedaid => '被推送到的文章aid'
cover => '主题封面负数:远程　正数:本地 0:无封面'
replycredit => '回帖奖励积分主题记录积分值'
relatebytag => '根据帖子标签取的相关主题id (time /t tid,...)'
maxposition => '最大回帖位置信息'

-----pre_forum_threadaddviews - 主题查看数延时更新表-----

tid => '主题id'
addviews => '浏览次数'

-----pre_forum_threaddisablepos - 主题有楼层不准确时不使用position查询-----

tid => '主题id'

-----pre_forum_threadclosed - 主题转移后保留的指向记录-----

tid => '对应源主题'
redirect => '保留的指向 tid'

-----pre_forum_threadmod - 主题管理记录表-----

tid => '主题id'
uid => '会员id'
username => '会员名'
dateline => '操作时间'
expiration => '有效时间'
action => '操作'
status => '0' COMMENT '状态'
magicid => '使用道具id'
stamp => '主题图章/图标 ID'
reason => '操作原因'

-----pre_forum_threadpartake - 主题参与者记录表-----

tid => '主题id'
uid => '会员id'
dateline => '参与时间'

-----pre_forum_threadrush - 抢楼设置表-----

tid => '主题id'
stopfloor => '截止楼层'
starttimefrom => '开始时间'
starttimeto => '结束时间'
rewardfloor => '奖励楼层'
creditlimit => '积分下限'

-----pre_forum_threadtype - 分类信息表-----

typeid => '分类信息id'
fid => '0'
displayorder => '显示顺序'
name => '名称'
description => '解释说明'
icon => '分类图标URL'
special => '分类状态'
modelid => '分类模型id'
expiration => '分类有效期'
template => '分类信息内容模板'
stemplate => '分类信息主题模板'
ptemplate => '分类信息发帖模板'
btemplate => '分类信息模块调用模板'

-----pre_forum_trade - 商品数据表-----

tid => '主题id'
pid => '帖子id'
typeid => '主题分类id'
sellerid => '卖家id'
seller => '卖家名'
account => '卖家帐号'
tenpayaccount => '卖家财付通账号'
subject => '标题'
price => '价格'
amount => '数量'
quality => '成色'
locus => '

Discuz X2.5 数据库字典 官方压缩版

Discuz X2.5 数据库字典官方压缩版