CREATE TABLE IF NOT EXISTS `wp_search_index` (
  `id` bigint(20) NOT NULL auto_increment,
  `object` bigint(20) NOT NULL,
  `title` text NOT NULL,
  `content` text NOT NULL,
  `post_date` datetime NOT NULL,
  `parent` bigint(20) NOT NULL,
  `categories` text NOT NULL,
  `tags` text NOT NULL,
  `author` text NOT NULL,
  `type` varchar(50) NOT NULL,
  `protected` smallint(6) NOT NULL,
  PRIMARY KEY  (`id`),
  FULLTEXT KEY `title` (`title`),
  FULLTEXT KEY `content` (`content`),
  FULLTEXT KEY `title_and_content` (`title`,`content`)
)