Host: mysql.puroparty.com
Database: puroparty
Generation Time: Apr 25, 2024 at 03:17 AM
Generated by: phpMyAdmin 2.6.0-pl3 / MySQL 4.1.22-standard
SQL-query: SELECT * FROM `wp_2_posts` PROCEDURE ANALYSE();
Rows: 24
Field_name | Min_value | Max_value | Min_length | Max_length | Empties_or_zeros | Nulls | Avg_value_or_avg_length | Std | Optimal_fieldtype |
---|---|---|---|---|---|---|---|---|---|
puroparty.wp_2_posts.ID | 1 | 9 | 1 | 1 | 0 | 0 | 5.0000 | 2.5820 | ENUM('1','2','3','4','5','6','7','8','9') NOT NULL |
puroparty.wp_2_posts.post_author | 1 | 1 | 1 | 1 | 0 | 0 | 1.0000 | 0.0000 | ENUM('1') NOT NULL |
puroparty.wp_2_posts.post_date | 0000-00-00 00:00:00 | 2008-09-05 00:01:45 | 19 | 19 | 0 | 0 | 19.0000 | NULL | ENUM('0000-00-00 00:00:00','2008-08-05 15:50:46','2008-08-19 23:50:39','2008-09-05 00:01:45') NOT NULL |
puroparty.wp_2_posts.post_date_gmt | 0000-00-00 00:00:00 | 2008-09-05 05:01:45 | 19 | 19 | 0 | 0 | 19.0000 | NULL | ENUM('0000-00-00 00:00:00','2008-08-05 20:50:46','2008-08-20 04:50:39','2008-09-05 05:01:45') NOT NULL |
puroparty.wp_2_posts.post_content | <object width="425" height="344"><param name="movie" value="<a href="http://www.youtube.com/v/scdm5il-hC4&hl=en&fs=1"></param><param">http://www.youtube.com/v/scdm5il-hC4&hl=en&fs=1"></param><param</a> name="allowFullScreen" value="true"></param><embed src="<a href="http://www.youtube.com/v/scdm5il-hC4&hl=en&fs=1">http://www.youtube.com/v/scdm5il-hC4&hl=en&fs=1</a>" type="application/x-shockwave-flash" allowfullscreen="true" width="425" height="344"></embed></object> | xxx | 3 | 568 | 2 | 0 | 111.0000 | NULL | ENUM('','<object width="425" height="344"><param name="movie" value="<a href="http://www.youtube.com/v/scdm5il-hC4&hl=en&fs=1"></param><param">http://www.youtube.com/v/scdm5il-hC4&hl=en&fs=1"></param><param</a> name="allowFullScreen" value="true"></param><embed src="<a href="http://www.youtube.com/v/scdm5il-hC4&hl=en&fs=1">http://www.youtube.com/v/scdm5il-hC4&hl=en&fs=1</a>" type="application/x-shockwave-flash" allowfullscreen="true" width="425" height="344"></embed></object>','test','test2','this is a test','This is an example of a WordPress page, you could edit this to put information about yourself or your site so readers know where you are coming from. You can create as many pages like this one or sub-pages as you like and manage all of your content inside of WordPress.','Welcome to <a href="http://puroparty.com/ppblogs/">PuroParty Blogs</a>. This is your first post. Edit or delete it, then start blogging!','xxx') NOT NULL |
puroparty.wp_2_posts.post_title | About | xxx | 3 | 12 | 0 | 0 | 6.6667 | NULL | ENUM('About','Hello world!','music 2','music 3','music video','test','test 4','test2','xxx') NOT NULL |
puroparty.wp_2_posts.post_category | 0 | 0 | 1 | 1 | 9 | 0 | 0.0000 | 0.0000 | ENUM('0') NOT NULL |
puroparty.wp_2_posts.post_excerpt | 0 | 0 | 9 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
puroparty.wp_2_posts.post_status | draft | publish | 5 | 7 | 0 | 0 | 5.8889 | NULL | ENUM('draft','publish') NOT NULL |
puroparty.wp_2_posts.comment_status | open | open | 4 | 4 | 0 | 0 | 4.0000 | NULL | ENUM('open') NOT NULL |
puroparty.wp_2_posts.ping_status | open | open | 4 | 4 | 0 | 0 | 4.0000 | NULL | ENUM('open') NOT NULL |
puroparty.wp_2_posts.post_password | 0 | 0 | 9 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
puroparty.wp_2_posts.post_name | about | test2 | 5 | 11 | 5 | 0 | 3.0000 | NULL | ENUM('','about','hello-world','test-4','test2') NOT NULL |
puroparty.wp_2_posts.to_ping | 0 | 0 | 9 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
puroparty.wp_2_posts.pinged | 0 | 0 | 9 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
puroparty.wp_2_posts.post_modified | 2008-08-05 15:50:46 | 2008-09-05 00:01:45 | 19 | 19 | 0 | 0 | 19.0000 | NULL | ENUM('2008-08-05 15:50:46','2008-08-19 16:44:22','2008-08-19 16:48:41','2008-08-19 17:00:29','2008-08-19 17:32:13','2008-08-19 23:48:24','2008-08-19 23:50:39','2008-09-05 00:01:45') NOT NULL |
puroparty.wp_2_posts.post_modified_gmt | 2008-08-05 20:50:46 | 2008-09-05 05:01:45 | 19 | 19 | 0 | 0 | 19.0000 | NULL | ENUM('2008-08-05 20:50:46','2008-08-19 21:44:22','2008-08-19 21:48:41','2008-08-19 22:00:29','2008-08-19 22:32:13','2008-08-20 04:48:24','2008-08-20 04:50:39','2008-09-05 05:01:45') NOT NULL |
puroparty.wp_2_posts.post_content_filtered | 0 | 0 | 9 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
puroparty.wp_2_posts.post_parent | 0 | 0 | 1 | 1 | 9 | 0 | 0.0000 | 0.0000 | ENUM('0') NOT NULL |
puroparty.wp_2_posts.guid | http://puroparty.com/ppblogs/politico/?p=9 | 0 | 42 | 2 | 0 | 32.6667 | NULL | ENUM('','http://puroparty.com/ppblogs/politico/?p=3','http://puroparty.com/ppblogs/politico/?p=4','http://puroparty.com/ppblogs/politico/?p=5','http://puroparty.com/ppblogs/politico/?p=6','http://puroparty.com/ppblogs/politico/?p=7','http://puroparty.com/ppblogs/politico/?p=8','http://puroparty.com/ppblogs/politico/?p=9') NOT NULL | |
puroparty.wp_2_posts.menu_order | 0 | 0 | 1 | 1 | 9 | 0 | 0.0000 | 0.0000 | ENUM('0') NOT NULL |
puroparty.wp_2_posts.post_type | page | post | 4 | 4 | 0 | 0 | 4.0000 | NULL | ENUM('page','post') NOT NULL |
puroparty.wp_2_posts.post_mime_type | 0 | 0 | 9 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
puroparty.wp_2_posts.comment_count | 1 | 1 | 1 | 1 | 8 | 0 | 0.1111 | 0.3143 | ENUM('0','1') NOT NULL |