From 5758770c5c0733383858463b2b33cadcc03b6f2f Mon Sep 17 00:00:00 2001 From: Patrick Davison Date: Thu, 24 Jan 2013 01:01:26 -0800 Subject: Added additional SQL ALTERs This should be the changes needed for Pathery.com (not including the new tables) --- db updates.sql | 12 ++++++++++-- 1 file changed, 10 insertions(+), 2 deletions(-) (limited to 'db updates.sql') diff --git a/db updates.sql b/db updates.sql index b8b63a2..50b6a97 100644 --- a/db updates.sql +++ b/db updates.sql @@ -1,4 +1,4 @@ -ALTER TABLE `db428221563`.`mapOfTheDay` DROP INDEX `UniqueTypeDate` , +ALTER TABLE `mapOfTheDay` DROP INDEX `UniqueTypeDate` , ADD UNIQUE `UniqueTypeDate` ( `mapDate` , `mapType` ); ALTER TABLE `mapOfTheDay` ADD `championPointsWorth` INT NOT NULL DEFAULT '0'; @@ -6,4 +6,12 @@ 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'; \ No newline at end of file +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 ; -- cgit v1.2.3