aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorAokromes <jipr@hotmail.com>2013-06-20 18:05:21 +0300
committerAokromes <jipr@hotmail.com>2013-06-20 18:05:21 +0300
commit8224116f89f1b37f67a9faff5104582d7e5a519c (patch)
tree965229726e1639d170d023d2cb1fa6c7a23d3978
parentf3ec76faeb63009ddff357a93b61220fc6039f47 (diff)
DB/Misc: Cleaning db
-rw-r--r--sql/updates/world/2013_06_20_00_world_creature.sql2
1 files changed, 2 insertions, 0 deletions
diff --git a/sql/updates/world/2013_06_20_00_world_creature.sql b/sql/updates/world/2013_06_20_00_world_creature.sql
new file mode 100644
index 00000000000..1ce9bce76d7
--- /dev/null
+++ b/sql/updates/world/2013_06_20_00_world_creature.sql
@@ -0,0 +1,2 @@
+-- Cleaning db, those mobs already have emote asigned on creature_template_addon
+DELETE FROM creature_addon WHERE guid IN (SELECT guid FROM creature WHERE `id` = 33236) AND `emote`=27;