diff options
Diffstat (limited to 'install.php')
| -rw-r--r-- | install.php | 12 |
1 files changed, 11 insertions, 1 deletions
diff --git a/install.php b/install.php index c39f62dd..5b72f51b 100644 --- a/install.php +++ b/install.php @@ -413,7 +413,7 @@ if (file_exists($config['has_installed'])) { query("UPDATE ``mods`` SET `type` = 30 WHERE `type` = 2") or error(db_error()); query("ALTER TABLE ``mods`` CHANGE `type` `type` smallint(1) NOT NULL") or error(db_error()); case 'v0.9.6-dev-20': - query("CREATE TABLE IF NOT EXISTS `bans_new_temp` ( + __query("CREATE TABLE IF NOT EXISTS `bans_new_temp` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `ipstart` varbinary(16) NOT NULL, `ipend` varbinary(16) DEFAULT NULL, @@ -472,6 +472,16 @@ if (file_exists($config['has_installed'])) { query("DROP TABLE ``bans``") or error(db_error()); // Replace with new table query("RENAME TABLE ``bans_new_temp`` TO ``bans``") or error(db_error()); + case 'v0.9.6-dev-21': + __query("CREATE TABLE IF NOT EXISTS ``ban_appeals`` ( + `id` int(10) unsigned NOT NULL AUTO_INCREMENT, + `ban_id` int(10) unsigned NOT NULL, + `time` int(10) unsigned NOT NULL, + `message` text NOT NULL, + `denied` tinyint(1) NOT NULL, + PRIMARY KEY (`id`), + KEY `ban_id` (`ban_id`) + ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=1 ;") or error(db_error()); case false: // Update version number file_write($config['has_installed'], VERSION); |