Host: mysql.puroparty.com
Database: puroparty
Generation Time: Apr 23, 2024 at 12:18 PM
Generated by: phpMyAdmin 2.6.0-pl3 / MySQL 4.1.22-standard
SQL-query: SELECT * FROM `jos_sections` PROCEDURE ANALYSE();
Rows: 15
| 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 |