diff options
| -rw-r--r-- | sql/updates/hotfixes/2015_04_14_01_hotfixes.sql | 8 | ||||
| -rw-r--r-- | sql/updates/hotfixes/2015_04_14_02_hotfixes.sql | 17 |
2 files changed, 25 insertions, 0 deletions
diff --git a/sql/updates/hotfixes/2015_04_14_01_hotfixes.sql b/sql/updates/hotfixes/2015_04_14_01_hotfixes.sql new file mode 100644 index 00000000000..19cd5a72707 --- /dev/null +++ b/sql/updates/hotfixes/2015_04_14_01_hotfixes.sql @@ -0,0 +1,8 @@ +DROP TABLE IF EXISTS `spell_effect_group_size`; +CREATE TABLE IF NOT EXISTS `spell_effect_group_size` ( + `ID` INT(10) UNSIGNED NOT NULL DEFAULT '0', + `SpellEffectID` INT(10) UNSIGNED NOT NULL DEFAULT '0', + `Size` FLOAT NOT NULL DEFAULT '0', + `VerifiedBuild` SMALLINT(6) NOT NULL DEFAULT '0', + PRIMARY KEY (`ID`) +) ENGINE=MYISAM DEFAULT CHARSET=utf8; diff --git a/sql/updates/hotfixes/2015_04_14_02_hotfixes.sql b/sql/updates/hotfixes/2015_04_14_02_hotfixes.sql new file mode 100644 index 00000000000..31cbee6d777 --- /dev/null +++ b/sql/updates/hotfixes/2015_04_14_02_hotfixes.sql @@ -0,0 +1,17 @@ +DELETE FROM `hotfix_data` WHERE (`TableHash`=599752208 AND `RecordID`=1789 AND `Timestamp`=1428969324) OR (`TableHash`=599752208 AND `RecordID`=1790 AND `Timestamp`=1428969324) OR (`TableHash`=599752208 AND `RecordID`=1791 AND `Timestamp`=1428969324) OR (`TableHash`=599752208 AND `RecordID`=1792 AND `Timestamp`=1428969324) OR (`TableHash`=599752208 AND `RecordID`=1793 AND `Timestamp`=1428969324) OR (`TableHash`=599752208 AND `RecordID`=1794 AND `Timestamp`=1428969324); +INSERT INTO `hotfix_data` (`TableHash`, `RecordID`, `Timestamp`, `Deleted`) VALUES +(599752208, 1789, 1428969324, 0), -- SpellEffectGroupSize - 1789 - 1789 +(599752208, 1790, 1428969324, 0), -- SpellEffectGroupSize - 1790 - 1790 +(599752208, 1791, 1428969324, 0), -- SpellEffectGroupSize - 1791 - 1791 +(599752208, 1792, 1428969324, 0), -- SpellEffectGroupSize - 1792 - 1792 +(599752208, 1793, 1428969324, 0), -- SpellEffectGroupSize - 1793 - 1793 +(599752208, 1794, 1428969324, 0); -- SpellEffectGroupSize - 1794 - 1794 + +DELETE FROM `spell_effect_group_size` WHERE `ID` IN (1789, 1790, 1791, 1792, 1793, 1794); +INSERT INTO `spell_effect_group_size` (`ID`, `SpellEffectID`, `Size`, `VerifiedBuild`) VALUES +(1789, 241861, 1.25, 19865), -- 1789 +(1790, 233592, 1.25, 19865), -- 1790 +(1791, 229325, 1.43, 19865), -- 1791 +(1792, 229326, 1.43, 19865), -- 1792 +(1793, 249873, 1.43, 19865), -- 1793 +(1794, 249874, 1.43, 19865); -- 1794 |