sql/updates/0.10/4951_mangos_spell_affect.sql

   1 DELETE FROM `spell_affect` WHERE `entry` IN (19498,19499,19500);
   2 INSERT INTO `spell_affect` VALUES
   3  (19498,0,0,0,0,0,0,0x00210810007FA01,0),
   4  (19499,0,0,0,0,0,0,0x00210810007FA01,0),
   5  (19500,0,0,0,0,0,0,0x00210810007FA01,0);
   6
   7 DELETE FROM `spell_affect` WHERE `entry` IN (19416,19417,19418,19419,19420);
   8 INSERT INTO `spell_affect` VALUES
   9  (19416,0,0,0,0,0,0,0x00210810007FA00,0),
  10  (19417,0,0,0,0,0,0,0x00210810007FA00,0),
  11  (19418,0,0,0,0,0,0,0x00210810007FA00,0),
  12  (19419,0,0,0,0,0,0,0x00210810007FA00,0),
  13  (19420,0,0,0,0,0,0,0x00210810007FA00,0);
  14
  15 DELETE FROM `spell_affect` WHERE `entry` IN (19485,19487,19488,19489,19490);
  16 INSERT INTO `spell_affect` VALUES
  17  (19485,0,0,0,0,0,0,0x000000100061801,0),
  18  (19487,0,0,0,0,0,0,0x000000100061801,0),
  19  (19488,0,0,0,0,0,0,0x000000100061801,0),
  20  (19489,0,0,0,0,0,0,0x000000100061801,0),
  21  (19490,0,0,0,0,0,0,0x000000100061801,0);