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

jos_components

Field Type Null Default
id  int(11) No   
name  varchar(50) No   
link  varchar(255) No   
menuid  int(11) No 
parent  int(11) No 
admin_menu_link  varchar(255) No   
admin_menu_alt  varchar(255) No   
option  varchar(50) No   
ordering  int(11) No 
admin_menu_img  varchar(255) No   
iscore  tinyint(4) No 
params  text No   
enabled  tinyint(4) No 


 Indexes :
Keyname Type Cardinality Field
PRIMARY PRIMARY 32 id
id_2 UNIQUE 32 id
id_4 UNIQUE 32 id
id_6 UNIQUE 32 id
parent_option INDEX None parent
option 32
id INDEX None id
name INDEX None name
link INDEX None link
menuid INDEX None menuid
parent INDEX None parent
admin_menu_link INDEX None admin_menu_link
admin_menu_alt INDEX None admin_menu_alt
option INDEX None option
ordering INDEX None ordering
admin_menu_img INDEX None admin_menu_img
iscore INDEX None iscore
enabled INDEX None enabled
iscore_2 INDEX None iscore
name_3 INDEX None name
admin_menu_link_3 INDEX None admin_menu_link
ordering_2 INDEX None ordering
enabled_2 INDEX None enabled
id_3 INDEX None id
parent_2 INDEX None parent
admin_menu_alt_4 INDEX None admin_menu_alt
link_4 INDEX None link
menuid_2 INDEX None menuid
option_4 INDEX None option
admin_menu_img_3 INDEX None admin_menu_img
menuid_3 INDEX None menuid
iscore_3 INDEX None iscore
link_6 INDEX None link
admin_menu_alt_5 INDEX None admin_menu_alt
parent_3 INDEX None parent
id_5 INDEX None id
admin_menu_link_6 INDEX None admin_menu_link
ordering_3 INDEX None ordering
name_6 INDEX None name
enabled_3 INDEX None enabled
option_6 INDEX None option
admin_menu_img_5 INDEX None admin_menu_img
name_2 INDEX None name
link_2 INDEX None link
admin_menu_link_2 INDEX None admin_menu_link
admin_menu_alt_2 INDEX None admin_menu_alt
option_2 INDEX None option
admin_menu_img_2 INDEX None admin_menu_img
params INDEX None params
option_3 INDEX None option
name_4 INDEX None name
params_2 INDEX None params
admin_menu_link_4 INDEX None admin_menu_link
admin_menu_alt_3 INDEX None admin_menu_alt
link_3 INDEX None link
admin_menu_img_4 INDEX None admin_menu_img
link_5 INDEX None link
option_5 INDEX None option
params_3 INDEX None params
admin_menu_alt_6 INDEX None admin_menu_alt
admin_menu_link_5 INDEX None admin_menu_link
name_5 INDEX None name
admin_menu_img_6 INDEX None admin_menu_img
admin_menu_alt_7 INDEX None admin_menu_alt
params_4 INDEX None params


 Space usage :
Type Usage
Data 4,364 Bytes
Index 4,096 Bytes
Total 8,460 Bytes
   Row Statistic :
Statements Value
Format dynamic
Rows 32
Row length ø 136
Row size  ø 264 Bytes
Next Autoindex 34
Creation Feb 19, 2018 at 08:22 PM
Last update May 26, 2018 at 01:00 AM
Last check Jun 21, 2018 at 04:55 PM