summaryrefslogtreecommitdiffstats
path: root/db updates.sql
blob: 9a20ade5ac26ddc90bcca47e919de04ce86d5768 (plain)
1
2
3
4
5
6
7
8
9
10
-- 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 ;

-- Add index necessary for stats updates
ALTER TABLE `bluePathery`.`solutions`
ADD INDEX `mapIDMoves` ( `mapID` , `moves` )