Server: mysql.puroparty.commysql.puroparty.com
Database: puropartypuroparty
Table: jos_bannerjos_banner
StructureStructure BrowseBrowse SQLSQL SearchSearch InsertInsert ExportExport OperationsOperations EmptyEmpty DropDrop

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 8309 2 4 0 0 3455.0000 2988.2638 ENUM('43','49','2753','2758','8217','8309') NOT NU...
puroparty.jos_banner.clicks 0 1640 1 4 2 0 681.1250 507.7761 ENUM('0','611','646','704','711','1137','1640') NO...
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