Backed out changeset 774aad302c74 - mangos [8247]

--HG--
branch : trunk

2 files changed, 1 insertions, 34 deletions

diff --git a/sql/mangos.sql b/sql/mangos.sql
index bd2e0838d65..5453a09ba83 100644
--- a/sql/mangos.sql
+++ b/sql/mangos.sql
@@ -23,7 +23,7 @@ DROP TABLE IF EXISTS `db_version`;
 CREATE TABLE `db_version` (
   `version` varchar(120) default NULL,
   `creature_ai_version` varchar(120) default NULL,
-  `required_8247_01_mangos_spell_bonus_data` bit(1) default NULL
+  `required_8237_01_mangos_creature_template` bit(1) default NULL
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Used DB version notes';
 
 --
@@ -17695,21 +17695,6 @@ CREATE TABLE `spell_bonus_data` (
 LOCK TABLES `spell_bonus_data` WRITE;
 /*!40000 ALTER TABLE `spell_bonus_data` DISABLE KEYS */;
 INSERT INTO `spell_bonus_data` VALUES
-('49941', '0', '0', '0.04', 'Death Knight - Blood Boil'),
-('55078', '0', '0', '0.055', 'Death Knight - Blood Plague Dummy Proc'),
-('50444', '0', '0', '0.105', 'Death Knight - Corpse Explosion Triggered'),
-('52212', '0', '0', '0.0475', 'Death Knight - Death and Decay Triggered'),
-('47632', '0', '0', '0.15', 'Death Knight - Death Coil Damage'),
-('47633', '0', '0', '0.15', 'Death Knight - Death Coil Heal'),
-('55095', '0', '0', '0.055', 'Death Knight - Frost Fever'),
-('49184', '0', '0', '0.1', 'Death Knight - Howling Blast'),
-('45477', '0', '0', '0.1', 'Death Knight - Icy Touch'),
-('50842', '0', '0', '0.04', 'Death Knight - Pestilence'),
-('47476', '0', '0', '0.06', 'Death Knight - Strangulate'),
-('50536', '0', '0', '0.013', 'Death Knight - Unholy Blight Triggered'),
-('50401', '0', '0', '0', 'Death Knight - Razor Frost'),
-('56903', '0', '0', '0', 'Death Knight - Lichflame'),
-
 ('5185', '1.6104', '0', '0', 'Druid - Healing Touch'),
 ('33763', '0', '0.09518', '0', 'Druid - Lifebloom'),
 ('774', '0', '0.37604', '0', 'Druid - Rejuvenation'),
diff --git a/sql/updates/8247_01_mangos_spell_bonus_data.sql.tbd b/sql/updates/8247_01_mangos_spell_bonus_data.sql.tbd
deleted file mode 100644
index 9af02b45d51..00000000000
--- a/sql/updates/8247_01_mangos_spell_bonus_data.sql.tbd
+++ /dev/null
@@ -1,18 +0,0 @@
-ALTER TABLE db_version CHANGE COLUMN required_8237_01_mangos_creature_template required_8247_01_mangos_spell_bonus_data bit;
-
-DELETE FROM `spell_bonus_data` where entry in (49941, 55078, 50444, 52212, 47632, 47633, 55095, 49184, 45477, 45477, 50842, 47476, 50536, 50401, 56903);
-INSERT INTO `spell_bonus_data`(`entry`, `direct_bonus`, `dot_bonus`, `ap_bonus`, `comments`) VALUES
-(49941, 0, 0, 0.04, "Death Knight - Blood Boil"),
-(55078, 0, 0, 0.055, "Death Knight - Blood Plague Dummy Proc"),
-(50444, 0, 0, 0.105, "Death Knight - Corpse Explosion Triggered"),
-(52212, 0, 0, 0.0475, "Death Knight - Death and Decay Triggered"),
-(47632, 0, 0, 0.15, "Death Knight - Death Coil Damage"),
-(47633, 0, 0, 0.15, "Death Knight - Death Coil Heal"),
-(55095, 0, 0, 0.055, "Death Knight - Frost Fever"),
-(49184, 0, 0, 0.1, "Death Knight - Howling Blast"),
-(45477, 0, 0, 0.1, "Death Knight - Icy Touch"),
-(50842, 0, 0, 0.04, "Death Knight - Pestilence"),
-(47476, 0, 0, 0.06, "Death Knight - Strangulate"),
-(50536, 0, 0, 0.013, "Death Knight - Unholy Blight Triggered"),
-(50401, 0, 0, 0, "Death Knight - Razor Frost"),
-(56903, 0, 0, 0, "Death Knight - Lichflame");