summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorMichael Save <savetheinternet@tinyboard.org>2013-01-19 18:47:01 +1100
committerMichael Save <savetheinternet@tinyboard.org>2013-01-19 18:47:01 +1100
commit7b02357e235aaab0bfa2feb7bad85300885ef258 (patch)
tree5178602444fc86f401b8c6069677b76b76c601b4
parent5c4421b4fd48d082ad35aff1bfc642e9e4047aad (diff)
parentf01813d95b2e39fc938262a3aca6986d97c7da6b (diff)
Merge branch 'newkey' of https://github.com/Macil/Tinyboard
-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 ;