npcomet 发表于 2007-11-13 21:15:04

Discuz!5数据库结构说明

Discuz!5数据库结构说明                                                                                                                                                                                                                                                                                                                        表格数量:67个

字段数量:742个
cdb_access访问权限表uidmediumint会员IDfidsmallint论坛IDallowviewtinyint允许浏览allowposttinyint允许发表allowreplytinyint允许回复allowgetattachtinyint允许下载附件allowpostattachtinyint允许上传附件cdb_activities活动表tidmediumint主题IDuidmediumint会员IDcostmediumint每人花销starttimefromint开始时间starttimetoint结束时间placechar地点classchar类别gendertinyint性别numbersmallint人数expirationint报名截止日期cdb_activityapplies活动申请表applyidint申请IDtidmediumint主题IDusernamechar用户名uidmediumint会员IDmessagechar消息verifiedtinyint是否审核通过(0:N1:Y)datelineint申请时间paymentmediumint每人花销cdb_adminactions关联用户组表admingidsmallint管理组IDdisabledactionstext禁止使用的功能cdb_admingroups管理组表admingidsmallint管理组IDalloweditposttinyint允许编辑帖子alloweditpolltinyint允许编辑投票allowstickthreadtinyint允许置顶allowmodposttinyint允许管理帖子allowdelposttinyint允许删除帖子allowmassprunetinyint允许批量主题管理allowrefundtinyint允许强制退款allowcensorwordtinyint允许过滤词语allowviewiptinyint允许查看用户IPallowbaniptinyint允许禁止IP访问alloweditusertinyint允许编辑用户allowmodusertinyint允许用户管理allowbanusertinyint允许禁止用户allowpostannouncetinyint允许匿名发帖allowviewlogtinyint允许查看管理日志disablepostctrltinyint发帖不受限制supe_allowpushthreadtinyint允许和Supe推送主题cdb_adminnotes后台留言表idmediumint后台留言IDadminvarchar管理员姓名accesstinyint哪组可以看到信息adminidtinyint管理员IDdatelineint发表时间expirationint过期时间messagetext消息cdb_adminsessions管理员认证表uidmediumint会员IDipcharIP地址datelineint登录时间errorcounttinyint错误次数cdb_advertisements后台广告表advidmediumint广告IDavailabletinyint是否启用typevarchar类型displayordertinyint显示顺序titlevarchar标题targetstext投放范围parameterstext参数codetext代码starttimeint开始时间endtimeint结束时间cdb_announcements公告表idsmallint公告IDauthorvarchar作者姓名subjectvarchar标题redirecttinyint外部URLdisplayordertinyint显示顺序starttimeint开始时间endtimeint结束时间messagetext消息cdb_attachments附件表aidmediumint附件IDtidmediumint主题IDpidint帖子IDdatelineint上传时间readpermtinyint阅读权限filenamechar原文件名descriptionchar解释说明filetypechar文件类型filesizeint文件大小attachmentchar服务器路径downloadsmediumint下载次数isimagetinyint是否图片uidmediumint会员IDcdb_attachtypes附件类型表idsmallint类型IDextensionchar扩展名maxsizeint允许上传最大值cdb_banned禁止访问表idsmallint禁止IDip1smallintIP分段1ip2smallintIP分段2ip3smallintIP分段3ip4smallintIP分段4adminvarchar管理员姓名datelineint禁止时间expirationint过期时间cdb_bbcodesDiscuz! 代码表idmediumint代码IDavailabletinyint是否启用tagvarchar标签iconvarchar图标replacementtext替换内容examplevarchar例子explanationtext解释说明paramstinyint参数个数nesttinyint嵌套层次cdb_blogcaches文集缓存表uidmediumint会员IDvariablevarchar变量valuetext变量值cdb_buddys好友表uidmediumint会员IDbuddyidmediumint好友IDgradetinyint性别datelineint加入日期descriptionchar解释说明cdb_creditslog转帐记录表uidmediumint会员IDfromtochar来自/到sendcreditstinyint转出积分字段receivecreditstinyint接受积分字段sendint转出积分receiveint接受积分datelineint转帐日期operationchar操作cdb_crons计划任务表cronidsmallint计划任务IDavailabletinyint是否启用typeenum类型namechar名称filenamechar对应文件lastrunint上次执行时间nextrunint下次执行时间weekdaytinyint周计划daytinyint日计划hourtinyint小时计划minutechar分计划cdb_failedlogins失败登录表ipchar失败IPcounttinyint尝试次数lastupdateint最后一次尝试时间cdb_favorites收藏表uidmediumint会员IDtidmediumint主题IDfidsmallint论坛IDcdb_forumfields论坛扩展表fidsmallint论坛IDdescriptiontext解释说明passwordvarchar私密论坛密码iconvarchar图标postcreditsvarchar发帖积分replycreditsvarchar回复积分getattachcreditsvarchar下载附件积分postattachcreditsvarchar发表附件积分digestcreditsvarchar精华积分redirectvarcharURL转发attachextensionsvarchar允许上传附件类型moderatorstext版主列表rulestext规则threadtypestext主题分类viewpermtext阅读权限postpermtext发表权限replypermtext回复权限getattachpermtext下载附件权限postattachpermtext上传附件权限supe_pushsettingtextsupe推送设置cdb_forumlinks联盟论坛表idsmallint联盟IDdisplayordertinyint显示顺序namevarchar名称urlvarcharURLnotevarchar解释说明logovarchar图标cdb_forums论坛表fidsmallint论坛IDfupsmallint上级论坛IDtypeenum类型namechar名称statustinyint显示状态displayordertinyint显示顺序styleidsmallint风格IDthreadsmediumint主题数量postsmediumint帖子数量todaypostsmediumint今日发帖数量lastpostchar最后发表allowsmiliestinyint允许使用表情allowhtmltinyint允许使用htmlallowbbcodetinyint允许bbcodeallowimgcodetinyint允许imgallowanonymoustinyint允许匿名allowsharetinyint允许共享到文集和supeallowpostspecialtinyint允许发表特殊主题alloweditrulestinyint允许版主修改论坛规则recyclebintinyint是否启用回收站modnewpoststinyint是否审核发帖jammertinyint是否启用干扰码disablewatermarktinyint是否图片附件增加水印inheritedmodtinyint本论坛或分类版主的权力继承到下级论坛autoclosesmallint自动关闭主题forumcolumnstinyint增加论坛水平横排设置threadcachestinyint主题缓存功能设置allowpaytoauthortinyint允许直接向作者支付cdb_medals勋章表medalidsmallint勋章IDnamevarchar勋章名称availabletinyint是否启用imagevarchar图片地址cdb_memberfields会员扩展表uidmediumint会员IDnicknamevarchar用户昵称sitevarchar网址alipayvarchar主页icqvarchar支付宝帐号qqvarcharQQyahoovarcharYAHOOmsnvarcharMSNtaobaovarcharTAOBAOlocationvarchar来自customstatusvarchar自定义头衔medalsvarchar勋章avatarvarchar头像avatarwidthtinyint头像宽度avatarheighttinyint头像高度biotext生日signaturetext个人签名sightmltext解析后的签名ignorepmtext忽略人员grouptermstext公共用户组authstrvarcharEmail认证串cdb_members会员表uidmediumint会员IDusernamechar用户名passwordchar密码secqueschar安全码gendertinyint性别adminidtinyint管理员IDgroupidsmallint会员组IDgroupexpiryint用户组有效期extgroupidschar扩展用户组regipchar注册IPregdateint注册时间lastipchar最后登录IPlastvisitint最后访问lastactivityint最后活动lastpostint最后发表postsmediumint帖子数digestpostssmallint精华数oltimesmallint在线时间pageviewsmediumint页面访问量creditsint总积分extcredits1int声望extcredits2int金钱extcredits3int扩展extcredits4int扩展extcredits5int扩展extcredits6int扩展extcredits7int扩展extcredits8int扩展avatarshowidint天下秀IDemailchar邮箱bdaydate生日sigstatustinyint签名状态tpptinyint每页显示主题数ppptinyint每页显示帖子数styleidsmallint风格IDdateformatchar日期格式timeformattinyint时间格式pmsoundtinyint短信声音showemailtinyint是否公开邮箱newslettertinyint是否接受论坛通知invisibletinyint是否隐身登录timeoffsetchar时区校正newpmtinyint是否有新短信息accessmaskstinyint标志editormodetinyint编辑器模式customshowtinyint自定义帖子显示模式xspacestatustinyintsupe状态cdb_moderators版主表uidmediumint会员IDfidsmallint论坛IDdisplayordertinyint显示顺序inheritedtinyint是否继承cdb_modworks论坛管理统计表uidmediumint会员IDmodactionchar动作datelinedate时间段countsmallint登录次数postssmallint发表数cdb_myposts我的帖子表uidmediumint会员IDtidmediumint主题IDpidint帖子IDpositionsmallint楼层datelineint帖子发表时间cdb_mythreads我的主题表uidmediumint会员IDtidmediumint主题IDdatelineint主题发表时间cdb_onlinelist在线列表定制groupidsmallint会员组IDdisplayordertinyint显示顺序titlevarchar组名称urlvarchar图例URLcdb_onlinetime在线时间表uidmediumint会员IDthismonthsmallint本月在线时间totalmediumint总计在线时间lastupdateint最后访问时间cdb_orders订单信息表orderidchar订单号IDstatuschar状态buyerchar购买者姓名adminchar补单管理员姓名uidmediumint购买者IDamountint数量pricefloat价格submitdateint提交日期confirmdateint确认日期cdb_paymentlog帖子买卖日志uidmediumint会员IDtidmediumint主题IDauthoridmediumint作者IDdatelineint帖子买卖时间amountint价格netamountint作者收入cdb_pluginhooks插件HOOK表pluginhookidmediumint钩子IDpluginidsmallint插件IDavailabletinyint是否启用titlevarchar标题descriptionmediumtext解释说明codemediumtext代码cdb_plugins插件表pluginidsmallint插件IDavailabletinyint是否启用adminidtinyint管理员IDnamevarchar名称identifiervarchar唯一标识符descriptionvarchar解释说明datatablesvarchar插件数据表directoryvarchar插件目录copyrightvarchar版权信息modulestext插件信息cdb_pms短信息表pmidint短信息IDmsgfromvarchar发送人姓名msgfromidmediumint发送人IDmsgtoidmediumint接受者IDfolderenum文件夹newtinyint是否新短信subjectvarchar标题datelineint发送日期messagetext消息cdb_pmsearchindex短信息查找缓存表searchidint查找IDkeywordsvarchar关键字searchstringvarchar查找字符串uidmediumint会员IDdatelineint查找时间expirationint过期时间pmssmallint短信pmidstext短信ID序列cdb_polloptions投票选项表polloptionidint选项IDtidmediumint主题IDvotesmediumint票数displayordertinyint显示顺序polloptionvarchar选项内容voteridsmediumtext投票人IDcdb_polls投票表tidmediumint主题IDmultipletinyint是否多选visibletinyint是否投票可见maxchoicestinyint最大可选项数expirationint过期时间

npcomet 发表于 2007-11-13 21:15:50

cdb_posts帖子表pidint帖子IDfidsmallint论坛IDtidmediumint主题IDfirsttinyint是否是首贴authorvarchar作者姓名authoridmediumint作者IDsubjectvarchar标题datelineint发表时间messagemediumtext消息useipvarchar发帖者IPinvisibletinyint是否通过审核anonymoustinyint是否匿名usesigtinyint是否启用签名htmlontinyint是否允许HTMLbbcodeofftinyint是否关闭BBCODEsmileyofftinyint是否关闭表情parseurlofftinyint是否允许粘贴URLattachmenttinyint附件ratesmallint评分分数ratetimestinyint评分次数cdb_profilefields个人信息扩展表fieldidsmallint数据IDavailabletinyint是否可用invisibletinyint是否隐藏titlevarchar栏目标题descriptionvarchar解释说明sizetinyint内容最大长度displayordersmallint显示顺序requiredtinyint必填内容unchangeabletinyint不可修改showinthreadtinyint在帖子中显示selectivetinyint是否可选choicestext选填内容cdb_promotions论坛推广ipcharIP地址uidmediumint会员IDusernamechar会员名cdb_pushedthreads推送表idmediumint推送IDtidmediumint主题IDstatustinyint推送状态datelineint推送时间subjectchar主题messagetext信息cdb_ranks级别表rankidsmallint级别IDranktitlevarchar级别头衔postshighermediumint发帖数阀值starstinyint星星数colorvarchar颜色cdb_ratelog帖子评分记录表pidint帖子IDuidmediumint会员IDusernamechar会员名extcreditstinyint评分字段datelineint评分时间scoresmallint分数reasonchar操作理由cdb_regips注册IP限制表ipcharIP地址datelineint限制时间countsmallint限制数量cdb_relatedthreads相关主题表tidmediumint主题IDexpirationint过期时间keywordsvarchar关键字relatedthreadstext相关主题序列cdb_rewardlog悬赏日志表tidmediumint主题IDauthoridmediumint作者IDanswereridmediumint回答者IDdatelineint悬赏发布时间netamountint悬赏金额cdb_rsscachesrss缓存表lastupdateint最后更新时间fidsmallint论坛IDtidmediumint主题IDdatelineint发表时间forumchar论坛名称authorchar作者subjectchar标题descriptionchar解释说明cdb_searchindex搜索缓存表searchidint缓存IDkeywordsvarchar关键字searchstringvarchar查找字符串useipvarchar搜索人IPuidmediumint会员IDdatelineint搜索时间expirationint过期时间threadssmallint主题数量tidstext主题ID序列cdb_sessions会员认证表sidcharSIDip1tinyintIP段ip2tinyintIP段ip3tinyintIP段ip4tinyintIP段uidmediumint会员IDusernamechar会员名groupidsmallint会员组styleidsmallint风格IDinvisibletinyint是否隐身登录actiontinyint当前动作lastactivityint最后活动时间lastolupdateint最后更新时间pageviewssmallint页面访问量seccodesmallint记录验证码fidsmallint论坛IDtidmediumint主题IDbloguidmediumint正在浏览的文集cdb_settings设置表variablevarchar变量名valuetext值cdb_smilies表情表idsmallint表情IDdisplayordertinyint显示顺序typeenum类型codevarchar标记urlvarchar路径cdb_stats统计表typechar类型variablechar变量名countint数量cdb_statvars统计变量表typevarchar类型variablevarchar变量名valuemediumtext值cdb_styles风格表styleidsmallint namevarchar availabletinyint templateidsmallint cdb_stylevars风格变量表stylevaridsmallint风格变量IDstyleidsmallint风格IDvariabletext变量名substitutetext变量赋值cdb_subscriptions论坛订阅表uidmediumint会员IDtidmediumint主题IDlastpostint最后发表lastnotifyint上次通知时间cdb_templates模版表templateidsmallint模板IDnamevarchar名称directoryvarchar目录copyrightvarchar版权cdb_threads主题表tidmediumint主题IDfidsmallint上级论坛iconidsmallint图标typeidsmallint主题分类IDreadpermtinyint阅读权限pricesmallint价格authorchar会员名authoridmediumint会员IDsubjectchar标题datelineint发表时间lastpostint最后发表lastposterchar最后发表人IDviewsint浏览次数repliesmediumint回复次数displayordertinyint显示顺序highlighttinyint是否高亮digesttinyint是否精华ratetinyint是否评分blogtinyint是否加入文集specialtinyint特殊主题attachmenttinyint附件subscribedtinyint是否被订阅moderatedtinyint是否被管理员改动closedmediumint是否关闭itemidmediumintsupe关联IDsupe_pushstatustinyintsupe推送状态cdb_threadsmod主题管理记录表tidmediumint主题IDuidmediumint会员IDusernamechar会员名datelineint操作时间expirationint有效时间actionchar操作statustinyint状态cdb_threadtypes主题分类表typeidsmallint主题分类IDdisplayordertinyint显示顺序namevarchar名称descriptionvarchar解释说明cdb_tradelog交易记录表tidmediumint主题IDorderidchar订单号IDtradenochar支付宝订单号subjectchar标题pricedecimal价格qualitytinyint成色itemtypetinyint商品类型numbersmallint数量taxdecimal交易手续费locuschar物品所在地selleridmediumint卖家IDsellerchar卖家名selleraccountchar卖家交易帐号buyeridmediumint卖家IDbuyerchar买家名buyercontactchar买家联系方式buyercreditssmallint买家暂扣积分buyermsgchar买家留言statustinyint状态lastupdateint状态最后更新cdb_trades交易表tidmediumint主题IDselleridmediumint买家IDsellerchar买家名accountchar买家帐号subjectchar标题pricedecimal价格amountsmallint数量qualitytinyint成色locuschar所在地transporttinyint物流方式ordinaryfeesmallint平邮附加费expressfeesmallint快递附加费emsfeesmallintEMS附加费itemtypetinyint商品类型datelineint交易时间expirationint过期时间lastbuyerchar最后买家用户名lastupdateint最后交易时间totalitemssmallint总交易量tradesumdecimal总交易额closedtinyint是否关闭cdb_usergroups会员用户组表groupidsmallint会员组IDradminidtinyint关联关管理组typeenum类型systemchar会员是否可以自由进出grouptitlechar组头衔creditshigherint该组的积分上限creditslowerint该组的积分下限starstinyint星星数量colorchar组头衔颜色groupavatarchar组头像图标readaccesstinyint阅读权限allowvisittinyint允许访问allowposttinyint允许发帖allowreplytinyint允许回复allowpostpolltinyint允许发表投票allowpostrewardtinyint允许发表悬赏allowposttradetinyint允许发表交易allowpostactivitytinyint允许发表活动allowdirectposttinyint是否需要审核allowgetattachtinyint允许下载附件allowpostattachtinyint允许上传附件allowvotetinyint允许参与投票allowmultigroupstinyint允许加入/离开公共用户组allowsearchtinyint允许搜索allowavatartinyint允许使用头像allowcstatustinyint允许自定义头衔allowuseblogtinyint允许使用论坛文集allowinvisibletinyint允许隐身登录allowtransfertinyint允许积分转帐allowsetreadpermtinyint允许设置阅读权限allowsetattachpermtinyint允许设置附件权限allowhidecodetinyint允许使用hide代码allowhtmltinyint允许使用htmlallowcusbbcodetinyint允许使用自定义bbocdeallowanonymoustinyint允许匿名发帖allownicknametinyint允许使用昵称allowsigbbcodetinyint允许签名使用bbocdeallowsigimgcodetinyint允许使用imgallowviewprotinyint允许查看会员资料allowviewstatstinyint允许查看统计数据disableperiodctrltinyint不受时间段限制reasonpmtinyint操作理由短信通知作者maxpricesmallint主题最大售价maxpmnumsmallint邮箱最大容量maxsigsizesmallint最大签名尺寸maxattachsizemediumint最大附件尺寸maxsizeperdayint每天最大附件总尺寸maxpostsperhourtinyint每小时发帖数限制attachextensionschar允许发表的附件类型raterangechar评分范围tradetaxtypetinyint交易手续费类型tradetaxssmallint交易手续费mintradepricesmallint交易最小积分maxtradepricesmallint交易最大积分minrewardpricesmallint悬赏最小积分maxrewardpricesmallint悬赏最大积分cdb_validating用户审核表uidmediumint会员IDsubmitdateint提交日期moddateint审核日期adminvarchar管理员名submittimestinyint提交的次数statustinyint状态messagetext注册原因remarktext管理员留言cdb_words词语过滤表idsmallint词汇IDadminvarchar管理员名findvarchar不良词语replacementvarchar替换内容

suxiangkun 发表于 2008-6-8 01:41:38

继续:)~~~~~~~

sejishikong 发表于 2011-11-3 11:18:08

disuz! 太烦人了。
页: [1]
查看完整版本: Discuz!5数据库结构说明