summaryrefslogtreecommitdiffstats
path: root/db updates.sql
blob: b8b63a24a6120f0183d89d49eb1beb1236f3e7a0 (plain)
1
2
3
4
5
6
7
8
9
ALTER TABLE `db428221563`.`mapOfTheDay` DROP INDEX `UniqueTypeDate` ,
ADD UNIQUE `UniqueTypeDate` ( `mapDate` , `mapType` );

ALTER TABLE `mapOfTheDay` ADD `championPointsWorth` INT NOT NULL DEFAULT '0';

ALTER TABLE `users` ADD `totalMazes` INT NOT NULL DEFAULT '0',
ADD `totalMoves` INT NOT NULL DEFAULT '0';

ALTER TABLE `solutions` ADD `isTiedForHighScore` BOOLEAN NOT NULL DEFAULT '0';