SQL result

Host: mysql.puroparty.com
Database: puroparty
Generation Time: Mar 28, 2024 at 05:39 AM
Generated by: phpMyAdmin 2.6.0-pl3 / MySQL 4.1.22-standard
SQL-query: SELECT * FROM `jos_plugins` PROCEDURE ANALYSE();
Rows: 12

Field_name Min_value Max_value Min_length Max_length Empties_or_zeros Nulls Avg_value_or_avg_length Std Optimal_fieldtype
puroparty.jos_plugins.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.jos_plugins.name Authentication - GMail XML-RPC - Joomla 12 35 0 0 19.4688 NULL ENUM('Authentication - GMail','Authentication - Joomla','Authentication - LDAP','Authentication - OpenID','Content - Code Hightlighter (GeSHi)','Content - Email Cloaking','Content - Load Module','Content - Page Navigation','Content - Pagebreak','Content - Rating','Editor - No Editor','Editor - TinyMCE 2.0','Editor - XStandard Lite 2.0','Editor Button - Image','Editor Button - Pagebreak','Editor Button - Readmore','Search - Categories','Search - Contacts','Search - Content','Search - Newsfeeds','Search - Sections','Search - Weblinks','System - Backlink','System - Cache','System - Debug','System - Legacy','System - Log','System - Remember Me','System - SEF','User - Joomla!','XML-RPC - Blogger API','XML-RPC - Joomla') NOT NULL
puroparty.jos_plugins.element backlink xstandard 3 14 0 0 6.9375 NULL ENUM('backlink','blogger','cache','categories','contacts','content','debug','emailcloak','geshi','gmail','image','joomla','ldap','legacy','loadmodule','log','newsfeeds','none','openid','pagebreak','pagenavigation','readmore','remember','sections','sef','tinymce','vote','weblinks','xstandard') NOT NULL
puroparty.jos_plugins.folder authentication xmlrpc 4 14 0 0 7.6875 NULL ENUM('authentication','content','editors','editors-xtd','search','system','user','xmlrpc') NOT NULL
puroparty.jos_plugins.access 0 0 1 1 32 0 0.0000 0.0000 ENUM('0') NOT NULL
puroparty.jos_plugins.ordering 1 10000 1 5 7 0 315.4688 1739.3947 ENUM('0','1','2','3','4','5','6','7','10000') NOT NULL
puroparty.jos_plugins.published 1 1 1 1 11 0 0.6562 0.4750 ENUM('0','1') NOT NULL
puroparty.jos_plugins.iscore 1 1 1 1 14 0 0.5625 0.4961 ENUM('0','1') NOT NULL
puroparty.jos_plugins.client_id 0 0 1 1 32 0 0.0000 0.0000 ENUM('0') NOT NULL
puroparty.jos_plugins.checked_out 0 0 1 1 32 0 0.0000 0.0000 ENUM('0') NOT NULL
puroparty.jos_plugins.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_plugins.params   theme=advanced\ncleanup=1\ncleanup_startup=0\nautosave=0\ncompressed=0\nrelative_urls=1\ntext_direction=ltr\nlang_mode=0\nlang_code=en\ninvalid_elements=applet\ncontent_css=1\ncontent_css_custom=\nnewlines=0\ntoolbar=top\nhr=1\nsmilies=1\ntable=1\nstyle=1\nlayer=1\nxhtmlxtras=0\ntemplate=0\ndirectionality=1\nfullscreen=1\nhtml_height=550\nhtml_width=750\npreview=1\ninsertdate=1\nformat_date=%Y-%m-%d\ninserttime=1\nformat_time=%H:%M:%S\n\n 0 411 15 0 29.5000 NULL ENUM('','autoregister=1\n\n','browsercache=0\ncachetime=15\n\n','catid=1\nsectionid=0\n\n','enabled=1\nstyle=0\n\n','enabled=1\ntitle=1\nmultipage_toc=1\nshowall=1\n\n','host=\nport=389\nuse_ldapV3=0\nnegotiate_tls=0\nno_referrals=0\nauth_method=bind\nbase_dn=\nsearch_string=\nusers_dn=\nusername=\npassword=\nldap_fullname=fullName\nldap_email=mail\nldap_uid=uid\n\n','mode=1\n\n','position=1\n\n','queries=1\nmemory=1\nlangauge=1\n\n','route=0\n\n','search_limit=50\n\n','search_limit=50\nsearch_content=1\nsearch_uncategorised=1\nsearch_archived=1\n\n','theme=advanced\ncleanup=1\ncleanup_startup=0\nautosave=0\ncompressed=0\nrelative_urls=1\ntext_direction=ltr\nlang_mode=0\nlang_code=en\ninvalid_elements=applet\ncontent_css=1\ncontent_css_custom=\nnewlines=0\ntoolbar=top\nhr=1\nsmilies=1\ntable=1\nstyle=1\nlayer=1\nxhtmlxtras=0\ntemplate=0\ndirectionality=1\nfullscreen=1\nhtml_height=550\nhtml_width=750\npreview=1\ninsertdate=1\nformat_date=%Y-%m-%d\ninserttime=1\nformat_time=%H:%M:%S\n\n') NOT NULL