PHPCMS V9最新 数据字典.xls

PHPCMS V9 数数据据字字典典 表 1 v9 admin 管理员表 ID字段类型Null默认额外 1useridmediumint 6 unsigned PKauto increment 2usernamevarchar 20 YES 3passwordvarchar 32 YES 4roleidsmallint 5 YES0 5encryptvarchar 6 YES 6lastloginipvarchar 15 YES 7lastlogintimeint 10 unsignedYES0 8emailvarchar 40 YES 9realnamevarchar 50 NO 10cardvarchar 255 NO 键名类型字段 PRIMARYPRIMARYuserid usernameINDEXusername 表 2 v9 admin panel 快捷面板 ID字段类型Null默认额外 1menuidmediumint 8 unsigned PK 2useridmediumint 8 unsigned NO0 3namechar 32 YES 4urlchar 255 YES 5datetimeint 10 unsignedYES0 键名类型字段 useridINDEXmenuid useridINDEXuserid 表 3 v9 admin role 角色表 ID字段类型Null默认额外 1roleidtinyint 3 unsignedPKauto increment 2rolenamevarchar 50 NO 3descriptiontextNO 4listordersmallint 5 unsigned NO0 5disabledtinyint 1 unsignedNO0 键名类型字段 PRIMARYPRIMARYroleid listorderINDEXlistorder disabledINDEXdisabled 表 4 v9 admin role priv 管理员权限表 ID字段类型Null默认额外 1roleidtinyint 3 unsignedPK0 2mchar 20 NO 3cchar 20 NO 4achar 20 NO 5datachar 30 NO 6siteidsmallint 5 unsigned NO0 键名类型字段 roleidINDEXroleid roleidINDEXm roleidINDEXc roleidINDEXa roleidINDEXsiteid 表 5 v9 announce 公告表 ID字段类型Null默认额外 1aidsmallint 4 unsigned PKauto increment 2siteidsmallint 5 unsigned NO0 3titlechar 80 NO 4contenttextNO 5starttimedateNO0000 00 00 6endtimedateNO0000 00 00 7usernamevarchar 40 NO 8addtimeint 10 unsignedNO0 9hitssmallint 5 unsigned NO0 10passedtinyint 1 unsignedNO0 11stylechar 15 NO 12show templatechar 30 NO 键名类型字段 PRIMARYPRIMARYaid siteidINDEXsiteid siteidINDEXpassed siteidINDEXendtime 表 6 v9 attachment 附件表 ID字段类型Null默认额外 1aidint 10 unsignedPKauto increment 2modulechar 15 NO 3catidsmallint 5 unsigned NO0 4filenamechar 50 NO 5filepathchar 200 NO 6filesizeint 10 unsignedNO0 7fileextchar 10 NO 8isimagetinyint 1 unsignedNO0 9isthumbtinyint 1 unsignedNO0 10downloadsmediumint 8 unsigned NO0 11useridmediumint 8 unsigned NO0 12uploadtimeint 10 unsignedNO0 13uploadipchar 15 NO 14statustinyint 1 NO0 15authcodechar 32 NO 16siteidsmallint 5 unsigned NO0 键名类型字段 PRIMARYPRIMARYaid authcodeINDEXauthcode 表 7 v9 attachment index 附件关系表 ID字段类型Null默认额外 1keyidchar 30 PK 2aidchar 10 NO 键名类型字段 keyidINDEXkeyid aidINDEXaid 表 8 v9 badword 敏感词 ID字段类型Null默认额外 1badidsmallint 5 unsigned PKauto increment 2badwordchar 20 NO 3leveltinyint 5 NO1 4replacewordchar 20 NO0 5lastusetimeint 10 unsignedNO0 6listordertinyint 3 unsignedNO0 键名类型字段 PRIMARYPRIMARYbadid badwordINDEXbadword usetimesINDEXreplaceword usetimesINDEXlistorder hitsINDEXlistorder 表 9 v9 block 碎片表 ID字段类型Null默认额外 1idint 10 PKauto increment 2siteidsmallint 5 unsigned YES0 3namechar 50 YES 4poschar 30 YES 5typetinyint 1 YES0 6datatextYES 7templatetextYES 键名类型字段 PRIMARYPRIMARYid posINDEXpos typeINDEXtype siteidINDEXsiteid 表 10 v9 block history 碎片历史记录表 ID字段类型Null默认额外 1idint 10 PKauto increment 2blockidint 10 unsignedYES0 3datatextYES 4creat atint 10 unsignedYES0 5useridmediumint 8 unsigned YES0 6usernamechar 20 YES 键名类型字段 PRIMARYPRIMARYid 表 11 v9 block priv 碎片权限表 ID字段类型Null默认额外 1idint 10 unsignedPKauto increment 2roleidtinyint 3 unsignedYES0 3siteidsmallint 5 unsigned YES0 4blockidint 10 unsignedYES0 键名类型字段 PRIMARYPRIMARYid blockidINDEXblockid roleidINDEXroleid roleidINDEXsiteid 表 12 v9 cache 缓存表 ID字段类型Null默认额外 1filenamechar 50 PK 2pathchar 50 NO 3datamediumtextNO 键名类型字段 PRIMARYPRIMARYfilename PRIMARYPRIMARYpath 表 13 v9 category 栏目表 ID字段类型Null默认额外 1catidsmallint 5 unsigned PKauto increment 2siteidsmallint 5 unsigned NO0 3modulevarchar 15 NO 4typetinyint 1 unsignedNO0 5modelidtinyint 5 unsignedNO0 6parentidsmallint 5 unsigned NO0 7arrparentidvarchar 255 NO 8childtinyint 1 unsignedNO0 9arrchildidmediumtextNO 10catnamevarchar 30 NO 11stylevarchar 5 NO 12imagevarchar 100 NO 13descriptionmediumtextNO 14parentdirvarchar 100 NO 15catdirvarchar 30 NO 16urlvarchar 100 NO 17itemsmediumint 8 unsigned NO0 18hitsint 10 unsignedNO0 19settingmediumtextNO 20listordersmallint 5 unsigned NO0 21ismenutinyint 1 unsignedNO1 22sethtmltinyint 1 unsignedNO0 23lettervarchar 30 NO 24usable typevarchar 255 NO 键名类型字段 PRIMARYPRIMARYcatid moduleINDEXmodule moduleINDEXparentid moduleINDEXlistorder moduleINDEXcatid siteidINDEXsiteid siteidINDEXtype 表 14 v9 category priv 栏目权限表 ID字段类型Null默认额外 1catidsmallint 5 unsigned PK0 2siteidsmallint 5 unsigned NO0 3roleidsmallint 5 unsigned NO0 4is admintinyint 1 unsignedNO0 5actionchar 30 NO 键名类型字段 catidINDEXcatid catidINDEXroleid catidINDEXis admin catidINDEXaction siteidINDEXsiteid 表 15 v9 collection content 采集内容表 ID字段类型Null默认额外 1idint 10 unsignedPKauto increment 2nodeidint 10 unsignedNO0 3siteidmediumint 5 unsigned NO0 4statustinyint 1 unsignedNO0 5urlchar 255 NO 6titlechar 100 NO 7datatextNO 键名类型字段 PRIMARYPRIMARYid nodeidINDEXnodeid nodeidINDEXsiteid statusINDEXstatus 表 16 v9 collection history 采集历史 ID字段类型Null默认额外 1md5char 32 PK 2siteidsmallint 5 unsigned NO0 键名类型字段 PRIMARYPRIMARYmd5 PRIMARYPRIMARYsiteid 表 17 v9 collection node 采集节点配置 ID字段类型Null默认额外 1nodeidsmallint 6 unsigned PKauto increment 2namevarchar 20 NO 3lastdateint 10 unsignedNO0 4siteidsmallint 5 unsigned NO0 5sourcecharsetvarchar 8 NO 6sourcetypetinyint 1 unsignedNO0 7urlpagetextNO 8pagesize starttinyint 3 unsignedNO0 9pagesize endmediumint 8 unsigned NO0 10page basechar 255 NO 11par numtinyint 3 unsignedNO1 12url containchar 100 NO 13url exceptchar 100 NO 14url startchar 100 NO 15url endchar 100 NO 16title rulechar 100 NO 17title html ruletextNO 18author rulechar 100 NO 19author html ruletextNO 20comeform rulechar 100 NO 21comeform html rule textNO 22time rulechar 100 NO 23time html ruletextNO 24content rulechar 100 NO 25content html ruletextNO 26content page startchar 100 NO 27content page endchar 100 NO 28content page ruletinyint 1 unsignedNO0 29content pagetinyint 1 unsignedNO0 30content nextpagechar 100 NO 31down attachmenttinyint 1 unsignedNO0 32watermarktinyint 1 unsignedNO0 33coll ordertinyint 3 unsignedNO0 34customize configtextNO 键名类型字段 PRIMARYPRIMARYnodeid siteidINDEXsiteid 表 18 v9 collection program 采集导入规则表 ID字段类型Null默认额外 1idint 10 unsignedPKauto increment 2siteidsmallint 5 unsigned NO0 3nodeidint 10 unsignedNO0 4modelidmediumint 6 unsigned NO0 5catidint 10 unsignedNO0 6configtextNO 键名类型字段 PRIMARYPRIMARYid siteidINDEXsiteid nodeidINDEXnodeid 表 19 v9 comment ID字段类型Null默认额外 1commentidchar 30 PK 2siteidsmallint 5 NO0 3titlechar 255 NO 4urlchar 255 NO 5totalint 8 unsignedYES0 6squaremediumint 8 unsigned YES0 7antimediumint 8 unsigned YES0 8neutralmediumint 8 unsigned YES0 9display typetinyint 1 YES0 10tableidmediumint 8 unsigned YES0 11lastupdateint 10 unsignedYES0 键名类型字段 PRIMARYPRIMARYcommentid lastupdateINDEXlastupdate siteidINDEXsiteid 表 20 v9 comment check ID字段类型Null默认额外 1idint 10 PKauto increment 2comment data idint 10 YES0 3siteidsmallint 5 NO0 4tableidmediumint 8 YES0 键名类型字段 PRIMARYPRIMARYid siteidINDEXsiteid comment data idINDEXcomment data id 表 21 v9 comment data 1 ID字段类型Null默认额外 1idint 10 unsignedPKauto increment 2commentidchar 30 NO 3siteidsmallint 5 NO0 4useridint 10 unsignedYES0 5usernamevarchar 20 YES 6creat atint 10 YES 7ipvarchar 15 YES 8statustinyint 1 YES0 9contenttextYES 10directiontinyint 1 YES0 11supportmediumint 8 unsigned YES0 12replytinyint 1 NO0 键名类型字段 PRIMARYPRIMARYid commentidINDEXcommentid directionINDEXdirection siteidINDEXsiteid supportINDEXsupport 表 22 v9 comment setting ID字段类型Null默认额外 1siteidsmallint 5 PK0 2guesttinyint 1 YES0 3checktinyint 1 YES0 4codetinyint 1 YES0 5add pointtinyint 3 unsignedYES0 6del pointtinyint 3 unsignedYES0 键名类型字段 PRIMARYPRIMARYsiteid 表 23 v9 comment table ID字段类型Null默认额外 1tableidmediumint 8 PKauto increment 2totalint 10 unsignedYES0 3creat atint 10 YES0 键名类型字段 PRIMARYPRIMARYtableid 表 24 v9 content check 内容审核表 ID字段类型Null默认额外 1checkidchar 15 NO 2catidsmallint 5 unsigned NO0 3siteidsmallint 5 unsigned NO0 4titlechar 80 NO 5usernamechar 20 PK 6inputtimeint 10 unsignedNO0 7statustinyint 1 unsignedNO0 键名类型字段 usernameINDEXusername checkidINDEXcheckid statusINDEXstatus statusINDEXinputtime 表 25 v9 copyfrom 来源表 ID字段类型Null默认额外 1idsmallint 5 unsigned PKauto increment 2siteidsmallint 5 unsigned NO0 3sitenamevarchar 30 NO 4siteurlvarchar 100 NO 5thumbvarchar 100 NO 6listordersmallint 5 unsigned NO0 键名类型字段 PRIMARYPRIMARYid 表 26 v9 datacall 数据调用 ID字段类型Null默认额外 1idint 10 PKauto increment 2namechar 40 YES 3dis typetinyint 1 unsignedYES0 4typetinyint 1 YES0 5modulechar 20 YES 6actionchar 20 YES 7datatextYES 8templatetextYES 9cachemediumint 8 YES 10numsmallint 6 unsigned YES 键名类型字段 PRIMARYPRIMARYid typeINDEXtype 表 27 v9 dbsource 数据源 ID字段类型Null默认额外 1idint 10 PKauto increment 2siteidsmallint 5 unsigned NO0 3namevarchar 50 NO 4hostvarchar 20 NO 5portint 5 NO3306 6usernamevarchar 50 NO 7passwordvarchar 50 NO 8dbnamevarchar 50 NO 9charsetvarchar 10 NO 键名类型字段 PRIMARYPRIMARYid siteidINDEXsiteid 表 28 v9 download ID字段类型Null默认额外 1idmediumint 8 unsigned PKauto increment 2catidsmallint 5 unsigned NO0 3typeidsmallint 5 unsigned NO 4titlevarchar 80 NO 5stylevarchar 24 NO 6thumbvarchar 100 NO 7keywordsvarchar 40 NO 8descriptionvarchar 255 NO 9posidstinyint 1 unsignedNO0 10urlvarchar 100 NO 11listordertinyint 3 unsignedNO0 12statustinyint 2 unsignedNO1 13sysaddtinyint 1 unsignedNO0 14islinktinyint 1 unsignedNO0 15usernamevarchar 20 NO 16inputtimeint 10 unsignedNO0 17updatetimeint 10 unsignedNO0 18systemsvarchar 100 NOWin2000 WinXP Win2003 19copytypevarchar 15 NO 20languagevarchar 10 NO 21classtypevarchar 20 NO 22versionvarchar 20 NO 23filesizevarchar 10 NO未知 24starsvarchar 20 NO 键名类型字段 PRIMARYPRIMARYid statusINDEXstatus statusINDEXlistorder statusINDEXid listorderINDEXcatid listorderINDEXstatus listorderINDEXlistorder listorderINDEXid catidINDEXcatid catidINDEXstatus catidINDEXid 表 29 v9 download data ID字段类型Null默认额外 1idmediumint 8 unsigned PK0 2contenttextNO 3readpointsmallint 5 unsigned NO0 4groupids viewvarchar 100 NO 5paginationtypetinyint 1 NO 6maxcharperpagemediumint 6 NO 7templatevarchar 30 NO 8paytypetinyint 1 unsignedNO0 9relationvarchar 255 NO 10allow commenttinyint 3 unsignedNO0 11downfilesmediumtextNO 12downfilevarchar 255 NO 键名类型字段 idINDEXid 表 30 v9 downservers 镜像服务器表 ID字段类型Null默认额外 1idmediumint 8 PKauto increment 2sitenamevarchar 100 YES 3siteurlvarchar 255 YES 4listordersmallint 5 unsigned NO0 5siteidsmallint 5 unsigned NO0 键名类型字段 PRIMARYPRIMARYid 表 31 v9 favorite 用户收藏表 ID字段类型Null默认额外 1idint 10 unsignedPKauto increment 2useridmediumint 8 unsigned NO0 3titlechar 100 NO 4urlchar 100 NO 5adddateint 10 unsignedNO0 键名类型字段 PRIMARYPRIMARYid useridINDEXuserid 表 32 v9 formguide ID字段类型Null默认额外 1formidsmallint 5 unsigned PKauto increment 2siteidsmallint 5 unsigned NO0 3namevarchar 30 NO 4tablenamevarchar 20 NO 5introducevarchar 255 NO 6settingtextNO 7addtimeint 10 unsignedNO 8itemsmediumint 8 unsigned NO0 9stylevarchar 20 NO 10templatevarchar 30 NO 11disabledtinyint 1 unsignedNO0 键名类型字段 PRIMARYPRIMARYformid formidINDEXformid formidINDEXsiteid siteidINDEXsiteid siteidINDEXdisabled 表 33 v9 formguide fields ID字段类型Null默认额外 1fieldidmediumint 8 unsigned PKauto increment 2formidsmallint 5 unsigned NO0 3siteidsmallint 5 unsigned NO0 4fieldvarchar 20 NO 5namevarchar 30 NO 6tipstextNO 7cssvarchar 30 NO 8minlengthint 10 unsignedNO0 9maxlengthint 10 unsignedNO0 10patternvarchar 255 NO 11errortipsvarchar 255 NO 12formtypevarchar 20 NO 13settingmediumtextNO 14formattributevarchar 255 NO 15unsetgroupidsvarchar 255 NO 16unsetroleidsvarchar 255 NO 17iscoretinyint 1 unsignedNO0 18issystemtinyint 1 unsignedNO0 19isuniquetinyint 1 unsignedNO0 20isbasetinyint 1 unsignedNO0 21issearchtinyint 1 unsignedNO0 22isselecttinyint 1 unsignedNO0 23iswheretinyint 1 unsignedNO0 24isordertinyint 1 unsignedNO0 25islisttinyint 1 unsignedNO0 26isshowtinyint 1 unsignedNO0 27isaddtinyint 1 unsignedNO0 28isfulltexttinyint 1 unsignedNO0 29ispositiontinyint 1 unsignedNO0 30listordermediumint 8 unsigned NO0 31disabledtinyint 1 unsignedNO0 32isomnipotenttinyint 1 unsignedNO0 键名类型字段 PRIMARYPRIMARYfieldid formidINDEXformid formidINDEXdisabled fieldINDEXfield fieldINDEXformid 表 34 v9 hits 访问统计 ID字段类型Null默认额外 1hitsidchar 30 PK 2viewsint 10 unsignedNO0 3yesterdayviewsint 10 unsignedNO0 4dayviewsint 10 unsignedNO0 5weekviewsint 10 unsignedNO0 6monthviewsint 10 unsignedNO0 7updatetimeint 10 unsignedNO0 键名类型字段 PRIMARYPRIMARYhitsid 表 35 v9 ipbanned IP禁止 ID字段类型Null默认额外 1ipbannedidsmallint 5 PKauto increment 2ipchar 15 NO 3expiresint 10 unsignedNO0 键名类型字段 PRIMARYPRIMARYipbannedid 表 36 v9 keylink 关联链接 ID字段类型Null默认额外 1keylinkidsmallint 5 unsigned PKauto increment 2wordchar 40 NO 3urlchar 100 NO 键名类型字段 PRIMARYPRIMARYkeylinkid 表 37 v9 link ID字段类型Null默认额外 1linkidsmallint 5 unsigned PKauto increment 2siteidsmallint 5 unsigned YES0 3typeidsmallint 5 unsigned NO0 4linktypetinyint 1 unsignedNO0 5namevarchar 50 NO 6urlvarchar 255 NO 7logovarchar 255 NO 8introducetextNO 9usernamevarchar 30 NO 10listordersmallint 5 unsigned NO0 11elitetinyint 1 unsignedNO0 12passedtinyint 1 unsignedNO0 13addtimeint 10 unsignedNO0 键名类型字段 PRIMARYPRIMARYlinkid typeidINDEXtypeid typeidINDEXpassed typeidINDEXlistorder typeidINDEXlinkid 表 38 v9 linkage 联动菜单表 ID字段类型Null默认额外 1linkageidsmallint 5 unsigned PKauto increment 2namevarchar 30 NO 3stylevarchar 35 NO 4parentidsmallint 5 unsigned NO0 5keyidsmallint 5 unsigned NO0 6listordersmallint 5 unsigned NO0 7descriptionvarchar 255 YES 8siteidsmallint 5 unsigned NO0 键名类型字段 PRIMARYPRIMARYlinkageid PRIMARYPRIMARYkeyid parentidINDEXparentid parentidINDEXlistorder 表 39 v9 log 操作日志 ID字段类型Null默认额外 1logidint 10 unsignedPKauto increment 2fieldvarchar 15 NO 3valueint 10 unsignedNO0 4modulevarchar 15 NO 5filevarchar 20 NO 6actionvarchar 20 NO 7querystringvarchar 255 NO 8datamediumtextNO 9useridmediumint 8 unsigned NO0 10usernamevarchar 20 NO 11ipvarchar 15 NO 12timedatetimeNO0000 00 00 00 00 00 键名类型字段 PRIMARYPRIMARYlogid moduleINDEXmodule moduleINDEXfile moduleINDEXaction usernameINDEXusername usernameINDEXaction 表 40 v9 member 会员表 ID字段类型Null默认额外 1useridmediumint 8 unsigned PKauto increment 2phpssouidmediumint 8 unsigned NO 3usernamechar 20 NO 4passwordchar 32 NO 5encryptchar 6 NO 6nicknamechar 20 NO 7regdateint 10 unsignedNO0 8lastdateint 10 unsignedNO0 9regipchar 15 NO 10lastipchar 15 NO 11loginnumsmallint 5 unsigned NO0 12emailchar 32 NO 13groupidtinyint 3 unsignedNO0 14areaidsmallint 5 unsigned NO0 15amountdecimal 8 2 unsignedNO0 16pointsmallint 5 unsigned NO0 17modelidsmallint 5 unsigned NO0 18messagetinyint 1 unsignedNO0 19islocktinyint 1 unsignedNO0 20viptinyint 1 unsignedNO0 21overduedateint 10 unsignedNO0 22siteidsmallint 5 unsigned NO1 键名类型字段 PRIMARYPRIMARYuserid usernameINDEXusername emailINDEXemail phpssouidINDEXphpssouid 表 41 v9 member detail 会员详细信息表 ID字段类型Null默认额外 1useridmediumint 8 unsigned PK0 2birthdaydateYES 键名类型字段 useridINDEXuserid 表 42 v9 member dt ID字段类型Null默认额外 1useridmediumint 8 unsigned PK 2codevarchar 255 NO 键名类型字段 useridINDEXuserid 表 43 v9 member group 用户组表 ID字段类型Null默认额外 1groupidtinyint 3 unsignedPKauto increment 2namechar 15 NO 3issystemtinyint 1 unsignedNO0 4starnumtinyint 2 unsignedNO 5pointsmallint 6 unsigned NO 6allowmessagesmallint 5 unsigned NO0 7allowvisittinyint 1 unsignedNO0 8allowposttinyint 1 unsignedNO0 9allowpostverifytinyint 1 unsignedNO 10allowsearchtinyint 1 unsignedNO0 11allowupgradetinyint 1 unsignedNO1 12allowsendmessagetinyint 1 unsignedNO 13allowpostnumsmallint 5 unsigned NO 14allowattachmenttinyint 1 NO 15price ydecimal 8 2 unsignedNO0 16price mdecimal 8 2 unsignedNO0 17price ddecimal 8 2 unsignedNO0 18iconchar 30 NO 19usernamecolorchar 7 NO 20descriptionchar 100 NO 21sorttinyint 3 unsignedNO0 22disabledtinyint 1 unsignedNO0 键名类型字段 PRIMARYPRIMARYgroupid disabledINDEXdisabled listorderINDEXsort 表 44 v9 member menu 会员前台菜单表 ID字段类型Null默认额外 1idsmallint 6 unsigned PKauto increment 2namechar 40 NO 3parentidsmallint 6 NO0 4mchar 20 NO 5cchar 20 NO 6achar 20 NO 7datachar 100 NO 8listordersmallint 6 unsigned NO0 9displayenum 1 0 NO1 10isurlenum 1 0 NO0 11urlchar 255 NO 键名类型字段 PRIMARYPRIMARYid listorderINDEXlistorder parentidINDEXparentid moduleINDEXm moduleINDEXc moduleINDEXa 表 45 v9 member verify 员会审核表 ID字段类型Null默认额外 1useridmediumint 8 unsigned PKauto increment 2usernamechar 20 NO 3passwordchar 32 NO 4encryptchar 6 NO 5nicknamechar 20 NO 6regdateint 10 unsignedNO 7regipchar 15 NO 8emailchar 32 NO 9modelidtinyint 3 unsignedNO0 10pointsmallint 5 unsigned NO0 11amountdecimal 8 2 unsignedNO0 12modelinfochar 255 NO0 13statustinyint 1 unsignedNO0 14siteidsmallint 5 unsigned NO1 15messagechar 100 YES 键名类型字段 PRIMARYPRIMARYuserid usernameINDEXusername emailINDEXemail 表 46 v9 member vip ID字段类型Null默认额外 1useridmediumint 8 unsigned PK0 键名类型字段 useridINDEXuserid 表 47 v9 menu 后台菜单 ID字段类型Null默认额外 1idsmallint 6 unsigned PKauto increment 2namechar 40 NO 3parentidsmallint 6 NO0 4mchar 20 NO 5cchar 20 NO 6achar 20 NO 7datachar 100 NO 8listordersmallint 6 unsigned NO0 9displayenum 1 0 NO1 键名类型字段 PRIMARYPRIMARYid listorderINDEXlistorder parentidINDEXparentid moduleINDEXm moduleINDEXc moduleINDEXa 表 48 v9 message 短消息 ID字段类型Null默认额外 1messageidint 10 unsignedPKauto increment 2send from idchar 30 NO0 3send to idchar 30 NO0 4folderenum all inbox outbox NO 5statustinyint 1 unsignedNO0 6message timeint 10 unsignedNO0 7subjectchar 80 YES 8contenttextNO 9replyidint 10 unsignedNO0 10del typetinyint 1 unsignedYES0 键名类型字段 PRIMARYPRIMARYmessageid msgtoidINDEXsend to id msgtoidINDEXfolder replyidINDEXreplyid folderINDEXsend from id folderINDEXfolder 表 49 v9 message data 群发消息查看统计表 ID字段类型Null默认额外 1idint 4 PKauto increment 2useridmediumint 8 NO 3group message idint 5 NO 键名类型字段 PRIMARYPRIMARYid messageINDEXuserid messageINDEXgroup message id 表 50 v9 message group 消息群发 ID字段类型Null默认额外 1idsmallint 5 unsigned PKauto increment 2typeidsmallint 5 unsigned NO0 3groupidtinyint 4 unsignedNO0 4subjectchar 80 YES 5contenttextNO 6inputtimeint 10 unsignedYES0 7statustinyint 2 unsignedYES1 键名类型字段 PRIMARYPRIMARYid 表 51 v9 model 模型表 ID字段类型Null默认额外 1modelidsmallint 5 unsigned PKauto increment 2siteidsmallint 5 unsigned NO0 3namechar 30 NO 4descriptionchar 100 NO 5tablenamechar 20 NO 6settingtextNO 7addtimeint 10 unsignedNO0 8itemssmallint 5 unsigned NO0 9enablesearchtinyint 1 unsignedNO1 10disabledtinyint 1 u