blob: 50b6a975ab35a4e89cd397550d04ff3c9a45e0ff (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
|
ALTER TABLE `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';
ALTER TABLE `users` ADD `challengeTier` INT NOT NULL ,
ADD `championPoints` INT NOT NULL ,
ADD `totalWins` INT DEFAULT '0' NOT NULL ,
ADD `totalTies` INT DEFAULT '0' NOT NULL ;
ALTER TABLE `solutions` ADD `championPointsWorth` INT DEFAULT '0' NOT NULL ,
ADD `isHighScore` TINYINT( 1 ) NOT NULL ;
|
