数据库文档

Clansday开发文档

1. 数据库设计

   参照discuz的数据库

2. pre_common_admincp_cmenu - 后台菜单收藏表

   title => '菜单名称'

   url => '菜单地址'

   sort => '0' COMMENT '菜单类型,备用'

   displayorder => '显示顺序'

   clicks => '1' COMMENT '点击数,备用'

   uid => '添加用户'

   dateline => '添加时间'

3. 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 => '是否允许管理淘专辑'

4. pre_common_adminnote - 后台留言表

   id => '后台留言id'

   admin => '管理员姓名'

   access => '哪组可以看到信息'

   adminid => '管理员id'

   dateline => '发表时间'

   expiration => '过期时间'

   message => '消息'

5. pre_common_advertisement - 广告数据表

   advid => '广告id'

   available => '是否启用'

   type => '0' COMMENT '类型'

   displayorder => '显示顺序'

   title => '广告标题'

   targets => '投放范围'

   parameters text NOT NULL COMMENT '参数 序列化存放的数组数据', code => '代码'

   starttime => '开始时间'

   endtime => '结束时间'

6. pre_common_advertisement_custom - 自定义广告数据表

   id => '自定义广告类型id'

   name => '名称'

7. pre_common_banned - 禁止访问表

   id => '禁止id'

   ip1 => 'IP分段1'

   ip2 => 'IP分段2'

   ip3 => 'IP分段3'

   ip4 => 'IP分段4'

   admin => '管理员姓名'

   dateline => '禁止时间'

   expiration => '过期时间'

8. pre_common_cache - 通用缓存表

   cachekey => '缓存名称'

   cachevalue => '缓存数据'

   dateline => '缓存时间'

9. 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 => '使用者'

10. pre_common_card_log - 充值卡密表

    id => '生成的卡片号码'

    uid => '0' COMMENT '卡片生成者'

    username => '卡片生成者'

    cardrule => '卡片生成规则'

    info => '卡片生成log'

    dateline => '本次log生成时间'

    description => '卡片描述'

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

11. pre_common_card_type - 卡片分类表

    id => '卡片分类ID'

    typename => '分类名称'

12. 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变化值'

13. 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 => '策略最后执行时间'

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

    clid => '策略日志ID'

    uid => '策略日志所有者uid'

    info => '记录信息防重'

    user => '记录用户防重'

    app => '记录应用防重'

15. 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'

16. pre_common_cron - 计划任务表

    cronid => '计划任务id'

    available => '是否启用'

    type => '类型'

    name => '名称'

    filename => '对应文件'

    lastrun => '上次执行时间'

    nextrun => '下次执行时间'

    weekday => '周计划'

    day => '0' COMMENT '日计划'

    hour => '0' COMMENT '小时计划'

    minute => '分计划'

17. pre_common_domain - 二级域名表

    domain => '域名前缀'

    domainroot => '二级域名后缀'

    id => '对应对象id'

    idtype => '对应对象类型subarea:分区、forum:版块、home:个人空间、group:群组、topic:专题、channel:频道'

18. pre_common_failedlogin - 失败登录表

    ip => '失败IP'

    username => '失败时的用户名'

    count => '尝试次数'

    lastupdate => '最后一次尝试时间'

19. pre_common_friendlink - 友情链接表

    id => 'id'

    displayorder => '显示顺序，正序'

    name => '名称'

    url => 'url'

    description => '解释说明'

    logo => 'logo'

    type => '0'

20. pre_common_relatedlink - 关联链接表

    id => 'id'

    name => '名称'

    url => 'url'

    extent => '0'

21. 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'

22. pre_common_mailcron - 邮件计划任务表

    touid => '对象UID'

    email => '对象email地址'

    sendtime => '发送时间'

23. pre_common_mailqueue - 邮件队列表

    `subject` => '邮件标题'

    message => '邮件内容'

    dateline => '添加时间'

24. 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'

25. 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 => '新增听众数量'

26. pre_common_member_field_forum - 用户论坛字段表

    uid => '会员id'

    publishfeed => '用户自定义发送哪些类型的feed(原字段为customaddfeed)'

    customshow => '自定义帖子显示模式'

    customstatus => '自定义头衔'

    medals => '勋章信息'

    sightml => '签名'

    groupterms => '公共用户组'

    authstr => '找回密码验证串'

    groups => '用户所有群组'

    attentiongroup => '用户偏好'

27. 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'

28. 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'

29. pre_common_member_status - 用户状态表

    uid => '会员id'

    regip => '注册IP'

    lastip => '最后登录IP'

    lastvisit => '最后访问'

    lastactivity => '最后活动'

    lastpost => '最后发表'

    lastsendmail => '上次发送email时间 home原字段为lastsend'

    invisible => '是否隐身登录'

    buyercredit => '买家信用等级及积分'

    sellercredit => '卖家信用等级及积分'

    favtimes => '个人空间收藏次数'

    sharetimes => '个人空间分享次数'

    profileprogress => '个人资料完成度'

30. pre_common_member_stat_field - 用户资料统计项

    optionid => '资料统计项 id'

    fieldid => '资料项字段标志符'

    fieldvalue => '资料值'

    hash => '由fieldid和fieldvalue生成的hash'

    users => '对应用户数'

    updatetime => '更新时间'

31. pre_common_member_action_log - 用户操作日志表

    id => '记录id'

    uid => '用户ID'

    action => '0' COMMENT '操作代码'

    dateline int(10) unsigned NOT NULL default '0',

32. 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',

33. pre_home_follow_feed - 被关注者事件表

    feedid => '自增id'

    uid => '被关注者ID'

    username => '被关注用户名'

    tid => '帖子tid'

    note => '转发理由'

    dateline int(10) unsigned NOT NULL default '0',

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

    feedid => '自增id'

    uid => '被关注者ID'

    username => '被关注用户名'

    tid => '帖子tid'

    note => '转发理由'

    dateline int(10) unsigned NOT NULL default '0',

35. pre_common_member_log - 漫游用户日志表

    uid => '记录UID'

    action => '记录动作'

    dateline => '添加时间'

36. 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:审核通过'

37. 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 => '提交日期'

38. pre_common_member_profile_setting - 个人信息扩展表

    fieldid => 'profile字段标志符'

    available => '是否可用'

    invisible => '是否隐藏'

    needverify => '是否需要审核'

    title => '栏目标题'

    description => '解释说明'

    displayorder => '显示顺序'

    required => '是否必填内容'

    unchangeable => '不可修改'

    showincard => '在名片中显示'

    showinthread => '在帖子中显示'

    showinregister => '是否在注册页面显示'

    allowsearch => '是否可搜索'

    formtype => '表单元素类型'

    size => '内容最大长度'

    choices => '选填内容'

    validate => '验证数据的正则表达式'

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

    securityid => '审核项id'

    uid => '会员id'

    username => '用户名'

    fieldid => 'profile字段标志符'

    oldvalue => '旧的profile字段值'

    newvalue => '新的profile字段值'

    dateline => '提交日期'

40. pre_common_member_validate - 用户审核表

    uid => '会员id'

    submitdate => '提交日期'

    moddate => '审核日期'

    admin => '管理员名'

    submittimes => '提交的次数'

    status => '0' COMMENT '状态'

    message => '注册原因'

    remark => '管理员留言'

41. pre_common_member_crime - 用户惩罚操作表

    cid => '自增id'

    uid => '被惩罚操作的用户id'

    operatorid => '进行惩罚操作的用户id'

    operator => '进行惩罚操作的用户名'

    action => '惩罚行为'

    reason => '惩罚理由'

    dateline => '惩罚操作时间'

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

    uid => '会员id'

    gpmid => '消息id'

    status => '0=未读 1=已读 -1=删除'

    dateline => '阅读时间'

43. pre_common_grouppm - 群发短消息表

    id => '消息id'

    authorid => '作者id'

    author => '作者姓名'

    dateline => '时间'

    message => '消息'

    numbers => '数量'

44. 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 => '应用图标下载到本地时间'

45. pre_common_myinvite - 用户邀请表

    id => '邀请id'

    typename => '邀请名称'

    appid => '应用id'

    type => '0' COMMENT '类型(request 邀请/invite 请求)'

    fromuid => '邀请者id'

    touid => '接收者id'

    myml => '邀请内容'

    dateline => '发送邀请的时间戳'

    hash => '0' COMMENT 'hash标记'

46. 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'

47. pre_common_onlinetime - 在线时间表

    uid => 'UID'

    thismonth => '本月在线时间'

    total => '总在线时间'

    lastupdate => '最后活动时间'

48. pre_common_regip - 注册IP限制表

    ip => 'IP地址'

    dateline => '限制时间'

    count => '限制数量'

49. pre_common_secquestion - 验证问题数据表

    id => '验证问题id'

    type => '验证问题类型'

    question => '验证问题'

    answer => '问题答案'

50. 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'

51. pre_common_setting - 设置表

    skey => '变量名'

    svalue => '值'

52. pre_common_smiley - 表情表

    id => '表情id'

    typeid => '表情分类 id'

    displayorder => '显示顺序'

    type => '类型'

    code => '标记'

    url => '路径'

53. 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 => '好友请求'

54. pre_common_statuser - 统计用户表

    uid => 'UID'

    daytime => '时间'

    type => '各种用户行为如：invite、register、login...'

55. pre_common_style - 风格表

    styleid => '风格id'

    name => '风格名称'

    available => '风格是否可用'

    templateid => '对应模板id'

    extstyle => '配色'

56. pre_common_stylevar - 风格变量表

    stylevarid => '风格变量id'

    styleid => '风格id'

    variable => '变量名'

    substitute => '变量赋值'

57. pre_common_syscache - 缓存数据表

    cname => '缓存名称'

    ctype => '缓存类型 0=value, serialize=1'

    dateline => '缓存生成时间'

    data => '缓存数据'

58. pre_common_template - 模板表

    templateid => '模板id'

    name => '名称'

    directory => '目录'

    copyright => '版权'

59. 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 => '邀请码有效期'

60. 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 => '替换内容'

61. pre_common_word_type - 词语过滤分类

    id => '词语过滤分类id'

    typename => '分类名称'

62. pre_common_tag - 标签表

    tagid => '标签id'

    tagname => '标签名'

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

63. pre_common_tagitem - 标签内容表

    tagid => '标签id'

    itemid => 'itemid'

    idtype => '内容类型'

64. pre_forum_access - 访问权限表

    uid => '会员id'

    fid => '论坛id'

    allowview => '允许浏览'

    allowpost => '允许发表'

    allowreply => '允许回复'

    allowgetattach => '允许下载附件'

    allowgetimage => '允许查看图片'

    allowpostattach => '允许上传附件'

    allowpostimage => '允许上传图片'

    adminuser => '管理员id'

    dateline => '时间'

65. pre_forum_activity - 活动表

    tid => '主题id'

    uid => '会员id'

    aid => '主题图片id'

    cost => '每人花销'

    starttimefrom => '开始时间'

    starttimeto => '结束时间'

    place => '地点'

    class => '类别'

    gender => '性别'

    number => '人数'

    applynumber => '已参加人数'

    expiration => '报名截止日期'

    ufield => '用户定制项目'

    credit => '需消耗的积分'

66. pre_forum_activityapply - 活动申请表

    applyid => '申请id'

    tid => '主题id'

    username => '用户名'

    uid => '会员id'

    message => '消息'

    verified => '是否审核通过(0:N 1:Y 2:需完善资料)'

    dateline => '申请时间'

    payment => '每人花销'

    ufielddata => '用户定制项目数据'

67. pre_forum_announcement - 公告表

    id => '公告id'

    author => '作者姓名'

    subject => '公告标题'

    type => '公告类型(0:文字公告 1:网址链接)',

    displayorder => '显示顺序'

    starttime => '开始时间'

    endtime => '结束时间'

    message => '消息'

    groups => '接受用户组'

68. pre_forum_threadimage - 主题图片表

    tid => '0'

    attachment => '服务器路径'

    remote => '是否远程附件'

69. pre_forum_attachment - 附件索引表

    aid => '附件id'

    tid => '主题id'

    pid => '帖子id'

    uid => '会员id'

    tableid => '附件表id'

    downloads => '下载次数'

70. pre_forum_attachment_exif - Exif缓存表

    aid => '附件id'

    exif => 'exif信息'

71. pre_forum_attachment_unused - 未使用附件表

    aid => '附件id'

    uid => '会员id'

    dateline => '上传时间'

    filename => '原文件名'

    filesize => '文件大小'

    attachment => '服务器路径'

    remote => '是否远程附件'

    isimage => '是否图片'

    width => '附件宽度'

    thumb => '是否是缩率图'

72. 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 '

73. 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 '

74. 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 '

75. 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 '

76. 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 '

77. 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 '

78. 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 '

79. 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 '

80. 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 '

81. pre_forum_attachtype - 附件类型表

    id => '类型id'

    fid => '论坛id'

    extension => '扩展名'

    maxsize => '允许上传最大值'

82. pre_forum_bbcode - Discuz! 代码表

    id => '代码id'

    available => '是否启用(0:不启用 1:启用但不显示 2:启用并显示)'

    tag => '标签'

    icon => '图标'

    replacement => '替换内容'

    example => '例子'

    explanation => '解释说明'

    params => '参数个数'

    prompt => '标签描述'

    nest => '嵌套层次'

    displayorder => '显示顺序'

    perm => '有权使用的用户组'

83. pre_forum_creditslog - 转帐记录表

    uid => '会员id'

    fromto => '来自/到'

    sendcredits => '转出积分字段'

    receivecredits => '接受积分字段'

    send => '转出积分'

    receive => '接受积分'

    dateline => '转帐日期'

    operation => '操作'

84. 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 => '反方回复次数，用来翻页'

85. pre_forum_debatepost - 辩论帖子表

    pid => '帖子id'

    stand => '立场(0:中立 1:正方 2:为反方)'

    tid => '主题id'

    uid => '发起人id'

    dateline => '发表的时间'

    voters => '投票人数'

    voterids => '投票人的 id 集合'

86. pre_forum_faq - 论坛帮助表

    id => '帮助id'

    fpid => '帮助父id'

    displayorder => '排序'

    identifier => '帮助标识'

    keyword => '帮助关键词'

    title => '帮助标题'

    message => '帮助内容'

87. pre_forum_postcache - 论坛帖子缓存表

    pid int(10) unsigned NOT NULL, comment => '点评内容缓存'

    rate => '评分情况缓存'

    dateline => '缓存时间'

88. pre_home_favorite - 收藏表

    favid => '收藏id'

    uid => '会员id'

    idtype => '收藏类型'

    spaceuid => '空间会员id'

    title => '标题'

    description => '简介'

    dateline => '时间'

89. 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 => '禁止淘帖'

90. 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:窄屏'

91. pre_forum_forum_threadtable - 版块存档信息

    fid => '版块id'

    threadtableid => 'thread分区id'

    threads => '0' COMMENT '主题数'

    posts => '0' COMMENT '帖子数'

92. pre_forum_forumrecommend - 版主推荐表

    fid => '版块id'

    tid => '帖子id'

    typeid => '是否含有附件图片'

    displayorder => '推荐顺序'

    subject => '推荐主题标题'

    author => '推荐主题作者'

    authorid => '推荐主题作者id'

    moderatorid => '推荐管理人员id'

    expiration => '推荐主题有效期'

    position => '显示位置'

    highlight => '高亮颜色'

    aid => '附件ID'

    filename => '附件文件'

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

    typeid => '分类id'

    available => '是否启用'

    name => '分类名称'

    type => '分类类型(smiley:表情 icon:图标 avatar:头像)'

    displayorder => '分类顺序'

    directory => '图片目录'

94. pre_forum_medal - 勋章表

    medalid => '勋章id'

    name => '勋章名称'

    available => '是否启用'

    image => '勋章图片'

    type => '0' COMMENT '勋章类型'

    displayorder => '勋章显示顺序'

    description => '勋章描述'

    expiration => '勋章有效期'

    permission => '勋章获得条件表达式'

    credit => '0' COMMENT '勋章购买使用积分'

    price => '0' COMMENT '勋章价格'

95. pre_forum_medallog - 勋章日志表

    id => '记录id'

    uid => '勋章拥有着用户id'

    medalid => '勋章id'

    type => '0' COMMENT '勋章类型id'

    dateline => '颁发时间id'

    expiration => '有效期id'

    status => '0' COMMENT '勋章状态id'

96. pre_common_member_magic - 用户道具数据表

    uid => '用户uid'

    magicid => '道具id'

    num => '拥有数量'

97. pre_common_member_medal - 用户勋章数据表

    uid => 'UID'

    medalid => '勋章类型'

98. pre_forum_memberrecommend - 用户推荐表

    tid => '主题ID'

    recommenduid => '推荐会员ID'

    dateline => '推荐时间'

99. pre_forum_moderator - 版主表

    uid => '会员id'

    fid => '论坛id'

    displayorder => '显示顺序'

    inherited => '是否继承'

100. pre_forum_modwork - 论坛管理统计表

     uid => '会员id'

     modaction => '动作'

     dateline => '时间段'

     count => '登录次数'

     posts => '发表数'

101. pre_common_mytask - 我的任务表

     uid => '用户Uid'

     username => '用户名'

     taskid => '任务id'

     `status` => '任务状态(-1:失败 0:进行中 1:已完成)'

     csc => '任务进度'

     dateline => '申请任务时间'

102. pre_forum_onlinelist - 在线列表定制

     groupid => '会员组id'

     displayorder => '显示顺序'

     title => '组名称'

     url => '图例URL'

103. pre_forum_order - 订单信息表

     orderid => '订单号id'

     status => '状态'

     buyer => '购买者姓名'

     admin => '补单管理员姓名'

     uid => '购买者id'

     amount => '数量'

     price => '价格'

     submitdate => '提交日期'

     confirmdate => '确认日期'

     email => '购买时的Email'

     ip => '购买时的IP'

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

     fid => '群组关联fid'

     privacy => '群组隐私设置'

     dateline => '缓存生成时间'

     type => '缓存类型'

     data => '缓存数据'

105. pre_forum_groupinvite - 群组邀请

     fid => '群组id'

     uid => '邀请人id'

     inviteuid => '被邀请人id'

     dateline => '邀请时间'

106. pre_forum_groupuser - 群组成员

     fid => '群组关联fid'

     uid => '成员id'

     username => '成员名'

     level => '成员等级(0:待审核 1:群主 2:副群主 3:明星成员 4:普通成员)'

     threads => '成员主题数'

     replies => '成员回复数'

     joindateline => '成员加入群组时间'

     lastupdate => '成员最后活动时间'

     privacy => '成员隐私设置'

107. pre_common_plugin - 插件表

     pluginid => '插件id'

     available => '是否启用'

     adminid => '管理员id'

     name => '名称'

     identifier => '唯一标识符'

     description => '解释说明'

     datatables => '插件数据表'

     directory => '插件目录'

     copyright => '版权信息'

     modules => '插件信息'

     version => '插件版本'

108. pre_common_pluginvar - 插件变量表

     pluginvarid => '插件变量id'

     pluginid => '插件id'

     displayorder => '显示顺序'

     title => '名称'

     description => '解释说明'

     variable => '变量名'

     type => 'text' COMMENT '类型'

     value => '值'

     extra => '附加'

109. pre_forum_thread_moderate - 主题审核数据表

     id => 'ID'

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

     dateline => '0'

110. pre_forum_post_moderate - 帖子审核数据表

     id => 'ID'

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

     dateline => '0'

111. pre_home_blog_moderate - 日志审核数据表

     id => 'ID'

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

     dateline => '0'

112. pre_home_pic_moderate - 图片审核数据表

     id => 'ID'

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

     dateline => '0'

113. pre_home_doing_moderate - 记录审核数据表

     id => 'ID'

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

     dateline => '0'

114. pre_home_share_moderate - 分享审核数据表

     id => 'ID'

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

     dateline => '0'

115. pre_portal_article_moderate - 文章审核数据表

     id => 'ID'

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

     dateline => '0'

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

     id => 'ID'

     idtype => 'ID类型'

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

     dateline => '0'

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

     id => 'ID'

     idtype => 'ID类型'

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

     dateline => '0'

118. pre_forum_postlog - 漫游帖子日志

     pid => '0'

     tid => '0'

     fid => '0'

     uid => '0'

     `action` char(10) NOT NULL DEFAULT , dateline => '0'

119. pre_forum_threadlog - 漫游主题日志

     tid => '0'

     fid => '0'

     uid => '0'

     otherid => '0'

     `action` char(10) NOT NULL, expiry => '0'

     dateline => '0'

120. pre_forum_threadpreview - 服务于广播

     tid => '主题ID'

     relay => '转播次数'

     content => '主题内容预览'

     pre_forum_poll - 投票表

     tid => '主题id'

     overt => '是否公开投票参与人'

     multiple => '是否多选'

     visible => '是否投票后可见'

     maxchoices => '最大可选项数'

     expiration => '过期时间'

     pollpreview => '选项内容前两项预览'

     voters => '投票人数'

121. pre_forum_pollvoter - 投票用户表

     tid => '主题id'

     uid => '会员id'

     username => '会员名'

     options => '选项 分隔'

     dateline => '发表时间'

122. pre_forum_polloption - 投票选项表

     polloptionid => '选项id'

     tid => '主题id'

     votes => '票数'

     displayorder => '显示顺序'

     polloption => '选项内容'

     voterids => '投票人id'

123. 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 => '帖子位置信息'

124. 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'

125. pre_forum_post_location - 帖子地理位置表

     pid => '0'

     tid => '0'

     uid => '0'

     mapx => ''

     mapy => ''

     location => ''

126. pre_forum_post_tableid - post分表协调表

     pid => 'Post ID'

127. pre_forum_poststick - 回帖置顶表

     tid => '所属主题TID'

     pid => '回帖PID'

     position => ''

     dateline => '操作时间'

128. pre_forum_promotion - 论坛推广

     ip => 'IP地址'

     uid => '会员id'

     username => '会员名'

129. pre_forum_ratelog - 帖子评分记录表

     pid => '帖子id'

     uid => '会员id'

     username => '会员名'

     extcredits => '评分字段'

     dateline => '评分时间'

     score => '分数'

     reason => '操作理由'

130. pre_forum_relatedthread - 相关主题表

     tid => '主题id'

     type => '关键词类型'

     expiration => '过期时间'

     keywords => '关键字'

     relatedthreads => '相关主题序列'

131. pre_forum_rsscache - rss缓存表

     lastupdate => '最后更新时间'

     fid => '论坛id'

     tid => '主题id'

     dateline => '发表时间'

     forum => '论坛名称'

     author => '作者'

     subject => '标题'

     description => '解释说明'

     guidetype => '导读中的类型'

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

     tid => '主题tid'

     extcredits => '单次回复奖励额度'

     extcreditstype => '本规则下奖励积分的类型'

     times => '回复奖励次数'

     membertimes => '单个用户参与次数'

     random => '用户设置的回帖奖励几率'

133. pre_common_searchindex - 搜索缓存表

     searchid => '缓存id'

     srchmod => 'mod模块'

     keywords => '关键字'

     searchstring => '查找字符串'

     useip => '搜索人IP'

     uid => '会员id'

     dateline => '搜索时间'

     expiration => '过期时间'

     threadsortid => '分类信息id'

     num => '主题数量'

     ids => '主题id序列'

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

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

135. pre_forum_spacecache - minispace缓存表

     uid => '用户 uid'

     variable => '缓存变量的名称'

     value => '缓存变量的值'

     expiration => '过期时间'

136. pre_forum_statlog - 版块统计日志表

     logdate => '日志日期'

     fid => '版块ID'

     `type` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT '记录类型 value => '0' COMMENT '记录值'

137. 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 => '任务脚本版本号'

138. pre_common_taskvar - 论坛任务设置表

     taskvarid => '任务变量id'

     taskid => '任务id'

     sort => '变量类别(apply:申请任务条件 complete:完成任务条件)'

     name => '变量名称'

     description => '变量描述'

     variable => '变量名'

     type => 'text' COMMENT '变量类型'

     value => '变量值'

139. 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 => '最大回帖位置信息'

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

     tid => '主题id'

     addviews => '浏览次数'

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

     tid => '主题id'

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

     tid => '对应源主题'

     redirect => '保留的指向 tid'

143. pre_forum_threadmod - 主题管理记录表

     tid => '主题id'

     uid => '会员id'

     username => '会员名'

     dateline => '操作时间'

     expiration => '有效时间'

     action => '操作'

     status => '0' COMMENT '状态'

     magicid => '使用道具id'

     stamp => '主题图章/图标 ID'

     reason => '操作原因'

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

     tid => '主题id'

     uid => '会员id'

     dateline => '参与时间'

145. pre_forum_threadrush - 抢楼设置表

     tid => '主题id'

     stopfloor => '截止楼层'

     starttimefrom => '开始时间'

     starttimeto => '结束时间'

     rewardfloor => '奖励楼层'

     creditlimit => '积分下限'

146. pre_forum_threadtype - 分类信息表

     typeid => '分类信息id'

     fid => '0'

     displayorder => '显示顺序'

     name => '名称'

     description => '解释说明'

     icon => '分类图标URL'

     special => '分类状态'

     modelid => '分类模型id'

     expiration => '分类有效期'

     template => '分类信息内容模板'

     stemplate => '分类信息主题模板'

     ptemplate => '分类信息发帖模板'

     btemplate => '分类信息模块调用模板'

147. 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 => '总积分交易额'

148. pre_forum_threadclass - 主题分类表

     typeid => '分类ID'

     fid => '所属版块ID'

     name => '分类名称'

     displayorder => '显示顺序'

     icon => '分类图标URL'

     moderators => '0' COMMENT '仅管理者可用'

149. pre_forum_tradecomment - 信用评价

     id => 'id'

     orderid => '订单 id'

     pid => '帖子 id'

     type => '类型'

     raterid => '评价方会员id'

     rater => '评价方用户名'

     rateeid => '被评价方会员id'

     ratee => '被评价方用户名'

     message => '评价内容'

     explanation => '解释'

     score => '评分'

     dateline => '评价时间'

150. 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 => '积分原价'

151. pre_forum_typeoption - 分类信息设置项目表

     optionid => '分类信息项目ID'

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

     displayorder => '分类信息排序'

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

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

     title => '分类信息项目标题'

     description => '分类信息项目描述'

     identifier => '分类信息项目标识'

     type => '分类信息项目类型'

     unit => '分类信息项目单位'

     rules => '分类信息项目规则'

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

152. pre_forum_typeoptionvar - 分类信息项目数据表

     sortid => '分类信息id'

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

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

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

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

     value => '分类信息数据数值'

153. pre_forum_typevar - 分类信息对应项目表

     sortid => '分类信息id'

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

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

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

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

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

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

     subjectshow => ''

154. 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 => '相册描述 '

155. pre_home_appcreditlog - 漫游应用积分操作记录表

     logid => '序列id'

     uid => '用户id'

     appid => '用户名'

     appname => '应用名称'

     type => '0' COMMENT '积分转入转出类型'

     credit => '积分数'

     note => '备注'

     dateline => '操作时间'

156. 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 => '是否为空白模块，只显示准送数据'

157. pre_common_block_style - 模块模板表

     styleid => '模块样式ID'

     blockclass => '模块分类'

     name => '样式名称'

     template => '样式模板'

     hash => '样式hash（blockclass + template）'

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

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

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

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

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

     moreurl => '是否有更多链接'

158. 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 => '结束时间戳'

159. 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'

160. pre_common_block_xml - 模块 XML 扩展类数据表

     id => 'ID'

     name => 'XML扩展 名称'

     version => 'XML扩展 版本'

     url => 'XML扩展 URL'

     clientid => '客户端ID'

     key => '通信密钥'

     signtype => '签名的加密方式：目前只支持MD5方式，空为不使用签名，直接使用通信密钥'

     data => 'XML扩展 数据'

161. 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'

162. 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 => '分类创建时间戳'

163. pre_home_click - 表态动作

     clickid => '表态ID'

     name => '表态名称'

     icon => '表态图标'

     idtype => '表态类型'

     available => '是否有效'

     displayorder => '排序'

164. pre_home_clickuser - 用户表态表

     uid => '表态用户id'

     username => '表态用户名'

     id => '作用对象id'

     idtype => '作用对象id类型'

     clickid => '表态id'

     dateline => '发表表态时间戳'

165. pre_home_comment - 用户评论表

     cid => '评论id'

     uid => '发表评论的用户id'

     id => '评论对象id'

     idtype => '评论对象的id类型：blogid，picid，uid'

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

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

     ip => '评论IP '

     dateline => '评论时间戳'

     message => '评论内容'

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

     status => '评论状态 1-审核'

166. pre_home_docomment - 用户记录回复表

     id => '记录回复id'

     upid => '上级记录回复id'

     doid => '所评论的记录id'

     uid => '发布记录者用户id'

     username => '发布记录者用户名'

     dateline => '记录回复时间戳'

     message => '记录回复内容'

     ip => '发布记录ip'

     grade => '记录回复的层级'

167. 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 '

168. pre_home_friend - 用户好友表

     uid => '用户ID '

     fuid => '用户好友ID '

     fusername => '用户好友名'

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

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

     dateline => '加好友的时间戳'

     note => '好友备注'

169. pre_home_friend_request - 申请好友表

     uid => '用户ID '

     fuid => '被请求用户ID '

     fusername => '被请求用户名称'

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

     note => '申请附言'

     dateline => '请求好友时间戳'

170. pre_home_friendlog - 用户好友动作日志表

     uid => '用户ID '

     fuid => '好友用户ID '

     action => '好友动作:"add"添加,"update"更新 '

     dateline => '好友动作时间'

171. pre_common_magiclog - 道具日志表

     uid => '用户id'

     magicid => '道具id'

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

     dateline => '操作时间'

     amount => '操作数量'

     credit => '操作积分'

     price => '操作价格'

     targetid => '0'

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

172. pre_common_magic - 道具数据表

     magicid => '道具id'

     available => '是否可用'

     name => '名称'

     identifier => '唯一标识'

     description => '描述'

     displayorder => '顺序'

     credit => '使用的积分'

     price => '价格'

     num => '数量'

     salevolume => '销售量'

     supplytype => '自动补货类型'

     supplynum => '自动补货数量'

     useperoid => '使用周期'

     usenum => '周期使用数量'

     weight => '重量'

     magicperm => '权限'

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

173. 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-审核'

174. pre_home_picfield - 家园图片拓展表

     picid => '图片id'

     hotuser => '图片对应热点用户'

175. pre_home_poke - 用户招呼表

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

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

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

     note => '招呼内容'

     dateline => '打招呼时间戳'

     iconid => '招呼图标'

176. 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-审核'

177. pre_home_show - 用户上榜表

     uid => '我要上榜用户id'

     username => '我要上榜用户名'

     unitprice => '单次访问单价'

     credit => '上榜总积分'

     note => '上榜宣言'

178. pre_home_userapp - 用户使用应用表

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

     appid => '应用ID '

     appname => '应用名'

     privacy => '应用是否公开'

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

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

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

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

     menuorder => '菜单顺序'

     displayorder => '显示顺序'

179. pre_home_userappfield - 用户使用应用扩展表

     uid => '使用应用的用户id'

     appid => '应用id'

     profilelink => '应用链接'

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

180. pre_home_visitor - 空间访问日志表

     uid => '受访者用户id'

     vuid => '访问者用户id'

     vusername => '访问者用户名'

     dateline => '访问时间戳'

181. 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 => '是否显示分页导航'

182. pre_portal_article_content - 门户文章内容表

     cid => '内容ID'

     aid => '文章ID'

     id => '来源ID'

     idtype => '来源ID类型'

     title => '标题'

     content => '文章内容'

     pageorder => '分页排序'

     dateline => '添加时间'

183. pre_portal_article_count - 门户文章统计数据表

     aid => '文章ID'

     catid => '栏目id'

     viewnum => '查看数'

     commentnum => '评论数'

     favtimes => '文章收藏次数'

     sharetimes => '文章分享次数'

184. pre_portal_article_trash - 门户文章回收站表

     aid => '垃圾文章ID'

     content => '文章数据的seriallize存储'

185. pre_portal_comment - 门户评论表

     cid => '评论id'

     uid => '发表评论的用户id'

     username => '发表评论的用户名'

     id => '评论对象id'

     idtype => '评论对象的id类型：aid，topicid'

     postip => '评论IP '

     dateline => '评论时间戳'

     status => '评论状态 1-审核'

     message => '评论内容'

186. 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 => '是否有远程图片'

187. pre_common_diy_data - DIY模板页面数据的存档表

     targettplname => '目标模板文件名'

     tpldirectory => '原模板所在目录'

     primaltplname => '原模板文件名'

     diycontent => 'DIY的内容'

     name => '目标模板页面名称'

     uid => '会员id'

     username => '用户名'

     dateline => '更新时间'

188. pre_common_template_block - 模板页面和模块的关联表

     targettplname => '目标模板文件名'

     tpldirectory => '原模板所在目录'

     bid => '模块ID'

189. pre_common_template_permission - DIY模板页面权限表

     targettplname => '目标模板'

     uid => '用户ID'

     allowmanage => '允许管理'

     allowrecommend => '允许推荐'

     needverify => '推荐需要审核'

     inheritedtplname => '继承自的模板名称'

190. pre_common_block_permission - 模块权限表

     bid => '模块ID'

     uid => '会员id'

     allowmanage => '允许管理'

     allowrecommend => '允许推荐'

     needverify => '推荐需要审核'

     inheritedtplname => '继承自的模板名称'

191. pre_portal_category_permission - 文章分类权限表

     catid => '分类ID'

     uid => '会员id'

     allowpublish => '允许发布文章'

     allowmanage => '允许管理文章'

     inheritedcatid => '继承自的频道ID'

192. 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 => '锁的附属信息'

193. pre_common_admincp_group - 后台管理组

     cpgroupid => '后台组id'

     cpgroupname => '后台组名称'

194. pre_common_admincp_member - 后台管理成员

     uid => '成员uid'

     cpgroupid => '成员组id'

     customperm => '自定义管理权限'

195. pre_common_admincp_perm - 后台权限表

     cpgroupid => '后台组id'

     perm => '后台组权限'

196. pre_common_admincp_session - 后台session表

     uid => '用户id'

     adminid => '管理组id'

     panel => '面板位置'

     ip => 'IP'

     dateline => '最后动作时间'

     errorcount => '登录错误次数'

     storage => '临时内容存储'

197. pre_portal_attachment - 门户文章附件表

     attachid => '附件id'

     uid => '会员id'

     dateline => '上传时间'

     filename => '原文件名'

     filetype => '文件类型'

     filesize => '文件大小'

     attachment => '服务器路径'

     isimage => '是否图片'

     thumb => '是否是缩率图'

     remote => '是否远程附件'

     aid => '文章id'

198. pre_portal_article_related - 门户相关文章

     aid => '文章ID'

     raid => '相关文章ID'

     displayorder => '显示顺序'

199. pre_home_specialuser - 特殊用户表

     uid => '用户ID'

     username => '用户名'

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

     dateline => '设置时间'

     reason => '操作原因'

     opuid => '操作者用户ID'

     opusername => '操作者用户名'

     displayorder => '显示顺序'

200. pre_common_district - 地区表

     id => '地区ID'

     name => '地区名称'

     level => '0' COMMENT '地区等级：1，省级；2，市级；3，县级；4，乡镇'

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

     upid => '上级地区ID'

     displayorder => '显示顺序'

201. pre_forum_grouplevel - 群组等级表

     levelid => '等级ID'

     type => '类型'

     leveltitle => '群组等级名称'

     creditshigher => '该等级的积分上限'

     creditslower => '该等级的积分下限'

     icon => '等级图标'

     creditspolicy => '积分策略'

     postpolicy => '帖子策略'

     specialswitch => '特殊开能开关'

202. pre_forum_groupcreditslog - 群组积分日志表

     fid => '群组ID'

     uid => '成员UID'

     logdate => '日期/20100308'

203. pre_home_blog_category - 日志系统栏目

     catid => '栏目id'

     upid => '上级栏目id'

     catname => '标题'

     num => '日志数'

     displayorder => '显示顺序'

204. pre_home_album_category - 相册系统栏目

     catid => '栏目id'

     upid => '上级栏目id'

     catname => '标题'

     num => '相册数'

     displayorder => '显示顺序'

205. pre_common_report - 用户举报表

     id => '记录id'

     urlkey => '地址md5'

     url => '地址'

     message => '举报理由'

     uid => '会员id'

     username => '用户名'

     dateline => '举报时间'

     num => '举报次数'

     opuid => '管理员id'

     opname => '管理员姓名'

     optime => '处理时间'

     opresult => '对举报人的奖惩'

     fid => '论坛id'

206. pre_common_patch - 漏洞补丁表

     serial => '漏洞编号'

     rule => '修补规则'

     note => '漏洞说明'

     status => '0' COMMENT '修补状态'

     dateline => '漏洞发布时间'

207. pre_forum_collection - 淘帖专辑表

     ctid => '专辑ID'

     uid => '用户ID'

     username => '用户名'

     name => '专辑名'

     dateline => '创建时间'

     follownum => '订阅数'

     threadnum => '主题数'

     commentnum => '评论数'

     desc => '简介'

     lastupdate => '最后变动时间'

     rate => '评分'

     ratenum => '评分次数'

     lastpost => '最后主题ID'

     lastsubject => '最后主题标题'

     lastposttime => '最后主题时间'

     lastposter => '最后主题发帖者'

     lastvisit => '创建者最后访问'

     keyword => '专辑关键词'

208. pre_forum_collectioncomment - 淘帖评论表

     cid => '评论ID'

     ctid => '专辑ID'

     uid => '用户ID'

     username => '用户名'

     message => '评论内容'

     dateline => '评论时间'

     useip => 'IP地址'

     rate => '评分'

209. pre_forum_collectionfollow - 淘帖关注表

     uid => '用户ID'

     username => '用户名'

     ctid => '专辑ID'

     dateline => '关注时间'

     lastvisit => '最后访问专辑时间'

210. pre_forum_collectioninvite - 邀请管理淘专辑

     ctid => '专辑ID'

     uid => '邀请合作者ID'

     dateline => '邀请时间'

211. pre_forum_collectionrelated - 淘帖主题被收入专辑表

     tid => '主题ID'

     collection => '专辑列表'

212. pre_forum_collectionteamworker - 淘帖合作编辑表

     ctid => '专辑ID'

     uid => '合作者ID'

     name => '专辑名'

     username => '用户名'

     lastvisit => '最后访问专辑时间'

213. pre_forum_collectionthread - 淘帖包含主题表

     ctid => '专辑ID'

     tid => '专辑内主题ID'

     dateline => '主题日期'

     reason => '推荐理由