From e36cce7903210153c6d02d0dca1be967d73c6561 Mon Sep 17 00:00:00 2001 From: Michael Foster Date: Sat, 21 Sep 2013 13:01:30 +1000 Subject: schema for ban appeals --- install.php | 12 +++++++++++- 1 file changed, 11 insertions(+), 1 deletion(-) (limited to 'install.php') 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); -- cgit v1.3 From 0f777519e306af50d576adc9b4967aeeba1440dc Mon Sep 17 00:00:00 2001 From: Michael Foster Date: Sat, 21 Sep 2013 13:02:44 +1000 Subject: forgot to increment version number --- install.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'install.php') diff --git a/install.php b/install.php index 5b72f51b..2aac065c 100644 --- a/install.php +++ b/install.php @@ -1,7 +1,7 @@ Date: Fri, 27 Sep 2013 20:17:21 +0200 Subject: install.php: fixed a typo --- install.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'install.php') diff --git a/install.php b/install.php index 2aac065c..5b65823c 100644 --- a/install.php +++ b/install.php @@ -13,7 +13,7 @@ $page = array( 'nojavascript' => true ); -// this breaks the dispaly of licenses if enabled +// this breaks the display of licenses if enabled $config['minify_html'] = false; if (file_exists($config['has_installed'])) { -- cgit v1.3