From 7b0dbb4a8a57b1ee3ab3dc5abb871311ae434d7f Mon Sep 17 00:00:00 2001 From: Patrick Davison Date: Wed, 29 May 2013 22:46:09 -0700 Subject: SQL updates. --- db updates.sql | 32 +++++++++++++++++++++++++++++--- 1 file 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 -- cgit v1.2.3