SQL updates.

1 files changed, 29 insertions, 3 deletions

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