From 5ddccd86ab09b4536b82545700281f32e71680f5 Mon Sep 17 00:00:00 2001
From: BlueRaja <BlueRaja.admin@gmail.com>
Date: Sun, 24 Mar 2013 16:59:17 -0500
Subject: Fixes for DB before releasing to production

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

(limited to 'db updates.sql')

diff --git a/db updates.sql b/db updates.sql
index 5afd88f..739c6e3 100644
--- a/db updates.sql	
+++ b/db updates.sql	
@@ -247,6 +247,9 @@ DROP INDEX `mapID` ,
 ADD UNIQUE `mapID` ( `mapID` , `ordering` );
 
 -- Optimizing the daily update queries
-ALTER TABLE `solutions` ADD INDEX ( `isHighScore` ) 
+ALTER TABLE `solutions` ADD INDEX ( `isHighScore` );
 
-ALTER TABLE  `users` ADD  `wallOrientation` TINYINT NOT NULL DEFAULT  '0' AFTER  `wallEmblem`
\ No newline at end of file
+ALTER TABLE  `users` ADD  `wallOrientation` TINYINT NOT NULL DEFAULT  '0' AFTER  `wallEmblem`;
+
+ALTER TABLE `solutions` DROP INDEX `userIDmapID` ,
+ADD UNIQUE `mapIDuserID` ( `mapID` , `userID` );
\ No newline at end of file
-- 
cgit v1.2.3

