From b51fc38783c1b93f1667ea4fb41a077de66dad49 Mon Sep 17 00:00:00 2001 From: Michael Foster Date: Sun, 1 Sep 2013 02:04:42 +1000 Subject: Some SQL and indexes improvements --- templates/posts.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'templates/posts.sql') diff --git a/templates/posts.sql b/templates/posts.sql index e41a7f38..0b0e32b9 100644 --- a/templates/posts.sql +++ b/templates/posts.sql @@ -27,8 +27,8 @@ CREATE TABLE IF NOT EXISTS ``posts_{{ board }}`` ( `embed` text, UNIQUE KEY `id` (`id`), KEY `thread_id` (`thread`,`id`), + KEY `filehash` (`filehash`), KEY `time` (`time`), - FULLTEXT KEY `body` (`body`), KEY `ip` (`ip`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=1 ; \ No newline at end of file -- cgit v1.3