"数据字典(非官方版)ForDiscuz!6.0",,,,

查看ip  时间:2021-03-22  阅读:()
"ByIFS-Simon(习明)2007.
11.
14",,,,,,,,"cdb_access用户版块权限表",,,,"表说明:设置某一用户对某一版块的用户权限.
",,,,"字段","类型","Null","默认","注释""uid","mediumint(8)","否","0","关联主键,特殊用户的UID""fid","smallint(6)","否","0","关联主键,版块的FID""allowview","tinyint(1)","否","0","浏览版块许可""allowpost","tinyint(1)","否","0","发新话题许可""allowreply","tinyint(1)","否","0","发表回复许可""allowgetattach","tinyint(1)","否","0","下载/查看许可""allowpostattach","tinyint(1)","否","0","上传许可",,,,"cdb_activities活动表",,,,"表说明:记录活动主题的活动相关数据.
",,,,"字段","类型","Null","默认","注释""tid","mediumint(8)","否","0","主键,活动主题的TID""uid","mediumint(8)","否","0","索引,发布活动者UID""cost","mediumint(8)","否","0","每人花销""starttimefrom","int(10)","否","0","开始时间(起始点)""starttimeto","int(10)","否","0","开始时间(终止点,如确定开始时间则为0)","place","char(40)","否",,"活动地点""class","char(20)","否",,"活动类别""gender","tinyint(1)","否","0","性别要求(0=不限,1=男,2=女)""number","smallint(5)","否","0","需要人数""expiration","int(10)","否","0","征集截止日期",,,,"cdb_activityapplies活动申请表",,,,"表说明:记录参与活动主题的申请数据.
",,,,"字段","类型","Null","默认","注释""applyid","int(10)","否",,"主键,活动申请编号,自增""tid","mediumint(8)","否","0","索引,活动主题的TID""username","char(15)","否",,"申请者的用户名""uid","mediumint(8)","否","0","索引,申请者的UID""message","char(200)","否",,"申请者留言""verified","tinyint(1)","否","0","审核""dateline","int(10)","否","0","索引,申请时间""payment","mediumint(8)","否","0","申请者支付费用""contact","char(200)","否",,"申请者联系方式",,,,"cdb_adminactions关联管理员权限表",,,,"表说明:当特殊用户组管理权限关联为管理员时,记录该组无权使用的功能.
",,,,"字段","类型","Null","默认","注释""admingid","smallint(6)","否","0","主键,关联为管理员的用户组GID""disabledactions","text","否",,"关联后的受限功能",,,,"cdb_admingroups管理组表",,,,"表说明:记录管理组的管理权限.
",,,,"字段","类型","Null","默认","注释""admingid","smallint(6)","否","0","主键,管理组GID""alloweditpost","tinyint(1)","否","0","允许编辑帖子""alloweditpoll","tinyint(1)","否","0","允许编辑投票""allowstickthread","tinyint(1)","否","0","允许置顶帖子(最高置顶等级)""allowmodpost","tinyint(1)","否","0","允许审核帖子""allowdelpost","tinyint(1)","否","0","允许删除帖子""allowmassprune","tinyint(1)","否","0","允许批量删贴""allowrefund","tinyint(1)","否","0","允许强制退款""allowcensorword","tinyint(1)","否","0","允许过滤词语""allowviewip","tinyint(1)","否","0","允许查看IP""allowbanip","tinyint(1)","否","0","允许禁止IP""allowedituser","tinyint(1)","否","0","允许编辑用户""allowmoduser","tinyint(1)","否","0","允许审核用户""allowbanuser","tinyint(1)","否","0","允许禁止用户""allowpostannounce","tinyint(1)","否","0","允许发布公告""allowviewlog","tinyint(1)","否","0","允许查看记录""allowbanpost","tinyint(1)","否","0","允许屏蔽帖子""disablepostctrl","tinyint(1)","否","0","发帖不受限制""supe_allowpushthread","tinyint(1)","否","0","允许推送主题到SS",,,,"cdb_adminnotes后台管理公告表",,,,"表说明:记录后台管理公告.
",,,,"字段","类型","Null","默认","注释""id","mediumint(8)","否",,"主键,后台管理公告编号,自增""admin","varchar(15)","否",,"公告发布者用户名""access","tinyint(3)","否","0","公告查看权限级别""adminid","tinyint(3)","否","0","公告发布者UID""dateline","int(10)","否","0","公告发布时间""expiration","int(10)","否","0","公告有效期""message","text","否",,"公告内容",,,,"cdb_adminsessions后台会话表",,,,"表说明:记录后台会话.
",,,,"字段","类型","Null","默认","注释""uid","mediumint(8)","否","0","登录后台用户UID""ip","char(15)","否",,"登录者IP""dateline","int(10)","否","0","最后活动时间""errorcount","tinyint(1)","否","0","登录密码错误计数",,,,"cdb_advertisements广告表",,,,"表说明:记录广告相关信息,广告参数为不同类型广告设置的参数及内容的serialize值,广告代码为根据广告参数生成的HTML.
",,,,"字段","类型","Null","默认","注释""advid","mediumint(8)","否",,"主键,广告编号,自增""available","tinyint(1)","否","0","广告可用""type","varchar(50)","否","0","广告类型""displayorder","tinyint(3)","否","0","广告显示顺序""title","varchar(50)","否",,"广告标题""targets","text","否",,"广告投放范围""parameters","text","否",,"广告参数""code","text","否",,"广告代码""starttime","int(10)","否","0","广告起始时间""endtime","int(10)","否","0","广告起始时间",,,,"cdb_announcements公告表",,,,"表说明:记录论坛公告信息.
",,,,"字段","类型","Null","默认","注释""id","smallint(6)","否",,"主键,公告编号,自增""author","varchar(15)","否",,"公告发布者用户名""subject","varchar(250)","否",,"公告标题""type","tinyint(1)","否","0","公告类型(0=文字1=链接2=消息)""displayorder","tinyint(3)","否","0","公告显示顺序""starttime","int(10)","否","0","公告起始时间""endtime","int(10)","否","0","公告终止时间""message","text","否",,"公告内容""groups","text","否",,"公告受众用户组",,,,"cdb_attachments表",,,,"表说明:记录帖子信息,filetype会因浏览器不同有所区别,filesize为服务器实际保存的文件大小.
",,,,"字段","类型","Null","默认","注释""aid","mediumint(8)","否",,"主键,编号,自增""tid","mediumint(8)","否","0","索引,所在主题TID""pid","int(10)","否","0","索引,所在帖子PID""dateline","int(10)","否","0","发布时间""readperm","tinyint(3)","否","0","阅读权限""price","smallint(6)","否","0","售价""filename","char(100)","否",,"文件名""description","char(100)","否",,"简介""filetype","char(50)","否",,"文件类型(MIMEContent-Type)""filesize","int(10)","否","0","文件大小(字节)""attachment","char(100)","否",,"URL""downloads","mediumint(8)","否","0","下载次数""isimage","tinyint(1)","否","0","图片""uid","mediumint(8)","否","0","索引,上传者UID""thumb","tinyint(1)","否","0","生成缩略图""remote","tinyint(1)","否","0","远程",,,,"cdb_attachpaymentlog付费记录表",,,,"表说明:记录帖子下载付费信息.
",,,,"字段","类型","Null","默认","注释""uid","mediumint(8)","否","0","关联主键,下载付费用户的UID""aid","mediumint(8)","否","0","关联主键,索引,被下载的AID""authorid","mediumint(8)","否","0","索引,上传者UID""dateline","int(10)","否","0","付费时间""amount","int(10)","否","0","付费总金额""netamount","int(10)","否","0","税后金额",,,,"cdb_attachtypes类型表",,,,"表说明:记录允许使用的类型信息.
",,,,"字段","类型","Null","默认","注释""id","smallint(6)","否",,"主键,类型编号,自增""extension","char(12)","否",,"类型扩展名""maxsize","int(10)","否","0","最大尺寸",,,,"cdb_banned禁止IP表",,,,"表说明:记录禁止IP操作信息.
",,,,"字段","类型","Null","默认","注释""id","smallint(6)","否",,"主键,禁止IP操作编号,自增""ip1","smallint(3)","否","0","ip字段1""ip2","smallint(3)","否","0","ip字段2""ip3","smallint(3)","否","0","ip字段3""ip4","smallint(3)","否","0","ip字段4""admin","varchar(15)","否",,"操作者用户名""dateline","int(10)","否","0","操作时间""expiration","int(10)","否","0","禁止有效期",,,,"cdb_bbcodes自定义代码表",,,,"表说明:记录自定义Discuz!
代码信息.
",,,,"字段","类型","Null","默认","注释""id","mediumint(8)","否",,"主键,代码编号,自增""available","tinyint(1)","否","0","代码可用""tag","varchar(100)","否",,"代码标签""icon","varchar(255)","否",,"代码图标文件""replacement","text","否",,"代码替换内容""example","varchar(255)","否",,"代码例子""explanation","text","否",,"代码解释""params","tinyint(1)","否","1","代码参数个数""prompt","text","否",,"代码参数提示语""nest","tinyint(3)","否","1","代码嵌套次数",,,,"cdb_buddys好友表",,,,"表说明:记录用户好友信息.
",,,,"字段","类型","Null","默认","注释""uid","mediumint(8)","否","0","索引,添加好友者UID""buddyid","mediumint(8)","否","0","好友UID""grade","tinyint(3)","否","1","好友等级(SS相关)""dateline","int(10)","否","0","添加好友时间""description","char(255)","否",,"好友备注",,,,"cdb_caches缓存数据表",,,,"表说明:记录缓存更新数据.
",,,,"字段","类型","Null","默认","注释""cachename","varchar(32)","否",,"主键,缓存名称""type","tinyint(3)","否",,"缓存类型(SS相关)""dateline","int(10)","否",,"最后更新时间""expiration","int(10)","否",,"有效期""data","mediumtext","否",,"缓存数据",,,,"cdb_campaignsInsenz活动表",,,,"表说明:略.
",,,,"字段","类型","Null","默认","注释""id","mediumint(8)","否",,"type","tinyint(1)","否",,"fid","smallint(6)","否",,"tid","mediumint(8)","否",,"status","tinyint(1)","否","0","begintime","int(10)","否",,"starttime","int(10)","否",,"endtime","int(10)","否",,"expiration","int(10)","否",,"nextrun","int(10)","否",,,,,,"cdb_creditslog积分交易记录表",,,,"表说明:记录积分交易信息,包括积分转帐、积分兑换等操作.
",,,,"字段","类型","Null","默认","注释""uid","mediumint(8)","否","0","索引,操作用户UID""fromto","char(15)","否",,"目标用户的用户名""sendcredits","tinyint(1)","否","0","支出积分类型""receivecredits","tinyint(1)","否","0","收入积分类型""send","int(10)","否","0","支出额""receive","int(10)","否","0","收入额""dateline","int(10)","否","0","交易时间""operation","char(3)","否",,"操作代码",,,,"cdb_crons计划任务表",,,,"表说明:记录计划任务信息.
",,,,"字段","类型","Null","默认","注释""cronid","smallint(6)","否",,"主键,计划任务编号,自增""available","tinyint(1)","否","0","计划任务可用""type","enum('user','system')","否","user","计划任务类型(user=自定义system=系统)""name","char(50)","否",,"计划任务名称""filename","char(50)","否",,"计划任务脚本文件名""lastrun","int(10)","否","0","上次执行时间""nextrun","int(10)","否","0","下次执行时间""weekday","tinyint(1)","否","0","执行时间:星期""day","tinyint(2)","否","0","执行时间:日""hour","tinyint(2)","否","0","执行时间:小时""minute","char(36)","否",,"执行时间:分钟",,,,"cdb_debateposts辩论观点表",,,,"表说明:记录辩论观点信息.
",,,,"字段","类型","Null","默认","注释""pid","int(10)","否","0","主键,索引,发布观点的帖子PID""stand","tinyint(1)","否","0","观点属性(0=中立1=正方2=反方)""tid","mediumint(8)","否","0","索引,辩论主题TID""uid","mediumint(8)","否","0","观点发布者UID""dateline","int(10)","否","0","发布时间""voters","mediumint(10)","否","0","支持人数""voterids","text","否",,"支持者UID组(\t分隔)",,,,"cdb_debates辩论主题表",,,,"表说明:记录辩论主题信息.
",,,,"字段","类型","Null","默认","注释""tid","mediumint(8)","否","0","主键,辩论主题TID""uid","mediumint(8)","否","0","索引,辩论发起者UID""starttime","int(10)","否","0","辩论发起时间""endtime","int(10)","否","0","辩论截止时间""affirmdebaters","mediumint(8)","否","0","正方辩手人数""negadebaters","mediumint(8)","否","0","反方辩手人数""affirmvotes","mediumint(8)","否","0","正方支持得票""negavotes","mediumint(8)","否","0","反方支持得票""umpire","varchar(15)","否",,"裁判用户名""winner","tinyint(1)","否","0","获胜方(0=未结束1=正方2=反方3=平局)""bestdebater","varchar(50)","否",,"最佳辩手综合信息""affirmpoint","text","否",,"正方观点""negapoint","text","否",,"反方观点""umpirepoint","text","否",,"裁判观点""affirmvoterids","text","否",,"正方支持者UID组(\t分隔)""negavoterids","text","否",,"反方支持者UID组(\t分隔)""affirmreplies","mediumint(8)","否",,"正方发言数""negareplies","mediumint(8)","否",,"反方发言数",,,,"cdb_failedlogins登录失败记录表",,,,"表说明:记录登录失败情况,成功登录后删除失败记录.
",,,,"字段","类型","Null","默认","注释""ip","char(15)","否",,"主键,登录失败者IP""count","tinyint(1)","否","0","登录失败次数""lastupdate","int(10)","否","0","最后一次登录失败时间",,,,"cdb_faqs论坛帮助表",,,,"表说明:记录论坛帮助信息.
",,,,"字段","类型","Null","默认","注释""id","smallint(6)","否",,"主键,论坛帮助编号,自增""fpid","smallint(6)","否","0","上级分类ID""displayorder","tinyint(3)","否","0","索引,显示顺序""identifier","varchar(20)","否",,"帮助标识""keyword","varchar(50)","否",,"帮助关键字""title","varchar(50)","否",,"帮助标题""message","text","否",,"帮助内容",,,,"cdb_favorites收藏表",,,,"表说明:记录用户收藏的主题或版块,每条记录中tid、fid之一为0.
",,,,"字段","类型","Null","默认","注释""uid","mediumint(8)","否","0","索引,收藏者UID""tid","mediumint(8)","否","0","被收藏的主题TID""fid","smallint(6)","否","0","被收藏的版块FID",,,,"cdb_forumfields论坛版块扩展表",,,,"表说明:记录论坛版块的扩展信息,标有*的字段为serialize值,标有**的字段为\t分隔.
",,,,"字段","类型","Null","默认","注释""fid","smallint(6)","否","0","主键,版块FID""description","text","否",,"版块简介内容""password","varchar(12)","否",,"版块访问密码""icon","varchar(255)","否",,"版块图标""postcredits","varchar(255)","否",,"发主题积分策略""replycredits","varchar(255)","否",,"回复积分策略""getattachcredits","varchar(255)","否",,"下载积分策略""postattachcredits","varchar(255)","否",,"上传积分策略""digestcredits","varchar(255)","否",,"加精华积分策略""redirect","varchar(255)","否",,"版块转向URL""attachextensions","varchar(255)","否",,"版块允许类型""formulaperm","text","否",,"版块权限表达式信息""moderators","text","否",,"版主用户名组**""rules","text","否",,"版块规则内容""threadtypes","text","否",,"版块使用的主题分类及参数*""viewperm","text","否",,"浏览权限用户组**""postperm","text","否",,"发主题权限用户组**""replyperm","text","否",,"回复权限用户组**""getattachperm","text","否",,"下载权限用户组**""postattachperm","text","否",,"上传权限用户组**""keywords","text","否",,"版块关键词""supe_pushsetting","text","否",,"SS主题推送设定*""modrecommend","text","否",,"版主推荐功能参数*""tradetypes","text","否",,"商品分类设定*""typemodels","mediumtext","否",,"分类信息模型设定*",,,,"cdb_forumlinks联盟论坛表",,,,"表说明:记录联盟论坛信息.
",,,,"字段","类型","Null","默认","注释""id","smallint(6)","否",,"主键,联盟论坛编号,自增""displayorder","tinyint(3)","否","0","显示顺序""name","varchar(100)","否",,"联盟论坛名称""url","varchar(100)","否",,"联盟论坛URL""description","mediumtext","否",,"联盟论坛文字说明""logo","varchar(100)","否",,"联盟论坛LOGO地址",,,,"cdb_forumrecommend版主推荐表",,,,"表说明:记录版主推荐主题信息.
",,,,"字段","类型","Null","默认","注释""fid","smallint(6)","否",,"主题所在版块FID""tid","mediumint(8)","否",,"主键,推荐主题TID""displayorder","tinyint(1)","否",,"索引,推荐主题显示顺序""subject","char(80)","否",,"推荐主题标题""author","char(15)","否",,"推荐主题作者用户名""authorid","mediumint(8)","否",,"推荐主题作者UID""moderatorid","mediumint(8)","否",,"推荐者UID""expiration","int(10)","否",,"推荐有效期",,,,"cdb_forums论坛版块表",,,,"表说明:记录论坛版块信息.
",,,,"字段","类型","Null","默认","注释""fid","smallint(6)","否",,"主键,论坛版块编号,自增""fup","smallint(6)","否","0","索引,上级版块编号""type","enum('group','forum','sub')","否","forum","版块类型(group=分区forum=版块sub=子版块)""name","char(50)","否",,"版块名称""status","tinyint(1)","否","0","显示版块""displayorder","tinyint(3)","否","0","显示顺序""styleid","smallint(6)","否","0","风格方案""threads","mediumint(8)","否","0","主题数""posts","mediumint(8)","否","0","帖数""todayposts","mediumint(8)","否","0","今日发表""lastpost","char(110)","否",,"最后发表""allowsmilies","tinyint(1)","否","0","允许使用表情""allowhtml","tinyint(1)","否","0","允许使用HTML代码""allowbbcode","tinyint(1)","否","0","允许使用Discuz!
代码""allowimgcode","tinyint(1)","否","0","允许使用[img]代码""allowmediacode","tinyint(1)","否","0","允许使用[media]代码""allowanonymous","tinyint(1)","否","0","允许匿名发帖""allowshare","tinyint(1)","否","0","允许其它模块共享""allowpostspecial","smallint(6)","否","0","允许发布的特殊主题""allowspecialonly","tinyint(1)","否","0","只允许发布特殊类型主题""alloweditrules","tinyint(1)","否","0","允许版主修改版块规则""recyclebin","tinyint(1)","否","0","开启主题回收站""modnewposts","tinyint(1)","否","0","发帖审核""jammer","tinyint(1)","否","0","启用内容干扰码""disablewatermark","tinyint(1)","否","0","禁用图片添加水印""inheritedmod","tinyint(1)","否","0","版主权力继承到下级版块""autoclose","smallint(6)","否","0","自动关闭时间(天)""forumcolumns","tinyint(3)","否","0","下级版块横排列数""threadcaches","tinyint(1)","否","0","页面缓存系数""allowpaytoauthor","tinyint(1)","否","1","显示"用支付宝求购"按钮""alloweditpost","tinyint(1)","否","1","允许编辑帖子""simple","tinyint(1)","否",,"只显示下级子版块",,,,"cdb_imagetypes图片分类表",,,,"表说明:记录图片分类信息.
现在只有表情分类功能,貌似会增加主题图标和用户头像的分类.
",,,,"字段","类型","Null","默认","注释""typeid","smallint(6)","否",,"主键,图片分类编号,自增""name","char(20)","否",,"图片分类名称""type","enum('smiley','icon','avatar')","否","smiley","分类归属(smiley=表情)""displayorder","tinyint(3)","否","0","显示顺序""directory","char(100)","否",,"所在目录",,,,"cdb_invites邀请注册数据表",,,,"表说明:记录邀请注册信息.
",,,,"字段","类型","Null","默认","注释""uid","mediumint(8)","否","0","索引,邀请码购买者的UID""dateline","int(10)","否","0","邀请码购买时间""expiration","int(10)","否","0","邀请码有效期""inviteip","char(15)","否",,"邀请码购买者IP""invitecode","char(16)","否",,"索引,邀请码""reguid","mediumint(8)","否","0","受邀者UID""regdateline","int(10)","否","0","受邀者注册时间""status","tinyint(1)","否","1","邀请码状态(1=未使用2=已用3=已发送4=过期)",,,,"cdb_itempool验证问答表",,,,"表说明:记录验证问答信息.
问答类型好像是预留的.
",,,,"字段","类型","Null","默认","注释""id","smallint(6)","否",,"主键,验证问答编号,自增""type","tinyint(1)","否",,"验证问答类型""question","text","否",,"验证问题""answer","varchar(50)","否",,"验证答案",,,,"cdb_magiclog道具记录表",,,,"表说明:记录道具购买使用等信息.
",,,,"字段","类型","Null","默认","注释""uid","mediumint(8)","否","0","索引,道具所有者UID""magicid","smallint(6)","否","0","道具ID""action","tinyint(1)","否","0","操作""dateline","int(10)","否","0","操作时间""amount","smallint(6)","否","0","操作数量""price","mediumint(8)","否","0","价格""targettid","mediumint(8)","否","0","目标主题TID""targetpid","int(10)","否","0","目标帖子PID""targetuid","mediumint(8)","否","0","索引,目标用户UID",,,,"cdb_magicmarket道具市场数据表",,,,"表说明:记录道具市场中待售道具信息.
",,,,"字段","类型","Null","默认","注释""mid","smallint(6)","否",,"主键,道具出售编号,自增""magicid","smallint(6)","否","0","所售道具MAGICID""uid","mediumint(8)","否","0","索引,卖家UID""username","char(15)","否",,"卖家用户名""price","mediumint(8)","否","0","索引,售价""num","smallint(6)","否","0","索引,出售数量",,,,"cdb_magics道具数据表",,,,"表说明:记录道具信息.
Magicperm为serialize值",,,,"字段","类型","Null","默认","注释""magicid","smallint(6)","否",,"主键,道具编号,自增""available","tinyint(1)","否","0","可用""type","tinyint(3)","否","0","道具分类""name","varchar(50)","否",,"道具名称""identifier","varchar(40)","否",,"道具标识""description","varchar(255)","否",,"道具描述""displayorder","tinyint(3)","否","0","显示顺序""price","mediumint(8)","否","0","道具价格""num","smallint(6)","否","0","道具数量""salevolume","smallint(6)","否","0","售出数量""supplytype","tinyint(1)","否","0","自动补货方式""supplynum","smallint(6)","否","0","自动补货数量""weight","tinyint(3)","否","1","道具重量""filename","varchar(50)","否",,"任务脚本""magicperm","text","否",,"道具权限",,,,"cdb_medals勋章表",,,,"表说明:记录勋章信息.
",,,,"字段","类型","Null","默认","注释""medalid","smallint(6)","否",,"主键,勋章编号,自增""name","varchar(50)","否",,"勋章名称""available","tinyint(1)","否","0","可用""image","varchar(30)","否",,"勋章图片",,,,"cdb_memberfields会员扩展表",,,,"表说明:记录会员扩展信息.
Medals为\t分隔,groupterms为serialize值",,,,"字段","类型","Null","默认","注释""uid","mediumint(8)","否","0","主键,会员UID""nickname","varchar(30)","否",,"会员昵称""site","varchar(75)","否",,"个人网站""alipay","varchar(50)","否",,"支付宝帐号""icq","varchar(12)","否",,"ICQ""qq","varchar(12)","否",,"QQ""yahoo","varchar(40)","否",,"YAHOO""msn","varchar(40)","否",,"MSN""taobao","varchar(40)","否",,"阿里旺旺""location","varchar(30)","否",,"来自""customstatus","varchar(30)","否",,"自定义头衔""medals","varchar(255)","否",,"获得的勋章""avatar","varchar(255)","否",,"头像""avatarwidth","tinyint(3)","否","0","头像宽""avatarheight","tinyint(3)","否","0","头像高""bio","text","否",,"自我介绍""sightml","text","否",,"个性签名""ignorepm","text","否",,"站内短消息忽略列表""groupterms","text","否",,"用户组有效期""authstr","varchar(20)","否",,"用户激活码""spacename","varchar(40)","否",,"MiniSpace名称""buyercredit","smallint(6)","否","0","卖家信用积分""sellercredit","smallint(6)","否","0","买家信用积分",,,,"cdb_membermagics会员道具表",,,,"表说明:记录会员持有道具信息.
",,,,"字段","类型","Null","默认","注释""uid","mediumint(8)","否","0","索引,会员UID""magicid","smallint(6)","否","0","道具MAGICID""num","smallint(6)","否","0","持有数量",,,,"cdb_members会员表",,,,"表说明:记录会员信息.
",,,,"字段","类型","Null","默认","注释""uid","mediumint(8)","否",,"主键,会员编号,自增""username","char(15)","否",,"唯一,会员用户名""password","char(32)","否",,"会员密码""secques","char(8)","否",,"用户安全问答""gender","tinyint(1)","否","0","性别(0=保密1=男2=女)""adminid","tinyint(1)","否","0","管理组GID""groupid","smallint(6)","否","0","索引,用户组GID""groupexpiry","int(10)","否","0","用户组有效期""extgroupids","char(20)","否",,"扩展用户组""regip","char(15)","否",,"注册IP""regdate","int(10)","否","0","注册时间""lastip","char(15)","否",,"最后访问IP""lastvisit","int(10)","否","0","最后访问时间""lastactivity","int(10)","否","0","最后活动时间""lastpost","int(10)","否","0","最后发表时间""posts","mediumint(8)","否","0","发帖数""digestposts","smallint(6)","否","0","精华数""oltime","smallint(6)","否","0","在线时间""pageviews","mediumint(8)","否","0","页面浏览量""credits","int(10)","否","0","积分""extcredits1","int(10)","否","0","扩展积分1""extcredits2","int(10)","否","0","扩展积分2""extcredits3","int(10)","否","0","扩展积分3""extcredits4","int(10)","否","0","扩展积分4""extcredits5","int(10)","否","0","扩展积分5""extcredits6","int(10)","否","0","扩展积分6""extcredits7","int(10)","否","0","扩展积分7""extcredits8","int(10)","否","0","扩展积分8""email","char(40)","否",,"索引,EMAIL""bday","date","否","0000-00-00","生日""sigstatus","tinyint(1)","否","0","拥有签名""tpp","tinyint(3)","否","0","主题列表每页主题数""ppp","tinyint(3)","否","0","主题页面每页帖数""styleid","smallint(6)","否","0","界面风格""dateformat","tinyint(1)","否","0","日期格式""timeformat","tinyint(1)","否","0","时间格式""pmsound","tinyint(1)","否","0","短消息提示音""showemail","tinyint(1)","否","0","EMAIL地址可见""newsletter","tinyint(1)","否","0","同意接收论坛通知(Email或短消息)""invisible","tinyint(1)","否","0","在线列表中隐身""timeoffset","char(4)","否",,"时差设定""newpm","tinyint(1)","否","0","有新短消息""accessmasks","tinyint(1)","否","0","权限屏蔽(见ACCESS表)""editormode","tinyint(1)","否","2","编辑器模式""customshow","tinyint(1)","否","26","签名、头像、图片显示设置""xspacestatus","tinyint(1)","否","0","XSPACE状态(SS相关)",,,,"cdb_memberspaces个人空间数据表",,,,"表说明:记录MiniSpace设置信息.
",,,,"字段","类型","Null","默认","注释""uid","mediumint(8)","否","0","主键,会员UID""style","char(20)","否",,"空间风格""description","char(100)","否",,"空间描述""layout","char(200)","否",,"布局层设置""side","tinyint(1)","否","0","布局侧边设置(0=双侧边1=左侧边2=右侧边)",,,,"cdb_moderators版主表",,,,"表说明:记录版主信息.
",,,,"字段","类型","Null","默认","注释""uid","mediumint(8)","否","0","关联主键,版主UID""fid","smallint(6)","否","0","关联主键,版块FID""displayorder","tinyint(3)","否","0","显示顺序""inherited","tinyint(1)","否","0","继承自父版块",,,,"cdb_modworks管理统计表",,,,"表说明:记录版主管理操作统计信息.
",,,,"字段","类型","Null","默认","注释""uid","mediumint(8)","否","0","索引,版主UID""modaction","char(3)","否",,"管理操作标识""dateline","date","否","01-02-10","管理操作日期""count","smallint(6)","否","0","管理操作计数""posts","smallint(6)","否","0","管理操作帖数",,,,"cdb_myposts我的回复表",,,,"表说明:记录我的回复信息.
",,,,"字段","类型","Null","默认","注释""uid","mediumint(8)","否","0","关联主键,会员UID""tid","mediumint(8)","否","0","关联主键,索引,主题TID""pid","int(10)","否","0","帖子PID""position","smallint(6)","否","0","最后回复位置""dateline","int(10)","否","0","最后回复时间""special","tinyint(1)","否","0","特殊主题类型",,,,"cdb_mythreads我的主题表",,,,"表说明:记录我的主题信息.
",,,,"字段","类型","Null","默认","注释""uid","mediumint(8)","否","0","关联主键,会员UID""tid","mediumint(8)","否","0","关联主键,索引,主题TID""special","tinyint(1)","否","0","特殊主题类型""dateline","int(10)","否","0","主题发表时间",,,,"cdb_onlinelist在线列表定制表",,,,"表说明:记录用户在线列表定制信息.
",,,,"字段","类型","Null","默认","注释""groupid","smallint(6)","否","0","用户组GID""displayorder","tinyint(3)","否","0","显示顺序""title","varchar(30)","否",,"用户组头衔""url","varchar(30)","否",,"用户组图例",,,,"cdb_onlinetime在线时间表",,,,"表说明:记录用户在线时间统计信息.
",,,,"字段","类型","Null","默认","注释""uid","mediumint(8)","否","0","主键,会员UID""thismonth","smallint(6)","否","0","本月在线时间""total","mediumint(8)","否","0","总在线时间""lastupdate","int(10)","否","0","最后更新时间",,,,"cdb_orders订单表",,,,"表说明:记录积分充值订单信息.
",,,,"字段","类型","Null","默认","注释""orderid","char(32)","否",,"唯一,订单编号""status","char(3)","否",,"订单状态(1=未付款2=已支付3=人工补单)""buyer","char(50)","否",,"付款支付宝帐号""admin","char(15)","否",,"补单管理员用户名""uid","mediumint(8)","否","0","索引,付款用户UID""amount","int(10)","否","0","订购量""price","float(7,2)","否","0","消费金额""submitdate","int(10)","否","0","索引,提交时间""confirmdate","int(10)","否","0","补单确认时间",,,,"cdb_paymentlog主题购买记录表",,,,"表说明:记录主题购买信息.
",,,,"字段","类型","Null","默认","注释""uid","mediumint(8)","否","0","关联主键,索引,购买者UID""tid","mediumint(8)","否","0","关联主键,所购主题TID""authorid","mediumint(8)","否","0","主题作者UID""dateline","int(10)","否","0","购买时间""amount","int(10)","否","0","付费总金额""netamount","int(10)","否","0","税后金额",,,,"cdb_pluginhooks插件钩子表",,,,"表说明:记录插件钩子信息.
",,,,"字段","类型","Null","默认","注释""pluginhookid","mediumint(8)","否",,"主键,插件钩子编号,自增""pluginid","smallint(6)","否","0","索引,所属插件pluginid""available","tinyint(1)","否","0","索引,可用""title","varchar(255)","否",,"钩子名称""description","mediumtext","否",,"钩子描述""code","mediumtext","否",,"PHP代码",,,,"cdb_plugins插件表",,,,"表说明:记录插件信息.
Modules为serialize值.
",,,,"字段","类型","Null","默认","注释""pluginid","smallint(6)","否",,"主键,插件编号,自增""available","tinyint(1)","否","0","可用""adminid","tinyint(1)","否","0","后台权限等级""name","varchar(40)","否",,"插件名称""identifier","varchar(40)","否",,"唯一,唯一标识符""description","varchar(255)","否",,"插件描述""datatables","varchar(255)","否",,"插件数据表""directory","varchar(100)","否",,"插件目录""copyright","varchar(100)","否",,"版权信息""modules","text","否",,"插件模块和自定义菜单信息",,,,"cdb_pluginvars插件变量表",,,,"表说明:记录插件变量信息.
",,,,"字段","类型","Null","默认","注释""pluginvarid","mediumint(8)","否",,"主键,插件变量编号,自增""pluginid","smallint(6)","否","0","索引,所属插件pluginid""displayorder","tinyint(3)","否","0","显示顺序""title","varchar(100)","否",,"配置名称""description","varchar(255)","否",,"配置说明""variable","varchar(40)","否",,"配置变量名""type","varchar(20)","否","text","配置类型""value","text","否",,"变量值""extra","text","否",,"扩充设置",,,,"cdb_pms站内短信息表",,,,"表说明:记录站内短消息信息.
",,,,"字段","类型","Null","默认","注释""pmid","int(10)","否",,"主键,短消息编号,自增""msgfrom","varchar(15)","否",,"发送者用户名""msgfromid","mediumint(8)","否","0","索引,发送者UID""msgtoid","mediumint(8)","否","0","索引,接收者UID""folder","enum('inbox','outbox')","否","inbox","短消息所在文件夹(inbox=收件箱outbox=草稿箱)""new","tinyint(1)","否","0","新短消息(0=已读1=未读2=不再显示)""subject","varchar(75)","否",,"短消息标题""dateline","int(10)","否","0","发送时间""message","text","否",,"短消息内容""delstatus","tinyint(1)","否","0","删除状态(0=无1=发送者2=接收者)",,,,"cdb_pmsearchindex站内短信息搜索缓存表",,,,"表说明:记录站内短消息搜索缓存信息.
keywords为关键字+收发信人,搜索searchstring为一定规则下的搜索条件字符串.
",,,,"字段","类型","Null","默认","注释""searchid","int(10)","否",,"主键,搜索缓存编号,自增""keywords","varchar(255)","否",,"搜索关键字""searchstring","varchar(255)","否",,"搜索字符串""uid","mediumint(8)","否","0","搜索者UID""dateline","int(10)","否","0","搜索时间""expiration","int(10)","否","0","缓存有效期""pms","smallint(6)","否","0","结果数据条数""pmids","text","否",,"结果短消息PMID组(,分隔)",,,,"cdb_polloptions投票选项表",,,,"表说明:记录投票选项信息.
",,,,"字段","类型","Null","默认","注释""polloptionid","int(10)","否",,"主键,投票选项编号,自增""tid","mediumint(8)","否","0","索引,投票主题TID""votes","mediumint(8)","否","0","选项得票数""displayorder","tinyint(3)","否","0","选项显示顺序""polloption","varchar(80)","否",,"选项内容""voterids","mediumtext","否",,"投票者UID组(\t分隔)",,,,"cdb_polls投票表",,,,"表说明:记录投票信息.
",,,,"字段","类型","Null","默认","注释""tid","mediumint(8)","否","0","主键,投票主题TID""multiple","tinyint(1)","否","0","多选""visible","tinyint(1)","否","0","提交投票后结果才可见""maxchoices","tinyint(3)","否","0","最多可选项数""expiration","int(10)","否","0","投票有效期",,,,"cdb_posts帖子表",,,,"表说明:记录帖子信息.
",,,,"字段","类型","Null","默认","注释""pid","int(10)","否",,"主键,帖子编号,自增""fid","smallint(6)","否","0","索引,帖子所在版块FID""tid","mediumint(8)","否","0","帖子所属主题TID""first","tinyint(1)","否","0","索引,主题贴""author","varchar(15)","否",,"帖子作者用户名""authorid","mediumint(8)","否","0","索引,帖子作者UID""subject","varchar(80)","否",,"帖子标题""dateline","int(10)","否","0","发布时间""message","mediumtext","否",,"帖子内容""useip","varchar(15)","否",,"作者IP""invisible","tinyint(1)","否","0","索引,不可见""anonymous","tinyint(1)","否","0","匿名发帖""usesig","tinyint(1)","否","0","使用个人签名""htmlon","tinyint(1)","否","0","使用HTML""bbcodeoff","tinyint(1)","否","0","禁用Discuz!
代码""smileyoff","tinyint(1)","否","0","禁用Smilies""parseurloff","tinyint(1)","否","0","禁用URL识别""attachment","tinyint(1)","否","0","包含""rate","smallint(6)","否","0","评分总计""ratetimes","tinyint(3)","否","0","评分次数""status","tinyint(1)","否","0","帖子状态(0=正常1=屏蔽)",,,,"cdb_profilefields用户栏目定制表",,,,"表说明:记录用户栏目定制信息.
每个用户栏目在memberfields表中会建立一个对应字段用以保存数据,字段名称为field_{fieldid}.
",,,,"字段","类型","Null","默认","注释""fieldid","smallint(6)","否",,"主键,栏目编号,自增""available","tinyint(1)","否","0","索引,可用""invisible","tinyint(1)","否","0","隐藏""title","varchar(50)","否",,"栏目标题""description","varchar(255)","否",,"简短描述""size","tinyint(3)","否","0","内容最大长度""displayorder","smallint(6)","否","0","显示顺序""required","tinyint(1)","否","0","必填内容""unchangeable","tinyint(1)","否","0","不可修改""showinthread","tinyint(1)","否","0","在帖子中显示""selective","tinyint(1)","否","0","是否可选""choices","text","否",,"选项内容",,,,"cdb_projects论坛方案表",,,,"表说明:记录论坛方案信息.
value为serialize值.
",,,,"字段","类型","Null","默认","注释""id","smallint(6)","否",,"主键,方案编号,自增""name","varchar(50)","否",,"方案名称""type","varchar(10)","否",,"方案类型""description","varchar(255)","否",,"方案描述""value","mediumtext","否",,"方案内容",,,,"cdb_promotions论坛推广表",,,,"表说明:记录论坛访问推广信息.
",,,,"字段","类型","Null","默认","注释""ip","char(15)","否",,"主键,来访者IP""uid","mediumint(8)","否","0","推广者UID""username","char(15)","否",,"推广者用户名",,,,"cdb_ranks发帖数级别表",,,,"表说明:记录发贴数级别信息.
",,,,"字段","类型","Null","默认","注释""rankid","smallint(6)","否",,"主键,发帖级别编号,自增""ranktitle","varchar(30)","否",,"级别头衔""postshigher","mediumint(8)","否","0","发贴数高于""stars","tinyint(3)","否","0","星星数""color","varchar(7)","否",,"头衔颜色",,,,"cdb_ratelog帖子评分记录表",,,,"表说明:记录帖子评分信息.
",,,,"字段","类型","Null","默认","注释""pid","int(10)","否","0","索引,被评分帖子PID""uid","mediumint(8)","否","0","评分者UID""username","char(15)","否",,"评分者用户名""extcredits","tinyint(1)","否","0","评分扩展积分类别""dateline","int(10)","否","0","索引,评分时间""score","smallint(6)","否","0","评分数""reason","char(40)","否",,"操作原因",,,,"cdb_regips限制注册IP表",,,,"表说明:开启IP注册间隔限制等功能时,记录注册IP信息.
",,,,"字段","类型","Null","默认","注释""ip","char(15)","否",,"索引,注册IP""dateline","int(10)","否","0","注册时间""count","smallint(6)","否","0","操作次数""cdb_relatedthreads相关主题表",,,,"表说明:记录相关主题信息.
relatedthreads为serialize值.
",,,,"字段","类型","Null","默认","注释""tid","mediumint(8)","否","0","关联主键,主题TID""type","enum('general','trade')","否","general","关联主键,相关类型(general=站内trade=站外)""expiration","int(10)","否","0","有效期""keywords","varchar(255)","否",,"关键字(\t分隔)""relatedthreads","text","否",,"相关主题信息",,,,"cdb_rewardlog悬赏记录表",,,,"表说明:记录悬赏信息.
",,,,"字段","类型","Null","默认","注释""tid","mediumint(8)","否","0","悬赏主题TID""authorid","mediumint(8)","否","0","悬赏发起者UID""answererid","mediumint(8)","否","0","回答者UID""dateline","int(10)","是","0","回答时间""netamount","int(10)","否","0","悬赏价格",,,,"cdb_rsscachesRSS缓存表",,,,"表说明:记录RSS订阅主题缓存信息.
",,,,"字段","类型","Null","默认","注释""lastupdate","int(10)","否","0","最后更新时间""fid","smallint(6)","否","0","索引,RSS订阅版块FID""tid","mediumint(8)","否","0","RSS订阅主题TID""dateline","int(10)","否","0","RSS订阅时间""forum","char(50)","否",,"RSS订阅版块名称""author","char(15)","否",,"RSS订阅主题作者用户名""subject","char(80)","否",,"RSS订阅主题标题""description","char(255)","否",,"RSS订阅主题摘要",,,,"cdb_searchindex搜索缓存表",,,,"表说明:记录搜索主题缓存信息.
keywords为关键字+作者,搜索searchstring为一定规则下的搜索条件字符串.
",,,,"字段","类型","Null","默认","注释""searchid","int(10)","否",,"主键,搜索缓存编号,自增""keywords","varchar(255)","否",,"搜索关键字""searchstring","text","否",,"搜索字符串""useip","varchar(15)","否",,"搜索者IP""uid","mediumint(10)","否","0","搜索者UID""dateline","int(10)","否","0","搜索时间""expiration","int(10)","否","0","有效期""threadtypeid","smallint(6)","否","0","搜索主题分类ID""threads","smallint(6)","否","0","搜索结果主题数""tids","text","否",,"搜索结果主题TID组",,,,"cdb_sessions会话表",,,,"表说明:记录论坛访问会话信息.
",,,,"字段","类型","Null","默认","注释""sid","char(6)","否",,"唯一,会话编号""ip1","tinyint(3)","否","0","ip字段1""ip2","tinyint(3)","否","0","ip字段2""ip3","tinyint(3)","否","0","ip字段3""ip4","tinyint(3)","否","0","ip字段4""uid","mediumint(8)","否","0","索引,会话用户UID""username","char(15)","否",,"会话用户名""groupid","smallint(6)","否","0","会话用户组GROUPID""styleid","smallint(6)","否","0","会话用户风格STYLEID""invisible","tinyint(1)","否","0","隐身登录""action","tinyint(1)","否","0","会话用户动作""lastactivity","int(10)","否","0","最后活动时间""lastolupdate","int(10)","否","0","在线时间最后更新""pageviews","smallint(6)","否","0","页面访问量""seccode","mediumint(6)","否","0","验证码""fid","smallint(6)","否","0","活动版块FID""tid","mediumint(8)","否","0","阅读主题TID""bloguid","mediumint(8)","否","0","不详",,,,"cdb_settings论坛设置表",,,,"表说明:记录论坛设置信息.
",,,,"字段","类型","Null","默认","注释""variable","varchar(32)","否",,"主键,论坛设置变量名""value","text","否",,"论坛设置变量值",,,,"cdb_smilies表情表",,,,"表说明:记录表情信息.
",,,,"字段","类型","Null","默认","注释""id","smallint(6)","否",,"主键,表情编号,自增""typeid","smallint(6)","否",,"表情分类typeid""displayorder","tinyint(3)","否","0","显示顺序""type","enum('smiley','icon')","否","smiley","表情类型(smiley=表情icon=主题图标)""code","varchar(30)","否",,"表情代码""url","varchar(30)","否",,"表情文件名",,,,"cdb_spacecachesminispace缓存表",,,,"表说明:记录minispace缓存信息.
value为serialize值.
",,,,"字段","类型","Null","默认","注释""uid","mediumint(8)","否","0","关联主键,空间用户UID""variable","varchar(20)","否",,"关联主键,空间缓存变量名""value","text","否",,"空间缓存变量值""expiration","int(10)","否","0","有效期",,,,"cdb_stats统计表",,,,"表说明:记录论坛基本统计信息.
",,,,"字段","类型","Null","默认","注释""type","char(10)","否",,"关联主键,统计类别""variable","char(10)","否",,"关联主键,统计变量名""count","int(10)","否","0","统计计数",,,,"cdb_statvars统计变量表",,,,"表说明:记录论坛统计信息.
Value根据统计类别不同可能为serialize值.
",,,,"字段","类型","Null","默认","注释""type","varchar(20)","否",,"关联主键,统计类别""variable","varchar(20)","否",,"关联主键,统计变量名""value","mediumtext","否",,"统计值",,,,"cdb_styles风格表",,,,"表说明:记录风格信息.
",,,,"字段","类型","Null","默认","注释""styleid","smallint(6)","否",,"主键,风格编号,自增""name","varchar(20)","否",,"风格名称""available","tinyint(1)","否","1","可用""templateid","smallint(6)","否","0","模板templateid",,,,"cdb_stylevars风格变量表",,,,"表说明:记录风格变量信息.
",,,,"字段","类型","Null","默认","注释""stylevarid","smallint(6)","否",,"主键,风格变量编号,自增""styleid","smallint(6)","否","0","索引,所属风格STYLEID""variable","text","否",,"变量名""substitute","text","否",,"替换内容",,,,"cdb_subscriptions订阅表",,,,"表说明:记录订阅主题信息.
",,,,"字段","类型","Null","默认","注释""uid","mediumint(8)","否","0","关联主键,订阅者UID""tid","mediumint(8)","否","0","关联主键,订阅主题TID""lastpost","int(10)","否","0","订阅主题最后发表时间""lastnotify","int(10)","否","0","最后通知时间",,,,"cdb_tags标签表",,,,"表说明:记录标签信息.
",,,,"字段","类型","Null","默认","注释""tagname","char(20)","否",,"主键,标签名""closed","tinyint(1)","否","0","索引,标签关闭""total","mediumint(8)","否",,"索引,标签主题数",,,,"cdb_templates模版表",,,,"表说明:记录模板信息.
",,,,"字段","类型","Null","默认","注释""templateid","smallint(6)","否",,"主键,模板编号,自增""name","varchar(30)","否",,"模板名称""directory","varchar(100)","否",,"所在目录""copyright","varchar(100)","否",,"版权信息",,,,"cdb_threads主题表",,,,"表说明:记录主题信息.
",,,,"字段","类型","Null","默认","注释""tid","mediumint(8)","否",,"主键,主题编号,自增""fid","smallint(6)","否","0","主题所在版块FID""iconid","smallint(6)","否","0","主题图标iconid""typeid","smallint(6)","否","0","索引,主题分类TYPEID""readperm","tinyint(3)","否","0","主题阅读权限""price","smallint(6)","否","0","主题出售价格""author","char(15)","否",,"主题作者用户名""authorid","mediumint(8)","否","0","索引,主题作者UID""subject","char(80)","否",,"主题标题""dateline","int(10)","否","0","主题发表时间""lastpost","int(10)","否","0","主题最后回复时间""lastposter","char(15)","否",,"主题最后回复作者""views","int(10)","否","0","主题浏览次数""replies","mediumint(8)","否","0","主题回复次数""displayorder","tinyint(1)","否","0","索引,主题显示顺序""highlight","tinyint(1)","否","0","主题是否被高亮""digest","tinyint(1)","否","0","索引,主题精华级别""rate","tinyint(1)","否","0","主题评分(-1=反对0=无1=支持)""blog","tinyint(1)","否","0","主题作者加入文集""special","tinyint(1)","否","0","特殊主题编码""attachment","tinyint(1)","否","0","主题包含""subscribed","tinyint(1)","否","0","主题被订阅""moderated","tinyint(1)","否","0","主题被管理""closed","mediumint(8)","否","0","主题关闭""itemid","mediumint(8)","否","0","SS项目itemid(SS相关)""supe_pushstatus","tinyint(1)","否","0","SS推送状态(SS相关)",,,,"cdb_threadsmod主题管理记录表",,,,"表说明:记录主题管理操作信息.
",,,,"字段","类型","Null","默认","注释""tid","mediumint(8)","否","0","索引,被管理主题TID""uid","mediumint(8)","否","0","管理者UID""username","char(15)","否",,"管理者用户名""dateline","int(10)","否","0","管理执行时间""expiration","int(10)","否","0","索引,管理有效期""action","char(5)","否",,"管理操作代码""status","tinyint(1)","否","0","管理操作状态(0=失效1=有效)""magicid","smallint(6)","否",,"所使用道具magicid",,,,"cdb_threadtags主题标签表",,,,"表说明:记录主题标签关联信息.
",,,,"字段","类型","Null","默认","注释""tagname","char(20)","否",,"索引,标签名称""tid","int(10)","否",,"索引,主题TID",,,,"cdb_threadtypes主题分类表",,,,"表说明:记录主题分类信息.
",,,,"字段","类型","Null","默认","注释""typeid","smallint(6)","否",,"主键,主题分类编号,自增""displayorder","tinyint(3)","否","0","显示顺序""name","varchar(255)","否",,"主题分类名称""description","varchar(255)","否",,"主题分类描述""special","smallint(6)","否","0","分类信息""modelid","smallint(6)","否","0","分类信息模型ID""expiration","tinyint(1)","否","0","设置有效期""template","text","否",,"分类信息模板",,,,"cdb_tradecomments交易评价表",,,,"表说明:记录交易双方评价信息.
",,,,"字段","类型","Null","默认","注释""id","mediumint(8)","否",,"主键,交易评价编号,自增""orderid","char(32)","否",,"索引,订单编号""pid","int(10)","否",,"评价贴PID""type","tinyint(1)","否",,"评价类型""raterid","mediumint(8)","否",,"评价者UID""rater","char(15)","否",,"评价者用户名""rateeid","mediumint(8)","否",,"被评价者UID""ratee","char(15)","否",,"被评价者用户名""message","char(200)","否",,"评价内容""explanation","char(200)","否",,"评价解释""score","tinyint(1)","否",,"评价分数(-1=差评0=中评1=好评)""dateline","int(10)","否",,"评价时间",,,,"cdb_tradelog交易记录表",,,,"表说明:记录交易记录信息.
",,,,"字段","类型","Null","默认","注释""tid","mediumint(8)","否",,"索引,交易主题TID""pid","int(10)","否",,"索引,交易贴PID""orderid","varchar(32)","否",,"唯一,订单编号""tradeno","varchar(32)","否",,"交易编号""subject","varchar(100)","否",,"商品名称""price","decimal(8,2)","否",,"商品价格""quality","tinyint(1)","否","0","商品质量(1=全新2=二手)""itemtype","tinyint(1)","否","0","商品类型""number","smallint(5)","否","0","商品数量""tax","decimal(6,2)","否","0","手续费""locus","varchar(100)","否",,"所在地""sellerid","mediumint(8)","否",,"卖家UID""seller","varchar(15)","否",,"卖家用户名""selleraccount","varchar(50)","否",,"卖家账户""buyerid","mediumint(8)","否",,"买家UID""buyer","varchar(15)","否",,"买家用户名""buyercontact","varchar(50)","否",,"买家联系方式""buyercredits","smallint(5)","否","0","买家诚信度""buyermsg","varchar(200)","是","NULL","买家备注信息""status","tinyint(1)","否","0","交易状态""lastupdate","int(10)","否","0","最后更新""offline","tinyint(1)","否","0","线下交易""buyername","varchar(50)","否",,"收货人姓名""buyerzip","varchar(10)","否",,"收货人邮编""buyerphone","varchar(20)","否",,"收货人电话""buyermobile","varchar(20)","否",,"收货人手机""transport","tinyint(1)","否","0","物流方式""transportfee","smallint(6)","否","0","运费""baseprice","decimal(8,2)","否",,"底价""discount","tinyint(1)","否","0","折扣""ratestatus","tinyint(1)","否","0","信用评价状态""message","text","否",,"交易相关信息",,,,"cdb_tradeoptionvars交易项目变量表",,,,"表说明:记录交易项目变量信息.
",,,,"字段","类型","Null","默认","注释""typeid","smallint(6)","否","0","索引,商品分类typeid""pid","mediumint(8)","否","0","索引,交易贴PID""optionid","smallint(6)","否","0","分类项目optionid""value","mediumtext","否",,"项目值",,,,"cdb_trades交易表",,,,"表说明:记录交易信息.
",,,,"字段","类型","Null","默认","注释""tid","mediumint(8)","否",,"关联主键,交易主题TID""pid","int(10)","否",,"关联主键,交易贴PID""typeid","smallint(6)","否",,"索引,商品分类typeid""sellerid","mediumint(8)","否",,"索引,卖家UID""seller","char(15)","否",,"卖家用户名""account","char(50)","否",,"卖家账户""subject","char(100)","否",,"商品名称""price","decimal(8,2)","否",,"商品价格""amount","smallint(6)","否","1","库存数""quality","tinyint(1)","否","0","商品质量(1=全新2=二手)""locus","char(20)","否",,"所在地""transport","tinyint(1)","否","0","物流方式""ordinaryfee","smallint(4)","否","0","平邮运费""expressfee","smallint(4)","否","0","快递运费""emsfee","smallint(4)","否","0","EMS运费""itemtype","tinyint(1)","否","0","商品类型""dateline","int(10)","否","0","上架时间""expiration","int(10)","否","0","有效期""lastbuyer","char(15)","否",,"最新买家""lastupdate","int(10)","否","0","最后更新时间""totalitems","smallint(5)","否","0","索引,售出数量""tradesum","decimal(8,2)","否","0","索引,总销售额""closed","tinyint(1)","否","0","交易结束""aid","mediumint(8)","否",,"商品图片AID""displayorder","tinyint(1)","否",,"索引,显示顺序""costprice","decimal(8,2)","否",,"原价",,,,"cdb_typemodels分类信息模型表",,,,"表说明:记录分类信息模型信息.
",,,,"字段","类型","Null","默认","注释""id","smallint(6)","否",,"主键,分类模型编号,自增""name","varchar(20)","否",,"模型名称""displayorder","tinyint(3)","否","0","显示顺序""type","tinyint(1)","否","0","模型类型""options","mediumtext","否",,"系统选项(\t分隔)""customoptions","mediumtext","否",,"用户自定义选项(\t分隔)",,,,"cdb_typeoptions分类信息项目表",,,,"表说明:记录分类信息项目信息.
rules为serialize值.
",,,,"字段","类型","Null","默认","注释""optionid","smallint(6)","否",,"主键,分类信息项目编号,自增""classid","smallint(6)","否","0","所属类别ID(上级项目optionid)""displayorder","tinyint(3)","否","0","显示顺序""title","varchar(100)","否",,"项目名称""description","varchar(255)","否",,"项目简短描述""identifier","varchar(40)","否",,"项目变量名""type","varchar(20)","否",,"项目类型""rules","mediumtext","否",,"项目规则",,,,"cdb_typeoptionvars分类信息项目变量表",,,,"表说明:记录分类信息项目变量信息.
",,,,"字段","类型","Null","默认","注释""typeid","smallint(6)","否","0","索引,分类TYPEID""tid","mediumint(8)","否","0","索引,分类主题TID""optionid","smallint(6)","否","0","分类信息项目OPTIONID""expiration","int(10)","否","0","有效期""value","mediumtext","否",,"分类信息项目变量值",,,,,"cdb_typevars分类信息变量表",,,,"表说明:记录分类与选项关联信息.
",,,,"字段","类型","Null","默认","注释""typeid","smallint(6)","否","0","关联唯一索引,索引,分类TYPEID""optionid","smallint(6)","否","0","关联唯一索引,分类信息项目OPTIONID""available","tinyint(1)","否","0","可用""required","tinyint(1)","否","0","必填""unchangeable","tinyint(1)","否","0","不可修改""search","tinyint(1)","否","0","参与搜索""displayorder","tinyint(3)","否","0","显示顺序",,,,"cdb_usergroups用户组表",,,,"表说明:记录用户组及其权限信息.
",,,,"字段","类型","Null","默认","注释""groupid","smallint(6)","否",,"主键,用户组编号,自增""radminid","tinyint(3)","否","0","关联管理权""type","enum('system','special','member')","否","member","组类型(system=系统special=特殊member=会员)""system","char(8)","否","private","组体制(private=非公共*\t*=日价格\t最短时间)""grouptitle","char(30)","否",,"用户组头衔""creditshigher","int(10)","否","0","积分上限""creditslower","int(10)","否","0","积分下限""stars","tinyint(3)","否","0","星星数""color","char(7)","否",,"组头衔颜色""groupavatar","char(60)","否",,"组头像""readaccess","tinyint(3)","否","0","阅读权限""allowvisit","tinyint(1)","否","0","允许访问""allowpost","tinyint(1)","否","0","允许发新话题""allowreply","tinyint(1)","否","0","允许发表回复""allowpostpoll","tinyint(1)","否","0","允许发起投票""allowpostreward","tinyint(1)","否","0","允许发起悬赏""allowposttrade","tinyint(1)","否","0","允许发布商品""allowpostactivity","tinyint(1)","否","0","允许发起活动""allowpostvideo","tinyint(1)","否","0","允许发布视频""allowdirectpost","tinyint(1)","否","0","允许直接发帖""allowgetattach","tinyint(1)","否","0","允许下载/查看""allowpostattach","tinyint(1)","否","0","允许发布""allowvote","tinyint(1)","否","0","允许参与投票""allowmultigroups","tinyint(1)","否","0","允许加入/离开公众用户组""allowsearch","tinyint(1)","否","0","允许使用搜索""allowavatar","tinyint(1)","否","0","允许使用头像""allowcstatus","tinyint(1)","否","0","允许自定义头衔""allowuseblog","tinyint(1)","否","0","允许使用文集""allowinvisible","tinyint(1)","否","0","允许隐身""allowtransfer","tinyint(1)","否","0","允许积分转账""allowsetreadperm","tinyint(1)","否","0","允许设置帖子权限""allowsetattachperm","tinyint(1)","否","0","允许设置权限""allowhidecode","tinyint(1)","否","0","允许使用[hide]代码""allowhtml","tinyint(1)","否","0","允许使用HTML代码""allowcusbbcode","tinyint(1)","否","0","允许使用自定义Discuz!
代码""allowanonymous","tinyint(1)","否","0","允许发匿名贴""allownickname","tinyint(1)","否","0","允许使用昵称""allowsigbbcode","tinyint(1)","否","0","允许签名中使用Discuz!
代码""allowsigimgcode","tinyint(1)","否","0","允许签名中使用[img]代码""allowviewpro","tinyint(1)","否","0","允许查看用户资料""allowviewstats","tinyint(1)","否","0","允许查看统计数据""disableperiodctrl","tinyint(1)","否","0","不受时间段限制""reasonpm","tinyint(1)","否","0","操作理由短消息通知作者""maxprice","smallint(6)","否","0","主题()最高售价""maxpmnum","smallint(6)","否","0","短消息收件箱容量""maxsigsize","smallint(6)","否","0","签名文字最大长度""maxattachsize","mediumint(8)","否","0","最大尺寸(字节)""maxsizeperday","int(10)","否","0","每天最大总尺寸(字节)""maxpostsperhour","tinyint(3)","否","0","会员每小时发帖数限制""attachextensions","char(100)","否",,"允许类型""raterange","char(150)","否",,"参与评分相关""mintradeprice","smallint(6)","否","1","最小交易金额""maxtradeprice","smallint(6)","否","0","最大交易金额""minrewardprice","smallint(6)","否","1","最小悬赏积分""maxrewardprice","smallint(6)","否","0","最大悬赏积分""magicsdiscount","tinyint(1)","否",,"购买道具折扣""allowmagics","tinyint(1)","否",,"允许使用道具""maxmagicsweight","smallint(6)","否",,"最大携带重量""allowbiobbcode","tinyint(1)","否","0","允许自我介绍中使用Discuz!
代码""allowbioimgcode","tinyint(1)","否","0","允许自我介绍中使用[img]代码""maxbiosize","smallint(6)","否","0","自我介绍文字最大长度""allowinvite","tinyint(1)","否","0","允许使用邀请注册""allowmailinvite","tinyint(1)","否","0","允许发送邀请注册""maxinvitenum","tinyint(3)","否","0","24小时内购买邀请码最大数量""inviteprice","smallint(6)","否","0","邀请码购买价格""maxinviteday","smallint(6)","否","0","邀请码有效期""allowpostdebate","tinyint(1)","否","0","允许发起辩论""tradestick","tinyint(1)","否",,"商品主题最多推荐商品数",,,,"cdb_validating用户审核表",,,,"表说明:记录审核信息.
",,,,"字段","类型","Null","默认","注释""uid","mediumint(8)","否","0","主键,审核用户UID""submitdate","int(10)","否","0","提交时间""moddate","int(10)","否","0","审核时间""admin","varchar(15)","否",,"审核操作者用户名""submittimes","tinyint(3)","否","0","提交次数""status","tinyint(1)","否","0","审核状态""message","text","否",,"注册原因""remark","text","否",,"管理员留言",,,,"cdb_videos视频表",,,,"表说明:记录视频主题信息.
",,,,"字段","类型","Null","默认","注释""vid","varchar(16)","否",,"关联唯一索引,主键,视频编号""uid","mediumint(8)","否","0","关联唯一索引,发布者UID""dateline","int(10)","否","0","索引,发布时间""tid","mediumint(8)","否","0","所在主题TID""pid","int(10)","否","0","所在帖子PID""vtype","tinyint(1)","否","0","视频分类""vview","mediumint(8)","否","0","视频浏览次数""vtime","smallint(6)","否","0","视频时长""visup","tinyint(1)","否","0","上传视频""vthumb","varchar(128)","否",,"视频缩略图地址""vtitle","varchar(64)","否",,"视频标题""vclass","varchar(32)","否",,"视频分类""vautoplay","tinyint(1)","否","0","自动播放",,,,"cdb_videotags视频标签表",,,,"表说明:记录视频标签信息.
",,,,"字段","类型","Null","默认","注释""tagname","char(10)","否",,"关联唯一索引,标签名称""vid","char(14)","否",,"关联唯一索引,视频VID""tid","mediumint(8)","否","0","索引,所在主题TID",,,,"cdb_words词语过滤表",,,,"表说明:记录词语过滤信息.
",,,,"字段","类型","Null","默认","注释""id","smallint(6)","否",,"主键,词语过滤编号""admin","varchar(15)","否",,"管理员用户名""find","varchar(255)","否",,"被过滤词语""replacement","varchar(255)","否",,"替换词语"

RackNerd提供四款高配美国服务器促销活动低至月$189

RackNerd 商家给的感觉就是一直蹭节日热点,然后时不时通过修改配置结构不断的提供低价年付的VPS主机,不过他们家还是在做事的,这么两年多的发展,居然已经有新增至十几个数据中心,而且产品线发展也是比较丰富。比如也有独立服务器业务,不过在他们轮番的低价年付VPS主机活动下,他们的服务器估摸着销路不是太好的。这里,今天有看到RackNerd商家的独立服务器业务有促销。这次提供美国多个机房的高配独立...

华圣云 HuaSaint-阿里云国际站一级分销商,只需一个邮箱即可注册国际账号,可代充值

简介华圣云 HuaSaint是阿里云国际版一级分销商(诚招募二级代理),专业为全球企业客户与个人开发者提供阿里云国际版开户注册、认证、充值等服务,通过HuaSaint开通阿里云国际版只需要一个邮箱,不需要PayPal信用卡,不需要买海外电话卡,绝对的零门槛,零风险官方网站:www.huasaint.com企业名:huaSaint Tech Limited阿里云国际版都有什么优势?阿里云国际版的产品...

618云上Go:腾讯云秒杀云服务器95元/年起,1C2G5M三年仅288元起

进入6月,各大网络平台都开启了618促销,腾讯云目前也正在开展618云上Go活动,上海/北京/广州/成都/香港/新加坡/硅谷等多个地区云服务器及轻量服务器秒杀,最低年付95元起,参与活动的产品还包括短信包、CDN流量包、MySQL数据库、云存储(标准存储)、直播/点播流量包等等,本轮秒杀活动每天5场,一直持续到7月中旬,感兴趣的朋友可以关注本页。活动页面:https://cloud.tencent...

查看ip为你推荐
1头牛168万人民币一个人650元买头牛?00元卖出;850元又买回来;900元卖出;问是亏还是赚sherylsandberg谷歌怎么看自己的详细资料巨星prince去世有几位好莱坞巨星死在2016年西部妈妈网啊,又是星期天百度关键词价格查询百度竞价关键词价格查询,帮忙查几个词儿点击一次多少钱,thanks百度关键词价格查询百度推广里怎么查指定的关键字参与竞价的价位呢百花百游百花百游的五滴自游进程se95se.comwww.sea8.com这个网站是用什么做的 需要多少钱www.bbb551.comHUNTA551第一个第二个妹子是谁呀??www.ca800.com西门子plc仿真软件有什么功能
美国linux主机 景安vps 汉邦高科域名申请 独享100m 国外主机 狗爹 isatap realvnc lamp配置 本网站服务器在美国 dux 网站cdn加速 asp免费空间申请 hkg 免费高速空间 hktv 搜索引擎提交入口 能外链的相册 卡巴斯基免费试用版 美国独立日 更多