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

   Field  Type Collation Attributes Null Default Extra Action
   bigint(20)     No    auto_increment  Change Drop Primary Index Unique Fulltext
   varchar(255) utf8_general_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(255) utf8_general_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(255) utf8_general_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(25) 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
   varchar(20) utf8_general_ci   No    Change Drop Primary Index Unique Fulltext
   int(11)     No    Change Drop Primary Index Unique Fulltext
   int(11)     No    Change Drop Primary Index Unique Fulltext
   datetime     No  0000-00-00 00:00:00    Change Drop Primary Index Unique Fulltext
   varchar(255) utf8_general_ci   No      Change Drop Primary Index Unique Fulltext
   mediumtext utf8_general_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(255) utf8_general_ci   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 link_id
link_id_2 UNIQUE Edit Drop link_id
link_url_2 UNIQUE Edit Drop link_url
link_name_2 UNIQUE Edit Drop link_name
link_rss_2 UNIQUE Edit Drop link_rss
link_id_4 UNIQUE Edit Drop link_id
link_name_5 UNIQUE Edit Drop link_name
link_rss_4 UNIQUE Edit Drop link_rss
link_url_6 UNIQUE Edit Drop link_url
link_id_5 UNIQUE Edit Drop link_id
link_category_5 UNIQUE Edit Drop link_category
link_category INDEX None  Edit Drop link_category
link_visible INDEX None  Edit Drop link_visible
link_id INDEX None  Edit Drop link_id
link_url INDEX None  Edit Drop link_url
link_name INDEX None  Edit Drop link_name
link_image INDEX None  Edit Drop link_image
link_target INDEX None  Edit Drop link_target
link_category_2 INDEX None  Edit Drop link_category
link_description INDEX None  Edit Drop link_description
link_visible_2 INDEX None  Edit Drop link_visible
link_owner INDEX None  Edit Drop link_owner
link_rating INDEX None  Edit Drop link_rating
link_updated INDEX None  Edit Drop link_updated
link_rel INDEX None  Edit Drop link_rel
link_rss INDEX None  Edit Drop link_rss
link_description_3 INDEX None  Edit Drop link_description
link_target_3 INDEX None  Edit Drop link_target
link_rating_2 INDEX None  Edit Drop link_rating
link_id_3 INDEX None  Edit Drop link_id
link_rel_3 INDEX None  Edit Drop link_rel
link_owner_2 INDEX None  Edit Drop link_owner
link_category_3 INDEX None  Edit Drop link_category
link_image_4 INDEX None  Edit Drop link_image
link_updated_2 INDEX None  Edit Drop link_updated
link_url_4 INDEX None  Edit Drop link_url
link_rss_5 INDEX None  Edit Drop link_rss
link_name_6 INDEX None  Edit Drop link_name
link_visible_5 INDEX None  Edit Drop link_visible
link_target_5 INDEX None  Edit Drop link_target
link_category_4 INDEX None  Edit Drop link_category
link_description_5 INDEX None  Edit Drop link_description
link_rss_7 INDEX None  Edit Drop link_rss
link_owner_3 INDEX None  Edit Drop link_owner
link_url_3 FULLTEXT None  Edit Drop link_url
link_name_3 FULLTEXT None  Edit Drop link_name
link_image_2 FULLTEXT None  Edit Drop link_image
link_target_2 FULLTEXT None  Edit Drop link_target
link_description_2 FULLTEXT None  Edit Drop link_description
link_visible_3 FULLTEXT None  Edit Drop link_visible
link_rel_2 FULLTEXT None  Edit Drop link_rel
link_notes FULLTEXT None  Edit Drop link_notes
link_rss_3 FULLTEXT None  Edit Drop link_rss
link_target_4 FULLTEXT None  Edit Drop link_target
link_image_3 FULLTEXT None  Edit Drop link_image
link_name_4 FULLTEXT None  Edit Drop link_name
link_rel_4 FULLTEXT None  Edit Drop link_rel
link_notes_2 FULLTEXT None  Edit Drop link_notes
link_description_4 FULLTEXT None  Edit Drop link_description
link_url_5 FULLTEXT None  Edit Drop link_url
link_visible_4 FULLTEXT None  Edit Drop link_visible
link_rss_6 FULLTEXT None  Edit Drop link_rss
link_target_6 FULLTEXT None  Edit Drop link_target
link_image_5 FULLTEXT None  Edit Drop link_image
Create an index on  columns  
 
Space usage: 
Type Usage
Data 204 Bytes
Index 4,096 Bytes
Total 4,300 Bytes
 
Row Statistic: 
Statements Value
Format dynamic
Collation utf8_general_ci
Rows 2
Row length ø 102
Row size  ø 2,150 Bytes
Next Autoindex 3
Creation Dec 12, 2017 at 05:01 PM
Last update Dec 12, 2017 at 05:01 PM

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: