aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authoroffl <offl@users.noreply.github.com>2021-10-01 18:20:32 +0300
committeroffl <offl@users.noreply.github.com>2021-10-01 18:20:32 +0300
commitcad9aaa82361238f7cb0b64cda635fc81240eb2c (patch)
tree10655a9fd20d2db55fc47f8c509d126fa334e172
parent0b76bb3519d427d8509257d48854c6ad941065e4 (diff)
DB/Creature: Add mountEntry column to addon tables for future use
Ref #25964
-rw-r--r--sql/updates/world/3.3.5/2021_10_01_05_world.sql6
1 files changed, 6 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2021_10_01_05_world.sql b/sql/updates/world/3.3.5/2021_10_01_05_world.sql
new file mode 100644
index 00000000000..3de765d5bee
--- /dev/null
+++ b/sql/updates/world/3.3.5/2021_10_01_05_world.sql
@@ -0,0 +1,6 @@
+--
+ALTER TABLE `creature_addon` ADD COLUMN `mountEntry` mediumint(8) unsigned NOT NULL AFTER `mount`;
+ALTER TABLE `creature_template_addon` ADD COLUMN `mountEntry` mediumint(8) unsigned NOT NULL AFTER `mount`;
+
+UPDATE `creature_template_addon` SET `mountEntry` = 25187 WHERE `entry` = 23346;
+UPDATE `creature_template_addon` SET `mountEntry` = 25182 WHERE `entry` = 23344;