Host: mysql.puroparty.com
Database: puroparty
Generation Time: Apr 19, 2024 at 04:17 PM
Generated by: phpMyAdmin 2.6.0-pl3 / MySQL 4.1.22-standard
SQL-query: SELECT * FROM `jos_categories` PROCEDURE ANALYSE();
Rows: 17
| Field_name | Min_value | Max_value | Min_length | Max_length | Empties_or_zeros | Nulls | Avg_value_or_avg_length | Std | Optimal_fieldtype |
|---|---|---|---|---|---|---|---|---|---|
| puroparty.jos_categories.id | 1 | 33 | 1 | 2 | 0 | 0 | 16.8636 | 10.7547 | ENUM('1','2','3','4','5','6','7','12','13','14','15','17','18','19','25','27','28','29','30','31','32','33') NOT NULL |
| puroparty.jos_categories.parent_id | 0 | 0 | 1 | 1 | 22 | 0 | 0.0000 | 0.0000 | ENUM('0') NOT NULL |
| puroparty.jos_categories.title | Benefits | The Project | 5 | 22 | 0 | 0 | 10.1364 | NULL | ENUM('Benefits','Business: General','Contacts','Current Users','Features','General','Internet','Joomla','Joomla!','Joomla! Promo','Joomla! Specific Links','Languages','Latest','Linux','New to Joomla!','Newsflash','Other Resources','Platforms','Text Ads','The CMS','The Community','The Project') NOT NULL |
| puroparty.jos_categories.name | 0 | 0 | 22 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
| puroparty.jos_categories.alias | benefits | the-project | 5 | 21 | 0 | 0 | 10.1364 | NULL | ENUM('benefits','business-general','contacts','current-users','features','general','internet','joomla','joomla-promo','joomla-specific-links','languages','latest-news','linux','new-to-joomla','newsflash','other-resources','platforms','text-ads','the-cms','the-community','the-project') NOT NULL |
| puroparty.jos_categories.image | clock.jpg | taking_notes.jpg | 9 | 16 | 20 | 0 | 1.1364 | NULL | ENUM('','clock.jpg','taking_notes.jpg') NOT NULL |
| puroparty.jos_categories.section | 1 | com_weblinks | 1 | 19 | 0 | 0 | 7.5909 | NULL | ENUM('1','3','4','com_banner','com_contact_details','com_content','com_newsfeeds','com_weblinks') NOT NULL |
| puroparty.jos_categories.image_position | left | left | 4 | 4 | 0 | 0 | 4.0000 | NULL | ENUM('left') NOT NULL |
| puroparty.jos_categories.description | A selection of links that are all related to the Joomla! Project. | The latest news from the Joomla! Team | 33 | 71 | 12 | 0 | 21.1364 | NULL | ENUM('','A selection of links that are all related to the Joomla! Project.','About the millions of Joomla! users and Web sites<br />','Contact Details for this Web site','General facts about Joomla!<br />','General questions about the Joomla! CMS','Information about the software behind Joomla!<br />','Questions for new users of Joomla!','Questions related to localisation and languages','Questions that users migrating to Joomla! 1.5 are likely to raise<br />','The latest news from the Joomla! Team') NOT NULL |
| puroparty.jos_categories.published | 1 | 1 | 1 | 1 | 3 | 0 | 0.8636 | 0.3432 | ENUM('0','1') NOT NULL |
| puroparty.jos_categories.checked_out | 0 | 65 | 1 | 2 | 21 | 0 | 2.9545 | 13.5394 | ENUM('0','65') NOT NULL |
| puroparty.jos_categories.checked_out_time | 0000-00-00 00:00:00 | 2007-06-28 14:50:15 | 19 | 19 | 0 | 0 | 19.0000 | NULL | ENUM('0000-00-00 00:00:00','2007-06-28 14:50:15') NOT NULL |
| puroparty.jos_categories.editor | 0 | 0 | 2 | 20 | 0.0000 | NULL | CHAR(0) | ||
| puroparty.jos_categories.ordering | 1 | 7 | 1 | 1 | 3 | 0 | 2.3636 | 1.9434 | ENUM('0','1','2','3','4','6','7') NOT NULL |
| puroparty.jos_categories.access | 0 | 0 | 1 | 1 | 22 | 0 | 0.0000 | 0.0000 | ENUM('0') NOT NULL |
| puroparty.jos_categories.count | 1 | 1 | 1 | 1 | 21 | 0 | 0.0455 | 0.2083 | ENUM('0','1') NOT NULL |
| puroparty.jos_categories.params | 0 | 0 | 22 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL |