Host: mysql.puroparty.com
Database: puroparty
Generation Time: Apr 23, 2024 at 12:47 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 Tracking of Joomla!','OpenSourceMatters','php.net') NOT NULL |
| puroparty.jos_weblinks.alias | joomla | php | 3 | 24 | 0 | 0 | 11.3333 | NULL | ENUM('joomla','joomla-forums','mysql','ohloh-tracking-of-joomla','opensourcematters','php') NOT NULL |
| 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.org','http://www.mysql.com','http://www.ohloh.net/projects/20','http://www.opensourcematters.org','http://www.php.net') NOT NULL |
| 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! Forums','Objective reports from Ohloh about Joomla\'s development activity. Joomla! has some star developers with serious kudos.','The database that Joomla! uses','The language that Joomla! is developed in') NOT NULL |
| 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','2005-02-14 15:19:02','2007-07-19 09:28:31') NOT NULL |
| 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 |