Host: mysql.puroparty.com
Database: puroparty
Generation Time: Mar 28, 2024 at 08:36 AM
Generated by: phpMyAdmin 2.6.0-pl3 / MySQL 4.1.22-standard
SQL-query: SELECT * FROM `wp_9_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_9_posts.ID | 1 | 3 | 1 | 1 | 0 | 0 | 2.0000 | 0.8165 | ENUM('1','2','3') NOT NULL |
puroparty.wp_9_posts.post_author | 1 | 5 | 1 | 1 | 0 | 0 | 3.6667 | 1.8856 | ENUM('1','5') NOT NULL |
puroparty.wp_9_posts.post_date | 2008-09-05 00:05:25 | 2008-09-05 01:04:04 | 19 | 19 | 0 | 0 | 19.0000 | NULL | ENUM('2008-09-05 00:05:25','2008-09-05 01:04:04') ... |
puroparty.wp_9_posts.post_date_gmt | 2008-09-05 05:05:25 | 2008-09-05 06:04:04 | 19 | 19 | 0 | 0 | 19.0000 | NULL | ENUM('2008-09-05 05:05:25','2008-09-05 06:04:04') ... |
puroparty.wp_9_posts.post_content | <strong>CNN)</strong> -- Sen. John McCain got one ... | Welcome to <a href="http://puroparty.com/ppblogs/"... | 136 | 2920 | 0 | 0 | 1108.3333 | NULL | ENUM('<strong>CNN)</strong> -- Sen. John McCain go... |
puroparty.wp_9_posts.post_title | About | McCain at GOP Convention | 5 | 24 | 0 | 0 | 13.6667 | NULL | ENUM('About','Hello world!','McCain at GOP Convent... |
puroparty.wp_9_posts.post_category | 0 | 0 | 1 | 1 | 3 | 0 | 0.0000 | 0.0000 | ENUM('0') NOT NULL |
puroparty.wp_9_posts.post_excerpt | 0 | 0 | 3 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
puroparty.wp_9_posts.post_status | publish | publish | 7 | 7 | 0 | 0 | 7.0000 | NULL | ENUM('publish') NOT NULL |
puroparty.wp_9_posts.comment_status | open | open | 4 | 4 | 0 | 0 | 4.0000 | NULL | ENUM('open') NOT NULL |
puroparty.wp_9_posts.ping_status | open | open | 4 | 4 | 0 | 0 | 4.0000 | NULL | ENUM('open') NOT NULL |
puroparty.wp_9_posts.post_password | 0 | 0 | 3 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
puroparty.wp_9_posts.post_name | about | mccain-at-gop-convention | 5 | 24 | 0 | 0 | 13.3333 | NULL | ENUM('about','hello-world','mccain-at-gop-conventi... |
puroparty.wp_9_posts.to_ping | 0 | 0 | 3 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
puroparty.wp_9_posts.pinged | 0 | 0 | 3 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
puroparty.wp_9_posts.post_modified | 2008-09-05 00:05:25 | 2008-09-05 01:04:04 | 19 | 19 | 0 | 0 | 19.0000 | NULL | ENUM('2008-09-05 00:05:25','2008-09-05 01:04:04') ... |
puroparty.wp_9_posts.post_modified_gmt | 2008-09-05 05:05:25 | 2008-09-05 06:04:04 | 19 | 19 | 0 | 0 | 19.0000 | NULL | ENUM('2008-09-05 05:05:25','2008-09-05 06:04:04') ... |
puroparty.wp_9_posts.post_content_filtered | 0 | 0 | 3 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
puroparty.wp_9_posts.post_parent | 0 | 0 | 1 | 1 | 3 | 0 | 0.0000 | 0.0000 | ENUM('0') NOT NULL |
puroparty.wp_9_posts.guid | http://puroparty.com/ppblogs/mccain/?p=3 | 0 | 40 | 2 | 0 | 13.3333 | NULL | ENUM('','http://puroparty.com/ppblogs/mccain/?p=3'... | |
puroparty.wp_9_posts.menu_order | 0 | 0 | 1 | 1 | 3 | 0 | 0.0000 | 0.0000 | ENUM('0') NOT NULL |
puroparty.wp_9_posts.post_type | page | post | 4 | 4 | 0 | 0 | 4.0000 | NULL | ENUM('page','post') NOT NULL |
puroparty.wp_9_posts.post_mime_type | 0 | 0 | 3 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
puroparty.wp_9_posts.comment_count | 1 | 1 | 1 | 1 | 2 | 0 | 0.3333 | 0.4714 | ENUM('0','1') NOT NULL |