| 1 | CREATE TABLE IF NOT EXISTS `wp_search_index` ( |
|---|
| 2 | `id` bigint(20) NOT NULL auto_increment, |
|---|
| 3 | `object` bigint(20) NOT NULL, |
|---|
| 4 | `title` text NOT NULL, |
|---|
| 5 | `content` text NOT NULL, |
|---|
| 6 | `post_date` datetime NOT NULL, |
|---|
| 7 | `parent` bigint(20) NOT NULL, |
|---|
| 8 | `categories` text NOT NULL, |
|---|
| 9 | `tags` text NOT NULL, |
|---|
| 10 | `author` text NOT NULL, |
|---|
| 11 | `type` varchar(50) NOT NULL, |
|---|
| 12 | `protected` smallint(6) NOT NULL, |
|---|
| 13 | PRIMARY KEY (`id`), |
|---|
| 14 | FULLTEXT KEY `title` (`title`), |
|---|
| 15 | FULLTEXT KEY `content` (`content`), |
|---|
| 16 | FULLTEXT KEY `title_and_content` (`title`,`content`) |
|---|
| 17 | ) |
|---|