diff options
| author | Michael Save <savetheinternet@tinyboard.org> | 2012-04-12 23:23:47 +1000 |
|---|---|---|
| committer | Michael Save <savetheinternet@tinyboard.org> | 2012-04-12 23:23:47 +1000 |
| commit | 95709e7588b9fb5a2e43049e0157cedc254b2536 (patch) | |
| tree | e7732391f27c6789b00de0dad9b1b98d4d2d0b66 /install.php | |
| parent | c39c54c2c2764596863e43a6d6ee4b07b52af327 (diff) | |
Removed `board`.`id`. Use the board URI/name at the key instead.
Diffstat (limited to 'install.php')
| -rw-r--r-- | install.php | 27 |
1 files changed, 25 insertions, 2 deletions
diff --git a/install.php b/install.php index f67d4cb0..c4619431 100644 --- a/install.php +++ b/install.php @@ -1,7 +1,7 @@ <?php // Installation/upgrade file -define('VERSION', 'v0.9.6-dev-2'); +define('VERSION', 'v0.9.6-dev-3'); require 'inc/functions.php'; @@ -184,7 +184,30 @@ if(file_exists($config['has_installed'])) { `passed` smallint(6) NOT NULL, PRIMARY KEY (`hash`), KEY `board` (`board`,`thread`) - ) ENGINE=MyISAM DEFAULT CHARSET=utf8;"); + ) ENGINE=MyISAM DEFAULT CHARSET=utf8;") or error(db_error()); + case 'v0.9.6-dev-2': + query("ALTER TABLE `boards` + DROP `id`, + CHANGE `uri` `uri` VARCHAR( 120 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL") or error(db_error()); + query("ALTER TABLE `bans` CHANGE `board` `board` VARCHAR( 120 ) NULL DEFAULT NULL") or error(db_error()); + query("ALTER TABLE `reports` CHANGE `board` `board` VARCHAR( 120 ) NULL DEFAULT NULL") or error(db_error()); + query("ALTER TABLE `modlogs` CHANGE `board` `board` VARCHAR( 120 ) NULL DEFAULT NULL") or error(db_error()); + foreach($boards as $board) { + $query = prepare("UPDATE `bans` SET `board` = :newboard WHERE `board` = :oldboard"); + $query->bindValue(':newboard', $board['uri']); + $query->bindValue(':oldboard', $board['id']); + $query->execute() or error(db_error($query)); + + $query = prepare("UPDATE `modlogs` SET `board` = :newboard WHERE `board` = :oldboard"); + $query->bindValue(':newboard', $board['uri']); + $query->bindValue(':oldboard', $board['id']); + $query->execute() or error(db_error($query)); + + $query = prepare("UPDATE `reports` SET `board` = :newboard WHERE `board` = :oldboard"); + $query->bindValue(':newboard', $board['uri']); + $query->bindValue(':oldboard', $board['id']); + $query->execute() or error(db_error($query)); + } case false: // Update version number file_write($config['has_installed'], VERSION); |