Host: mysql.puroparty.com
Database: puroparty
Generation Time: Apr 24, 2024 at 12:10 PM
Generated by: phpMyAdmin 2.6.0-pl3 / MySQL 4.1.22-standard
SQL-query: SELECT * FROM `jos_weblinks` PROCEDURE ANALYSE();
Rows: 16
Field_name | Min_value | Max_value | Min_length | Max_length | Empties_or_zeros | Nulls | Avg_value_or_avg_length | Std | Optimal_fieldtype |
---|---|---|---|---|---|---|---|---|---|
puroparty.jos_weblinks.id | 1 | 6 | 1 | 1 | 0 | 0 | 3.5000 | 1.7078 | ENUM('1','2','3','4','5','6') NOT NULL |
puroparty.jos_weblinks.catid | 2 | 2 | 1 | 1 | 0 | 0 | 2.0000 | 0.0000 | ENUM('2') NOT NULL |
puroparty.jos_weblinks.sid | 0 | 0 | 1 | 1 | 6 | 0 | 0.0000 | 0.0000 | ENUM('0') NOT NULL |
puroparty.jos_weblinks.title | Joomla! | php.net | 5 | 25 | 0 | 0 | 12.8333 | NULL | ENUM('Joomla!','Joomla! - Forums','MySQL','Ohloh T... |
puroparty.jos_weblinks.alias | joomla | php | 3 | 24 | 0 | 0 | 11.3333 | NULL | ENUM('joomla','joomla-forums','mysql','ohloh-track... |
puroparty.jos_weblinks.url | http://forum.joomla.org | http://www.php.net | 18 | 32 | 0 | 0 | 24.3333 | NULL | ENUM('http://forum.joomla.org','http://www.joomla.... |
puroparty.jos_weblinks.description | Home of Joomla! | The language that Joomla! is developed in | 11 | 118 | 0 | 0 | 38.1667 | NULL | ENUM('Home of Joomla!','Home of OSM','Joomla! Foru... |
puroparty.jos_weblinks.date | 2004-07-07 10:18:31 | 2007-07-19 09:28:31 | 19 | 19 | 0 | 0 | 19.0000 | NULL | ENUM('2004-07-07 10:18:31','2004-07-07 11:33:24','... |
puroparty.jos_weblinks.hits | 1 | 11 | 1 | 2 | 0 | 0 | 4.3333 | 3.4480 | ENUM('1','3','4','6','11') NOT NULL |
puroparty.jos_weblinks.published | 1 | 1 | 1 | 1 | 0 | 0 | 1.0000 | 0.0000 | ENUM('1') NOT NULL |
puroparty.jos_weblinks.checked_out | 0 | 0 | 1 | 1 | 6 | 0 | 0.0000 | 0.0000 | ENUM('0') NOT NULL |
puroparty.jos_weblinks.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_weblinks.ordering | 1 | 6 | 1 | 1 | 0 | 0 | 3.5000 | 1.7078 | ENUM('1','2','3','4','5','6') NOT NULL |
puroparty.jos_weblinks.archived | 0 | 0 | 1 | 1 | 6 | 0 | 0.0000 | 0.0000 | ENUM('0') NOT NULL |
puroparty.jos_weblinks.approved | 1 | 1 | 1 | 1 | 0 | 0 | 1.0000 | 0.0000 | ENUM('1') NOT NULL |
puroparty.jos_weblinks.params | target=0\n\n | target=0 | 8 | 10 | 2 | 0 | 5.6667 | NULL | ENUM('','target=0\n\n','target=0') NOT NULL |