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

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

(limited to 'templates/posts.sql')

diff --git a/templates/posts.sql b/templates/posts.sql
index 917398bd..6e691044 100644
--- a/templates/posts.sql
+++ b/templates/posts.sql
@@ -23,5 +23,8 @@ CREATE TABLE IF NOT EXISTS `posts_{board}` (
   `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 ;
-- 
cgit v1.3