From df6d557a4d778093ec522d2c39c6c01acc41d978 Mon Sep 17 00:00:00 2001 From: Shauren Date: Tue, 26 Apr 2016 18:56:35 +0200 Subject: Core/Entities: Updated updatefields to 7.0.3.21414 --- sql/base/characters_database.sql | 1 - sql/updates/characters/2016_xx_xx_xx_characters_legion_03.sql | 1 + sql/updates/world/2016_xx_xx_xx_world_legion_01.sql | 1 + 3 files changed, 2 insertions(+), 1 deletion(-) create mode 100644 sql/updates/characters/2016_xx_xx_xx_characters_legion_03.sql create mode 100644 sql/updates/world/2016_xx_xx_xx_world_legion_01.sql (limited to 'sql') diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql index 1d9fc2dcfcc..1f20780bc92 100644 --- a/sql/base/characters_database.sql +++ b/sql/base/characters_database.sql @@ -1460,7 +1460,6 @@ CREATE TABLE `character_stats` ( `agility` int(10) unsigned NOT NULL DEFAULT '0', `stamina` int(10) unsigned NOT NULL DEFAULT '0', `intellect` int(10) unsigned NOT NULL DEFAULT '0', - `spirit` int(10) unsigned NOT NULL DEFAULT '0', `armor` int(10) unsigned NOT NULL DEFAULT '0', `resHoly` int(10) unsigned NOT NULL DEFAULT '0', `resFire` int(10) unsigned NOT NULL DEFAULT '0', diff --git a/sql/updates/characters/2016_xx_xx_xx_characters_legion_03.sql b/sql/updates/characters/2016_xx_xx_xx_characters_legion_03.sql new file mode 100644 index 00000000000..03320194c94 --- /dev/null +++ b/sql/updates/characters/2016_xx_xx_xx_characters_legion_03.sql @@ -0,0 +1 @@ +ALTER TABLE `character_stats` DROP `spirit`; diff --git a/sql/updates/world/2016_xx_xx_xx_world_legion_01.sql b/sql/updates/world/2016_xx_xx_xx_world_legion_01.sql new file mode 100644 index 00000000000..44e87058b38 --- /dev/null +++ b/sql/updates/world/2016_xx_xx_xx_world_legion_01.sql @@ -0,0 +1 @@ +DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_sha_mana_tide_totem'; -- cgit v1.2.3