diff options
| author | BlueRaja <BlueRaja.admin@gmail.com> | 2013-03-12 20:01:10 -0500 |
|---|---|---|
| committer | BlueRaja <BlueRaja.admin@gmail.com> | 2013-03-12 20:01:10 -0500 |
| commit | 6ce00969ead28f357ff924340da524d6f2fede65 (patch) | |
| tree | b51cab9e4f1ce9715962eb481d1fe892e8a8677b /db updates.sql | |
| parent | 2b852b97cb6e6d0270c5f3ffbfb28a8279e37f90 (diff) | |
| parent | d9958bde9c3feddf15eced5c786c164db21b1efe (diff) | |
| download | pathery-6ce00969ead28f357ff924340da524d6f2fede65.tar.xz | |
Merge branch 'master' of git.raylu.net:pathery
Conflicts:
db updates.sql
Diffstat (limited to 'db updates.sql')
| -rw-r--r-- | db updates.sql | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/db updates.sql b/db updates.sql index 1f275db..7e7bc8b 100644 --- a/db updates.sql +++ b/db updates.sql @@ -99,6 +99,13 @@ 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' + +-- 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` ) UPDATE unlocks SET name = 'Light Diagonal Cover' WHERE name = 'Light Diagnol Cover'; -- The new code relies on these being unique, so we'll enforce that through indices. Make sure you |