ddon-server/Arrowgene.Ddon.Database/Files/Database/Script/migration_msq_2.0.sql
Paul Campbell 25b968c9bc fix: Fix issue with 2.x migration
Fixed an issue where the MSQ migrations through a constaint faiure exception
when no characters in the database match the query.
2024-10-01 09:53:08 -04:00

4 lines
234 B
SQL

INSERT INTO ddon_quest_progress(character_common_id, quest_type, quest_id, step, variant_quest_id)
SELECT ddon_completed_quests.character_common_id, 3, 20010, 0, 0
FROM ddon_completed_quests
WHERE ddon_completed_quests.quest_id = 30;