mysql.puroparty.com
puroparty
wp_2_comments
| Server: mysql.puroparty.com
|
Database: puroparty
|
Table: wp_2_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 | 2 | comment_ID | |
| comment_ID_2 | UNIQUE | 2 | comment_ID | |
| comment_author_email_2 | UNIQUE | 2 | comment_author_email | |
| comment_author_url_2 | UNIQUE | 2 | comment_author_url | |
| comment_author_IP_2 | UNIQUE | 2 | comment_author_IP | |
| comment_date_2 | UNIQUE | 2 | comment_date | |
| comment_date_gmt_3 | UNIQUE | 2 | comment_date_gmt | |
| comment_approved_3 | UNIQUE | 2 | comment_approved | |
| comment_agent_2 | UNIQUE | 2 | comment_agent | |
| comment_approved_6 | UNIQUE | 2 | comment_approved | |
| comment_date_4 | UNIQUE | 2 | comment_date | |
| comment_agent_5 | UNIQUE | 2 | comment_agent | |
| comment_date_gmt_4 | UNIQUE | 2 | comment_date_gmt | |
| comment_author_IP_5 | UNIQUE | 2 | comment_author_IP | |
| comment_author_email_5 | UNIQUE | 2 | comment_author_email | |
| comment_author_url_6 | UNIQUE | 2 | comment_author_url | |
| comment_ID_4 | UNIQUE | 2 | comment_ID | |
| 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_karma_2 | INDEX | None | comment_karma | |
| comment_post_ID_3 | INDEX | None | comment_post_ID | |
| comment_date_3 | INDEX | None | comment_date | |
| user_id_2 | INDEX | None | user_id | |
| comment_author_url_4 | INDEX | None | comment_author_url | |
| comment_author_IP_4 | INDEX | None | comment_author_IP | |
| comment_agent_6 | INDEX | None | comment_agent | |
| comment_ID_3 | INDEX | None | comment_ID | |
| comment_type_3 | INDEX | None | comment_type | |
| comment_approved_7 | INDEX | None | comment_approved | |
| comment_parent_2 | INDEX | None | comment_parent | |
| comment_date_gmt_5 | INDEX | None | comment_date_gmt | |
| comment_author_email_6 | INDEX | None | comment_author_email | |
| comment_ID_5 | INDEX | None | comment_ID | |
| comment_author | INDEX | None | comment_author | |
| comment_author_email_3 | INDEX | None | comment_author_email | |
| comment_author_url_3 | INDEX | None | comment_author_url | |
| comment_author_IP_3 | INDEX | None | comment_author_IP | |
| comment_content | INDEX | None | comment_content | |
| comment_approved_4 | INDEX | None | comment_approved | |
| comment_agent_3 | INDEX | None | comment_agent | |
| comment_type_2 | INDEX | None | comment_type | |
| comment_agent_4 | INDEX | None | comment_agent | |
| comment_approved_5 | INDEX | None | comment_approved | |
| comment_author_email_4 | INDEX | None | comment_author_email | |
| comment_author_2 | INDEX | None | comment_author | |
| comment_content_2 | INDEX | None | comment_content | |
| comment_author_url_5 | INDEX | None | comment_author_url | |
| comment_type_4 | INDEX | None | comment_type | |
| comment_author_IP_6 | INDEX | None | comment_author_IP | |
Space usage :
|
Row Statistic :
|
|||||||||||||||||||||||||||||||