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

SQL-query
SQL-query: 
SELECT *
FROM `jos_menu`
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.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


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