diff options
author | BlueRaja <BlueRaja.admin@gmail.com> | 2013-03-12 20:10:11 -0500 |
---|---|---|
committer | BlueRaja <BlueRaja.admin@gmail.com> | 2013-03-12 20:10:11 -0500 |
commit | 12d52b19f580406c52f1b4e590fc5fac4e6d9e6c (patch) | |
tree | fe58e7b0c6b33cc60a5ef9b165f8d6bc00c5e402 | |
parent | 6ce00969ead28f357ff924340da524d6f2fede65 (diff) | |
download | pathery-12d52b19f580406c52f1b4e590fc5fac4e6d9e6c.tar.xz |
Removed spurious line
-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) |