Host: mysql.puroparty.com
Database: puroparty
Generation Time: Apr 19, 2024 at 08:34 PM
Generated by: phpMyAdmin 2.6.0-pl3 / MySQL 4.1.22-standard
SQL-query: SELECT * FROM `wp_3_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_3_posts.ID | 1 | 10 | 1 | 2 | 0 | 0 | 5.5000 | 2.8723 | ENUM('1','2','3','4','5','6','7','8','9','10') NOT... |
puroparty.wp_3_posts.post_author | 1 | 2 | 1 | 1 | 0 | 0 | 1.8000 | 0.4000 | ENUM('1','2') NOT NULL |
puroparty.wp_3_posts.post_date | 0000-00-00 00:00:00 | 2008-08-12 00:17:35 | 19 | 19 | 0 | 0 | 19.0000 | NULL | ENUM('0000-00-00 00:00:00','2008-08-05 16:00:38','... |
puroparty.wp_3_posts.post_date_gmt | 0000-00-00 00:00:00 | 2008-08-12 05:17:35 | 19 | 19 | 0 | 0 | 19.0000 | NULL | ENUM('0000-00-00 00:00:00','2008-08-05 21:00:38','... |
puroparty.wp_3_posts.post_content | \r\n \r\n \r\n <!-- some minimal styling, can be remove... | [flv]config=%7Bembedded%3Atrue%2CbaseURL%3A%27http... | 4 | 951 | 2 | 0 | 184.5000 | NULL | ENUM('\r\n \r\n \r\n <!-- some minimal styling, can be ... |
puroparty.wp_3_posts.post_title | Baby Boy - Ya No LLores (Let Me Love You) Music V... | test 45 | 4 | 54 | 0 | 0 | 11.2000 | NULL | ENUM(' Baby Boy - Ya No LLores (Let Me Love You) M... |
puroparty.wp_3_posts.post_category | 0 | 0 | 1 | 1 | 10 | 0 | 0.0000 | 0.0000 | ENUM('0') NOT NULL |
puroparty.wp_3_posts.post_excerpt | 0 | 0 | 10 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
puroparty.wp_3_posts.post_status | draft | publish | 5 | 7 | 0 | 0 | 5.8000 | NULL | ENUM('draft','publish') NOT NULL |
puroparty.wp_3_posts.comment_status | open | open | 4 | 4 | 0 | 0 | 4.0000 | NULL | ENUM('open') NOT NULL |
puroparty.wp_3_posts.ping_status | open | open | 4 | 4 | 0 | 0 | 4.0000 | NULL | ENUM('open') NOT NULL |
puroparty.wp_3_posts.post_password | 0 | 0 | 10 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
puroparty.wp_3_posts.post_name | about | spacer-3 | 5 | 11 | 6 | 0 | 3.0000 | NULL | ENUM('','about','blog-2','hello-world','spacer-3')... |
puroparty.wp_3_posts.to_ping | 0 | 0 | 10 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
puroparty.wp_3_posts.pinged | 0 | 0 | 10 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
puroparty.wp_3_posts.post_modified | 2008-08-05 16:00:38 | 2008-09-01 18:10:29 | 19 | 19 | 0 | 0 | 19.0000 | NULL | ENUM('2008-08-05 16:00:38','2008-08-12 00:16:17','... |
puroparty.wp_3_posts.post_modified_gmt | 2008-08-05 21:00:38 | 2008-09-01 23:10:29 | 19 | 19 | 0 | 0 | 19.0000 | NULL | ENUM('2008-08-05 21:00:38','2008-08-12 05:16:17','... |
puroparty.wp_3_posts.post_content_filtered | 0 | 0 | 10 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
puroparty.wp_3_posts.post_parent | 0 | 0 | 1 | 1 | 10 | 0 | 0.0000 | 0.0000 | ENUM('0') NOT NULL |
puroparty.wp_3_posts.guid | http://puroparty.com/ppblogs/baba/?p=9 | 0 | 39 | 2 | 0 | 30.5000 | NULL | ENUM('','http://puroparty.com/ppblogs/baba/?p=10',... | |
puroparty.wp_3_posts.menu_order | 0 | 0 | 1 | 1 | 10 | 0 | 0.0000 | 0.0000 | ENUM('0') NOT NULL |
puroparty.wp_3_posts.post_type | page | post | 4 | 4 | 0 | 0 | 4.0000 | NULL | ENUM('page','post') NOT NULL |
puroparty.wp_3_posts.post_mime_type | 0 | 0 | 10 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
puroparty.wp_3_posts.comment_count | 1 | 1 | 1 | 1 | 9 | 0 | 0.1000 | 0.3000 | ENUM('0','1') NOT NULL |