diff options
Diffstat (limited to 'sql/tools')
| -rw-r--r-- | sql/tools/characters_item_duplicates_remove.sql | 1 | ||||
| -rw-r--r-- | sql/tools/characters_pet_data_cleanup.sql | 1 |
2 files changed, 2 insertions, 0 deletions
diff --git a/sql/tools/characters_item_duplicates_remove.sql b/sql/tools/characters_item_duplicates_remove.sql index 9cdd8738ecd..fdd88262b2e 100644 --- a/sql/tools/characters_item_duplicates_remove.sql +++ b/sql/tools/characters_item_duplicates_remove.sql @@ -20,3 +20,4 @@ DELETE FROM guild_bank_item WHERE item_guid IN (SELECT item_guid FROM item_test DELETE FROM guild_bank_item WHERE item_guid IN (SELECT item_guid FROM item_test WHERE `source`='m'); DROP TABLE IF EXISTS item_test; + diff --git a/sql/tools/characters_pet_data_cleanup.sql b/sql/tools/characters_pet_data_cleanup.sql index f4454ca856f..06c48882780 100644 --- a/sql/tools/characters_pet_data_cleanup.sql +++ b/sql/tools/characters_pet_data_cleanup.sql @@ -1,3 +1,4 @@ DELETE FROM pet_aura WHERE guid NOT IN (SELECT id FROM character_pet); 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); + |