diff options
| author | offl <offl@users.noreply.github.com> | 2021-10-01 18:20:32 +0300 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2022-03-19 22:43:10 +0100 |
| commit | 7d22f76f11afd7d52e0abe7635708d5ea5376b48 (patch) | |
| tree | 44f2f35bde8c273cfd79b1966c15ae9cc94a04f3 | |
| parent | 1a236bdecdf4464c774eb8398bb94591e23fb234 (diff) | |
DB/Creature: Add MountCreatureID column to addon tables for future use
Ref #25964
(cherry picked from commit cad9aaa82361238f7cb0b64cda635fc81240eb2c)
| -rw-r--r-- | sql/updates/world/master/2022_03_19_05_world_2021_10_01_05_world.sql | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_03_19_05_world_2021_10_01_05_world.sql b/sql/updates/world/master/2022_03_19_05_world_2021_10_01_05_world.sql new file mode 100644 index 00000000000..610a5f6aa4f --- /dev/null +++ b/sql/updates/world/master/2022_03_19_05_world_2021_10_01_05_world.sql @@ -0,0 +1,6 @@ +-- +ALTER TABLE `creature_addon` ADD COLUMN `MountCreatureID` int unsigned NOT NULL AFTER `mount`; +ALTER TABLE `creature_template_addon` ADD COLUMN `MountCreatureID` int unsigned NOT NULL AFTER `mount`; + +UPDATE `creature_template_addon` SET `MountCreatureID` = 25187 WHERE `entry` = 23346; +UPDATE `creature_template_addon` SET `MountCreatureID` = 25182 WHERE `entry` = 23344; |