From e84dfff4cee74baf2c02cc7752df5bf392eae180 Mon Sep 17 00:00:00 2001 From: ariel- Date: Sun, 30 Oct 2016 07:18:57 -0300 Subject: 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 --- sql/updates/characters/3.3.5/2016_10_30_00_characters.sql | 2 ++ sql/updates/world/3.3.5/2016_10_30_02_world.sql | 1 + 2 files changed, 3 insertions(+) create mode 100644 sql/updates/characters/3.3.5/2016_10_30_00_characters.sql create mode 100644 sql/updates/world/3.3.5/2016_10_30_02_world.sql (limited to 'sql/updates') 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'; -- cgit v1.2.3