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§ion=com_banner','option=com_categories§ion=com_contact_details','option=com_categories§ion=com_newsfeeds','option=com_categories§ion=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 |