summaryrefslogtreecommitdiff
path: root/templates/posts.sql
diff options
context:
space:
mode:
authorMarcin Łabanowski <marcin@6irc.net>2013-01-19 16:23:02 +0100
committerMarcin Łabanowski <marcin@6irc.net>2013-01-19 16:23:02 +0100
commit82fb733906e73fd348d961602144d91a9019b1ba (patch)
tree957e13b7e87b5a30f77b9f11231b9cef1b86fca6 /templates/posts.sql
parentfa0a79d99246bc82cac5640cf0ecdee214d6545f (diff)
parent27ee4d320c196a5490891831f615f2e871eb6782 (diff)
Merge branch 'master' of https://github.com/savetheinternet/Tinyboard
Diffstat (limited to 'templates/posts.sql')
-rw-r--r--templates/posts.sql2
1 files changed, 1 insertions, 1 deletions
diff --git a/templates/posts.sql b/templates/posts.sql
index d10749f8..c766d38e 100644
--- a/templates/posts.sql
+++ b/templates/posts.sql
@@ -26,7 +26,7 @@ CREATE TABLE IF NOT EXISTS `posts_{{ board }}` (
`sage` int(1) NOT NULL,
`embed` text,
UNIQUE KEY `id` (`id`),
- KEY `thread` (`thread`),
+ KEY `thread_id` (`thread`, `id`),
KEY `time` (`time`),
FULLTEXT KEY `body` (`body`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;