SQL result

Host: mysql.puroparty.com
Database: puroparty
Generation Time: Apr 26, 2024 at 06:34 PM
Generated by: phpMyAdmin 2.6.0-pl3 / MySQL 4.1.22-standard
SQL-query: SELECT * FROM `bak_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.bak_menu.id 1 1 1 1 0 0 1.0000 0.0000 ENUM('1') NOT NULL
puroparty.bak_menu.menutype mainmenu mainmenu 8 8 0 0 8.0000 NULL ENUM('mainmenu') NOT NULL
puroparty.bak_menu.name Home Home 4 4 0 0 4.0000 NULL ENUM('Home') NOT NULL
puroparty.bak_menu.alias home home 4 4 0 0 4.0000 NULL ENUM('home') NOT NULL
puroparty.bak_menu.link index.php?option=com_content&view=frontpage index.php?option=com_content&view=frontpage 43 43 0 0 43.0000 NULL ENUM('index.php?option=com_content&view=frontpage') NOT NULL
puroparty.bak_menu.type component component 9 9 0 0 9.0000 NULL ENUM('component') NOT NULL
puroparty.bak_menu.published 1 1 1 1 0 0 1.0000 0.0000 ENUM('1') NOT NULL
puroparty.bak_menu.parent 0 0 1 1 1 0 0.0000 0.0000 ENUM('0') NOT NULL
puroparty.bak_menu.componentid 20 20 2 2 0 0 20.0000 0.0000 ENUM('20') NOT NULL
puroparty.bak_menu.sublevel 0 0 1 1 1 0 0.0000 0.0000 ENUM('0') NOT NULL
puroparty.bak_menu.ordering 1 1 1 1 0 0 1.0000 0.0000 ENUM('1') NOT NULL
puroparty.bak_menu.checked_out 0 0 1 1 1 0 0.0000 0.0000 ENUM('0') NOT NULL
puroparty.bak_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.bak_menu.pollid 0 0 1 1 1 0 0.0000 0.0000 ENUM('0') NOT NULL
puroparty.bak_menu.browserNav 0 0 1 1 1 0 0.0000 0.0000 ENUM('0') NOT NULL
puroparty.bak_menu.access 0 0 1 1 1 0 0.0000 0.0000 ENUM('0') NOT NULL
puroparty.bak_menu.utaccess 3 3 1 1 0 0 3.0000 0.0000 ENUM('3') NOT NULL
puroparty.bak_menu.params num_leading_articles=1\nnum_intro_articles=4\nnum_columns=2\nnum_links=4\norderby_pri=\norderby_sec=front\nshow_pagination=2\nshow_pagination_results=1\nshow_feed_link=1\nshow_noauth=\nshow_title=\nlink_titles=\nshow_intro=\nshow_section=\nlink_section=\nshow_category=\nlink_category=\nshow_author=\nshow_create_date=\nshow_modify_date=\nshow_item_navigation=\nshow_readmore=\nshow_vote=\nshow_icons=\nshow_pdf_icon=\nshow_print_icon=\nshow_email_icon=\nshow_hits=\nfeed_summary=\npage_title=\nshow_page_title=1\npageclass_sfx=\nmenu_image=-1\nsecure=0\n\n num_leading_articles=1\nnum_intro_articles=4\nnum_columns=2\nnum_links=4\norderby_pri=\norderby_sec=front\nshow_pagination=2\nshow_pagination_results=1\nshow_feed_link=1\nshow_noauth=\nshow_title=\nlink_titles=\nshow_intro=\nshow_section=\nlink_section=\nshow_category=\nlink_category=\nshow_author=\nshow_create_date=\nshow_modify_date=\nshow_item_navigation=\nshow_readmore=\nshow_vote=\nshow_icons=\nshow_pdf_icon=\nshow_print_icon=\nshow_email_icon=\nshow_hits=\nfeed_summary=\npage_title=\nshow_page_title=1\npageclass_sfx=\nmenu_image=-1\nsecure=0\n\n 522 522 0 0 522.0000 NULL ENUM('num_leading_articles=1\nnum_intro_articles=4\nnum_columns=2\nnum_links=4\norderby_pri=\norderby_sec=front\nshow_pagination=2\nshow_pagination_results=1\nshow_feed_link=1\nshow_noauth=\nshow_title=\nlink_titles=\nshow_intro=\nshow_section=\nlink_section=\nshow_category=\nlink_category=\nshow_author=\nshow_create_date=\nshow_modify_date=\nshow_item_navigation=\nshow_readmore=\nshow_vote=\nshow_icons=\nshow_pdf_icon=\nshow_print_icon=\nshow_email_icon=\nshow_hits=\nfeed_summary=\npage_title=\nshow_page_title=1\npageclass_sfx=\nmenu_image=-1\nsecure=0\n\n') NOT NULL
puroparty.bak_menu.lft 0 0 1 1 1 0 0.0000 0.0000 ENUM('0') NOT NULL
puroparty.bak_menu.rgt 0 0 1 1 1 0 0.0000 0.0000 ENUM('0') NOT NULL
puroparty.bak_menu.home 1 1 1 1 0 0 1.0000 0.0000 ENUM('1') NOT NULL