sql/updates/8249_02_mangos_spell_chain.sql

   1 ALTER TABLE db_version CHANGE COLUMN required_8249_01_mangos_spell_proc_item_enchant required_8249_02_mangos_spell_chain bit;
   2
   3 DELETE FROM `spell_chain` WHERE `spell_id` IN
   4 (8034, 8037, 10458, 16352, 16353, 25501, 58797, 58798, 58799, 8680, 8685, 8689, 11335, 11336, 11337, 26890, 57964, 57965, 13218, 13222, 13223, 13224, 27189, 57974, 57975);
   5
   6 INSERT INTO `spell_chain` (`spell_id`, `prev_spell`, `first_spell`, `rank`, `req_spell`) VALUES
   7 (8034,0,8034,1,0),     -- Frostbrand Attack
   8 (8037,8034,8034,2,0),
   9 (10458,8037,8034,3,0),
  10 (16352,10458,8034,4,0),
  11 (16353,16352,8034,5,0),
  12 (25501,16353,8034,6,0),
  13 (58797,25501,8034,7,0),
  14 (58798,58797,8034,8,0),
  15 (58799,58798,8034,9,0),
  16 (8680,0,8680,1,0),     -- Instant Poison
  17 (8685,8680,8680,2,0),
  18 (8689,8685,8680,3,0),
  19 (11335,8689,8680,4,0),
  20 (11336,11335,8680,5,0),
  21 (11337,11336,8680,6,0),
  22 (26890,11337,8680,7,0),
  23 (57964,26890,8680,8,0),
  24 (57965,57964,8680,9,0),
  25 (13218,0,13218,1,0),   -- Wound Poison
  26 (13222,13218,13218,2,0),
  27 (13223,13222,13218,3,0),
  28 (13224,13223,13218,4,0),
  29 (27189,13224,13218,5,0),
  30 (57974,27189,13218,6,0),
  31 (57975,57974,13218,7,0);