diff options
| author | Michael Foster <savetheinternet@tinyboard.org> | 2013-09-17 09:23:50 +1000 |
|---|---|---|
| committer | Michael Foster <savetheinternet@tinyboard.org> | 2013-09-17 09:23:50 +1000 |
| commit | c7c297b8a6f526a467f0f3bd8044e02d481db63a (patch) | |
| tree | f7f1fdc991676f6ce4a6dfaad571c008782dda18 /install.sql | |
| parent | f53348d7c8b4f9bc5bb29850faec80c91954e7f1 (diff) | |
Finish upgrade to new bans table
Diffstat (limited to 'install.sql')
| -rw-r--r-- | install.sql | 20 |
1 files changed, 11 insertions, 9 deletions
diff --git a/install.sql b/install.sql index 22bdeb55..462cd2f0 100644 --- a/install.sql +++ b/install.sql @@ -40,18 +40,20 @@ CREATE TABLE IF NOT EXISTS `antispam` ( -- CREATE TABLE IF NOT EXISTS `bans` ( - `id` int(11) unsigned NOT NULL AUTO_INCREMENT, - `ip` varchar(39) CHARACTER SET ascii NOT NULL, - `mod` int(11) NOT NULL COMMENT 'which mod made the ban', - `set` int(11) NOT NULL, - `expires` int(11) DEFAULT NULL, + `id` int(10) unsigned NOT NULL AUTO_INCREMENT, + `ipstart` varbinary(16) NOT NULL, + `ipend` varbinary(16) DEFAULT NULL, + `created` int(10) unsigned NOT NULL, + `expires` int(10) unsigned DEFAULT NULL, + `board` varchar(58) DEFAULT NULL, + `creator` int(10) NOT NULL, `reason` text, - `board` varchar(58) CHARACTER SET utf8 DEFAULT NULL, `seen` tinyint(1) NOT NULL, + `post` blob, PRIMARY KEY (`id`), - KEY `ip` (`ip`), - KEY `seen` (`seen`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=1 ; + KEY `expires` (`expires`), + KEY `ipstart` (`ipstart`,`ipend`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- |