Server: mysql.puroparty.commysql.puroparty.com
Database: puropartypuroparty
Table: bak_componentsbak_components
StructureStructure BrowseBrowse SQLSQL SearchSearch InsertInsert ExportExport OperationsOperations EmptyEmpty DropDrop

SQL-query
SQL-query: 
SELECT *
FROM `bak_components`
PROCEDURE ANALYSE ( )
 [Edit] [Explain SQL] [Create PHP Code] [Refresh]



Field_name Min_value Max_value Min_length Max_length Empties_or_zeros Nulls Avg_value_or_avg_length Std Optimal_fieldtype
puroparty.bak_components.id 1 33 1 2 0 0 16.7188 9.5336 ENUM('1','2','3','4','5','6','7','8','9','10','11'...
puroparty.bak_components.name Articles Wrapper 4 21 0 0 10.1562 NULL ENUM('Articles','Banners','Cache Manager','Categor...
puroparty.bak_components.link   option=com_wrapper 0 20 24 0 4.3750 NULL ENUM('','option=com_contact','option=com_content',...
puroparty.bak_components.menuid 0 0 1 1 32 0 0.0000 0.0000 ENUM('0') NOT NULL
puroparty.bak_components.parent 0 11 1 2 23 0 1.4688 3.0922 ENUM('0','1','4','7','11') NOT NULL
puroparty.bak_components.admin_menu_link   option=com_weblinks 0 49 20 0 10.1250 NULL ENUM('','option=com_banners','option=com_banners&c...
puroparty.bak_components.admin_menu_alt Active Banners Wrapper 5 25 3 0 12.2188 NULL ENUM('','Active Banners','Banner Management','Cach...
puroparty.bak_components.option com_banners com_wrapper 8 13 4 0 9.5000 NULL ENUM('','com_banners','com_cache','com_config','co...
puroparty.bak_components.ordering 0 3 1 1 24 0 0.4375 0.8268 ENUM('0','1','2','3') NOT NULL
puroparty.bak_components.admin_menu_img js/ThemeOffice/categories.png js/ThemeOffice/edit.png 23 29 18 0 11.7500 NULL ENUM('','js/ThemeOffice/categories.png','js/ThemeO...
puroparty.bak_components.iscore 0 1 1 1 10 0 0.6875 0.4635 ENUM('0','1') NOT NULL
puroparty.bak_components.params allowUserRegistration=1\nnew_usertype=Registered\nus... upload_extensions=bmp,csv,doc,epg,gif,ico,jpg,odg,... 11 530 22 0 57.1875 NULL ENUM('','allowUserRegistration=1\nnew_usertype=Regi...
puroparty.bak_components.enabled 1 1 1 1 0 0 1.0000 0.0000 ENUM('1') NOT NULL


Print viewPrint view    Print view (with full texts)Print view (with full texts)     ExportExport