表名称 | 字段名 | 默认值 | 是_可空 | 数据类型 | 最大长度 | 字符长度 | 字符集名 | 整理 | 列类型 | COLUMN_KEY | 额外的 | 描述 | 生成表达式 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
comments | coid | NO | int | int(10) unsigned | PRI | auto_increment | |||||||
comments | cid | 0 | YES | int | int(10) unsigned | MUL | |||||||
comments | created | 0 | YES | int | int(10) unsigned | MUL | |||||||
comments | author | YES | varchar | 200 | 600 | utf8 | utf8_general_ci | varchar(200) | |||||
comments | authorId | 0 | YES | int | int(10) unsigned | ||||||||
comments | ownerId | 0 | YES | int | int(10) unsigned | ||||||||
comments | YES | varchar | 200 | 600 | utf8 | utf8_general_ci | varchar(200) | ||||||
comments | url | YES | varchar | 200 | 600 | utf8 | utf8_general_ci | varchar(200) | |||||
comments | ip | YES | varchar | 64 | 192 | utf8 | utf8_general_ci | varchar(64) | |||||
comments | agent | YES | varchar | 200 | 600 | utf8 | utf8_general_ci | varchar(200) | |||||
comments | text | YES | text | 65535 | 65535 | utf8 | utf8_general_ci | text | |||||
comments | type | comment | YES | varchar | 16 | 48 | utf8 | utf8_general_ci | varchar(16) | ||||
comments | status | approved | YES | varchar | 16 | 48 | utf8 | utf8_general_ci | varchar(16) | ||||
comments | parent | 0 | YES | int | int(10) unsigned | ||||||||
表名称 | 字段名 | 默认值 | 是_可空 | 数据类型 | 最大长度 | 字符长度 | 字符集名 | 整理 | 列类型 | COLUMN_KEY | 额外的 | 描述 | 生成表达式 |
contents | cid | NO | int | int(10) unsigned | PRI | auto_increment | |||||||
contents | title | YES | varchar | 200 | 600 | utf8 | utf8_general_ci | varchar(200) | |||||
contents | slug | YES | varchar | 200 | 600 | utf8 | utf8_general_ci | varchar(200) | UNI | ||||
contents | created | 0 | YES | int | int(10) unsigned | MUL | |||||||
contents | modified | 0 | YES | int | int(10) unsigned | ||||||||
contents | text | YES | longtext | 4294967295 | 4294967295 | utf8 | utf8_general_ci | longtext | |||||
contents | order | 0 | YES | int | int(10) unsigned | ||||||||
contents | authorId | 0 | YES | int | int(10) unsigned | ||||||||
contents | template | YES | varchar | 32 | 96 | utf8 | utf8_general_ci | varchar(32) | |||||
contents | type | post | YES | varchar | 16 | 48 | utf8 | utf8_general_ci | varchar(16) | ||||
contents | status | publish | YES | varchar | 16 | 48 | utf8 | utf8_general_ci | varchar(16) | ||||
contents | password | YES | varchar | 32 | 96 | utf8 | utf8_general_ci | varchar(32) | |||||
contents | commentsNum | 0 | YES | int | int(10) unsigned | ||||||||
contents | allowComment | 0 | YES | char | 1 | 3 | utf8 | utf8_general_ci | char(1) | ||||
contents | allowPing | 0 | YES | char | 1 | 3 | utf8 | utf8_general_ci | char(1) | ||||
contents | allowFeed | 0 | YES | char | 1 | 3 | utf8 | utf8_general_ci | char(1) | ||||
contents | parent | 0 | YES | int | int(10) unsigned | ||||||||
表名称 | 字段名 | 默认值 | 是_可空 | 数据类型 | 最大长度 | 字符长度 | 字符集名 | 整理 | 列类型 | COLUMN_KEY | 额外的 | 描述 | 生成表达式 |
fields | cid | NO | int | int(10) unsigned | PRI | ||||||||
fields | name | NO | varchar | 200 | 600 | utf8 | utf8_general_ci | varchar(200) | PRI | ||||
fields | type | str | YES | varchar | 8 | 24 | utf8 | utf8_general_ci | varchar(8) | ||||
fields | str_value | YES | text | 65535 | 65535 | utf8 | utf8_general_ci | text | |||||
fields | int_value | 0 | YES | int | int(10) | MUL | |||||||
fields | float_value | 0 | YES | float | float | MUL | |||||||
表名称 | 字段名 | 默认值 | 是_可空 | 数据类型 | 最大长度 | 字符长度 | 字符集名 | 整理 | 列类型 | COLUMN_KEY | 额外的 | 描述 | 生成表达式 |
metas | mid | NO | int | int(10) unsigned | PRI | auto_increment | |||||||
metas | name | YES | varchar | 200 | 600 | utf8 | utf8_general_ci | varchar(200) | |||||
metas | slug | YES | varchar | 200 | 600 | utf8 | utf8_general_ci | varchar(200) | MUL | ||||
metas | type | NO | varchar | 32 | 96 | utf8 | utf8_general_ci | varchar(32) | |||||
metas | description | YES | varchar | 200 | 600 | utf8 | utf8_general_ci | varchar(200) | |||||
metas | count | 0 | YES | int | int(10) unsigned | ||||||||
metas | order | 0 | YES | int | int(10) unsigned | ||||||||
metas | parent | 0 | YES | int | int(10) unsigned | ||||||||
表名称 | 字段名 | 默认值 | 是_可空 | 数据类型 | 最大长度 | 字符长度 | 字符集名 | 整理 | 列类型 | COLUMN_KEY | 额外的 | 描述 | 生成表达式 |
options | name | NO | varchar | 32 | 96 | utf8 | utf8_general_ci | varchar(32) | PRI | ||||
options | user | 0 | NO | int | int(10) unsigned | PRI | |||||||
options | value | YES | text | 65535 | 65535 | utf8 | utf8_general_ci | text | |||||
表名称 | 字段名 | 默认值 | 是_可空 | 数据类型 | 最大长度 | 字符长度 | 字符集名 | 整理 | 列类型 | COLUMN_KEY | 额外的 | 描述 | 生成表达式 |
relationships | cid | NO | int | int(10) unsigned | PRI | ||||||||
relationships | mid | NO | int | int(10) unsigned | PRI | ||||||||
表名称 | 字段名 | 默认值 | 是_可空 | 数据类型 | 最大长度 | 字符长度 | 字符集名 | 整理 | 列类型 | COLUMN_KEY | 额外的 | 描述 | 生成表达式 |
users | uid | NO | int | int(10) unsigned | PRI | auto_increment | |||||||
users | name | YES | varchar | 32 | 96 | utf8 | utf8_general_ci | varchar(32) | UNI | ||||
users | password | YES | varchar | 64 | 192 | utf8 | utf8_general_ci | varchar(64) | |||||
users | YES | varchar | 200 | 600 | utf8 | utf8_general_ci | varchar(200) | UNI | |||||
users | url | YES | varchar | 200 | 600 | utf8 | utf8_general_ci | varchar(200) | |||||
users | screenName | YES | varchar | 32 | 96 | utf8 | utf8_general_ci | varchar(32) | |||||
users | created | 0 | YES | int | int(10) unsigned | ||||||||
users | activated | 0 | YES | int | int(10) unsigned | ||||||||
users | logged | 0 | YES | int | int(10) unsigned | ||||||||
users | group | visitor | YES | varchar | 16 | 48 | utf8 | utf8_general_ci | varchar(16) | ||||
users | authCode | YES | varchar | 64 | 192 | utf8 | utf8_general_ci | varchar(64) |