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

   Field  Type Collation Attributes Null Default Extra Action
   bigint(20)     No    auto_increment  Change Drop Primary Index Unique Fulltext
   bigint(20)     No    Change Drop Primary Index Unique Fulltext
   varchar(200) utf8_general_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(100) 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
   tinyint(2)     No    Change Drop Primary Index Unique Fulltext
   enum('0', '1') utf8_general_ci   No    Change Drop Primary Index Unique Fulltext
   tinyint(2)     No    Change Drop Primary Index Unique Fulltext
   tinyint(2)     No    Change Drop Primary Index Unique Fulltext
   tinyint(2)     No    Change Drop Primary Index Unique Fulltext
   int(11)     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 blog_id
blog_id_2 UNIQUE Edit Drop blog_id
path_2 UNIQUE Edit Drop path
registered_2 UNIQUE Edit Drop registered
last_updated_2 UNIQUE Edit Drop last_updated
last_updated_3 UNIQUE Edit Drop last_updated
registered_4 UNIQUE Edit Drop registered
path_5 UNIQUE Edit Drop path
blog_id_4 UNIQUE Edit Drop blog_id
blog_id_5 UNIQUE Edit Drop blog_id
last_updated_5 UNIQUE Edit Drop last_updated
path_8 UNIQUE Edit Drop path
registered_6 UNIQUE Edit Drop registered
registered_7 UNIQUE Edit Drop registered
last_updated_7 UNIQUE Edit Drop last_updated
domain INDEX None  Edit Drop domain 50
path 5
lang_id INDEX None  Edit Drop lang_id
blog_id INDEX None  Edit Drop blog_id
site_id INDEX None  Edit Drop site_id
domain_2 INDEX None  Edit Drop domain
path INDEX None  Edit Drop path
registered INDEX None  Edit Drop registered
last_updated INDEX None  Edit Drop last_updated
public INDEX None  Edit Drop public
archived INDEX None  Edit Drop archived
mature INDEX None  Edit Drop mature
spam INDEX None  Edit Drop spam
deleted INDEX None  Edit Drop deleted
lang_id_2 INDEX None  Edit Drop lang_id
archived_2 INDEX None  Edit Drop archived
registered_3 INDEX None  Edit Drop registered
public_2 INDEX None  Edit Drop public
deleted_2 INDEX None  Edit Drop deleted
last_updated_4 INDEX None  Edit Drop last_updated
blog_id_3 INDEX None  Edit Drop blog_id
lang_id_3 INDEX None  Edit Drop lang_id
site_id_2 INDEX None  Edit Drop site_id
mature_2 INDEX None  Edit Drop mature
domain_5 INDEX None  Edit Drop domain
path_6 INDEX None  Edit Drop path
spam_2 INDEX None  Edit Drop spam
spam_3 INDEX None  Edit Drop spam
public_3 INDEX None  Edit Drop public
path_7 INDEX None  Edit Drop path
archived_3 INDEX None  Edit Drop archived
deleted_3 INDEX None  Edit Drop deleted
lang_id_4 INDEX None  Edit Drop lang_id
site_id_3 INDEX None  Edit Drop site_id
mature_3 INDEX None  Edit Drop mature
domain_6 INDEX None  Edit Drop domain
last_updated_6 INDEX None  Edit Drop last_updated
registered_5 INDEX None  Edit Drop registered
blog_id_6 INDEX None  Edit Drop blog_id
registered_8 INDEX None  Edit Drop registered
last_updated_8 INDEX None  Edit Drop last_updated
archived_4 INDEX None  Edit Drop archived
blog_id_7 INDEX None  Edit Drop blog_id
domain_3 FULLTEXT None  Edit Drop domain
path_3 FULLTEXT None  Edit Drop path
path_4 FULLTEXT None  Edit Drop path
domain_4 FULLTEXT None  Edit Drop domain
path_9 FULLTEXT None  Edit Drop path
domain_7 FULLTEXT None  Edit Drop domain
path_10 FULLTEXT None  Edit Drop path
Create an index on  columns  
 
Space usage: 
Type Usage
Data 576 Bytes
Index 4,096 Bytes
Total 4,672 Bytes
 
Row Statistic: 
Statements Value
Format dynamic
Collation utf8_general_ci
Rows 8
Row length ø 72
Row size  ø 584 Bytes
Next Autoindex 10
Creation Dec 14, 2017 at 08:20 AM
Last update Dec 14, 2017 at 08:20 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: