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

wp_1_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 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 :
Type Usage
Data 19,452 Bytes
Index 4,096 Bytes
Total 23,548 Bytes
   Row Statistic :
Statements Value
Format dynamic
Rows 54
Row length ø 360
Row size  ø 436 Bytes
Next Autoindex 55
Creation Dec 14, 2017 at 08:30 AM
Last update Mar 28, 2024 at 09:40 AM
Last check Apr 25, 2024 at 10:41 AM