diff options
| author | Killyana <morphone1@gmail.com> | 2015-11-23 19:10:44 +0100 |
|---|---|---|
| committer | Killyana <morphone1@gmail.com> | 2015-11-23 19:10:44 +0100 |
| commit | 659428f636a8cc0bd0732edf90edd6bd72af8d7f (patch) | |
| tree | a41020a71320de759495ef0171ea5b1b572bb3a8 | |
| parent | 2cecc7b1f7b846d24f25e0f5acb957c4c4b4484d (diff) | |
DB: Remove skinloot from Critters
By @tkrokli
Closes #15871
| -rw-r--r-- | sql/updates/world/2015_11_23_01_world_335.sql | 3 |
1 files changed, 3 insertions, 0 deletions
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); |