From 5758770c5c0733383858463b2b33cadcc03b6f2f Mon Sep 17 00:00:00 2001
From: Patrick Davison <snapwilliam@gmail.com>
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

