SQL result

Host: mysql.puroparty.com
Database: puroparty
Generation Time: Mar 28, 2024 at 04:54 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','12','13','14','15','16','17','18','19','20','21','22','23','24','25','26','27','28','29','30','31','32','33','34','35','36','37','38','39','40','41','42','43') NOT NULL
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 with PHP Safe Mode On?','Content Layouts','Does the PDF icon render pictures and special characters?','Example Pages and Menu Links','Extensions','How do I install Joomla! 1.5?','How do I localise Joomla! to my language?','How do I remove an Article?','How do I upgrade to Joomla! 1.5 ?','I installed with my own language, but the Back-end is still in English','Is it possible to change A Menu Item\'s Type?','Is it useful to install the sample data?','Joomla! Facts','Joomla! Features','Joomla! License Guidelines','Joomla! Overview','My MySQL  database does not support UTF-8. Do I have a problem?','Newsflash 1','Newsflash 2','Newsflash 3','Newsflash 4','Newsflash 5','Only one edit window! How do I create "Read more..."?','Platforms and Open Standards','Stick to the Code!','Support and Documentation','The Joomla! Community','The Legend of Buca di Beppo','We are Volunteers','Welcome to Joomla!','What are the requirements to run Joomla! 1.5?','What happened to the locale setting?','What is an Uncategorised Article?','What is the difference between Archiving and Trashing an Article?','What is the FTP layer for?','What is the purpose of the collation selection in the installation screen?','What languages are supported by Joomla! 1.5?','What\'s New In 1.5?','Where did the Installers go?','Where did the Mambots go?','Where is the Static Content Item?','Why does Joomla! 1.5 use utf-8 encoding?') NOT NULL
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-with-php-safe-mode-on','content-layouts','does-the-pdf-icon-render-pictures-and-special-characters','example-pages-and-menu-links','extensions','how-do-i-install-joomla-15','how-do-i-localise-joomla-to-my-language','how-do-i-remove-an-article','how-do-i-upgrade-to-joomla-15','i-installed-with-my-own-language-but-the-back-end-is-still-in-english','is-it-possible-to-change-the-types-of-menu-entries','is-it-useful-to-install-the-sample-data','joomla-facts','joomla-features','joomla-license-guidelines','joomla-overview','my-mysql-database-does-not-support-utf-8-do-i-have-a-problem','newsflash-1','newsflash-2','newsflash-3','newsflash-4','newsflash-5','only-one-edit-window-how-do-i-create-read-more','platforms-and-open-standards','stick-to-the-code','support and documentation','the-joomla-community','the-legend-of-buca-di-beppo','we-are-volunteers','welcome-to-joomla','what-are-the-requirements-to-run-joomla-15','what-happened-to-the-locale-setting','what-is-the-difference-between-archiving-and-trashing-an-article','what-is-the-ftp-layer-for','what-is-the-purpose-of-the-collation-selection-in-the-installation-screen','what-is-uncategorised-article','what-languages-are-supported-by-joomla-15','whats-new-in-15','where-did-the-installer-go','where-did-the-mambots-go','where-is-the-static-content','why-does-joomla-15-use-utf-8-encoding') NOT NULL
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 source framework and content publishing system designed for quickly creating highly interactive multi-language Web sites, online communities, media portals, blogs and eCommerce applications. <br /></strong></div><p><strong><br /></strong><img src="images/stories/powered_by.png" border="0" alt="Joomla! Logo" title="Example Caption" hspace="6" vspace="0" width="165" height="68" align="left" />Joomla! provides an easy-to-use graphical user interface that simplifies the management and publishing of large volumes of content including HTML, documents, and rich media.  Joomla! is used by organisations of all sizes for Public Web sites, Intranets, and Extranets and is supported by a community of thousands of users. </p> Yesterday all servers in the U.S. went out on strike in a bid to get more RAM and better CPUs. A spokes person said that the need for better RAM was due to some fool increasing the front-side bus speed. In future, buses will be told to slow down in residential motherboards. 201 8227 0 0 913.9767 NULL TEXT NOT NULL
puroparty.jos_content.fulltext  </li></ul> <h4>Extensive Administration:</h4> <ul><li>Change order of objects including news, FAQs, Articles etc. </li><li>Random Newsflash generator </li><li>Remote Author submission Module for News, Articles, FAQs, and Links </li><li>Object hierarchy - as many Sections, departments, divisions, and pages as you want </li><li>Image library - store all your PNGs, PDFs, DOCs, XLSs, GIFs, and JPEGs online for easy use </li><li>Automatic Path-Finder. Place a picture and let Joomla! fix the link </li><li>News Feed Manager. Choose from over 360 News Feeds from around the world </li><li>E-mail a friend and Print format available for every story and Article </li><li>In-line Text editor similar to any basic word processor software </li><li>User editable look and feel </li><li>Polls/Surveys - Now put a different one on each page </li><li>Custom Page Modules. Download custom page Modules to spice up your site </li><li>Template Manager. Download Templates and implement them in seconds </li><li>Layout preview. See how it looks before going live </li><li>Banner Manager. Make money out of your site</li></ul> With a fully documented library of developer resources, Joomla! allows the customisation of every aspect of a Web site including presentation, layout, administration, and the rapid integration with third-party applications.<p>Joomla! has a rich heritage and has been crowned CMS king many times over.  Now with more power under the hood, Joomla! is shifting gear and provides developer power while making the user experience all the more friendly.  For those who always wanted increased extensibility, Joomla! 1.5 can make this happen.</p><p>A new framework, ground-up refactoring, and a highly-active development team brings the excitement of 'the next generation CMS' to your fingertips.  Whether you are a systems architect or a complete 'noob' Joomla! can take you to the next level of content delivery. 'More than a CMS' is something we have been playing with as a catchcry because the new Joomla! API has such incredible power and flexibility, you are free to take whatever direction your creative mind takes you and Joomla! can help you get there so much more easily than ever before.</p><p>Thinking Web publishing? Think Joomla!</p> 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') NOT NULL
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','2004-07-07 12:00:00','2004-08-09 22:30:34','2004-08-10 06:30:34','2004-08-20 10:11:07','2006-09-30 14:06:37','2006-09-30 20:27:52','2006-10-05 01:11:29','2006-10-06 16:47:35','2006-10-06 19:28:35','2006-10-06 19:29:28','2006-10-06 21:27:49','2006-10-07 09:30:37','2006-10-08 23:32:45','2006-10-09 07:49:20','2006-10-09 08:33:57','2006-10-09 16:46:37','2006-10-10 23:13:33','2006-10-10 23:15:36','2006-10-10 23:16:20','2006-10-11 00:42:31','2006-10-11 01:10:59','2006-10-11 01:12:18','2006-10-11 03:11:38','2006-10-11 04:22:14','2006-10-11 05:19:43','2006-10-11 06:00:00','2006-10-11 09:12:55','2006-10-11 09:17:00','2006-10-11 09:19:01','2006-10-11 15:14:11','2006-10-11 17:14:57','2006-10-11 17:18:14','2006-10-11 22:13:58','2006-10-12 00:17:31','2006-10-12 00:25:50','2006-10-12 09:26:52','2006-10-12 10:00:00','2006-10-12 16:50:48','2006-10-12 22:33:10') NOT NULL
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','2007-11-04 15:36:15','2007-11-04 15:39:15','2007-11-04 15:50:34','2007-11-04 16:38:53','2007-11-04 16:58:35','2007-11-04 18:24:09','2007-11-04 18:29:55','2007-11-04 18:49:37','2007-11-04 23:02:47','2007-11-04 23:07:08','2007-11-04 23:10:18','2007-11-04 23:12:30','2007-11-08 11:01:01','2007-11-08 11:03:30','2007-11-08 11:04:30','2007-11-08 11:22:14','2007-11-08 11:23:14','2007-11-08 11:23:56','2007-11-08 11:25:01','2007-11-08 11:26:51','2007-11-08 11:36:52','2007-11-08 11:39:01','2007-11-08 11:39:51','2007-11-08 11:42:43','2007-11-08 11:45:40','2007-11-08 11:46:29','2007-11-08 11:55:56','2007-11-08 12:01:26','2007-11-08 12:02:40','2007-11-08 12:03:24','2007-11-08 12:06:35','2007-11-08 12:10:35','2007-11-08 12:14:09','2007-11-08 12:16:19','2007-11-08 12:17:20','2007-11-08 12:17:53','2007-11-08 12:19:35','2007-11-08 12:20:41','2007-11-08 12:21:51','2007-11-08 14:49:48','2007-11-25 22:37:55') NOT NULL
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') NOT NULL
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','2004-08-09 06:00:00','2004-08-09 10:00:00','2004-08-19 06:00:00','2006-01-03 01:00:00','2006-09-29 10:00:00','2006-09-29 12:00:00','2006-10-03 10:00:00','2006-10-05 14:00:00','2006-10-05 16:00:00','2006-10-05 20:00:00','2006-10-07 06:00:00','2006-10-07 10:00:00','2006-10-07 14:00:00','2006-10-10 04:00:00','2006-10-10 06:00:00','2006-10-10 08:00:00','2006-10-10 10:00:00','2006-10-10 12:00:00','2006-10-10 14:00:00','2006-10-10 18:00:00','2006-10-10 22:00:00','2006-10-11 02:00:00','2006-10-11 06:00:00','2006-10-11 10:00:00') NOT NULL
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=\nlink_section=\nshow_category=\nlink_category=\nshow_vote=\nshow_author=\nshow_create_date=\nshow_modify_date=\nshow_pdf_icon=\nshow_print_icon=\nshow_email_icon=\nlanguage=\nkeyref=\nreadmore= show_title=\nlink_titles=\nshow_intro=\nshow_section=\nlink_section=\nshow_category=\nlink_category=\nshow_vote=\nshow_author=\nshow_create_date=\nshow_modify_date=\nshow_pdf_icon=\nshow_print_icon=\nshow_email_icon=\nlanguage=\nkeyref= 221 231 0 0 230.3023 NULL ENUM('show_title=\nlink_titles=\nshow_intro=\nshow_section=\nlink_section=\nshow_category=\nlink_category=\nshow_vote=\nshow_author=\nshow_create_date=\nshow_modify_date=\nshow_pdf_icon=\nshow_print_icon=\nshow_email_icon=\nlanguage=\nkeyref=\nreadmore=','show_title=\nlink_titles=\nshow_intro=\nshow_section=\nlink_section=\nshow_category=\nlink_category=\nshow_vote=\nshow_author=\nshow_create_date=\nshow_modify_date=\nshow_pdf_icon=\nshow_print_icon=\nshow_email_icon=\nlanguage=\nkeyref=') NOT NULL
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','29') NOT NULL
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 Menu Links 0 58 41 0 2.1395 NULL ENUM('','About Joomla!, General, Extensions','Uncategorized, Uncategorized, Example Pages and Menu Links') NOT NULL
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 2821 1 4 1 0 491.5349 798.4933 ENUM('0','1','6','11','26','28','29','32','34','39','40','42','43','50','52','59','65','172','204','228','396','404','966','1034','1063','1078','1119','1641','1898','2129','2336','2745','2821') NOT NULL
puroparty.jos_content.metadata robots=\nauthor= robots=\nauthor= 15 15 0 0 15.0000 NULL ENUM('robots=\nauthor=') NOT NULL