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

   Field  Type Collation Attributes Null Default Extra Action
   smallint(10)   UNSIGNED No    auto_increment  Change Drop Primary Index Unique Fulltext
   varchar(255) latin1_swedish_ci   Yes  NULL    Change Drop Primary Index Unique Fulltext
   varchar(255) latin1_swedish_ci   Yes  NULL    Change Drop Primary Index Unique Fulltext
   varchar(255) latin1_swedish_ci   Yes  NULL    Change Drop Primary Index Unique Fulltext
   text latin1_swedish_ci   Yes  NULL    Change Drop Primary Index Unique Fulltext
   text latin1_swedish_ci   Yes  NULL    Change Drop Primary Index Unique Fulltext
   smallint(10)     No    Change Drop Primary Index Unique Fulltext
   varchar(255) latin1_swedish_ci   Yes  NULL    Change Drop Primary Index Unique Fulltext
   smallint(1)     No    Change Drop Primary Index Unique Fulltext
   smallint(1)     No    Change Drop Primary Index Unique Fulltext
   int(10)     No    Change Drop Primary Index Unique Fulltext
   int(10)     No    Change Drop Primary Index Unique Fulltext
   smallint(1)     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
category_2 UNIQUE Edit Drop category
confirmed_2 UNIQUE Edit Drop confirmed
approved_2 UNIQUE Edit Drop approved
nextcheck_2 UNIQUE Edit Drop nextcheck
id_3 UNIQUE Edit Drop id
approved_3 UNIQUE Edit Drop approved
nextcheck_3 UNIQUE Edit Drop nextcheck
confirmed_4 UNIQUE Edit Drop confirmed
category_4 UNIQUE Edit Drop category
id_6 UNIQUE Edit Drop id
name_2 UNIQUE None  Edit Drop name
email_2 UNIQUE None  Edit Drop email
url_2 UNIQUE None  Edit Drop url
reciprocal_2 UNIQUE None  Edit Drop reciprocal
reciprocal_4 UNIQUE None  Edit Drop reciprocal
email_5 UNIQUE None  Edit Drop email
name_5 UNIQUE None  Edit Drop name
url_4 UNIQUE None  Edit Drop url
name_8 UNIQUE None  Edit Drop name
email_8 UNIQUE None  Edit Drop email
url_8 UNIQUE None  Edit Drop url
id INDEX None  Edit Drop id
name INDEX None  Edit Drop name
email INDEX None  Edit Drop email
url INDEX None  Edit Drop url
category INDEX None  Edit Drop category
reciprocal INDEX None  Edit Drop reciprocal
confirmed INDEX None  Edit Drop confirmed
approved INDEX None  Edit Drop approved
added INDEX None  Edit Drop added
nextcheck INDEX None  Edit Drop nextcheck
nocheck INDEX None  Edit Drop nocheck
category_3 INDEX None  Edit Drop category
name_4 INDEX None  Edit Drop name
nocheck_2 INDEX None  Edit Drop nocheck
id_4 INDEX None  Edit Drop id
email_6 INDEX None  Edit Drop email
confirmed_3 INDEX None  Edit Drop confirmed
approved_4 INDEX None  Edit Drop approved
added_2 INDEX None  Edit Drop added
reciprocal_6 INDEX None  Edit Drop reciprocal
nextcheck_4 INDEX None  Edit Drop nextcheck
url_6 INDEX None  Edit Drop url
nocheck_3 INDEX None  Edit Drop nocheck
id_5 INDEX None  Edit Drop id
name_7 INDEX None  Edit Drop name
email_7 INDEX None  Edit Drop email
url_7 INDEX None  Edit Drop url
name_3 FULLTEXT None  Edit Drop name
email_3 FULLTEXT None  Edit Drop email
url_3 FULLTEXT None  Edit Drop url
title FULLTEXT None  Edit Drop title
description FULLTEXT None  Edit Drop description
reciprocal_3 FULLTEXT None  Edit Drop reciprocal
description_2 FULLTEXT None  Edit Drop description
email_4 FULLTEXT None  Edit Drop email
name_6 FULLTEXT None  Edit Drop name
reciprocal_5 FULLTEXT None  Edit Drop reciprocal
title_2 FULLTEXT None  Edit Drop title
url_5 FULLTEXT None  Edit Drop url
name_9 FULLTEXT None  Edit Drop name
email_9 FULLTEXT None  Edit Drop email
Create an index on  columns  
 
Space usage: 
Type Usage
Data 444 Bytes
Index 4,096 Bytes
Total 4,540 Bytes
 
Row Statistic: 
Statements Value
Format dynamic
Collation latin1_swedish_ci
Rows 2
Row length ø 222
Row size  ø 2,270 Bytes
Next Autoindex 3
Creation Nov 12, 2017 at 10:12 AM
Last update Mar 31, 2018 at 04:29 AM
Last check Mar 31, 2018 at 04:29 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: