aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorfunjoker <funjoker109@gmail.com>2020-12-16 20:46:07 +0100
committerfunjoker <funjoker109@gmail.com>2020-12-16 20:46:07 +0100
commit51ebc079446181e0fb70640934ede0513108f4e7 (patch)
treecccf6f447f13c894a75c80ca9d505338e5dbb92b /sql
parent8742bf353df619bd24b00ef8eeea7590c85e8761 (diff)
Core/Quest: Change RewardFactionCapIn type to signed int32
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/world/master/2020_12_16_00_world.sql6
1 files changed, 6 insertions, 0 deletions
diff --git a/sql/updates/world/master/2020_12_16_00_world.sql b/sql/updates/world/master/2020_12_16_00_world.sql
new file mode 100644
index 00000000000..2203a9375b1
--- /dev/null
+++ b/sql/updates/world/master/2020_12_16_00_world.sql
@@ -0,0 +1,6 @@
+ALTER TABLE `quest_template`
+CHANGE COLUMN `RewardFactionCapIn1` `RewardFactionCapIn1` INT(10) NOT NULL DEFAULT '0' AFTER `RewardFactionOverride1`,
+CHANGE COLUMN `RewardFactionCapIn2` `RewardFactionCapIn2` INT(10) NOT NULL DEFAULT '0' AFTER `RewardFactionOverride2`,
+CHANGE COLUMN `RewardFactionCapIn3` `RewardFactionCapIn3` INT(10) NOT NULL DEFAULT '0' AFTER `RewardFactionOverride3`,
+CHANGE COLUMN `RewardFactionCapIn4` `RewardFactionCapIn4` INT(10) NOT NULL DEFAULT '0' AFTER `RewardFactionOverride4`,
+CHANGE COLUMN `RewardFactionCapIn5` `RewardFactionCapIn5` INT(10) NOT NULL DEFAULT '0' AFTER `RewardFactionOverride5`;