m8r4myXJ

1-- Table structure for table `mjevsty0u1_posts`
2--
3
4DROP TABLE IF EXISTS `mjevsty0u1_posts`;
5/*!40101 SET @saved_cs_client     = @@character_set_client */;
6/*!40101 SET character_set_client = utf8 */;
7CREATE TABLE `mjevsty0u1_posts` (
8  `ID` bigint(20) unsigned NOT NULL auto_increment,
9  `post_author` bigint(20) unsigned NOT NULL default '0',
10  `post_date` datetime NOT NULL default '0000-00-00 00:00:00',
11  `post_date_gmt` datetime NOT NULL default '0000-00-00 00:00:00',
12  `post_content` longtext NOT NULL,
13  `post_title` text NOT NULL,
14  `post_category` int(4) NOT NULL default '0',
15  `post_excerpt` text NOT NULL,
16  `post_status` varchar(20) NOT NULL default 'publish',
17  `comment_status` varchar(20) NOT NULL default 'open',
18  `ping_status` varchar(20) NOT NULL default 'open',
19  `post_password` varchar(20) NOT NULL default '',
20  `post_name` varchar(200) NOT NULL default '',
21  `to_ping` text NOT NULL,
22  `pinged` text NOT NULL,
23  `post_modified` datetime NOT NULL default '0000-00-00 00:00:00',
24  `post_modified_gmt` datetime NOT NULL default '0000-00-00 00:00:00',
25  `post_content_filtered` text NOT NULL,
26  `post_parent` bigint(20) unsigned NOT NULL default '0',
27  `guid` varchar(255) NOT NULL default '',
28  `menu_order` int(11) NOT NULL default '0',
29  `post_type` varchar(20) NOT NULL default 'post',
30  `post_mime_type` varchar(100) NOT NULL default '',
31  `comment_count` bigint(20) NOT NULL default '0',
32  `robotsmeta` varchar(64) default NULL,
33  PRIMARY KEY  (`ID`),
34  KEY `post_name` (`post_name`),
35  KEY `type_status_date` (`post_type`,`post_status`,`post_date`,`ID`),
36  KEY `post_date` (`post_date`),
37  KEY `post_date_gmt` (`post_date_gmt`),
38  KEY `post_parent` (`post_parent`),
39  KEY `post_author` (`post_author`),
40  FULLTEXT KEY `yarpp_title` (`post_title`),
41  FULLTEXT KEY `yarpp_content` (`post_content`),
42  FULLTEXT KEY `wp_greet_box_post_related` (`post_title`,`post_content`)
43) ENGINE=MyISAM AUTO_INCREMENT=4655 DEFAULT CHARSET=utf8;
44/*!40101 SET character_set_client = @saved_cs_client */;