From 3990b65956331263b0963f695ddc88b4c3356af0 Mon Sep 17 00:00:00 2001
From: BlueRaja <BlueRaja.admin@gmail.com>
Date: Tue, 15 Jan 2013 22:36:27 -0600
Subject: Added totalMoves and totalMazes to users; and isTiedForHighScore to
 solutions (for convenience)

---
 db updates.sql | 8 ++++++--
 1 file changed, 6 insertions(+), 2 deletions(-)

(limited to 'db updates.sql')

diff --git a/db updates.sql b/db updates.sql
index e038771..b8b63a2 100644
--- a/db updates.sql	
+++ b/db updates.sql	
@@ -1,5 +1,9 @@
 ALTER TABLE `db428221563`.`mapOfTheDay` DROP INDEX `UniqueTypeDate` ,
-ADD UNIQUE `UniqueTypeDate` ( `mapDate` , `mapType` ) 
+ADD UNIQUE `UniqueTypeDate` ( `mapDate` , `mapType` );
 
-ALTER TABLE `mapOfTheDay` ADD `championPointsWorth` INT NOT NULL DEFAULT '0'
+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
-- 
cgit v1.2.3

