sql/updates/2008_10_19_01_mangos_spell_affect.sql

   1 DELETE FROM spell_affect WHERE entry IN (30017,30280,44373) AND effectId = 0;
   2 INSERT INTO spell_affect (entry, effectId, SpellFamilyMask) VALUES
   3 (30017,0,0x0000000000000000),
   4 (30280,0,0x0000000000000000),
   5 (44373,0,0x0000000000000000);
   6
   7
   8 DELETE FROM spell_affect WHERE entry IN (34520,37508) AND effectId = 1;
   9 INSERT INTO spell_affect (entry, effectId, SpellFamilyMask) VALUES
  10 (34520,1,0x0000000000000000),
  11 (37508,1,0x0000000000000000);