WordPress.org

Make WordPress Core

Ticket #10667: schema.txt

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

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

Line 
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`)
17)