diff options
| author | Michael Foster <savetheinternet@tinyboard.org> | 2013-08-28 18:02:28 +1000 |
|---|---|---|
| committer | Michael Foster <savetheinternet@tinyboard.org> | 2013-08-28 18:02:28 +1000 |
| commit | 5aaa6887f647a2d16b5db995c434cea4ce98538d (patch) | |
| tree | 628edd022e3d8950b466ef28776f774be11b67ca /templates/posts.sql | |
| parent | fcb88b16cdf79f7f543f923b3d5fa39bbdbfb239 (diff) | |
Add `ip` index to post tables for faster ?/IP/ (and flood detection, etc.)
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 4eef3a0d..1e092985 100644 --- a/templates/posts.sql +++ b/templates/posts.sql @@ -28,6 +28,7 @@ CREATE TABLE IF NOT EXISTS ``posts_{{ board }}`` ( UNIQUE KEY `id` (`id`), KEY `thread_id` (`thread`,`id`), KEY `time` (`time`), - FULLTEXT KEY `body` (`body`) + FULLTEXT KEY `body` (`body`), + KEY `ip` (`ip`), ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=1 ;
\ No newline at end of file |