UgFYCFAj

1DROP TABLE IF EXISTS `wp_4_posts`;
2/*!40101 SET @saved_cs_client     = @@character_set_client */;
3/*!40101 SET character_set_client = utf8 */;
4CREATE TABLE `wp_4_posts` (
5  `ID` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
6  `post_author` bigint(20) unsigned NOT NULL DEFAULT '0',
7  `post_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
8  `post_date_gmt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
9  `post_content` longtext NOT NULL,
10  `post_title` longtext NOT NULL,
11  `post_excerpt` text NOT NULL,
12  `post_status` varchar(20) NOT NULL DEFAULT 'publish',
13  `comment_status` varchar(20) NOT NULL DEFAULT 'open',
14  `ping_status` varchar(20) NOT NULL DEFAULT 'open',
15  `post_password` varchar(20) NOT NULL DEFAULT '',
16  `post_name` varchar(200) NOT NULL DEFAULT '',
17  `to_ping` text NOT NULL,
18  `pinged` text NOT NULL,
19  `post_modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
20  `post_modified_gmt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
21  `post_content_filtered` longtext NOT NULL,
22  `post_parent` bigint(20) unsigned NOT NULL DEFAULT '0',
23  `guid` varchar(255) NOT NULL DEFAULT '',
24  `menu_order` int(11) NOT NULL DEFAULT '0',
25  `post_type` varchar(20) NOT NULL DEFAULT 'post',
26  `post_mime_type` varchar(100) NOT NULL DEFAULT '',
27  `comment_count` bigint(20) NOT NULL DEFAULT '0',
28  PRIMARY KEY (`ID`),
29  KEY `post_name` (`post_name`(191)),
30  KEY `type_status_date` (`post_type`,`post_status`,`post_date`,`ID`),
31  KEY `post_parent` (`post_parent`),
32  KEY `post_author` (`post_author`)
33) ENGINE=InnoDB AUTO_INCREMENT=468 DEFAULT CHARSET=utf8;
34/*!40101 SET character_set_client = @saved_cs_client */;
35
36--
37-- Dumping data for table `wp_4_posts`
38--
39
40LOCK TABLES `wp_4_posts` WRITE;
41/*!40000 ALTER TABLE `wp_4_posts` DISABLE KEYS */;