Advertisement
Guest User

Untitled

a guest
May 29th, 2017
94
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.70 KB | None | 0 0
  1. -- delete chars belonging to no account
  2. DELETE FROM `characters` WHERE `account` NOT IN(SELECT id FROM `realmd`.`account`);
  3.  
  4. -- delete account-data belonging to no account
  5. DELETE FROM `account_data` WHERE `account` NOT IN(SELECT id FROM `realmd`.`account`);
  6.  
  7. -- cleanup characters. remove anything left from no longer existing characters
  8. DELETE FROM `character_account_data` WHERE guid NOT IN(SELECT guid FROM `characters`);
  9. DELETE FROM `character_achievement` WHERE guid NOT IN(SELECT guid FROM `characters`);
  10. DELETE FROM `character_achievement_progress` WHERE guid NOT IN(SELECT guid FROM `characters`);
  11. DELETE FROM `character_action` WHERE guid NOT IN(SELECT guid FROM `characters`);
  12. DELETE FROM `character_aura` WHERE guid NOT IN(SELECT guid FROM `characters`);
  13. DELETE FROM `character_battleground_data` WHERE guid NOT IN(SELECT guid FROM `characters`);
  14. DELETE FROM `character_declinedname` WHERE guid NOT IN(SELECT guid FROM `characters`);
  15. DELETE FROM `character_equipmentsets` WHERE guid NOT IN(SELECT guid FROM `characters`);
  16. DELETE FROM `character_gifts` WHERE guid NOT IN(SELECT guid FROM `characters`);
  17. DELETE FROM `character_glyphs` WHERE guid NOT IN(SELECT guid FROM `characters`);
  18. DELETE FROM `character_homebind` WHERE guid NOT IN(SELECT guid FROM `characters`);
  19. DELETE FROM `character_instance` WHERE guid NOT IN(SELECT guid FROM `characters`);
  20. DELETE FROM `character_inventory` WHERE guid NOT IN(SELECT guid FROM `characters`);
  21. DELETE FROM `character_pet` WHERE owner NOT IN(SELECT guid FROM `characters`);
  22. DELETE FROM `character_pet_declinedname` WHERE owner NOT IN(SELECT guid FROM `characters`);
  23. DELETE FROM `character_queststatus` WHERE guid NOT IN(SELECT guid FROM `characters`);
  24. DELETE FROM `character_queststatus_daily` WHERE guid NOT IN(SELECT guid FROM `characters`);
  25. DELETE FROM `character_reputation` WHERE guid NOT IN(SELECT guid FROM `characters`);
  26. DELETE FROM `character_social` WHERE guid NOT IN(SELECT guid FROM `characters`);
  27. DELETE FROM `character_spell` WHERE guid NOT IN(SELECT guid FROM `characters`);
  28. DELETE FROM `character_spell_cooldown` WHERE guid NOT IN(SELECT guid FROM `characters`);
  29. DELETE FROM `character_talent` WHERE guid NOT IN(SELECT guid FROM `characters`);
  30. DELETE FROM `character_tutorial` WHERE account NOT IN(SELECT id FROM `realmd`.`account`);
  31.  
  32. -- cleanup guilds. delete anything left from no longer existing guilds
  33. DELETE FROM `guild_member` WHERE guid NOT IN(SELECT guid FROM `characters`);
  34. DELETE FROM `guild` WHERE (SELECT COUNT(*) FROM `guild_member` WHERE `guildid` = `guild`.`guildid`) = 0;
  35. DELETE FROM `guild_bank_eventlog` WHERE guildid NOT IN(SELECT guildid FROM `guild`);
  36. DELETE FROM `guild_bank_item` WHERE guildid NOT IN(SELECT guildid FROM `guild`);
  37. DELETE FROM `guild_bank_right` WHERE guildid NOT IN(SELECT guildid FROM `guild`);
  38. DELETE FROM `guild_bank_tab` WHERE guildid NOT IN(SELECT guildid FROM `guild`);
  39. DELETE FROM `guild_eventlog` WHERE guildid NOT IN(SELECT guildid FROM `guild`);
  40. DELETE FROM `guild_member` WHERE guildid NOT IN(SELECT guildid FROM `guild`);
  41. DELETE FROM `guild_rank` WHERE guildid NOT IN(SELECT guildid FROM `guild`);
  42.  
  43. -- cleanup pets. delete anything left from no longer existing pets
  44. DELETE FROM `pet_aura` WHERE guid NOT IN(SELECT id FROM `character_pet`);
  45. DELETE FROM `pet_aura` WHERE caster_guid NOT IN(SELECT guid FROM `characters`);
  46. DELETE FROM `pet_spell` WHERE guid NOT IN(SELECT id FROM `character_pet`);
  47. DELETE FROM `pet_spell_cooldown` WHERE guid NOT IN(SELECT id FROM `character_pet`);
  48.  
  49.  
  50. -- delete items having no owner
  51. DELETE FROM `item_instance` WHERE guid NOT IN(SELECT item FROM `character_inventory`) AND guid NOT IN(SELECT item_guid FROM `guild_bank_item`) AND guid NOT IN(SELECT item_guid FROM `mail_items`);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement