summaryrefslogtreecommitdiffstats
path: root/db updates.sql
diff options
context:
space:
mode:
Diffstat (limited to 'db updates.sql')
-rw-r--r--db updates.sql10
1 files changed, 10 insertions, 0 deletions
diff --git a/db updates.sql b/db updates.sql
index 440f473..efc21ce 100644
--- a/db updates.sql
+++ b/db updates.sql
@@ -8,6 +8,16 @@ 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 ;
+
+ALTER TABLE `solutions` ADD `isTiedForHighScore` BOOLEAN NOT NULL DEFAULT '0';
+
-- Add the 'mapExpireTime' column
ALTER TABLE `mapOfTheDay` ADD `mapExpireTime` DATETIME NULL DEFAULT NULL AFTER `mapDate`;