diff options
| author | megamage <none@none> | 2009-02-18 11:36:19 -0600 |
|---|---|---|
| committer | megamage <none@none> | 2009-02-18 11:36:19 -0600 |
| commit | 31637d4aac6ae2081ccb3db976cab17936019f1a (patch) | |
| tree | a0e098d4afafaddcb901486d00da1563ecd628b9 /sql/tools | |
| parent | 017f309b5b5b981b6edfe0ae071971d513828a20 (diff) | |
| parent | 7bff1c1d60b78ba78f2ab0a9c67bdde80427ea30 (diff) | |
*Merge.
--HG--
branch : trunk
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); + |