Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- delete chars belonging to no account
- DELETE FROM `characters` WHERE `account` NOT IN(SELECT id FROM `realmd`.`account`);
- -- delete account-data belonging to no account
- DELETE FROM `account_data` WHERE `account` NOT IN(SELECT id FROM `realmd`.`account`);
- -- cleanup characters. remove anything left from no longer existing characters
- DELETE FROM `character_account_data` WHERE guid NOT IN(SELECT guid FROM `characters`);
- DELETE FROM `character_achievement` WHERE guid NOT IN(SELECT guid FROM `characters`);
- DELETE FROM `character_achievement_progress` WHERE guid NOT IN(SELECT guid FROM `characters`);
- DELETE FROM `character_action` WHERE guid NOT IN(SELECT guid FROM `characters`);
- DELETE FROM `character_aura` WHERE guid NOT IN(SELECT guid FROM `characters`);
- DELETE FROM `character_battleground_data` WHERE guid NOT IN(SELECT guid FROM `characters`);
- DELETE FROM `character_declinedname` WHERE guid NOT IN(SELECT guid FROM `characters`);
- DELETE FROM `character_equipmentsets` WHERE guid NOT IN(SELECT guid FROM `characters`);
- DELETE FROM `character_gifts` WHERE guid NOT IN(SELECT guid FROM `characters`);
- DELETE FROM `character_glyphs` WHERE guid NOT IN(SELECT guid FROM `characters`);
- DELETE FROM `character_homebind` WHERE guid NOT IN(SELECT guid FROM `characters`);
- DELETE FROM `character_instance` WHERE guid NOT IN(SELECT guid FROM `characters`);
- DELETE FROM `character_inventory` WHERE guid NOT IN(SELECT guid FROM `characters`);
- DELETE FROM `character_pet` WHERE owner NOT IN(SELECT guid FROM `characters`);
- DELETE FROM `character_pet_declinedname` WHERE owner NOT IN(SELECT guid FROM `characters`);
- DELETE FROM `character_queststatus` WHERE guid NOT IN(SELECT guid FROM `characters`);
- DELETE FROM `character_queststatus_daily` WHERE guid NOT IN(SELECT guid FROM `characters`);
- DELETE FROM `character_reputation` WHERE guid NOT IN(SELECT guid FROM `characters`);
- DELETE FROM `character_social` WHERE guid NOT IN(SELECT guid FROM `characters`);
- DELETE FROM `character_spell` WHERE guid NOT IN(SELECT guid FROM `characters`);
- DELETE FROM `character_spell_cooldown` WHERE guid NOT IN(SELECT guid FROM `characters`);
- DELETE FROM `character_talent` WHERE guid NOT IN(SELECT guid FROM `characters`);
- DELETE FROM `character_tutorial` WHERE account NOT IN(SELECT id FROM `realmd`.`account`);
- -- cleanup guilds. delete anything left from no longer existing guilds
- DELETE FROM `guild_member` WHERE guid NOT IN(SELECT guid FROM `characters`);
- DELETE FROM `guild` WHERE (SELECT COUNT(*) FROM `guild_member` WHERE `guildid` = `guild`.`guildid`) = 0;
- DELETE FROM `guild_bank_eventlog` WHERE guildid NOT IN(SELECT guildid FROM `guild`);
- DELETE FROM `guild_bank_item` WHERE guildid NOT IN(SELECT guildid FROM `guild`);
- DELETE FROM `guild_bank_right` WHERE guildid NOT IN(SELECT guildid FROM `guild`);
- DELETE FROM `guild_bank_tab` WHERE guildid NOT IN(SELECT guildid FROM `guild`);
- DELETE FROM `guild_eventlog` WHERE guildid NOT IN(SELECT guildid FROM `guild`);
- DELETE FROM `guild_member` WHERE guildid NOT IN(SELECT guildid FROM `guild`);
- DELETE FROM `guild_rank` WHERE guildid NOT IN(SELECT guildid FROM `guild`);
- -- cleanup pets. delete anything left from no longer existing pets
- DELETE FROM `pet_aura` WHERE guid NOT IN(SELECT id FROM `character_pet`);
- DELETE FROM `pet_aura` WHERE caster_guid NOT IN(SELECT guid FROM `characters`);
- DELETE FROM `pet_spell` WHERE guid NOT IN(SELECT id FROM `character_pet`);
- DELETE FROM `pet_spell_cooldown` WHERE guid NOT IN(SELECT id FROM `character_pet`);
- -- delete items having no owner
- 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