Server: mysql.puroparty.commysql.puroparty.com
Database: puropartypuroparty
Table: jos_bannerjos_banner

SQL-query
SQL-query: 
SELECT *
FROM `jos_banner`
PROCEDURE ANALYSE ( )
 [Edit] [Explain SQL] [Create PHP Code] [Refresh]



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...
puroparty.jos_banner.alias joomla osm-2 5 18 0 0 11.1250 NULL ENUM('joomla','joomla-extensions','joomla-promo-bo...
puroparty.jos_banner.imptotal 0 0 1 1 8 0 0.0000 0.0000 ENUM('0') NOT NULL
puroparty.jos_banner.impmade 43 1699 2 4 0 0 808.1250 570.3180 ENUM('43','49','764','769','1608','1699') NOT NULL
puroparty.jos_banner.clicks 0 126 1 3 2 0 88.5000 51.6769 ENUM('0','101','113','118','124','126') 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...
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://joomla...
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','...
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<... 0 134 4 0 57.0000 NULL ENUM('','<a href="{CLICKURL}" target="_blank">{NAM...
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



Print viewPrint view    Print view (with full texts)Print view (with full texts)     ExportExport