Removed trailing whitespaces and CRLFs
[getmangos.git] / sql / updates / 0.8 / 4076_character_spell.sql
blob653a2e9cc4c77b222be2330f680b6d4945b31592
1 DELETE FROM `character_spell` WHERE `spell` = '23301';
3 INSERT IGNORE INTO `character_spell`
4 SELECT `character`.`guid`,`playercreateinfo_spell`.`spell` AS `spell`, '65535' AS `slot`,`playercreateinfo_spell`.`Active` AS `active`
5 FROM `character`,`playercreateinfo_spell`
6 WHERE `character`.`class`=`playercreateinfo_spell`.`class` AND `character`.`race`=`playercreateinfo_spell`.`race`;