简单代码
beta
博客主题
Z-BlogPHP 1.7.3 主题制作emlog 5.3.1 主题制作
第三方组件
Echarts图表生成
基础在线工具
颜色选择器时间戳在线转换正则表达式在线工具字符串编码转换进制转换数据库结构查看百度翻译随机密码
扫一扫添加微信
  粤ICP备2022073302号-1 粤公网安备 44162302000034号
我的
更新 注册 登陆
颜色选择器时间戳在线转换正则表达式在线工具字符串编码转换进制转换数据库结构查看百度翻译随机密码
网站程序数据库结构
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)
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 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
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 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_member uid NO mediumint mediumint(8) unsigned PRI
common_member openid NO char 32 96 utf8 utf8_general_ci char(32) UNI
common_member status 0 NO tinyint tinyint(1)
common_member isregister 0 NO tinyint tinyint(1) unsigned
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
common_member uid NO mediumint mediumint(8) unsigned PRI
common_member openid NO char 32 96 utf8 utf8_general_ci char(32) MUL
common_member status 0 NO tinyint tinyint(1)
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 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_wechat sid NO char 6 18 utf8 utf8_general_ci char(6) PRI
mobile_wechat code NO int int(10) unsigned UNI
mobile_wechat uid NO mediumint mediumint(8) unsigned
mobile_wechat status 0 NO tinyint tinyint(1)
mobile_wechat createtime NO int int(10) unsigned MUL
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
mobile_wechat id NO int int(10) unsigned PRI auto_increment
mobile_wechat type NO char 5 15 utf8 utf8_general_ci char(5)
mobile_wechat name NO varchar 255 765 utf8 utf8_general_ci varchar(255)
mobile_wechat resource_id NO int int(10) unsigned
mobile_wechat group_id NO int int(10) unsigned
mobile_wechat text YES text 65535 65535 utf8 utf8_general_ci text
mobile_wechat media_id YES char 64 192 utf8 utf8_general_ci char(64)
mobile_wechat created_at NO int int(10) unsigned
mobile_wechat sent_at YES int int(10) unsigned
mobile_wechat msg_id YES int int(10) unsigned
mobile_wechat res_status YES varchar 50 150 utf8 utf8_general_ci varchar(50)
mobile_wechat res_totalcount YES int int(10)
mobile_wechat res_filtercount YES int int(10)
mobile_wechat res_sentcount YES int int(10)
mobile_wechat res_errorcount YES int int(10)
mobile_wechat res_finish_at YES int int(10)
表名称 字段名 默认值 是_可空 数据类型 最大长度 字符长度 字符集名 整理 列类型 COLUMN_KEY 额外的 描述 生成表达式
mobile_wechat id NO int int(10) unsigned PRI auto_increment
mobile_wechat name NO varchar 255 765 utf8 utf8_general_ci varchar(255)
mobile_wechat dateline NO int int(10) unsigned
mobile_wechat type 0 NO tinyint tinyint(1) MUL
mobile_wechat data 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)