Server: mysql.puroparty.commysql.puroparty.com
Database: puropartypuroparty
Table: jos_contentjos_content
StructureStructure BrowseBrowse SQLSQL SearchSearch InsertInsert ExportExport OperationsOperations EmptyEmpty DropDrop

SQL-query
SQL-query: 
SELECT *
FROM `jos_content`
PROCEDURE ANALYSE ( )
 [Edit] [Explain SQL] [Create PHP Code] [Refresh]



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 2853 1 4 1 0 497.6512 808.4985 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


Print viewPrint view    Print view (with full texts)Print view (with full texts)     ExportExport