Host: mysql.puroparty.com
Database: puroparty
Generation Time: May 11, 2024 at 08:51 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 |