diff options
| -rw-r--r-- | db updates.sql | 3 |
1 files changed, 1 insertions, 2 deletions
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) |