Host: mysql.puroparty.com
Database: puroparty
Generation Time: Apr 25, 2024 at 11:49 PM
Generated by: phpMyAdmin 2.6.0-pl3 / MySQL 4.1.22-standard
SQL-query: SELECT * FROM `wp_1_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_1_posts.ID | 1 | 3 | 1 | 1 | 0 | 0 | 2.0000 | 0.8165 | ENUM('1','2','3') NOT NULL |
puroparty.wp_1_posts.post_author | 1 | 2 | 1 | 1 | 0 | 0 | 1.3333 | 0.4714 | ENUM('1','2') NOT NULL |
puroparty.wp_1_posts.post_date | 0000-00-00 00:00:00 | 2008-08-05 15:42:17 | 19 | 19 | 0 | 0 | 19.0000 | NULL | ENUM('0000-00-00 00:00:00','2008-08-05 15:42:17') NOT NULL |
puroparty.wp_1_posts.post_date_gmt | 0000-00-00 00:00:00 | 2008-08-05 20:42:17 | 19 | 19 | 0 | 0 | 19.0000 | NULL | ENUM('0000-00-00 00:00:00','2008-08-05 20:42:17') NOT NULL |
puroparty.wp_1_posts.post_content | 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.com</a>. This is your first post. Edit or delete it, then start blogging! | 134 | 269 | 1 | 0 | 134.3333 | NULL | ENUM('','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.com</a>. This is your first post. Edit or delete it, then start blogging!') NOT NULL |
puroparty.wp_1_posts.post_title | About | Test | 4 | 12 | 0 | 0 | 7.0000 | NULL | ENUM('About','Hello world!','Test') NOT NULL |
puroparty.wp_1_posts.post_category | 0 | 0 | 1 | 1 | 3 | 0 | 0.0000 | 0.0000 | ENUM('0') NOT NULL |
puroparty.wp_1_posts.post_excerpt | 0 | 0 | 3 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
puroparty.wp_1_posts.post_status | draft | publish | 5 | 7 | 0 | 0 | 6.3333 | NULL | ENUM('draft','publish') NOT NULL |
puroparty.wp_1_posts.comment_status | open | open | 4 | 4 | 0 | 0 | 4.0000 | NULL | ENUM('open') NOT NULL |
puroparty.wp_1_posts.ping_status | open | open | 4 | 4 | 0 | 0 | 4.0000 | NULL | ENUM('open') NOT NULL |
puroparty.wp_1_posts.post_password | 0 | 0 | 3 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
puroparty.wp_1_posts.post_name | about | hello-world | 5 | 11 | 1 | 0 | 5.3333 | NULL | ENUM('','about','hello-world') NOT NULL |
puroparty.wp_1_posts.to_ping | 0 | 0 | 3 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
puroparty.wp_1_posts.pinged | 0 | 0 | 3 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
puroparty.wp_1_posts.post_modified | 2008-08-05 15:42:17 | 2008-08-17 19:43:33 | 19 | 19 | 0 | 0 | 19.0000 | NULL | ENUM('2008-08-05 15:42:17','2008-08-17 19:43:33') NOT NULL |
puroparty.wp_1_posts.post_modified_gmt | 2008-08-05 20:42:17 | 2008-08-18 00:43:33 | 19 | 19 | 0 | 0 | 19.0000 | NULL | ENUM('2008-08-05 20:42:17','2008-08-18 00:43:33') NOT NULL |
puroparty.wp_1_posts.post_content_filtered | 0 | 0 | 3 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
puroparty.wp_1_posts.post_parent | 0 | 0 | 1 | 1 | 3 | 0 | 0.0000 | 0.0000 | ENUM('0') NOT NULL |
puroparty.wp_1_posts.guid | http://puroparty.com/ppblogs/?p=3 | 0 | 33 | 2 | 0 | 11.0000 | NULL | ENUM('','http://puroparty.com/ppblogs/?p=3') NOT NULL | |
puroparty.wp_1_posts.menu_order | 0 | 0 | 1 | 1 | 3 | 0 | 0.0000 | 0.0000 | ENUM('0') NOT NULL |
puroparty.wp_1_posts.post_type | page | post | 4 | 4 | 0 | 0 | 4.0000 | NULL | ENUM('page','post') NOT NULL |
puroparty.wp_1_posts.post_mime_type | 0 | 0 | 3 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
puroparty.wp_1_posts.comment_count | 2 | 2 | 1 | 1 | 2 | 0 | 0.6667 | 0.9428 | ENUM('0','2') NOT NULL |