summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorMichael Foster <savetheinternet@tinyboard.org>2013-09-01 09:57:09 +1000
committerMichael Foster <savetheinternet@tinyboard.org>2013-09-01 09:57:09 +1000
commitcf3173d226271c59eab1fe841baec6ec309771f3 (patch)
tree30acfea2587f45c9931ec297bf67f453be4a2929
parentb51fc38783c1b93f1667ea4fb41a077de66dad49 (diff)
Fix issue #136
-rw-r--r--templates/posts.sql2
1 files changed, 1 insertions, 1 deletions
diff --git a/templates/posts.sql b/templates/posts.sql
index 0b0e32b9..b35865ca 100644
--- a/templates/posts.sql
+++ b/templates/posts.sql
@@ -27,7 +27,7 @@ CREATE TABLE IF NOT EXISTS ``posts_{{ board }}`` (
`embed` text,
UNIQUE KEY `id` (`id`),
KEY `thread_id` (`thread`,`id`),
- KEY `filehash` (`filehash`),
+ KEY `filehash` (`filehash`(40)),
KEY `time` (`time`),
KEY `ip` (`ip`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=1 ;