Host: mysql.puroparty.com
Database: puroparty
Generation Time: Apr 17, 2024 at 07:29 PM
Generated by: phpMyAdmin 2.6.0-pl3 / MySQL 4.1.22-standard
SQL-query: SELECT * FROM `wp_7_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_7_posts.ID | 1 | 22 | 1 | 2 | 0 | 0 | 12.1667 | 6.5000 | ENUM('1','2','4','5','7','8','9','11','12','13','1... |
puroparty.wp_7_posts.post_author | 5 | 5 | 1 | 1 | 0 | 0 | 5.0000 | 0.0000 | ENUM('5') NOT NULL |
puroparty.wp_7_posts.post_date | 2008-08-12 15:24:36 | 2008-08-12 17:29:36 | 19 | 19 | 0 | 0 | 19.0000 | NULL | ENUM('2008-08-12 15:24:36','2008-08-12 15:55:57','... |
puroparty.wp_7_posts.post_date_gmt | 2008-08-12 20:24:36 | 2008-08-12 22:29:36 | 19 | 19 | 0 | 0 | 19.0000 | NULL | ENUM('2008-08-12 20:24:36','2008-08-12 20:55:57','... |
puroparty.wp_7_posts.post_content | <a href="http://puroparty.com/ppblogs/index/files/... | Welcome to <a href="http://puroparty.com/ppblogs/"... | 7 | 836 | 7 | 0 | 164.1667 | NULL | ENUM('','<a href="http://puroparty.com/ppblogs/ind... |
puroparty.wp_7_posts.post_title | About | title thalia | 4 | 22 | 0 | 0 | 10.7778 | NULL | ENUM('About','Hello world!','sodi','thalia','Thali... |
puroparty.wp_7_posts.post_category | 0 | 0 | 1 | 1 | 18 | 0 | 0.0000 | 0.0000 | ENUM('0') NOT NULL |
puroparty.wp_7_posts.post_excerpt | Thalia Sodi | 0 | 14 | 10 | 0 | 5.2778 | NULL | ENUM('','caption thalia','th cap','thalia caption'... | |
puroparty.wp_7_posts.post_status | inherit | publish | 7 | 7 | 0 | 0 | 7.0000 | NULL | ENUM('inherit','publish') NOT NULL |
puroparty.wp_7_posts.comment_status | open | open | 4 | 4 | 0 | 0 | 4.0000 | NULL | ENUM('open') NOT NULL |
puroparty.wp_7_posts.ping_status | open | open | 4 | 4 | 0 | 0 | 4.0000 | NULL | ENUM('open') NOT NULL |
puroparty.wp_7_posts.post_password | 0 | 0 | 18 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
puroparty.wp_7_posts.post_name | about | thalia8-12-20084 | 4 | 17 | 0 | 0 | 10.2778 | NULL | ENUM('about','hello-world','sodi','thalia','thalia... |
puroparty.wp_7_posts.to_ping | 0 | 0 | 18 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
puroparty.wp_7_posts.pinged | 0 | 0 | 18 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
puroparty.wp_7_posts.post_modified | 2008-08-12 15:24:36 | 2008-08-12 23:28:06 | 19 | 19 | 0 | 0 | 19.0000 | NULL | ENUM('2008-08-12 15:24:36','2008-08-12 15:55:57','... |
puroparty.wp_7_posts.post_modified_gmt | 2008-08-12 20:24:36 | 2008-08-13 04:28:06 | 19 | 19 | 0 | 0 | 19.0000 | NULL | ENUM('2008-08-12 20:24:36','2008-08-12 20:55:57','... |
puroparty.wp_7_posts.post_content_filtered | 0 | 0 | 18 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
puroparty.wp_7_posts.post_parent | -1218578052 | 17 | 1 | 11 | 6 | 0 | -67698773.4444 | 279129225.1658 | ENUM('-1218578052','0','3','6','10','17') NOT NULL |
puroparty.wp_7_posts.guid | http://puroparty.com/ppblogs/index/files/2008/08/t... | 0 | 69 | 2 | 0 | 55.0000 | NULL | ENUM('','http://puroparty.com/ppblogs/index/?p=17'... | |
puroparty.wp_7_posts.menu_order | 0 | 0 | 1 | 1 | 18 | 0 | 0.0000 | 0.0000 | ENUM('0') NOT NULL |
puroparty.wp_7_posts.post_type | attachment | post | 4 | 10 | 0 | 0 | 9.0000 | NULL | ENUM('attachment','page','post') NOT NULL |
puroparty.wp_7_posts.post_mime_type | image/jpeg | 0 | 10 | 3 | 0 | 8.3333 | NULL | ENUM('','image/jpeg') NOT NULL | |
puroparty.wp_7_posts.comment_count | 1 | 1 | 1 | 1 | 17 | 0 | 0.0556 | 0.2291 | ENUM('0','1') NOT NULL |