Make WordPress Core

Ticket #10667: schema.txt

File schema.txt, 553 bytes (added by jshreve, 6 years ago)

The schema is included in the installer code but I'm providing it for reference

1CREATE 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`)