From 659428f636a8cc0bd0732edf90edd6bd72af8d7f Mon Sep 17 00:00:00 2001
From: Killyana <morphone1@gmail.com>
Date: Mon, 23 Nov 2015 19:10:44 +0100
Subject: DB: Remove skinloot from Critters

By @tkrokli
Closes #15871
---
 sql/updates/world/2015_11_23_01_world_335.sql | 3 +++
 1 file changed, 3 insertions(+)
 create mode 100644 sql/updates/world/2015_11_23_01_world_335.sql

(limited to 'sql')

diff --git a/sql/updates/world/2015_11_23_01_world_335.sql b/sql/updates/world/2015_11_23_01_world_335.sql
new file mode 100644
index 00000000000..8432c2d14fd
--- /dev/null
+++ b/sql/updates/world/2015_11_23_01_world_335.sql
@@ -0,0 +1,3 @@
+UPDATE `creature_template` SET `skinloot` = 0 WHERE `entry` IN (721,883,890,1933,2098,2442,2620,4166,5951,10780,12296,12297,12298,12299,17467);
+-- Remove unreferenced skinning_loot_template entries because of this update:
+DELETE FROM `skinning_loot_template` WHERE `Entry` IN (1933,12299,100000);
-- 
cgit v1.2.3