* Move sql updates for 0.11 release to sql/updates/0.11
[getmangos.git] / sql / updates / 0.11 / 5977_characters_pet.sql
blobf4454ca856f556835c25ea39699a4418c7949d34
1 DELETE FROM pet_aura           WHERE guid NOT IN (SELECT id FROM character_pet);
2 DELETE FROM pet_spell          WHERE guid NOT IN (SELECT id FROM character_pet);
3 DELETE FROM pet_spell_cooldown WHERE guid NOT IN (SELECT id FROM character_pet);