2 files changed, 44 insertions, 0 deletions
diff --git a/sql/updates/8249_01_mangos_spell_proc_item_enchant.sql.tbd b/sql/updates/8249_01_mangos_spell_proc_item_enchant.sql.tbd
new file mode 100644
index 00000000000..d1502ba40fe
--- /dev/null
+++ b/sql/updates/8249_01_mangos_spell_proc_item_enchant.sql.tbd
@@ -0,0 +1,13 @@
+ALTER TABLE db_version CHANGE COLUMN required_8247_01_mangos_spell_bonus_data required_8249_01_mangos_spell_proc_item_enchant bit;
+
+DROP TABLE IF EXISTS `spell_proc_item_enchant`;
+CREATE TABLE `spell_proc_item_enchant` (
+  `entry` mediumint unsigned NOT NULL,
+  `ppmRate` float NOT NULL default '0',
+  PRIMARY KEY  (`entry`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+INSERT INTO `spell_proc_item_enchant` (`entry`, `ppmRate`) VALUES
+(8034, 9),        -- Frostbrand Weapon
+(8680, 8.5714),   -- Instant Poison
+(13218, 21.4286); -- Wound Poison
diff --git a/sql/updates/8249_02_mangos_spell_chain.sql.tbd b/sql/updates/8249_02_mangos_spell_chain.sql.tbd
new file mode 100644
index 00000000000..f3fda91c872
--- /dev/null
+++ b/sql/updates/8249_02_mangos_spell_chain.sql.tbd
@@ -0,0 +1,31 @@
+ALTER TABLE db_version CHANGE COLUMN required_8249_01_mangos_spell_proc_item_enchant required_8249_02_mangos_spell_chain bit;
+
+DELETE FROM `spell_chain` WHERE `spell_id` IN
+(8034, 8037, 10458, 16352, 16353, 25501, 58797, 58798, 58799, 8680, 8685, 8689, 11335, 11336, 11337, 26890, 57964, 57965, 13218, 13222, 13223, 13224, 27189, 57974, 57975);
+
+INSERT INTO `spell_chain` (`spell_id`, `prev_spell`, `first_spell`, `rank`, `req_spell`) VALUES
+(8034,0,8034,1,0),     -- Frostbrand Attack
+(8037,8034,8034,2,0),
+(10458,8037,8034,3,0),
+(16352,10458,8034,4,0),
+(16353,16352,8034,5,0),
+(25501,16353,8034,6,0),
+(58797,25501,8034,7,0),
+(58798,58797,8034,8,0),
+(58799,58798,8034,9,0),
+(8680,0,8680,1,0),     -- Instant Poison
+(8685,8680,8680,2,0),
+(8689,8685,8680,3,0),
+(11335,8689,8680,4,0),
+(11336,11335,8680,5,0),
+(11337,11336,8680,6,0),
+(26890,11337,8680,7,0),
+(57964,26890,8680,8,0),
+(57965,57964,8680,9,0),
+(13218,0,13218,1,0),   -- Wound Poison
+(13222,13218,13218,2,0),
+(13223,13222,13218,3,0),
+(13224,13223,13218,4,0),
+(27189,13224,13218,5,0),
+(57974,27189,13218,6,0),
+(57975,57974,13218,7,0);