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

   Field  Type Collation Attributes Null Default Extra Action
   int(11)     No    auto_increment  Change Drop Primary Index Unique Fulltext
   varchar(50) utf8_general_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(255) utf8_general_ci   No      Change Drop Primary Index Unique Fulltext
   int(11)   UNSIGNED No    Change Drop Primary Index Unique Fulltext
   int(11)   UNSIGNED 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(50) utf8_general_ci   No      Change Drop Primary Index Unique Fulltext
   int(11)     No    Change Drop Primary Index Unique Fulltext
   varchar(255) utf8_general_ci   No      Change Drop Primary Index Unique Fulltext
   tinyint(4)     No    Change Drop Primary Index Unique Fulltext
   text utf8_general_ci   No      Change Drop Primary Index Unique Fulltext
   tinyint(4)     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 32  Edit Drop id
id_2 UNIQUE 32  Edit Drop id
id_3 UNIQUE 32  Edit Drop id
id_5 UNIQUE 32  Edit Drop id
id_8 UNIQUE 32  Edit Drop id
parent_option INDEX None  Edit Drop parent
option 32
id INDEX None  Edit Drop id
name INDEX None  Edit Drop name
link INDEX None  Edit Drop link
menuid INDEX None  Edit Drop menuid
parent INDEX None  Edit Drop parent
admin_menu_link INDEX None  Edit Drop admin_menu_link
admin_menu_alt INDEX None  Edit Drop admin_menu_alt
option INDEX None  Edit Drop option
ordering INDEX None  Edit Drop ordering
admin_menu_img INDEX None  Edit Drop admin_menu_img
iscore INDEX None  Edit Drop iscore
enabled INDEX None  Edit Drop enabled
admin_menu_alt_3 INDEX None  Edit Drop admin_menu_alt
menuid_2 INDEX None  Edit Drop menuid
admin_menu_img_4 INDEX None  Edit Drop admin_menu_img
ordering_2 INDEX None  Edit Drop ordering
id_4 INDEX None  Edit Drop id
iscore_2 INDEX None  Edit Drop iscore
link_3 INDEX None  Edit Drop link
parent_2 INDEX None  Edit Drop parent
option_4 INDEX None  Edit Drop option
enabled_2 INDEX None  Edit Drop enabled
name_4 INDEX None  Edit Drop name
admin_menu_link_4 INDEX None  Edit Drop admin_menu_link
option_5 INDEX None  Edit Drop option
menuid_3 INDEX None  Edit Drop menuid
admin_menu_img_5 INDEX None  Edit Drop admin_menu_img
id_6 INDEX None  Edit Drop id
admin_menu_link_6 INDEX None  Edit Drop admin_menu_link
parent_3 INDEX None  Edit Drop parent
ordering_3 INDEX None  Edit Drop ordering
admin_menu_alt_6 INDEX None  Edit Drop admin_menu_alt
enabled_3 INDEX None  Edit Drop enabled
iscore_3 INDEX None  Edit Drop iscore
name_6 INDEX None  Edit Drop name
link_6 INDEX None  Edit Drop link
id_7 INDEX None  Edit Drop id
name_2 FULLTEXT None  Edit Drop name
link_2 FULLTEXT None  Edit Drop link
admin_menu_link_2 FULLTEXT None  Edit Drop admin_menu_link
admin_menu_alt_2 FULLTEXT None  Edit Drop admin_menu_alt
option_2 FULLTEXT None  Edit Drop option
admin_menu_img_2 FULLTEXT None  Edit Drop admin_menu_img
params FULLTEXT None  Edit Drop params
admin_menu_img_3 FULLTEXT None  Edit Drop admin_menu_img
admin_menu_alt_4 FULLTEXT None  Edit Drop admin_menu_alt
option_3 FULLTEXT None  Edit Drop option
name_3 FULLTEXT None  Edit Drop name
link_4 FULLTEXT None  Edit Drop link
params_2 FULLTEXT None  Edit Drop params
admin_menu_link_3 FULLTEXT None  Edit Drop admin_menu_link
name_5 FULLTEXT None  Edit Drop name
link_5 FULLTEXT None  Edit Drop link
admin_menu_link_5 FULLTEXT None  Edit Drop admin_menu_link
params_3 FULLTEXT None  Edit Drop params
admin_menu_alt_5 FULLTEXT None  Edit Drop admin_menu_alt
option_6 FULLTEXT None  Edit Drop option
admin_menu_img_6 FULLTEXT None  Edit Drop admin_menu_img
Create an index on  columns  
 
Space usage: 
Type Usage
Data 4,364 Bytes
Index 4,096 Bytes
Total 8,460 Bytes
 
Row Statistic: 
Statements Value
Format dynamic
Collation utf8_general_ci
Rows 32
Row length ø 136
Row size  ø 264 Bytes
Next Autoindex 34
Creation Nov 21, 2017 at 10:57 PM
Last update Mar 31, 2018 at 10:38 PM
Last check Apr 09, 2018 at 02:54 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: