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

wp_5_posts

Field Type Null Default
ID  bigint(20) No   
post_author  bigint(20) No 
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 
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 
guid  varchar(255) No   
menu_order  int(11) No 
post_type  varchar(20) No  post 
post_mime_type  varchar(100) No   
comment_count  bigint(20) No 


 Indexes :
Keyname Type Cardinality Field
PRIMARY PRIMARY 5 ID
ID_2 UNIQUE 5 ID
post_name_3 UNIQUE 5 post_name
post_name_5 UNIQUE 5 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
ping_status_2 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
post_status_3 INDEX None post_status
post_modified_gmt_2 INDEX None post_modified_gmt
post_author_2 INDEX None post_author
comment_count_2 INDEX None comment_count
guid_4 INDEX None guid
comment_status_3 INDEX None comment_status
post_type_3 INDEX None post_type
post_parent_2 INDEX None post_parent
post_date_gmt_2 INDEX None post_date_gmt
ping_status_4 INDEX None ping_status
post_category_2 INDEX None post_category
post_password_3 INDEX None post_password
post_mime_type_3 INDEX None post_mime_type
ID_3 INDEX None ID
post_date_2 INDEX None post_date
menu_order_2 INDEX None menu_order
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_3 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
guid_3 INDEX None guid
post_title_2 INDEX None post_title
post_content_2 INDEX None post_content
ping_status_5 INDEX None ping_status
post_type_4 INDEX None post_type
pinged_2 INDEX None pinged
post_password_4 INDEX None post_password
post_content_filtered_2 INDEX None post_content_filtered
to_ping_2 INDEX None to_ping


 Space usage :
Type Usage
Data 1,348 Bytes
Index 4,096 Bytes
Total 5,444 Bytes
   Row Statistic :
Statements Value
Format dynamic
Rows 5
Row length ø 269
Row size  ø 1,089 Bytes
Next Autoindex 6
Creation Oct 22, 2017 at 10:02 AM
Last update Apr 18, 2024 at 02:28 PM
Last check Apr 25, 2024 at 08:00 AM