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 | |
| 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')
| -rw-r--r-- | sql/updates/characters/3.3.5/2016_10_30_00_characters.sql | 2 | ||||
| -rw-r--r-- | sql/updates/world/3.3.5/2016_10_30_02_world.sql | 1 |
2 files changed, 3 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`; diff --git a/sql/updates/world/3.3.5/2016_10_30_02_world.sql b/sql/updates/world/3.3.5/2016_10_30_02_world.sql new file mode 100644 index 00000000000..0d39b8eb6f9 --- /dev/null +++ b/sql/updates/world/3.3.5/2016_10_30_02_world.sql @@ -0,0 +1 @@ +DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_hallows_end_has_water_bucket'; |