From 5aaa6887f647a2d16b5db995c434cea4ce98538d Mon Sep 17 00:00:00 2001 From: Michael Foster Date: Wed, 28 Aug 2013 18:02:28 +1000 Subject: Add `ip` index to post tables for faster ?/IP/ (and flood detection, etc.) --- templates/posts.sql | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) (limited to 'templates/posts.sql') 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 -- cgit v1.3