吉吉于

free

DiscuzX2.5数据库字典

pre_common_admincp_cmenu – 后台菜单收藏表

title => ‘菜单名称’

url => ‘菜单地址’

sort => ’0′ COMMENT ‘菜单类型,备用’

displayorder => ‘显示顺序’

clicks => ’1′ COMMENT ‘点击数,备用’

uid => ‘添加用户’

dateline => ‘添加时间’

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 => ‘结束时间’

pre_common_advertisement_custom – 自定义广告数据表

id => ‘自定义广告类型id’

name => ‘名称’

pre_common_banned – 禁止访问表

id => ‘禁止id’

ip1 => ‘IP分段1′

ip2 => ‘IP分段2′

ip3 => ‘IP分段3′

ip4 => ‘IP分段4′

admin => ‘管理员姓名’

dateline => ‘禁止时间’

expiration => ‘过期时间’

pre_common_cache – 通用缓存表

cachekey => ‘缓存名称’

cachevalue => ‘缓存数据’

dateline => ‘缓存时间’

pre_common_card – 充值卡密表

id => ‘生成的卡片号码’

typeid => ‘卡片分类’

maketype => ‘卡片生成的方法’

makeruid => ‘卡片生成者uid’

price => ’0′ COMMENT ‘卡片面值’

extcreditskey => ’0′ COMMENT ‘充值积分种类’

extcreditsval => ’0′ COMMENT ‘积分数额’

status => ’1′ COMMENT ‘卡片状态(位与):1:可用,2:已用’

dateline => ‘卡片生成时间’

cleardateline => ‘卡片清理时间’

useddateline => ‘使用时间’

uid => ‘使用者’

pre_common_card_log – 充值卡密表

id => ‘生成的卡片号码’

uid => ’0′ COMMENT ‘卡片生成者’

username => ‘卡片生成者’

cardrule => ‘卡片生成规则’

info => ‘卡片生成log’

dateline => ‘本次log生成时间’

description => ‘卡片描述’

operation => ‘操作动作(位与):1:生成,2:任务生成,4:删除,9:卡片过期’

pre_common_card_type – 卡片分类表

id => ‘卡片分类ID’

typename => ‘分类名称’

pre_common_credit_log – 积分日志表

uid => ‘所属用户uid’

operation => ‘操作类型’

relatedid => ‘操作相关ID’

dateline => ‘记录时间’

extcredits1 => ‘积分1变化值’

extcredits2 => ‘积分2变化值’

extcredits3 => ‘积分3变化值’

extcredits4 => ‘积分4变化值’

extcredits5 => ‘积分5变化值’

extcredits6 => ‘积分6变化值’

extcredits7 => ‘积分7变化值’

extcredits8 => ‘积分8变化值’

pre_common_credit_rule_log – 积分规则日志表

clid => ‘策略日志ID’

uid => ‘策略日志所有者uid’

rid => ‘策略ID’

fid => ‘版块ID’

total => ‘策略被执行总次数’

cyclenum => ‘周期被执行次数’

extcredits1 => ‘扩展1′

extcredits2 => ‘扩展2′

extcredits3 => ‘扩展3′

extcredits4 => ‘扩展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 – 邮件队列表

`subject` => ‘邮件标题’

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 => ‘点评内容缓存’ </p>

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 => ‘版主列表,格式:admin’

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 => ‘所在地’

transport => ‘物流方式’

ordinaryfee => ‘平邮附加费’

expressfee => ‘快递附加费’

emsfee => ‘EMS附加费’

itemtype => ‘商品类型’

dateline => ‘交易时间’

expiration => ‘过期时间’

lastbuyer => ‘最后买家用户名’

lastupdate => ‘最后交易时间’

totalitems => ‘总交易量’

tradesum => ‘总交易额’

closed => ‘是否关闭’

aid => ‘商品图片的 Aid’

displayorder => ‘显示顺序’

costprice => ‘商品原价’

credit => ‘积分价格’

costcredit => ‘积分原价’

credittradesum => ‘总积分交易额’

pre_forum_threadclass – 主题分类表

typeid => ‘分类ID’

fid => ‘所属版块ID’

name => ‘分类名称’

displayorder => ‘显示顺序’

icon => ‘分类图标URL’

moderators => ’0′ COMMENT ‘仅管理者可用’

pre_forum_tradecomment – 信用评价

id => ‘id’

orderid => ‘订单 id’

pid => ‘帖子 id’

type => ‘类型’

raterid => ‘评价方会员id’

rater => ‘评价方用户名’

rateeid => ‘被评价方会员id’

ratee => ‘被评价方用户名’

message => ‘评价内容’

explanation => ‘解释’

score => ‘评分’

dateline => ‘评价时间’

pre_forum_tradelog – 交易记录表

tid => ‘主题id’

pid => ‘帖子id’

orderid => ‘订单号id’

tradeno => ‘支付宝订单号’

paytype => ‘在线支付方式’

subject => ‘标题’

price => ‘价格’

quality => ‘成色’

itemtype => ‘商品类型’

number => ‘数量’

tax => ‘交易手续费’

locus => ‘物品所在地’

sellerid => ‘卖家id’

seller => ‘卖家名’

selleraccount => ‘卖家交易帐号’

tenpayaccount => ‘卖家财付通账号’

buyerid => ‘买家id’

buyer => ‘买家名’

buyercontact => ‘买家联系方式’

buyercredits => ‘买家暂扣积分’

buyermsg => ‘买家留言’

status => ’0′ COMMENT ‘状态’

lastupdate => ‘状态最后更新’

offline => ‘是否离线交易’

buyername => ‘买家姓名’

buyerzip => ‘买家邮编’

buyerphone => ‘买家电话’

buyermobile => ‘买家手机’

transport => ‘运输方式’

transportfee => ‘运输费用’

baseprice => ‘商品原价’

discount => ‘折扣’

ratestatus => ‘评价状态’

message => ‘订单留言’

credit => ‘积分价格’

basecredit => ‘积分原价’

pre_forum_typeoption – 分类信息设置项目表

optionid => ‘分类信息项目ID’

classid => ‘分类信息上级项目ID’

displayorder => ‘分类信息排序’

expiration => ‘分类信息项目是否受有效期限制’

protect => ‘分类信息项目是否是保护项目’

title => ‘分类信息项目标题’

description => ‘分类信息项目描述’

identifier => ‘分类信息项目标识’

type => ‘分类信息项目类型’

unit => ‘分类信息项目单位’

rules => ‘分类信息项目规则’

permprompt => ‘分类信息项目权限提示’

pre_forum_typeoptionvar – 分类信息项目数据表

sortid => ‘分类信息id’

tid => ‘分类信息数据对应帖子id’

fid => ‘分类信息数据对应帖子板块id’

optionid => ‘分类信息数据对应选项id’

expiration => ‘分类信息数据有效期’

value => ‘分类信息数据数值’

pre_forum_typevar – 分类信息对应项目表

sortid => ‘分类信息id’

optionid => ‘分类信息对应项目id’

available => ‘分类信息对应项目是否可用’

required => ‘分类信息对应项目是否必填’

unchangeable => ‘分类信息对应项目是否可修改’

search => ‘分类信息对应项目是否可搜索’

displayorder => ‘分类信息对应项目顺序’

subjectshow => ”

pre_forum_warning – 警告记录表

wid => ‘记录id’

pid => ‘帖子 pid’

operatorid => ‘警告者 Uid’

operator => ‘警告者用户名’

authorid => ‘被警告者 uid’

author => ‘被警告者用户名’

dateline => ‘警告时间’

reason => ‘警告原因’

pre_home_album – 相册表

albumid => ‘相册ID ‘

albumname => ‘相册名字’

catid => ‘相册系统分类’

uid => ‘相册用户ID ‘

username => ‘相册用户名’

dateline => ‘相册建立时间戳’

updatetime => ‘相册最后修改时间戳’

picnum => ‘相册照片数量’

pic => ‘相册封面照片’

picflag => ‘相册是否有图片’

friend => ‘相册隐私设置:”0″全站用户可见,”1″为全好友可见,”2″为仅指定的好友可见,”3″为仅自己可见,”4″为凭密码查看 ‘

password => ‘相册密码’

target_ids => ‘允许查看相册的用户ID,多个用户ID用”m”间隔 ‘

favtimes => ‘相册收藏次数’

sharetimes => ‘相册分享次数’

depict => ‘相册描述 ‘

pre_home_appcreditlog – 漫游应用积分操作记录表

logid => ‘序列id’

uid => ‘用户id’

appid => ‘用户名’

appname => ‘应用名称’

type => ’0′ COMMENT ‘积分转入转出类型’

credit => ‘积分数’

note => ‘备注’

dateline => ‘操作时间’

pre_home_blacklist – 屏蔽黑名单表

uid => ‘用户ID ‘

buid => ‘被屏蔽的用户ID ‘

dateline => ‘被屏蔽的时间戳’

pre_common_block – 模块表

bid => ‘模块ID’

blockclass => ‘模块分类 article/pic/member/board/poll’

blocktype => ‘调用类型 0为模板调用 1为js调用’

name => ‘模块标名称’

title => ‘模块标题名’

classname => ‘指定样式class’

summary => ‘模块自定义内容’

uid => ‘创建者用户ID ‘

username => ‘创建者用户名’

styleid => ‘模块风格ID’

blockstyle => ‘自定义风格’

picwidth => ‘显示图片长度’

picheight => ‘显示图片宽度’

target => ‘模块链接打开方式: _blank, _self, _top’

dateformat => ‘时间格式: H:i; u; Y-m-d等’

dateuformat => ‘是否使用个性化时间格式’

script => ‘模块获取数据脚本名’

param => ‘模块参数配置序列化存储’

shownum => ‘获取数据数目’

cachetime => ‘模块缓存更新时间间隔’

cachetimerange => ‘模块缓存更新时间区间’

punctualupdate => ‘是否严格按照缓存时间更新(忽略优化)’

hidedisplay => ‘是否屏蔽输出’

dateline => ‘模块缓存创建时间戳’

notinherited => ‘是否继承所在页面权限’

isblank => ‘是否为空白模块,只显示准送数据’

pre_common_block_style – 模块模板表

styleid => ‘模块样式ID’

blockclass => ‘模块分类’

name => ‘样式名称’

template => ‘样式模板’

hash => ‘样式hash(blockclass + template)’

getpic => ‘是否需要获取pic数据’

getsummary => ‘是否需要获取summary数据’

makethumb => ‘是否需要block设置缩略图’

settarget => ‘是否需要设置链接打开方式’

fields => ‘模板中用到的模块分类字段’

moreurl => ‘是否有更多链接’

pre_common_block_item – 模块数据表

itemid => ‘信息ID’

bid => ‘模块ID’

id => ‘来源ID’

idtype => ‘来源ID TYPE,手工添加数据为rand’

itemtype => ‘信息类型 0为自动 1为手工输入 2已编辑’

title => ‘信息标题名’

url => ‘信息链接地址’

pic => ‘信息图片’

picflag => ‘图片类型 0为url 1为本地 2 为ftp远程’

makethumb => ‘是否已生成缩略图 1:生成成功; 2:生成失败’

thumbpath => ‘缩略图地址’

summary => ‘信息摘要’

showstyle => ‘显示样式’

related => ‘相关链接’

fields => ‘信息附属num/author/authorid/dateline’

displayorder => ‘显示顺序’

startdate => ‘开始时间戳’

enddate => ‘结束时间戳’

pre_common_block_pic – 模块使用图片表

picid => ‘图片ID’

bid => ‘模块ID’

itemid => ‘信息ID’

pic => ‘信息图片’

picflag => ‘图片类型 0为本地 1为ftp远程’

type => ’0′ COMMENT ‘信息类型 0为模块缩略图 1为上传的图’

pre_common_block_item_data – 模块推荐信息表

dataid => ‘推荐信息ID’

bid => ‘模块ID’

id => ‘来源ID’

idtype => ‘来源ID TYPE’

itemtype => ‘信息类型 0为自动 1为手工输入 3推荐数据’

title => ‘信息标题名’

url => ‘信息链接地址’

pic => ‘信息图片’

picflag => ‘图片类型 0为url 1为本地 2 为ftp远程’

makethumb => ‘是否已生成缩略图’

summary => ‘信息摘要’

showstyle => ‘显示样式’

related => ‘相关链接’

fields => ‘信息附属num/author/authorid/dateline’

displayorder => ‘显示顺序’

startdate => ‘开始时间戳’

enddate => ‘结束时间戳’

uid => ‘推荐者 UID’

username => ‘推荐者用户名’

dateline => ‘推荐日期’

isverified => ‘是否已通过审核’

verifiedtime => ‘通过审核日期’

stickgrade => ‘置顶等级: 0~10′

pre_common_block_xml – 模块 XML 扩展类数据表

id => ‘ID’

name => ‘XML扩展 名称’

version => ‘XML扩展 版本’

url => ‘XML扩展 URL’

clientid => ‘客户端ID’

key => ‘通信密钥’

signtype => ‘签名的加密方式:目前只支持MD5方式,空为不使用签名,直接使用通信密钥’

data => ‘XML扩展 数据’

pre_common_block_favorite – 模块收藏表

favid => ‘收藏id’

uid => ‘会员id’

bid => ‘模块id’

dateline => ‘收藏时间’

pre_home_blog – 日志表

blogid => ‘日志ID’

uid => ‘日志所属用户ID ‘

username => ‘日志所属用户名’

subject => ‘日志标题’

classid => ‘个人分类id’

catid => ‘系统分类id’

viewnum => ‘日志查看数’

replynum => ‘日志回复数’

hot => ‘热度’

dateline => ‘日志发布时间’

picflag => ‘日志是否有图片’

noreply => ‘是否允许评论:”0″为允许,”1″为不允许 ‘

friend => ‘日志隐私设置:”0″为全站用户可见,”1″为全好友可见,”2″为仅指定的好友可见,”3″为仅自己可见,”4″为凭密码查看 ‘

password => ‘日志密码’

favtimes => ‘日志收藏次数’

sharetimes => ‘日志分享次数’

status => ’0′ COMMENT ‘blog状态 1-审核’

click1 => ‘表态1 id’

click2 => ‘表态2 id’

click3 => ‘表态3 id’

click4 => ‘表态4 id’

click5 => ‘表态5 id’

click6 => ‘表态6 id’

click7 => ‘表态7 id’

click8 => ‘表态8 id’

pre_home_blogfield – 日志字段表

blogid => ‘日志id’

uid => ‘日志所属用户ID ‘

pic => ‘标题图片’

tag => ‘日志TAG ‘

message => ‘日志内容’

postip => ‘发表日志的IP ‘

related => ‘相关日志的数据信息’

relatedtime => ‘相关日志产生时间戳’

target_ids => ‘允许查看日志的用户ID多个ID以”,”间隔 ‘

hotuser => ‘热点用户’

magiccolor => ‘道具彩色灯id’

magicpaper => ‘道具信纸id’

pushedaid => ‘被推送到的文章aid’

pre_home_class – 日志个人分类表

classid => ‘个人分类id’

classname => ‘分类名称’

uid => ‘分类所属用户ID ‘

dateline => ‘分类创建时间戳’

pre_home_click – 表态动作

clickid => ‘表态ID’

name => ‘表态名称’

icon => ‘表态图标’

idtype => ‘表态类型’

available => ‘是否有效’

displayorder => ‘排序’

pre_home_clickuser – 用户表态表

uid => ‘表态用户id’

username => ‘表态用户名’

id => ‘作用对象id’

idtype => ‘作用对象id类型’

clickid => ‘表态id’

dateline => ‘发表表态时间戳’

pre_home_comment – 用户评论表

cid => ‘评论id’

uid => ‘发表评论的用户id’

id => ‘评论对象id’

idtype => ‘评论对象的id类型:blogid,picid,uid’

authorid => ‘若为回复,回复作者用户ID ‘

author => ‘若为回复,回复作者用户名 ‘

ip => ‘评论IP ‘

dateline => ‘评论时间戳’

message => ‘评论内容’

magicflicker => ‘是否使用了道具彩虹炫’

status => ‘评论状态 1-审核’

pre_home_docomment – 用户记录回复表

id => ‘记录回复id’

upid => ‘上级记录回复id’

doid => ‘所评论的记录id’

uid => ‘发布记录者用户id’

username => ‘发布记录者用户名’

dateline => ‘记录回复时间戳’

message => ‘记录回复内容’

ip => ‘发布记录ip’

grade => ‘记录回复的层级’

pre_home_doing – 用户记录表

doid => ‘记录id’

uid => ‘记录发布者用户id’

username => ‘记录发布者用户名’

from => ‘记录的发表来源’

dateline => ‘记录发布时间戳’

message => ‘记录内容’

ip => ‘记录发布ip’

replynum => ‘记录回复数’

status => ‘记录状态 1-审核’

pre_home_feed – 站点feed表

feedid => ‘feed的ID ‘

appid => ‘应用程序ID ‘

icon => ‘feed图标 ‘

uid => ‘产生feed的用户ID ‘

username => ‘产生feed的用户名 ‘

dateline => ‘feed产生时间戳 ‘

friend => ‘产生feed信息的隐私设置 ‘

hash_template => ‘模板hash:md5(title_template” “body_template) ‘

hash_data => ‘数据内容hash:md5(title_templat” “title_data” “body_template” “body_data) ‘

title_template => ‘feed标题模板 ‘

title_data => ‘feed标题 ‘

body_template => ‘feed内容模板 ‘

body_data => ‘feed内容 ‘

body_general => ‘用户填写的信息 ‘

image_1 => ‘feed图1′

image_1_link => ‘feed图片链接1′

image_2 => ‘feed图片2′

image_2_link => ‘feed图片链接2′

image_3 => ‘feed图片3′

image_3_link => ‘feed图片链接3′

image_4 => ‘feed图片4′

image_4_link => ‘feed图片链接4′

target_ids => ‘产生feed信息允许查看的好友ID ‘

id => ‘feed对应对象id’

idtype => ‘feed对应对象类型’

hot => ‘热度’

pre_home_feed_app – 应该feed表

feedid => ‘应用feed id’

appid => ‘应用程序ID’

icon => ‘feed图标 ‘

uid => ‘产生feed的用户ID ‘

username => ‘产生feed的用户名 ‘

dateline => ‘feed产生时间戳 ‘

friend => ‘产生feed信息的隐私设置 ‘

hash_template => ‘模板hash:md5(title_template” “body_template) ‘

hash_data => ‘数据内容hash:md5(title_templat” “title_data” “body_template” “body_data) ‘

title_template => ‘feed标题模板 ‘

title_data => ‘feed标题 ‘

body_template => ‘feed内容模板 ‘

body_data => ‘feed内容 ‘

body_general => ‘用户填写的信息 ‘

image_1 => ‘feed图1′

image_1_link => ‘feed图片链接1′

image_2 => ‘feed图片2′

image_2_link => ‘feed图片链接2′

image_3 => ‘feed图片3′

image_3_link => ‘feed图片链接3′

image_4 => ‘feed图片4′

image_4_link => ‘feed图片链接4′

target_ids => ‘产生feed信息允许查看的好友ID ‘

pre_home_friend – 用户好友表

uid => ‘用户ID ‘

fuid => ‘用户好友ID ‘

fusername => ‘用户好友名’

gid => ‘好友所在的好友组ID ‘

num => ‘好友之间的任务关系数’

dateline => ‘加好友的时间戳’

note => ‘好友备注’

pre_home_friend_request – 申请好友表

uid => ‘用户ID ‘

fuid => ‘被请求用户ID ‘

fusername => ‘被请求用户名称’

gid => ‘好友所在的好友组ID ‘

note => ‘申请附言’

dateline => ‘请求好友时间戳’

pre_home_friendlog – 用户好友动作日志表

uid => ‘用户ID ‘

fuid => ‘好友用户ID ‘

action => ‘好友动作:”add”添加,”update”更新 ‘

dateline => ‘好友动作时间’

pre_common_magiclog – 道具日志表

uid => ‘用户id’

magicid => ‘道具id’

action => ‘操作动作 1 购买 2 使用 3 赠送’

dateline => ‘操作时间’

amount => ‘操作数量’

credit => ‘操作积分’

price => ‘操作价格’

targetid => ’0′

`idtype` char(6) DEFAULT NULL,
targetuid => ‘道具目标uid’

pre_common_magic – 道具数据表

magicid => ‘道具id’

available => ‘是否可用’

name => ‘名称’

identifier => ‘唯一标识’

description => ‘描述’

displayorder => ‘顺序’

credit => ‘使用的积分’

price => ‘价格’

num => ‘数量’

salevolume => ‘销售量’

supplytype => ‘自动补货类型’

supplynum => ‘自动补货数量’

useperoid => ‘使用周期’

usenum => ‘周期使用数量’

weight => ‘重量’

magicperm => ‘权限’

useevent => ’0:只在特定环境使用 1:可以在道具中心使用’

pre_home_notification – 通知表

id => ‘通知ID ‘

uid => ‘通知用户ID ‘

type => ‘通知类型:”doing”记录,”friend”好友请求,”sharenotice”好友分享,”post”话题回复, ‘

new => ’0′ COMMENT ‘通知是否为新:”1″为新通知,”0″为通知已读 ‘

authorid => ‘作者用户ID ‘

author => ‘用户名’

note => ‘通知内容’

dateline => ‘通知产生的时间戳’

from_id => ‘来源对象id’

from_idtype => ‘来源对象类型’

from_num => ‘来源量’

pre_home_pic – 家园图片表

picid => ‘图片ID ‘

albumid => ‘图片所属相册ID ‘

uid => ‘图片所属用户ID ‘

username => ‘图片所属用户名’

dateline => ‘图片上传时间戳’

postip => ‘图片上传ip’

filename => ‘图片文件名’

title => ‘图片标题’

type => ‘图片类型’

size => ‘图片大小’

filepath => ‘图片路径’

thumb => ‘是否有缩略图’

remote => ‘是否有远程图片0:home本地图片,1:home远程图片,2:论坛本地图片,3论坛远程图片’

hot => ‘热度’

sharetimes => ‘图片分享次数’

click1 => ‘表态1 id’

click2 => ‘表态2 id’

click3 => ‘表态3 id’

click4 => ‘表态4 id’

click5 => ‘表态5 id’

click6 => ‘表态6 id’

click7 => ‘表态7 id’

click8 => ‘表态8 id’

magicframe => ‘道具使用相框id’

status => ‘图片状态 1-审核’

pre_home_picfield – 家园图片拓展表

picid => ‘图片id’

hotuser => ‘图片对应热点用户’

pre_home_poke – 用户招呼表

uid => ‘接招呼的用户ID ‘

fromuid => ‘打招呼的用户ID ‘

fromusername => ‘打招呼的用户名 ‘

note => ‘招呼内容’

dateline => ‘打招呼时间戳’

iconid => ‘招呼图标’

pre_home_pokearchive – 用户招呼存档表

pid => ‘招呼历史id’

pokeuid => ‘uid + fromuid’

uid => ‘目标用户ID’

fromuid => ‘发起用户ID’

note => ‘招呼内容’

dateline => ‘招呼时间戳’

iconid => ‘招呼图标’

pre_home_share – 用户分享表

sid => ‘分享id’

itemid => ‘相关条目的ID’

type => ‘分享类型’

uid => ‘分享者用户id’

username => ‘分享者用户名’

fromuid => ‘被分享者用户ID’

dateline => ‘分享时间戳’

title_template => ‘分享标题模板’

body_template => ‘分享内容模板’

body_data => ‘分享内容数据’

body_general => ‘分享说明’

image => ‘分享的图片’

image_link => ‘分享的图片链接’

hot => ‘热度’

hotuser => ‘相关热点用户’

status => ‘分享条目状态 1-审核’

pre_home_show – 用户上榜表

uid => ‘我要上榜用户id’

username => ‘我要上榜用户名’

unitprice => ‘单次访问单价’

credit => ‘上榜总积分’

note => ‘上榜宣言’

pre_home_userapp – 用户使用应用表

uid => ‘使用应用的用户ID ‘

appid => ‘应用ID ‘

appname => ‘应用名’

privacy => ‘应用是否公开’

allowsidenav => ‘是否在开始菜单中显示’

allowfeed => ‘是否允许应用产生feed ‘

allowprofilelink => ‘时都允许在首页显示连接’

narrow => ‘是否在个人空间左边显示’

menuorder => ‘菜单顺序’

displayorder => ‘显示顺序’

pre_home_userappfield – 用户使用应用扩展表

uid => ‘使用应用的用户id’

appid => ‘应用id’

profilelink => ‘应用链接’

myml => ‘myml格式的首页显示信息’

pre_home_visitor – 空间访问日志表

uid => ‘受访者用户id’

vuid => ‘访问者用户id’

vusername => ‘访问者用户名’

dateline => ‘访问时间戳’

pre_portal_article_title – 门户文章标题表

aid => ‘文章ID’

catid => ‘栏目id’

bid => ‘模块id’

uid => ‘用户id’

username => ‘用户名’

title => ‘标题’

highlight => ‘标题样式’

author => ‘原作者’

from => ‘来源’

fromurl => ‘来源URL’

url => ‘访问URL’

summary => ‘摘要’

pic => ‘封面图片’

thumb => ‘封面图片是否缩略’

remote => ‘封面图片是否远程’

id => ‘来源ID’

idtype => ‘来源ID类型’

contents => ‘内容分页数’

allowcomment => ‘是否允许评论’

owncomment => ‘对于推送过来的文章:1,使用文章评论;0,同步原主题/日志的帖子/评论’

click1 => ‘表态1 id’

click2 => ‘表态2 id’

click3 => ‘表态3 id’

click4 => ‘表态4 id’

click5 => ‘表态5 id’

click6 => ‘表态6 id’

click7 => ‘表态7 id’

click8 => ‘表态8 id’

tag => ‘文章属性,共八位’

dateline => ‘添加时间’

status => ‘文章状态 0-已审核 1-需要审核 2-已忽略’

showinnernav => ‘是否显示分页导航’

pre_portal_article_content – 门户文章内容表

cid => ‘内容ID’

aid => ‘文章ID’

id => ‘来源ID’

idtype => ‘来源ID类型’

title => ‘标题’

content => ‘文章内容’

pageorder => ‘分页排序’

dateline => ‘添加时间’

pre_portal_article_count – 门户文章统计数据表

aid => ‘文章ID’

catid => ‘栏目id’

viewnum => ‘查看数’

commentnum => ‘评论数’

favtimes => ‘文章收藏次数’

sharetimes => ‘文章分享次数’

pre_portal_article_trash – 门户文章回收站表

aid => ‘垃圾文章ID’

content => ‘文章数据的seriallize存储’

pre_portal_comment – 门户评论表

cid => ‘评论id’

uid => ‘发表评论的用户id’

username => ‘发表评论的用户名’

id => ‘评论对象id’

idtype => ‘评论对象的id类型:aid,topicid’

postip => ‘评论IP ‘

dateline => ‘评论时间戳’

status => ‘评论状态 1-审核’

message => ‘评论内容’

pre_portal_rsscache – 文章rss缓存表

lastupdate => ‘最后更新时间’

catid => ‘文章分类id’

aid => ‘文章id’

dateline => ‘发表时间’

catname => ‘分类名称’

author => ‘作者’

subject => ‘标题’

description => ‘解释说明’

pre_portal_topic – 门户专题表

topicid => ‘专题ID’

title => ‘专题标题’

name => ‘静态化名称’

domain => ‘二级域名’

summary => ‘专题介绍’

keyword => ‘SEO 关键字’

cover => ‘专题封面’

picflag => ‘图片类型 0为url 1为本地 2 为ftp远程’

primaltplname => ‘原模板地址’

useheader => ‘是否使用网站导航内容’

usefooter => ‘是否使用网站尾部信息’

uid => ‘创建者UID’

username => ‘创建者用户名’

viewnum => ‘查看数’

dateline => ‘创建时间’

closed => ‘是否关闭状态’

allowcomment => ‘是否允许评论’

commentnum => ‘评论数’

pre_portal_topic_pic – 门户专题图片表

picid => ‘图片ID ‘

topicid => ‘图片所属专题ID ‘

uid => ‘图片所属用户ID ‘

username => ‘图片所属用户名’

dateline => ‘图片上传时间戳’

filename => ‘图片文件名’

title => ‘图片标题’

size => ‘图片大小’

filepath => ‘图片路径’

thumb => ‘是否有缩略图’

remote => ‘是否有远程图片’

pre_common_diy_data – DIY模板页面数据的存档表

targettplname => ‘目标模板文件名’

tpldirectory => ‘原模板所在目录’

primaltplname => ‘原模板文件名’

diycontent => ‘DIY的内容’

name => ‘目标模板页面名称’

uid => ‘会员id’

username => ‘用户名’

dateline => ‘更新时间’

pre_common_template_block – 模板页面和模块的关联表

targettplname => ‘目标模板文件名’

tpldirectory => ‘原模板所在目录’

bid => ‘模块ID’

pre_common_template_permission – DIY模板页面权限表

targettplname => ‘目标模板’

uid => ‘用户ID’

allowmanage => ‘允许管理’

allowrecommend => ‘允许推荐’

needverify => ‘推荐需要审核’

inheritedtplname => ‘继承自的模板名称’

pre_common_block_permission – 模块权限表

bid => ‘模块ID’

uid => ‘会员id’

allowmanage => ‘允许管理’

allowrecommend => ‘允许推荐’

needverify => ‘推荐需要审核’

inheritedtplname => ‘继承自的模板名称’

pre_portal_category_permission – 文章分类权限表

catid => ‘分类ID’

uid => ‘会员id’

allowpublish => ‘允许发布文章’

allowmanage => ‘允许管理文章’

inheritedcatid => ‘继承自的频道ID’

pre_portal_category – 门户 文章栏目表

catid => ‘栏目id’

upid => ‘上级栏目id’

catname => ‘标题’

articles => ‘文章数’

allowcomment => ‘是否允许评论’

displayorder => ‘显示顺序’

notinheritedarticle => ‘是否不继承上级文章管理权限’

notinheritedblock => ‘是否不继承上级DIY页面和模块权限’

domain => ‘二级域名’

url => ‘自定义链接’

uid => ‘创建者ID’

username => ‘创建者用户名’

dateline => ‘创建时间’

closed => ‘是否关闭’

shownav => ‘是否在导航显示’

description => ‘分类介绍 SEO描述’

seotitle => ‘SEO 标题’

keyword => ‘SEO 关键字’

primaltplname => ‘列表页原模板地址’

articleprimaltplname => ‘文章页原模板地址’

disallowpublish => ‘是否禁止发布文章’

foldername => ‘文件夹名称’

notshowarticlesummay => ‘文章内容页是否不显示摘要’

perpage => ‘列表每页显示文章数’

maxpages => ‘列表最大分页数’

pre_common_process – 进程锁管理

processid => ‘锁名称的md5′

expiry => ‘锁的过期时间’

extra => ‘锁的附属信息’

pre_common_admincp_group – 后台管理组

cpgroupid => ‘后台组id’

cpgroupname => ‘后台组名称’

pre_common_admincp_member – 后台管理成员

uid => ‘成员uid’

cpgroupid => ‘成员组id’

customperm => ‘自定义管理权限’

pre_common_admincp_perm – 后台权限表

cpgroupid => ‘后台组id’

perm => ‘后台组权限’

pre_common_admincp_session – 后台session表

uid => ‘用户id’

adminid => ‘管理组id’

panel => ‘面板位置’

ip => ‘IP’

dateline => ‘最后动作时间’

errorcount => ‘登录错误次数’

storage => ‘临时内容存储’

pre_portal_attachment – 门户文章附件表

attachid => ‘附件id’

uid => ‘会员id’

dateline => ‘上传时间’

filename => ‘原文件名’

filetype => ‘文件类型’

filesize => ‘文件大小’

attachment => ‘服务器路径’

isimage => ‘是否图片’

thumb => ‘是否是缩率图’

remote => ‘是否远程附件’

aid => ‘文章id’

pre_portal_article_related – 门户相关文章

aid => ‘文章ID’

raid => ‘相关文章ID’

displayorder => ‘显示顺序’

pre_home_specialuser – 特殊用户表

uid => ‘用户ID’

username => ‘用户名’

status => ‘用户类型0为推荐用户1为默认好友’

dateline => ‘设置时间’

reason => ‘操作原因’

opuid => ‘操作者用户ID’

opusername => ‘操作者用户名’

displayorder => ‘显示顺序’

pre_common_district – 地区表

id => ‘地区ID’

name => ‘地区名称’

level => ’0′ COMMENT ‘地区等级:1,省级;2,市级;3,县级;4,乡镇’

usetype => ‘使用对象:0:都不启用; 1:出生地; 2:居住地; 3:都启用’

upid => ‘上级地区ID’

displayorder => ‘显示顺序’

pre_forum_grouplevel – 群组等级表

levelid => ‘等级ID’

type => ‘类型’

leveltitle => ‘群组等级名称’

creditshigher => ‘该等级的积分上限’

creditslower => ‘该等级的积分下限’

icon => ‘等级图标’

creditspolicy => ‘积分策略’

postpolicy => ‘帖子策略’

specialswitch => ‘特殊开能开关’

pre_forum_groupcreditslog – 群组积分日志表

fid => ‘群组ID’

uid => ‘成员UID’

logdate => ‘日期/20100308′

pre_home_blog_category – 日志系统栏目

catid => ‘栏目id’

upid => ‘上级栏目id’

catname => ‘标题’

num => ‘日志数’

displayorder => ‘显示顺序’

pre_home_album_category – 相册系统栏目

catid => ‘栏目id’

upid => ‘上级栏目id’

catname => ‘标题’

num => ‘相册数’

displayorder => ‘显示顺序’

pre_common_report – 用户举报表

id => ‘记录id’

urlkey => ‘地址md5′

url => ‘地址’

message => ‘举报理由’

uid => ‘会员id’

username => ‘用户名’

dateline => ‘举报时间’

num => ‘举报次数’

opuid => ‘管理员id’

opname => ‘管理员姓名’

optime => ‘处理时间’

opresult => ‘对举报人的奖惩’

fid => ‘论坛id’

pre_common_patch – 漏洞补丁表

serial => ‘漏洞编号’

rule => ‘修补规则’

note => ‘漏洞说明’

status => ’0′ COMMENT ‘修补状态’

dateline => ‘漏洞发布时间’

pre_forum_collection – 淘帖专辑表

ctid => ‘专辑ID’

uid => ‘用户ID’

username => ‘用户名’

name => ‘专辑名’

dateline => ‘创建时间’

follownum => ‘订阅数’

threadnum => ‘主题数’

commentnum => ‘评论数’

desc => ‘简介’

lastupdate => ‘最后变动时间’

rate => ‘评分’

ratenum => ‘评分次数’

lastpost => ‘最后主题ID’

lastsubject => ‘最后主题标题’

lastposttime => ‘最后主题时间’

lastposter => ‘最后主题发帖者’

lastvisit => ‘创建者最后访问’

keyword => ‘专辑关键词’

pre_forum_collectioncomment – 淘帖评论表

cid => ‘评论ID’

ctid => ‘专辑ID’

uid => ‘用户ID’

username => ‘用户名’

message => ‘评论内容’

dateline => ‘评论时间’

useip => ‘IP地址’

rate => ‘评分’

pre_forum_collectionfollow – 淘帖关注表

uid => ‘用户ID’

username => ‘用户名’

ctid => ‘专辑ID’

dateline => ‘关注时间’

lastvisit => ‘最后访问专辑时间’

pre_forum_collectioninvite – 邀请管理淘专辑

ctid => ‘专辑ID’

uid => ‘邀请合作者ID’

dateline => ‘邀请时间’

pre_forum_collectionrelated – 淘帖主题被收入专辑表

tid => ‘主题ID’

collection => ‘专辑列表’

pre_forum_collectionteamworker – 淘帖合作编辑表

ctid => ‘专辑ID’

uid => ‘合作者ID’

name => ‘专辑名’

username => ‘用户名’

lastvisit => ‘最后访问专辑时间’

pre_forum_collectionthread – 淘帖包含主题表

ctid => ‘专辑ID’

tid => ‘专辑内主题ID’

dateline => ‘主题日期’

reason => ‘推荐理由’

转载请注明:于哲的博客 » DiscuzX2.5数据库字典