sql/updates/7024_01_mangos_spell_chain.sql

   1 ALTER TABLE db_version CHANGE COLUMN required_7015_01_mangos_item_template required_7024_01_mangos_spell_chain bit;
   2
   3 /* Lifeblood (Herbalizm) */
   4 DELETE FROM `spell_chain` WHERE `spell_id` IN (55428,55480,55500,55501,55502,55503);
   5 INSERT INTO `spell_chain` VALUES
   6 (55428,0,55428,1,0),
   7 (55480,55428,55428,2,0),
   8 (55500,55480,55428,3,0),
   9 (55501,55500,55428,4,0),
  10 (55502,55501,55428,5,0),
  11 (55503,55502,55428,6,0);
  12
  13 /* Toughness (Mining) */
  14 DELETE FROM `spell_chain` WHERE `spell_id` IN (53120,53121,53122,53123,53124,53040);
  15 INSERT INTO `spell_chain` VALUES
  16 (53120,0,53120,1,0),
  17 (53121,53120,53120,2,0),
  18 (53122,53121,53120,3,0),
  19 (53123,53122,53120,4,0),
  20 (53124,53123,53120,5,0),
  21 (53040,53124,53120,6,0);
  22
  23 /* Master of Anatomy (Skinning) */
  24 DELETE FROM `spell_chain` WHERE `spell_id` IN (53125,53662,53663,53664,53665,53666);
  25 INSERT INTO `spell_chain` VALUES
  26 (53125,0,53125,1,0),
  27 (53662,53125,53125,2,0),
  28 (53663,53662,53125,3,0),
  29 (53664,53663,53125,4,0),
  30 (53665,53664,53125,5,0),
  31 (53666,53665,53125,6,0);