From 55743a77054f1a5a5157856bd2c11751892653d2 Mon Sep 17 00:00:00 2001
From: Savetheinternet <savetheinternet@tinyboard.org>
Date: Sun, 2 Oct 2011 23:34:31 +1100
Subject: add indexes

---
 install.sql | 7 +++++--
 1 file changed, 5 insertions(+), 2 deletions(-)

(limited to 'install.sql')

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`
-- 
cgit v1.3