Host: mysql.puroparty.com
Database: puroparty
Generation Time: May 01, 2024 at 05:25 PM
Generated by: phpMyAdmin 2.6.0-pl3 / MySQL 4.1.22-standard
SQL-query: SELECT * FROM `jos_menu` PROCEDURE ANALYSE();
Rows: 21
| Field_name | Min_value | Max_value | Min_length | Max_length | Empties_or_zeros | Nulls | Avg_value_or_avg_length | Std | Optimal_fieldtype |
|---|---|---|---|---|---|---|---|---|---|
| puroparty.jos_menu.id | 1 | 52 | 1 | 2 | 0 | 0 | 31.3448 | 15.3315 | ENUM('1','2','11','12','13','14','15','18','20','2... |
| puroparty.jos_menu.menutype | ExamplePages | usermenu | 7 | 12 | 0 | 0 | 8.8966 | NULL | ENUM('ExamplePages','keyconcepts','mainmenu','othe... |
| puroparty.jos_menu.name | About Joomla! | Your Details | 3 | 18 | 0 | 0 | 11.7241 | NULL | ENUM('About Joomla!','Administrator','Category Blo... |
| puroparty.jos_menu.alias | about-joomla | your-details | 3 | 18 | 0 | 0 | 11.4483 | NULL | ENUM('about-joomla','administrator','category-tabl... |
| puroparty.jos_menu.link | administrator/ | index.php?option=com_weblinks&view=weblink&layout=... | 14 | 60 | 0 | 0 | 44.0345 | NULL | ENUM('administrator/','http://forum.joomla.org','h... |
| puroparty.jos_menu.type | component | url | 3 | 9 | 0 | 0 | 7.9655 | NULL | ENUM('component','url') NOT NULL |
| puroparty.jos_menu.published | 1 | 1 | 1 | 1 | 0 | 0 | 1.0000 | 0.0000 | ENUM('1') NOT NULL |
| puroparty.jos_menu.parent | 0 | 27 | 1 | 2 | 28 | 0 | 0.9310 | 4.9266 | ENUM('0','27') NOT NULL |
| puroparty.jos_menu.componentid | 4 | 20 | 1 | 2 | 5 | 0 | 14.4138 | 7.9677 | ENUM('0','4','11','14','20') NOT NULL |
| puroparty.jos_menu.sublevel | 0 | 1 | 1 | 1 | 28 | 0 | 0.0345 | 0.1825 | ENUM('0','1') NOT NULL |
| puroparty.jos_menu.ordering | 1 | 9 | 1 | 1 | 0 | 0 | 3.2414 | 2.1279 | ENUM('1','2','3','4','5','6','7','8','9') NOT NULL |
| puroparty.jos_menu.checked_out | 0 | 0 | 1 | 1 | 29 | 0 | 0.0000 | 0.0000 | ENUM('0') NOT NULL |
| puroparty.jos_menu.checked_out_time | 0000-00-00 00:00:00 | 0000-00-00 00:00:00 | 19 | 19 | 0 | 0 | 19.0000 | NULL | ENUM('0000-00-00 00:00:00') NOT NULL |
| puroparty.jos_menu.pollid | 0 | 0 | 1 | 1 | 29 | 0 | 0.0000 | 0.0000 | ENUM('0') NOT NULL |
| puroparty.jos_menu.browserNav | 0 | 0 | 1 | 1 | 29 | 0 | 0.0000 | 0.0000 | ENUM('0') NOT NULL |
| puroparty.jos_menu.access | 0 | 2 | 1 | 1 | 25 | 0 | 0.2069 | 0.5496 | ENUM('0','1','2') NOT NULL |
| puroparty.jos_menu.utaccess | 3 | 4 | 1 | 1 | 20 | 0 | 0.9655 | 1.4499 | ENUM('0','3','4') NOT NULL |
| puroparty.jos_menu.params | menu_image=-1\n\n | show_page_title=1\nshow_description=0\nshow_descript... | 15 | 604 | 4 | 0 | 285.4483 | NULL | ENUM('','menu_image=-1\n\n','pageclass_sfx=\nmenu_ima... |
| puroparty.jos_menu.lft | 0 | 0 | 1 | 1 | 29 | 0 | 0.0000 | 0.0000 | ENUM('0') NOT NULL |
| puroparty.jos_menu.rgt | 0 | 0 | 1 | 1 | 29 | 0 | 0.0000 | 0.0000 | ENUM('0') NOT NULL |
| puroparty.jos_menu.home | 1 | 1 | 1 | 1 | 28 | 0 | 0.0345 | 0.1825 | ENUM('0','1') NOT NULL |