From 95709e7588b9fb5a2e43049e0157cedc254b2536 Mon Sep 17 00:00:00 2001
From: Michael Save <savetheinternet@tinyboard.org>
Date: Thu, 12 Apr 2012 23:23:47 +1000
Subject: Removed `board`.`id`. Use the board URI/name at the key instead.

---
 install.php | 27 +++++++++++++++++++++++++--
 1 file changed, 25 insertions(+), 2 deletions(-)

(limited to 'install.php')

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);
-- 
cgit v1.3