diff options
| author | Michael Foster <savetheinternet@tinyboard.org> | 2013-09-01 02:04:42 +1000 |
|---|---|---|
| committer | Michael Foster <savetheinternet@tinyboard.org> | 2013-09-01 02:04:42 +1000 |
| commit | b51fc38783c1b93f1667ea4fb41a077de66dad49 (patch) | |
| tree | d6c8db4f1306c97189b8eff724b1bb307245db2f /templates/posts.sql | |
| parent | c567131ca703a8bda0c3b1ca83fa2cae5af863a4 (diff) | |
Some SQL and indexes improvements
Diffstat (limited to 'templates/posts.sql')
| -rw-r--r-- | templates/posts.sql | 2 |
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 |