-- db updates reset after patch on March 24th.

--Dialog to challenges:
ALTER TABLE  `challenges` ADD  `dialogStart` VARCHAR( 200 ) DEFAULT NULL ,
ADD  `dialogFail` VARCHAR( 200 ) DEFAULT NULL ,
ADD  `dialogSuccess` VARCHAR( 200 ) DEFAULT NULL ;

--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