数据库文档

2019年11月24日 阅读数:77
这篇文章主要向大家介绍数据库文档,主要内容包括基础应用、实用技巧、原理机制等方面,希望对大家有所帮助。

Clansday开发文档 css

  1. 数据库设计

    参照discuz的数据库 html

  2. pre_common_admincp_cmenu - 后台菜单收藏表

    title => '菜单名称' git

    url => '菜单地址' 正则表达式

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

    displayorder => '显示顺序' express

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

    uid => '添加用户' canvas

    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 '邮件邀请 10'

    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 => 'fieldidfieldvalue生成的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=13)'

    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 => '各类用户行为如:inviteregisterlogin...'

  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表示一次性任务 设置为241天表示平常任务'

    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为模板调用 1js调用'

    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 => '样式hashblockclass + 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 => '图片类型 0url 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为本地 1ftp远程'

    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 => '图片类型 0url 1为本地 2 ftp远程'

    makethumb => '是否已生成缩略图'

    summary => '信息摘要'

    showstyle => '显示样式'

    related => '相关连接'

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

    displayorder => '显示顺序'

    startdate => '开始时间戳'

    enddate => '结束时间戳'

    uid => '推荐者 UID'

    username => '推荐者用户名'

    dateline => '推荐日期'

    isverified => '是否已经过审核'

    verifiedtime => '经过审核日期'

    stickgrade => '置顶等级: 010'

  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类型:blogidpiciduid'

    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 => 'feedID '

    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 => 'feed1'

    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 => 'feed1'

    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类型:aidtopicid'

    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 => '图片类型 0url 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 => '推荐理由