From 805a8fc305b140bc47e95a6ce4e01de0315bfe8c Mon Sep 17 00:00:00 2001
From: Patrick Davison <snapwilliam@gmail.com>
Date: Sun, 10 Mar 2013 22:41:14 -0700
Subject: Duplicate Solution issue. Amazed this came up just now! O_o!

---
 db updates.sql | 8 +++++++-
 1 file changed, 7 insertions(+), 1 deletion(-)

(limited to 'db updates.sql')

diff --git a/db updates.sql b/db updates.sql
index 2e04942..66da097 100644
--- a/db updates.sql	
+++ b/db updates.sql	
@@ -108,4 +108,10 @@ AND (maps.name IS NULL OR maps.name = '');
 ALTER TABLE `solutions` CHANGE `solution` `solution` VARCHAR( 4095 ) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL;
 
 -- Fix Typo
-UPDATE unlocks SET name = 'Light Diagonal Cover' WHERE name = 'Light Diagnol Cover'
\ No newline at end of file
+UPDATE unlocks SET name = 'Light Diagonal Cover' WHERE name = 'Light Diagnol Cover'
+
+-- Change index to a unique index
+-- If any duplicates exist you can find them with this:
+-- select mapID, count(*) from `solutions` group by mapID, userID HAVING count(*) > 1
+ALTER TABLE  `solutions` DROP INDEX  `userID` ,
+ADD UNIQUE  `userIDmapID` (  `userID` ,  `mapID` )
-- 
cgit v1.2.3

