DB/Misc: Fix wrong types in creature_text and kill some DB startup errors

1 files changed, 6 insertions, 0 deletions

diff --git a/sql/updates/world/2011_05_22_07_world_misc.sql b/sql/updates/world/2011_05_22_07_world_misc.sql
new file mode 100644
index 00000000000..0f4eb84ffab
--- /dev/null
+++ b/sql/updates/world/2011_05_22_07_world_misc.sql
@@ -0,0 +1,6 @@
+UPDATE `creature_text` SET `type`=14 WHERE `type`=1; -- 9 rows changed
+UPDATE `creature_text` SET `type`=16 WHERE `type`=2; -- 1 row changed
+
+-- Fix unrelated DB errors
+UPDATE `creature_template` SET `unit_class`=8 WHERE `entry`=40418;
+DELETE FROM `creature_addon` WHERE `guid`=136607;