summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorBlueRaja <BlueRaja.admin@gmail.com>2013-03-12 20:10:11 -0500
committerBlueRaja <BlueRaja.admin@gmail.com>2013-03-12 20:10:11 -0500
commit12d52b19f580406c52f1b4e590fc5fac4e6d9e6c (patch)
treefe58e7b0c6b33cc60a5ef9b165f8d6bc00c5e402
parent6ce00969ead28f357ff924340da524d6f2fede65 (diff)
downloadpathery-12d52b19f580406c52f1b4e590fc5fac4e6d9e6c.tar.xz
Removed spurious line
-rw-r--r--db updates.sql3
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)