aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorShauren <shauren.trinity@gmail.com>2017-02-19 10:58:08 +0100
committerShauren <shauren.trinity@gmail.com>2017-02-19 10:58:08 +0100
commit5dbe9e7890e41b16933e4651edc634373d4d876b (patch)
tree8f997abff36d456ce562c956da12b45d0f668901 /sql
parent7b5bbf2c3544f824fd672fcad05af2ced58fd7ff (diff)
Core/Creatures: Implemented all creature equipment modifiers
* It is now possible to give creatures a mythic/heroic weapon Closes #19160
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/world/master/2017_02_19_03_world.sql7
1 files changed, 7 insertions, 0 deletions
diff --git a/sql/updates/world/master/2017_02_19_03_world.sql b/sql/updates/world/master/2017_02_19_03_world.sql
new file mode 100644
index 00000000000..123c42a0599
--- /dev/null
+++ b/sql/updates/world/master/2017_02_19_03_world.sql
@@ -0,0 +1,7 @@
+ALTER TABLE `creature_equip_template`
+ ADD `AppearanceModID1` smallint(5) unsigned NOT NULL DEFAULT '0' AFTER `ItemID1`,
+ ADD `ItemVisual1` smallint(5) unsigned NOT NULL DEFAULT '0' AFTER `AppearanceModID1`,
+ ADD `AppearanceModID2` smallint(5) unsigned NOT NULL DEFAULT '0' AFTER `ItemID2`,
+ ADD `ItemVisual2` smallint(5) unsigned NOT NULL DEFAULT '0' AFTER `AppearanceModID2`,
+ ADD `AppearanceModID3` smallint(5) unsigned NOT NULL DEFAULT '0' AFTER `ItemID3`,
+ ADD `ItemVisual3` smallint(5) unsigned NOT NULL DEFAULT '0' AFTER `AppearanceModID3`;