SQL result

Host: mysql.puroparty.com
Database: puroparty
Generation Time: Apr 20, 2024 at 01:58 AM
Generated by: phpMyAdmin 2.6.0-pl3 / MySQL 4.1.22-standard
SQL-query: SELECT * FROM `jos_banner` PROCEDURE ANALYSE();
Rows: 24

Field_name Min_value Max_value Min_length Max_length Empties_or_zeros Nulls Avg_value_or_avg_length Std Optimal_fieldtype
puroparty.jos_banner.bid 1 8 1 1 0 0 4.5000 2.2913 ENUM('1','2','3','4','5','6','7','8') NOT NULL
puroparty.jos_banner.cid 1 1 1 1 0 0 1.0000 0.0000 ENUM('1') NOT NULL
puroparty.jos_banner.type banner banner 6 6 6 0 1.5000 NULL ENUM('','banner') NOT NULL
puroparty.jos_banner.name Joomla! OSM 2 5 19 0 0 11.7500 NULL ENUM('Joomla!','Joomla! Extensions','Joomla! Promo Books','Joomla! Promo Shop','Joomla! Shop','JoomlaCode','OSM 1','OSM 2') NOT NULL
puroparty.jos_banner.alias joomla osm-2 5 18 0 0 11.1250 NULL ENUM('joomla','joomla-extensions','joomla-promo-books','joomla-promo-shop','joomla-shop','joomlacode','osm-1','osm-2') NOT NULL
puroparty.jos_banner.imptotal 0 0 1 1 8 0 0.0000 0.0000 ENUM('0') NOT NULL
puroparty.jos_banner.impmade 43 8277 2 4 0 0 3445.1250 2978.8028 ENUM('43','49','2746','2751','8198','8277') NOT NULL
puroparty.jos_banner.clicks 0 1636 1 4 2 0 678.5000 506.4257 ENUM('0','607','644','700','708','1133','1636') NOT NULL
puroparty.jos_banner.imageurl osmbanner1.png shop-ad.jpg 11 17 4 0 7.0000 NULL ENUM('','osmbanner1.png','osmbanner2.png','shop-ad-books.jpg','shop-ad.jpg') NOT NULL
puroparty.jos_banner.clickurl http://extensions.joomla.org http://www.opensourcematters.org 21 48 0 0 28.2500 NULL ENUM('http://extensions.joomla.org','http://joomlacode.org','http://shop.joomla.org','http://shop.joomla.org/amazoncom-bookstores.html','http://www.joomla.org','http://www.opensourcematters.org') NOT NULL
puroparty.jos_banner.date 2004-07-07 15:31:29 2007-09-19 17:28:01 19 19 0 0 19.0000 NULL ENUM('2004-07-07 15:31:29','2006-05-29 14:19:26','2006-05-29 14:21:28','2006-05-29 14:23:21','2007-09-19 17:26:24','2007-09-19 17:28:01') NOT NULL
puroparty.jos_banner.showBanner 1 1 1 1 0 0 1.0000 0.0000 ENUM('1') NOT NULL
puroparty.jos_banner.checked_out 0 0 1 1 8 0 0.0000 0.0000 ENUM('0') NOT NULL
puroparty.jos_banner.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_banner.editor     0 0 8 0 0.0000 NULL CHAR(0) NOT NULL
puroparty.jos_banner.custombannercode   <a href="{CLICKURL}" target="_blank">{NAME}</a>\r\n<br/>\r\nJoomlaCode, development and distribution made easy. 0 134 4 0 57.0000 NULL ENUM('','<a href="{CLICKURL}" target="_blank">{NAME}</a>\r\n<br/>\r\nFor all your Joomla! merchandise.','<a href="{CLICKURL}" target="_blank">{NAME}</a>\r\n<br/>\r\nJoomla! Components, Modules, Plugins and Languages by the bucket load.','<a href="{CLICKURL}" target="_blank">{NAME}</a>\r\n<br/>\r\nJoomla! The most popular and widely used Open Source CMS Project in the world.','<a href="{CLICKURL}" target="_blank">{NAME}</a>\r\n<br/>\r\nJoomlaCode, development and distribution made easy.') NOT NULL
puroparty.jos_banner.catid 13 33 2 2 0 0 18.5000 8.3815 ENUM('13','14','33') NOT NULL
puroparty.jos_banner.description     0 0 8 0 0.0000 NULL CHAR(0) NOT NULL
puroparty.jos_banner.sticky 0 0 1 1 8 0 0.0000 0.0000 ENUM('0') NOT NULL
puroparty.jos_banner.ordering 1 4 1 1 0 0 2.5000 1.1180 ENUM('1','2','3','4') NOT NULL
puroparty.jos_banner.publish_up 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_banner.publish_down 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_banner.tags     0 0 8 0 0.0000 NULL CHAR(0) NOT NULL
puroparty.jos_banner.params     0 0 8 0 0.0000 NULL CHAR(0) NOT NULL