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

SQL-query
SQL-query: 
SELECT *
FROM `jos_sections`
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_sections.id 1 4 1 1 0 0 2.6667 1.2472 ENUM('1','3','4') NOT NULL
puroparty.jos_sections.title About Joomla! News 4 13 0 0 7.0000 NULL ENUM('About Joomla!','FAQs','News') NOT NULL
puroparty.jos_sections.name     0 0 3 0 0.0000 NULL CHAR(0) NOT NULL
puroparty.jos_sections.alias about-joomla news 4 12 0 0 6.6667 NULL ENUM('about-joomla','faqs','news') NOT NULL
puroparty.jos_sections.image articles.jpg key.jpg 7 12 1 0 6.3333 NULL ENUM('','articles.jpg','key.jpg') NOT NULL
puroparty.jos_sections.scope content content 7 7 0 0 7.0000 NULL ENUM('content') NOT NULL
puroparty.jos_sections.image_position left right 4 5 0 0 4.3333 NULL ENUM('left','right') NOT NULL
puroparty.jos_sections.description From the list below choose one of our FAQs topics,... Select a news topic from the list below, then sele... 76 150 1 0 75.3333 NULL ENUM('','From the list below choose one of our FAQ...
puroparty.jos_sections.published 1 1 1 1 0 0 1.0000 0.0000 ENUM('1') NOT NULL
puroparty.jos_sections.checked_out 0 0 1 1 3 0 0.0000 0.0000 ENUM('0') NOT NULL
puroparty.jos_sections.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_sections.ordering 2 5 1 1 0 0 3.3333 1.2472 ENUM('2','3','5') NOT NULL
puroparty.jos_sections.access 0 0 1 1 3 0 0.0000 0.0000 ENUM('0') NOT NULL
puroparty.jos_sections.count 2 23 1 2 0 0 13.0000 8.6023 ENUM('2','14','23') NOT NULL
puroparty.jos_sections.params     0 0 3 0 0.0000 NULL CHAR(0) NOT NULL


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