Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- /*
- Source Server : localhost
- Source Server Type : MySQL
- Source Server Version : 50144
- Source Host : localhost
- Source Database : wp
- Target Server Type : MySQL
- Target Server Version : 50144
- File Encoding : utf-8
- Date: 11/09/2011 11:34:37 AM
- */
- SET NAMES utf8;
- SET FOREIGN_KEY_CHECKS = 0;
- -- ----------------------------
- -- Table structure for `wp_posts`
- -- ----------------------------
- DROP TABLE IF EXISTS `wp_posts`;
- CREATE TABLE `wp_posts` (
- `ID` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
- `post_author` bigint(20) unsigned NOT NULL DEFAULT '0',
- `post_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
- `post_date_gmt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
- `post_content` longtext NOT NULL,
- `post_title` text NOT NULL,
- `post_excerpt` text NOT NULL,
- `post_status` varchar(20) NOT NULL DEFAULT 'publish',
- `comment_status` varchar(20) NOT NULL DEFAULT 'open',
- `ping_status` varchar(20) NOT NULL DEFAULT 'open',
- `post_password` varchar(20) NOT NULL DEFAULT '',
- `post_name` varchar(200) NOT NULL DEFAULT '',
- `to_ping` text NOT NULL,
- `pinged` text NOT NULL,
- `post_modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
- `post_modified_gmt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
- `post_content_filtered` text NOT NULL,
- `post_parent` bigint(20) unsigned NOT NULL DEFAULT '0',
- `guid` varchar(255) NOT NULL DEFAULT '',
- `menu_order` int(11) NOT NULL DEFAULT '0',
- `post_type` varchar(20) NOT NULL DEFAULT 'post',
- `post_mime_type` varchar(100) NOT NULL DEFAULT '',
- `comment_count` bigint(20) NOT NULL DEFAULT '0',
- PRIMARY KEY (`ID`),
- KEY `post_name` (`post_name`),
- KEY `type_status_date` (`post_type`,`post_status`,`post_date`,`ID`),
- KEY `post_parent` (`post_parent`),
- KEY `post_author` (`post_author`)
- ) ENGINE=MyISAM AUTO_INCREMENT=34 DEFAULT CHARSET=utf8;
- -- ----------------------------
- -- Records of `wp_posts`
- -- ----------------------------
- BEGIN;
- 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');
- COMMIT;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement