diff options
| author | Savetheinternet <savetheinternet@tinyboard.org> | 2011-08-04 15:47:34 +1000 |
|---|---|---|
| committer | Savetheinternet <savetheinternet@tinyboard.org> | 2011-08-04 15:47:34 +1000 |
| commit | c4c6a9839645c49a981de6f9dcf82fe0c7a0c739 (patch) | |
| tree | 08ca02da3f80f2830bd8aba1937a77ee0a6eda43 /install.sql | |
| parent | 1fe672fed203c30772b7959050648ed9d75a4c42 (diff) | |
various bug fixed, introduced ban ID, temporarily broke caching bans with memcached
Diffstat (limited to 'install.sql')
| -rw-r--r-- | install.sql | 7 |
1 files changed, 5 insertions, 2 deletions
diff --git a/install.sql b/install.sql index dfdb62f0..508de215 100644 --- a/install.sql +++ b/install.sql @@ -19,13 +19,16 @@ SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; -- CREATE TABLE IF NOT EXISTS `bans` ( + `id` int(11) NOT NULL AUTO_INCREMENT, `ip` varchar(45) NOT NULL, `mod` int(11) NOT NULL COMMENT 'which mod made the ban', `set` int(11) NOT NULL, `expires` int(11) DEFAULT NULL, `reason` text, - `board` smallint(6) DEFAULT NULL -) ENGINE=InnoDB DEFAULT CHARSET=utf8; + `board` smallint(6) DEFAULT NULL, + PRIMARY KEY (`id`), + UNIQUE KEY `id` (`id`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ; -- -- Dumping data for table `bans` |