summaryrefslogtreecommitdiff
path: root/install.sql
diff options
context:
space:
mode:
Diffstat (limited to 'install.sql')
-rw-r--r--install.sql3
1 files changed, 2 insertions, 1 deletions
diff --git a/install.sql b/install.sql
index 1980f8bb..2978b5c3 100644
--- a/install.sql
+++ b/install.sql
@@ -49,7 +49,8 @@ CREATE TABLE IF NOT EXISTS `bans` (
`board` varchar(58) CHARACTER SET utf8 DEFAULT NULL,
`seen` tinyint(1) NOT NULL,
PRIMARY KEY (`id`),
- KEY `ip` (`ip`)
+ KEY `ip` (`ip`),
+ KEY `seen` (`seen`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------