aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorShauren <shauren.trinity@gmail.com>2016-04-26 18:56:35 +0200
committerShauren <shauren.trinity@gmail.com>2016-05-20 23:50:20 +0200
commitdf6d557a4d778093ec522d2c39c6c01acc41d978 (patch)
tree55ea1573d75628f8aa4516d4632607ad49c4a4f7 /sql
parent70102f32fe38ae7d49acbd5ddee0239602d3cb94 (diff)
Core/Entities: Updated updatefields to 7.0.3.21414
Diffstat (limited to 'sql')
-rw-r--r--sql/base/characters_database.sql1
-rw-r--r--sql/updates/characters/2016_xx_xx_xx_characters_legion_03.sql1
-rw-r--r--sql/updates/world/2016_xx_xx_xx_world_legion_01.sql1
3 files changed, 2 insertions, 1 deletions
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';