diff options
| author | ZxBiohazardZx <zxbiohazardzx@gmail.com> | 2013-01-06 23:36:53 +0100 |
|---|---|---|
| committer | ZxBiohazardZx <zxbiohazardzx@gmail.com> | 2013-01-06 23:36:53 +0100 |
| commit | 5fe399195f8f46ba1934ac69d6c8f6a2efac794c (patch) | |
| tree | c67c445b9402fef4975eb0919b0ef4976ea7672d | |
| parent | 6f19129a4a65977da0c5eb122383dbeb3cb06835 (diff) | |
DB/Cleanup: Remove duplicate aura definitions in creature_addon and creature_template addon
| -rw-r--r-- | sql/updates/world/2013_01_06_00_world_creature_addon.sql | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/sql/updates/world/2013_01_06_00_world_creature_addon.sql b/sql/updates/world/2013_01_06_00_world_creature_addon.sql new file mode 100644 index 00000000000..e4412241dce --- /dev/null +++ b/sql/updates/world/2013_01_06_00_world_creature_addon.sql @@ -0,0 +1,10 @@ +-- Cleanup creature_addon and creature_template_addon +-- we had 83 duplicate aura definitions in those +-- Glacier Penguin (51 rows) +DELETE FROM `creature_addon` WHERE `guid` IN (134996,134997,134998,134999,135000,135001,135002,135004,135005,135006,135007,135008,135009,135010,135011,135012,135013,135014,135015,135016,135017,135018,135025,135026,135027,135028,135029,135030,135031,135032,135033,135034,135035,135036,135037,135038,135039,135040,135041,53884,53885,53886,53887,53888,53889,53890,53891,53892,54042,54043,54044); +-- Plagued Dragonflayer Tribesman (21 rows) +DELETE FROM `creature_addon` WHERE `guid` IN (97517,97518,97519,97520,97521,97522,97523,97524,97526,97527,97528,97529,97530,97531,97532,97534,97535,97537,97538,97539,97541); +DELETE FROM `creature_addon` WHERE `guid` IN ( +85036, -- Sir Marcus Barlowe +85038, -- Captain Joseph Holley +85053); -- Marshal Jacob Alerius |