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 |