SQL result

Host: mysql.puroparty.com
Database: puroparty
Generation Time: Apr 26, 2024 at 05:18 AM
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','24','27','28','29','30','34','37','38','40','41','43','44','45','46','47','48','49','50','51','52') NOT NULL
puroparty.jos_menu.menutype ExamplePages usermenu 7 12 0 0 8.8966 NULL ENUM('ExamplePages','keyconcepts','mainmenu','othermenu','topmenu','usermenu') NOT NULL
puroparty.jos_menu.name About Joomla! Your Details 3 18 0 0 11.7241 NULL ENUM('About Joomla!','Administrator','Category Blog','Category Table','Content Layouts','Example Pages','Extensions','FAQ','Features','Home','Joomla! Forums','Joomla! Help','Joomla! Home','Joomla! License','Joomla! Overview','Logout','More about Joomla!','News','News Feeds','OSM Home','Section Blog','Section Table','Submit a Web Link','Submit an Article','The Community','The News','Web Links','What\'s New in 1.5?','Your Details') NOT NULL
puroparty.jos_menu.alias about-joomla your-details 3 18 0 0 11.4483 NULL ENUM('about-joomla','administrator','category-table','categoryblog','content-layouts','example-pages','extensions','faq','features','home','joomla-forums','joomla-help','joomla-home','joomla-license','joomla-overview','logout','more-about-joomla','news','news-feeds','osm-home','section-blog','section-table','submit-a-web-link','submit-an-article','the-community','the-news','web-links','what-is-new-in-1-5','your-details') NOT NULL
puroparty.jos_menu.link administrator/ index.php?option=com_weblinks&view=weblink&layout=form 14 60 0 0 44.0345 NULL ENUM('administrator/','http://forum.joomla.org','http://help.joomla.org','http://www.joomla.org','http://www.opensourcematters.org','index.php?option=com_content&view=article&id=19','index.php?option=com_content&view=article&id=22','index.php?option=com_content&view=article&id=24','index.php?option=com_content&view=article&id=25','index.php?option=com_content&view=article&id=26','index.php?option=com_content&view=article&id=27','index.php?option=com_content&view=article&id=43','index.php?option=com_content&view=article&id=5','index.php?option=com_content&view=article&layout=form','index.php?option=com_content&view=category&id=32','index.php?option=com_content&view=category&layout=blog&id=1','index.php?option=com_content&view=category&layout=blog&id=31','index.php?option=com_content&view=frontpage','index.php?option=com_content&view=section&id=3','index.php?option=com_content&view=section&id=4','index.php?option=com_content&view=section&layout=blog&id=3','index.php?option=com_newsfeeds&view=categories','index.php?option=com_newsfeeds&view=newsfeed&id=1&feedid=1','index.php?option=com_user&view=login','index.php?option=com_user&view=user&task=edit','index.php?option=com_weblinks&view=categories','index.php?option=com_weblinks&view=weblink&layout=form') NOT NULL
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_description_image=0\nshow_categories=1\nshow_empty_categories=0\nshow_cat_num_articles=1\nshow_category_description=1\npageclass_sfx=\nmenu_image=-1\nsecure=0\norderby=\nshow_noauth=0\nshow_title=1\nlink_titles=0\nshow_intro=1\nshow_section=0\nlink_section=0\nshow_category=0\nlink_category=0\nshow_author=1\nshow_create_date=1\nshow_modify_date=1\nshow_item_navigation=0\nshow_readmore=1\nshow_vote=0\nshow_icons=1\nshow_pdf_icon=1\nshow_print_icon=1\nshow_email_icon=1\nshow_hits=1 15 604 4 0 285.4483 NULL ENUM('','menu_image=-1\n\n','pageclass_sfx=\nmenu_image=-1\nsecure=0\nshow_noauth=0\nlink_titles=0\nshow_intro=1\nshow_section=0\nlink_section=0\nshow_category=0\nlink_category=0\nshow_author=1\nshow_create_date=1\nshow_modify_date=1\nshow_item_navigation=0\nshow_readmore=1\nshow_vote=0\nshow_icons=1\nshow_pdf_icon=1\nshow_print_icon=1\nshow_email_icon=1\nshow_hits=1\n\n','pageclass_sfx=\nmenu_image=-1\nsecure=0\nshow_noauth=0\nshow_title=1\nlink_titles=0\nshow_intro=1\nshow_section=0\nlink_section=0\nshow_category=0\nlink_category=0\nshow_author=1\nshow_create_date=1\nshow_modify_date=1\nshow_item_navigation=0\nshow_readmore=1\nshow_vote=0\nshow_icons=1\nshow_pdf_icon=1\nshow_print_icon=1\nshow_email_icon=1\nshow_hits=1\n\n','page_title=Weblinks\nimage=-1\nimage_align=right\npageclass_sfx=\nmenu_image=-1\nsecure=0\nshow_comp_description=1\ncomp_description=\nshow_link_hits=1\nshow_link_description=1\nshow_other_cats=1\nshow_headings=1\nshow_page_title=1\nlink_target=0\nlink_icons=\n\n','show_page_title=1\npage_title=Example of Category Blog layout (FAQs/General category)\nshow_description=0\nshow_description_image=0\nnum_leading_articles=1\nnum_intro_articles=4\nnum_columns=2\nnum_links=4\nshow_title=1\npageclass_sfx=\nmenu_image=-1\nsecure=0\norderby_pri=\norderby_sec=\nshow_pagination=2\nshow_pagination_results=1\nshow_noauth=0\nlink_titles=0\nshow_intro=1\nshow_section=0\nlink_section=0\nshow_category=0\nlink_category=0\nshow_author=1\nshow_create_date=1\nshow_modify_date=1\nshow_item_navigation=0\nshow_readmore=1\nshow_vote=0\nshow_icons=1\nshow_pdf_icon=1\nshow_print_icon=1\nshow_email_icon=1\nshow_hits=1\n\n','show_page_title=1\npage_title=Example of Category Table layout (FAQs/Languages category)\nshow_headings=1\nshow_date=0\ndate_format=\nfilter=1\nfilter_type=title\npageclass_sfx=\nmenu_image=-1\nsecure=0\norderby_sec=\nshow_pagination=1\nshow_pagination_limit=1\nshow_noauth=0\nshow_title=1\nlink_titles=0\nshow_intro=1\nshow_section=0\nlink_section=0\nshow_category=0\nlink_category=0\nshow_author=1\nshow_create_date=1\nshow_modify_date=1\nshow_item_navigation=0\nshow_readmore=1\nshow_vote=0\nshow_icons=1\nshow_pdf_icon=1\nshow_print_icon=1\nshow_email_icon=1\nshow_hits=1\n\n','show_page_title=1\npage_title=Example of Section Blog layout (FAQ section)\nshow_description=0\nshow_description_image=0\nnum_leading_articles=1\nnum_intro_articles=4\nnum_columns=2\nnum_links=4\nshow_title=1\npageclass_sfx=\nmenu_image=-1\nsecure=0\norderby_pri=\norderby_sec=\nshow_pagination=2\nshow_pagination_results=1\nshow_noauth=0\nlink_titles=0\nshow_intro=1\nshow_section=0\nlink_section=0\nshow_category=0\nlink_category=0\nshow_author=1\nshow_create_date=1\nshow_modify_date=1\nshow_item_navigation=0\nshow_readmore=1\nshow_vote=0\nshow_icons=1\nshow_pdf_icon=1\nshow_print_icon=1\nshow_email_icon=1\nshow_hits=1\n\n','show_page_title=1\npage_title=Example of Table Blog layout (FAQ section)\nshow_description=0\nshow_description_image=0\nshow_categories=1\nshow_empty_categories=0\nshow_cat_num_articles=1\nshow_category_description=1\npageclass_sfx=\nmenu_image=-1\nsecure=0\norderby=\nshow_noauth=0\nshow_title=1\nnlink_titles=0\nshow_intro=1\nshow_section=0\nlink_section=0\nshow_category=0\nlink_category=0\nshow_author=1\nshow_create_date=1\nshow_modify_date=1\nshow_item_navigation=0\nshow_readmore=1\nshow_vote=0\nshow_icons=1\nshow_pdf_icon=1\nshow_print_icon=1\nshow_email_icon=1\nshow_hits=1\n\n','show_page_title=1\npage_title=News\npageclass_sfx=\nmenu_image=-1\nsecure=0\nshow_headings=1\nshow_name=1\nshow_articles=1\nshow_link=1\nshow_other_cats=1\nshow_cat_description=1\nshow_cat_items=1\nshow_feed_image=1\nshow_feed_description=1\nshow_item_description=1\nfeed_word_count=0\n\n','show_page_title=1\npage_title=Newsfeeds\nshow_comp_description=1\ncomp_description=\nimage=-1\nimage_align=right\npageclass_sfx=\nmenu_image=-1\nsecure=0\nshow_headings=1\nshow_name=1\nshow_articles=1\nshow_link=1\nshow_other_cats=1\nshow_cat_description=1\nshow_cat_items=1\nshow_feed_image=1\nshow_feed_description=1\nshow_item_description=1\nfeed_word_count=0\n\n','show_page_title=1\npage_title=The News\nshow_description=0\nshow_description_image=0\nnum_leading_articles=1\nnum_intro_articles=4\nnum_columns=2\nnum_links=4\nshow_title=1\npageclass_sfx=\nmenu_image=-1\nsecure=0\norderby_pri=\norderby_sec=\nshow_pagination=2\nshow_pagination_results=1\nshow_noauth=0\nlink_titles=0\nshow_intro=1\nshow_section=0\nlink_section=0\nshow_category=0\nlink_category=0\nshow_author=1\nshow_create_date=1\nshow_modify_date=1\nshow_item_navigation=0\nshow_readmore=1\nshow_vote=0\nshow_icons=1\nshow_pdf_icon=1\nshow_print_icon=1\nshow_email_icon=1\nshow_hits=1\n\n','show_page_title=1\npage_title=Welcome to the Frontpage\nshow_description=0\nshow_description_image=0\nnum_leading_articles=1\nnum_intro_articles=4\nnum_columns=2\nnum_links=4\nshow_title=1\npageclass_sfx=\nmenu_image=-1\nsecure=0\norderby_pri=\norderby_sec=front\nshow_pagination=2\nshow_pagination_results=1\nshow_noauth=0\nlink_titles=0\nshow_intro=1\nshow_section=0\nlink_section=0\nshow_category=0\nlink_category=0\nshow_author=1\nshow_create_date=1\nshow_modify_date=1\nshow_item_navigation=0\nshow_readmore=1\nshow_vote=0\nshow_icons=1\nshow_pdf_icon=1\nshow_print_icon=1\nshow_email_icon=1\nshow_hits=1\n\n','show_page_title=1\nshow_description=0\nshow_description_image=0\nshow_categories=1\nshow_empty_categories=0\nshow_cat_num_articles=1\nshow_category_description=1\npageclass_sfx=\nmenu_image=-1\nsecure=0\norderby=\nshow_noauth=0\nshow_title=1\nlink_titles=0\nshow_intro=1\nshow_section=0\nlink_section=0\nshow_category=0\nlink_category=0\nshow_author=1\nshow_create_date=1\nshow_modify_date=1\nshow_item_navigation=0\nshow_readmore=1\nshow_vote=0\nshow_icons=1\nshow_pdf_icon=1\nshow_print_icon=1\nshow_email_icon=1\nshow_hits=1') NOT NULL
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