mysql.puroparty.com
puroparty
wp_8_posts
| Server: mysql.puroparty.com
|
Database: puroparty
|
Table: wp_8_posts
|
| Field | Type | Null | Default |
|---|---|---|---|
| ID | bigint(20) | No | |
| post_author | bigint(20) | No | 0 |
| post_date | datetime | No | 0000-00-00 00:00:00 |
| post_date_gmt | datetime | No | 0000-00-00 00:00:00 |
| post_content | longtext | No | |
| post_title | text | No | |
| post_category | int(4) | No | 0 |
| post_excerpt | text | No | |
| post_status | varchar(20) | No | publish |
| comment_status | varchar(20) | No | open |
| ping_status | varchar(20) | No | open |
| post_password | varchar(20) | No | |
| post_name | varchar(200) | No | |
| to_ping | text | No | |
| pinged | text | No | |
| post_modified | datetime | No | 0000-00-00 00:00:00 |
| post_modified_gmt | datetime | No | 0000-00-00 00:00:00 |
| post_content_filtered | text | No | |
| post_parent | bigint(20) | No | 0 |
| guid | varchar(255) | No | |
| menu_order | int(11) | No | 0 |
| post_type | varchar(20) | No | post |
| post_mime_type | varchar(100) | No | |
| comment_count | bigint(20) | No | 0 |
| Keyname | Type | Cardinality | Field | |
|---|---|---|---|---|
| PRIMARY | PRIMARY | 10 | ID | |
| ID_2 | UNIQUE | 10 | ID | |
| post_name_3 | UNIQUE | 10 | post_name | |
| post_name_5 | UNIQUE | 10 | post_name | |
| post_name | INDEX | None | post_name | |
| type_status_date | INDEX | None | post_type | |
| post_status | ||||
| post_date | ||||
| ID | ||||
| ID | INDEX | None | ID | |
| post_author | INDEX | None | post_author | |
| post_date | INDEX | None | post_date | |
| post_date_gmt | INDEX | None | post_date_gmt | |
| post_category | INDEX | None | post_category | |
| post_status | INDEX | None | post_status | |
| comment_status | INDEX | None | comment_status | |
| ping_status | INDEX | None | ping_status | |
| post_password | INDEX | None | post_password | |
| post_name_2 | INDEX | None | post_name | |
| post_modified | INDEX | None | post_modified | |
| post_modified_gmt | INDEX | None | post_modified_gmt | |
| post_parent | INDEX | None | post_parent | |
| guid | INDEX | None | guid | |
| menu_order | INDEX | None | menu_order | |
| post_type | INDEX | None | post_type | |
| post_mime_type | INDEX | None | post_mime_type | |
| comment_count | INDEX | None | comment_count | |
| guid_3 | INDEX | None | guid | |
| post_type_3 | INDEX | None | post_type | |
| menu_order_2 | INDEX | None | menu_order | |
| ID_3 | INDEX | None | ID | |
| post_password_3 | INDEX | None | post_password | |
| post_date_gmt_2 | INDEX | None | post_date_gmt | |
| post_author_2 | INDEX | None | post_author | |
| comment_status_4 | INDEX | None | comment_status | |
| post_modified_gmt_2 | INDEX | None | post_modified_gmt | |
| post_category_2 | INDEX | None | post_category | |
| post_status_3 | INDEX | None | post_status | |
| post_name_7 | INDEX | None | post_name | |
| post_mime_type_4 | INDEX | None | post_mime_type | |
| post_date_2 | INDEX | None | post_date | |
| post_content | INDEX | None | post_content | |
| post_title | INDEX | None | post_title | |
| post_excerpt | INDEX | None | post_excerpt | |
| post_status_2 | INDEX | None | post_status | |
| comment_status_2 | INDEX | None | comment_status | |
| ping_status_2 | INDEX | None | ping_status | |
| post_password_2 | INDEX | None | post_password | |
| post_name_4 | INDEX | None | post_name | |
| to_ping | INDEX | None | to_ping | |
| pinged | INDEX | None | pinged | |
| post_content_filtered | INDEX | None | post_content_filtered | |
| guid_2 | INDEX | None | guid | |
| post_type_2 | INDEX | None | post_type | |
| post_mime_type_2 | INDEX | None | post_mime_type | |
| post_type_4 | INDEX | None | post_type | |
| ping_status_3 | INDEX | None | ping_status | |
| comment_status_3 | INDEX | None | comment_status | |
| post_excerpt_2 | INDEX | None | post_excerpt | |
| post_name_6 | INDEX | None | post_name | |
| post_mime_type_3 | INDEX | None | post_mime_type | |
| to_ping_2 | INDEX | None | to_ping | |
| pinged_2 | INDEX | None | pinged | |
| post_content_filtered_2 | INDEX | None | post_content_filtered | |
| post_status_4 | INDEX | None | post_status | |
| post_password_4 | INDEX | None | post_password | |
| post_content_2 | INDEX | None | post_content | |
Space usage :
|
Row Statistic :
|
|||||||||||||||||||||||||||||||