diff options
| author | Michael Foster <savetheinternet@tinyboard.org> | 2013-09-21 13:01:30 +1000 |
|---|---|---|
| committer | Michael Foster <savetheinternet@tinyboard.org> | 2013-09-21 13:01:30 +1000 |
| commit | e36cce7903210153c6d02d0dca1be967d73c6561 (patch) | |
| tree | ccbc90c0acc6373c8139ae21f5c926fd6e64d3ac /install.php | |
| parent | 902da76433fbcedc083971f60c4e4fbd7a100b6e (diff) | |
schema for ban appeals
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); |