repo.or.cz
/
getmangos.git
/
blob
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
log
|
graphiclog1
|
graphiclog2
|
commit
|
commitdiff
|
tree
|
refs
|
edit
|
fork
history
|
raw
|
HEAD
[8589] Merge branch '320' - Switch to support client version 3.2.2A
[getmangos.git]
/
sql
/
tools
/
characters_pet_data_cleanup.sql
blob
f4454ca856f556835c25ea39699a4418c7949d34
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);