1 ALTER TABLE character_db_version CHANGE COLUMN required_7067_03_characters_character_spell required_7075_01_characters_character_spell bit;
3 DELETE FROM character_spell WHERE `spell` IN (
4 20580, /*old Shadowmeld*/
6 21009, /*old Shadowmeld Passive and new Elusiveness (learned as racial passive)*/
7 21184 /*old Seal of Righteousness*/
11 /*old Shadow Resistance, leaned as racial passive of race 5 */
12 DELETE FROM character_spell USING character_spell INNER JOIN characters ON character_spell.guid = characters.guid
13 WHERE character_spell.spell = 20579 AND characters.race <> 5;