Host: mysql.puroparty.com
Database: puroparty
Generation Time: Apr 26, 2024 at 12:02 AM
Generated by: phpMyAdmin 2.6.0-pl3 / MySQL 4.1.22-standard
SQL-query: SELECT * FROM `jos_content` PROCEDURE ANALYSE();
Rows: 30
Field_name | Min_value | Max_value | Min_length | Max_length | Empties_or_zeros | Nulls | Avg_value_or_avg_length | Std | Optimal_fieldtype |
---|---|---|---|---|---|---|---|---|---|
puroparty.jos_content.id | 1 | 43 | 1 | 2 | 0 | 0 | 22.0000 | 12.4097 | ENUM('1','2','3','4','5','6','7','8','9','10','11'... |
puroparty.jos_content.title | 1 Million Smiles | Why does Joomla! 1.5 use utf-8 encoding? | 10 | 74 | 0 | 0 | 30.6744 | NULL | ENUM('1 Million Smiles','Can Joomla! 1.5 operate w... |
puroparty.jos_content.alias | 1-million-smiles | why-does-joomla-15-use-utf-8-encoding | 10 | 73 | 0 | 0 | 29.3721 | NULL | ENUM('1-million-smiles','can-joomla-15-operate-wit... |
puroparty.jos_content.title_alias | joomla-license-guidelines | 0 | 25 | 42 | 0 | 0.5814 | NULL | ENUM('','joomla-license-guidelines') NOT NULL | |
puroparty.jos_content.introtext | <div align="left"><strong>Joomla! is a free open s... | Yesterday all servers in the U.S. went out on stri... | 201 | 8227 | 0 | 0 | 913.9767 | NULL | TEXT NOT NULL |
puroparty.jos_content.fulltext | </li></ul> <h4>Extensive Administration:</h4> <u... | With a fully documented library of developer resou... | 394 | 3678 | 36 | 0 | 234.1860 | NULL | TEXT NOT NULL |
puroparty.jos_content.state | 1 | 1 | 1 | 1 | 0 | 0 | 1.0000 | 0.0000 | ENUM('1') NOT NULL |
puroparty.jos_content.sectionid | 1 | 4 | 1 | 1 | 1 | 0 | 2.6977 | 1.1317 | ENUM('0','1','3','4') NOT NULL |
puroparty.jos_content.mask | 0 | 0 | 1 | 1 | 43 | 0 | 0.0000 | 0.0000 | ENUM('0') NOT NULL |
puroparty.jos_content.catid | 1 | 32 | 1 | 2 | 1 | 0 | 22.2558 | 12.1332 | ENUM('0','1','3','25','27','28','29','30','31','32... |
puroparty.jos_content.created | 2004-04-12 09:54:06 | 2006-10-12 22:33:10 | 19 | 19 | 0 | 0 | 19.0000 | NULL | ENUM('2004-04-12 09:54:06','2004-07-07 09:54:06','... |
puroparty.jos_content.created_by | 62 | 62 | 2 | 2 | 0 | 0 | 62.0000 | 0.0000 | ENUM('62') NOT NULL |
puroparty.jos_content.created_by_alias | 0 | 0 | 43 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
puroparty.jos_content.modified | 2007-05-03 09:39:48 | 2007-11-25 22:37:55 | 19 | 19 | 0 | 0 | 19.0000 | NULL | ENUM('2007-05-03 09:39:48','2007-05-03 09:40:32','... |
puroparty.jos_content.modified_by | 62 | 62 | 2 | 2 | 0 | 0 | 62.0000 | 0.0000 | ENUM('62') NOT NULL |
puroparty.jos_content.checked_out | 62 | 62 | 2 | 2 | 42 | 0 | 1.4419 | 9.3443 | ENUM('0','62') NOT NULL |
puroparty.jos_content.checked_out_time | 0000-00-00 00:00:00 | 2008-08-25 21:50:18 | 19 | 19 | 0 | 0 | 19.0000 | NULL | ENUM('0000-00-00 00:00:00','2008-08-25 21:50:18') ... |
puroparty.jos_content.publish_up | 2004-07-06 22:00:00 | 2006-10-11 10:00:00 | 19 | 19 | 0 | 0 | 19.0000 | NULL | ENUM('2004-07-06 22:00:00','2004-07-07 11:00:00','... |
puroparty.jos_content.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_content.images | 0 | 0 | 43 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
puroparty.jos_content.urls | 0 | 0 | 43 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
puroparty.jos_content.attribs | show_title=\nlink_titles=\nshow_intro=\nshow_section=... | show_title=\nlink_titles=\nshow_intro=\nshow_section=... | 221 | 231 | 0 | 0 | 230.3023 | NULL | ENUM('show_title=\nlink_titles=\nshow_intro=\nshow_se... |
puroparty.jos_content.version | 4 | 29 | 1 | 2 | 0 | 0 | 8.5349 | 4.6573 | ENUM('4','5','6','7','8','9','10','11','13','24','... |
puroparty.jos_content.parentid | 0 | 0 | 1 | 1 | 43 | 0 | 0.0000 | 0.0000 | ENUM('0') NOT NULL |
puroparty.jos_content.ordering | 1 | 8 | 1 | 1 | 0 | 0 | 3.0930 | 1.7890 | ENUM('1','2','3','4','5','6','7','8') NOT NULL |
puroparty.jos_content.metakey | Uncategorized, Uncategorized, Example Pages and Me... | 0 | 58 | 41 | 0 | 2.1395 | NULL | ENUM('','About Joomla!, General, Extensions','Unca... | |
puroparty.jos_content.metadesc | 0 | 0 | 43 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
puroparty.jos_content.access | 0 | 0 | 1 | 1 | 43 | 0 | 0.0000 | 0.0000 | ENUM('0') NOT NULL |
puroparty.jos_content.hits | 1 | 2860 | 1 | 4 | 1 | 0 | 498.9535 | 810.5790 | ENUM('0','1','6','11','26','28','29','32','34','39... |
puroparty.jos_content.metadata | robots=\nauthor= | robots=\nauthor= | 15 | 15 | 0 | 0 | 15.0000 | NULL | ENUM('robots=\nauthor=') NOT NULL |