diff options
Diffstat (limited to 'templates/posts.sql')
| -rw-r--r-- | templates/posts.sql | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/templates/posts.sql b/templates/posts.sql index b35865ca..c1f491f2 100644 --- a/templates/posts.sql +++ b/templates/posts.sql @@ -29,6 +29,7 @@ CREATE TABLE IF NOT EXISTS ``posts_{{ board }}`` ( KEY `thread_id` (`thread`,`id`), KEY `filehash` (`filehash`(40)), KEY `time` (`time`), - 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 |