diff options
| -rw-r--r-- | sql/updates/world/master/2022_03_26_06_world_2022_02_13_02_world.sql | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_03_26_06_world_2022_02_13_02_world.sql b/sql/updates/world/master/2022_03_26_06_world_2022_02_13_02_world.sql new file mode 100644 index 00000000000..347c67eb48e --- /dev/null +++ b/sql/updates/world/master/2022_03_26_06_world_2022_02_13_02_world.sql @@ -0,0 +1,8 @@ +-- +-- ALTER TABLE `quest_request_items` CHANGE `VerifiedBuild` `VerifiedBuild` INT(11) DEFAULT 0 NOT NULL; +-- ALTER TABLE `quest_details` CHANGE `VerifiedBuild` `VerifiedBuild` INT(11) DEFAULT 0 NOT NULL; +-- ALTER TABLE `quest_offer_reward` CHANGE `VerifiedBuild` `VerifiedBuild` INT(11) DEFAULT 0 NOT NULL; + +UPDATE `quest_request_items` SET `EmoteOnComplete`=0, `EmoteOnIncomplete`=0, `VerifiedBuild`=42083 WHERE `ID`=2178; +UPDATE `quest_details` SET `Emote1`=1, `VerifiedBuild`=42083 WHERE `ID`=2178; +UPDATE `quest_offer_reward` SET `Emote1`=5, `VerifiedBuild`=42083 WHERE `ID`=2178; |