Host: mysql.puroparty.com
Database: puroparty
Generation Time: Apr 16, 2024 at 12:26 PM
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... |
| 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 | 8262 | 2 | 4 | 0 | 0 | 3439.7500 | 2972.9212 | ENUM('43','49','2743','2748','8182','8262') NOT NU... |
| puroparty.jos_banner.clicks | 0 | 1633 | 1 | 4 | 2 | 0 | 676.7500 | 505.4074 | ENUM('0','605','642','698','706','1130','1633') 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 |