Server: mysql.puroparty.commysql.puroparty.com
Database: puropartypuroparty
Table: wp_5_commentswp_5_comments

wp_5_comments

Field Type Null Default
comment_ID  bigint(20) No   
comment_post_ID  int(11) No 
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 
comment_approved  varchar(20) No 
comment_agent  varchar(255) No   
comment_type  varchar(20) No   
comment_parent  bigint(20) No 
user_id  bigint(20) No 


 Indexes :
Keyname Type Cardinality Field
PRIMARY PRIMARY 3 comment_ID
comment_ID_2 UNIQUE 3 comment_ID
comment_author_url_2 UNIQUE 3 comment_author_url
comment_author_IP_2 UNIQUE 3 comment_author_IP
comment_date_2 UNIQUE 3 comment_date
comment_date_gmt_3 UNIQUE 3 comment_date_gmt
comment_agent_2 UNIQUE 3 comment_agent
comment_author_url_4 UNIQUE 3 comment_author_url
comment_ID_3 UNIQUE 3 comment_ID
comment_date_gmt_5 UNIQUE 3 comment_date_gmt
comment_date_4 UNIQUE 3 comment_date
comment_agent_6 UNIQUE 3 comment_agent
comment_author_IP_6 UNIQUE 3 comment_author_IP
comment_author_email_5 UNIQUE 3 comment_author_email
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_author_IP_4 INDEX None comment_author_IP
comment_approved_4 INDEX None comment_approved
comment_type_3 INDEX None comment_type
comment_author_email_3 INDEX None comment_author_email
comment_date_gmt_4 INDEX None comment_date_gmt
user_id_2 INDEX None user_id
comment_agent_5 INDEX None comment_agent
comment_parent_2 INDEX None comment_parent
comment_ID_4 INDEX None comment_ID
comment_karma_2 INDEX None comment_karma
comment_post_ID_3 INDEX None comment_post_ID
comment_author_url_6 INDEX None comment_author_url
comment_date_3 INDEX None comment_date
comment_karma_3 INDEX None comment_karma
comment_author INDEX None comment_author
comment_author_email_2 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_3 INDEX None comment_approved
comment_agent_3 INDEX None comment_agent
comment_type_2 INDEX None comment_type
comment_approved_5 INDEX None comment_approved
comment_type_4 INDEX None comment_type
comment_author_IP_5 INDEX None comment_author_IP
comment_agent_4 INDEX None comment_agent
comment_author_2 INDEX None comment_author
comment_author_url_5 INDEX None comment_author_url
comment_content_2 INDEX None comment_content
comment_author_email_4 INDEX None comment_author_email
comment_author_3 INDEX None comment_author
comment_author_IP_7 INDEX None comment_author_IP
comment_approved_6 INDEX None comment_approved


 Space usage :
Type Usage
Data 864 Bytes
Index 4,096 Bytes
Total 4,960 Bytes
   Row Statistic :
Statements Value
Format dynamic
Rows 3
Row length ø 288
Row size  ø 1,653 Bytes
Next Autoindex 4
Creation Dec 11, 2017 at 09:50 PM
Last update Dec 11, 2017 at 09:50 PM