From 12d52b19f580406c52f1b4e590fc5fac4e6d9e6c Mon Sep 17 00:00:00 2001 From: BlueRaja Date: Tue, 12 Mar 2013 20:10:11 -0500 Subject: Removed spurious line --- db updates.sql | 3 +-- 1 file changed, 1 insertion(+), 2 deletions(-) (limited to 'db updates.sql') diff --git a/db updates.sql b/db updates.sql index 7e7bc8b..a38b1cc 100644 --- a/db updates.sql +++ b/db updates.sql @@ -105,8 +105,7 @@ UPDATE unlocks SET name = 'Light Diagonal Cover' WHERE name = 'Light Diagnol Cov -- 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` ) -UPDATE unlocks SET name = 'Light Diagonal Cover' WHERE name = 'Light Diagnol Cover'; +ADD UNIQUE `userIDmapID` ( `userID` , `mapID` ); -- The new code relies on these being unique, so we'll enforce that through indices. Make sure you -- verify these ARE unique in the DB before adding these indices (they weren't in my test DB) -- cgit v1.2.3