Advertisement
Guest User

dbaf_wp_posts

a guest
Nov 9th, 2011
416
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 8.08 KB | None | 0 0
  1. /*
  2.  
  3. Source Server : localhost
  4. Source Server Type : MySQL
  5. Source Server Version : 50144
  6. Source Host : localhost
  7. Source Database : wp
  8.  
  9. Target Server Type : MySQL
  10. Target Server Version : 50144
  11. File Encoding : utf-8
  12.  
  13. Date: 11/09/2011 11:34:37 AM
  14. */
  15.  
  16. SET NAMES utf8;
  17. SET FOREIGN_KEY_CHECKS = 0;
  18.  
  19. -- ----------------------------
  20. -- Table structure for `wp_posts`
  21. -- ----------------------------
  22. DROP TABLE IF EXISTS `wp_posts`;
  23. CREATE TABLE `wp_posts` (
  24. `ID` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  25. `post_author` bigint(20) unsigned NOT NULL DEFAULT '0',
  26. `post_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  27. `post_date_gmt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  28. `post_content` longtext NOT NULL,
  29. `post_title` text NOT NULL,
  30. `post_excerpt` text NOT NULL,
  31. `post_status` varchar(20) NOT NULL DEFAULT 'publish',
  32. `comment_status` varchar(20) NOT NULL DEFAULT 'open',
  33. `ping_status` varchar(20) NOT NULL DEFAULT 'open',
  34. `post_password` varchar(20) NOT NULL DEFAULT '',
  35. `post_name` varchar(200) NOT NULL DEFAULT '',
  36. `to_ping` text NOT NULL,
  37. `pinged` text NOT NULL,
  38. `post_modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  39. `post_modified_gmt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  40. `post_content_filtered` text NOT NULL,
  41. `post_parent` bigint(20) unsigned NOT NULL DEFAULT '0',
  42. `guid` varchar(255) NOT NULL DEFAULT '',
  43. `menu_order` int(11) NOT NULL DEFAULT '0',
  44. `post_type` varchar(20) NOT NULL DEFAULT 'post',
  45. `post_mime_type` varchar(100) NOT NULL DEFAULT '',
  46. `comment_count` bigint(20) NOT NULL DEFAULT '0',
  47. PRIMARY KEY (`ID`),
  48. KEY `post_name` (`post_name`),
  49. KEY `type_status_date` (`post_type`,`post_status`,`post_date`,`ID`),
  50. KEY `post_parent` (`post_parent`),
  51. KEY `post_author` (`post_author`)
  52. ) ENGINE=MyISAM AUTO_INCREMENT=34 DEFAULT CHARSET=utf8;
  53.  
  54. -- ----------------------------
  55. -- Records of `wp_posts`
  56. -- ----------------------------
  57. BEGIN;
  58. INSERT INTO `wp_posts` VALUES ('3', '1', '2011-11-09 08:45:03', '0000-00-00 00:00:00', '', 'Auto Draft', '', 'auto-draft', 'open', 'open', '', '', '', '', '2011-11-09 08:45:03', '0000-00-00 00:00:00', '', '0', 'http://wp.local/?p=3', '0', 'post', '', '0'), ('5', '1', '2011-11-09 08:47:07', '2011-11-09 08:47:07', 'p 1', 'p 1', '', 'publish', 'open', 'open', '', 'p-1', '', '', '2011-11-09 08:47:07', '2011-11-09 08:47:07', '', '0', 'http://wp.local/?p=5', '0', 'post', '', '0'), ('6', '1', '2011-11-09 08:46:43', '2011-11-09 08:46:43', '', 'p 1', '', 'inherit', 'open', 'open', '', '5-revision', '', '', '2011-11-09 08:46:43', '2011-11-09 08:46:43', '', '5', 'http://wp.local/?p=6', '0', 'revision', '', '0'), ('7', '1', '2011-11-09 08:47:22', '2011-11-09 08:47:22', 'p 2', 'p 2', '', 'publish', 'open', 'open', '', 'p-2', '', '', '2011-11-09 08:47:22', '2011-11-09 08:47:22', '', '0', 'http://wp.local/?p=7', '0', 'post', '', '0'), ('8', '1', '2011-11-09 08:47:14', '2011-11-09 08:47:14', '', 'p 2', '', 'inherit', 'open', 'open', '', '7-revision', '', '', '2011-11-09 08:47:14', '2011-11-09 08:47:14', '', '7', 'http://wp.local/?p=8', '0', 'revision', '', '0'), ('9', '1', '2011-11-09 08:47:52', '2011-11-09 08:47:52', 'p 3', 'p 3', '', 'publish', 'open', 'open', '', 'p-3', '', '', '2011-11-09 08:47:52', '2011-11-09 08:47:52', '', '0', 'http://wp.local/?p=9', '0', 'post', '', '0'), ('10', '1', '2011-11-09 08:47:48', '2011-11-09 08:47:48', '', 'p 3', '', 'inherit', 'open', 'open', '', '9-revision', '', '', '2011-11-09 08:47:48', '2011-11-09 08:47:48', '', '9', 'http://wp.local/?p=10', '0', 'revision', '', '0'), ('11', '1', '2011-11-09 08:48:05', '2011-11-09 08:48:05', 'p 4', 'p 4', '', 'publish', 'open', 'open', '', 'p-4', '', '', '2011-11-09 08:48:05', '2011-11-09 08:48:05', '', '0', 'http://wp.local/?p=11', '0', 'post', '', '0'), ('12', '1', '2011-11-09 08:48:00', '2011-11-09 08:48:00', '', 'p 4', '', 'inherit', 'open', 'open', '', '11-revision', '', '', '2011-11-09 08:48:00', '2011-11-09 08:48:00', '', '11', 'http://wp.local/?p=12', '0', 'revision', '', '0'), ('13', '1', '2011-11-09 08:48:18', '2011-11-09 08:48:18', 'p 5', 'p 5', '', 'publish', 'open', 'open', '', 'p-5', '', '', '2011-11-09 08:48:18', '2011-11-09 08:48:18', '', '0', 'http://wp.local/?p=13', '0', 'post', '', '0'), ('14', '1', '2011-11-09 08:48:13', '2011-11-09 08:48:13', '', 'p 5', '', 'inherit', 'open', 'open', '', '13-revision', '', '', '2011-11-09 08:48:13', '2011-11-09 08:48:13', '', '13', 'http://wp.local/?p=14', '0', 'revision', '', '0'), ('15', '1', '2011-11-09 08:48:30', '2011-11-09 08:48:30', 'p 6', 'p 6', '', 'publish', 'open', 'open', '', 'p-6', '', '', '2011-11-09 08:48:30', '2011-11-09 08:48:30', '', '0', 'http://wp.local/?p=15', '0', 'post', '', '0'), ('16', '1', '2011-11-09 08:48:26', '2011-11-09 08:48:26', '', 'p 6', '', 'inherit', 'open', 'open', '', '15-revision', '', '', '2011-11-09 08:48:26', '2011-11-09 08:48:26', '', '15', 'http://wp.local/?p=16', '0', 'revision', '', '0'), ('17', '1', '2011-11-09 08:48:45', '2011-11-09 08:48:45', 'p 7', 'p 7', '', 'publish', 'open', 'open', '', 'p-7', '', '', '2011-11-09 08:48:45', '2011-11-09 08:48:45', '', '0', 'http://wp.local/?p=17', '0', 'post', '', '0'), ('18', '1', '2011-11-09 08:48:41', '2011-11-09 08:48:41', '', 'p 7', '', 'inherit', 'open', 'open', '', '17-revision', '', '', '2011-11-09 08:48:41', '2011-11-09 08:48:41', '', '17', 'http://wp.local/?p=18', '0', 'revision', '', '0'), ('19', '1', '2011-11-09 08:48:57', '2011-11-09 08:48:57', 'p 8', 'p 8', '', 'publish', 'open', 'open', '', 'p-8', '', '', '2011-11-09 08:48:57', '2011-11-09 08:48:57', '', '0', 'http://wp.local/?p=19', '0', 'post', '', '0'), ('20', '1', '2011-11-09 08:48:52', '2011-11-09 08:48:52', '', 'p 8', '', 'inherit', 'open', 'open', '', '19-revision', '', '', '2011-11-09 08:48:52', '2011-11-09 08:48:52', '', '19', 'http://wp.local/?p=20', '0', 'revision', '', '0'), ('21', '1', '2011-11-09 08:49:10', '2011-11-09 08:49:10', 'p 9', 'p 9', '', 'publish', 'open', 'open', '', 'p-9', '', '', '2011-11-09 08:49:10', '2011-11-09 08:49:10', '', '0', 'http://wp.local/?p=21', '0', 'post', '', '0'), ('22', '1', '2011-11-09 08:49:05', '2011-11-09 08:49:05', '', 'p 9', '', 'inherit', 'open', 'open', '', '21-revision', '', '', '2011-11-09 08:49:05', '2011-11-09 08:49:05', '', '21', 'http://wp.local/?p=22', '0', 'revision', '', '0'), ('23', '1', '2011-11-09 08:49:23', '2011-11-09 08:49:23', 'p 10', 'p 10', '', 'publish', 'open', 'open', '', 'p-10', '', '', '2011-11-09 08:49:23', '2011-11-09 08:49:23', '', '0', 'http://wp.local/?p=23', '0', 'post', '', '0'), ('24', '1', '2011-11-09 08:49:18', '2011-11-09 08:49:18', '', 'p 10', '', 'inherit', 'open', 'open', '', '23-revision', '', '', '2011-11-09 08:49:18', '2011-11-09 08:49:18', '', '23', 'http://wp.local/?p=24', '0', 'revision', '', '0'), ('25', '1', '2011-11-09 08:49:35', '2011-11-09 08:49:35', 'p 11', 'p 11', '', 'publish', 'open', 'open', '', 'p-11', '', '', '2011-11-09 08:49:35', '2011-11-09 08:49:35', '', '0', 'http://wp.local/?p=25', '0', 'post', '', '0'), ('26', '1', '2011-11-09 08:49:31', '2011-11-09 08:49:31', '', 'p 11', '', 'inherit', 'open', 'open', '', '25-revision', '', '', '2011-11-09 08:49:31', '2011-11-09 08:49:31', '', '25', 'http://wp.local/?p=26', '0', 'revision', '', '0'), ('27', '1', '2011-11-09 08:52:35', '2011-11-09 08:52:35', ' ', '', '', 'publish', 'open', 'open', '', '27', '', '', '2011-11-09 08:52:35', '2011-11-09 08:52:35', '', '0', 'http://wp.local/?p=27', '1', 'nav_menu_item', '', '0'), ('28', '1', '2011-11-09 08:52:35', '2011-11-09 08:52:35', ' ', '', '', 'publish', 'open', 'open', '', '28', '', '', '2011-11-09 08:52:35', '2011-11-09 08:52:35', '', '1', 'http://wp.local/?p=28', '2', 'nav_menu_item', '', '0'), ('29', '1', '2011-11-09 08:52:35', '2011-11-09 08:52:35', ' ', '', '', 'publish', 'open', 'open', '', '29', '', '', '2011-11-09 08:52:35', '2011-11-09 08:52:35', '', '1', 'http://wp.local/?p=29', '3', 'nav_menu_item', '', '0'), ('30', '1', '2011-11-09 08:52:35', '2011-11-09 08:52:35', ' ', '', '', 'publish', 'open', 'open', '', '30', '', '', '2011-11-09 08:52:35', '2011-11-09 08:52:35', '', '1', 'http://wp.local/?p=30', '4', 'nav_menu_item', '', '0');
  59. COMMIT;
  60.  
  61.  
  62.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement