From ecd02144da9a1f233837c17282be1842d2fe0708 Mon Sep 17 00:00:00 2001
From: Savetheinternet <savetheinternet@tinyboard.org>
Date: Sat, 10 Sep 2011 22:26:52 +1000
Subject: Use MyISAM instead of InnoDB

---
 install.php | 15 ++++++++++++++-
 1 file changed, 14 insertions(+), 1 deletion(-)

(limited to 'install.php')

diff --git a/install.php b/install.php
index baac2cc4..160492cd 100644
--- a/install.php
+++ b/install.php
@@ -1,6 +1,6 @@
 <?php
 	// Installation/upgrade file	
-	define('VERSION', 'v0.9.3-dev-6');
+	define('VERSION', 'v0.9.3-dev-7');
 	
 	require 'inc/functions.php';
 	require 'inc/display.php';
@@ -91,6 +91,19 @@
 					// Increase subject field size
 					query(sprintf("ALTER TABLE `posts_%s` CHANGE  `subject` `subject` VARCHAR( 100 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL", $_board['uri'])) or error(db_error());
 				}
+			case 'v0.9.3-dev-6':
+				// change to MyISAM
+				$tables = Array(
+					'bans', 'boards', 'ip_notes', 'modlogs', 'mods', 'mutes', 'noticeboard', 'pms', 'reports', 'robot', 'theme_settings', 'news'
+				);
+				$boards = listBoards();
+				foreach($boards as &$board) {
+					$tables[] = "posts_{$board['uri']}";
+				}
+				
+				foreach($tables as &$table) {
+					query("ALTER TABLE  `{$table}` ENGINE = MYISAM DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci");
+				}				
 			case false:
 				// Update version number
 				file_write($config['has_installed'], VERSION);
-- 
cgit v1.3