diff options
| -rw-r--r-- | db updates.sql | 32 |
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 |