diff options
| author | ariel- <ariel-@users.noreply.github.com> | 2016-10-30 07:18:57 -0300 |
|---|---|---|
| committer | ariel- <ariel-@users.noreply.github.com> | 2016-10-30 07:31:42 -0300 |
| commit | e84dfff4cee74baf2c02cc7752df5bf392eae180 (patch) | |
| tree | 9d9bd857a29cd4da03fe3ec4541659b3144dd9f8 /sql/updates/characters | |
| parent | 5d9d25d5960a29d098035f9382a7b022e5294229 (diff) | |
Core/Auras: don't save auras casted by items
- Drop useless field from DB (itemGuid was being saved, but never used, see Prepared Statements)
- This type of auras (like Water Bucket, Precious Ribbon, etc) will be recasted on login anyways.
This reverts commit 16cfd59f5b368fd1d05eeeab3afbacfccf0a6870
Diffstat (limited to 'sql/updates/characters')
| -rw-r--r-- | sql/updates/characters/3.3.5/2016_10_30_00_characters.sql | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/sql/updates/characters/3.3.5/2016_10_30_00_characters.sql b/sql/updates/characters/3.3.5/2016_10_30_00_characters.sql new file mode 100644 index 00000000000..f72e8c32e22 --- /dev/null +++ b/sql/updates/characters/3.3.5/2016_10_30_00_characters.sql @@ -0,0 +1,2 @@ +DELETE FROM `character_aura` WHERE `itemGuid` != 0; +ALTER TABLE `character_aura` DROP COLUMN `itemGuid`; |