From 7b0dbb4a8a57b1ee3ab3dc5abb871311ae434d7f Mon Sep 17 00:00:00 2001
From: Patrick Davison <snapwilliam@gmail.com>
Date: Wed, 29 May 2013 22:46:09 -0700
Subject: SQL updates.

---
 db updates.sql | 32 +++++++++++++++++++++++++++++---
 1 file changed, 29 insertions(+), 3 deletions(-)

(limited to 'db updates.sql')

diff --git a/db updates.sql b/db updates.sql
index 9a20ade..403fc43 100644
--- a/db updates.sql	
+++ b/db updates.sql	
@@ -5,6 +5,32 @@ ALTER TABLE  `challenges` ADD  `dialogStart` VARCHAR( 200 ) DEFAULT NULL ,
 ADD  `dialogFail` VARCHAR( 200 ) DEFAULT NULL ,
 ADD  `dialogSuccess` VARCHAR( 200 ) DEFAULT NULL ;
 
--- Add index necessary for stats updates
-ALTER TABLE `bluePathery`.`solutions`
-ADD INDEX `mapIDMoves` ( `mapID` , `moves` ) 
\ No newline at end of file
+--InnoDB engine switch:
+ALTER TABLE achievements ENGINE = InnoDB;
+ALTER TABLE challengeMaps ENGINE = InnoDB;
+ALTER TABLE challenges ENGINE = InnoDB;
+ALTER TABLE challengeSolutions ENGINE = InnoDB;
+ALTER TABLE chat ENGINE = InnoDB;
+ALTER TABLE emailQueue ENGINE = InnoDB;
+ALTER TABLE emails ENGINE = InnoDB;
+ALTER TABLE mapOfTheDay ENGINE = InnoDB;
+ALTER TABLE maps ENGINE = InnoDB;
+ALTER TABLE settings ENGINE = InnoDB;
+ALTER TABLE solutions ENGINE = InnoDB;
+ALTER TABLE users ENGINE = InnoDB;
+
+--Add index necessary for stats updates
+ALTER TABLE `solutions`
+ADD INDEX `mapIDMoves` ( `mapID` , `moves` );
+
+--I forgot this table:
+ALTER TABLE unlocks ENGINE = InnoDB;
+
+--Straggling depreciated tables:
+DROP TABLE statistics;
+--We must have copied the data from this, right?
+DROP TABLE userData;
+DROP TABLE guestSolutions;
+
+
+--The above was executed on production on 05-28-2013
\ No newline at end of file
-- 
cgit v1.2.3

