diff options
| author | Vincent-Michael <Vincent_Michael@gmx.de> | 2015-04-07 00:07:11 +0200 |
|---|---|---|
| committer | Vincent-Michael <Vincent_Michael@gmx.de> | 2015-04-07 00:07:11 +0200 |
| commit | a063f5e974feefb03b499faa1244c951f563ec47 (patch) | |
| tree | 34692ae1b3ff1cf565cc15070cae7db1deac5ce2 | |
| parent | ee8e850fc3fa3e2004fae3dc65a9380aec3ea25a (diff) | |
DB/Hotfixes: Added BattlePetSpecies hotfixes for 9dbe55b3197dcab233e7aeadafbde3164cd1b37b
| -rw-r--r-- | sql/updates/hotfixes/2015_04_07_00_hotfixes.sql | 16 | ||||
| -rw-r--r-- | sql/updates/hotfixes/2015_04_07_01_hotfixes.sql | 4 |
2 files changed, 20 insertions, 0 deletions
diff --git a/sql/updates/hotfixes/2015_04_07_00_hotfixes.sql b/sql/updates/hotfixes/2015_04_07_00_hotfixes.sql new file mode 100644 index 00000000000..4dd11328bbf --- /dev/null +++ b/sql/updates/hotfixes/2015_04_07_00_hotfixes.sql @@ -0,0 +1,16 @@ +DROP TABLE IF EXISTS `battle_pet_species`; +CREATE TABLE IF NOT EXISTS `battle_pet_species` ( + `ID` INT(10) UNSIGNED NOT NULL DEFAULT '0', + `CreatureID` INT(10) UNSIGNED NOT NULL DEFAULT '0', + `IconFileID` INT(10) UNSIGNED NOT NULL DEFAULT '0', + `SummonSpellID` INT(10) UNSIGNED NOT NULL DEFAULT '0', + `PetType` INT(11) NOT NULL DEFAULT '0', + `Source` INT(10) UNSIGNED NOT NULL DEFAULT '0', + `Flags` INT(10) UNSIGNED NOT NULL DEFAULT '0', + `SourceText` TEXT, + `Description` TEXT, + `VerifiedBuild` SMALLINT(6) NOT NULL DEFAULT '0' +) ENGINE=MYISAM DEFAULT CHARSET=utf8; + +ALTER TABLE `battle_pet_species` + ADD PRIMARY KEY (`ID`); diff --git a/sql/updates/hotfixes/2015_04_07_01_hotfixes.sql b/sql/updates/hotfixes/2015_04_07_01_hotfixes.sql new file mode 100644 index 00000000000..2030f8cc718 --- /dev/null +++ b/sql/updates/hotfixes/2015_04_07_01_hotfixes.sql @@ -0,0 +1,4 @@ +DELETE FROM `battle_pet_species` WHERE `ID` IN (1449, 1636); +INSERT INTO `battle_pet_species` (`ID`, `CreatureID`, `IconFileID`, `SummonSpellID`, `PetType`, `Source`, `Flags`, `SourceText`, `Description`, `VerifiedBuild`) VALUES +(1449, 84521, 1044497, 169220, 7, 2, 18, '|cFFFFD200Vendor:|r Guild Vendor|n|cFFFFD200Zone:|r Stormwind, Orgrimmar|n|cFFFFD200Cost: |r300|TINTERFACE\\MONEYFRAME\\UI-GOLDICON.BLP:0|t', 'This hatchling has an unusual sense that allows it to detect and follow along with alpha predators.', 19831), -- 1449 +(1636, 90345, 134509, 179954, 9, 5, 82, '|cFFFFD200Achievement: |rBig Rocketeer: Gold|n|cFFFFD200Category: |rDarkmoon Faire', 'One of the Darkmoon Race''s most obnoxious obstacles, now in the palm of your hand!', 19831); -- 1636 |