blob: 403fc438425e3c3f0c1f1151692042416c53a85f (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
|
-- 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
|
