130.sql

-- Delete 130 Wrong SAI
DELETE FROM `smart_scripts` WHERE `action_param1` IN (3391, 3417, 8876, 12787, 54913) AND `source_type` = 0;

-- 1843
DELETE FROM `creature_template_addon` WHERE `entry` = 1843;
INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `MountCreatureID`, `bytes1`, `bytes2`, `emote`, `visibilityDistanceType`, `auras`) VALUES
(1843, 0, 0, 0, 0, 0, 0, 0, '12787');

-- 1847
UPDATE `creature_template_addon` SET `auras` = '12787' WHERE `entry` = 1847;

-- 2681 doesn't seem to use trash at all https://www.wowhead.com/wotlk/npc=2681/vilebranch-raiding-wolf#abilities;mode:20player

-- 4634
UPDATE `creature_template_addon` SET `auras` = '12787' WHERE `entry` = 4634;

-- 4645
UPDATE `creature_template_addon` SET `auras` = '12787' WHERE `entry` = 4645;

-- 4652
UPDATE `creature_template_addon` SET `auras` = '12787' WHERE `entry` = 4652;

-- 4656
UPDATE `creature_template_addon` SET `auras` = '12787' WHERE `entry` = 4656;

-- 7101
UPDATE `creature_template_addon` SET `auras` = '12787' WHERE `entry` = 7101;

-- 7446 doesn't seem to use trash at all https://www.wowhead.com/wotlk/npc=7446/rabid-shardtooth#abilities;mode:20player

-- 8205
DELETE FROM `creature_template_addon` WHERE `entry` = 8205;
INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `MountCreatureID`, `bytes1`, `bytes2`, `emote`, `visibilityDistanceType`, `auras`) VALUES
(8205, 0, 0, 0, 0, 0, 0, 0, '12787');

-- 8208
DELETE FROM `creature_template_addon` WHERE `entry` = 8208;
INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `MountCreatureID`, `bytes1`, `bytes2`, `emote`, `visibilityDistanceType`, `auras`) VALUES
(8208, 0, 0, 0, 0, 0, 0, 0, '12787');

-- 8216
DELETE FROM `creature_template_addon` WHERE `entry` = 8216;
INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `MountCreatureID`, `bytes1`, `bytes2`, `emote`, `visibilityDistanceType`, `auras`) VALUES
(8216, 0, 0, 0, 0, 1, 0, 0, '12787');

-- 8961 doesn't seem to use trash at all https://www.wowhead.com/wotlk/npc=8961/felpaw-ravager#abilities

-- 10836
DELETE FROM `creature_template_addon` WHERE `entry` = 10836;
INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `MountCreatureID`, `bytes1`, `bytes2`, `emote`, `visibilityDistanceType`, `auras`) VALUES
(10836, 0, 0, 0, 0, 0, 0, 0, '12787');

-- 11442
UPDATE `creature_template_addon` SET `auras` = '12787' WHERE `entry` = 11442;

-- 11714
DELETE FROM `creature_template_addon` WHERE `entry` = 11714;
INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `MountCreatureID`, `bytes1`, `bytes2`, `emote`, `visibilityDistanceType`, `auras`) VALUES
(11714, 0, 0, 0, 0, 1, 0, 0, '12787');

-- 11737 doesn't seem to use trash at all https://www.wowhead.com/wotlk/npc=11737/stonelash-flayer#abilities

-- 14426
UPDATE `creature_template_addon` SET `auras` = '12787' WHERE `entry` = 14426;

-- 15207
DELETE FROM `creature_template_addon` WHERE `entry` = 15207;
INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `MountCreatureID`, `bytes1`, `bytes2`, `emote`, `visibilityDistanceType`, `auras`) VALUES
(15207, 0, 0, 0, 0, 0, 0, 0, '12787');

-- 15305
UPDATE `creature_template_addon` SET `auras` = '12787' WHERE `entry` = 15305;

-- 21271
UPDATE `creature_template_addon` SET `auras` = '12787' WHERE `entry` = 21271;

-- 24567
UPDATE `creature_template_addon` SET `auras` = '12787' WHERE `entry` = 24567;

-- 100 doesn't seem to use trash at all https://www.wowhead.com/wotlk/npc=100/gruff-swiftbite#abilities

-- 449 doesn't seem to use trash at all https://www.wowhead.com/wotlk/npc=449/defias-knuckleduster#abilities

-- 478
UPDATE `creature_template_addon` SET `auras` = '12787' WHERE `entry` = 478;

-- 519 doesn't seem to use trash at all https://www.wowhead.com/wotlk/npc=519/slark#abilities

-- 669
UPDATE `creature_template_addon` SET `auras` = '12787' WHERE `entry` = 669;

-- 712 doesn't seem to use trash at all https://www.wowhead.com/wotlk/npc=712/redridge-thrasher#abilities

-- 723 doesn't seem to use trash at all https://www.wowhead.com/wotlk/npc=723/moshogg-butcher#abilities

-- 1202
UPDATE `creature_template_addon` SET `auras` = '12787' WHERE `entry` = 1202;

-- 1224 doesn't seem to use trash at all https://www.wowhead.com/wotlk/npc=1224/young-threshadon#abilities

-- 1353 doesn't seem to use trash at all https://www.wowhead.com/wotlk/npc=1353/sarltooth#abilities

-- 1693 doesn't seem to use trash at all https://www.wowhead.com/wotlk/npc=1693/loch-crocolisk#abilities

-- 1696
DELETE FROM `creature_template_addon` WHERE `entry` = 1696;
INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `MountCreatureID`, `bytes1`, `bytes2`, `emote`, `visibilityDistanceType`, `auras`) VALUES
(1696, 0, 0, 0, 0, 1, 0, 0, '12787');

-- 1783
DELETE FROM `creature_template_addon` WHERE `entry` = 1783;
INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `MountCreatureID`, `bytes1`, `bytes2`, `emote`, `visibilityDistanceType`, `auras`) VALUES
(1783, 0, 0, 0, 0, 0, 0, 0, '12787');
UPDATE `creature_addon` SET `auras` = '12787' WHERE `guid` IN (SELECT `guid` FROM `creature` WHERE `id` = 1783);

-- 1791 doesn't seem to use trash at all https://www.wowhead.com/wotlk/npc=1791/slavering-ghoul#abilities

-- 2167
DELETE FROM `creature_template_addon` WHERE `entry` = 2167;
INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `MountCreatureID`, `bytes1`, `bytes2`, `emote`, `visibilityDistanceType`, `auras`) VALUES
(2167, 0, 0, 0, 0, 0, 0, 0, '12787');
UPDATE `creature_addon` SET `auras` = '12787' WHERE `guid` IN (SELECT `guid` FROM `creature` WHERE `id` = 2167);

-- 2186
DELETE FROM `creature_template_addon` WHERE `entry` = 2186;
INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `MountCreatureID`, `bytes1`, `bytes2`, `emote`, `visibilityDistanceType`, `auras`) VALUES
(2186, 0, 0, 0, 0, 0, 0, 0, '12787');

-- 2236
UPDATE `creature_template_addon` SET `auras` = '12787' WHERE `entry` = 2236;

-- 2476 doesn't seem to use trash at all https://www.wowhead.com/wotlk/npc=2476/large-loch-crocolisk#abilities

-- 2560
UPDATE `creature_template_addon` SET `auras` = '12787' WHERE `entry` = 2560;

-- 2717
DELETE FROM `creature_template_addon` WHERE `entry` = 2717;
INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `MountCreatureID`, `bytes1`, `bytes2`, `emote`, `visibilityDistanceType`, `auras`) VALUES
(2717, 0, 0, 0, 0, 1, 0, 0, '12787');
UPDATE `creature_addon` SET `auras` = '12787' WHERE `guid` IN (SELECT `guid` FROM `creature` WHERE `id` = 2717);

-- 2728
UPDATE `creature_template_addon` SET `auras` = '12787' WHERE `entry` = 2728;

-- 3256
DELETE FROM `creature_template_addon` WHERE `entry` = 3256;
INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `MountCreatureID`, `bytes1`, `bytes2`, `emote`, `visibilityDistanceType`, `auras`) VALUES
(3256, 0, 0, 0, 0, 0, 0, 0, '12787');
UPDATE `creature_addon` SET `auras` = '12787' WHERE `guid` IN (SELECT `guid` FROM `creature` WHERE `id` = 3256);

-- 3378
UPDATE `creature_template_addon` SET `auras` = '12787' WHERE `entry` = 3378;

-- 3456
DELETE FROM `creature_template_addon` WHERE `entry` = 3456;
INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `MountCreatureID`, `bytes1`, `bytes2`, `emote`, `visibilityDistanceType`, `auras`) VALUES
(3456, 0, 0, 0, 0, 1, 0, 0, '12787');
UPDATE `creature_addon` SET `auras` = '12787' WHERE `guid` IN (SELECT `guid` FROM `creature` WHERE `id` = 3456);

-- 3636 doesn't seem to use trash at all https://www.wowhead.com/wotlk/npc=3636/deviate-ravager#abilities

-- 3652 doesn't seem to use trash at all https://www.wowhead.com/wotlk/npc=3652/trigore-the-lasher

-- 3722 doesn't seem to use trash at all https://www.wowhead.com/wotlk/npc=3722/mystlash-flayer

-- 3746
UPDATE `creature_template_addon` SET `auras` = '12787' WHERE `entry` = 3746;

-- 4023
UPDATE `creature_template_addon` SET `auras` = '12787' WHERE `entry` = 4023;

-- 4348 doesn't seem to use trash at all https://www.wowhead.com/wotlk/npc=4348/noxious-shredder#abilities;mode:normal

-- 4374
UPDATE `creature_template_addon` SET `auras` = '12787' WHERE `entry` = 4374;

-- 4389
UPDATE `creature_template_addon` SET `auras` = '12787' WHERE `entry` = 4389;

-- 4390
UPDATE `creature_template_addon` SET `auras` = '12787' WHERE `entry` = 4390;

-- 4479
UPDATE `creature_template_addon` SET `auras` = '12787' WHERE `entry` = 4479;

-- 4493
DELETE FROM `creature_template_addon` WHERE `entry` = 4493;
INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `MountCreatureID`, `bytes1`, `bytes2`, `emote`, `visibilityDistanceType`, `auras`) VALUES
(4493, 0, 0, 0, 0, 1, 0, 0, '12787');
UPDATE `creature_addon` SET `auras` = '12787' WHERE `guid` IN (SELECT `guid` FROM `creature` WHERE `id` = 4493);

-- 4540
UPDATE `creature_template_addon` SET `auras` = '12787' WHERE `entry` = 4540;
UPDATE `creature_addon` SET `auras` = '12787' WHERE `guid` IN (SELECT `guid` FROM `creature` WHERE `id` = 4540);

-- 4855
DELETE FROM `creature_template_addon` WHERE `entry` = 4855;
INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `MountCreatureID`, `bytes1`, `bytes2`, `emote`, `visibilityDistanceType`, `auras`) VALUES
(4855, 0, 0, 0, 0, 0, 0, 0, '12787');
UPDATE `creature_addon` SET `auras` = '12787' WHERE `guid` IN (SELECT `guid` FROM `creature` WHERE `id` = 4855);

-- 5234
DELETE FROM `creature_template_addon` WHERE `entry` = 5234;
INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `MountCreatureID`, `bytes1`, `bytes2`, `emote`, `visibilityDistanceType`, `auras`) VALUES
(5234, 0, 0, 0, 0, 1, 0, 0, '12787');
UPDATE `creature_addon` SET `auras` = '12787' WHERE `guid` IN (SELECT `guid` FROM `creature` WHERE `id` = 5234);

-- 5267
DELETE FROM `creature_template_addon` WHERE `entry` = 5267;
INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `MountCreatureID`, `bytes1`, `bytes2`, `emote`, `visibilityDistanceType`, `auras`) VALUES
(5267, 0, 0, 0, 0, 1, 0, 0, '12787');

-- 5363
UPDATE `creature_template_addon` SET `auras` = '12787' WHERE `entry` = 5363;

-- 5435
DELETE FROM `creature_template_addon` WHERE `entry` = 5435;
INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `MountCreatureID`, `bytes1`, `bytes2`, `emote`, `visibilityDistanceType`, `auras`) VALUES
(5435, 0, 0, 0, 0, 0, 0, 0, '12787');

-- 5455
DELETE FROM `creature_template_addon` WHERE `entry` = 5455;
INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `MountCreatureID`, `bytes1`, `bytes2`, `emote`, `visibilityDistanceType`, `auras`) VALUES
(5455, 0, 0, 0, 0, 0, 0, 0, '12787');
UPDATE `creature_addon` SET `auras` = '12787' WHERE `guid` IN (SELECT `guid` FROM `creature` WHERE `id` = 5455);

-- 5456
DELETE FROM `creature_template_addon` WHERE `entry` = 5456;
INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `MountCreatureID`, `bytes1`, `bytes2`, `emote`, `visibilityDistanceType`, `auras`) VALUES
(5456, 0, 0, 0, 0, 0, 0, 0, '12787');
UPDATE `creature_addon` SET `auras` = '12787' WHERE `guid` IN (SELECT `guid` FROM `creature` WHERE `id` = 5456);

-- 5457
DELETE FROM `creature_template_addon` WHERE `entry` = 5457;
INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `MountCreatureID`, `bytes1`, `bytes2`, `emote`, `visibilityDistanceType`, `auras`) VALUES
(5457, 0, 0, 0, 0, 0, 0, 0, '12787');
UPDATE `creature_addon` SET `auras` = '12787' WHERE `guid` IN (SELECT `guid` FROM `creature` WHERE `id` = 5457);

-- 5458
UPDATE `creature_template_addon` SET `auras` = '12787' WHERE `entry` = 5458;

-- 5459 doesn't seem to use trash at all https://www.wowhead.com/wotlk/npc=5459/centipaar-tunneler#abilities;mode:normal

-- 5460
DELETE FROM `creature_template_addon` WHERE `entry` = 5460;
INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `MountCreatureID`, `bytes1`, `bytes2`, `emote`, `visibilityDistanceType`, `auras`) VALUES
(5460, 0, 0, 0, 0, 0, 0, 0, '12787');
UPDATE `creature_addon` SET `auras` = '12787' WHERE `guid` IN (SELECT `guid` FROM `creature` WHERE `id` = 5460);

-- 5683 doesn't seem to use trash at all https://www.wowhead.com/wotlk/npc=5683/corma-villard#abilities;mode:normal

-- 5709
UPDATE `creature_template_addon` SET `auras` = '12787' WHERE `entry` = 5709;
UPDATE `creature_addon` SET `auras` = '12787' WHERE `guid` IN (SELECT `guid` FROM `creature` WHERE `id` = 5709);

-- 5977
UPDATE `creature_template_addon` SET `auras` = '12787' WHERE `entry` = 5977;

-- 6005
UPDATE `creature_template_addon` SET `auras` = '12787' WHERE `entry` = 6005;

-- 6210
DELETE FROM `creature_template_addon` WHERE `entry` = 6210;
INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `MountCreatureID`, `bytes1`, `bytes2`, `emote`, `visibilityDistanceType`, `auras`) VALUES
(6210, 0, 0, 0, 0, 1, 0, 0, '12787');

-- 6347
UPDATE `creature_template_addon` SET `auras` = '12787' WHERE `entry` = 6347;

-- 6348
UPDATE `creature_template_addon` SET `auras` = '12787' WHERE `entry` = 6348;

-- 6349
UPDATE `creature_template_addon` SET `auras` = '12787' WHERE `entry` = 6349;

-- 6506 doesn't seem to use trash at all https://www.wowhead.com/wotlk/npc=6506/ravasaur-runner#abilities

-- 7039
DELETE FROM `creature_template_addon` WHERE `entry` = 7039;
INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `MountCreatureID`, `bytes1`, `bytes2`, `emote`, `visibilityDistanceType`, `auras`) VALUES
(7039, 0, 0, 0, 0, 0, 0, 0, '12787');
UPDATE `creature_addon` SET `auras` = '12787' WHERE `guid` IN (SELECT `guid` FROM `creature` WHERE `id` = 7039);

-- 7234
UPDATE `creature_template_addon` SET `auras` = '12787' WHERE `entry` = 7234;
UPDATE `creature_addon` SET `auras` = '12787' WHERE `guid` IN (SELECT `guid` FROM `creature` WHERE `id` = 7234);

-- 7268
DELETE FROM `creature_template_addon` WHERE `entry` = 7268;
INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `MountCreatureID`, `bytes1`, `bytes2`, `emote`, `visibilityDistanceType`, `auras`) VALUES
(7268, 0, 0, 0, 0, 0, 0, 0, '12787');

-- 7320
UPDATE `creature_template_addon` SET `auras` = '12787' WHERE `entry` = 7320;

-- 7369 doesn't seem to use trash at all https://www.wowhead.com/wotlk/npc=7369/deadwind-brute#abilities

-- 8138
DELETE FROM `creature_template_addon` WHERE `entry` = 8138;
INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `MountCreatureID`, `bytes1`, `bytes2`, `emote`, `visibilityDistanceType`, `auras`) VALUES
(8138, 0, 0, 0, 0, 0, 0, 0, '12787');

-- 8299
DELETE FROM `creature_template_addon` WHERE `entry` = 8299;
INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `MountCreatureID`, `bytes1`, `bytes2`, `emote`, `visibilityDistanceType`, `auras`) VALUES
(8299, 0, 0, 0, 0, 0, 0, 0, '12787');

-- 8520 doesn't seem to use trash at all https://www.wowhead.com/wotlk/npc=8520/plague-ravager#abilities

-- 8546 doesn't seem to use trash at all https://www.wowhead.com/wotlk/npc=8546/dark-adept#abilities

-- 8911 doesn't seem to use trash at all https://www.wowhead.com/wotlk/npc=8911/fireguard-destroyer#abilities

-- 8981
DELETE FROM `creature_template_addon` WHERE `entry` = 8981;
INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `MountCreatureID`, `bytes1`, `bytes2`, `emote`, `visibilityDistanceType`, `auras`) VALUES
(8981, 0, 0, 0, 0, 0, 0, 0, '12787');

-- 9096 doesn't seem to use trash at all https://www.wowhead.com/wotlk/npc=9096/rage-talon-dragonspawn#abilities

-- 9164 doesn't seem to use trash at all https://www.wowhead.com/wotlk/npc=9164/elder-diemetradon#abilities
UPDATE `creature_template_addon` SET `auras` = '' WHERE `entry` = 9164;

-- 9167 doesn't seem to use trash at all https://www.wowhead.com/wotlk/npc=9167/frenzied-pterrordax#abilities
UPDATE `creature_template_addon` SET `auras` = '' WHERE `entry` = 9167;

-- 9176 doesn't seem to use trash at all https://www.wowhead.com/wotlk/npc=9176/gortesh#abilities

-- 9267
DELETE FROM `creature_template_addon` WHERE `entry` = 9267;
INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `MountCreatureID`, `bytes1`, `bytes2`, `emote`, `visibilityDistanceType`, `auras`) VALUES
(9267, 0, 0, 0, 0, 1, 0, 0, '12787');

-- 9777
UPDATE `creature_template_addon` SET `auras` = '12787' WHERE `entry` = 9777;

-- 10158
UPDATE `creature_template_addon` SET `auras` = '12787' WHERE `entry` = 10158;

-- 10407 doesn't seem to use trash at all https://www.wowhead.com/wotlk/npc=10407/fleshflayer-ghoul#abilities

-- 10414 doesn't seem to use trash at all https://www.wowhead.com/wotlk/npc=10414/patchwork-horror#abilities

-- 10416 doesn't seem to use trash at all https://www.wowhead.com/wotlk/npc=10416/bile-spewer#abilities

-- 10488
UPDATE `creature_template_addon` SET `auras` = '12787' WHERE `entry` = 10488;

-- 10639
DELETE FROM `creature_template_addon` WHERE `entry` = 10639;
INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `MountCreatureID`, `bytes1`, `bytes2`, `emote`, `visibilityDistanceType`, `auras`) VALUES
(10639, 0, 0, 0, 0, 0, 0, 0, '12787');
UPDATE `creature_addon` SET `auras` = '12787' WHERE `guid` IN (SELECT `guid` FROM `creature` WHERE `id` = 10639);

-- 10946
UPDATE `creature_template_addon` SET `auras` = '12787 17467' WHERE `entry` = 10946;

-- 10991
DELETE FROM `creature_template_addon` WHERE `entry` = 10991;
INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `MountCreatureID`, `bytes1`, `bytes2`, `emote`, `visibilityDistanceType`, `auras`) VALUES
(10991, 0, 0, 0, 0, 0, 0, 0, '12787');

-- 11043
UPDATE `creature_template_addon` SET `auras` = '12787' WHERE `entry` = 11043;
UPDATE `creature_addon` SET `auras` = '12787' WHERE `guid` IN (SELECT `guid` FROM `creature` WHERE `id` = 11043);

-- 11075
DELETE FROM `creature_template_addon` WHERE `entry` = 11075;
INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `MountCreatureID`, `bytes1`, `bytes2`, `emote`, `visibilityDistanceType`, `auras`) VALUES
(11075, 0, 0, 0, 0, 0, 0, 0, '12787');

-- 11357 doesn't seem to use trash at all https://www.wowhead.com/wotlk/npc=11357/son-of-hakkar#abilities

-- 11372
DELETE FROM `creature_template_addon` WHERE `entry` = 11372;
INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `MountCreatureID`, `bytes1`, `bytes2`, `emote`, `visibilityDistanceType`, `auras`) VALUES
(11372, 0, 0, 0, 0, 0, 0, 0, '12787');
UPDATE `creature_addon` SET `auras` = '12787' WHERE `guid` IN (SELECT `guid` FROM `creature` WHERE `id` = 11372);

-- 11486
UPDATE `creature_template_addon` SET `auras` = '12787', `bytes2` = 1 WHERE `entry` = 11486;

-- 11677
DELETE FROM `creature_template_addon` WHERE `entry` = 11677;
INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `MountCreatureID`, `bytes1`, `bytes2`, `emote`, `visibilityDistanceType`, `auras`) VALUES
(11677, 0, 0, 0, 0, 1, 0, 0, '12787');

-- 11782 doesn't seem to use trash at all https://www.wowhead.com/wotlk/npc=11782/ambershard-destroyer#abilities

-- 11791
UPDATE `creature_template_addon` SET `auras` = '12787' WHERE `entry` = 11791;
UPDATE `creature_addon` SET `auras` = '12787' WHERE `guid` IN (SELECT `guid` FROM `creature` WHERE `id` = 11791);

-- 12138
DELETE FROM `creature_template_addon` WHERE `entry` = 12138;
INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `MountCreatureID`, `bytes1`, `bytes2`, `emote`, `visibilityDistanceType`, `auras`) VALUES
(12138, 0, 0, 0, 0, 0, 0, 0, '12787');

-- 12207
UPDATE `creature_template_addon` SET `auras` = '12787' WHERE `entry` = 12207;
UPDATE `creature_addon` SET `auras` = '12787' WHERE `guid` IN (SELECT `guid` FROM `creature` WHERE `id` = 12207);

-- 12258 doesn't seem to use trash at all https://www.wowhead.com/wotlk/npc=12258/razorlash#abilities

-- 12940
DELETE FROM `creature_template_addon` WHERE `entry` = 12940;
INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `MountCreatureID`, `bytes1`, `bytes2`, `emote`, `visibilityDistanceType`, `auras`) VALUES
(12940, 0, 0, 0, 0, 0, 0, 0, '12787');

-- 13088
DELETE FROM `creature_template_addon` WHERE `entry` = 13088;
INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `MountCreatureID`, `bytes1`, `bytes2`, `emote`, `visibilityDistanceType`, `auras`) VALUES
(13088, 0, 0, 0, 0, 1, 0, 0, '12787');

-- 13285 doesn't seem to use trash at all https://www.wowhead.com/wotlk/npc=13285/death-lash#abilities

-- 14282
DELETE FROM `creature_template_addon` WHERE `entry` = 14282;
INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `MountCreatureID`, `bytes1`, `bytes2`, `emote`, `visibilityDistanceType`, `auras`) VALUES
(14282, 0, 0, 0, 0, 0, 0, 0, '12787');

-- 14283
DELETE FROM `creature_template_addon` WHERE `entry` = 14283;
INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `MountCreatureID`, `bytes1`, `bytes2`, `emote`, `visibilityDistanceType`, `auras`) VALUES
(14283, 0, 0, 0, 0, 0, 0, 0, '12787');

-- 14750
DELETE FROM `creature_template_addon` WHERE `entry` = 14750;
INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `MountCreatureID`, `bytes1`, `bytes2`, `emote`, `visibilityDistanceType`, `auras`) VALUES
(14750, 0, 0, 0, 0, 0, 0, 0, '12787');
UPDATE `creature_addon` SET `auras` = '12787' WHERE `guid` IN (SELECT `guid` FROM `creature` WHERE `id` = 14750);

-- 14821
UPDATE `creature_template_addon` SET `auras` = '12787' WHERE `entry` = 14821;

-- 14882
UPDATE `creature_template_addon` SET `auras` = '12787' WHERE `entry` = 14882;

-- 16216
UPDATE `creature_template_addon` SET `auras` = '12787', `bytes2` = 1 WHERE `entry` = 16216;
UPDATE `creature_addon` SET `auras` = '12787' WHERE `guid` IN (SELECT `guid` FROM `creature` WHERE `id` = 16216);

-- 16593
DELETE FROM `creature_template_addon` WHERE `entry` = 16593;
INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `MountCreatureID`, `bytes1`, `bytes2`, `emote`, `visibilityDistanceType`, `auras`) VALUES
(16593, 0, 0, 0, 0, 0, 0, 0, '12787');

-- 17397
UPDATE `creature_template_addon` SET `auras` = '12787' WHERE `entry` = 17397;

-- 18105
UPDATE `creature_template_addon` SET `auras` = '' WHERE `entry` = 18105;
UPDATE `creature_addon` SET `auras` = '' WHERE `guid` IN (SELECT `guid` FROM `creature` WHERE `id` = 18105);

-- 19299 doesn't seem to use trash at all https://www.wowhead.com/wotlk/npc=19299/deathwhisperer#abilities

-- 23680
UPDATE `creature_template_addon` SET `auras` = '12787', `bytes2` = 0 WHERE `entry` = 23680;
UPDATE `creature_addon` SET `auras` = '12787', `bytes2` = 0 WHERE `guid` IN (SELECT `guid` FROM `creature` WHERE `id` = 23680);

-- 29033 doesn't seem to use trash at all https://www.wowhead.com/wotlk/npc=29033/spirit-of-atha#abilities

-- 29392
DELETE FROM `creature_template_addon` WHERE `entry` = 29392;
INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `MountCreatureID`, `bytes1`, `bytes2`, `emote`, `visibilityDistanceType`, `auras`) VALUES
(29392, 0, 0, 0, 0, 0, 0, 0, '12787');