aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/world/2011_05_13_06_world_creature_text.sql7
1 files changed, 7 insertions, 0 deletions
diff --git a/sql/updates/world/2011_05_13_06_world_creature_text.sql b/sql/updates/world/2011_05_13_06_world_creature_text.sql
new file mode 100644
index 00000000000..6a8eca79ade
--- /dev/null
+++ b/sql/updates/world/2011_05_13_06_world_creature_text.sql
@@ -0,0 +1,7 @@
+-- Update creature_text to use proper text values
+UPDATE `creature_text` SET `type`=12 WHERE `type`=0;
+UPDATE `creature_text` SET `type`=14 WHERE `type`=1;
+UPDATE `creature_text` SET `type`=16 WHERE `type`=2;
+UPDATE `creature_text` SET `type`=41 WHERE `type`=3;
+UPDATE `creature_text` SET `type`=15 WHERE `type`=4;
+UPDATE `creature_text` SET `type`=42 WHERE `type`=5;