root/trunk/sql/tools/characters_pet_data_cleanup.sql

Revision 2, 243 bytes (checked in by yumileroy, 17 years ago)

[svn] * Proper SVN structure

Original author: Neo2003
Date: 2008-10-02 16:23:55-05:00
Line 
1DELETE FROM pet_aura           WHERE guid NOT IN (SELECT id FROM character_pet);
2DELETE FROM pet_spell          WHERE guid NOT IN (SELECT id FROM character_pet);
3DELETE FROM pet_spell_cooldown WHERE guid NOT IN (SELECT id FROM character_pet);
Note: See TracBrowser for help on using the browser.