diff options
Diffstat (limited to 'install.sql')
| -rw-r--r-- | install.sql | 7 |
1 files changed, 5 insertions, 2 deletions
diff --git a/install.sql b/install.sql index af5b3f29..210ead99 100644 --- a/install.sql +++ b/install.sql @@ -209,8 +209,11 @@ CREATE TABLE IF NOT EXISTS `posts_b` ( `sticky` int(1) NOT NULL, `locked` int(1) NOT NULL, `embed` text, - UNIQUE KEY `id` (`id`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; + UNIQUE KEY `id` (`id`), + KEY `thread` (`thread`), + KEY `time` (`time`), + FULLTEXT KEY `body` (`body`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -- Dumping data for table `posts_b` |