summaryrefslogtreecommitdiff
path: root/templates/posts.sql
diff options
context:
space:
mode:
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 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