SQL result

Host: mysql.puroparty.com
Database: puroparty
Generation Time: Mar 28, 2024 at 04:15 PM
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','12','13','14','15','16','17','18','19','20','21','22','23','24','25','27','28','29','30','31','32','33') NOT NULL
puroparty.bak_components.name Articles Wrapper 4 21 0 0 10.1562 NULL ENUM('Articles','Banners','Cache Manager','Categories','Clients','Configuration Manager','Contacts','Control Panel','Feeds','Installation Manager','Language Manager','Links','Mail To','Mass mail','Media Manager','Menu Editor','Messaging','Modules Manager','News Feeds','Plugin Manager','Polls','Search','Template Manager','User','User Manager','Web Links','Wrapper') NOT NULL
puroparty.bak_components.link   option=com_wrapper 0 20 24 0 4.3750 NULL ENUM('','option=com_contact','option=com_content','option=com_newsfeeds','option=com_poll','option=com_search','option=com_user','option=com_weblinks','option=com_wrapper') NOT NULL
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=client','option=com_categories&section=com_banner','option=com_categories&section=com_contact_details','option=com_categories&section=com_newsfeeds','option=com_categories&section=com_weblinks','option=com_contact','option=com_media','option=com_newsfeeds','option=com_poll','option=com_search','option=com_weblinks') NOT NULL
puroparty.bak_components.admin_menu_alt Active Banners Wrapper 5 25 3 0 12.2188 NULL ENUM('','Active Banners','Banner Management','Cache','Categories','Configuration','Control Panel','Edit contact details','Installer','Languages','Manage Categories','Manage Clients','Manage contact categories','Manage News Feeds','Manage Polls','Manage weblink categories','Manage Weblinks','Mass Mail','Media Manager','Menu Editor','Messages','Modules','News Feeds Management','Plugins','Search Statistics','Templates','Users','View existing weblinks','Wrapper') NOT NULL
puroparty.bak_components.option com_banners com_wrapper 8 13 4 0 9.5000 NULL ENUM('','com_banners','com_cache','com_config','com_contact','com_content','com_cpanel','com_installer','com_languages','com_mailto','com_massmail','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_poll','com_search','com_templates','com_user','com_users','com_weblinks','com_wrapper') NOT NULL
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/ThemeOffice/component.png','js/ThemeOffice/edit.png') NOT NULL
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\nuseractivation=1\nfrontend_userparams=1\n\n upload_extensions=bmp,csv,doc,epg,gif,ico,jpg,odg,odp,ods,odt,pdf,png,ppt,swf,txt,xcf,xls,BMP,CSV,DOC,EPG,GIF,ICO,JPG,ODG,ODP,ODS,ODT,PDF,PNG,PPT,SWF,TXT,XCF,XLS\nupload_maxsize=10000000\nfile_path=images\nimage_path=images/stories\nrestrict_uploads=1\ncheck_mime=1\nimage_extensions=bmp,gif,jpg,png\nignore_extensions=\nupload_mime=image/jpeg,image/gif,image/png,image/bmp,application/x-shockwave-flash,application/msword,application/excel,application/pdf,application/powerpoint,text/plain,application/x-zip\nupload_mime_illegal=text/html 11 530 22 0 57.1875 NULL ENUM('','allowUserRegistration=1\nnew_usertype=Registered\nuseractivation=1\nfrontend_userparams=1\n\n','contact_icons=0\nicon_address=\nicon_email=\nicon_telephone=\nicon_fax=\nicon_misc=\nshow_headings=1\nshow_position=1\nshow_email=0\nshow_telephone=1\nshow_mobile=1\nshow_fax=1\nbannedEmail=\nbannedSubject=\nbannedText=\nsession=1\ncustomReply=0\n\n','enabled=0\n\n','mailSubjectPrefix=\nmailBodySuffix=\n\n','show_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_headings=1\nshow_name=1\nshow_articles=1\nshow_link=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_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\nfeed_summary=0\n\n','track_impressions=0\ntrack_clicks=0\ntag_prefix=\n\n','upload_extensions=bmp,csv,doc,epg,gif,ico,jpg,odg,odp,ods,odt,pdf,png,ppt,swf,txt,xcf,xls,BMP,CSV,DOC,EPG,GIF,ICO,JPG,ODG,ODP,ODS,ODT,PDF,PNG,PPT,SWF,TXT,XCF,XLS\nupload_maxsize=10000000\nfile_path=images\nimage_path=images/stories\nrestrict_uploads=1\ncheck_mime=1\nimage_extensions=bmp,gif,jpg,png\nignore_extensions=\nupload_mime=image/jpeg,image/gif,image/png,image/bmp,application/x-shockwave-flash,application/msword,application/excel,application/pdf,application/powerpoint,text/plain,application/x-zip\nupload_mime_illegal=text/html') NOT NULL
puroparty.bak_components.enabled 1 1 1 1 0 0 1.0000 0.0000 ENUM('1') NOT NULL