diff options
| -rw-r--r-- | sql/base/world_database.sql | 8 | ||||
| -rw-r--r-- | sql/updates/9830_world_spell_group.sql | 4 | ||||
| -rw-r--r-- | sql/updates/9830_world_spell_group_stack_rules.sql | 2 |
3 files changed, 12 insertions, 2 deletions
diff --git a/sql/base/world_database.sql b/sql/base/world_database.sql index 28a9c759db7..385d1a1151a 100644 --- a/sql/base/world_database.sql +++ b/sql/base/world_database.sql @@ -17770,7 +17770,10 @@ INSERT INTO `spell_group` (`id`, `spell_id`) VALUES (1109, 72590), -- Fortitude (Scroll) -- Immolate / Unstable Affliction (1112, 348), -(1112, 30108); +(1112, 30108), +-- Amplify Magic / Dampen Magic +(1113, 1008), +(1113, 604); /*!40000 ALTER TABLE `spell_group` ENABLE KEYS */; UNLOCK TABLES; @@ -19436,7 +19439,8 @@ INSERT INTO spell_group_stack_rules (`group_id`, `stack_rule`) VALUES (1108,1), (1109,1), (1110,1), -(1112,2); +(1112,2), +(1113,1); /*!40000 ALTER TABLE `spell_group_stack_rules` ENABLE KEYS */; UNLOCK TABLES; diff --git a/sql/updates/9830_world_spell_group.sql b/sql/updates/9830_world_spell_group.sql new file mode 100644 index 00000000000..e571f0d3a1a --- /dev/null +++ b/sql/updates/9830_world_spell_group.sql @@ -0,0 +1,4 @@ +DELETE FROM `spell_group` where `id`=1113; +INSERT INTO spell_group (id, spell_id) VALUES +(1113, 1008), +(1113, 604); diff --git a/sql/updates/9830_world_spell_group_stack_rules.sql b/sql/updates/9830_world_spell_group_stack_rules.sql new file mode 100644 index 00000000000..29d3079fc3f --- /dev/null +++ b/sql/updates/9830_world_spell_group_stack_rules.sql @@ -0,0 +1,2 @@ +DELETE FROM `spell_group_stack_rules` where `group_id`=1113; +INSERT INTO spell_group_stack_rules (group_id, stack_rule) VALUES (1113, 1); |