齐乐分享社区 - bbs.76fx.com 前言:DZX3的功能很强大,这点毋庸置疑,感谢康盛。但是功能的强大对应这复杂的数据库,对于广大屌丝站长来说,数据库崩溃了,那就什么都没了。在此根据官方提供的数据库表来对应,这样各位站长们的数据库表出现了问题也可以知道到底是什么表,这个表的重要性等等!这样方能安心处理!对于网站异常,喜欢折腾的站长们可以对照折腾了!
pre_common_admincp_cmenu 后台菜单收藏表
pre_common_admincp_group 后台管理组
pre_common_admincp_member 后台管理成员
pre_common_admincp_perm 后台权限表
pre_common_admincp_session 后台session表
pre_common_admingroup 管理组表
pre_common_adminnote 后台留言表
pre_common_advertisement 广告数据表
pre_common_advertisement_custom 自定义广告数据表
pre_common_banned 禁止访问表
pre_common_block 模块表
字段名 | | | | | | | |
| | | | | | | |
| 模块分类 article/pic/member/board/poll | | | | |
| | | |
| |
| | | |
| |
| | | |
| |
| | | |
| |
| | | | | |
| | | |
| |
| | | | | |
| | | |
| |
| | | | | |
| | | | | |
| | | |
| |
| 模块链接打开方式: _blank, _self, _top | | |
| |
| | | | | |
| | | |
| |
| | | |
| |
| | | | | |
| | | | | |
| | | |
| |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| |
pre_common_block_favorite 模块收藏表
pre_common_block_item 模块数据表
字段名 | | | | | | | |
| | | | | | | |
| | | | | |
| | | |
| |
| | | | | |
| | | |
| |
| | | |
| |
| | | |
| |
| | | | | |
| | | | | |
| | | |
| |
| | | |
| |
| | | |
| |
| | | |
| |
| | | |
| |
| 信息附属num/author/authorid/dateline | | | | |
| | | | | |
| | | | | |
| |
pre_common_block_item_data 模块推荐信息表
字段名 | | | | | | | |
| | | | | | | |
| | | | | |
| | | |
| |
| | | | | |
| | | |
| |
| | | |
| |
| | | |
| |
| | | | | |
| | | | | |
| | | |
| |
| | | |
| |
| | | |
| |
| | | |
| |
| 信息附属num/author/authorid/dateline | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | |
| |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| |
pre_common_block_permission 模块权限表
pre_common_block_pic 模块使用图片表
pre_common_block_style 模块模板表
字段名 | | | | | | | |
| | | | | |
| |
| | | |
| |
| | | |
| |
| | | |
| |
| 样式hash(blockclass + template) | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | |
| |
| | | | | |
| |
pre_common_block_xml 模块 XML 扩展类数据表
字段名 | | | | | | | |
| | | | | |
| |
| | | |
| |
| | | |
| |
| | | |
| |
| | | |
| |
| | | |
| |
| 签名的加密方式:目前只支持MD5方式,空为不使用签名,直接使用通信密钥 | | |
| |
| |
(本帖资源介绍来自齐乐分享|bbs.76fx.com|转载请注明!)
pre_common_cache 通用缓存表
pre_common_card 充值卡密表
pre_common_card_log 充值卡密表
字段名 | | | | | | | |
| | | | | | | |
| | | |
| |
| | | |
| |
| | | |
| |
| | | | | |
| | | |
| |
| | | | | |
| 操作动作(位与):1:生成,2:任务生成,4:删除,9:卡片过期 |
pre_common_card_type 卡片分类表
pre_common_credit_log 积分日志表
pre_common_credit_log_field 积分日志详情
pre_common_credit_rule 积分规则表
字段名 | | | | | | | |
| | | | | |
| |
| | | |
| |
| | | | | |
| 奖励周期0:一次;1:每天;2:整点;3:间隔分钟;4:不限; | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | |
| |
| |
pre_common_credit_rule_log 积分规则日志表
pre_common_credit_rule_log_field 积分规则日志扩展表
pre_common_cron 计划任务表
字段名 | | | | | | | |
| | | | | | | |
| | | enum('user','system','plugin') | | |
| | | |
| |
| | | |
| |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | |
| |
| |
pre_common_district 地区表 字段名 | | | | | | | |
| | | | | |
| |
| | | | | |
| | | | | |
| 使用对象:0:都不启用; 1:出生地; 2:居住地; 3:都启用 | | | | |
| | | | | |
| |
pre_common_diy_dataDIY模板页面数据的存档表 pre_common_domain 二级域名表 字段名 | | | | | | | |
| |
| | | |
| |
| | | | | |
| | | |
| |
| 对应对象类型subarea:分区、forum:版块、home:个人空间、group:群组、topic:专题、channel:频道 |
pre_common_failedlogin失败登录表 pre_common_friendlink友情链接表 pre_common_grouppm 群发短消息表 pre_common_invite 邀请表 pre_common_magic 道具数据表 pre_common_magiclog 道具日志表 pre_common_mailcron 邮件计划任务表 pre_common_mailqueue 邮件队列表 pre_common_member 用户主表 字段名 | | | | | | | |
| | | | | |
| |
| | | |
| |
| | | |
| |
| | | | | |
| 判断用户是否已经删除 需要discuz程序加判断,并增加整体清理的功能。原home字段为flag | | | | |
| email是否经过验证 home字段为emailcheck | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | |
| |
| | | | | |
| | | | | |
| | | | | |
| | | |
| |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| |
pre_common_member_action_log用户操作日志表 pre_common_member_count用户统计表 pre_common_member_crime用户惩罚|违规记录操作表(本帖资源介绍来自齐乐分享|bbs.76fx.com|转载请注明!) pre_common_member_field_forum用户论坛字段表 字段名 | | | | | | | |
| |
| | | | | |
| 用户自定义发送哪些类型的feed(原字段为customaddfeed) | | | | |
| | | |
| |
| | | |
| |
| | | |
| |
| | | |
| |
| | | |
| |
| | | |
| |
| | | |
| |
| |
pre_common_member_field_home用户家园字段表 字段名 | | | | | | | |
| |
| | | |
| |
| | | |
| |
| | | |
| |
| | | |
| |
| | | | | |
| | | | | |
| | | | | |
| | | |
| |
| | | |
| |
| | | |
| |
| | | |
| |
| | | |
| |
| | | |
| |
| home隐私设置(注意要和论坛发feed等开关的设置结合) | | |
| |
| | | |
| |
| | | |
| |
| | | |
| |
| |
pre_common_member_forum_buylog用户版块积分付费记录 pre_common_member_grouppm群发短消息用户记录表 pre_common_member_log漫游用户日志表 pre_common_member_magic用户道具数据表 pre_common_member_medal用户勋章数据表 pre_common_member_newprompt用户新提醒数量表 pre_common_member_profile用户栏目表 pre_common_member_profile_setting个人信息扩展表 pre_common_member_security个人信息修改审核 pre_common_member_stat_field用户资料统计项 字段名 | | | | | | | |
| | | | | |
| |
| | | |
| |
| | | |
| |
| 由fieldid和fieldvalue生成的hash | | | | |
| | | | | |
| |
pre_common_member_status用户状态表 字段名 | | | | | | | |
| |
| | | |
| |
| | | |
| |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| 上次发送email时间 home原字段为lastsend | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| |
pre_common_member_validate 用户审核表 pre_common_member_verify用户认证表 字段名 | | | | | | | |
| |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| 实名认证: -1:被拒绝 0:待审核 1:审核通过 | | | | |
| 视频认证: -1:被拒绝 0:待审核 1:审核通过 |
pre_common_member_verify_info个人信息修改审核(本帖资源介绍来自齐乐分享|bbs.76fx.com|转载请注明!) 字段名 | | | | | | | |
| | | | | | | |
| | | |
| |
| | | | | |
| 审核类型0:资料审核, 1:认证1, 2:认证2, 3:认证3, 4:认证4, 5:认证5 | | | | |
| | | |
| |
| | | | | |
| |
pre_common_myapp 漫游应用表 字段名 | | | | | | | | | |
| | | |
| |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| userabout显示区域、1主区、2、副区、3应用区 | | |
| |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| 应用图标是否已下载到本地。-1:失败;0:未下载;1:已下载 | | | | |
| |
pre_common_myinvite 用户邀请表 pre_common_mytask 我的任务表 pre_common_nav 自定义导航栏表 字段名 | | | | | | | |
| | | | | | | |
| | | |
| |
| | | |
| |
| | | |
| |
| | | |
| |
| | | | | |
| | | | | |
| 类型 0 系统 1 自定义 3 插件 4 频道 5 版块 | | | | |
| | | |
| |
| | | | | |
| | | | | |
| 使用等级 (0:游客 1:会员 2:版主 3:管理员) | | | | |
| 二级导航样式(navtype=0) 顶部导航位置(navtype=4) | | | | |
| | | |
| |
| | | |
| |
| | | |
| |
| | | | | |
| 导航类型 (0:主导航 1:底部导航 2:家园导航 3:快捷导航 4:顶部导航) | | |
| |
| |
pre_common_onlinetime在线时间表 pre_common_optimizer 优化大师的记录数据 pre_common_patch 漏洞补丁表 pre_common_plugin 插件表 pre_common_pluginvar 插件变量表 pre_common_process 进程锁管理 pre_common_regip 注册IP限制表 pre_common_relatedlink关联链接表 pre_common_report 用户举报表 pre_common_searchindex搜索缓存表 pre_common_secquestion验证问题数据表 pre_common_session 会员认证表 pre_common_setting 设置表 pre_common_smiley 表情表 字段名 | | | | | | | |
| | | | | |
| |
| | | | | |
| | | enum('smiley','stamp','stamplist') | | |
| | | |
| |
| | | |
| |
| |
pre_common_sphinxcounterSphinx 增量索引记录表 pre_common_stat 趋势统计 pre_common_statuser 统计用户表 字段名 | | | | | | | | | |
|
| | | | |
|
| | |
| |
| 各种用户行为如:invite、register、login... |
pre_common_style 风格表 pre_common_stylevar 风格变量表 pre_common_syscache 缓存数据表 字段名 | | | | | | | |
| |
| | | |
| |
| 缓存类型 0=value, serialize=1 | | |
| |
| | | |
| |
| |
pre_common_tag 标签表 字段名 | | | | | | | |
| | | | | |
| |
| | | | | |
| 显示状态 (0:正常 1:关闭 2:推荐 3:用户标签) |
pre_common_tagitem 标签内容表 pre_common_task 论坛任务表 字段名 | | | | | | | |
| | | | | | | |
| | | | | |
| | | |
| |
| | | |
| |
| | | |
| |
| | | | | |
| | | | | |
| | | | | |
| | | |
| |
| | | |
| |
| | | | | |
| | | | | |
| | | | | |
| 任务周期 单位:小时 默认为0表示一次性任务 设置为24即1天表示日常任务 | | | | |
| 任务间隔周期单位 0:小时 1:天 2:周 3:月 | | enum('credit','magic','medal','invite','group') | | |
| 奖励类型 (credit:积分 magic:道具 medal:勋章 invite:邀请码 group:特殊用户组) | | |
| |
| 奖品: 哪一个扩展积分, 道具id, 勋章id,邀请码有效期, 特殊用户组id | | | | |
| 奖品数量/有效期: 积分数量, 道具数量, 勋章有效期, 邀请码数量,特殊用户组有效期 | | | | |
| | | |
| |
| |
pre_common_taskvar 论坛任务设置表 字段名 | | | | | | | |
| | | | | | | |
| | | | | |
| 变量类别 (apply:申请任务条件 complete:完成任务条件) | | |
| |
| | | |
| |
| | | |
| |
| | | | | |
| | | |
| |
| |
pre_common_template 模板表 pre_common_template_block模板页面和模块的关联表 pre_common_template_permissionDIY模板页面权限表 pre_common_usergroup 用户组表 字段名 | | | | | | | |
| | | | | | | |
| | | enum('system','special','member') | | |
| | | | | |
| | | |
| |
| | | | | |
| | | | | |
| | | | | |
| | | |
| |
| | | |
| |
|
| | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| |
pre_common_usergroup_field会员用户组权限表 字段名 | | | | | | | |
| |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | |
| |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | |
| |
| | | |
| |
| | | |
| |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | |
| |
| | | |
| |
| | | | | |
| | | |
| |
| | | |
| |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| 允许帖子点评 0:禁止 1:楼主 2:回复 3:All | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| |
pre_common_visit 用户访问日志表 pre_common_word 词语过滤表 pre_common_word_type 词语过滤分类 pre_forum_access 访问权限表 pre_forum_activity 活动表 pre_forum_activityapply活动申请表 pre_forum_announcement公告表 pre_forum_attachment 附件索引表 pre_forum_attachment_0附件表 pre_forum_attachment_1附件表 pre_forum_attachment_2附件表 pre_forum_attachment_3附件表 pre_forum_attachment_4附件表(本帖资源介绍来自齐乐分享|bbs.76fx.com|转载请注明!) pre_forum_attachment_5附件表 pre_forum_attachment_6附件表 pre_forum_attachment_7附件表 pre_forum_attachment_8附件表 pre_forum_attachment_9附件表 pre_forum_attachment_exifExif缓存表 pre_forum_attachment_unused未使用附件表 pre_forum_attachtype 附件类型表 pre_forum_bbcodeDiscuz! 代码表 字段名 | | | | | | | |
| | | | | | | |
| 是否启用 (0:不启用 1:启用但不显示 2:启用并显示) | | |
| |
| | | |
| |
| | | |
| |
| | | |
| |
| | | |
| |
| | | | | |
| | | |
| |
| | | | | |
| | | | | |
| | | |
| |
| |
pre_forum_collection 淘帖专辑表 pre_forum_collectioncomment淘帖评论表 pre_forum_collectionfollow淘帖关注表 pre_forum_collectioninvite邀请管理淘专辑 pre_forum_collectionrelated淘帖主题被收入专辑表 pre_forum_collectionteamworker淘帖合作编辑表 pre_forum_collectionthread淘帖包含主题表 pre_forum_creditslog 转帐记录表 pre_forum_debate 辩论主题表 字段名 | | | | | | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | |
| |
| | | | | |
| 获胜方 (0:平局 1:为正方 2:为反方) 裁判评判结果 | | |
| |
| | | |
| |
| | | |
| |
| | | |
| |
| | | |
| |
| | | |
| |
| | | |
| |
| | | |
| |
| |
pre_forum_debatepost 辩论帖子表 pre_forum_faq 论坛帮助表 pre_forum_filter_post非水帖标记 pre_forum_forum 版块表 字段名 | | | | | | | |
| | | | | | | |
| | | enum('group','forum','sub') | | |
| 类型 (group:分类 forum:普通论坛 sub:子论坛) | | |
| |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | |
| |
| | | |
| |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| |
pre_forum_forum_threadtable版块存档信息 pre_forum_forumfield 版块扩展表 字段名 | | | | | | | | | |
| | | |
| |
| | | |
| |
| | | |
| |
| | | |
| |
| | | |
| |
| | | |
| |
| | | |
| |
| | | |
| |
| | | |
| |
| | | |
| |
| | | |
| |
| | | |
| |
| | | |
| |
| | | |
| |
| | | |
| |
| | | |
| |
| | | |
| |
| | | |
| |
| | | |
| |
| | | |
| |
| | | |
| |
| | | |
| |
| supe推送设置,序列化存放设置数据,格式为一个数组。 | | |
| |
| | | |
| |
| | | |
| |
| | | |
| |
|
| | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | |
| |
| | | |
| |
| | | | | |
| | | |
| |
|
| | |
| |
|
| | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| |
pre_forum_forumrecommend版主推荐表 pre_forum_groupcreditslog群组积分日志表 pre_forum_groupfield 群组扩展信息缓存 pre_forum_groupinvite群组邀请 pre_forum_grouplevel 群组等级表 字段名 | | | | | | | |
| | | | | enum('special','default') | | |
| | | |
| |
| | | | | |
| | | | | |
| | | |
| |
| | | |
| |
| | | |
| |
| | | |
| |
| |
pre_forum_groupuser 群组成员 字段名 | | | | | | | | | |
| | | | | |
| | | |
| |
| | | | | |
| 成员等级 (0:待审核 1:群主 2:副群主 3:明星成员 4:普通成员) | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| |
pre_forum_hotreply_member回帖投票会员记录表 pre_forum_hotreply_number回帖投票 pre_forum_imagetype 图片 表情 头像等 分类 字段名 | | | | | | | |
| | | | | | | |
| | | |
| |
| | | enum('smiley','icon','avatar') | | |
| 分类类型 (smiley:表情 icon:图标 avatar:头像) | | | | |
| | | |
| |
| |
pre_forum_medal 勋章表(本帖资源介绍来自齐乐分享|bbs.76fx.com|转载请注明!) pre_forum_medallog 勋章日志表 pre_forum_memberrecommend用户推荐表 pre_forum_moderator 版主表 pre_forum_modwork 论坛管理统计表 pre_forum_newthread 最新主题表 pre_forum_onlinelist 在线列表定制 pre_forum_order 订单信息表 pre_forum_poll 投票表 pre_forum_polloption 投票选项表 pre_forum_polloption_image投票选项图片 pre_forum_pollvoter 投票用户表 pre_forum_post 帖子表 pre_forum_post_location帖子地理位置表 pre_forum_post_moderate帖子审核数据表 pre_forum_post_tableidpost分表协调表 pre_forum_postcache 论坛帖子缓存表 pre_forum_postcomment点评帖子表 pre_forum_postlog 漫游帖子日志 pre_forum_poststick 回帖置顶表 pre_forum_promotion 论坛推广 pre_forum_ratelog 帖子评分记录表 pre_forum_relatedthread相关主题表 pre_forum_replycredit主题回帖获得积分规则表 pre_forum_rsscacherss缓存表 pre_forum_sofa 抢沙发列表 pre_forum_spacecacheminispace缓存表 pre_forum_statlog 版块统计日志表 pre_forum_thread 主题表 字段名 | | | | | | | |
| | | | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | |
| |
| | | | | |
| | | |
| |
| | | | | |
| | | | | |
| | | |
| |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| 特殊主题,1:投票;2:商品;3:悬赏;4:活动;5:辩论贴;127:插件相关 | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
|
| | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| 根据帖子标签取的相关主题id (time /t tid,...) | | | | |
| | | |
| |
| | | | | |
| |
pre_forum_thread_moderate主题审核数据表 pre_forum_threadaddviews主题查看数延时更新表 pre_forum_threadcalendar热帖日历表 pre_forum_threadclass主题分类表 pre_forum_threadclosed主题转移后保留的指向记录 pre_forum_threaddisablepos主题有楼层不准确时不使用position查询 pre_forum_threadhot 热帖日历数据表 pre_forum_threadimage主题图片表 pre_forum_threadlog 漫游主题日志 pre_forum_threadmod 主题管理记录表 pre_forum_threadpartake主题参与者记录表 pre_forum_threadpreview服务于广播 pre_forum_threadprofile贴内用户信息设置 pre_forum_threadprofile_group贴内用户信息用户组 pre_forum_threadrush 抢楼设置表 pre_forum_threadtype 分类信息表 pre_forum_trade 商品数据表 pre_forum_tradecomment信用评价 pre_forum_tradelog 交易记录表 pre_forum_typeoption 分类信息设置项目表 pre_forum_typeoptionvar分类信息项目数据表 pre_forum_typevar 分类信息对应项目表 pre_forum_warning 警告记录表 pre_home_album 相册表 字段名 | | | | | | | |
| | | | | |
| |
| | | | | |
| | | | | |
| | | |
| |
| | | | | |
| | | | | |
| | | | | |
| | | |
| |
| | | | | |
| | | | | |
| 相册隐私设置:"0"全站用户可见,"1"为全好友可见,"2"为仅指定的好友可见,"3"为仅自己可见,"4"为凭密码查看 | | |
| |
| | | |
| |
| | | |
| |
| | | |
| |
| | | |
| |
| |
pre_home_album_category相册系统栏目 pre_home_appcreditlog漫游应用积分操作记录表 pre_home_blacklist 屏蔽黑名单表 pre_home_blog 日志表 字段名 | | | | | | | |
| | | | | | | |
| | | |
| |
| | | |
| |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| 日志隐私设置:"0"为全站用户可见,"1"为全好友可见,"2"为仅指定的好友可见,"3"为仅自己可见,"4"为凭密码查看 | | |
| |
| | | | | |
| | | | | |
| | | | | |
| blog状态 -1:回收站日志; 0:正常; 1:审核; | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| |
pre_home_blog_category日志系统栏目 pre_home_blog_moderate日志审核数据表 pre_home_blogfield 日志字段表 pre_home_class 日志个人分类表 pre_home_click 表态动作 pre_home_clickuser 用户表态表 pre_home_comment 用户评论表 字段名 | | | | | | | |
| | | | | | | |
| | | | | |
| | | |
| |
| 评论对象的id类型:blogid,picid,uid | | | | |
| | | |
| |
| | | |
| |
| | | | | |
| | | |
| |
| | | | | |
| | | | | |
| |
pre_home_comment_moderate家园评论审核数据表 pre_home_docomment 用户记录回复表 pre_home_doing 用户记录表 pre_home_doing_moderate记录审核数据表 pre_home_favorite 收藏表 pre_home_feed 站点feed表 字段名 | | | | | | | |
| | | | | | | |
| | | |
| |
| | | | | |
| | | |
| |
| | | | | |
| | | | | |
| | | |
| |
| 模板hash:md5(title_template" "body_template) | | |
| |
| 数据内容hash:md5(title_templat" "title_data" "body_template" "body_data) | | |
| |
| | | |
| |
| | | |
| |
| | | |
| |
| | | |
| |
| | | |
| |
| | | |
| |
| | | |
| |
| | | |
| |
| | | |
| |
| | | |
| |
| | | |
| |
| | | |
| |
| | | |
| |
| | | | | |
| | | |
| |
| | | | | |
| |
pre_home_feed_app 应该feed表 字段名 | | | | | | | |
| | | | | | | |
| | | |
| |
| | | | | |
| | | |
| |
| | | | | |
| | | | | |
| | | |
| |
| 模板hash:md5(title_template" "body_template) | | |
| |
| 数据内容hash:md5(title_templat" "title_data" "body_template" "body_data) | | |
| |
| | | |
| |
| | | |
| |
| | | |
| |
| | | |
| |
| | | |
| |
| | | |
| |
| | | |
| |
| | | |
| |
| | | |
| |
| | | |
| |
| | | |
| |
| | | |
| |
| | | |
| |
| |
pre_home_follow 用户关注关系表 pre_home_follow_feed 被关注者事件表 pre_home_follow_feed_archiver被关注者事件存档 pre_home_friend 用户好友表 pre_home_friend_request申请好友表 pre_home_friendlog 用户好友动作日志表 pre_home_notification通知表 字段名 | | | | | | | |
| | | | | | | |
| | | |
| |
| 通知类型:"doing"记录,"friend"好友请求,"sharenotice"好友分享,"post"话题回复, | | | | |
| | | | | |
| | | |
| |
| | | |
| |
| | | | | |
| | | | | |
| | | |
| |
| | | | | |
| | | | | |
| 提醒分类 1我的帖子 2坛友互动 3系统消息 4管理工作 0应用消息 |
pre_home_pic 家园图片表 字段名 | | | | | | | |
| | | | | | | |
| | | | | |
| | | |
| |
| | | | | |
| | | |
| |
| | | |
| |
| | | |
| |
| | | |
| |
| | | | | |
| | | |
| |
| | | | | |
| | | | | |
| 是否有远程图片0:home本地图片,1:home远程图片,2:论坛本地图片,3论坛远程图片 | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| |
pre_home_pic_moderate图片审核数据表 pre_home_picfield 家园图片拓展表 pre_home_poke 用户招呼表 pre_home_pokearchive 用户招呼存档表 pre_home_share 用户分享表 pre_home_share_moderate分享审核数据表 pre_home_show 用户上榜表 pre_home_specialuser 特殊用户表 pre_home_userapp 用户使用应用表 pre_home_userappfield用户使用应用扩展表 pre_home_visitor 空间访问日志表 pre_portal_article_content门户文章内容表 pre_portal_article_count门户文章统计数据表 pre_portal_article_moderate文章审核数据表 pre_portal_article_related门户相关文章 pre_portal_article_title门户文章标题表 字段名 | | | | | | | |
| | | | | | | |
| | | | | |
| | | | | |
| | | |
| |
| | | |
| |
| | | |
| |
| | | |
| |
| | | |
| |
| | | |
| |
| | | |
| |
| | | |
| |
| | | |
| |
| | | | | |
| | | | | |
| | | | | |
| | | |
| |
| | | | | |
| | | | | |
| | | | | |
| 对于推送过来的文章:1,使用文章评论;0,同步原主题/日志的帖子/评论 | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | |
| |
| | | |
| |
| | | | | |
| | | |
| |
| | | |
| |
| |
pre_portal_article_trash门户文章回收站表 pre_portal_attachment门户文章附件表 pre_portal_category 门户 文章栏目表 pre_portal_category_permission文章分类权限表 pre_portal_comment 门户评论表 pre_portal_comment_moderate文章/专题评论审核数据表 pre_portal_rsscache 文章rss缓存表 pre_portal_topic 门户专题表 pre_portal_topic_pic 门户专题图片表
本帖资源介绍来自齐乐分享|bbs.76fx.com|转载请注明! |