Server: mysql.puroparty.commysql.puroparty.com
Database: puropartypuroparty
Table: jos_componentsjos_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_4 UNIQUE 32  Edit Drop id
id_6 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
iscore_2 INDEX None  Edit Drop iscore
name_3 INDEX None  Edit Drop name
admin_menu_link_3 INDEX None  Edit Drop admin_menu_link
ordering_2 INDEX None  Edit Drop ordering
enabled_2 INDEX None  Edit Drop enabled
id_3 INDEX None  Edit Drop id
parent_2 INDEX None  Edit Drop parent
admin_menu_alt_4 INDEX None  Edit Drop admin_menu_alt
link_4 INDEX None  Edit Drop link
menuid_2 INDEX None  Edit Drop menuid
option_4 INDEX None  Edit Drop option
admin_menu_img_3 INDEX None  Edit Drop admin_menu_img
menuid_3 INDEX None  Edit Drop menuid
iscore_3 INDEX None  Edit Drop iscore
link_6 INDEX None  Edit Drop link
admin_menu_alt_5 INDEX None  Edit Drop admin_menu_alt
parent_3 INDEX None  Edit Drop parent
id_5 INDEX None  Edit Drop id
admin_menu_link_6 INDEX None  Edit Drop admin_menu_link
ordering_3 INDEX None  Edit Drop ordering
name_6 INDEX None  Edit Drop name
enabled_3 INDEX None  Edit Drop enabled
option_6 INDEX None  Edit Drop option
admin_menu_img_5 INDEX None  Edit Drop admin_menu_img
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
option_3 FULLTEXT None  Edit Drop option
name_4 FULLTEXT None  Edit Drop name
params_2 FULLTEXT None  Edit Drop params
admin_menu_link_4 FULLTEXT None  Edit Drop admin_menu_link
admin_menu_alt_3 FULLTEXT None  Edit Drop admin_menu_alt
link_3 FULLTEXT None  Edit Drop link
admin_menu_img_4 FULLTEXT None  Edit Drop admin_menu_img
link_5 FULLTEXT None  Edit Drop link
option_5 FULLTEXT None  Edit Drop option
params_3 FULLTEXT None  Edit Drop params
admin_menu_alt_6 FULLTEXT None  Edit Drop admin_menu_alt
admin_menu_link_5 FULLTEXT None  Edit Drop admin_menu_link
name_5 FULLTEXT None  Edit Drop name
admin_menu_img_6 FULLTEXT None  Edit Drop admin_menu_img
admin_menu_alt_7 FULLTEXT None  Edit Drop admin_menu_alt
params_4 FULLTEXT None  Edit Drop params
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 Feb 19, 2018 at 08:22 PM
Last update Mar 11, 2018 at 04:39 PM
Last check Apr 07, 2018 at 11:30 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: