简单代码
beta
第三方组件
网站程序数据库结构
animationdedecms57discuz34discuze33emlog531emlogprophpwind901thinksaas24typecho11typechowecenter321wordpress494xiunobbs404zblogphp170
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
common_admincp id NO smallint smallint(6) unsigned PRI auto_increment
common_admincp title NO varchar 255 765 utf8 utf8_general_ci varchar(255)
common_admincp url NO varchar 255 765 utf8 utf8_general_ci varchar(255)
common_admincp sort 0 NO tinyint tinyint(1)
common_admincp displayorder NO tinyint tinyint(3) MUL
common_admincp clicks 1 NO smallint smallint(6) unsigned
common_admincp uid NO mediumint mediumint(8) unsigned MUL
common_admincp dateline NO int int(10) unsigned
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
common_admincp cpgroupid NO smallint smallint(6) unsigned PRI auto_increment
common_admincp cpgroupname NO varchar 255 765 utf8 utf8_general_ci varchar(255)
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
common_admincp uid NO int int(10) unsigned PRI
common_admincp cpgroupid NO int int(10) unsigned
common_admincp customperm NO text 65535 65535 utf8 utf8_general_ci text
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
common_admincp cpgroupid NO smallint smallint(6) unsigned PRI
common_admincp perm NO varchar 255 765 utf8 utf8_general_ci varchar(255) PRI
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
common_admincp uid 0 NO mediumint mediumint(8) unsigned PRI
common_admincp adminid 0 NO smallint smallint(6) unsigned
common_admincp panel 0 NO tinyint tinyint(1) PRI
common_admincp ip NO varchar 15 45 utf8 utf8_general_ci varchar(15)
common_admincp dateline 0 NO int int(10) unsigned
common_admincp errorcount 0 NO tinyint tinyint(1)
common_admincp storage NO mediumtext 16777215 16777215 utf8 utf8_general_ci mediumtext
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
common_admingroup admingid 0 NO smallint smallint(6) unsigned PRI
common_admingroup alloweditpost 0 NO tinyint tinyint(1)
common_admingroup alloweditpoll 0 NO tinyint tinyint(1)
common_admingroup allowstickthread 0 NO tinyint tinyint(1)
common_admingroup allowmodpost 0 NO tinyint tinyint(1)
common_admingroup allowdelpost 0 NO tinyint tinyint(1)
common_admingroup allowmassprune 0 NO tinyint tinyint(1)
common_admingroup allowrefund 0 NO tinyint tinyint(1)
common_admingroup allowcensorword 0 NO tinyint tinyint(1)
common_admingroup allowviewip 0 NO tinyint tinyint(1)
common_admingroup allowbanip 0 NO tinyint tinyint(1)
common_admingroup allowedituser 0 NO tinyint tinyint(1)
common_admingroup allowmoduser 0 NO tinyint tinyint(1)
common_admingroup allowbanuser 0 NO tinyint tinyint(1)
common_admingroup allowbanvisituser 0 NO tinyint tinyint(1)
common_admingroup allowpostannounce 0 NO tinyint tinyint(1)
common_admingroup allowviewlog 0 NO tinyint tinyint(1)
common_admingroup allowbanpost 0 NO tinyint tinyint(1)
common_admingroup supe_allowpushthread 0 NO tinyint tinyint(1)
common_admingroup allowhighlightthread 0 NO tinyint tinyint(1)
common_admingroup allowlivethread 0 NO tinyint tinyint(1)
common_admingroup allowdigestthread 0 NO tinyint tinyint(1)
common_admingroup allowrecommendthread 0 NO tinyint tinyint(1)
common_admingroup allowbumpthread 0 NO tinyint tinyint(1)
common_admingroup allowclosethread 0 NO tinyint tinyint(1)
common_admingroup allowmovethread 0 NO tinyint tinyint(1)
common_admingroup allowedittypethread 0 NO tinyint tinyint(1)
common_admingroup allowstampthread 0 NO tinyint tinyint(1)
common_admingroup allowstamplist 0 NO tinyint tinyint(1)
common_admingroup allowcopythread 0 NO tinyint tinyint(1)
common_admingroup allowmergethread 0 NO tinyint tinyint(1)
common_admingroup allowsplitthread 0 NO tinyint tinyint(1)
common_admingroup allowrepairthread 0 NO tinyint tinyint(1)
common_admingroup allowwarnpost 0 NO tinyint tinyint(1)
common_admingroup allowviewreport 0 NO tinyint tinyint(1)
common_admingroup alloweditforum 0 NO tinyint tinyint(1)
common_admingroup allowremovereward 0 NO tinyint tinyint(1)
common_admingroup allowedittrade 0 NO tinyint tinyint(1)
common_admingroup alloweditactivity 0 NO tinyint tinyint(1)
common_admingroup allowstickreply 0 NO tinyint tinyint(1)
common_admingroup allowmanagearticle 0 NO tinyint tinyint(1)
common_admingroup allowaddtopic 0 NO tinyint tinyint(1)
common_admingroup allowmanagetopic 0 NO tinyint tinyint(1)
common_admingroup allowdiy 0 NO tinyint tinyint(1)
common_admingroup allowclearrecycle 0 NO tinyint tinyint(1)
common_admingroup allowmanagetag 0 NO tinyint tinyint(1)
common_admingroup alloweditusertag 0 NO tinyint tinyint(1)
common_admingroup managefeed 0 NO tinyint tinyint(1)
common_admingroup managedoing 0 NO tinyint tinyint(1)
common_admingroup manageshare 0 NO tinyint tinyint(1)
common_admingroup manageblog 0 NO tinyint tinyint(1)
common_admingroup managealbum 0 NO tinyint tinyint(1)
common_admingroup managecomment 0 NO tinyint tinyint(1)
common_admingroup managemagiclog 0 NO tinyint tinyint(1)
common_admingroup managereport 0 NO tinyint tinyint(1)
common_admingroup managehotuser 0 NO tinyint tinyint(1)
common_admingroup managedefaultuser 0 NO tinyint tinyint(1)
common_admingroup managevideophoto 0 NO tinyint tinyint(1)
common_admingroup managemagic 0 NO tinyint tinyint(1)
common_admingroup manageclick 0 NO tinyint tinyint(1)
common_admingroup allowmanagecollection 0 NO tinyint tinyint(1)
common_admingroup allowmakehtml 0 NO tinyint tinyint(1)
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
common_adminnote id NO mediumint mediumint(8) unsigned PRI auto_increment
common_adminnote admin NO varchar 15 45 utf8 utf8_general_ci varchar(15)
common_adminnote access 0 NO tinyint tinyint(3)
common_adminnote adminid 0 NO tinyint tinyint(3)
common_adminnote dateline 0 NO int int(10) unsigned
common_adminnote expiration 0 NO int int(10) unsigned
common_adminnote message NO text 65535 65535 utf8 utf8_general_ci text
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
common_advertisement advid NO mediumint mediumint(8) unsigned PRI auto_increment
common_advertisement available 0 NO tinyint tinyint(1)
common_advertisement type 0 NO varchar 50 150 utf8 utf8_general_ci varchar(50)
common_advertisement displayorder 0 NO tinyint tinyint(3)
common_advertisement title NO varchar 255 765 utf8 utf8_general_ci varchar(255)
common_advertisement targets NO text 65535 65535 utf8 utf8_general_ci text
common_advertisement parameters NO text 65535 65535 utf8 utf8_general_ci text
common_advertisement code NO text 65535 65535 utf8 utf8_general_ci text
common_advertisement starttime 0 NO int int(10) unsigned
common_advertisement endtime 0 NO int int(10) unsigned
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
common_advertisement id NO smallint smallint(5) unsigned PRI auto_increment
common_advertisement name NO varchar 255 765 utf8 utf8_general_ci varchar(255) MUL
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
common_banned id NO smallint smallint(6) unsigned PRI auto_increment
common_banned ip1 0 NO smallint smallint(3)
common_banned ip2 0 NO smallint smallint(3)
common_banned ip3 0 NO smallint smallint(3)
common_banned ip4 0 NO smallint smallint(3)
common_banned admin NO varchar 15 45 utf8 utf8_general_ci varchar(15)
common_banned dateline 0 NO int int(10) unsigned
common_banned expiration 0 NO int int(10) unsigned
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
common_block bid NO mediumint mediumint(8) unsigned PRI auto_increment
common_block blockclass 0 NO varchar 255 765 utf8 utf8_general_ci varchar(255)
common_block blocktype 0 NO tinyint tinyint(1)
common_block name NO varchar 255 765 utf8 utf8_general_ci varchar(255)
common_block title NO text 65535 65535 utf8 utf8_general_ci text
common_block classname NO varchar 255 765 utf8 utf8_general_ci varchar(255)
common_block summary NO text 65535 65535 utf8 utf8_general_ci text
common_block uid 0 NO mediumint mediumint(8) unsigned
common_block username NO varchar 255 765 utf8 utf8_general_ci varchar(255)
common_block styleid 0 NO smallint smallint(6) unsigned
common_block blockstyle NO text 65535 65535 utf8 utf8_general_ci text
common_block picwidth 0 NO smallint smallint(6) unsigned
common_block picheight 0 NO smallint smallint(6) unsigned
common_block target NO varchar 255 765 utf8 utf8_general_ci varchar(255)
common_block dateformat NO varchar 255 765 utf8 utf8_general_ci varchar(255)
common_block dateuformat 0 NO tinyint tinyint(1)
common_block script NO varchar 255 765 utf8 utf8_general_ci varchar(255)
common_block param NO text 65535 65535 utf8 utf8_general_ci text
common_block shownum 0 NO smallint smallint(6) unsigned
common_block cachetime 0 NO int int(10)
common_block cachetimerange NO char 5 15 utf8 utf8_general_ci char(5)
common_block punctualupdate 0 NO tinyint tinyint(1)
common_block hidedisplay 0 NO tinyint tinyint(1)
common_block dateline 0 NO int int(10) unsigned
common_block notinherited 0 NO tinyint tinyint(1)
common_block isblank 0 NO tinyint tinyint(1)
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
common_block favid NO mediumint mediumint(8) unsigned PRI auto_increment
common_block uid 0 NO mediumint mediumint(8) unsigned MUL
common_block bid 0 NO mediumint mediumint(8) unsigned
common_block dateline 0 NO int int(10) unsigned
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
common_block itemid NO int int(10) unsigned PRI auto_increment
common_block bid 0 NO mediumint mediumint(8) unsigned MUL
common_block id 0 NO int int(10) unsigned
common_block idtype NO varchar 255 765 utf8 utf8_general_ci varchar(255)
common_block itemtype 0 NO tinyint tinyint(1)
common_block title NO varchar 255 765 utf8 utf8_general_ci varchar(255)
common_block url NO varchar 255 765 utf8 utf8_general_ci varchar(255)
common_block pic NO varchar 255 765 utf8 utf8_general_ci varchar(255)
common_block picflag 0 NO tinyint tinyint(1)
common_block makethumb 0 NO tinyint tinyint(1)
common_block thumbpath NO varchar 255 765 utf8 utf8_general_ci varchar(255)
common_block summary NO text 65535 65535 utf8 utf8_general_ci text
common_block showstyle NO text 65535 65535 utf8 utf8_general_ci text
common_block related NO text 65535 65535 utf8 utf8_general_ci text
common_block fields NO text 65535 65535 utf8 utf8_general_ci text
common_block displayorder 0 NO smallint smallint(6)
common_block startdate 0 NO int int(10) unsigned
common_block enddate 0 NO int int(10) unsigned
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
common_block dataid NO int int(10) unsigned PRI auto_increment
common_block bid 0 NO mediumint mediumint(8) unsigned MUL
common_block id 0 NO int int(10) unsigned
common_block idtype NO varchar 255 765 utf8 utf8_general_ci varchar(255)
common_block itemtype 0 NO tinyint tinyint(1)
common_block title NO varchar 255 765 utf8 utf8_general_ci varchar(255)
common_block url NO varchar 255 765 utf8 utf8_general_ci varchar(255)
common_block pic NO varchar 255 765 utf8 utf8_general_ci varchar(255)
common_block picflag 0 NO tinyint tinyint(1)
common_block makethumb 0 NO tinyint tinyint(1)
common_block summary NO text 65535 65535 utf8 utf8_general_ci text
common_block showstyle NO text 65535 65535 utf8 utf8_general_ci text
common_block related NO text 65535 65535 utf8 utf8_general_ci text
common_block fields NO text 65535 65535 utf8 utf8_general_ci text
common_block displayorder 0 NO smallint smallint(6)
common_block startdate 0 NO int int(10) unsigned
common_block enddate 0 NO int int(10) unsigned
common_block uid 0 NO mediumint mediumint(8) unsigned
common_block username NO varchar 255 765 utf8 utf8_general_ci varchar(255)
common_block dateline 0 NO int int(10) unsigned
common_block isverified 0 NO tinyint tinyint(1)
common_block verifiedtime 0 NO int int(10) unsigned
common_block stickgrade 0 NO tinyint tinyint(2) unsigned
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
common_block bid 0 NO mediumint mediumint(8) unsigned PRI
common_block uid 0 NO mediumint mediumint(8) unsigned PRI
common_block allowmanage 0 NO tinyint tinyint(1)
common_block allowrecommend 0 NO tinyint tinyint(1)
common_block needverify 0 NO tinyint tinyint(1)
common_block inheritedtplname NO varchar 255 765 utf8 utf8_general_ci varchar(255)
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
common_block picid NO int int(10) unsigned PRI auto_increment
common_block bid 0 NO mediumint mediumint(8) unsigned MUL
common_block itemid 0 NO int int(10) unsigned
common_block pic NO varchar 255 765 utf8 utf8_general_ci varchar(255)
common_block picflag 0 NO tinyint tinyint(1)
common_block type 0 NO tinyint tinyint(1)
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
common_block styleid NO smallint smallint(6) unsigned PRI auto_increment
common_block blockclass NO varchar 255 765 utf8 utf8_general_ci varchar(255) MUL
common_block name NO varchar 255 765 utf8 utf8_general_ci varchar(255)
common_block template NO text 65535 65535 utf8 utf8_general_ci text
common_block hash NO varchar 255 765 utf8 utf8_general_ci varchar(255) MUL
common_block getpic 0 NO tinyint tinyint(1)
common_block getsummary 0 NO tinyint tinyint(1)
common_block makethumb 0 NO tinyint tinyint(1)
common_block settarget 0 NO tinyint tinyint(1)
common_block fields NO text 65535 65535 utf8 utf8_general_ci text
common_block moreurl 0 NO tinyint tinyint(1)
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
common_block id NO smallint smallint(5) unsigned PRI auto_increment
common_block name NO varchar 255 765 utf8 utf8_general_ci varchar(255)
common_block version NO varchar 255 765 utf8 utf8_general_ci varchar(255)
common_block url NO varchar 255 765 utf8 utf8_general_ci varchar(255)
common_block clientid NO varchar 255 765 utf8 utf8_general_ci varchar(255)
common_block key NO varchar 255 765 utf8 utf8_general_ci varchar(255)
common_block signtype NO varchar 255 765 utf8 utf8_general_ci varchar(255)
common_block data NO text 65535 65535 utf8 utf8_general_ci text
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
common_cache cachekey NO varchar 255 765 utf8 utf8_general_ci varchar(255) PRI
common_cache cachevalue NO mediumblob 16777215 16777215 mediumblob
common_cache dateline 0 NO int int(10) unsigned
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
common_card id NO char 255 765 utf8 utf8_general_ci char(255) PRI
common_card typeid 1 NO smallint smallint(6) unsigned
common_card maketype 0 NO tinyint tinyint(1)
common_card makeruid 0 NO mediumint mediumint(8) unsigned
common_card price 0 NO mediumint mediumint(8) unsigned
common_card extcreditskey 0 NO tinyint tinyint(1)
common_card extcreditsval 0 NO int int(10)
common_card status 1 NO tinyint tinyint(1) unsigned
common_card dateline 0 NO int int(10) unsigned MUL
common_card cleardateline 0 NO int int(10) unsigned
common_card useddateline 0 NO int int(10) unsigned
common_card uid 0 NO mediumint mediumint(8) unsigned
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
common_card id NO smallint smallint(6) PRI auto_increment
common_card uid 0 NO mediumint mediumint(8)
common_card username NO varchar 20 60 utf8 utf8_general_ci varchar(20)
common_card cardrule NO varchar 255 765 utf8 utf8_general_ci varchar(255)
common_card info NO text 65535 65535 utf8 utf8_general_ci text
common_card dateline 0 NO int int(10) unsigned MUL
common_card description NO mediumtext 16777215 16777215 utf8 utf8_general_ci mediumtext
common_card operation 0 NO tinyint tinyint(1) MUL
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
common_card id NO smallint smallint(6) PRI auto_increment
common_card typename NO char 20 60 utf8 utf8_general_ci char(20)
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
common_connect conopenid NO char 32 96 utf8 utf8_general_ci char(32) PRI
common_connect conuin NO char 40 120 utf8 utf8_general_ci char(40)
common_connect conuinsecret NO char 16 48 utf8 utf8_general_ci char(16)
common_connect conqqnick NO char 100 300 utf8 utf8_general_ci char(100)
common_connect conuintoken NO char 32 96 utf8 utf8_general_ci char(32)
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
common_credit logid NO mediumint mediumint(8) unsigned PRI auto_increment
common_credit uid 0 NO mediumint mediumint(8) unsigned MUL
common_credit operation NO char 3 9 utf8 utf8_general_ci char(3) MUL
common_credit relatedid NO int int(10) unsigned MUL
common_credit dateline NO int int(10) unsigned MUL
common_credit extcredits1 NO int int(10)
common_credit extcredits2 NO int int(10)
common_credit extcredits3 NO int int(10)
common_credit extcredits4 NO int int(10)
common_credit extcredits5 NO int int(10)
common_credit extcredits6 NO int int(10)
common_credit extcredits7 NO int int(10)
common_credit extcredits8 NO int int(10)
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
common_credit logid NO mediumint mediumint(8) unsigned MUL
common_credit title NO varchar 100 300 utf8 utf8_general_ci varchar(100)
common_credit text NO text 65535 65535 utf8 utf8_general_ci text
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
common_credit rid NO mediumint mediumint(8) unsigned PRI auto_increment
common_credit rulename NO varchar 20 60 utf8 utf8_general_ci varchar(20)
common_credit action NO varchar 20 60 utf8 utf8_general_ci varchar(20) UNI
common_credit cycletype 0 NO tinyint tinyint(1)
common_credit cycletime 0 NO int int(10)
common_credit rewardnum 1 NO tinyint tinyint(2)
common_credit norepeat 0 NO tinyint tinyint(1)
common_credit extcredits1 0 NO int int(10)
common_credit extcredits2 0 NO int int(10)
common_credit extcredits3 0 NO int int(10)
common_credit extcredits4 0 NO int int(10)
common_credit extcredits5 0 NO int int(10)
common_credit extcredits6 0 NO int int(10)
common_credit extcredits7 0 NO int int(10)
common_credit extcredits8 0 NO int int(10)
common_credit fids NO text 65535 65535 utf8 utf8_general_ci text
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
common_credit clid NO mediumint mediumint(8) unsigned PRI auto_increment
common_credit uid 0 NO mediumint mediumint(8) unsigned MUL
common_credit rid 0 NO mediumint mediumint(8) unsigned
common_credit fid 0 NO mediumint mediumint(8) unsigned
common_credit total 0 NO mediumint mediumint(8) unsigned
common_credit cyclenum 0 NO mediumint mediumint(8) unsigned
common_credit extcredits1 0 NO int int(10)
common_credit extcredits2 0 NO int int(10)
common_credit extcredits3 0 NO int int(10)
common_credit extcredits4 0 NO int int(10)
common_credit extcredits5 0 NO int int(10)
common_credit extcredits6 0 NO int int(10)
common_credit extcredits7 0 NO int int(10)
common_credit extcredits8 0 NO int int(10)
common_credit starttime 0 NO int int(10) unsigned
common_credit dateline 0 NO int int(10) unsigned MUL
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
common_credit clid 0 NO mediumint mediumint(8) unsigned PRI
common_credit uid 0 NO mediumint mediumint(8) unsigned PRI
common_credit info NO text 65535 65535 utf8 utf8_general_ci text
common_credit user NO text 65535 65535 utf8 utf8_general_ci text
common_credit app NO text 65535 65535 utf8 utf8_general_ci text
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
common_cron cronid NO smallint smallint(6) unsigned PRI auto_increment
common_cron available 0 NO tinyint tinyint(1) MUL
common_cron type user NO enum 6 18 utf8 utf8_general_ci enum('user','system','plugin')
common_cron name NO char 50 150 utf8 utf8_general_ci char(50)
common_cron filename NO char 50 150 utf8 utf8_general_ci char(50)
common_cron lastrun 0 NO int int(10) unsigned
common_cron nextrun 0 NO int int(10) unsigned
common_cron weekday 0 NO tinyint tinyint(1)
common_cron day 0 NO tinyint tinyint(2)
common_cron hour 0 NO tinyint tinyint(2)
common_cron minute NO char 36 108 utf8 utf8_general_ci char(36)
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
common_devicetoken uid NO mediumint mediumint(8) unsigned PRI
common_devicetoken token NO char 50 150 utf8 utf8_general_ci char(50) MUL
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
common_district id NO mediumint mediumint(8) unsigned PRI auto_increment
common_district name NO varchar 255 765 utf8 utf8_general_ci varchar(255)
common_district level 0 NO tinyint tinyint(4) unsigned
common_district usetype 0 NO tinyint tinyint(1) unsigned
common_district upid 0 NO mediumint mediumint(8) unsigned MUL
common_district displayorder 0 NO smallint smallint(6)
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
common_diy targettplname NO varchar 100 300 utf8 utf8_general_ci varchar(100) PRI
common_diy tpldirectory NO varchar 80 240 utf8 utf8_general_ci varchar(80) PRI
common_diy primaltplname NO varchar 255 765 utf8 utf8_general_ci varchar(255)
common_diy diycontent NO mediumtext 16777215 16777215 utf8 utf8_general_ci mediumtext
common_diy name NO varchar 255 765 utf8 utf8_general_ci varchar(255)
common_diy uid 0 NO mediumint mediumint(8) unsigned
common_diy username NO varchar 15 45 utf8 utf8_general_ci varchar(15)
common_diy dateline 0 NO int int(10) unsigned
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
common_domain domain NO char 30 90 utf8 utf8_general_ci char(30) MUL
common_domain domainroot NO char 60 180 utf8 utf8_general_ci char(60)
common_domain id 0 NO mediumint mediumint(8) unsigned PRI
common_domain idtype NO char 15 45 utf8 utf8_general_ci char(15) PRI
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
common_failedip ip NO char 7 21 utf8 utf8_general_ci char(7) PRI
common_failedip lastupdate 0 NO int int(10) unsigned PRI
common_failedip count 0 NO tinyint tinyint(1) unsigned
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
common_failedlogin ip NO char 15 45 utf8 utf8_general_ci char(15) PRI
common_failedlogin username NO char 32 96 utf8 utf8_general_ci char(32) PRI
common_failedlogin count 0 NO tinyint tinyint(1) unsigned
common_failedlogin lastupdate 0 NO int int(10) unsigned
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
common_friendlink id NO smallint smallint(6) unsigned PRI auto_increment
common_friendlink displayorder 0 NO tinyint tinyint(3)
common_friendlink name NO varchar 100 300 utf8 utf8_general_ci varchar(100)
common_friendlink url NO varchar 255 765 utf8 utf8_general_ci varchar(255)
common_friendlink description NO mediumtext 16777215 16777215 utf8 utf8_general_ci mediumtext
common_friendlink logo NO varchar 255 765 utf8 utf8_general_ci varchar(255)
common_friendlink type 0 NO tinyint tinyint(3)
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
common_grouppm id NO smallint smallint(6) unsigned PRI auto_increment
common_grouppm authorid 0 NO mediumint mediumint(8) unsigned
common_grouppm author NO varchar 15 45 utf8 utf8_general_ci varchar(15)
common_grouppm dateline 0 NO int int(10) unsigned
common_grouppm message NO text 65535 65535 utf8 utf8_general_ci text
common_grouppm numbers 0 NO mediumint mediumint(8) unsigned
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
common_invite id NO mediumint mediumint(8) unsigned PRI auto_increment
common_invite uid 0 NO mediumint mediumint(8) unsigned MUL
common_invite code NO char 20 60 utf8 utf8_general_ci char(20)
common_invite fuid 0 NO mediumint mediumint(8) unsigned
common_invite fusername NO char 20 60 utf8 utf8_general_ci char(20)
common_invite type 0 NO tinyint tinyint(1)
common_invite email NO char 40 120 utf8 utf8_general_ci char(40)
common_invite inviteip NO char 15 45 utf8 utf8_general_ci char(15)
common_invite appid 0 NO mediumint mediumint(8) unsigned
common_invite dateline 0 NO int int(10) unsigned
common_invite endtime 0 NO int int(10) unsigned
common_invite regdateline 0 NO int int(10) unsigned
common_invite status 1 NO tinyint tinyint(1)
common_invite orderid NO char 32 96 utf8 utf8_general_ci char(32)
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
common_magic magicid NO smallint smallint(6) unsigned PRI auto_increment
common_magic available 0 NO tinyint tinyint(1) MUL
common_magic name NO varchar 50 150 utf8 utf8_general_ci varchar(50)
common_magic identifier NO varchar 40 120 utf8 utf8_general_ci varchar(40) UNI
common_magic description NO varchar 255 765 utf8 utf8_general_ci varchar(255)
common_magic displayorder 0 NO tinyint tinyint(3)
common_magic credit 0 NO tinyint tinyint(1)
common_magic price 0 NO mediumint mediumint(8) unsigned
common_magic num 0 NO smallint smallint(6) unsigned
common_magic salevolume 0 NO smallint smallint(6) unsigned
common_magic supplytype 0 NO tinyint tinyint(1)
common_magic supplynum 0 NO smallint smallint(6) unsigned
common_magic useperoid 0 NO tinyint tinyint(1)
common_magic usenum 0 NO smallint smallint(6) unsigned
common_magic weight 1 NO tinyint tinyint(3) unsigned
common_magic magicperm NO text 65535 65535 utf8 utf8_general_ci text
common_magic useevent 0 NO tinyint tinyint(1)
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
common_magiclog uid 0 NO mediumint mediumint(8) unsigned MUL
common_magiclog magicid 0 NO smallint smallint(6) unsigned MUL
common_magiclog action 0 NO tinyint tinyint(1) MUL
common_magiclog dateline 0 NO int int(10) unsigned
common_magiclog amount 0 NO smallint smallint(6) unsigned
common_magiclog credit 0 NO tinyint tinyint(1) unsigned
common_magiclog price 0 NO mediumint mediumint(8) unsigned
common_magiclog targetid 0 NO int int(10) unsigned
common_magiclog idtype YES char 6 18 utf8 utf8_general_ci char(6)
common_magiclog targetuid 0 NO mediumint mediumint(8) unsigned MUL
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
common_mailcron cid NO mediumint mediumint(8) unsigned PRI auto_increment
common_mailcron touid 0 NO mediumint mediumint(8) unsigned
common_mailcron email NO varchar 100 300 utf8 utf8_general_ci varchar(100)
common_mailcron sendtime 0 NO int int(10) unsigned MUL
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
common_mailqueue qid NO mediumint mediumint(8) unsigned PRI auto_increment
common_mailqueue cid 0 NO mediumint mediumint(8) unsigned MUL
common_mailqueue subject NO text 65535 65535 utf8 utf8_general_ci text
common_mailqueue message NO text 65535 65535 utf8 utf8_general_ci text
common_mailqueue dateline 0 NO int int(10) unsigned
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
common_member uid NO mediumint mediumint(8) unsigned PRI auto_increment
common_member email NO char 40 120 utf8 utf8_general_ci char(40) MUL
common_member username NO char 15 45 utf8 utf8_general_ci char(15) UNI
common_member password NO char 32 96 utf8 utf8_general_ci char(32)
common_member status 0 NO tinyint tinyint(1)
common_member emailstatus 0 NO tinyint tinyint(1)
common_member avatarstatus 0 NO tinyint tinyint(1)
common_member videophotostatus 0 NO tinyint tinyint(1)
common_member adminid 0 NO tinyint tinyint(1)
common_member groupid 0 NO smallint smallint(6) unsigned MUL
common_member groupexpiry 0 NO int int(10) unsigned
common_member extgroupids NO char 20 60 utf8 utf8_general_ci char(20)
common_member regdate 0 NO int int(10) unsigned MUL
common_member credits 0 NO int int(10)
common_member notifysound 0 NO tinyint tinyint(1)
common_member timeoffset NO char 4 12 utf8 utf8_general_ci char(4)
common_member newpm 0 NO smallint smallint(6) unsigned
common_member newprompt 0 NO smallint smallint(6) unsigned
common_member accessmasks 0 NO tinyint tinyint(1)
common_member allowadmincp 0 NO tinyint tinyint(1)
common_member onlyacceptfriendpm 0 NO tinyint tinyint(1)
common_member conisbind 0 NO tinyint tinyint(1) unsigned MUL
common_member freeze 0 NO tinyint tinyint(1)
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
common_member id NO mediumint mediumint(8) unsigned PRI auto_increment
common_member uid 0 NO mediumint mediumint(8) unsigned
common_member action 0 NO tinyint tinyint(5)
common_member dateline 0 NO int int(10) unsigned MUL
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
common_member uid 0 NO mediumint mediumint(8) unsigned PRI
common_member conuin NO char 40 120 utf8 utf8_general_ci char(40) MUL
common_member conuinsecret NO char 16 48 utf8 utf8_general_ci char(16)
common_member conopenid NO char 32 96 utf8 utf8_general_ci char(32) MUL
common_member conisfeed 0 NO tinyint tinyint(1) unsigned
common_member conispublishfeed 0 NO tinyint tinyint(1) unsigned
common_member conispublisht 0 NO tinyint tinyint(1) unsigned
common_member conisregister 0 NO tinyint tinyint(1) unsigned
common_member conisqzoneavatar 0 NO tinyint tinyint(1) unsigned
common_member conisqqshow 0 NO tinyint tinyint(1) unsigned
common_member conuintoken NO char 32 96 utf8 utf8_general_ci char(32)
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
common_member uid NO mediumint mediumint(8) unsigned PRI
common_member extcredits1 0 NO int int(10)
common_member extcredits2 0 NO int int(10)
common_member extcredits3 0 NO int int(10)
common_member extcredits4 0 NO int int(10)
common_member extcredits5 0 NO int int(10)
common_member extcredits6 0 NO int int(10)
common_member extcredits7 0 NO int int(10)
common_member extcredits8 0 NO int int(10)
common_member friends 0 NO smallint smallint(6) unsigned
common_member posts 0 NO mediumint mediumint(8) unsigned MUL
common_member threads 0 NO mediumint mediumint(8) unsigned
common_member digestposts 0 NO smallint smallint(6) unsigned
common_member doings 0 NO smallint smallint(6) unsigned
common_member blogs 0 NO smallint smallint(6) unsigned
common_member albums 0 NO smallint smallint(6) unsigned
common_member sharings 0 NO smallint smallint(6) unsigned
common_member attachsize 0 NO int int(10) unsigned
common_member views 0 NO mediumint mediumint(8) unsigned
common_member oltime 0 NO smallint smallint(6) unsigned
common_member todayattachs 0 NO smallint smallint(6) unsigned
common_member todayattachsize 0 NO int int(10) unsigned
common_member feeds 0 NO mediumint mediumint(8) unsigned
common_member follower 0 NO mediumint mediumint(8) unsigned
common_member following 0 NO mediumint mediumint(8) unsigned
common_member newfollower 0 NO mediumint mediumint(8) unsigned
common_member blacklist 0 NO mediumint mediumint(8) unsigned
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
common_member cid NO mediumint mediumint(8) unsigned PRI auto_increment
common_member uid 0 NO mediumint mediumint(8) unsigned MUL
common_member operatorid 0 NO mediumint mediumint(8) unsigned
common_member operator NO varchar 15 45 utf8 utf8_general_ci varchar(15)
common_member action NO tinyint tinyint(5)
common_member reason NO text 65535 65535 utf8 utf8_general_ci text
common_member dateline 0 NO int int(10) unsigned
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
common_member uid NO mediumint mediumint(8) unsigned PRI
common_member publishfeed 0 NO tinyint tinyint(3)
common_member customshow 26 NO tinyint tinyint(1) unsigned
common_member customstatus NO varchar 30 90 utf8 utf8_general_ci varchar(30)
common_member medals NO text 65535 65535 utf8 utf8_general_ci text
common_member sightml NO text 65535 65535 utf8 utf8_general_ci text
common_member groupterms NO text 65535 65535 utf8 utf8_general_ci text
common_member authstr NO varchar 20 60 utf8 utf8_general_ci varchar(20)
common_member groups NO mediumtext 16777215 16777215 utf8 utf8_general_ci mediumtext
common_member attentiongroup NO varchar 255 765 utf8 utf8_general_ci varchar(255)
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
common_member uid NO mediumint mediumint(8) unsigned PRI
common_member videophoto NO varchar 255 765 utf8 utf8_general_ci varchar(255)
common_member spacename NO varchar 255 765 utf8 utf8_general_ci varchar(255)
common_member spacedescription NO varchar 255 765 utf8 utf8_general_ci varchar(255)
common_member domain NO char 15 45 utf8 utf8_general_ci char(15) MUL
common_member addsize 0 NO int int(10) unsigned
common_member addfriend 0 NO smallint smallint(6) unsigned
common_member menunum 0 NO smallint smallint(6) unsigned
common_member theme NO varchar 20 60 utf8 utf8_general_ci varchar(20)
common_member spacecss NO text 65535 65535 utf8 utf8_general_ci text
common_member blockposition NO text 65535 65535 utf8 utf8_general_ci text
common_member recentnote NO text 65535 65535 utf8 utf8_general_ci text
common_member spacenote NO text 65535 65535 utf8 utf8_general_ci text
common_member privacy NO text 65535 65535 utf8 utf8_general_ci text
common_member feedfriend NO mediumtext 16777215 16777215 utf8 utf8_general_ci mediumtext
common_member acceptemail NO text 65535 65535 utf8 utf8_general_ci text
common_member magicgift NO text 65535 65535 utf8 utf8_general_ci text
common_member stickblogs NO text 65535 65535 utf8 utf8_general_ci text
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
common_member uid NO mediumint mediumint(8) unsigned PRI
common_member fid 0 NO mediumint mediumint(8) unsigned PRI
common_member credits 0 NO int int(10) unsigned
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
common_member uid 0 NO mediumint mediumint(8) unsigned PRI
common_member gpmid NO smallint smallint(6) unsigned PRI auto_increment
common_member status 0 NO tinyint tinyint(1)
common_member dateline 0 NO int int(10) unsigned
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
common_member uid 0 NO mediumint mediumint(8) unsigned PRI
common_member action NO char 10 30 utf8 utf8_general_ci char(10)
common_member dateline 0 NO int int(10) unsigned
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
common_member uid 0 NO mediumint mediumint(8) unsigned PRI
common_member magicid 0 NO smallint smallint(6) unsigned PRI
common_member num 0 NO smallint smallint(6) unsigned
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
common_member uid NO mediumint mediumint(8) unsigned PRI
common_member medalid NO smallint smallint(6) unsigned PRI
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
common_member uid NO mediumint mediumint(8) unsigned PRI
common_member data NO varchar 255 765 utf8 utf8_general_ci varchar(255)
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
common_member uid NO mediumint mediumint(8) unsigned PRI
common_member realname NO varchar 255 765 utf8 utf8_general_ci varchar(255)
common_member gender 0 NO tinyint tinyint(1)
common_member birthyear 0 NO smallint smallint(6) unsigned
common_member birthmonth 0 NO tinyint tinyint(3) unsigned
common_member birthday 0 NO tinyint tinyint(3) unsigned
common_member constellation NO varchar 255 765 utf8 utf8_general_ci varchar(255)
common_member zodiac NO varchar 255 765 utf8 utf8_general_ci varchar(255)
common_member telephone NO varchar 255 765 utf8 utf8_general_ci varchar(255)
common_member mobile NO varchar 255 765 utf8 utf8_general_ci varchar(255)
common_member idcardtype NO varchar 255 765 utf8 utf8_general_ci varchar(255)
common_member idcard NO varchar 255 765 utf8 utf8_general_ci varchar(255)
common_member address NO varchar 255 765 utf8 utf8_general_ci varchar(255)
common_member zipcode NO varchar 255 765 utf8 utf8_general_ci varchar(255)
common_member nationality NO varchar 255 765 utf8 utf8_general_ci varchar(255)
common_member birthprovince NO varchar 255 765 utf8 utf8_general_ci varchar(255)
common_member birthcity NO varchar 255 765 utf8 utf8_general_ci varchar(255)
common_member birthdist NO varchar 20 60 utf8 utf8_general_ci varchar(20)
common_member birthcommunity NO varchar 255 765 utf8 utf8_general_ci varchar(255)
common_member resideprovince NO varchar 255 765 utf8 utf8_general_ci varchar(255)
common_member residecity NO varchar 255 765 utf8 utf8_general_ci varchar(255)
common_member residedist NO varchar 20 60 utf8 utf8_general_ci varchar(20)
common_member residecommunity NO varchar 255 765 utf8 utf8_general_ci varchar(255)
common_member residesuite NO varchar 255 765 utf8 utf8_general_ci varchar(255)
common_member graduateschool NO varchar 255 765 utf8 utf8_general_ci varchar(255)
common_member company NO varchar 255 765 utf8 utf8_general_ci varchar(255)
common_member education NO varchar 255 765 utf8 utf8_general_ci varchar(255)
common_member occupation NO varchar 255 765 utf8 utf8_general_ci varchar(255)
common_member position NO varchar 255 765 utf8 utf8_general_ci varchar(255)
common_member revenue NO varchar 255 765 utf8 utf8_general_ci varchar(255)
common_member affectivestatus NO varchar 255 765 utf8 utf8_general_ci varchar(255)
common_member lookingfor NO varchar 255 765 utf8 utf8_general_ci varchar(255)
common_member bloodtype NO varchar 255 765 utf8 utf8_general_ci varchar(255)
common_member height NO varchar 255 765 utf8 utf8_general_ci varchar(255)
common_member weight NO varchar 255 765 utf8 utf8_general_ci varchar(255)
common_member alipay NO varchar 255 765 utf8 utf8_general_ci varchar(255)
common_member icq NO varchar 255 765 utf8 utf8_general_ci varchar(255)
common_member qq NO varchar 255 765 utf8 utf8_general_ci varchar(255)
common_member yahoo NO varchar 255 765 utf8 utf8_general_ci varchar(255)
common_member msn NO varchar 255 765 utf8 utf8_general_ci varchar(255)
common_member taobao NO varchar 255 765 utf8 utf8_general_ci varchar(255)
common_member site NO varchar 255 765 utf8 utf8_general_ci varchar(255)
common_member bio NO text 65535 65535 utf8 utf8_general_ci text
common_member interest NO text 65535 65535 utf8 utf8_general_ci text
common_member field1 NO text 65535 65535 utf8 utf8_general_ci text
common_member field2 NO text 65535 65535 utf8 utf8_general_ci text
common_member field3 NO text 65535 65535 utf8 utf8_general_ci text
common_member field4 NO text 65535 65535 utf8 utf8_general_ci text
common_member field5 NO text 65535 65535 utf8 utf8_general_ci text
common_member field6 NO text 65535 65535 utf8 utf8_general_ci text
common_member field7 NO text 65535 65535 utf8 utf8_general_ci text
common_member field8 NO text 65535 65535 utf8 utf8_general_ci text
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
common_member fieldid NO varchar 255 765 utf8 utf8_general_ci varchar(255) PRI
common_member available 0 NO tinyint tinyint(1)
common_member invisible 0 NO tinyint tinyint(1)
common_member needverify 0 NO tinyint tinyint(1)
common_member title NO varchar 255 765 utf8 utf8_general_ci varchar(255)
common_member description NO varchar 255 765 utf8 utf8_general_ci varchar(255)
common_member displayorder 0 NO smallint smallint(6) unsigned
common_member required 0 NO tinyint tinyint(1)
common_member unchangeable 0 NO tinyint tinyint(1)
common_member showincard 0 NO tinyint tinyint(1)
common_member showinthread 0 NO tinyint tinyint(1)
common_member showinregister 0 NO tinyint tinyint(1)
common_member allowsearch 0 NO tinyint tinyint(1)
common_member formtype NO varchar 255 765 utf8 utf8_general_ci varchar(255)
common_member size 0 NO smallint smallint(6) unsigned
common_member choices NO text 65535 65535 utf8 utf8_general_ci text
common_member validate NO text 65535 65535 utf8 utf8_general_ci text
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
common_member securityid NO mediumint mediumint(8) unsigned PRI auto_increment
common_member uid 0 NO mediumint mediumint(8) unsigned MUL
common_member username NO varchar 255 765 utf8 utf8_general_ci varchar(255)
common_member fieldid NO varchar 255 765 utf8 utf8_general_ci varchar(255)
common_member oldvalue NO text 65535 65535 utf8 utf8_general_ci text
common_member newvalue NO text 65535 65535 utf8 utf8_general_ci text
common_member dateline 0 NO int int(10) unsigned MUL
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
common_member uid NO int int(10) PRI
common_member dateline NO int int(10)
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
common_member optionid NO mediumint mediumint(8) unsigned PRI auto_increment
common_member fieldid NO varchar 255 765 utf8 utf8_general_ci varchar(255) MUL
common_member fieldvalue NO varchar 255 765 utf8 utf8_general_ci varchar(255)
common_member hash NO varchar 255 765 utf8 utf8_general_ci varchar(255)
common_member users 0 NO mediumint mediumint(8) unsigned
common_member updatetime 0 NO int int(10) unsigned
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
common_member uid NO mediumint mediumint(8) unsigned PRI
common_member regip NO char 15 45 utf8 utf8_general_ci char(15)
common_member lastip NO char 15 45 utf8 utf8_general_ci char(15)
common_member port 0 NO smallint smallint(6) unsigned
common_member lastvisit 0 NO int int(10) unsigned
common_member lastactivity 0 NO int int(10) unsigned MUL
common_member lastpost 0 NO int int(10) unsigned
common_member lastsendmail 0 NO int int(10) unsigned
common_member invisible 0 NO tinyint tinyint(1)
common_member buyercredit 0 NO smallint smallint(6)
common_member sellercredit 0 NO smallint smallint(6)
common_member favtimes 0 NO mediumint mediumint(8) unsigned
common_member sharetimes 0 NO mediumint mediumint(8) unsigned
common_member profileprogress 0 NO tinyint tinyint(2) unsigned
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
common_member uid 0 NO mediumint mediumint(8) unsigned PRI
common_member submitdate 0 NO int int(10) unsigned
common_member moddate 0 NO int int(10) unsigned
common_member admin NO varchar 15 45 utf8 utf8_general_ci varchar(15)
common_member submittimes 0 NO tinyint tinyint(3) unsigned
common_member status 0 NO tinyint tinyint(1) MUL
common_member message NO text 65535 65535 utf8 utf8_general_ci text
common_member remark NO text 65535 65535 utf8 utf8_general_ci text
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
common_member uid NO mediumint mediumint(8) unsigned PRI
common_member verify1 0 NO tinyint tinyint(1) MUL
common_member verify2 0 NO tinyint tinyint(1) MUL
common_member verify3 0 NO tinyint tinyint(1) MUL
common_member verify4 0 NO tinyint tinyint(1) MUL
common_member verify5 0 NO tinyint tinyint(1) MUL
common_member verify6 0 NO tinyint tinyint(1) MUL
common_member verify7 0 NO tinyint tinyint(1) MUL
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
common_member vid NO mediumint mediumint(8) unsigned PRI auto_increment
common_member uid 0 NO mediumint mediumint(8) unsigned MUL
common_member username NO varchar 30 90 utf8 utf8_general_ci varchar(30)
common_member verifytype 0 NO tinyint tinyint(1) MUL
common_member flag 0 NO tinyint tinyint(1)
common_member field NO text 65535 65535 utf8 utf8_general_ci text
common_member dateline 0 NO int int(10) unsigned
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
common_myapp appid 0 NO mediumint mediumint(8) unsigned PRI
common_myapp appname NO varchar 60 180 utf8 utf8_general_ci varchar(60)
common_myapp narrow 0 NO tinyint tinyint(1)
common_myapp flag 0 NO tinyint tinyint(1) MUL
common_myapp version 0 NO mediumint mediumint(8) unsigned
common_myapp userpanelarea 0 NO tinyint tinyint(1)
common_myapp canvastitle NO varchar 60 180 utf8 utf8_general_ci varchar(60)
common_myapp fullscreen 0 NO tinyint tinyint(1)
common_myapp displayuserpanel 0 NO tinyint tinyint(1)
common_myapp displaymethod 0 NO tinyint tinyint(1)
common_myapp displayorder 0 NO smallint smallint(6) unsigned
common_myapp appstatus 0 NO tinyint tinyint(2)
common_myapp iconstatus 0 NO tinyint tinyint(2)
common_myapp icondowntime 0 NO int int(10) unsigned
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
common_myinvite id NO mediumint mediumint(8) unsigned PRI auto_increment
common_myinvite typename NO varchar 100 300 utf8 utf8_general_ci varchar(100)
common_myinvite appid 0 NO mediumint mediumint(8)
common_myinvite type 0 NO tinyint tinyint(1)
common_myinvite fromuid 0 NO mediumint mediumint(8) unsigned
common_myinvite touid 0 NO mediumint mediumint(8) unsigned MUL
common_myinvite myml NO text 65535 65535 utf8 utf8_general_ci text
common_myinvite dateline 0 NO int int(10) unsigned
common_myinvite hash 0 NO int int(10) unsigned MUL
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
common_mytask uid NO mediumint mediumint(8) unsigned PRI
common_mytask username NO char 15 45 utf8 utf8_general_ci char(15)
common_mytask taskid NO smallint smallint(6) unsigned PRI
common_mytask status 0 NO tinyint tinyint(1)
common_mytask csc NO char 255 765 utf8 utf8_general_ci char(255)
common_mytask dateline 0 NO int int(10) unsigned
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
common_nav id NO smallint smallint(6) unsigned PRI auto_increment
common_nav parentid 0 NO smallint smallint(6) unsigned
common_nav name NO varchar 255 765 utf8 utf8_general_ci varchar(255)
common_nav title NO varchar 255 765 utf8 utf8_general_ci varchar(255)
common_nav url NO varchar 255 765 utf8 utf8_general_ci varchar(255)
common_nav identifier NO varchar 255 765 utf8 utf8_general_ci varchar(255)
common_nav target 0 NO tinyint tinyint(1)
common_nav type 0 NO tinyint tinyint(1)
common_nav available 0 NO tinyint tinyint(1)
common_nav displayorder NO tinyint tinyint(3)
common_nav highlight 0 NO tinyint tinyint(1)
common_nav level 0 NO tinyint tinyint(1)
common_nav subtype 0 NO tinyint tinyint(1)
common_nav subcols 0 NO tinyint tinyint(1)
common_nav icon NO varchar 255 765 utf8 utf8_general_ci varchar(255)
common_nav subname NO varchar 255 765 utf8 utf8_general_ci varchar(255)
common_nav suburl NO varchar 255 765 utf8 utf8_general_ci varchar(255)
common_nav navtype 0 NO tinyint tinyint(1) MUL
common_nav logo NO varchar 255 765 utf8 utf8_general_ci varchar(255)
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
common_onlinetime uid 0 NO mediumint mediumint(8) unsigned PRI
common_onlinetime thismonth 0 NO smallint smallint(6) unsigned
common_onlinetime total 0 NO mediumint mediumint(8) unsigned
common_onlinetime lastupdate 0 NO int int(10) unsigned
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
common_optimizer k NO char 100 300 utf8 utf8_general_ci char(100) PRI
common_optimizer v NO char 255 765 utf8 utf8_general_ci char(255)
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
common_patch serial NO varchar 10 30 utf8 utf8_general_ci varchar(10) PRI
common_patch rule NO text 65535 65535 utf8 utf8_general_ci text
common_patch note NO text 65535 65535 utf8 utf8_general_ci text
common_patch status 0 NO tinyint tinyint(1)
common_patch dateline 0 NO int int(10) unsigned
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
common_plugin pluginid NO smallint smallint(6) unsigned PRI auto_increment
common_plugin available 0 NO tinyint tinyint(1)
common_plugin adminid 0 NO tinyint tinyint(1) unsigned
common_plugin name NO varchar 40 120 utf8 utf8_general_ci varchar(40)
common_plugin identifier NO varchar 40 120 utf8 utf8_general_ci varchar(40) UNI
common_plugin description NO varchar 255 765 utf8 utf8_general_ci varchar(255)
common_plugin datatables NO varchar 255 765 utf8 utf8_general_ci varchar(255)
common_plugin directory NO varchar 100 300 utf8 utf8_general_ci varchar(100)
common_plugin copyright NO varchar 100 300 utf8 utf8_general_ci varchar(100)
common_plugin modules NO text 65535 65535 utf8 utf8_general_ci text
common_plugin version NO varchar 20 60 utf8 utf8_general_ci varchar(20)
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
common_pluginvar pluginvarid NO mediumint mediumint(8) unsigned PRI auto_increment
common_pluginvar pluginid 0 NO smallint smallint(6) unsigned MUL
common_pluginvar displayorder 0 NO tinyint tinyint(3)
common_pluginvar title NO varchar 100 300 utf8 utf8_general_ci varchar(100)
common_pluginvar description NO varchar 255 765 utf8 utf8_general_ci varchar(255)
common_pluginvar variable NO varchar 40 120 utf8 utf8_general_ci varchar(40)
common_pluginvar type text NO varchar 20 60 utf8 utf8_general_ci varchar(20)
common_pluginvar value NO text 65535 65535 utf8 utf8_general_ci text
common_pluginvar extra NO text 65535 65535 utf8 utf8_general_ci text
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
common_process processid NO char 32 96 utf8 utf8_general_ci char(32) PRI
common_process expiry YES int int(10) MUL
common_process extra YES int int(10)
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
common_regip ip NO char 15 45 utf8 utf8_general_ci char(15) MUL
common_regip dateline 0 NO int int(10) unsigned
common_regip count 0 NO smallint smallint(6)
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
common_relatedlink id NO smallint smallint(6) unsigned PRI auto_increment
common_relatedlink name NO varchar 100 300 utf8 utf8_general_ci varchar(100)
common_relatedlink url NO varchar 255 765 utf8 utf8_general_ci varchar(255)
common_relatedlink extent 0 NO tinyint tinyint(3)
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
common_remote id 0 NO mediumint mediumint(8) unsigned PRI
common_remote idtype NO char 15 45 utf8 utf8_general_ci char(15) PRI
common_remote useip NO char 15 45 utf8 utf8_general_ci char(15)
common_remote port 0 NO smallint smallint(6) unsigned
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
common_report id NO mediumint mediumint(8) unsigned PRI auto_increment
common_report urlkey NO char 32 96 utf8 utf8_general_ci char(32) MUL
common_report url NO varchar 255 765 utf8 utf8_general_ci varchar(255)
common_report message NO text 65535 65535 utf8 utf8_general_ci text
common_report uid 0 NO mediumint mediumint(8) unsigned
common_report username NO varchar 15 45 utf8 utf8_general_ci varchar(15)
common_report dateline 0 NO int int(10) unsigned
common_report num 1 NO smallint smallint(6) unsigned
common_report opuid 0 NO mediumint mediumint(8) unsigned
common_report opname NO varchar 15 45 utf8 utf8_general_ci varchar(15)
common_report optime 0 NO int int(10) unsigned
common_report opresult NO varchar 255 765 utf8 utf8_general_ci varchar(255)
common_report fid 0 NO mediumint mediumint(8) unsigned MUL
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
common_searchindex searchid NO int int(10) unsigned PRI auto_increment
common_searchindex srchmod NO tinyint tinyint(3) unsigned MUL
common_searchindex keywords NO varchar 255 765 utf8 utf8_general_ci varchar(255)
common_searchindex searchstring NO text 65535 65535 utf8 utf8_general_ci text
common_searchindex useip NO varchar 15 45 utf8 utf8_general_ci varchar(15)
common_searchindex uid 0 NO mediumint mediumint(10) unsigned
common_searchindex dateline 0 NO int int(10) unsigned
common_searchindex expiration 0 NO int int(10) unsigned
common_searchindex threadsortid 0 NO smallint smallint(6) unsigned
common_searchindex num 0 NO smallint smallint(6) unsigned
common_searchindex ids NO text 65535 65535 utf8 utf8_general_ci text
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
common_seccheck ssid NO int int(10) PRI auto_increment
common_seccheck dateline NO int int(10) MUL
common_seccheck code NO char 6 18 utf8 utf8_general_ci char(6)
common_seccheck succeed NO tinyint tinyint(1) MUL
common_seccheck verified NO tinyint tinyint(1) MUL
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
common_secquestion id NO smallint smallint(6) unsigned PRI auto_increment
common_secquestion type NO tinyint tinyint(1) unsigned
common_secquestion question NO text 65535 65535 utf8 utf8_general_ci text
common_secquestion answer NO varchar 255 765 utf8 utf8_general_ci varchar(255)
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
common_session sid NO char 6 18 utf8 utf8_general_ci char(6) PRI
common_session ip1 0 NO tinyint tinyint(3) unsigned
common_session ip2 0 NO tinyint tinyint(3) unsigned
common_session ip3 0 NO tinyint tinyint(3) unsigned
common_session ip4 0 NO tinyint tinyint(3) unsigned
common_session uid 0 NO mediumint mediumint(8) unsigned MUL
common_session username NO char 15 45 utf8 utf8_general_ci char(15)
common_session groupid 0 NO smallint smallint(6) unsigned
common_session invisible 0 NO tinyint tinyint(1)
common_session action 0 NO tinyint tinyint(1) unsigned
common_session lastactivity 0 NO int int(10) unsigned
common_session lastolupdate 0 NO int int(10) unsigned
common_session fid 0 NO mediumint mediumint(8) unsigned
common_session tid 0 NO mediumint mediumint(8) unsigned
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
common_setting skey NO varchar 255 765 utf8 utf8_general_ci varchar(255) PRI
common_setting svalue NO text 65535 65535 utf8 utf8_general_ci text
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
common_smiley id NO smallint smallint(6) unsigned PRI auto_increment
common_smiley typeid NO smallint smallint(6) unsigned
common_smiley displayorder 0 NO tinyint tinyint(1)
common_smiley type smiley NO enum 9 27 utf8 utf8_general_ci enum('smiley','stamp','stamplist') MUL
common_smiley code NO varchar 30 90 utf8 utf8_general_ci varchar(30)
common_smiley url NO varchar 30 90 utf8 utf8_general_ci varchar(30)
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
common_sphinxcounter indexid NO tinyint tinyint(1) PRI
common_sphinxcounter maxid NO int int(10)
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
common_stat daytime 0 NO int int(10) unsigned PRI
common_stat login 0 NO int int(10) unsigned
common_stat mobilelogin 0 NO int int(10) unsigned
common_stat connectlogin 0 NO int int(10) unsigned
common_stat register 0 NO int int(10) unsigned
common_stat invite 0 NO int int(10) unsigned
common_stat appinvite 0 NO int int(10) unsigned
common_stat doing 0 NO int int(10) unsigned
common_stat blog 0 NO int int(10) unsigned
common_stat pic 0 NO int int(10) unsigned
common_stat poll 0 NO int int(10) unsigned
common_stat activity 0 NO int int(10) unsigned
common_stat share 0 NO int int(10) unsigned
common_stat thread 0 NO int int(10) unsigned
common_stat docomment 0 NO int int(10) unsigned
common_stat blogcomment 0 NO int int(10) unsigned
common_stat piccomment 0 NO int int(10) unsigned
common_stat sharecomment 0 NO int int(10) unsigned
common_stat reward 0 NO int int(10) unsigned
common_stat debate 0 NO int int(10) unsigned
common_stat trade 0 NO int int(10) unsigned
common_stat group 0 NO int int(10) unsigned
common_stat groupjoin 0 NO int int(10) unsigned
common_stat groupthread 0 NO int int(10) unsigned
common_stat grouppost 0 NO int int(10) unsigned
common_stat post 0 NO int int(10) unsigned
common_stat wall 0 NO int int(10) unsigned
common_stat poke 0 NO int int(10) unsigned
common_stat click 0 NO int int(10) unsigned
common_stat sendpm 0 NO int int(10) unsigned
common_stat friend 0 NO int int(10) unsigned
common_stat addfriend 0 NO int int(10) unsigned
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
common_statuser uid 0 NO mediumint mediumint(8) unsigned MUL
common_statuser daytime 0 NO int int(10) unsigned
common_statuser type NO char 20 60 utf8 utf8_general_ci char(20)
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
common_style styleid NO smallint smallint(6) unsigned PRI auto_increment
common_style name NO varchar 20 60 utf8 utf8_general_ci varchar(20)
common_style available 1 NO tinyint tinyint(1)
common_style templateid 0 NO smallint smallint(6) unsigned
common_style extstyle NO varchar 255 765 utf8 utf8_general_ci varchar(255)
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
common_stylevar stylevarid NO smallint smallint(6) unsigned PRI auto_increment
common_stylevar styleid 0 NO smallint smallint(6) unsigned MUL
common_stylevar variable NO text 65535 65535 utf8 utf8_general_ci text
common_stylevar substitute NO text 65535 65535 utf8 utf8_general_ci text
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
common_syscache cname NO varchar 32 96 utf8 utf8_general_ci varchar(32) PRI
common_syscache ctype NO tinyint tinyint(3) unsigned
common_syscache dateline NO int int(10) unsigned
common_syscache data NO mediumblob 16777215 16777215 mediumblob
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
common_tag tagid NO mediumint mediumint(8) unsigned PRI auto_increment
common_tag tagname NO char 20 60 utf8 utf8_general_ci char(20) MUL
common_tag status 0 NO tinyint tinyint(1) MUL
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
common_tagitem tagid 0 NO mediumint mediumint(8) unsigned PRI
common_tagitem itemid 0 NO mediumint mediumint(8) unsigned PRI
common_tagitem idtype NO char 10 30 utf8 utf8_general_ci char(10) PRI
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
common_task taskid NO smallint smallint(6) unsigned PRI auto_increment
common_task relatedtaskid 0 NO smallint smallint(6) unsigned
common_task available 0 NO tinyint tinyint(1)
common_task name NO varchar 50 150 utf8 utf8_general_ci varchar(50)
common_task description NO text 65535 65535 utf8 utf8_general_ci text
common_task icon NO varchar 150 450 utf8 utf8_general_ci varchar(150)
common_task applicants 0 NO mediumint mediumint(8) unsigned
common_task achievers 0 NO mediumint mediumint(8) unsigned
common_task tasklimits 0 NO mediumint mediumint(8) unsigned
common_task applyperm NO text 65535 65535 utf8 utf8_general_ci text
common_task scriptname NO varchar 50 150 utf8 utf8_general_ci varchar(50)
common_task starttime 0 NO int int(10) unsigned
common_task endtime 0 NO int int(10) unsigned
common_task period 0 NO int int(10) unsigned
common_task periodtype 0 NO tinyint tinyint(1)
common_task reward credit NO enum 6 18 utf8 utf8_general_ci enum('credit','magic','medal','invite','group')
common_task prize NO varchar 15 45 utf8 utf8_general_ci varchar(15)
common_task bonus 0 NO int int(10)
common_task displayorder 0 NO smallint smallint(6) unsigned
common_task version NO varchar 15 45 utf8 utf8_general_ci varchar(15)
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
common_taskvar taskvarid NO mediumint mediumint(8) unsigned PRI auto_increment
common_taskvar taskid 0 NO smallint smallint(6) unsigned MUL
common_taskvar sort complete NO enum 8 24 utf8 utf8_general_ci enum('apply','complete')
common_taskvar name NO varchar 100 300 utf8 utf8_general_ci varchar(100)
common_taskvar description NO varchar 255 765 utf8 utf8_general_ci varchar(255)
common_taskvar variable NO varchar 40 120 utf8 utf8_general_ci varchar(40)
common_taskvar type text NO varchar 20 60 utf8 utf8_general_ci varchar(20)
common_taskvar value NO text 65535 65535 utf8 utf8_general_ci text
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
common_template templateid NO smallint smallint(6) unsigned PRI auto_increment
common_template name NO varchar 30 90 utf8 utf8_general_ci varchar(30)
common_template directory NO varchar 100 300 utf8 utf8_general_ci varchar(100)
common_template copyright NO varchar 100 300 utf8 utf8_general_ci varchar(100)
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
common_template targettplname NO varchar 100 300 utf8 utf8_general_ci varchar(100) PRI
common_template tpldirectory NO varchar 80 240 utf8 utf8_general_ci varchar(80) PRI
common_template bid 0 NO mediumint mediumint(8) unsigned PRI
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
common_template targettplname NO varchar 100 300 utf8 utf8_general_ci varchar(100) PRI
common_template uid 0 NO mediumint mediumint(8) unsigned PRI
common_template allowmanage 0 NO tinyint tinyint(1)
common_template allowrecommend 0 NO tinyint tinyint(1)
common_template needverify 0 NO tinyint tinyint(1)
common_template inheritedtplname NO varchar 255 765 utf8 utf8_general_ci varchar(255)
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
common_uin uin NO char 40 120 utf8 utf8_general_ci char(40) PRI
common_uin uid 0 NO mediumint mediumint(8) unsigned UNI
common_uin dateline 0 NO int int(10) unsigned
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
common_usergroup groupid NO smallint smallint(6) unsigned PRI auto_increment
common_usergroup radminid 0 NO tinyint tinyint(3)
common_usergroup type member NO enum 7 21 utf8 utf8_general_ci enum('system','special','member')
common_usergroup system private NO varchar 255 765 utf8 utf8_general_ci varchar(255)
common_usergroup grouptitle NO varchar 255 765 utf8 utf8_general_ci varchar(255)
common_usergroup creditshigher 0 NO int int(10) MUL
common_usergroup creditslower 0 NO int int(10)
common_usergroup stars 0 NO tinyint tinyint(3)
common_usergroup color NO varchar 255 765 utf8 utf8_general_ci varchar(255)
common_usergroup icon NO varchar 255 765 utf8 utf8_general_ci varchar(255)
common_usergroup allowvisit 0 NO tinyint tinyint(1)
common_usergroup allowsendpm 1 NO tinyint tinyint(1)
common_usergroup allowinvite 0 NO tinyint tinyint(1)
common_usergroup allowmailinvite 0 NO tinyint tinyint(1)
common_usergroup maxinvitenum 0 NO tinyint tinyint(3) unsigned
common_usergroup inviteprice 0 NO smallint smallint(6) unsigned
common_usergroup maxinviteday 0 NO smallint smallint(6) unsigned
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
common_usergroup groupid NO smallint smallint(6) unsigned PRI
common_usergroup readaccess 0 NO tinyint tinyint(3) unsigned
common_usergroup allowpost 0 NO tinyint tinyint(1)
common_usergroup allowreply 0 NO tinyint tinyint(1)
common_usergroup allowpostpoll 0 NO tinyint tinyint(1)
common_usergroup allowpostreward 0 NO tinyint tinyint(1)
common_usergroup allowposttrade 0 NO tinyint tinyint(1)
common_usergroup allowpostactivity 0 NO tinyint tinyint(1)
common_usergroup allowdirectpost 0 NO tinyint tinyint(1)
common_usergroup allowgetattach 0 NO tinyint tinyint(1)
common_usergroup allowgetimage 0 NO tinyint tinyint(1)
common_usergroup allowpostattach 0 NO tinyint tinyint(1)
common_usergroup allowpostimage 0 NO tinyint tinyint(1)
common_usergroup allowvote 0 NO tinyint tinyint(1)
common_usergroup allowsearch 0 NO tinyint tinyint(1)
common_usergroup allowcstatus 0 NO tinyint tinyint(1)
common_usergroup allowinvisible 0 NO tinyint tinyint(1)
common_usergroup allowtransfer 0 NO tinyint tinyint(1)
common_usergroup allowsetreadperm 0 NO tinyint tinyint(1)
common_usergroup allowsetattachperm 0 NO tinyint tinyint(1)
common_usergroup allowposttag 0 NO tinyint tinyint(1)
common_usergroup allowhidecode 0 NO tinyint tinyint(1)
common_usergroup allowhtml 0 NO tinyint tinyint(1)
common_usergroup allowanonymous 0 NO tinyint tinyint(1)
common_usergroup allowsigbbcode 0 NO tinyint tinyint(1)
common_usergroup allowsigimgcode 0 NO tinyint tinyint(1)
common_usergroup allowmagics NO tinyint tinyint(1) unsigned
common_usergroup disableperiodctrl 0 NO tinyint tinyint(1)
common_usergroup reasonpm 0 NO tinyint tinyint(1)
common_usergroup maxprice 0 NO smallint smallint(6) unsigned
common_usergroup maxsigsize 0 NO smallint smallint(6) unsigned
common_usergroup maxattachsize 0 NO int int(10) unsigned
common_usergroup maxsizeperday 0 NO int int(10) unsigned
common_usergroup maxthreadsperhour 0 NO tinyint tinyint(3) unsigned
common_usergroup maxpostsperhour 0 NO tinyint tinyint(3) unsigned
common_usergroup attachextensions NO char 100 300 utf8 utf8_general_ci char(100)
common_usergroup raterange NO char 150 450 utf8 utf8_general_ci char(150)
common_usergroup loginreward NO char 150 450 utf8 utf8_general_ci char(150)
common_usergroup mintradeprice 1 NO smallint smallint(6) unsigned
common_usergroup maxtradeprice 0 NO smallint smallint(6) unsigned
common_usergroup minrewardprice 1 NO smallint smallint(6) unsigned
common_usergroup maxrewardprice 0 NO smallint smallint(6) unsigned
common_usergroup magicsdiscount NO tinyint tinyint(1)
common_usergroup maxmagicsweight NO smallint smallint(6) unsigned
common_usergroup allowpostdebate 0 NO tinyint tinyint(1)
common_usergroup tradestick NO tinyint tinyint(1) unsigned
common_usergroup exempt NO tinyint tinyint(1) unsigned
common_usergroup maxattachnum 0 NO smallint smallint(6)
common_usergroup allowposturl 3 NO tinyint tinyint(1)
common_usergroup allowrecommend 1 NO tinyint tinyint(1) unsigned
common_usergroup allowpostrushreply 0 NO tinyint tinyint(1)
common_usergroup maxfriendnum 0 NO smallint smallint(6) unsigned
common_usergroup maxspacesize 0 NO int int(10) unsigned
common_usergroup allowcomment 0 NO tinyint tinyint(1)
common_usergroup allowcommentarticle 0 NO smallint smallint(6)
common_usergroup searchinterval 0 NO smallint smallint(6) unsigned
common_usergroup searchignore 0 NO tinyint tinyint(1)
common_usergroup allowblog 0 NO tinyint tinyint(1)
common_usergroup allowdoing 0 NO tinyint tinyint(1)
common_usergroup allowupload 0 NO tinyint tinyint(1)
common_usergroup allowshare 0 NO tinyint tinyint(1)
common_usergroup allowblogmod 0 NO tinyint tinyint(1) unsigned
common_usergroup allowdoingmod 0 NO tinyint tinyint(1) unsigned
common_usergroup allowuploadmod 0 NO tinyint tinyint(1) unsigned
common_usergroup allowsharemod 0 NO tinyint tinyint(1) unsigned
common_usergroup allowcss 0 NO tinyint tinyint(1)
common_usergroup allowpoke 0 NO tinyint tinyint(1)
common_usergroup allowfriend 0 NO tinyint tinyint(1)
common_usergroup allowclick 0 NO tinyint tinyint(1)
common_usergroup allowmagic 0 NO tinyint tinyint(1)
common_usergroup allowstat 0 NO tinyint tinyint(1)
common_usergroup allowstatdata 0 NO tinyint tinyint(1)
common_usergroup videophotoignore 0 NO tinyint tinyint(1)
common_usergroup allowviewvideophoto 0 NO tinyint tinyint(1)
common_usergroup allowmyop 0 NO tinyint tinyint(1)
common_usergroup magicdiscount 0 NO tinyint tinyint(1)
common_usergroup domainlength 0 NO smallint smallint(6) unsigned
common_usergroup seccode 1 NO tinyint tinyint(1)
common_usergroup disablepostctrl 0 NO tinyint tinyint(1)
common_usergroup allowbuildgroup 0 NO tinyint tinyint(1) unsigned
common_usergroup allowgroupdirectpost 0 NO tinyint tinyint(1) unsigned
common_usergroup allowgroupposturl 0 NO tinyint tinyint(1) unsigned
common_usergroup edittimelimit 0 NO smallint smallint(6) unsigned
common_usergroup allowpostarticle 0 NO tinyint tinyint(1)
common_usergroup allowdownlocalimg 0 NO tinyint tinyint(1)
common_usergroup allowdownremoteimg 0 NO tinyint tinyint(1)
common_usergroup allowpostarticlemod 0 NO tinyint tinyint(1) unsigned
common_usergroup allowspacediyhtml 0 NO tinyint tinyint(1)
common_usergroup allowspacediybbcode 0 NO tinyint tinyint(1)
common_usergroup allowspacediyimgcode 0 NO tinyint tinyint(1)
common_usergroup allowcommentpost 2 NO tinyint tinyint(1)
common_usergroup allowcommentitem 0 NO tinyint tinyint(1)
common_usergroup allowcommentreply 0 NO tinyint tinyint(1)
common_usergroup allowreplycredit 0 NO tinyint tinyint(1)
common_usergroup ignorecensor 0 NO tinyint tinyint(1) unsigned
common_usergroup allowsendallpm 0 NO tinyint tinyint(1) unsigned
common_usergroup allowsendpmmaxnum 0 NO smallint smallint(6) unsigned
common_usergroup maximagesize 0 NO mediumint mediumint(8) unsigned
common_usergroup allowmediacode 0 NO tinyint tinyint(1)
common_usergroup allowbegincode 0 NO tinyint tinyint(1) unsigned
common_usergroup allowat 0 NO smallint smallint(6) unsigned
common_usergroup allowsetpublishdate 0 NO tinyint tinyint(1) unsigned
common_usergroup allowfollowcollection 0 NO tinyint tinyint(1) unsigned
common_usergroup allowcommentcollection 0 NO tinyint tinyint(1) unsigned
common_usergroup allowcreatecollection 0 NO smallint smallint(6) unsigned
common_usergroup forcesecques 0 NO tinyint tinyint(1) unsigned
common_usergroup forcelogin 0 NO tinyint tinyint(1) unsigned
common_usergroup closead 0 NO tinyint tinyint(1) unsigned
common_usergroup buildgroupcredits 0 NO smallint smallint(6) unsigned
common_usergroup allowimgcontent 0 NO tinyint tinyint(1) unsigned
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
common_visit ip 0 NO int int(10) unsigned PRI
common_visit view 0 NO int int(10) unsigned
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
common_word id NO smallint smallint(6) unsigned PRI auto_increment
common_word admin NO varchar 15 45 utf8 utf8_general_ci varchar(15)
common_word type 1 NO smallint smallint(6)
common_word find NO varchar 255 765 utf8 utf8_general_ci varchar(255)
common_word replacement NO varchar 255 765 utf8 utf8_general_ci varchar(255)
common_word extra NO varchar 255 765 utf8 utf8_general_ci varchar(255)
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
common_word id NO smallint smallint(6) unsigned PRI auto_increment
common_word typename NO varchar 15 45 utf8 utf8_general_ci varchar(15)
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
connect_disktask taskid NO int int(10) unsigned PRI auto_increment
connect_disktask aid 0 NO int int(10) unsigned
connect_disktask uid 0 NO int int(10) unsigned
connect_disktask openid NO char 32 96 utf8 utf8_general_ci char(32) MUL
connect_disktask filename NO varchar 255 765 utf8 utf8_general_ci varchar(255)
connect_disktask verifycode NO char 32 96 utf8 utf8_general_ci char(32)
connect_disktask status 0 NO smallint smallint(6) unsigned MUL
connect_disktask dateline 0 NO int int(10) unsigned
connect_disktask downloadtime 0 NO int int(10) unsigned
connect_disktask extra YES text 65535 65535 utf8 utf8_general_ci text
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
connect_feedlog flid NO mediumint mediumint(8) unsigned PRI auto_increment
connect_feedlog tid 0 NO mediumint mediumint(8) unsigned UNI
connect_feedlog uid 0 NO mediumint mediumint(8) unsigned
connect_feedlog publishtimes 0 NO mediumint mediumint(8) unsigned
connect_feedlog lastpublished 0 NO int int(10) unsigned
connect_feedlog dateline 0 NO int int(10) unsigned
connect_feedlog status 1 NO tinyint tinyint(1)
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
connect_memberbindlog mblid NO mediumint mediumint(8) unsigned PRI auto_increment
connect_memberbindlog uid 0 NO mediumint mediumint(8) unsigned MUL
connect_memberbindlog uin NO char 40 120 utf8 utf8_general_ci char(40) MUL
connect_memberbindlog type 0 NO tinyint tinyint(1)
connect_memberbindlog dateline 0 NO int int(10) unsigned MUL
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
connect_postfeedlog flid NO mediumint mediumint(8) unsigned PRI auto_increment
connect_postfeedlog pid 0 NO int int(10) unsigned UNI
connect_postfeedlog uid 0 NO mediumint mediumint(8) unsigned
connect_postfeedlog publishtimes 0 NO mediumint mediumint(8) unsigned
connect_postfeedlog lastpublished 0 NO int int(10) unsigned
connect_postfeedlog dateline 0 NO int int(10) unsigned
connect_postfeedlog status 1 NO tinyint tinyint(1)
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
connect_tthreadlog twid NO char 16 48 utf8 utf8_general_ci char(16) PRI
connect_tthreadlog tid 0 NO mediumint mediumint(8) unsigned MUL
connect_tthreadlog conopenid NO char 32 96 utf8 utf8_general_ci char(32)
connect_tthreadlog pagetime 0 YES int int(10) unsigned
connect_tthreadlog lasttwid YES char 16 48 utf8 utf8_general_ci char(16)
connect_tthreadlog nexttime 0 YES int int(10) unsigned
connect_tthreadlog updatetime 0 YES int int(10) unsigned
connect_tthreadlog dateline 0 YES int int(10) unsigned
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
forum_access uid 0 NO mediumint mediumint(8) unsigned PRI
forum_access fid 0 NO mediumint mediumint(8) unsigned PRI
forum_access allowview 0 NO tinyint tinyint(1)
forum_access allowpost 0 NO tinyint tinyint(1)
forum_access allowreply 0 NO tinyint tinyint(1)
forum_access allowgetattach 0 NO tinyint tinyint(1)
forum_access allowgetimage 0 NO tinyint tinyint(1)
forum_access allowpostattach 0 NO tinyint tinyint(1)
forum_access allowpostimage 0 NO tinyint tinyint(1)
forum_access adminuser 0 NO mediumint mediumint(8) unsigned
forum_access dateline 0 NO int int(10) unsigned
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
forum_activity tid 0 NO mediumint mediumint(8) unsigned PRI
forum_activity uid 0 NO mediumint mediumint(8) unsigned MUL
forum_activity aid 0 NO mediumint mediumint(8) unsigned
forum_activity cost 0 NO mediumint mediumint(8) unsigned
forum_activity starttimefrom 0 NO int int(10) unsigned MUL
forum_activity starttimeto 0 NO int int(10) unsigned
forum_activity place NO varchar 255 765 utf8 utf8_general_ci varchar(255)
forum_activity class NO varchar 255 765 utf8 utf8_general_ci varchar(255)
forum_activity gender 0 NO tinyint tinyint(1)
forum_activity number 0 NO smallint smallint(5) unsigned
forum_activity applynumber 0 NO smallint smallint(5) unsigned MUL
forum_activity expiration 0 NO int int(10) unsigned MUL
forum_activity ufield NO text 65535 65535 utf8 utf8_general_ci text
forum_activity credit 0 NO smallint smallint(6) unsigned
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
forum_activityapply applyid NO int int(10) unsigned PRI auto_increment
forum_activityapply tid 0 NO mediumint mediumint(8) unsigned MUL
forum_activityapply username NO varchar 255 765 utf8 utf8_general_ci varchar(255)
forum_activityapply uid 0 NO mediumint mediumint(8) unsigned MUL
forum_activityapply message NO varchar 255 765 utf8 utf8_general_ci varchar(255)
forum_activityapply verified 0 NO tinyint tinyint(1)
forum_activityapply dateline 0 NO int int(10) unsigned
forum_activityapply payment 0 NO mediumint mediumint(8)
forum_activityapply ufielddata NO text 65535 65535 utf8 utf8_general_ci text
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
forum_announcement id NO smallint smallint(6) unsigned PRI auto_increment
forum_announcement author NO varchar 15 45 utf8 utf8_general_ci varchar(15)
forum_announcement subject NO varchar 255 765 utf8 utf8_general_ci varchar(255)
forum_announcement type 0 NO tinyint tinyint(1)
forum_announcement displayorder 0 NO tinyint tinyint(3)
forum_announcement starttime 0 NO int int(10) unsigned MUL
forum_announcement endtime 0 NO int int(10) unsigned
forum_announcement message NO text 65535 65535 utf8 utf8_general_ci text
forum_announcement groups NO text 65535 65535 utf8 utf8_general_ci text
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
forum_attachment aid NO mediumint mediumint(8) unsigned PRI auto_increment
forum_attachment tid 0 NO mediumint mediumint(8) unsigned MUL
forum_attachment pid 0 NO int int(10) unsigned MUL
forum_attachment uid 0 NO mediumint mediumint(8) unsigned MUL
forum_attachment tableid 0 NO tinyint tinyint(1) unsigned
forum_attachment downloads 0 NO mediumint mediumint(8)
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
forum_attachment aid NO mediumint mediumint(8) unsigned PRI
forum_attachment tid 0 NO mediumint mediumint(8) unsigned MUL
forum_attachment pid 0 NO int int(10) unsigned MUL
forum_attachment uid 0 NO mediumint mediumint(8) unsigned MUL
forum_attachment dateline 0 NO int int(10) unsigned
forum_attachment filename NO varchar 255 765 utf8 utf8_general_ci varchar(255)
forum_attachment filesize 0 NO int int(10) unsigned
forum_attachment attachment NO varchar 255 765 utf8 utf8_general_ci varchar(255)
forum_attachment remote 0 NO tinyint tinyint(1) unsigned
forum_attachment description NO varchar 255 765 utf8 utf8_general_ci varchar(255)
forum_attachment readperm 0 NO tinyint tinyint(3) unsigned
forum_attachment price 0 NO smallint smallint(6) unsigned
forum_attachment isimage 0 NO tinyint tinyint(1)
forum_attachment width 0 NO smallint smallint(6) unsigned
forum_attachment thumb 0 NO tinyint tinyint(1) unsigned
forum_attachment picid 0 NO mediumint mediumint(8)
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
forum_attachment aid NO mediumint mediumint(8) unsigned PRI
forum_attachment tid 0 NO mediumint mediumint(8) unsigned MUL
forum_attachment pid 0 NO int int(10) unsigned MUL
forum_attachment uid 0 NO mediumint mediumint(8) unsigned MUL
forum_attachment dateline 0 NO int int(10) unsigned
forum_attachment filename NO varchar 255 765 utf8 utf8_general_ci varchar(255)
forum_attachment filesize 0 NO int int(10) unsigned
forum_attachment attachment NO varchar 255 765 utf8 utf8_general_ci varchar(255)
forum_attachment remote 0 NO tinyint tinyint(1) unsigned
forum_attachment description NO varchar 255 765 utf8 utf8_general_ci varchar(255)
forum_attachment readperm 0 NO tinyint tinyint(3) unsigned
forum_attachment price 0 NO smallint smallint(6) unsigned
forum_attachment isimage 0 NO tinyint tinyint(1)
forum_attachment width 0 NO smallint smallint(6) unsigned
forum_attachment thumb 0 NO tinyint tinyint(1) unsigned
forum_attachment picid 0 NO mediumint mediumint(8)
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
forum_attachment aid NO mediumint mediumint(8) unsigned PRI
forum_attachment tid 0 NO mediumint mediumint(8) unsigned MUL
forum_attachment pid 0 NO int int(10) unsigned MUL
forum_attachment uid 0 NO mediumint mediumint(8) unsigned MUL
forum_attachment dateline 0 NO int int(10) unsigned
forum_attachment filename NO varchar 255 765 utf8 utf8_general_ci varchar(255)
forum_attachment filesize 0 NO int int(10) unsigned
forum_attachment attachment NO varchar 255 765 utf8 utf8_general_ci varchar(255)
forum_attachment remote 0 NO tinyint tinyint(1) unsigned
forum_attachment description NO varchar 255 765 utf8 utf8_general_ci varchar(255)
forum_attachment readperm 0 NO tinyint tinyint(3) unsigned
forum_attachment price 0 NO smallint smallint(6) unsigned
forum_attachment isimage 0 NO tinyint tinyint(1)
forum_attachment width 0 NO smallint smallint(6) unsigned
forum_attachment thumb 0 NO tinyint tinyint(1) unsigned
forum_attachment picid 0 NO mediumint mediumint(8)
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
forum_attachment aid NO mediumint mediumint(8) unsigned PRI
forum_attachment tid 0 NO mediumint mediumint(8) unsigned MUL
forum_attachment pid 0 NO int int(10) unsigned MUL
forum_attachment uid 0 NO mediumint mediumint(8) unsigned MUL
forum_attachment dateline 0 NO int int(10) unsigned
forum_attachment filename NO varchar 255 765 utf8 utf8_general_ci varchar(255)
forum_attachment filesize 0 NO int int(10) unsigned
forum_attachment attachment NO varchar 255 765 utf8 utf8_general_ci varchar(255)
forum_attachment remote 0 NO tinyint tinyint(1) unsigned
forum_attachment description NO varchar 255 765 utf8 utf8_general_ci varchar(255)
forum_attachment readperm 0 NO tinyint tinyint(3) unsigned
forum_attachment price 0 NO smallint smallint(6) unsigned
forum_attachment isimage 0 NO tinyint tinyint(1)
forum_attachment width 0 NO smallint smallint(6) unsigned
forum_attachment thumb 0 NO tinyint tinyint(1) unsigned
forum_attachment picid 0 NO mediumint mediumint(8)
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
forum_attachment aid NO mediumint mediumint(8) unsigned PRI
forum_attachment tid 0 NO mediumint mediumint(8) unsigned MUL
forum_attachment pid 0 NO int int(10) unsigned MUL
forum_attachment uid 0 NO mediumint mediumint(8) unsigned MUL
forum_attachment dateline 0 NO int int(10) unsigned
forum_attachment filename NO varchar 255 765 utf8 utf8_general_ci varchar(255)
forum_attachment filesize 0 NO int int(10) unsigned
forum_attachment attachment NO varchar 255 765 utf8 utf8_general_ci varchar(255)
forum_attachment remote 0 NO tinyint tinyint(1) unsigned
forum_attachment description NO varchar 255 765 utf8 utf8_general_ci varchar(255)
forum_attachment readperm 0 NO tinyint tinyint(3) unsigned
forum_attachment price 0 NO smallint smallint(6) unsigned
forum_attachment isimage 0 NO tinyint tinyint(1)
forum_attachment width 0 NO smallint smallint(6) unsigned
forum_attachment thumb 0 NO tinyint tinyint(1) unsigned
forum_attachment picid 0 NO mediumint mediumint(8)
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
forum_attachment aid NO mediumint mediumint(8) unsigned PRI
forum_attachment tid 0 NO mediumint mediumint(8) unsigned MUL
forum_attachment pid 0 NO int int(10) unsigned MUL
forum_attachment uid 0 NO mediumint mediumint(8) unsigned MUL
forum_attachment dateline 0 NO int int(10) unsigned
forum_attachment filename NO varchar 255 765 utf8 utf8_general_ci varchar(255)
forum_attachment filesize 0 NO int int(10) unsigned
forum_attachment attachment NO varchar 255 765 utf8 utf8_general_ci varchar(255)
forum_attachment remote 0 NO tinyint tinyint(1) unsigned
forum_attachment description NO varchar 255 765 utf8 utf8_general_ci varchar(255)
forum_attachment readperm 0 NO tinyint tinyint(3) unsigned
forum_attachment price 0 NO smallint smallint(6) unsigned
forum_attachment isimage 0 NO tinyint tinyint(1)
forum_attachment width 0 NO smallint smallint(6) unsigned
forum_attachment thumb 0 NO tinyint tinyint(1) unsigned
forum_attachment picid 0 NO mediumint mediumint(8)
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
forum_attachment aid NO mediumint mediumint(8) unsigned PRI
forum_attachment tid 0 NO mediumint mediumint(8) unsigned MUL
forum_attachment pid 0 NO int int(10) unsigned MUL
forum_attachment uid 0 NO mediumint mediumint(8) unsigned MUL
forum_attachment dateline 0 NO int int(10) unsigned
forum_attachment filename NO varchar 255 765 utf8 utf8_general_ci varchar(255)
forum_attachment filesize 0 NO int int(10) unsigned
forum_attachment attachment NO varchar 255 765 utf8 utf8_general_ci varchar(255)
forum_attachment remote 0 NO tinyint tinyint(1) unsigned
forum_attachment description NO varchar 255 765 utf8 utf8_general_ci varchar(255)
forum_attachment readperm 0 NO tinyint tinyint(3) unsigned
forum_attachment price 0 NO smallint smallint(6) unsigned
forum_attachment isimage 0 NO tinyint tinyint(1)
forum_attachment width 0 NO smallint smallint(6) unsigned
forum_attachment thumb 0 NO tinyint tinyint(1) unsigned
forum_attachment picid 0 NO mediumint mediumint(8)
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
forum_attachment aid NO mediumint mediumint(8) unsigned PRI
forum_attachment tid 0 NO mediumint mediumint(8) unsigned MUL
forum_attachment pid 0 NO int int(10) unsigned MUL
forum_attachment uid 0 NO mediumint mediumint(8) unsigned MUL
forum_attachment dateline 0 NO int int(10) unsigned
forum_attachment filename NO varchar 255 765 utf8 utf8_general_ci varchar(255)
forum_attachment filesize 0 NO int int(10) unsigned
forum_attachment attachment NO varchar 255 765 utf8 utf8_general_ci varchar(255)
forum_attachment remote 0 NO tinyint tinyint(1) unsigned
forum_attachment description NO varchar 255 765 utf8 utf8_general_ci varchar(255)
forum_attachment readperm 0 NO tinyint tinyint(3) unsigned
forum_attachment price 0 NO smallint smallint(6) unsigned
forum_attachment isimage 0 NO tinyint tinyint(1)
forum_attachment width 0 NO smallint smallint(6) unsigned
forum_attachment thumb 0 NO tinyint tinyint(1) unsigned
forum_attachment picid 0 NO mediumint mediumint(8)
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
forum_attachment aid NO mediumint mediumint(8) unsigned PRI
forum_attachment tid 0 NO mediumint mediumint(8) unsigned MUL
forum_attachment pid 0 NO int int(10) unsigned MUL
forum_attachment uid 0 NO mediumint mediumint(8) unsigned MUL
forum_attachment dateline 0 NO int int(10) unsigned
forum_attachment filename NO varchar 255 765 utf8 utf8_general_ci varchar(255)
forum_attachment filesize 0 NO int int(10) unsigned
forum_attachment attachment NO varchar 255 765 utf8 utf8_general_ci varchar(255)
forum_attachment remote 0 NO tinyint tinyint(1) unsigned
forum_attachment description NO varchar 255 765 utf8 utf8_general_ci varchar(255)
forum_attachment readperm 0 NO tinyint tinyint(3) unsigned
forum_attachment price 0 NO smallint smallint(6) unsigned
forum_attachment isimage 0 NO tinyint tinyint(1)
forum_attachment width 0 NO smallint smallint(6) unsigned
forum_attachment thumb 0 NO tinyint tinyint(1) unsigned
forum_attachment picid 0 NO mediumint mediumint(8)
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
forum_attachment aid NO mediumint mediumint(8) unsigned PRI
forum_attachment tid 0 NO mediumint mediumint(8) unsigned MUL
forum_attachment pid 0 NO int int(10) unsigned MUL
forum_attachment uid 0 NO mediumint mediumint(8) unsigned MUL
forum_attachment dateline 0 NO int int(10) unsigned
forum_attachment filename NO varchar 255 765 utf8 utf8_general_ci varchar(255)
forum_attachment filesize 0 NO int int(10) unsigned
forum_attachment attachment NO varchar 255 765 utf8 utf8_general_ci varchar(255)
forum_attachment remote 0 NO tinyint tinyint(1) unsigned
forum_attachment description NO varchar 255 765 utf8 utf8_general_ci varchar(255)
forum_attachment readperm 0 NO tinyint tinyint(3) unsigned
forum_attachment price 0 NO smallint smallint(6) unsigned
forum_attachment isimage 0 NO tinyint tinyint(1)
forum_attachment width 0 NO smallint smallint(6) unsigned
forum_attachment thumb 0 NO tinyint tinyint(1) unsigned
forum_attachment picid 0 NO mediumint mediumint(8)
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
forum_attachment aid NO mediumint mediumint(8) unsigned PRI
forum_attachment exif NO text 65535 65535 utf8 utf8_general_ci text
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
forum_attachment aid NO mediumint mediumint(8) unsigned PRI
forum_attachment uid 0 NO mediumint mediumint(8) unsigned MUL
forum_attachment dateline 0 NO int int(10) unsigned
forum_attachment filename NO varchar 255 765 utf8 utf8_general_ci varchar(255)
forum_attachment filesize 0 NO int int(10) unsigned
forum_attachment attachment NO varchar 255 765 utf8 utf8_general_ci varchar(255)
forum_attachment remote 0 NO tinyint tinyint(1) unsigned
forum_attachment isimage 0 NO tinyint tinyint(1)
forum_attachment width 0 NO smallint smallint(6) unsigned
forum_attachment thumb 0 NO tinyint tinyint(1) unsigned
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
forum_attachtype id NO smallint smallint(6) unsigned PRI auto_increment
forum_attachtype fid 0 NO mediumint mediumint(8) unsigned MUL
forum_attachtype extension NO char 12 36 utf8 utf8_general_ci char(12)
forum_attachtype maxsize 0 NO int int(10) unsigned
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
forum_bbcode id NO mediumint mediumint(8) unsigned PRI auto_increment
forum_bbcode available 0 NO tinyint tinyint(1)
forum_bbcode tag NO varchar 100 300 utf8 utf8_general_ci varchar(100)
forum_bbcode icon NO varchar 255 765 utf8 utf8_general_ci varchar(255)
forum_bbcode replacement NO text 65535 65535 utf8 utf8_general_ci text
forum_bbcode example NO varchar 255 765 utf8 utf8_general_ci varchar(255)
forum_bbcode explanation NO text 65535 65535 utf8 utf8_general_ci text
forum_bbcode params 1 NO tinyint tinyint(1) unsigned
forum_bbcode prompt NO text 65535 65535 utf8 utf8_general_ci text
forum_bbcode nest 1 NO tinyint tinyint(3) unsigned
forum_bbcode displayorder 0 NO tinyint tinyint(3)
forum_bbcode perm NO text 65535 65535 utf8 utf8_general_ci text
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
forum_collection ctid NO mediumint mediumint(8) unsigned PRI auto_increment
forum_collection uid 0 NO mediumint mediumint(8) unsigned MUL
forum_collection username NO varchar 15 45 utf8 utf8_general_ci varchar(15)
forum_collection name NO varchar 50 150 utf8 utf8_general_ci varchar(50)
forum_collection dateline 0 NO int int(10) unsigned MUL
forum_collection follownum 0 NO mediumint mediumint(8) unsigned MUL
forum_collection threadnum 0 NO mediumint mediumint(8) unsigned MUL
forum_collection commentnum 0 NO mediumint mediumint(8) unsigned
forum_collection desc NO varchar 255 765 utf8 utf8_general_ci varchar(255)
forum_collection lastupdate 0 NO int int(10) unsigned
forum_collection rate 0 NO float float
forum_collection ratenum 0 NO mediumint mediumint(8) unsigned
forum_collection lastpost 0 NO mediumint mediumint(8) unsigned
forum_collection lastsubject NO varchar 80 240 utf8 utf8_general_ci varchar(80)
forum_collection lastposttime 0 NO int int(10) unsigned
forum_collection lastposter NO varchar 15 45 utf8 utf8_general_ci varchar(15)
forum_collection lastvisit 0 NO int int(10) unsigned
forum_collection keyword NO varchar 255 765 utf8 utf8_general_ci varchar(255)
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
forum_collectioncomment cid NO mediumint mediumint(8) unsigned PRI auto_increment
forum_collectioncomment ctid 0 NO mediumint mediumint(8) unsigned MUL
forum_collectioncomment uid 0 NO mediumint mediumint(8) unsigned
forum_collectioncomment username NO varchar 15 45 utf8 utf8_general_ci varchar(15)
forum_collectioncomment message NO text 65535 65535 utf8 utf8_general_ci text
forum_collectioncomment dateline 0 NO int int(10) unsigned
forum_collectioncomment useip NO varchar 16 48 utf8 utf8_general_ci varchar(16)
forum_collectioncomment port 0 NO smallint smallint(6) unsigned
forum_collectioncomment rate 0 NO float float
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
forum_collectionfollow uid 0 NO mediumint mediumint(8) unsigned PRI
forum_collectionfollow username NO char 15 45 utf8 utf8_general_ci char(15)
forum_collectionfollow ctid 0 NO mediumint mediumint(8) unsigned PRI
forum_collectionfollow dateline 0 NO int int(10) unsigned
forum_collectionfollow lastvisit 0 NO int int(10) unsigned
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
forum_collectioninvite ctid 0 NO mediumint mediumint(8) unsigned PRI
forum_collectioninvite uid 0 NO mediumint mediumint(8) unsigned PRI
forum_collectioninvite dateline 0 NO int int(10) unsigned MUL
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
forum_collectionrelated tid 0 NO mediumint mediumint(8) unsigned PRI
forum_collectionrelated collection NO text 65535 65535 utf8 utf8_general_ci text
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
forum_collectionteamworker ctid 0 NO mediumint mediumint(8) unsigned PRI
forum_collectionteamworker uid 0 NO mediumint mediumint(8) unsigned PRI
forum_collectionteamworker name NO varchar 50 150 utf8 utf8_general_ci varchar(50)
forum_collectionteamworker username NO varchar 15 45 utf8 utf8_general_ci varchar(15)
forum_collectionteamworker lastvisit 0 NO int int(8) unsigned
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
forum_collectionthread ctid 0 NO mediumint mediumint(8) unsigned PRI
forum_collectionthread tid 0 NO mediumint mediumint(8) unsigned PRI
forum_collectionthread dateline 0 NO int int(10) unsigned
forum_collectionthread reason NO varchar 255 765 utf8 utf8_general_ci varchar(255)
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
forum_creditslog uid 0 NO mediumint mediumint(8) unsigned MUL
forum_creditslog fromto NO char 15 45 utf8 utf8_general_ci char(15)
forum_creditslog sendcredits 0 NO tinyint tinyint(1)
forum_creditslog receivecredits 0 NO tinyint tinyint(1)
forum_creditslog send 0 NO int int(10) unsigned
forum_creditslog receive 0 NO int int(10) unsigned
forum_creditslog dateline 0 NO int int(10) unsigned
forum_creditslog operation NO char 3 9 utf8 utf8_general_ci char(3)
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
forum_debate tid 0 NO mediumint mediumint(8) unsigned PRI
forum_debate uid 0 NO mediumint mediumint(8) unsigned MUL
forum_debate starttime 0 NO int int(10) unsigned
forum_debate endtime 0 NO int int(10) unsigned
forum_debate affirmdebaters 0 NO mediumint mediumint(8) unsigned
forum_debate negadebaters 0 NO mediumint mediumint(8) unsigned
forum_debate affirmvotes 0 NO mediumint mediumint(8) unsigned
forum_debate negavotes 0 NO mediumint mediumint(8) unsigned
forum_debate umpire NO varchar 15 45 utf8 utf8_general_ci varchar(15)
forum_debate winner 0 NO tinyint tinyint(1)
forum_debate bestdebater NO varchar 50 150 utf8 utf8_general_ci varchar(50)
forum_debate affirmpoint NO text 65535 65535 utf8 utf8_general_ci text
forum_debate negapoint NO text 65535 65535 utf8 utf8_general_ci text
forum_debate umpirepoint NO text 65535 65535 utf8 utf8_general_ci text
forum_debate affirmvoterids NO text 65535 65535 utf8 utf8_general_ci text
forum_debate negavoterids NO text 65535 65535 utf8 utf8_general_ci text
forum_debate affirmreplies NO mediumint mediumint(8) unsigned
forum_debate negareplies NO mediumint mediumint(8) unsigned
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
forum_debatepost pid 0 NO int int(10) unsigned PRI
forum_debatepost stand 0 NO tinyint tinyint(1)
forum_debatepost tid 0 NO mediumint mediumint(8) unsigned MUL
forum_debatepost uid 0 NO mediumint mediumint(8) unsigned
forum_debatepost dateline 0 NO int int(10) unsigned
forum_debatepost voters 0 NO mediumint mediumint(10) unsigned
forum_debatepost voterids NO text 65535 65535 utf8 utf8_general_ci text
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
forum_faq id NO smallint smallint(6) PRI auto_increment
forum_faq fpid 0 NO smallint smallint(6) unsigned
forum_faq displayorder 0 NO tinyint tinyint(3) MUL
forum_faq identifier NO varchar 20 60 utf8 utf8_general_ci varchar(20)
forum_faq keyword NO varchar 50 150 utf8 utf8_general_ci varchar(50)
forum_faq title NO varchar 50 150 utf8 utf8_general_ci varchar(50)
forum_faq message NO text 65535 65535 utf8 utf8_general_ci text
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
forum_filter tid 0 NO mediumint mediumint(8) unsigned PRI
forum_filter pid 0 NO int int(10) unsigned PRI
forum_filter postlength 0 NO int int(10) unsigned
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
forum_forum fid NO mediumint mediumint(8) unsigned PRI auto_increment
forum_forum fup 0 NO mediumint mediumint(8) unsigned MUL
forum_forum type forum NO enum 5 15 utf8 utf8_general_ci enum('group','forum','sub')
forum_forum name NO char 50 150 utf8 utf8_general_ci char(50)
forum_forum status 0 NO tinyint tinyint(1) MUL
forum_forum displayorder 0 NO smallint smallint(6)
forum_forum styleid 0 NO smallint smallint(6) unsigned
forum_forum threads 0 NO mediumint mediumint(8) unsigned
forum_forum posts 0 NO mediumint mediumint(8) unsigned
forum_forum todayposts 0 NO mediumint mediumint(8) unsigned
forum_forum yesterdayposts 0 NO mediumint mediumint(8) unsigned
forum_forum rank 0 NO smallint smallint(6) unsigned
forum_forum oldrank 0 NO smallint smallint(6) unsigned
forum_forum lastpost NO char 110 330 utf8 utf8_general_ci char(110)
forum_forum domain NO char 15 45 utf8 utf8_general_ci char(15)
forum_forum allowsmilies 0 NO tinyint tinyint(1)
forum_forum allowhtml 0 NO tinyint tinyint(1)
forum_forum allowbbcode 0 NO tinyint tinyint(1)
forum_forum allowimgcode 0 NO tinyint tinyint(1)
forum_forum allowmediacode 0 NO tinyint tinyint(1)
forum_forum allowanonymous 0 NO tinyint tinyint(1)
forum_forum allowpostspecial 0 NO smallint smallint(6) unsigned
forum_forum allowspecialonly 0 NO tinyint tinyint(1) unsigned
forum_forum allowappend 0 NO tinyint tinyint(1) unsigned
forum_forum alloweditrules 0 NO tinyint tinyint(1)
forum_forum allowfeed 1 NO tinyint tinyint(1)
forum_forum allowside 0 NO tinyint tinyint(1)
forum_forum recyclebin 0 NO tinyint tinyint(1)
forum_forum modnewposts 0 NO tinyint tinyint(1)
forum_forum jammer 0 NO tinyint tinyint(1)
forum_forum disablewatermark 0 NO tinyint tinyint(1)
forum_forum inheritedmod 0 NO tinyint tinyint(1)
forum_forum autoclose 0 NO smallint smallint(6)
forum_forum forumcolumns 0 NO tinyint tinyint(3) unsigned
forum_forum catforumcolumns 0 NO tinyint tinyint(3) unsigned
forum_forum threadcaches 0 NO tinyint tinyint(1)
forum_forum alloweditpost 1 NO tinyint tinyint(1) unsigned
forum_forum simple 0 NO tinyint tinyint(1) unsigned
forum_forum modworks 0 NO tinyint tinyint(1) unsigned
forum_forum allowglobalstick 1 NO tinyint tinyint(1)
forum_forum level 0 NO smallint smallint(6)
forum_forum commoncredits 0 NO int int(10) unsigned
forum_forum archive 0 NO tinyint tinyint(1)
forum_forum recommend 0 NO smallint smallint(6) unsigned
forum_forum favtimes 0 NO mediumint mediumint(8) unsigned
forum_forum sharetimes 0 NO mediumint mediumint(8) unsigned
forum_forum disablethumb 0 NO tinyint tinyint(1)
forum_forum disablecollect 0 NO tinyint tinyint(1)
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
forum_forum fid NO smallint smallint(6) unsigned PRI
forum_forum threadtableid NO smallint smallint(6) unsigned PRI
forum_forum threads 0 NO int int(11) unsigned
forum_forum posts 0 NO int int(11) unsigned
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
forum_forumfield fid 0 NO mediumint mediumint(8) unsigned PRI
forum_forumfield description NO text 65535 65535 utf8 utf8_general_ci text
forum_forumfield password NO varchar 12 36 utf8 utf8_general_ci varchar(12)
forum_forumfield icon NO varchar 255 765 utf8 utf8_general_ci varchar(255)
forum_forumfield redirect NO varchar 255 765 utf8 utf8_general_ci varchar(255)
forum_forumfield attachextensions NO varchar 255 765 utf8 utf8_general_ci varchar(255)
forum_forumfield creditspolicy NO mediumtext 16777215 16777215 utf8 utf8_general_ci mediumtext
forum_forumfield formulaperm NO text 65535 65535 utf8 utf8_general_ci text
forum_forumfield moderators NO text 65535 65535 utf8 utf8_general_ci text
forum_forumfield rules NO text 65535 65535 utf8 utf8_general_ci text
forum_forumfield threadtypes NO text 65535 65535 utf8 utf8_general_ci text
forum_forumfield threadsorts NO text 65535 65535 utf8 utf8_general_ci text
forum_forumfield viewperm NO text 65535 65535 utf8 utf8_general_ci text
forum_forumfield postperm NO text 65535 65535 utf8 utf8_general_ci text
forum_forumfield replyperm NO text 65535 65535 utf8 utf8_general_ci text
forum_forumfield getattachperm NO text 65535 65535 utf8 utf8_general_ci text
forum_forumfield postattachperm NO text 65535 65535 utf8 utf8_general_ci text
forum_forumfield postimageperm NO text 65535 65535 utf8 utf8_general_ci text
forum_forumfield spviewperm NO text 65535 65535 utf8 utf8_general_ci text
forum_forumfield seotitle NO text 65535 65535 utf8 utf8_general_ci text
forum_forumfield keywords NO text 65535 65535 utf8 utf8_general_ci text
forum_forumfield seodescription NO text 65535 65535 utf8 utf8_general_ci text
forum_forumfield supe_pushsetting NO text 65535 65535 utf8 utf8_general_ci text
forum_forumfield modrecommend NO text 65535 65535 utf8 utf8_general_ci text
forum_forumfield threadplugin NO text 65535 65535 utf8 utf8_general_ci text
forum_forumfield replybg NO text 65535 65535 utf8 utf8_general_ci text
forum_forumfield extra NO text 65535 65535 utf8 utf8_general_ci text
forum_forumfield jointype 0 NO tinyint tinyint(1)
forum_forumfield gviewperm 0 NO tinyint tinyint(1) unsigned
forum_forumfield membernum 0 NO smallint smallint(6) unsigned MUL
forum_forumfield dateline 0 NO int int(10) unsigned MUL
forum_forumfield lastupdate 0 NO int int(10) unsigned MUL
forum_forumfield activity 0 NO int int(10) unsigned MUL
forum_forumfield founderuid 0 NO mediumint mediumint(8) unsigned
forum_forumfield foundername NO varchar 255 765 utf8 utf8_general_ci varchar(255)
forum_forumfield banner NO varchar 255 765 utf8 utf8_general_ci varchar(255)
forum_forumfield groupnum 0 NO smallint smallint(6) unsigned
forum_forumfield commentitem NO text 65535 65535 utf8 utf8_general_ci text
forum_forumfield relatedgroup NO text 65535 65535 utf8 utf8_general_ci text
forum_forumfield picstyle 0 NO tinyint tinyint(1)
forum_forumfield widthauto 0 NO tinyint tinyint(1)
forum_forumfield noantitheft 0 NO tinyint tinyint(1)
forum_forumfield noforumhidewater 0 NO tinyint tinyint(1)
forum_forumfield noforumrecommend 0 NO tinyint tinyint(1)
forum_forumfield livetid 0 NO mediumint mediumint(8) unsigned
forum_forumfield price 0 NO mediumint mediumint(8) unsigned
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
forum_forumrecommend fid 0 NO mediumint mediumint(8) unsigned MUL
forum_forumrecommend tid NO mediumint mediumint(8) unsigned PRI
forum_forumrecommend typeid NO smallint smallint(6)
forum_forumrecommend displayorder NO tinyint tinyint(1)
forum_forumrecommend subject NO char 80 240 utf8 utf8_general_ci char(80)
forum_forumrecommend author NO char 15 45 utf8 utf8_general_ci char(15)
forum_forumrecommend authorid NO mediumint mediumint(8)
forum_forumrecommend moderatorid NO mediumint mediumint(8)
forum_forumrecommend expiration NO int int(10) unsigned
forum_forumrecommend position 0 NO tinyint tinyint(1) MUL
forum_forumrecommend highlight 0 NO tinyint tinyint(1)
forum_forumrecommend aid 0 NO mediumint mediumint(8) unsigned
forum_forumrecommend filename NO char 100 300 utf8 utf8_general_ci char(100)
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
forum_groupcreditslog fid NO mediumint mediumint(8) unsigned PRI
forum_groupcreditslog uid NO mediumint mediumint(8) unsigned PRI
forum_groupcreditslog logdate 0 NO int int(8) PRI
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
forum_groupfield fid 0 NO mediumint mediumint(8) unsigned PRI
forum_groupfield privacy 0 NO tinyint tinyint(1) unsigned
forum_groupfield dateline 0 NO int int(10) unsigned
forum_groupfield type NO varchar 255 765 utf8 utf8_general_ci varchar(255) PRI
forum_groupfield data NO text 65535 65535 utf8 utf8_general_ci text
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
forum_groupinvite fid 0 NO mediumint mediumint(8) unsigned PRI
forum_groupinvite uid 0 NO mediumint mediumint(8) unsigned
forum_groupinvite inviteuid 0 NO mediumint mediumint(8) unsigned PRI
forum_groupinvite dateline 0 NO int int(10) unsigned MUL
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
forum_grouplevel levelid NO smallint smallint(6) unsigned PRI auto_increment
forum_grouplevel type default NO enum 7 21 utf8 utf8_general_ci enum('special','default')
forum_grouplevel leveltitle NO varchar 255 765 utf8 utf8_general_ci varchar(255)
forum_grouplevel creditshigher 0 NO int int(10) MUL
forum_grouplevel creditslower 0 NO int int(10)
forum_grouplevel icon NO varchar 255 765 utf8 utf8_general_ci varchar(255)
forum_grouplevel creditspolicy NO text 65535 65535 utf8 utf8_general_ci text
forum_grouplevel postpolicy NO text 65535 65535 utf8 utf8_general_ci text
forum_grouplevel specialswitch NO text 65535 65535 utf8 utf8_general_ci text
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
forum_groupuser fid 0 NO mediumint mediumint(8) unsigned PRI
forum_groupuser uid 0 NO mediumint mediumint(8) unsigned PRI
forum_groupuser username NO char 15 45 utf8 utf8_general_ci char(15)
forum_groupuser level 0 NO tinyint tinyint(3) unsigned
forum_groupuser threads 0 NO mediumint mediumint(8) unsigned
forum_groupuser replies 0 NO mediumint mediumint(8) unsigned
forum_groupuser joindateline 0 NO int int(10) unsigned
forum_groupuser lastupdate 0 NO int int(10) unsigned
forum_groupuser privacy 0 NO tinyint tinyint(1) unsigned
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
forum_hotreply tid 0 NO mediumint mediumint(8) unsigned
forum_hotreply pid 0 NO int int(10) unsigned PRI
forum_hotreply uid 0 NO mediumint mediumint(8) unsigned PRI
forum_hotreply attitude 0 NO tinyint tinyint(1) unsigned
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
forum_hotreply pid 0 NO int int(10) unsigned PRI
forum_hotreply tid 0 NO mediumint mediumint(8) unsigned MUL
forum_hotreply support 0 NO smallint smallint(6) unsigned
forum_hotreply against 0 NO smallint smallint(6) unsigned
forum_hotreply total 0 NO mediumint mediumint(8) unsigned
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
forum_imagetype typeid NO smallint smallint(6) unsigned PRI auto_increment
forum_imagetype available 0 NO tinyint tinyint(1)
forum_imagetype name NO char 20 60 utf8 utf8_general_ci char(20)
forum_imagetype type smiley NO enum 6 18 utf8 utf8_general_ci enum('smiley','icon','avatar')
forum_imagetype displayorder 0 NO tinyint tinyint(3)
forum_imagetype directory NO char 100 300 utf8 utf8_general_ci char(100)
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
forum_medal medalid NO smallint smallint(6) unsigned PRI auto_increment
forum_medal name NO varchar 50 150 utf8 utf8_general_ci varchar(50)
forum_medal available 0 NO tinyint tinyint(1) MUL
forum_medal image NO varchar 255 765 utf8 utf8_general_ci varchar(255)
forum_medal type 0 NO tinyint tinyint(1)
forum_medal displayorder 0 NO tinyint tinyint(3) MUL
forum_medal description NO varchar 255 765 utf8 utf8_general_ci varchar(255)
forum_medal expiration 0 NO smallint smallint(6) unsigned
forum_medal permission NO mediumtext 16777215 16777215 utf8 utf8_general_ci mediumtext
forum_medal credit 0 NO tinyint tinyint(1) unsigned
forum_medal price 0 NO mediumint mediumint(8) unsigned
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
forum_medallog id NO mediumint mediumint(8) unsigned PRI auto_increment
forum_medallog uid 0 NO mediumint mediumint(8) unsigned MUL
forum_medallog medalid 0 NO smallint smallint(6) unsigned
forum_medallog type 0 NO tinyint tinyint(1) MUL
forum_medallog dateline 0 NO int int(10) unsigned MUL
forum_medallog expiration 0 NO int int(10) unsigned
forum_medallog status 0 NO tinyint tinyint(1) MUL
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
forum_memberrecommend tid NO mediumint mediumint(8) unsigned MUL
forum_memberrecommend recommenduid NO mediumint mediumint(8) unsigned MUL
forum_memberrecommend dateline NO int int(10) unsigned
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
forum_moderator uid 0 NO mediumint mediumint(8) unsigned PRI
forum_moderator fid 0 NO mediumint mediumint(8) unsigned PRI
forum_moderator displayorder 0 NO tinyint tinyint(3)
forum_moderator inherited 0 NO tinyint tinyint(1)
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
forum_modwork uid 0 NO mediumint mediumint(8) unsigned MUL
forum_modwork modaction NO char 3 9 utf8 utf8_general_ci char(3)
forum_modwork dateline 2006-01-01 NO date date
forum_modwork count 0 NO smallint smallint(6) unsigned
forum_modwork posts 0 NO smallint smallint(6) unsigned
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
forum_newthread tid 0 NO mediumint mediumint(8) unsigned PRI
forum_newthread fid 0 NO mediumint mediumint(8) unsigned MUL
forum_newthread dateline 0 NO int int(10) unsigned MUL
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
forum_onlinelist groupid 0 NO smallint smallint(6) unsigned
forum_onlinelist displayorder 0 NO tinyint tinyint(3)
forum_onlinelist title NO varchar 30 90 utf8 utf8_general_ci varchar(30)
forum_onlinelist url NO varchar 30 90 utf8 utf8_general_ci varchar(30)
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
forum_order orderid NO char 32 96 utf8 utf8_general_ci char(32) PRI
forum_order status NO char 3 9 utf8 utf8_general_ci char(3)
forum_order buyer NO char 50 150 utf8 utf8_general_ci char(50)
forum_order admin NO char 15 45 utf8 utf8_general_ci char(15)
forum_order uid 0 NO mediumint mediumint(8) unsigned MUL
forum_order amount 0 NO int int(10) unsigned
forum_order price 0.00 NO float float(7,2) unsigned
forum_order submitdate 0 NO int int(10) unsigned MUL
forum_order confirmdate 0 NO int int(10) unsigned
forum_order email NO char 40 120 utf8 utf8_general_ci char(40)
forum_order ip NO char 15 45 utf8 utf8_general_ci char(15)
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
forum_poll tid 0 NO mediumint mediumint(8) unsigned PRI
forum_poll overt 0 NO tinyint tinyint(1)
forum_poll multiple 0 NO tinyint tinyint(1)
forum_poll visible 0 NO tinyint tinyint(1)
forum_poll maxchoices 0 NO tinyint tinyint(3) unsigned
forum_poll isimage 0 NO tinyint tinyint(1)
forum_poll expiration 0 NO int int(10) unsigned
forum_poll pollpreview NO varchar 255 765 utf8 utf8_general_ci varchar(255)
forum_poll voters 0 NO mediumint mediumint(8) unsigned
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
forum_polloption polloptionid NO int int(10) unsigned PRI auto_increment
forum_polloption tid 0 NO mediumint mediumint(8) unsigned MUL
forum_polloption votes 0 NO mediumint mediumint(8) unsigned
forum_polloption displayorder 0 NO tinyint tinyint(3)
forum_polloption polloption NO varchar 80 240 utf8 utf8_general_ci varchar(80)
forum_polloption voterids NO mediumtext 16777215 16777215 utf8 utf8_general_ci mediumtext
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
forum_polloption aid NO int int(10) unsigned PRI auto_increment
forum_polloption poid 0 NO int int(10) unsigned MUL
forum_polloption tid 0 NO mediumint mediumint(8) unsigned MUL
forum_polloption pid 0 NO int int(10) unsigned
forum_polloption uid 0 NO mediumint mediumint(8) unsigned MUL
forum_polloption filename NO varchar 255 765 utf8 utf8_general_ci varchar(255)
forum_polloption filesize 0 NO int int(10) unsigned
forum_polloption attachment NO varchar 255 765 utf8 utf8_general_ci varchar(255)
forum_polloption remote 0 NO tinyint tinyint(1) unsigned
forum_polloption width 0 NO smallint smallint(6) unsigned
forum_polloption thumb 0 NO tinyint tinyint(1) unsigned
forum_polloption dateline 0 NO int int(10) unsigned
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
forum_pollvoter tid 0 NO mediumint mediumint(8) unsigned MUL
forum_pollvoter uid 0 NO mediumint mediumint(8) unsigned MUL
forum_pollvoter username NO varchar 15 45 utf8 utf8_general_ci varchar(15)
forum_pollvoter options NO text 65535 65535 utf8 utf8_general_ci text
forum_pollvoter dateline 0 NO int int(10) unsigned
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
forum_post pid NO int int(10) unsigned UNI
forum_post fid 0 NO mediumint mediumint(8) unsigned MUL
forum_post tid 0 NO mediumint mediumint(8) unsigned PRI
forum_post first 0 NO tinyint tinyint(1)
forum_post author NO varchar 15 45 utf8 utf8_general_ci varchar(15)
forum_post authorid 0 NO mediumint mediumint(8) unsigned MUL
forum_post subject NO varchar 80 240 utf8 utf8_general_ci varchar(80)
forum_post dateline 0 NO int int(10) unsigned MUL
forum_post message NO mediumtext 16777215 16777215 utf8 utf8_general_ci mediumtext
forum_post useip NO varchar 15 45 utf8 utf8_general_ci varchar(15)
forum_post port 0 NO smallint smallint(6) unsigned
forum_post invisible 0 NO tinyint tinyint(1) MUL
forum_post anonymous 0 NO tinyint tinyint(1)
forum_post usesig 0 NO tinyint tinyint(1)
forum_post htmlon 0 NO tinyint tinyint(1)
forum_post bbcodeoff 0 NO tinyint tinyint(1)
forum_post smileyoff 0 NO tinyint tinyint(1)
forum_post parseurloff 0 NO tinyint tinyint(1)
forum_post attachment 0 NO tinyint tinyint(1)
forum_post rate 0 NO smallint smallint(6)
forum_post ratetimes 0 NO tinyint tinyint(3) unsigned
forum_post status 0 NO int int(10)
forum_post tags 0 NO varchar 255 765 utf8 utf8_general_ci varchar(255)
forum_post comment 0 NO tinyint tinyint(1)
forum_post replycredit 0 NO int int(10)
forum_post position NO int int(8) unsigned PRI auto_increment
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
forum_post pid 0 NO int int(10) unsigned PRI
forum_post tid 0 YES mediumint mediumint(8) unsigned MUL
forum_post uid 0 YES mediumint mediumint(8) unsigned MUL
forum_post mapx NO varchar 255 765 utf8 utf8_general_ci varchar(255)
forum_post mapy NO varchar 255 765 utf8 utf8_general_ci varchar(255)
forum_post location NO varchar 255 765 utf8 utf8_general_ci varchar(255)
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
forum_post id 0 NO int int(10) unsigned PRI
forum_post status 0 NO tinyint tinyint(3) MUL
forum_post dateline 0 NO int int(10) unsigned
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
forum_post pid NO int int(10) unsigned PRI auto_increment
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
forum_postcache pid NO int int(10) unsigned PRI
forum_postcache comment NO text 65535 65535 utf8 utf8_general_ci text
forum_postcache rate NO text 65535 65535 utf8 utf8_general_ci text
forum_postcache dateline 0 NO int int(10) unsigned MUL
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
forum_postcomment id NO int int(10) unsigned PRI auto_increment
forum_postcomment tid 0 NO mediumint mediumint(8) unsigned MUL
forum_postcomment pid 0 NO int int(10) unsigned MUL
forum_postcomment author NO varchar 15 45 utf8 utf8_general_ci varchar(15)
forum_postcomment authorid 0 NO mediumint mediumint(8) MUL
forum_postcomment dateline 0 NO int int(10) unsigned
forum_postcomment comment NO varchar 255 765 utf8 utf8_general_ci varchar(255)
forum_postcomment score 0 NO tinyint tinyint(1) MUL
forum_postcomment useip NO varchar 15 45 utf8 utf8_general_ci varchar(15)
forum_postcomment port 0 NO smallint smallint(6) unsigned
forum_postcomment rpid 0 NO int int(10) unsigned MUL
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
forum_postlog pid 0 NO int int(10) unsigned PRI
forum_postlog tid 0 NO mediumint mediumint(8) unsigned PRI
forum_postlog fid 0 NO smallint smallint(6) unsigned MUL
forum_postlog uid 0 NO mediumint mediumint(8) unsigned MUL
forum_postlog action NO char 10 30 utf8 utf8_general_ci char(10)
forum_postlog dateline 0 NO int int(10) unsigned MUL
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
forum_poststick tid NO mediumint mediumint(8) unsigned PRI
forum_poststick pid NO int int(10) unsigned PRI
forum_poststick position NO int int(10) unsigned
forum_poststick dateline NO int int(10) unsigned
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
forum_promotion ip NO char 15 45 utf8 utf8_general_ci char(15) PRI
forum_promotion uid 0 NO mediumint mediumint(8) unsigned
forum_promotion username NO char 15 45 utf8 utf8_general_ci char(15)
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
forum_ratelog pid 0 NO int int(10) unsigned MUL
forum_ratelog uid 0 NO mediumint mediumint(8) unsigned MUL
forum_ratelog username NO char 15 45 utf8 utf8_general_ci char(15)
forum_ratelog extcredits 0 NO tinyint tinyint(1) unsigned
forum_ratelog dateline 0 NO int int(10) unsigned MUL
forum_ratelog score 0 NO smallint smallint(6)
forum_ratelog reason NO char 40 120 utf8 utf8_general_ci char(40)
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
forum_relatedthread tid 0 NO mediumint mediumint(8) PRI
forum_relatedthread type general NO enum 7 21 utf8 utf8_general_ci enum('general','trade') PRI
forum_relatedthread expiration 0 NO int int(10)
forum_relatedthread keywords NO varchar 255 765 utf8 utf8_general_ci varchar(255)
forum_relatedthread relatedthreads NO text 65535 65535 utf8 utf8_general_ci text
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
forum_replycredit tid NO mediumint mediumint(6) unsigned PRI
forum_replycredit extcredits 0 NO mediumint mediumint(6) unsigned
forum_replycredit extcreditstype 0 NO tinyint tinyint(1)
forum_replycredit times 0 NO smallint smallint(6) unsigned
forum_replycredit membertimes 0 NO smallint smallint(6) unsigned
forum_replycredit random 0 NO tinyint tinyint(1)
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
forum_rsscache lastupdate 0 NO int int(10) unsigned
forum_rsscache fid 0 NO mediumint mediumint(8) unsigned MUL
forum_rsscache tid 0 NO mediumint mediumint(8) unsigned PRI
forum_rsscache dateline 0 NO int int(10) unsigned
forum_rsscache forum NO char 50 150 utf8 utf8_general_ci char(50)
forum_rsscache author NO char 15 45 utf8 utf8_general_ci char(15)
forum_rsscache subject NO char 80 240 utf8 utf8_general_ci char(80)
forum_rsscache description NO char 255 765 utf8 utf8_general_ci char(255)
forum_rsscache guidetype NO char 10 30 utf8 utf8_general_ci char(10)
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
forum_sofa tid 0 NO mediumint mediumint(8) unsigned PRI
forum_sofa fid 0 NO mediumint mediumint(8) unsigned MUL
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
forum_spacecache uid 0 NO mediumint mediumint(8) unsigned PRI
forum_spacecache variable NO varchar 20 60 utf8 utf8_general_ci varchar(20) PRI
forum_spacecache value NO text 65535 65535 utf8 utf8_general_ci text
forum_spacecache expiration 0 NO int int(10) unsigned
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
forum_statlog logdate NO date date PRI
forum_statlog fid NO mediumint mediumint(8) unsigned PRI
forum_statlog type 0 NO smallint smallint(5) unsigned
forum_statlog value 0 NO int int(10) unsigned
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
forum_thread tid NO mediumint mediumint(8) unsigned PRI auto_increment
forum_thread fid 0 NO mediumint mediumint(8) unsigned MUL
forum_thread posttableid 0 NO smallint smallint(6) unsigned
forum_thread typeid 0 NO smallint smallint(6) unsigned
forum_thread sortid 0 NO smallint smallint(6) unsigned MUL
forum_thread readperm 0 NO tinyint tinyint(3) unsigned
forum_thread price 0 NO smallint smallint(6)
forum_thread author NO char 15 45 utf8 utf8_general_ci char(15)
forum_thread authorid 0 NO mediumint mediumint(8) unsigned MUL
forum_thread subject NO char 80 240 utf8 utf8_general_ci char(80)
forum_thread dateline 0 NO int int(10) unsigned
forum_thread lastpost 0 NO int int(10) unsigned
forum_thread lastposter NO char 15 45 utf8 utf8_general_ci char(15)
forum_thread views 0 NO int int(10) unsigned
forum_thread replies 0 NO mediumint mediumint(8) unsigned
forum_thread displayorder 0 NO tinyint tinyint(1)
forum_thread highlight 0 NO tinyint tinyint(1)
forum_thread digest 0 NO tinyint tinyint(1) MUL
forum_thread rate 0 NO tinyint tinyint(1)
forum_thread special 0 NO tinyint tinyint(1) MUL
forum_thread attachment 0 NO tinyint tinyint(1)
forum_thread moderated 0 NO tinyint tinyint(1)
forum_thread closed 0 NO mediumint mediumint(8) unsigned
forum_thread stickreply 0 NO tinyint tinyint(1) unsigned
forum_thread recommends 0 NO smallint smallint(6) MUL
forum_thread recommend_add 0 NO smallint smallint(6)
forum_thread recommend_sub 0 NO smallint smallint(6)
forum_thread heats 0 NO int int(10) unsigned MUL
forum_thread status 0 NO smallint smallint(6) unsigned
forum_thread isgroup 0 NO tinyint tinyint(1) MUL
forum_thread favtimes 0 NO mediumint mediumint(8)
forum_thread sharetimes 0 NO mediumint mediumint(8)
forum_thread stamp -1 NO tinyint tinyint(3)
forum_thread icon -1 NO tinyint tinyint(3)
forum_thread pushedaid 0 NO mediumint mediumint(8)
forum_thread cover 0 NO smallint smallint(6)
forum_thread replycredit 0 NO smallint smallint(6)
forum_thread relatebytag 0 NO char 255 765 utf8 utf8_general_ci char(255)
forum_thread maxposition 0 NO int int(8) unsigned
forum_thread bgcolor NO char 8 24 utf8 utf8_general_ci char(8)
forum_thread comments 0 NO int int(10) unsigned
forum_thread hidden 0 NO smallint smallint(6) unsigned
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
forum_thread id 0 NO int int(10) unsigned PRI
forum_thread status 0 NO tinyint tinyint(3) MUL
forum_thread dateline 0 NO int int(10) unsigned
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
forum_threadaddviews tid 0 NO mediumint mediumint(8) unsigned PRI
forum_threadaddviews addviews 0 NO int int(10) unsigned
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
forum_threadcalendar cid NO mediumint mediumint(8) unsigned PRI auto_increment
forum_threadcalendar fid 0 NO mediumint mediumint(8) unsigned MUL
forum_threadcalendar dateline 0 NO int int(10) unsigned
forum_threadcalendar hotnum 0 NO int int(10) unsigned
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
forum_threadclass typeid NO mediumint mediumint(8) unsigned PRI auto_increment
forum_threadclass fid NO mediumint mediumint(8) unsigned MUL
forum_threadclass name NO varchar 255 765 utf8 utf8_general_ci varchar(255)
forum_threadclass displayorder NO mediumint mediumint(9)
forum_threadclass icon NO varchar 255 765 utf8 utf8_general_ci varchar(255)
forum_threadclass moderators 0 NO tinyint tinyint(1)
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
forum_threadclosed tid 0 NO mediumint mediumint(8) unsigned PRI
forum_threadclosed redirect 0 NO mediumint mediumint(8) unsigned
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
forum_threaddisablepos tid 0 NO mediumint mediumint(8) unsigned PRI
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
forum_threadhidelog tid 0 NO mediumint mediumint(8) unsigned PRI
forum_threadhidelog uid 0 NO mediumint mediumint(8) unsigned PRI
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
forum_threadhot cid 0 NO mediumint mediumint(8) unsigned PRI
forum_threadhot fid 0 NO mediumint mediumint(8) unsigned MUL
forum_threadhot tid 0 NO mediumint mediumint(8) unsigned PRI
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
forum_threadimage tid 0 NO mediumint mediumint(8) unsigned MUL
forum_threadimage attachment NO varchar 255 765 utf8 utf8_general_ci varchar(255)
forum_threadimage remote 0 NO tinyint tinyint(1) unsigned
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
forum_threadlog tid 0 NO mediumint mediumint(8) unsigned PRI
forum_threadlog fid 0 NO smallint smallint(6) unsigned PRI
forum_threadlog uid 0 NO mediumint mediumint(8) unsigned PRI
forum_threadlog otherid 0 NO smallint smallint(6) unsigned
forum_threadlog action NO char 10 30 utf8 utf8_general_ci char(10)
forum_threadlog expiry 0 NO int int(10) unsigned
forum_threadlog dateline 0 NO int int(10) unsigned MUL
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
forum_threadmod tid 0 NO mediumint mediumint(8) unsigned MUL
forum_threadmod uid 0 NO mediumint mediumint(8) unsigned
forum_threadmod username NO char 15 45 utf8 utf8_general_ci char(15)
forum_threadmod dateline 0 NO int int(10) unsigned
forum_threadmod expiration 0 NO int int(10) unsigned MUL
forum_threadmod action NO char 5 15 utf8 utf8_general_ci char(5)
forum_threadmod status 0 NO tinyint tinyint(1)
forum_threadmod magicid NO smallint smallint(6) unsigned
forum_threadmod stamp NO tinyint tinyint(3)
forum_threadmod reason NO char 40 120 utf8 utf8_general_ci char(40)
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
forum_threadpartake tid 0 NO mediumint mediumint(8) unsigned MUL
forum_threadpartake uid 0 NO mediumint mediumint(8) unsigned
forum_threadpartake dateline 0 NO int int(10) unsigned
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
forum_threadpreview tid 0 NO mediumint mediumint(8) unsigned PRI
forum_threadpreview relay 0 NO int int(10) unsigned
forum_threadpreview content NO text 65535 65535 utf8 utf8_general_ci text
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
forum_threadprofile id NO mediumint mediumint(8) unsigned PRI auto_increment
forum_threadprofile name NO char 100 300 utf8 utf8_general_ci char(100)
forum_threadprofile template NO text 65535 65535 utf8 utf8_general_ci text
forum_threadprofile global 0 NO tinyint tinyint(1) MUL
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
forum_threadprofile gid NO mediumint mediumint(8) PRI
forum_threadprofile tpid NO mediumint mediumint(8) unsigned
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
forum_threadrush tid 0 NO mediumint mediumint(8) unsigned PRI
forum_threadrush stopfloor 0 NO mediumint mediumint(8) unsigned
forum_threadrush starttimefrom 0 NO int int(10) unsigned
forum_threadrush starttimeto 0 NO int int(10) unsigned
forum_threadrush rewardfloor NO text 65535 65535 utf8 utf8_general_ci text
forum_threadrush creditlimit -996 NO int int(10)
forum_threadrush replylimit 0 NO smallint smallint(6)
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
forum_threadtype typeid NO smallint smallint(6) unsigned PRI auto_increment
forum_threadtype fid 0 NO mediumint mediumint(8) unsigned
forum_threadtype displayorder 0 NO smallint smallint(6)
forum_threadtype name NO varchar 255 765 utf8 utf8_general_ci varchar(255)
forum_threadtype description NO varchar 255 765 utf8 utf8_general_ci varchar(255)
forum_threadtype icon NO varchar 255 765 utf8 utf8_general_ci varchar(255)
forum_threadtype special 0 NO smallint smallint(6)
forum_threadtype modelid 0 NO smallint smallint(6) unsigned
forum_threadtype expiration 0 NO tinyint tinyint(1)
forum_threadtype template NO text 65535 65535 utf8 utf8_general_ci text
forum_threadtype stemplate NO text 65535 65535 utf8 utf8_general_ci text
forum_threadtype ptemplate NO text 65535 65535 utf8 utf8_general_ci text
forum_threadtype btemplate NO text 65535 65535 utf8 utf8_general_ci text
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
forum_trade tid NO mediumint mediumint(8) unsigned PRI
forum_trade pid NO int int(10) unsigned PRI
forum_trade typeid NO smallint smallint(6) unsigned MUL
forum_trade sellerid NO mediumint mediumint(8) unsigned MUL
forum_trade seller NO char 15 45 utf8 utf8_general_ci char(15)
forum_trade account NO char 50 150 utf8 utf8_general_ci char(50)
forum_trade tenpayaccount NO char 20 60 utf8 utf8_general_ci char(20)
forum_trade subject NO char 100 300 utf8 utf8_general_ci char(100)
forum_trade price NO decimal decimal(8,2)
forum_trade amount 1 NO smallint smallint(6) unsigned
forum_trade quality 0 NO tinyint tinyint(1) unsigned
forum_trade locus NO char 20 60 utf8 utf8_general_ci char(20)
forum_trade transport 0 NO tinyint tinyint(1)
forum_trade ordinaryfee 0 NO smallint smallint(4) unsigned
forum_trade expressfee 0 NO smallint smallint(4) unsigned
forum_trade emsfee 0 NO smallint smallint(4) unsigned
forum_trade itemtype 0 NO tinyint tinyint(1)
forum_trade dateline 0 NO int int(10) unsigned
forum_trade expiration 0 NO int int(10) unsigned MUL
forum_trade lastbuyer NO char 15 45 utf8 utf8_general_ci char(15)
forum_trade lastupdate 0 NO int int(10) unsigned
forum_trade totalitems 0 NO smallint smallint(5) unsigned MUL
forum_trade tradesum 0.00 NO decimal decimal(8,2) MUL
forum_trade closed 0 NO tinyint tinyint(1)
forum_trade aid NO mediumint mediumint(8) unsigned
forum_trade displayorder NO tinyint tinyint(1)
forum_trade costprice NO decimal decimal(8,2)
forum_trade credit 0 NO int int(10) unsigned
forum_trade costcredit 0 NO int int(10) unsigned
forum_trade credittradesum 0 NO int int(10) unsigned MUL
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
forum_tradecomment id NO mediumint mediumint(8) PRI auto_increment
forum_tradecomment orderid NO char 32 96 utf8 utf8_general_ci char(32) MUL
forum_tradecomment pid NO int int(10) unsigned
forum_tradecomment type NO tinyint tinyint(1)
forum_tradecomment raterid NO mediumint mediumint(8) unsigned MUL
forum_tradecomment rater NO char 15 45 utf8 utf8_general_ci char(15)
forum_tradecomment rateeid NO mediumint mediumint(8) unsigned MUL
forum_tradecomment ratee NO char 15 45 utf8 utf8_general_ci char(15)
forum_tradecomment message NO char 200 600 utf8 utf8_general_ci char(200)
forum_tradecomment explanation NO char 200 600 utf8 utf8_general_ci char(200)
forum_tradecomment score NO tinyint tinyint(1)
forum_tradecomment dateline NO int int(10) unsigned
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
forum_tradelog tid NO mediumint mediumint(8) unsigned MUL
forum_tradelog pid NO int int(10) unsigned MUL
forum_tradelog orderid NO varchar 32 96 utf8 utf8_general_ci varchar(32) PRI
forum_tradelog tradeno NO varchar 32 96 utf8 utf8_general_ci varchar(32)
forum_tradelog paytype 0 NO tinyint tinyint(1) unsigned
forum_tradelog subject NO varchar 100 300 utf8 utf8_general_ci varchar(100)
forum_tradelog price 0.00 NO decimal decimal(8,2)
forum_tradelog quality 0 NO tinyint tinyint(1) unsigned
forum_tradelog itemtype 0 NO tinyint tinyint(1)
forum_tradelog number 0 NO smallint smallint(5) unsigned
forum_tradelog tax 0.00 NO decimal decimal(6,2) unsigned
forum_tradelog locus NO varchar 100 300 utf8 utf8_general_ci varchar(100)
forum_tradelog sellerid NO mediumint mediumint(8) unsigned MUL
forum_tradelog seller NO varchar 15 45 utf8 utf8_general_ci varchar(15)
forum_tradelog selleraccount NO varchar 50 150 utf8 utf8_general_ci varchar(50)
forum_tradelog tenpayaccount 0 NO varchar 20 60 utf8 utf8_general_ci varchar(20)
forum_tradelog buyerid NO mediumint mediumint(8) unsigned MUL
forum_tradelog buyer NO varchar 15 45 utf8 utf8_general_ci varchar(15)
forum_tradelog buyercontact NO varchar 50 150 utf8 utf8_general_ci varchar(50)
forum_tradelog buyercredits 0 NO smallint smallint(5) unsigned
forum_tradelog buyermsg YES varchar 200 600 utf8 utf8_general_ci varchar(200)
forum_tradelog status 0 NO tinyint tinyint(1) MUL
forum_tradelog lastupdate 0 NO int int(10) unsigned
forum_tradelog offline 0 NO tinyint tinyint(1)
forum_tradelog buyername NO varchar 50 150 utf8 utf8_general_ci varchar(50)
forum_tradelog buyerzip NO varchar 10 30 utf8 utf8_general_ci varchar(10)
forum_tradelog buyerphone NO varchar 20 60 utf8 utf8_general_ci varchar(20)
forum_tradelog buyermobile NO varchar 20 60 utf8 utf8_general_ci varchar(20)
forum_tradelog transport 0 NO tinyint tinyint(1)
forum_tradelog transportfee 0 NO smallint smallint(6) unsigned
forum_tradelog baseprice NO decimal decimal(8,2)
forum_tradelog discount 0 NO tinyint tinyint(1)
forum_tradelog ratestatus 0 NO tinyint tinyint(1)
forum_tradelog message NO text 65535 65535 utf8 utf8_general_ci text
forum_tradelog credit 0 NO int int(10) unsigned
forum_tradelog basecredit 0 NO int int(10) unsigned
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
forum_typeoption optionid NO smallint smallint(6) unsigned PRI auto_increment
forum_typeoption classid 0 NO smallint smallint(6) unsigned MUL
forum_typeoption displayorder 0 NO tinyint tinyint(3)
forum_typeoption expiration NO tinyint tinyint(1)
forum_typeoption protect NO varchar 255 765 utf8 utf8_general_ci varchar(255)
forum_typeoption title NO varchar 255 765 utf8 utf8_general_ci varchar(255)
forum_typeoption description NO varchar 255 765 utf8 utf8_general_ci varchar(255)
forum_typeoption identifier NO varchar 255 765 utf8 utf8_general_ci varchar(255)
forum_typeoption type NO varchar 255 765 utf8 utf8_general_ci varchar(255)
forum_typeoption unit NO varchar 255 765 utf8 utf8_general_ci varchar(255)
forum_typeoption rules NO mediumtext 16777215 16777215 utf8 utf8_general_ci mediumtext
forum_typeoption permprompt NO mediumtext 16777215 16777215 utf8 utf8_general_ci mediumtext
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
forum_typeoptionvar sortid 0 NO smallint smallint(6) unsigned MUL
forum_typeoptionvar tid 0 NO mediumint mediumint(8) unsigned MUL
forum_typeoptionvar fid 0 NO mediumint mediumint(8) unsigned MUL
forum_typeoptionvar optionid 0 NO smallint smallint(6) unsigned
forum_typeoptionvar expiration 0 NO int int(10) unsigned
forum_typeoptionvar value NO mediumtext 16777215 16777215 utf8 utf8_general_ci mediumtext
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
forum_typevar sortid 0 NO smallint smallint(6) PRI
forum_typevar optionid 0 NO smallint smallint(6) PRI
forum_typevar available 0 NO tinyint tinyint(1)
forum_typevar required 0 NO tinyint tinyint(1)
forum_typevar unchangeable 0 NO tinyint tinyint(1)
forum_typevar search 0 NO tinyint tinyint(1)
forum_typevar displayorder 0 NO tinyint tinyint(3)
forum_typevar subjectshow 0 NO tinyint tinyint(1)
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
forum_warning wid NO int int(10) unsigned PRI auto_increment
forum_warning pid NO int int(10) unsigned UNI
forum_warning operatorid NO mediumint mediumint(8) unsigned
forum_warning operator NO char 15 45 utf8 utf8_general_ci char(15)
forum_warning authorid NO mediumint mediumint(8) unsigned MUL
forum_warning author NO char 15 45 utf8 utf8_general_ci char(15)
forum_warning dateline NO int int(10) unsigned
forum_warning reason NO char 40 120 utf8 utf8_general_ci char(40)
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
home_album albumid NO mediumint mediumint(8) unsigned PRI auto_increment
home_album albumname NO varchar 50 150 utf8 utf8_general_ci varchar(50)
home_album catid 0 NO smallint smallint(6) unsigned
home_album uid 0 NO mediumint mediumint(8) unsigned MUL
home_album username NO varchar 15 45 utf8 utf8_general_ci varchar(15)
home_album dateline 0 NO int int(10) unsigned
home_album updatetime 0 NO int int(10) unsigned MUL
home_album picnum 0 NO smallint smallint(6) unsigned
home_album pic NO varchar 255 765 utf8 utf8_general_ci varchar(255)
home_album picflag 0 NO tinyint tinyint(1)
home_album friend 0 NO tinyint tinyint(1)
home_album password NO varchar 10 30 utf8 utf8_general_ci varchar(10)
home_album target_ids NO text 65535 65535 utf8 utf8_general_ci text
home_album favtimes NO mediumint mediumint(8) unsigned
home_album sharetimes NO mediumint mediumint(8) unsigned
home_album depict NO text 65535 65535 utf8 utf8_general_ci text
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
home_album catid NO mediumint mediumint(8) unsigned PRI auto_increment
home_album upid 0 NO mediumint mediumint(8) unsigned
home_album catname NO varchar 255 765 utf8 utf8_general_ci varchar(255)
home_album num 0 NO mediumint mediumint(8) unsigned
home_album displayorder 0 NO smallint smallint(6)
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
home_appcreditlog logid NO mediumint mediumint(8) unsigned PRI auto_increment
home_appcreditlog uid 0 NO mediumint mediumint(8) unsigned MUL
home_appcreditlog appid 0 NO mediumint mediumint(8) unsigned MUL
home_appcreditlog appname NO varchar 60 180 utf8 utf8_general_ci varchar(60)
home_appcreditlog type 0 NO tinyint tinyint(1)
home_appcreditlog credit 0 NO mediumint mediumint(8) unsigned
home_appcreditlog note NO text 65535 65535 utf8 utf8_general_ci text
home_appcreditlog dateline 0 NO int int(10) unsigned
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
home_blacklist uid 0 NO mediumint mediumint(8) unsigned PRI
home_blacklist buid 0 NO mediumint mediumint(8) unsigned PRI
home_blacklist dateline 0 NO int int(10) unsigned
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
home_blog blogid NO mediumint mediumint(8) unsigned PRI auto_increment
home_blog uid 0 NO mediumint mediumint(8) unsigned MUL
home_blog username NO char 15 45 utf8 utf8_general_ci char(15)
home_blog subject NO char 80 240 utf8 utf8_general_ci char(80)
home_blog classid 0 NO smallint smallint(6) unsigned
home_blog catid 0 NO smallint smallint(6) unsigned
home_blog viewnum 0 NO mediumint mediumint(8) unsigned
home_blog replynum 0 NO mediumint mediumint(8) unsigned
home_blog hot 0 NO mediumint mediumint(8) unsigned MUL
home_blog dateline 0 NO int int(10) unsigned MUL
home_blog picflag 0 NO tinyint tinyint(1)
home_blog noreply 0 NO tinyint tinyint(1)
home_blog friend 0 NO tinyint tinyint(1)
home_blog password NO char 10 30 utf8 utf8_general_ci char(10)
home_blog favtimes 0 NO mediumint mediumint(8) unsigned
home_blog sharetimes 0 NO mediumint mediumint(8) unsigned
home_blog status 0 NO tinyint tinyint(1)
home_blog click1 0 NO smallint smallint(6) unsigned
home_blog click2 0 NO smallint smallint(6) unsigned
home_blog click3 0 NO smallint smallint(6) unsigned
home_blog click4 0 NO smallint smallint(6) unsigned
home_blog click5 0 NO smallint smallint(6) unsigned
home_blog click6 0 NO smallint smallint(6) unsigned
home_blog click7 0 NO smallint smallint(6) unsigned
home_blog click8 0 NO smallint smallint(6) unsigned
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
home_blog catid NO mediumint mediumint(8) unsigned PRI auto_increment
home_blog upid 0 NO mediumint mediumint(8) unsigned
home_blog catname NO varchar 255 765 utf8 utf8_general_ci varchar(255)
home_blog num 0 NO mediumint mediumint(8) unsigned
home_blog displayorder 0 NO smallint smallint(6)
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
home_blog id 0 NO int int(10) unsigned PRI
home_blog status 0 NO tinyint tinyint(3) MUL
home_blog dateline 0 NO int int(10) unsigned
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
home_blogfield blogid 0 NO mediumint mediumint(8) unsigned PRI
home_blogfield uid 0 NO mediumint mediumint(8) unsigned MUL
home_blogfield pic NO varchar 255 765 utf8 utf8_general_ci varchar(255)
home_blogfield tag NO varchar 255 765 utf8 utf8_general_ci varchar(255)
home_blogfield message NO mediumtext 16777215 16777215 utf8 utf8_general_ci mediumtext
home_blogfield postip NO varchar 255 765 utf8 utf8_general_ci varchar(255)
home_blogfield port 0 NO smallint smallint(6) unsigned
home_blogfield related NO text 65535 65535 utf8 utf8_general_ci text
home_blogfield relatedtime 0 NO int int(10) unsigned
home_blogfield target_ids NO text 65535 65535 utf8 utf8_general_ci text
home_blogfield hotuser NO text 65535 65535 utf8 utf8_general_ci text
home_blogfield magiccolor 0 NO tinyint tinyint(6)
home_blogfield magicpaper 0 NO tinyint tinyint(6)
home_blogfield pushedaid 0 NO mediumint mediumint(8)
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
home_class classid NO mediumint mediumint(8) unsigned PRI auto_increment
home_class classname NO char 40 120 utf8 utf8_general_ci char(40)
home_class uid 0 NO mediumint mediumint(8) unsigned MUL
home_class dateline 0 NO int int(10) unsigned
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
home_click clickid NO smallint smallint(6) unsigned PRI auto_increment
home_click name NO char 50 150 utf8 utf8_general_ci char(50)
home_click icon NO char 100 300 utf8 utf8_general_ci char(100)
home_click idtype NO char 15 45 utf8 utf8_general_ci char(15) MUL
home_click available 0 NO tinyint tinyint(1) unsigned
home_click displayorder 0 NO tinyint tinyint(6) unsigned
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
home_clickuser uid 0 NO mediumint mediumint(8) unsigned MUL
home_clickuser username NO varchar 15 45 utf8 utf8_general_ci varchar(15)
home_clickuser id 0 NO mediumint mediumint(8) unsigned MUL
home_clickuser idtype NO varchar 15 45 utf8 utf8_general_ci varchar(15)
home_clickuser clickid 0 NO smallint smallint(6) unsigned
home_clickuser dateline 0 NO int int(10) unsigned
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
home_comment cid NO mediumint mediumint(8) unsigned PRI auto_increment
home_comment uid 0 NO mediumint mediumint(8) unsigned
home_comment id 0 NO mediumint mediumint(8) unsigned MUL
home_comment idtype NO varchar 20 60 utf8 utf8_general_ci varchar(20)
home_comment authorid 0 NO mediumint mediumint(8) unsigned MUL
home_comment author NO varchar 15 45 utf8 utf8_general_ci varchar(15)
home_comment ip NO varchar 20 60 utf8 utf8_general_ci varchar(20)
home_comment port 0 NO smallint smallint(6) unsigned
home_comment dateline 0 NO int int(10) unsigned
home_comment message NO text 65535 65535 utf8 utf8_general_ci text
home_comment magicflicker 0 NO tinyint tinyint(1)
home_comment status 0 NO tinyint tinyint(1)
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
home_comment id 0 NO int int(10) unsigned PRI
home_comment idtype NO varchar 15 45 utf8 utf8_general_ci varchar(15) MUL
home_comment status 0 NO tinyint tinyint(3)
home_comment dateline 0 NO int int(10) unsigned
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
home_docomment id NO int int(10) unsigned PRI auto_increment
home_docomment upid 0 NO int int(10) unsigned
home_docomment doid 0 NO mediumint mediumint(8) unsigned MUL
home_docomment uid 0 NO mediumint mediumint(8) unsigned
home_docomment username NO varchar 15 45 utf8 utf8_general_ci varchar(15)
home_docomment dateline 0 NO int int(10) unsigned MUL
home_docomment message NO text 65535 65535 utf8 utf8_general_ci text
home_docomment ip NO varchar 20 60 utf8 utf8_general_ci varchar(20)
home_docomment grade 0 NO smallint smallint(6) unsigned
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
home_doing doid NO mediumint mediumint(8) unsigned PRI auto_increment
home_doing uid 0 NO mediumint mediumint(8) unsigned MUL
home_doing username NO varchar 15 45 utf8 utf8_general_ci varchar(15)
home_doing from NO varchar 20 60 utf8 utf8_general_ci varchar(20)
home_doing dateline 0 NO int int(10) unsigned MUL
home_doing message NO text 65535 65535 utf8 utf8_general_ci text
home_doing ip NO varchar 20 60 utf8 utf8_general_ci varchar(20)
home_doing port 0 NO smallint smallint(6) unsigned
home_doing replynum 0 NO int int(10) unsigned
home_doing status 0 NO tinyint tinyint(1) unsigned
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
home_doing id 0 NO int int(10) unsigned PRI
home_doing status 0 NO tinyint tinyint(3) MUL
home_doing dateline 0 NO int int(10) unsigned
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
home_favorite favid NO mediumint mediumint(8) unsigned PRI auto_increment
home_favorite uid 0 NO mediumint mediumint(8) unsigned MUL
home_favorite id 0 NO mediumint mediumint(8) unsigned MUL
home_favorite idtype NO varchar 255 765 utf8 utf8_general_ci varchar(255)
home_favorite spaceuid 0 NO mediumint mediumint(8) unsigned
home_favorite title NO varchar 255 765 utf8 utf8_general_ci varchar(255)
home_favorite description NO text 65535 65535 utf8 utf8_general_ci text
home_favorite dateline 0 NO int int(10) unsigned
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
home_feed feedid NO int int(10) unsigned PRI auto_increment
home_feed appid 0 NO smallint smallint(6) unsigned
home_feed icon NO varchar 30 90 utf8 utf8_general_ci varchar(30)
home_feed uid 0 NO mediumint mediumint(8) unsigned MUL
home_feed username NO varchar 15 45 utf8 utf8_general_ci varchar(15)
home_feed dateline 0 NO int int(10) unsigned MUL
home_feed friend 0 NO tinyint tinyint(1)
home_feed hash_template NO varchar 32 96 utf8 utf8_general_ci varchar(32)
home_feed hash_data NO varchar 32 96 utf8 utf8_general_ci varchar(32)
home_feed title_template NO text 65535 65535 utf8 utf8_general_ci text
home_feed title_data NO text 65535 65535 utf8 utf8_general_ci text
home_feed body_template NO text 65535 65535 utf8 utf8_general_ci text
home_feed body_data NO text 65535 65535 utf8 utf8_general_ci text
home_feed body_general NO text 65535 65535 utf8 utf8_general_ci text
home_feed image_1 NO varchar 255 765 utf8 utf8_general_ci varchar(255)
home_feed image_1_link NO varchar 255 765 utf8 utf8_general_ci varchar(255)
home_feed image_2 NO varchar 255 765 utf8 utf8_general_ci varchar(255)
home_feed image_2_link NO varchar 255 765 utf8 utf8_general_ci varchar(255)
home_feed image_3 NO varchar 255 765 utf8 utf8_general_ci varchar(255)
home_feed image_3_link NO varchar 255 765 utf8 utf8_general_ci varchar(255)
home_feed image_4 NO varchar 255 765 utf8 utf8_general_ci varchar(255)
home_feed image_4_link NO varchar 255 765 utf8 utf8_general_ci varchar(255)
home_feed target_ids NO text 65535 65535 utf8 utf8_general_ci text
home_feed id 0 NO mediumint mediumint(8) unsigned MUL
home_feed idtype NO varchar 15 45 utf8 utf8_general_ci varchar(15)
home_feed hot 0 NO mediumint mediumint(8) unsigned MUL
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
home_feed feedid NO int int(10) unsigned PRI auto_increment
home_feed appid 0 NO smallint smallint(6) unsigned
home_feed icon NO varchar 30 90 utf8 utf8_general_ci varchar(30)
home_feed uid 0 NO mediumint mediumint(8) unsigned MUL
home_feed username NO varchar 15 45 utf8 utf8_general_ci varchar(15)
home_feed dateline 0 NO int int(10) unsigned MUL
home_feed friend 0 NO tinyint tinyint(1)
home_feed hash_template NO varchar 32 96 utf8 utf8_general_ci varchar(32)
home_feed hash_data NO varchar 32 96 utf8 utf8_general_ci varchar(32)
home_feed title_template NO text 65535 65535 utf8 utf8_general_ci text
home_feed title_data NO text 65535 65535 utf8 utf8_general_ci text
home_feed body_template NO text 65535 65535 utf8 utf8_general_ci text
home_feed body_data NO text 65535 65535 utf8 utf8_general_ci text
home_feed body_general NO text 65535 65535 utf8 utf8_general_ci text
home_feed image_1 NO varchar 255 765 utf8 utf8_general_ci varchar(255)
home_feed image_1_link NO varchar 255 765 utf8 utf8_general_ci varchar(255)
home_feed image_2 NO varchar 255 765 utf8 utf8_general_ci varchar(255)
home_feed image_2_link NO varchar 255 765 utf8 utf8_general_ci varchar(255)
home_feed image_3 NO varchar 255 765 utf8 utf8_general_ci varchar(255)
home_feed image_3_link NO varchar 255 765 utf8 utf8_general_ci varchar(255)
home_feed image_4 NO varchar 255 765 utf8 utf8_general_ci varchar(255)
home_feed image_4_link NO varchar 255 765 utf8 utf8_general_ci varchar(255)
home_feed target_ids NO text 65535 65535 utf8 utf8_general_ci text
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
home_follow uid 0 NO mediumint mediumint(8) unsigned PRI
home_follow username NO char 15 45 utf8 utf8_general_ci char(15)
home_follow followuid 0 NO mediumint mediumint(8) unsigned PRI
home_follow fusername NO char 15 45 utf8 utf8_general_ci char(15)
home_follow bkname NO varchar 255 765 utf8 utf8_general_ci varchar(255)
home_follow status 0 NO tinyint tinyint(1)
home_follow mutual 0 NO tinyint tinyint(1)
home_follow dateline 0 NO int int(10) unsigned
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
home_follow feedid NO mediumint mediumint(8) unsigned PRI auto_increment
home_follow uid 0 NO mediumint mediumint(8) unsigned MUL
home_follow username NO varchar 15 45 utf8 utf8_general_ci varchar(15)
home_follow tid 0 NO mediumint mediumint(8) unsigned
home_follow note NO text 65535 65535 utf8 utf8_general_ci text
home_follow dateline 0 NO int int(10) unsigned
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
home_follow feedid NO mediumint mediumint(8) unsigned PRI auto_increment
home_follow uid 0 NO mediumint mediumint(8) unsigned MUL
home_follow username NO varchar 15 45 utf8 utf8_general_ci varchar(15)
home_follow tid 0 NO mediumint mediumint(8) unsigned
home_follow note NO text 65535 65535 utf8 utf8_general_ci text
home_follow dateline 0 NO int int(10) unsigned
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
home_friend uid 0 NO mediumint mediumint(8) unsigned PRI
home_friend fuid 0 NO mediumint mediumint(8) unsigned PRI
home_friend fusername NO varchar 15 45 utf8 utf8_general_ci varchar(15)
home_friend gid 0 NO smallint smallint(6) unsigned
home_friend num 0 NO mediumint mediumint(8) unsigned
home_friend dateline 0 NO int int(10) unsigned
home_friend note NO varchar 255 765 utf8 utf8_general_ci varchar(255)
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
home_friend uid 0 NO mediumint mediumint(8) unsigned PRI
home_friend fuid 0 NO mediumint mediumint(8) unsigned PRI
home_friend fusername NO char 15 45 utf8 utf8_general_ci char(15)
home_friend gid 0 NO smallint smallint(6) unsigned
home_friend note NO char 60 180 utf8 utf8_general_ci char(60)
home_friend dateline 0 NO int int(10) unsigned
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
home_friendlog uid 0 NO mediumint mediumint(8) unsigned PRI
home_friendlog fuid 0 NO mediumint mediumint(8) unsigned PRI
home_friendlog action NO varchar 10 30 utf8 utf8_general_ci varchar(10)
home_friendlog dateline 0 NO int int(10) unsigned
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
home_notification id NO mediumint mediumint(8) unsigned PRI auto_increment
home_notification uid 0 NO mediumint mediumint(8) unsigned MUL
home_notification type NO varchar 20 60 utf8 utf8_general_ci varchar(20)
home_notification new 0 NO tinyint tinyint(1)
home_notification authorid 0 NO mediumint mediumint(8) unsigned
home_notification author NO varchar 15 45 utf8 utf8_general_ci varchar(15)
home_notification note NO text 65535 65535 utf8 utf8_general_ci text
home_notification dateline 0 NO int int(10) unsigned
home_notification from_id 0 NO mediumint mediumint(8) unsigned MUL
home_notification from_idtype NO varchar 20 60 utf8 utf8_general_ci varchar(20)
home_notification from_num 0 NO mediumint mediumint(8) unsigned
home_notification category 0 NO tinyint tinyint(1)
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
home_pic picid NO mediumint mediumint(8) PRI auto_increment
home_pic albumid 0 NO mediumint mediumint(8) unsigned MUL
home_pic uid 0 NO mediumint mediumint(8) unsigned MUL
home_pic username NO varchar 15 45 utf8 utf8_general_ci varchar(15)
home_pic dateline 0 NO int int(10) unsigned
home_pic postip NO varchar 255 765 utf8 utf8_general_ci varchar(255)
home_pic port 0 NO smallint smallint(6) unsigned
home_pic filename NO varchar 255 765 utf8 utf8_general_ci varchar(255)
home_pic title NO varchar 255 765 utf8 utf8_general_ci varchar(255)
home_pic type NO varchar 255 765 utf8 utf8_general_ci varchar(255)
home_pic size 0 NO int int(10) unsigned
home_pic filepath NO varchar 255 765 utf8 utf8_general_ci varchar(255)
home_pic thumb 0 NO tinyint tinyint(1)
home_pic remote 0 NO tinyint tinyint(1)
home_pic hot 0 NO mediumint mediumint(8) unsigned
home_pic sharetimes 0 NO mediumint mediumint(8) unsigned
home_pic click1 0 NO smallint smallint(6) unsigned
home_pic click2 0 NO smallint smallint(6) unsigned
home_pic click3 0 NO smallint smallint(6) unsigned
home_pic click4 0 NO smallint smallint(6) unsigned
home_pic click5 0 NO smallint smallint(6) unsigned
home_pic click6 0 NO smallint smallint(6) unsigned
home_pic click7 0 NO smallint smallint(6) unsigned
home_pic click8 0 NO smallint smallint(6) unsigned
home_pic magicframe 0 NO tinyint tinyint(6)
home_pic status 0 NO tinyint tinyint(1) unsigned
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
home_pic id 0 NO int int(10) unsigned PRI
home_pic status 0 NO tinyint tinyint(3) MUL
home_pic dateline 0 NO int int(10) unsigned
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
home_picfield picid 0 NO mediumint mediumint(8) unsigned PRI
home_picfield hotuser NO text 65535 65535 utf8 utf8_general_ci text
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
home_poke uid 0 NO mediumint mediumint(8) unsigned PRI
home_poke fromuid 0 NO mediumint mediumint(8) unsigned PRI
home_poke fromusername NO varchar 15 45 utf8 utf8_general_ci varchar(15)
home_poke note NO varchar 255 765 utf8 utf8_general_ci varchar(255)
home_poke dateline 0 NO int int(10) unsigned
home_poke iconid 0 NO smallint smallint(6) unsigned
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
home_pokearchive pid NO mediumint mediumint(8) PRI auto_increment
home_pokearchive pokeuid 0 NO int int(10) unsigned MUL
home_pokearchive uid 0 NO mediumint mediumint(8) unsigned
home_pokearchive fromuid 0 NO mediumint mediumint(8) unsigned
home_pokearchive note NO varchar 255 765 utf8 utf8_general_ci varchar(255)
home_pokearchive dateline 0 NO int int(10) unsigned
home_pokearchive iconid 0 NO smallint smallint(6) unsigned
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
home_share sid NO mediumint mediumint(8) unsigned PRI auto_increment
home_share itemid NO mediumint mediumint(8) unsigned
home_share type NO varchar 30 90 utf8 utf8_general_ci varchar(30)
home_share uid 0 NO mediumint mediumint(8) unsigned MUL
home_share username NO varchar 15 45 utf8 utf8_general_ci varchar(15)
home_share fromuid 0 NO mediumint mediumint(8) unsigned
home_share dateline 0 NO int int(10) unsigned MUL
home_share title_template NO text 65535 65535 utf8 utf8_general_ci text
home_share body_template NO text 65535 65535 utf8 utf8_general_ci text
home_share body_data NO text 65535 65535 utf8 utf8_general_ci text
home_share body_general NO text 65535 65535 utf8 utf8_general_ci text
home_share image NO varchar 255 765 utf8 utf8_general_ci varchar(255)
home_share image_link NO varchar 255 765 utf8 utf8_general_ci varchar(255)
home_share hot 0 NO mediumint mediumint(8) unsigned MUL
home_share hotuser NO text 65535 65535 utf8 utf8_general_ci text
home_share status NO tinyint tinyint(1)
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
home_share id 0 NO int int(10) unsigned PRI
home_share status 0 NO tinyint tinyint(3) MUL
home_share dateline 0 NO int int(10) unsigned
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
home_show uid 0 NO mediumint mediumint(8) unsigned PRI
home_show username NO varchar 15 45 utf8 utf8_general_ci varchar(15)
home_show unitprice 1 NO int int(10) unsigned MUL
home_show credit 0 NO int int(10) unsigned MUL
home_show note NO varchar 100 300 utf8 utf8_general_ci varchar(100)
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
home_specialuser uid 0 NO mediumint mediumint(8) unsigned MUL
home_specialuser username NO varchar 15 45 utf8 utf8_general_ci varchar(15)
home_specialuser status 0 NO tinyint tinyint(1) unsigned MUL
home_specialuser dateline 0 NO int int(10)
home_specialuser reason NO text 65535 65535 utf8 utf8_general_ci text
home_specialuser opuid 0 NO mediumint mediumint(8) unsigned
home_specialuser opusername NO varchar 15 45 utf8 utf8_general_ci varchar(15)
home_specialuser displayorder 0 NO mediumint mediumint(8) unsigned
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
home_userapp uid 0 NO mediumint mediumint(8) unsigned MUL
home_userapp appid 0 NO mediumint mediumint(8) unsigned
home_userapp appname NO varchar 60 180 utf8 utf8_general_ci varchar(60)
home_userapp privacy 0 NO tinyint tinyint(1)
home_userapp allowsidenav 0 NO tinyint tinyint(1)
home_userapp allowfeed 0 NO tinyint tinyint(1)
home_userapp allowprofilelink 0 NO tinyint tinyint(1)
home_userapp narrow 0 NO tinyint tinyint(1)
home_userapp menuorder 0 NO smallint smallint(6)
home_userapp displayorder 0 NO smallint smallint(6)
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
home_userappfield uid 0 NO mediumint mediumint(8) unsigned MUL
home_userappfield appid 0 NO mediumint mediumint(8) unsigned
home_userappfield profilelink NO text 65535 65535 utf8 utf8_general_ci text
home_userappfield myml NO text 65535 65535 utf8 utf8_general_ci text
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
home_visitor uid 0 NO mediumint mediumint(8) unsigned PRI
home_visitor vuid 0 NO mediumint mediumint(8) unsigned PRI
home_visitor vusername NO char 15 45 utf8 utf8_general_ci char(15)
home_visitor dateline 0 NO int int(10) unsigned MUL
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
mobile_setting skey NO varchar 255 765 utf8 utf8_general_ci varchar(255) PRI
mobile_setting svalue NO text 65535 65535 utf8 utf8_general_ci text
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
mobile_wsq skey NO int int(10) unsigned PRI
mobile_wsq svalue NO text 65535 65535 utf8 utf8_general_ci text
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
portal_article cid NO int int(10) unsigned PRI auto_increment
portal_article aid 0 NO mediumint mediumint(8) unsigned MUL
portal_article id 0 NO int int(10) unsigned
portal_article idtype NO varchar 255 765 utf8 utf8_general_ci varchar(255)
portal_article title NO varchar 255 765 utf8 utf8_general_ci varchar(255)
portal_article content NO text 65535 65535 utf8 utf8_general_ci text
portal_article pageorder 0 NO smallint smallint(6) unsigned MUL
portal_article dateline 0 NO int int(10) unsigned
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
portal_article aid 0 NO mediumint mediumint(8) unsigned PRI
portal_article catid 0 NO mediumint mediumint(8) unsigned
portal_article viewnum 0 NO mediumint mediumint(8) unsigned
portal_article commentnum 0 NO mediumint mediumint(8) unsigned
portal_article favtimes 0 NO mediumint mediumint(8) unsigned
portal_article sharetimes 0 NO mediumint mediumint(8) unsigned
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
portal_article id 0 NO int int(10) unsigned PRI
portal_article status 0 NO tinyint tinyint(3) MUL
portal_article dateline 0 NO int int(10) unsigned
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
portal_article aid NO mediumint mediumint(8) unsigned PRI auto_increment
portal_article raid 0 NO mediumint mediumint(8) unsigned PRI
portal_article displayorder 0 NO mediumint mediumint(8) unsigned
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
portal_article aid NO mediumint mediumint(8) unsigned PRI auto_increment
portal_article catid 0 NO mediumint mediumint(8) unsigned MUL
portal_article bid 0 NO mediumint mediumint(8) unsigned
portal_article uid 0 NO mediumint mediumint(8) unsigned
portal_article username NO varchar 255 765 utf8 utf8_general_ci varchar(255)
portal_article title NO varchar 255 765 utf8 utf8_general_ci varchar(255)
portal_article highlight NO varchar 255 765 utf8 utf8_general_ci varchar(255)
portal_article author NO varchar 255 765 utf8 utf8_general_ci varchar(255)
portal_article from NO varchar 255 765 utf8 utf8_general_ci varchar(255)
portal_article fromurl NO varchar 255 765 utf8 utf8_general_ci varchar(255)
portal_article url NO varchar 255 765 utf8 utf8_general_ci varchar(255)
portal_article summary NO varchar 255 765 utf8 utf8_general_ci varchar(255)
portal_article pic NO varchar 255 765 utf8 utf8_general_ci varchar(255)
portal_article thumb 0 NO tinyint tinyint(1)
portal_article remote 0 NO tinyint tinyint(1)
portal_article id 0 NO int int(10) unsigned
portal_article idtype NO varchar 255 765 utf8 utf8_general_ci varchar(255)
portal_article contents 0 NO smallint smallint(6)
portal_article allowcomment 0 NO tinyint tinyint(1)
portal_article owncomment 0 NO tinyint tinyint(1)
portal_article click1 0 NO smallint smallint(6) unsigned
portal_article click2 0 NO smallint smallint(6) unsigned
portal_article click3 0 NO smallint smallint(6) unsigned
portal_article click4 0 NO smallint smallint(6) unsigned
portal_article click5 0 NO smallint smallint(6) unsigned
portal_article click6 0 NO smallint smallint(6) unsigned
portal_article click7 0 NO smallint smallint(6) unsigned
portal_article click8 0 NO smallint smallint(6) unsigned
portal_article tag 0 NO tinyint tinyint(8) unsigned
portal_article dateline 0 NO int int(10) unsigned
portal_article status 0 NO tinyint tinyint(1) unsigned
portal_article showinnernav 0 NO tinyint tinyint(1) unsigned
portal_article preaid NO mediumint mediumint(8) unsigned
portal_article nextaid NO mediumint mediumint(8) unsigned
portal_article htmlmade 0 NO tinyint tinyint(1) unsigned
portal_article htmlname NO varchar 255 765 utf8 utf8_general_ci varchar(255)
portal_article htmldir NO varchar 255 765 utf8 utf8_general_ci varchar(255)
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
portal_article aid 0 NO mediumint mediumint(8) unsigned PRI
portal_article content NO text 65535 65535 utf8 utf8_general_ci text
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
portal_attachment attachid NO mediumint mediumint(8) unsigned PRI auto_increment
portal_attachment uid 0 NO mediumint mediumint(8) unsigned
portal_attachment dateline 0 NO int int(10) unsigned
portal_attachment filename NO varchar 255 765 utf8 utf8_general_ci varchar(255)
portal_attachment filetype NO varchar 255 765 utf8 utf8_general_ci varchar(255)
portal_attachment filesize 0 NO int int(10) unsigned
portal_attachment attachment NO varchar 255 765 utf8 utf8_general_ci varchar(255)
portal_attachment isimage 0 NO tinyint tinyint(1)
portal_attachment thumb 0 NO tinyint tinyint(1) unsigned
portal_attachment remote 0 NO tinyint tinyint(1) unsigned
portal_attachment aid 0 NO mediumint mediumint(8) unsigned MUL
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
portal_category catid NO mediumint mediumint(8) unsigned PRI auto_increment
portal_category upid 0 NO mediumint mediumint(8) unsigned
portal_category catname NO varchar 255 765 utf8 utf8_general_ci varchar(255)
portal_category articles 0 NO mediumint mediumint(8) unsigned
portal_category allowcomment 1 NO tinyint tinyint(1)
portal_category displayorder 0 NO smallint smallint(6)
portal_category notinheritedarticle 0 NO tinyint tinyint(1)
portal_category notinheritedblock 0 NO tinyint tinyint(1)
portal_category domain NO varchar 255 765 utf8 utf8_general_ci varchar(255)
portal_category url NO varchar 255 765 utf8 utf8_general_ci varchar(255)
portal_category uid 0 NO mediumint mediumint(8) unsigned
portal_category username NO varchar 255 765 utf8 utf8_general_ci varchar(255)
portal_category dateline 0 NO int int(10) unsigned
portal_category closed 0 NO tinyint tinyint(1)
portal_category shownav 0 NO tinyint tinyint(1)
portal_category description NO text 65535 65535 utf8 utf8_general_ci text
portal_category seotitle NO text 65535 65535 utf8 utf8_general_ci text
portal_category keyword NO text 65535 65535 utf8 utf8_general_ci text
portal_category primaltplname NO varchar 255 765 utf8 utf8_general_ci varchar(255)
portal_category articleprimaltplname NO varchar 255 765 utf8 utf8_general_ci varchar(255)
portal_category disallowpublish 0 NO tinyint tinyint(1)
portal_category foldername NO varchar 255 765 utf8 utf8_general_ci varchar(255)
portal_category notshowarticlesummay NO varchar 255 765 utf8 utf8_general_ci varchar(255)
portal_category perpage 0 NO smallint smallint(6)
portal_category maxpages 0 NO smallint smallint(6)
portal_category noantitheft 0 NO tinyint tinyint(1)
portal_category lastpublish 0 NO int int(10) unsigned
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
portal_category catid 0 NO mediumint mediumint(8) unsigned PRI
portal_category uid 0 NO mediumint mediumint(8) unsigned PRI
portal_category allowpublish 0 NO tinyint tinyint(1)
portal_category allowmanage 0 NO tinyint tinyint(1)
portal_category inheritedcatid 0 NO mediumint mediumint(8)
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
portal_comment cid NO mediumint mediumint(8) unsigned PRI auto_increment
portal_comment uid 0 NO mediumint mediumint(8) unsigned
portal_comment username NO varchar 255 765 utf8 utf8_general_ci varchar(255)
portal_comment id 0 NO mediumint mediumint(8) unsigned MUL
portal_comment idtype NO varchar 20 60 utf8 utf8_general_ci varchar(20)
portal_comment postip NO varchar 255 765 utf8 utf8_general_ci varchar(255)
portal_comment port 0 NO smallint smallint(6) unsigned
portal_comment dateline 0 NO int int(10) unsigned
portal_comment status 0 NO tinyint tinyint(1) unsigned
portal_comment message NO text 65535 65535 utf8 utf8_general_ci text
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
portal_comment id 0 NO int int(10) unsigned PRI
portal_comment idtype NO varchar 15 45 utf8 utf8_general_ci varchar(15) MUL
portal_comment status 0 NO tinyint tinyint(3)
portal_comment dateline 0 NO int int(10) unsigned
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
portal_rsscache lastupdate 0 NO int int(10) unsigned
portal_rsscache catid 0 NO mediumint mediumint(8) unsigned MUL
portal_rsscache aid 0 NO mediumint mediumint(8) unsigned PRI
portal_rsscache dateline 0 NO int int(10) unsigned
portal_rsscache catname NO char 50 150 utf8 utf8_general_ci char(50)
portal_rsscache author NO char 15 45 utf8 utf8_general_ci char(15)
portal_rsscache subject NO char 80 240 utf8 utf8_general_ci char(80)
portal_rsscache description NO char 255 765 utf8 utf8_general_ci char(255)
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
portal_topic topicid NO mediumint mediumint(8) unsigned PRI auto_increment
portal_topic title NO varchar 255 765 utf8 utf8_general_ci varchar(255)
portal_topic name NO varchar 255 765 utf8 utf8_general_ci varchar(255) MUL
portal_topic domain NO varchar 255 765 utf8 utf8_general_ci varchar(255)
portal_topic summary NO text 65535 65535 utf8 utf8_general_ci text
portal_topic keyword NO text 65535 65535 utf8 utf8_general_ci text
portal_topic cover NO varchar 255 765 utf8 utf8_general_ci varchar(255)
portal_topic picflag 0 NO tinyint tinyint(1)
portal_topic primaltplname NO varchar 255 765 utf8 utf8_general_ci varchar(255)
portal_topic useheader 0 NO tinyint tinyint(1)
portal_topic usefooter 0 NO tinyint tinyint(1)
portal_topic uid 0 NO mediumint mediumint(8) unsigned
portal_topic username NO varchar 255 765 utf8 utf8_general_ci varchar(255)
portal_topic viewnum 0 NO mediumint mediumint(8) unsigned
portal_topic dateline 0 NO int int(10) unsigned
portal_topic closed 0 NO tinyint tinyint(1)
portal_topic allowcomment 0 NO tinyint tinyint(1)
portal_topic commentnum 0 NO mediumint mediumint(8) unsigned
portal_topic htmlmade 0 NO tinyint tinyint(1) unsigned
portal_topic htmldir NO varchar 255 765 utf8 utf8_general_ci varchar(255)
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
portal_topic picid NO mediumint mediumint(8) PRI auto_increment
portal_topic topicid 0 NO mediumint mediumint(8) unsigned MUL
portal_topic uid 0 NO mediumint mediumint(8) unsigned
portal_topic username NO varchar 15 45 utf8 utf8_general_ci varchar(15)
portal_topic dateline 0 NO int int(10) unsigned
portal_topic filename NO varchar 255 765 utf8 utf8_general_ci varchar(255)
portal_topic title NO varchar 255 765 utf8 utf8_general_ci varchar(255)
portal_topic size 0 NO int int(10) unsigned
portal_topic filepath NO varchar 255 765 utf8 utf8_general_ci varchar(255)
portal_topic thumb 0 NO tinyint tinyint(1)
portal_topic remote 0 NO tinyint tinyint(1)
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
security_evilpost pid NO int int(10) unsigned PRI
security_evilpost tid 0 NO mediumint mediumint(8) unsigned MUL
security_evilpost type 0 NO tinyint tinyint(1)
security_evilpost evilcount 0 NO int int(10)
security_evilpost eviltype 0 NO mediumint mediumint(8) unsigned
security_evilpost createtime 0 NO int int(10) unsigned
security_evilpost operateresult 0 NO tinyint tinyint(1) unsigned MUL
security_evilpost isreported 0 NO tinyint tinyint(1)
security_evilpost censorword NO char 50 150 utf8 utf8_general_ci char(50)
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
security_eviluser uid NO int int(10) unsigned PRI
security_eviluser evilcount 0 NO int int(10)
security_eviluser eviltype 0 NO mediumint mediumint(8) unsigned
security_eviluser createtime 0 NO int int(10) unsigned
security_eviluser operateresult 0 NO tinyint tinyint(1) unsigned MUL
security_eviluser isreported 0 NO tinyint tinyint(1)
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
security_failedlog id NO int int(11) PRI auto_increment
security_failedlog reporttype NO char 20 60 utf8 utf8_general_ci char(20)
security_failedlog tid 0 NO int int(10) unsigned
security_failedlog pid 0 NO int int(10) unsigned MUL
security_failedlog uid 0 NO int int(10) unsigned MUL
security_failedlog failcount 0 NO int int(10) unsigned
security_failedlog createtime 0 NO int int(10) unsigned
security_failedlog posttime 0 NO int int(10) unsigned
security_failedlog delreason NO char 255 765 utf8 utf8_general_ci char(255)
security_failedlog scheduletime 0 NO int int(10) unsigned
security_failedlog lastfailtime 0 NO int int(10) unsigned
security_failedlog extra1 NO int int(10) unsigned
security_failedlog extra2 0 NO char 255 765 utf8 utf8_general_ci char(255)
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
ucenter_admins uid NO mediumint mediumint(8) unsigned PRI auto_increment
ucenter_admins username NO char 15 45 utf8 utf8_general_ci char(15) UNI
ucenter_admins allowadminsetting 0 NO tinyint tinyint(1)
ucenter_admins allowadminapp 0 NO tinyint tinyint(1)
ucenter_admins allowadminuser 0 NO tinyint tinyint(1)
ucenter_admins allowadminbadword 0 NO tinyint tinyint(1)
ucenter_admins allowadmintag 0 NO tinyint tinyint(1)
ucenter_admins allowadminpm 0 NO tinyint tinyint(1)
ucenter_admins allowadmincredits 0 NO tinyint tinyint(1)
ucenter_admins allowadmindomain 0 NO tinyint tinyint(1)
ucenter_admins allowadmindb 0 NO tinyint tinyint(1)
ucenter_admins allowadminnote 0 NO tinyint tinyint(1)
ucenter_admins allowadmincache 0 NO tinyint tinyint(1)
ucenter_admins allowadminlog 0 NO tinyint tinyint(1)
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
ucenter_applications appid NO smallint smallint(6) unsigned PRI auto_increment
ucenter_applications type NO varchar 16 48 utf8 utf8_general_ci varchar(16)
ucenter_applications name NO varchar 20 60 utf8 utf8_general_ci varchar(20)
ucenter_applications url NO varchar 255 765 utf8 utf8_general_ci varchar(255)
ucenter_applications authkey NO varchar 255 765 utf8 utf8_general_ci varchar(255)
ucenter_applications ip NO varchar 15 45 utf8 utf8_general_ci varchar(15)
ucenter_applications viewprourl NO varchar 255 765 utf8 utf8_general_ci varchar(255)
ucenter_applications apifilename uc.php NO varchar 30 90 utf8 utf8_general_ci varchar(30)
ucenter_applications charset NO varchar 8 24 utf8 utf8_general_ci varchar(8)
ucenter_applications dbcharset NO varchar 8 24 utf8 utf8_general_ci varchar(8)
ucenter_applications synlogin 0 NO tinyint tinyint(1)
ucenter_applications recvnote 0 YES tinyint tinyint(1)
ucenter_applications extra NO text 65535 65535 utf8 utf8_general_ci text
ucenter_applications tagtemplates NO text 65535 65535 utf8 utf8_general_ci text
ucenter_applications allowips NO text 65535 65535 utf8 utf8_general_ci text
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
ucenter_badwords id NO smallint smallint(6) unsigned PRI auto_increment
ucenter_badwords admin NO varchar 15 45 utf8 utf8_general_ci varchar(15)
ucenter_badwords find NO varchar 255 765 utf8 utf8_general_ci varchar(255) UNI
ucenter_badwords replacement NO varchar 255 765 utf8 utf8_general_ci varchar(255)
ucenter_badwords findpattern NO varchar 255 765 utf8 utf8_general_ci varchar(255)
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
ucenter_domains id NO int int(10) unsigned PRI auto_increment
ucenter_domains domain NO char 40 120 utf8 utf8_general_ci char(40)
ucenter_domains ip NO char 15 45 utf8 utf8_general_ci char(15)
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
ucenter_failedlogins ip NO char 15 45 utf8 utf8_general_ci char(15) PRI
ucenter_failedlogins count 0 NO tinyint tinyint(1) unsigned
ucenter_failedlogins lastupdate 0 NO int int(10) unsigned
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
ucenter_feeds feedid NO mediumint mediumint(8) unsigned PRI auto_increment
ucenter_feeds appid NO varchar 30 90 utf8 utf8_general_ci varchar(30)
ucenter_feeds icon NO varchar 30 90 utf8 utf8_general_ci varchar(30)
ucenter_feeds uid 0 NO mediumint mediumint(8) unsigned MUL
ucenter_feeds username NO varchar 15 45 utf8 utf8_general_ci varchar(15)
ucenter_feeds dateline 0 NO int int(10) unsigned
ucenter_feeds hash_template NO varchar 32 96 utf8 utf8_general_ci varchar(32)
ucenter_feeds hash_data NO varchar 32 96 utf8 utf8_general_ci varchar(32)
ucenter_feeds title_template NO text 65535 65535 utf8 utf8_general_ci text
ucenter_feeds title_data NO text 65535 65535 utf8 utf8_general_ci text
ucenter_feeds body_template NO text 65535 65535 utf8 utf8_general_ci text
ucenter_feeds body_data NO text 65535 65535 utf8 utf8_general_ci text
ucenter_feeds body_general NO text 65535 65535 utf8 utf8_general_ci text
ucenter_feeds image_1 NO varchar 255 765 utf8 utf8_general_ci varchar(255)
ucenter_feeds image_1_link NO varchar 255 765 utf8 utf8_general_ci varchar(255)
ucenter_feeds image_2 NO varchar 255 765 utf8 utf8_general_ci varchar(255)
ucenter_feeds image_2_link NO varchar 255 765 utf8 utf8_general_ci varchar(255)
ucenter_feeds image_3 NO varchar 255 765 utf8 utf8_general_ci varchar(255)
ucenter_feeds image_3_link NO varchar 255 765 utf8 utf8_general_ci varchar(255)
ucenter_feeds image_4 NO varchar 255 765 utf8 utf8_general_ci varchar(255)
ucenter_feeds image_4_link NO varchar 255 765 utf8 utf8_general_ci varchar(255)
ucenter_feeds target_ids NO varchar 255 765 utf8 utf8_general_ci varchar(255)
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
ucenter_friends uid 0 NO mediumint mediumint(8) unsigned MUL
ucenter_friends friendid 0 NO mediumint mediumint(8) unsigned MUL
ucenter_friends direction 0 NO tinyint tinyint(1)
ucenter_friends version NO int int(10) unsigned PRI auto_increment
ucenter_friends delstatus 0 NO tinyint tinyint(1)
ucenter_friends comment NO char 255 765 utf8 utf8_general_ci char(255)
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
ucenter_mailqueue mailid NO int int(10) unsigned PRI auto_increment
ucenter_mailqueue touid 0 NO mediumint mediumint(8) unsigned
ucenter_mailqueue tomail NO varchar 32 96 utf8 utf8_general_ci varchar(32)
ucenter_mailqueue frommail NO varchar 100 300 utf8 utf8_general_ci varchar(100)
ucenter_mailqueue subject NO varchar 255 765 utf8 utf8_general_ci varchar(255)
ucenter_mailqueue message NO text 65535 65535 utf8 utf8_general_ci text
ucenter_mailqueue charset NO varchar 15 45 utf8 utf8_general_ci varchar(15)
ucenter_mailqueue htmlon 0 NO tinyint tinyint(1)
ucenter_mailqueue level 1 NO tinyint tinyint(1) MUL
ucenter_mailqueue dateline 0 NO int int(10) unsigned
ucenter_mailqueue failures 0 NO tinyint tinyint(3) unsigned
ucenter_mailqueue appid 0 NO smallint smallint(6) unsigned MUL
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
ucenter_memberfields uid NO mediumint mediumint(8) unsigned PRI
ucenter_memberfields blacklist NO text 65535 65535 utf8 utf8_general_ci text
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
ucenter_members uid NO mediumint mediumint(8) unsigned PRI auto_increment
ucenter_members username NO char 15 45 utf8 utf8_general_ci char(15) UNI
ucenter_members password NO char 32 96 utf8 utf8_general_ci char(32)
ucenter_members email NO char 32 96 utf8 utf8_general_ci char(32) MUL
ucenter_members myid NO char 30 90 utf8 utf8_general_ci char(30)
ucenter_members myidkey NO char 16 48 utf8 utf8_general_ci char(16)
ucenter_members regip NO char 15 45 utf8 utf8_general_ci char(15)
ucenter_members regdate 0 NO int int(10) unsigned
ucenter_members lastloginip 0 NO int int(10)
ucenter_members lastlogintime 0 NO int int(10) unsigned
ucenter_members salt NO char 6 18 utf8 utf8_general_ci char(6)
ucenter_members secques NO char 8 24 utf8 utf8_general_ci char(8)
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
ucenter_mergemembers appid NO smallint smallint(6) unsigned PRI
ucenter_mergemembers username NO char 15 45 utf8 utf8_general_ci char(15) PRI
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
ucenter_newpm uid NO mediumint mediumint(8) unsigned PRI
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
ucenter_notelist noteid NO int int(10) unsigned PRI auto_increment
ucenter_notelist operation NO char 32 96 utf8 utf8_general_ci char(32)
ucenter_notelist closed 0 NO tinyint tinyint(4) MUL
ucenter_notelist totalnum 0 NO smallint smallint(6) unsigned
ucenter_notelist succeednum 0 NO smallint smallint(6) unsigned
ucenter_notelist getdata NO mediumtext 16777215 16777215 utf8 utf8_general_ci mediumtext
ucenter_notelist postdata NO mediumtext 16777215 16777215 utf8 utf8_general_ci mediumtext
ucenter_notelist dateline 0 NO int int(10) unsigned MUL
ucenter_notelist pri 0 NO tinyint tinyint(3)
ucenter_notelist app1 NO tinyint tinyint(4)
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
ucenter_pm pmid NO mediumint mediumint(8) unsigned PRI auto_increment
ucenter_pm plid 0 NO mediumint mediumint(8) unsigned MUL
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
ucenter_pm plid NO mediumint mediumint(8) unsigned PRI auto_increment
ucenter_pm authorid 0 NO mediumint mediumint(8) unsigned MUL
ucenter_pm pmtype 0 NO tinyint tinyint(1) unsigned MUL
ucenter_pm subject NO varchar 80 240 utf8 utf8_general_ci varchar(80)
ucenter_pm members 0 NO smallint smallint(5) unsigned
ucenter_pm min_max NO varchar 17 51 utf8 utf8_general_ci varchar(17) MUL
ucenter_pm dateline 0 NO int int(10) unsigned
ucenter_pm lastmessage NO text 65535 65535 utf8 utf8_general_ci text
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
ucenter_pm plid 0 NO mediumint mediumint(8) unsigned PRI
ucenter_pm uid 0 NO mediumint mediumint(8) unsigned PRI
ucenter_pm isnew 0 NO tinyint tinyint(1) unsigned MUL
ucenter_pm pmnum 0 NO int int(10) unsigned
ucenter_pm lastupdate 0 NO int int(10) unsigned
ucenter_pm lastdateline 0 NO int int(10) unsigned
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
ucenter_pm pmid 0 NO mediumint mediumint(8) unsigned PRI
ucenter_pm plid 0 NO mediumint mediumint(8) unsigned MUL
ucenter_pm authorid 0 NO mediumint mediumint(8) unsigned
ucenter_pm message NO text 65535 65535 utf8 utf8_general_ci text
ucenter_pm delstatus 0 NO tinyint tinyint(1) unsigned
ucenter_pm dateline 0 NO int int(10) unsigned
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
ucenter_pm pmid 0 NO mediumint mediumint(8) unsigned PRI
ucenter_pm plid 0 NO mediumint mediumint(8) unsigned MUL
ucenter_pm authorid 0 NO mediumint mediumint(8) unsigned
ucenter_pm message NO text 65535 65535 utf8 utf8_general_ci text
ucenter_pm delstatus 0 NO tinyint tinyint(1) unsigned
ucenter_pm dateline 0 NO int int(10) unsigned
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
ucenter_pm pmid 0 NO mediumint mediumint(8) unsigned PRI
ucenter_pm plid 0 NO mediumint mediumint(8) unsigned MUL
ucenter_pm authorid 0 NO mediumint mediumint(8) unsigned
ucenter_pm message NO text 65535 65535 utf8 utf8_general_ci text
ucenter_pm delstatus 0 NO tinyint tinyint(1) unsigned
ucenter_pm dateline 0 NO int int(10) unsigned
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
ucenter_pm pmid 0 NO mediumint mediumint(8) unsigned PRI
ucenter_pm plid 0 NO mediumint mediumint(8) unsigned MUL
ucenter_pm authorid 0 NO mediumint mediumint(8) unsigned
ucenter_pm message NO text 65535 65535 utf8 utf8_general_ci text
ucenter_pm delstatus 0 NO tinyint tinyint(1) unsigned
ucenter_pm dateline 0 NO int int(10) unsigned
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
ucenter_pm pmid 0 NO mediumint mediumint(8) unsigned PRI
ucenter_pm plid 0 NO mediumint mediumint(8) unsigned MUL
ucenter_pm authorid 0 NO mediumint mediumint(8) unsigned
ucenter_pm message NO text 65535 65535 utf8 utf8_general_ci text
ucenter_pm delstatus 0 NO tinyint tinyint(1) unsigned
ucenter_pm dateline 0 NO int int(10) unsigned
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
ucenter_pm pmid 0 NO mediumint mediumint(8) unsigned PRI
ucenter_pm plid 0 NO mediumint mediumint(8) unsigned MUL
ucenter_pm authorid 0 NO mediumint mediumint(8) unsigned
ucenter_pm message NO text 65535 65535 utf8 utf8_general_ci text
ucenter_pm delstatus 0 NO tinyint tinyint(1) unsigned
ucenter_pm dateline 0 NO int int(10) unsigned
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
ucenter_pm pmid 0 NO mediumint mediumint(8) unsigned PRI
ucenter_pm plid 0 NO mediumint mediumint(8) unsigned MUL
ucenter_pm authorid 0 NO mediumint mediumint(8) unsigned
ucenter_pm message NO text 65535 65535 utf8 utf8_general_ci text
ucenter_pm delstatus 0 NO tinyint tinyint(1) unsigned
ucenter_pm dateline 0 NO int int(10) unsigned
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
ucenter_pm pmid 0 NO mediumint mediumint(8) unsigned PRI
ucenter_pm plid 0 NO mediumint mediumint(8) unsigned MUL
ucenter_pm authorid 0 NO mediumint mediumint(8) unsigned
ucenter_pm message NO text 65535 65535 utf8 utf8_general_ci text
ucenter_pm delstatus 0 NO tinyint tinyint(1) unsigned
ucenter_pm dateline 0 NO int int(10) unsigned
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
ucenter_pm pmid 0 NO mediumint mediumint(8) unsigned PRI
ucenter_pm plid 0 NO mediumint mediumint(8) unsigned MUL
ucenter_pm authorid 0 NO mediumint mediumint(8) unsigned
ucenter_pm message NO text 65535 65535 utf8 utf8_general_ci text
ucenter_pm delstatus 0 NO tinyint tinyint(1) unsigned
ucenter_pm dateline 0 NO int int(10) unsigned
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
ucenter_pm pmid 0 NO mediumint mediumint(8) unsigned PRI
ucenter_pm plid 0 NO mediumint mediumint(8) unsigned MUL
ucenter_pm authorid 0 NO mediumint mediumint(8) unsigned
ucenter_pm message NO text 65535 65535 utf8 utf8_general_ci text
ucenter_pm delstatus 0 NO tinyint tinyint(1) unsigned
ucenter_pm dateline 0 NO int int(10) unsigned
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
ucenter_protectedmembers uid 0 NO mediumint mediumint(8) unsigned
ucenter_protectedmembers username NO char 15 45 utf8 utf8_general_ci char(15) PRI
ucenter_protectedmembers appid 0 NO tinyint tinyint(1) unsigned PRI
ucenter_protectedmembers dateline 0 NO int int(10) unsigned
ucenter_protectedmembers admin 0 NO char 15 45 utf8 utf8_general_ci char(15)
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
ucenter_settings k NO varchar 32 96 utf8 utf8_general_ci varchar(32) PRI
ucenter_settings v NO text 65535 65535 utf8 utf8_general_ci text
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
ucenter_sqlcache sqlid NO char 6 18 utf8 utf8_general_ci char(6) PRI
ucenter_sqlcache data NO char 100 300 utf8 utf8_general_ci char(100)
ucenter_sqlcache expiry NO int int(10) unsigned MUL
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
ucenter_tags tagname NO char 20 60 utf8 utf8_general_ci char(20) MUL
ucenter_tags appid 0 NO smallint smallint(6) unsigned
ucenter_tags data YES mediumtext 16777215 16777215 utf8 utf8_general_ci mediumtext
ucenter_tags expiration NO int int(10) unsigned
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
ucenter_vars name NO char 32 96 utf8 utf8_general_ci char(32) PRI
ucenter_vars value NO char 255 765 utf8 utf8_general_ci char(255)