sql/updates/7067_02_mangos_spell_learn_spell.sql

   1 ALTER TABLE db_version CHANGE COLUMN required_7067_01_mangos_playercreateinfo_spell required_7067_02_mangos_spell_learn_spell bit;
   2
   3 ALTER TABLE spell_learn_spell
   4   ADD COLUMN Active tinyint(3) unsigned NOT NULL default '1' AFTER SpellID;
   5
   6 DELETE FROM spell_learn_spell WHERE Entry IN (
   7   71,768,783,1066,2458,2457,5487,5487,9634,9634,17002,24858,24866,
   8   33872,33873,33891,33891,33943,33943,33943,40123,40123
   9 );
  10
  11 INSERT INTO spell_learn_spell VALUES
  12 (71,7376,0),
  13 (768,3025,0),
  14 (783,5419,0),
  15 (1066,5421,0),
  16 (2457,21156,0),
  17 (2458,7381,0),
  18 (5487,1178,0),
  19 (5487,21178,0),
  20 (9634,9635,0),
  21 (9634,21178,0),
  22 (17002,24867,0),
  23 (24858,24905,0),
  24 (24866,24864,0),
  25 (33872,47179,0),
  26 (33873,47180,0),
  27 (33891,5420,0),
  28 (33891,34123,0),
  29 (33943,33948,0),
  30 (33943,34090,1),
  31 (33943,34764,0),
  32 (40123,40121,0),
  33 (40123,40122,0);