From fb4ac24ebe493e1419c547e6f8de1d19251d1cf6 Mon Sep 17 00:00:00 2001 From: Kinzcool Date: Sun, 26 Oct 2014 10:41:01 -0400 Subject: DB/Creatures: Changed the default char value from 100 to 200 for some columns --- sql/updates/world/2014_10_26_04_world.sql | 7 +++++++ 1 file changed, 7 insertions(+) create mode 100644 sql/updates/world/2014_10_26_04_world.sql (limited to 'sql') diff --git a/sql/updates/world/2014_10_26_04_world.sql b/sql/updates/world/2014_10_26_04_world.sql new file mode 100644 index 00000000000..d1c93b63cab --- /dev/null +++ b/sql/updates/world/2014_10_26_04_world.sql @@ -0,0 +1,7 @@ +ALTER TABLE `creature_template` CHANGE `name` `name` CHAR(200) NOT NULL DEFAULT '0'; +ALTER TABLE `creature_template` CHANGE `femaleName` `femaleName` CHAR(200) NOT NULL; +ALTER TABLE `creature_template` CHANGE `subname` `subname` CHAR(200); + +UPDATE `creature_template` SET `name`='Gorgrond Smokebelcher Depot NPC "Far From Invulnerable" Commander Rakish skewered Quest Kill Credit [NEVER SPAWNED]' WHERE `entry`=74403; +UPDATE `creature_template` SET `name`='Gorgrond Smokebelcher Depot NPC "Far From Invulnerable" Blademaster Kroga skewered Quest Kill Credit [NEVER SPAWNED]' WHERE `entry`=74674; +UPDATE `creature_template` SET `name`='Gorgrond Smokebelcher Depot NPC "Far From Invulnerable" Weaponsmith Garloc skewered Quest Kill Credit [NEVER SPAWNED]' WHERE `entry`=76435; -- cgit v1.2.3