/sql/old/ancient/3.3.5a/TDB48_to_TDB49_updates/world/2012_08_27_02_world_playercreateinfo_spell.sql

https://gitlab.com/trinitycore/TrinityCore_434 · SQL · 9 lines · 9 code · 0 blank · 0 comment · 0 complexity · 1c1e3a5835ce1f5599ca36754d852d29 MD5 · raw file 

    

  1. DELETE FROM `playercreateinfo_spell` WHERE `Spell` IN (59221,59535,59536,59538,59539,59540,59541);
    2. 

  2. INSERT INTO `playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES
    3. 

  3. (11,1,59221,'Shadow Resistance'),
    4. 

  4. (11,2,59535,'Shadow Resistance'),
    5. 

  5. (11,3,59536,'Shadow Resistance'),
    6. 

  6. (11,5,59538,'Shadow Resistance'),
    7. 

  7. (11,6,59539,'Shadow Resistance'),
    8. 

  8. (11,7,59540,'Shadow Resistance'),
    9. 

  9. (11,8,59541,'Shadow Resistance');
    10.