aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorModoX <moardox@gmail.com>2022-07-19 06:25:23 +0200
committerModoX <moardox@gmail.com>2022-07-19 06:27:02 +0200
commit27931b45c681f7f84928bad557882350731df3dc (patch)
tree8e493cd6e4823b8d0232b9cc0aa1eef16004de4f /sql
parente9152679d78c456e05be3743d7fed308c8304555 (diff)
Core/Quest: Corrected type of emote field in QuestOfferReward to be signed
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/world/master/2022_07_19_00_world.sql5
1 files changed, 5 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_07_19_00_world.sql b/sql/updates/world/master/2022_07_19_00_world.sql
new file mode 100644
index 00000000000..e78ec905e90
--- /dev/null
+++ b/sql/updates/world/master/2022_07_19_00_world.sql
@@ -0,0 +1,5 @@
+--
+ALTER TABLE `quest_offer_reward` MODIFY COLUMN `Emote1` smallint NOT NULL DEFAULT 0 AFTER `ID`;
+ALTER TABLE `quest_offer_reward` MODIFY COLUMN `Emote2` smallint NOT NULL DEFAULT 0 AFTER `Emote1`;
+ALTER TABLE `quest_offer_reward` MODIFY COLUMN `Emote3` smallint NOT NULL DEFAULT 0 AFTER `Emote2`;
+ALTER TABLE `quest_offer_reward` MODIFY COLUMN `Emote4` smallint NOT NULL DEFAULT 0 AFTER `Emote3`;