Host: mysql.puroparty.com
Database: puroparty
Generation Time: Mar 29, 2024 at 02:59 AM
Generated by: phpMyAdmin 2.6.0-pl3 / MySQL 4.1.22-standard
SQL-query: SELECT * FROM `bak_components` PROCEDURE ANALYSE();
Rows: 13
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 |