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 ;