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

   Field  Type Collation Attributes Null Default Extra Action
   bigint(20)   UNSIGNED No    auto_increment  Change Drop Primary Index Unique Fulltext
   bigint(20)     No    Change Drop Primary Index Unique Fulltext
   datetime     No  0000-00-00 00:00:00    Change Drop Primary Index Unique Fulltext
   datetime     No  0000-00-00 00:00:00    Change Drop Primary Index Unique Fulltext
   longtext utf8_general_ci   No      Change Drop Primary Index Unique Fulltext
   text utf8_general_ci   No      Change Drop Primary Index Unique Fulltext
   int(4)     No    Change Drop Primary Index Unique Fulltext
   text utf8_general_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(20) utf8_general_ci   No  publish    Change Drop Primary Index Unique Fulltext
   varchar(20) utf8_general_ci   No  open    Change Drop Primary Index Unique Fulltext
   varchar(20) utf8_general_ci   No  open    Change Drop Primary Index Unique Fulltext
   varchar(20) utf8_general_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(200) utf8_general_ci   No      Change Drop Primary Index Unique Fulltext
   text utf8_general_ci   No      Change Drop Primary Index Unique Fulltext
   text utf8_general_ci   No      Change Drop Primary Index Unique Fulltext
   datetime     No  0000-00-00 00:00:00    Change Drop Primary Index Unique Fulltext
   datetime     No  0000-00-00 00:00:00    Change Drop Primary Index Unique Fulltext
   text utf8_general_ci   No      Change Drop Primary Index Unique Fulltext
   bigint(20)     No    Change Drop Primary Index Unique Fulltext
   varchar(255) utf8_general_ci   No      Change Drop Primary Index Unique Fulltext
   int(11)     No    Change Drop Primary Index Unique Fulltext
   varchar(20) utf8_general_ci   No  post    Change Drop Primary Index Unique Fulltext
   varchar(100) utf8_general_ci   No      Change Drop Primary Index Unique Fulltext
   bigint(20)     No    Change Drop Primary Index Unique Fulltext
With selected: Check All  /  Uncheck All     With selected:  

Print viewPrint view    Propose table structurePropose table structureDocumentation
Add new fieldAdd new field: 


Indexes: Documentation
Keyname Type Cardinality Action Field
PRIMARY PRIMARY Edit Drop ID
ID_2 UNIQUE Edit Drop ID
post_name_3 UNIQUE Edit Drop post_name
post_name_5 UNIQUE Edit Drop post_name
post_name INDEX None  Edit Drop post_name
type_status_date INDEX None  Edit Drop post_type
post_status
post_date
ID
ID INDEX None  Edit Drop ID
post_author INDEX None  Edit Drop post_author
post_date INDEX None  Edit Drop post_date
post_date_gmt INDEX None  Edit Drop post_date_gmt
post_category INDEX None  Edit Drop post_category
post_status INDEX None  Edit Drop post_status
comment_status INDEX None  Edit Drop comment_status
ping_status INDEX None  Edit Drop ping_status
ping_status_2 INDEX None  Edit Drop ping_status
post_password INDEX None  Edit Drop post_password
post_name_2 INDEX None  Edit Drop post_name
post_modified INDEX None  Edit Drop post_modified
post_modified_gmt INDEX None  Edit Drop post_modified_gmt
post_parent INDEX None  Edit Drop post_parent
guid INDEX None  Edit Drop guid
menu_order INDEX None  Edit Drop menu_order
post_type INDEX None  Edit Drop post_type
post_mime_type INDEX None  Edit Drop post_mime_type
comment_count INDEX None  Edit Drop comment_count
post_status_3 INDEX None  Edit Drop post_status
post_modified_gmt_2 INDEX None  Edit Drop post_modified_gmt
post_author_2 INDEX None  Edit Drop post_author
comment_count_2 INDEX None  Edit Drop comment_count
guid_4 INDEX None  Edit Drop guid
comment_status_3 INDEX None  Edit Drop comment_status
post_type_3 INDEX None  Edit Drop post_type
post_parent_2 INDEX None  Edit Drop post_parent
post_date_gmt_2 INDEX None  Edit Drop post_date_gmt
ping_status_4 INDEX None  Edit Drop ping_status
post_category_2 INDEX None  Edit Drop post_category
post_password_3 INDEX None  Edit Drop post_password
post_mime_type_3 INDEX None  Edit Drop post_mime_type
ID_3 INDEX None  Edit Drop ID
post_date_2 INDEX None  Edit Drop post_date
menu_order_2 INDEX None  Edit Drop menu_order
post_content FULLTEXT None  Edit Drop post_content
post_title FULLTEXT None  Edit Drop post_title
post_excerpt FULLTEXT None  Edit Drop post_excerpt
post_status_2 FULLTEXT None  Edit Drop post_status
comment_status_2 FULLTEXT None  Edit Drop comment_status
ping_status_3 FULLTEXT None  Edit Drop ping_status
post_password_2 FULLTEXT None  Edit Drop post_password
post_name_4 FULLTEXT None  Edit Drop post_name
to_ping FULLTEXT None  Edit Drop to_ping
pinged FULLTEXT None  Edit Drop pinged
post_content_filtered FULLTEXT None  Edit Drop post_content_filtered
guid_2 FULLTEXT None  Edit Drop guid
post_type_2 FULLTEXT None  Edit Drop post_type
post_mime_type_2 FULLTEXT None  Edit Drop post_mime_type
guid_3 FULLTEXT None  Edit Drop guid
post_title_2 FULLTEXT None  Edit Drop post_title
post_content_2 FULLTEXT None  Edit Drop post_content
ping_status_5 FULLTEXT None  Edit Drop ping_status
post_type_4 FULLTEXT None  Edit Drop post_type
pinged_2 FULLTEXT None  Edit Drop pinged
post_password_4 FULLTEXT None  Edit Drop post_password
post_content_filtered_2 FULLTEXT None  Edit Drop post_content_filtered
to_ping_2 FULLTEXT None  Edit Drop to_ping
Create an index on  columns  
 
Space usage: 
Type Usage
Data 1,348 Bytes
Index 4,096 Bytes
Total 5,444 Bytes
 
Row Statistic: 
Statements Value
Format dynamic
Collation utf8_general_ci
Rows 5
Row length ø 269
Row size  ø 1,089 Bytes
Next Autoindex 6
Creation Oct 22, 2017 at 10:02 AM
Last update Oct 22, 2017 at 10:02 AM

Run SQL query/queries on database puropartyDocumentation     Fields: 
Or Location of the textfile: 
 Location of the textfile: 
   (Max: 2,048KB)
  Compression:
                
Character set of the file: