diff options
Diffstat (limited to 'templates/posts.sql')
| -rw-r--r-- | templates/posts.sql | 5 |
1 files changed, 3 insertions, 2 deletions
diff --git a/templates/posts.sql b/templates/posts.sql index e41a7f38..c1f491f2 100644 --- a/templates/posts.sql +++ b/templates/posts.sql @@ -27,8 +27,9 @@ CREATE TABLE IF NOT EXISTS ``posts_{{ board }}`` ( `embed` text, UNIQUE KEY `id` (`id`), KEY `thread_id` (`thread`,`id`), + KEY `filehash` (`filehash`(40)), KEY `time` (`time`), - FULLTEXT KEY `body` (`body`), - KEY `ip` (`ip`) + KEY `ip` (`ip`), + KEY `list_threads` (`thread`, `sticky`, `bump`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=1 ;
\ No newline at end of file |