Server: mysql.puroparty.com | Database: puroparty | Table: wp_1_comments |
Field | Type | Null | Default |
---|---|---|---|
comment_ID | bigint(20) | No | |
comment_post_ID | int(11) | No | 0 |
comment_author | tinytext | No | |
comment_author_email | varchar(100) | No | |
comment_author_url | varchar(200) | No | |
comment_author_IP | varchar(100) | No | |
comment_date | datetime | No | 0000-00-00 00:00:00 |
comment_date_gmt | datetime | No | 0000-00-00 00:00:00 |
comment_content | text | No | |
comment_karma | int(11) | No | 0 |
comment_approved | varchar(20) | No | 1 |
comment_agent | varchar(255) | No | |
comment_type | varchar(20) | No | |
comment_parent | bigint(20) | No | 0 |
user_id | bigint(20) | No | 0 |
Keyname | Type | Cardinality | Field | |
---|---|---|---|---|
PRIMARY | PRIMARY | 54 | comment_ID | |
comment_ID_2 | UNIQUE | 54 | comment_ID | |
comment_date_2 | UNIQUE | 54 | comment_date | |
comment_date_gmt_3 | UNIQUE | 54 | comment_date_gmt | |
comment_date_4 | UNIQUE | 54 | comment_date | |
comment_date_gmt_5 | UNIQUE | 54 | comment_date_gmt | |
comment_ID_3 | UNIQUE | 54 | comment_ID | |
comment_date_gmt_6 | UNIQUE | 54 | comment_date_gmt | |
comment_approved | INDEX | None | comment_approved | |
comment_post_ID | INDEX | None | comment_post_ID | |
comment_approved_date_gmt | INDEX | None | comment_approved | |
comment_date_gmt | ||||
comment_date_gmt | INDEX | None | comment_date_gmt | |
comment_ID | INDEX | None | comment_ID | |
comment_post_ID_2 | INDEX | None | comment_post_ID | |
comment_author_email | INDEX | None | comment_author_email | |
comment_author_url | INDEX | None | comment_author_url | |
comment_author_IP | INDEX | None | comment_author_IP | |
comment_date | INDEX | None | comment_date | |
comment_date_gmt_2 | INDEX | None | comment_date_gmt | |
comment_karma | INDEX | None | comment_karma | |
comment_approved_2 | INDEX | None | comment_approved | |
comment_agent | INDEX | None | comment_agent | |
comment_type | INDEX | None | comment_type | |
comment_parent | INDEX | None | comment_parent | |
user_id | INDEX | None | user_id | |
comment_date_3 | INDEX | None | comment_date | |
comment_approved_4 | INDEX | None | comment_approved | |
comment_date_gmt_4 | INDEX | None | comment_date_gmt | |
comment_karma_2 | INDEX | None | comment_karma | |
comment_agent_3 | INDEX | None | comment_agent | |
comment_post_ID_3 | INDEX | None | comment_post_ID | |
user_id_2 | INDEX | None | user_id | |
comment_author_IP_3 | INDEX | None | comment_author_IP | |
comment_author_url_3 | INDEX | None | comment_author_url | |
comment_ID_4 | INDEX | None | comment_ID | |
comment_parent_2 | INDEX | None | comment_parent | |
comment_type_4 | INDEX | None | comment_type | |
comment_author_email_4 | INDEX | None | comment_author_email | |
comment_approved_6 | INDEX | None | comment_approved | |
comment_approved_7 | INDEX | None | comment_approved | |
comment_date_5 | INDEX | None | comment_date | |
comment_agent_5 | INDEX | None | comment_agent | |
user_id_3 | INDEX | None | user_id | |
comment_post_ID_4 | INDEX | None | comment_post_ID | |
comment_author | INDEX | None | comment_author | |
comment_author_email_2 | INDEX | None | comment_author_email | |
comment_author_url_2 | INDEX | None | comment_author_url | |
comment_author_IP_2 | INDEX | None | comment_author_IP | |
comment_content | INDEX | None | comment_content | |
comment_approved_3 | INDEX | None | comment_approved | |
comment_agent_2 | INDEX | None | comment_agent | |
comment_type_2 | INDEX | None | comment_type | |
comment_author_email_3 | INDEX | None | comment_author_email | |
comment_content_2 | INDEX | None | comment_content | |
comment_approved_5 | INDEX | None | comment_approved | |
comment_author_IP_4 | INDEX | None | comment_author_IP | |
comment_type_3 | INDEX | None | comment_type | |
comment_author_2 | INDEX | None | comment_author | |
comment_agent_4 | INDEX | None | comment_agent | |
comment_author_url_4 | INDEX | None | comment_author_url | |
comment_author_IP_5 | INDEX | None | comment_author_IP | |
comment_type_5 | INDEX | None | comment_type | |
comment_approved_8 | INDEX | None | comment_approved | |
comment_content_3 | INDEX | None | comment_content |
Space usage :
|
Row Statistic :
|