SQL result

Host: mysql.puroparty.com
Database: puroparty
Generation Time: Mar 28, 2024 at 09:49 PM
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','Joomla! - Official News','Linux Central:Best Selling','Linux Central:Daily Specials','Linux Central:New Products','Linux Today','Web Developer News') NOT NULL
puroparty.jos_newsfeeds.alias business-news web-developer-news 11 28 0 0 20.5000 NULL ENUM('business-news','joomla-community-news','joomla-official-news','linux-central-best-selling','linux-central-daily-specials','linux-central-news-products','linux-today','web-developer-news') NOT NULL
puroparty.jos_newsfeeds.link http://headlines.internet.com/internetnews/bus-news/news.rss http://www.joomla.org/index.php?option=com_rss_xtd&feed=RSS2.0&type=com_frontpage&Itemid=1 41 112 0 0 62.2500 NULL ENUM('http://headlines.internet.com/internetnews/bus-news/news.rss','http://headlines.internet.com/internetnews/wd-news/news.rss','http://linuxcentral.com/backend/lcbestns.rdf','http://linuxcentral.com/backend/lcnew.rdf','http://linuxcentral.com/backend/lcspecialns.rdf','http://linuxtoday.com/backend/my-netscape.rdf','http://www.joomla.org/index.php?option=com_rss_xtd&feed=RSS2.0&type=com_content&task=blogcategory&id=0&Itemid=33','http://www.joomla.org/index.php?option=com_rss_xtd&feed=RSS2.0&type=com_frontpage&Itemid=1') NOT NULL
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