summaryrefslogtreecommitdiff
path: root/install.sql
diff options
context:
space:
mode:
Diffstat (limited to 'install.sql')
-rw-r--r--install.sql2
1 files changed, 1 insertions, 1 deletions
diff --git a/install.sql b/install.sql
index 2978b5c3..a3c03cb1 100644
--- a/install.sql
+++ b/install.sql
@@ -101,7 +101,7 @@ CREATE TABLE IF NOT EXISTS `ip_notes` (
`time` int(11) NOT NULL,
`body` text NOT NULL,
UNIQUE KEY `id` (`id`),
- KEY `ip` (`ip`)
+ KEY `ip_lookup` (`ip`, `time`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------