?  search:
summary | log | graphiclog1 | graphiclog2 | commit | commitdiff | tree | refs | edit | fork
history | raw | HEAD
[8587] MaNGOS 0.14 release.
[getmangos.git] / sql / tools / characters_pet_data_cleanup.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);
MaNGOS is a free, Open Source implementation of a game server compatible with the original World of Warcraft client.