diff options
| author | megamage <none@none> | 2009-02-17 21:54:48 -0600 |
|---|---|---|
| committer | megamage <none@none> | 2009-02-17 21:54:48 -0600 |
| commit | 89ba43ef3e3f8d4b563c9e8efaf06bf7f7b44065 (patch) | |
| tree | fbe73c4d529f195d51b8ca4b62be8443da80becf /sql/tools | |
| parent | be53cfe1044d7e913c4c11a7245e2d2846826363 (diff) | |
| parent | 3931b802f1b8b890a615e5b2a4c0ed70407468d7 (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); + |