Host: mysql.puroparty.com
Database: puroparty
Generation Time: May 19, 2024 at 10:59 AM
Generated by: phpMyAdmin 2.6.0-pl3 / MySQL 4.1.22-standard
SQL-query: SELECT * FROM `jos_newsfeeds` PROCEDURE ANALYSE();
Rows: 13
Field_name | Min_value | Max_value | Min_length | Max_length | Empties_or_zeros | Nulls | Avg_value_or_avg_length | Std | Optimal_fieldtype |
---|---|---|---|---|---|---|---|---|---|
puroparty.jos_newsfeeds.catid | 4 | 7 | 1 | 1 | 0 | 0 | 5.5000 | 1.0000 | ENUM('4','5','6','7') NOT NULL |
puroparty.jos_newsfeeds.id | 1 | 8 | 1 | 1 | 0 | 0 | 4.5000 | 2.2913 | ENUM('1','2','3','4','5','6','7','8') NOT NULL |
puroparty.jos_newsfeeds.name | Business News | Web Developer News | 11 | 28 | 0 | 0 | 21.1250 | NULL | ENUM('Business News','Joomla! - Community News','J... |
puroparty.jos_newsfeeds.alias | business-news | web-developer-news | 11 | 28 | 0 | 0 | 20.5000 | NULL | ENUM('business-news','joomla-community-news','joom... |
puroparty.jos_newsfeeds.link | http://headlines.internet.com/internetnews/bus-new... | http://www.joomla.org/index.php?option=com_rss_xtd... | 41 | 112 | 0 | 0 | 62.2500 | NULL | ENUM('http://headlines.internet.com/internetnews/b... |
puroparty.jos_newsfeeds.filename | 0 | 0 | 8 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
puroparty.jos_newsfeeds.published | 1 | 1 | 1 | 1 | 0 | 0 | 1.0000 | 0.0000 | ENUM('1') NOT NULL |
puroparty.jos_newsfeeds.numarticles | 3 | 5 | 1 | 1 | 0 | 0 | 3.5000 | 0.8660 | ENUM('3','5') NOT NULL |
puroparty.jos_newsfeeds.cache_time | 3600 | 3600 | 4 | 4 | 0 | 0 | 3600.0000 | 0.0000 | ENUM('3600') NOT NULL |
puroparty.jos_newsfeeds.checked_out | 0 | 0 | 1 | 1 | 8 | 0 | 0.0000 | 0.0000 | ENUM('0') NOT NULL |
puroparty.jos_newsfeeds.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_newsfeeds.ordering | 1 | 9 | 1 | 1 | 0 | 0 | 4.7500 | 2.6339 | ENUM('1','2','3','4','5','6','8','9') NOT NULL |
puroparty.jos_newsfeeds.rtl | 0 | 0 | 1 | 1 | 8 | 0 | 0.0000 | 0.0000 | ENUM('0') NOT NULL |