diff options
| author | Kinzcool <kinzzcool@hotmail.com> | 2014-10-26 10:41:01 -0400 |
|---|---|---|
| committer | Kinzcool <kinzzcool@hotmail.com> | 2014-10-26 10:41:01 -0400 |
| commit | fb4ac24ebe493e1419c547e6f8de1d19251d1cf6 (patch) | |
| tree | e25c3c0e174392aa4fd3343550a491c71b1858cd | |
| parent | 0444c144bf949fd7e9bea23b55133b3fcd70452d (diff) | |
DB/Creatures: Changed the default char value from 100 to 200 for some columns
| -rw-r--r-- | sql/updates/world/2014_10_26_04_world.sql | 7 |
1 files changed, 7 insertions, 0 deletions
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; |