Host: mysql.puroparty.com
Database: puroparty
Generation Time: Apr 26, 2024 at 02:39 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 NULL |
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','2008-08-12 00:16:17','2008-08-12 00:17:35') NOT NULL |
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','2008-08-12 05:16:17','2008-08-12 05:17:35') NOT NULL |
puroparty.wp_3_posts.post_content | \r\n \r\n \r\n <!-- some minimal styling, can be removed -->\r\n \r\n\r\n\r\n\r\n \r\n \r\n /*\r\n use flashembed to place flowplayer into HTML element \r\n whose id is "example" (below this script tag)\r\n */\r\n flashembed("example", \r\n \r\n /* \r\n first argument supplies standard Flash parameters. See full list:\r\n http://kb.adobe.com/selfservice/viewContent.do?externalId=tn_12701\r\n */\r\n {\r\n src:'http://www.puroparty.com/flow/FlowPlayerLight.swf',\r\n width: 640, \r\n height: 480\r\n },\r\n \r\n /*\r\n second argument is Flowplayer specific configuration. See full list:\r\n http://flowplayer.org/player/configuration.html\r\n */\r\n {config: { \r\n autoPlay: false,\r\n loop: false,\r\n autoBuffering: true,\r\n controlBarBackgroundColor:'0x2e8860',\r\n initialScale: 'scale',\r\n controlsOverVideo: 'locked',\r\n controlBarBackgroundColor: -1,\r\n controlBarGloss: 'none',\r\n videoFile: 'http://www.puroparty.com/flow/examples/22_220001F.flv'\r\n }} \r\n );\r\n \r\n | [flv]config=%7Bembedded%3Atrue%2CbaseURL%3A%27http%3A%2F%2Fpuroparty%2Ecom%2Fflow%27%2CvideoFile%3A%27http%3A%2F%2Fwww%2Epuroparty%2Ecom%2Fflow%2Fexamples%2Fduffy%2Dwarwick%5Favenue%2Eflv%27%2CinitialScale%3A%27scale%27%2CcontrolBarBackgroundColor%3A%270x2e8860%27%2CautoBuffering%3Atrue%2CautoPlay%3Afalse%7D[/flv] | 4 | 951 | 2 | 0 | 184.5000 | NULL | ENUM('\r\n \r\n \r\n <!-- some minimal styling, can be removed -->\r\n \r\n\r\n\r\n\r\n \r\n \r\n /*\r\n use flashembed to place flowplayer into HTML element \r\n whose id is "example" (below this script tag)\r\n */\r\n flashembed("example", \r\n \r\n /* \r\n first argument supplies standard Flash parameters. See full list:\r\n http://kb.adobe.com/selfservice/viewContent.do?externalId=tn_12701\r\n */\r\n {\r\n src:\'http://www.puroparty.com/flow/FlowPlayerLight.swf\',\r\n width: 640, \r\n height: 480\r\n },\r\n \r\n /*\r\n second argument is Flowplayer specific configuration. See full list:\r\n http://flowplayer.org/player/configuration.html\r\n */\r\n {config: { \r\n autoPlay: false,\r\n loop: false,\r\n autoBuffering: true,\r\n controlBarBackgroundColor:\'0x2e8860\',\r\n initialScale: \'scale\',\r\n controlsOverVideo: \'locked\',\r\n controlBarBackgroundColor: -1,\r\n controlBarGloss: \'none\',\r\n videoFile: \'http://www.puroparty.com/flow/examples/22_220001F.flv\'\r\n }} \r\n );\r\n \r\n','\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n<A HREF="//www.puroparty.com/index.php\')">Open the Popup Window</A>','','Baby Boy - Ya No LLores (Let Me Love You) Music Video\r\n<code>\r\n\r\n</code>','spacer test','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!','[flv]config=%7Bembedded%3Atrue%2CbaseURL%3A%27http%3A%2F%2Fpuroparty%2Ecom%2Fflow%27%2CvideoFile%3A%27http%3A%2F%2Fwww%2Epuroparty%2Ecom%2Fflow%2Fexamples%2Fduffy%2Dwarwick%5Favenue%2Eflv%27%2CinitialScale%3A%27scale%27%2CcontrolBarBackgroundColor%3A%270x2e8860%27%2CautoBuffering%3Atrue%2CautoPlay%3Afalse%7D[/flv]') NOT NULL |
puroparty.wp_3_posts.post_title | Baby Boy - Ya No LLores (Let Me Love You) Music Video | test 45 | 4 | 54 | 0 | 0 | 11.2000 | NULL | ENUM(' Baby Boy - Ya No LLores (Let Me Love You) Music Video','About','blog 2','FLV Test','Hello world!','spacer 3','Test','test 45') NOT NULL |
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') NOT NULL |
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','2008-08-12 00:17:35','2008-08-17 17:16:56','2008-08-17 17:32:11','2008-08-17 18:24:19','2008-08-17 20:25:29','2008-09-01 16:37:05','2008-09-01 18:10:29') NOT NULL |
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','2008-08-12 05:17:35','2008-08-17 22:16:56','2008-08-17 22:32:11','2008-08-17 23:24:19','2008-08-18 01:25:29','2008-09-01 21:37:05','2008-09-01 23:10:29') NOT NULL |
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','http://puroparty.com/ppblogs/baba/?p=3','http://puroparty.com/ppblogs/baba/?p=4','http://puroparty.com/ppblogs/baba/?p=5','http://puroparty.com/ppblogs/baba/?p=6','http://puroparty.com/ppblogs/baba/?p=7','http://puroparty.com/ppblogs/baba/?p=8','http://puroparty.com/ppblogs/baba/?p=9') NOT NULL | |
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 |