From 5dbe9e7890e41b16933e4651edc634373d4d876b Mon Sep 17 00:00:00 2001 From: Shauren Date: Sun, 19 Feb 2017 10:58:08 +0100 Subject: Core/Creatures: Implemented all creature equipment modifiers * It is now possible to give creatures a mythic/heroic weapon Closes #19160 --- sql/updates/world/master/2017_02_19_03_world.sql | 7 +++++++ 1 file changed, 7 insertions(+) create mode 100644 sql/updates/world/master/2017_02_19_03_world.sql (limited to 'sql') 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`; -- cgit v1.2.3