DELETE FROM `spell_pvp_mod` WHERE `spell_id`=3606;
INSERT INTO `spell_pvp_mod` VALUES (3606, 0.5, 0.5, 0.5, 0.5, 0.5, 'Shaman - Searing Totem Attack Rank 1');

DELETE FROM `spell_pvp_mod` WHERE `spell_id`=8187;
INSERT INTO `spell_pvp_mod` VALUES (8187, 0.45, 0.45, 0.45, 0.45, 0.45, 'Magma Totem');

#deep wounds pvp mod
DELETE FROM `spell_linked_spell` WHERE `spell_trigger`=12721 AND `spell_effect`=812721 AND `type`=0;
DELETE FROM `spell` WHERE `ID`=812721;

#Removed aura from 75461 and put it in resilient constitution

#update pet sls. Remove from SLS

DELETE FROM `spell_linked_spell` WHERE  `spell_trigger`=65220 AND `spell_effect`=856511 AND `type`=2;

DELETE FROM `spell_linked_spell` WHERE  `spell_trigger`=32233 AND `spell_effect`=856511 AND `type`=2;

DELETE FROM `spell_linked_spell` WHERE `spell_trigger`=65220 AND `spell_effect`=979700 AND `type`=2;
INSERT INTO `spell_linked_spell` VALUES (65220, 979700, 2, 0, 'Resilient Constitution for pets');
DELETE FROM `spell_linked_spell` WHERE `spell_trigger`=32233 AND `spell_effect`=979700 AND `type`=2;
INSERT INTO `spell_linked_spell` VALUES (32233, 979700, 2, 0, 'Resilient Constitution for pets');

#totem pvp mods

DELETE FROM `spell_pvp_mod` WHERE `spell_id`=8187;
INSERT INTO `spell_pvp_mod` VALUES (8187, 0.9, 0.9, 0.9, 0.9, 0.9, 'Magma Totem');
DELETE FROM `spell_pvp_mod` WHERE `spell_id`=3606;
INSERT INTO `spell_pvp_mod` VALUES (3606, 1, 1, 1, 1, 1, 'Shaman - Searing Totem Attack Rank 1');

DELETE FROM `spell_pvp_mod` WHERE  `spell_id`=12162;