moonwell-core-vanilla/sql/migrations/20260617025134_world.sql

DROP PROCEDURE IF EXISTS add_migration;
DELIMITER ??
CREATE PROCEDURE `add_migration`()
BEGIN
DECLARE v INT DEFAULT 1;
SET v = (SELECT COUNT(*) FROM `migrations` WHERE `id`='20260617025134');
IF v = 0 THEN
INSERT INTO `migrations` VALUES ('20260617025134');
-- Add your query below.


-- Darnassus Auction House
UPDATE `gameobject_template` SET `data0` = 3 /*auctionHouseID*/ WHERE `entry`=153113;

-- Book "Soothsaying for Dummies"
DELETE FROM `gameobject_template` WHERE `entry`=177226;
INSERT INTO `gameobject_template` (`entry`, `patch`, `type`, `displayId`, `name`, `icon`, `faction`, `flags`, `size`, `data0`, `data1`, `data2`, `data3`, `data4`, `data5`, `data6`, `data7`, `data8`, `data9`, `data10`, `data11`, `data12`, `data13`, `data14`, `data15`, `data16`, `data17`, `data18`, `data19`, `data20`, `data21`, `data22`, `data23`, `mingold`, `maxgold`, `script_name`) VALUES (177226, 0, 10, 4677, 'Book "Soothsaying for Dummies"', '', 35, 4, 1, 0, 0, 0, 196608, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '');
INSERT INTO `gameobject_template` (`entry`, `patch`, `type`, `displayId`, `name`, `icon`, `faction`, `flags`, `size`, `data0`, `data1`, `data2`, `data3`, `data4`, `data5`, `data6`, `data7`, `data8`, `data9`, `data10`, `data11`, `data12`, `data13`, `data14`, `data15`, `data16`, `data17`, `data18`, `data19`, `data20`, `data21`, `data22`, `data23`, `mingold`, `maxgold`, `script_name`) VALUES (177226, 8, 2, 4677, 'Book "Soothsaying for Dummies"', '', 35, 4, 1, 0, 0, 1, 7058, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '');

-- Mudskunk Lure
UPDATE `gameobject_template` SET `data0` = 93 /*lockId*/ WHERE `entry`=180346;

-- Changes to notInCombat field of chests.
DELETE FROM `gameobject_template` WHERE `entry` IN (2843, 2849, 2850, 2852, 2855, 2857, 3714, 3715, 4096, 4149, 74447, 74448, 75293, 75295, 75296, 75297, 75298, 75299, 75300, 105570, 105578, 105579, 105581, 106318, 106319, 111095, 131978, 131979, 153451, 153453, 153454, 153463, 153464, 153468, 153469, 179547, 179548, 180228, 180229);
INSERT INTO `gameobject_template` (`entry`, `patch`, `type`, `displayId`, `name`, `icon`, `faction`, `flags`, `size`, `data0`, `data1`, `data2`, `data3`, `data4`, `data5`, `data6`, `data7`, `data8`, `data9`, `data10`, `data11`, `data12`, `data13`, `data14`, `data15`, `data16`, `data17`, `data18`, `data19`, `data20`, `data21`, `data22`, `data23`, `mingold`, `maxgold`, `script_name`) VALUES 
(2843, 0, 3, 259, 'Battered Chest', '', 94, 0, 1, 57, 2265, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 10, 20, ''),
(2849, 0, 3, 259, 'Battered Chest', '', 94, 0, 1, 57, 2280, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 60, 119, ''),
(2850, 0, 3, 259, 'Solid Chest', '', 94, 0, 1, 57, 2281, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 121, 208, ''),
(2852, 0, 3, 259, 'Solid Chest', '', 94, 0, 1, 57, 2282, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 145, 269, ''),
(2855, 0, 3, 259, 'Solid Chest', '', 94, 0, 1, 57, 2283, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 162, 315, ''),
(2857, 0, 3, 259, 'Solid Chest', '', 94, 0, 1, 57, 2284, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 205, 385, ''),
(3714, 0, 3, 259, 'Alliance Strongbox', '', 102, 2, 1, 5, 2281, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(3715, 0, 3, 259, 'Alliance Chest', '', 102, 0, 1, 57, 2281, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(4096, 0, 3, 259, 'Alliance Chest', '', 102, 0, 1, 57, 2282, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 211, 211, ''),
(4149, 0, 3, 259, 'Solid Chest', '', 94, 0, 1, 57, 5278, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 401, 791, ''),
(74447, 0, 3, 259, 'Large Iron Bound Chest', '', 94, 2, 1, 23, 4075, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(74448, 0, 3, 259, 'Large Solid Chest', '', 94, 0, 1, 57, 4075, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 388, 388, ''),
(75293, 0, 3, 259, 'Large Battered Chest', '', 94, 0, 1, 57, 4073, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 171, 240, ''),
(75295, 0, 3, 259, 'Large Iron Bound Chest', '', 94, 2, 1, 5, 4074, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(75296, 0, 3, 259, 'Large Iron Bound Chest', '', 94, 2, 1, 24, 4076, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(75297, 0, 3, 259, 'Large Iron Bound Chest', '', 94, 2, 1, 60, 4077, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(75298, 0, 3, 259, 'Large Solid Chest', '', 94, 0, 1, 57, 4074, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 245, 360, ''),
(75299, 0, 3, 259, 'Large Solid Chest', '', 94, 0, 1, 57, 4076, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 381, 395, ''),
(75300, 0, 3, 259, 'Large Solid Chest', '', 94, 0, 1, 57, 4077, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 568, 777, ''),
(105570, 0, 3, 259, 'Alliance Strongbox', '', 102, 2, 1, 24, 2283, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 267, 267, ''),
(105578, 0, 3, 259, 'Horde Chest', '', 101, 0, 1, 57, 2283, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(105579, 0, 3, 259, 'Alliance Chest', '', 102, 0, 1, 57, 2283, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(105581, 0, 3, 259, 'Alliance Chest', '', 102, 0, 1, 57, 2284, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 242, 242, ''),
(106318, 0, 3, 259, 'Battered Chest', '', 94, 0, 1, 57, 2277, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(106319, 0, 3, 259, 'Battered Chest', '', 94, 0, 1, 57, 2279, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 30, 75, ''),
(111095, 0, 3, 259, 'Alliance Chest', '', 102, 0, 1, 57, 2280, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 101, 103, ''),
(131978, 0, 3, 259, 'Large Mithril Bound Chest', '', 94, 2, 1, 61, 5282, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(131979, 0, 3, 259, 'Large Darkwood Chest', '', 94, 0, 1, 57, 5282, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(153451, 0, 3, 259, 'Solid Chest', '', 94, 0, 1, 57, 9931, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(153453, 0, 3, 259, 'Solid Chest', '', 94, 0, 1, 57, 9932, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 980, 1461, ''),
(153454, 0, 3, 259, 'Solid Chest', '', 94, 0, 1, 57, 9933, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 816, 1594, ''),
(153463, 0, 3, 259, 'Large Solid Chest', '', 94, 0, 1, 57, 9935, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(153468, 0, 3, 259, 'Large Mithril Bound Chest', '', 94, 2, 1, 599, 9935, 0, 1, 0, 0, 0, 0, 0, 55, 1, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(153469, 0, 3, 259, 'Large Mithril Bound Chest', '', 94, 2, 1, 600, 9936, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1879, 1879, ''),
(179547, 1, 3, 4431, 'A Dusty Tome', '', 0, 0, 1.5, 93, 16563, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(179548, 1, 3, 4431, 'A Dusty Tome', '', 0, 0, 1.5, 93, 16564, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(180229, 5, 3, 6393, 'Jinxed Hoodoo Pile', '', 94, 0, 1, 43, 17259, 0, 1, 0, 0, 0, 180244, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(180228, 5, 3, 6393, 'Jinxed Hoodoo Pile', '', 94, 0, 1, 43, 17259, 0, 1, 0, 0, 0, 180247, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(153464, 0, 3, 259, 'Large Solid Chest', '', 94, 0, 1, 57, 9936, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1628, 2366, ''),
(2843, 7, 3, 259, 'Battered Chest', '', 94, 0, 1, 57, 2265, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 10, 20, ''),
(2849, 7, 3, 259, 'Battered Chest', '', 94, 0, 1, 57, 2280, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 60, 119, ''),
(2850, 7, 3, 259, 'Solid Chest', '', 94, 0, 1, 57, 2281, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 121, 208, ''),
(2852, 7, 3, 259, 'Solid Chest', '', 94, 0, 1, 57, 2282, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 145, 269, ''),
(2855, 7, 3, 259, 'Solid Chest', '', 94, 0, 1, 57, 2283, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 162, 315, ''),
(2857, 7, 3, 259, 'Solid Chest', '', 94, 0, 1, 57, 2284, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 205, 385, ''),
(3714, 7, 3, 259, 'Alliance Strongbox', '', 102, 2, 1, 5, 2281, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(3715, 7, 3, 259, 'Alliance Chest', '', 102, 0, 1, 57, 2281, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(4096, 7, 3, 259, 'Alliance Chest', '', 102, 0, 1, 57, 2282, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 211, 211, ''),
(4149, 7, 3, 259, 'Solid Chest', '', 94, 0, 1, 57, 5278, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 401, 791, ''),
(74447, 7, 3, 259, 'Large Iron Bound Chest', '', 94, 2, 1, 23, 4075, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(74448, 7, 3, 259, 'Large Solid Chest', '', 94, 0, 1, 57, 4075, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 388, 388, ''),
(75293, 7, 3, 259, 'Large Battered Chest', '', 94, 0, 1, 57, 4073, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 171, 240, ''),
(75295, 7, 3, 259, 'Large Iron Bound Chest', '', 94, 2, 1, 5, 4074, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(75296, 7, 3, 259, 'Large Iron Bound Chest', '', 94, 2, 1, 24, 4076, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(75297, 7, 3, 259, 'Large Iron Bound Chest', '', 94, 2, 1, 60, 4077, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(75298, 7, 3, 259, 'Large Solid Chest', '', 94, 0, 1, 57, 4074, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 245, 360, ''),
(75299, 7, 3, 259, 'Large Solid Chest', '', 94, 0, 1, 57, 4076, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 381, 395, ''),
(75300, 7, 3, 259, 'Large Solid Chest', '', 94, 0, 1, 57, 4077, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 568, 777, ''),
(105570, 7, 3, 259, 'Alliance Strongbox', '', 102, 2, 1, 24, 2283, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 267, 267, ''),
(105578, 7, 3, 259, 'Horde Chest', '', 101, 0, 1, 57, 2283, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(105579, 7, 3, 259, 'Alliance Chest', '', 102, 0, 1, 57, 2283, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(105581, 7, 3, 259, 'Alliance Chest', '', 102, 0, 1, 57, 2284, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 242, 242, ''),
(106318, 7, 3, 259, 'Battered Chest', '', 94, 0, 1, 57, 2277, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(106319, 7, 3, 259, 'Battered Chest', '', 94, 0, 1, 57, 2279, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 30, 75, ''),
(111095, 7, 3, 259, 'Alliance Chest', '', 102, 0, 1, 57, 2280, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 101, 103, ''),
(131978, 7, 3, 259, 'Large Mithril Bound Chest', '', 94, 2, 1, 61, 5282, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(131979, 7, 3, 259, 'Large Darkwood Chest', '', 94, 0, 1, 57, 5282, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(153451, 7, 3, 259, 'Solid Chest', '', 94, 0, 1, 57, 9931, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(153453, 7, 3, 259, 'Solid Chest', '', 94, 0, 1, 57, 9932, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 980, 1461, ''),
(153454, 7, 3, 259, 'Solid Chest', '', 94, 0, 1, 57, 9933, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 816, 1594, ''),
(153463, 7, 3, 259, 'Large Solid Chest', '', 94, 0, 1, 57, 9935, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(153468, 7, 3, 259, 'Large Mithril Bound Chest', '', 94, 2, 1, 599, 9935, 0, 1, 0, 0, 0, 0, 0, 55, 1, 0, 1, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(153469, 7, 3, 259, 'Large Mithril Bound Chest', '', 94, 2, 1, 600, 9936, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1879, 1879, ''),
(179547, 7, 3, 4431, 'A Dusty Tome', '', 0, 0, 1.5, 93, 16563, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(179548, 7, 3, 4431, 'A Dusty Tome', '', 0, 0, 1.5, 93, 16564, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(180229, 7, 3, 6393, 'Jinxed Hoodoo Pile', '', 94, 0, 1, 43, 17259, 0, 1, 0, 0, 0, 180244, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(180228, 7, 3, 6393, 'Jinxed Hoodoo Pile', '', 94, 0, 1, 43, 17259, 0, 1, 0, 0, 0, 180247, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(153464, 7, 3, 259, 'Large Solid Chest', '', 94, 0, 1, 57, 9936, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1628, 2366, '');

-- Gadgetzan Auction
UPDATE `gameobject_template` SET `data0` = 7 /*auctionHouseID*/ WHERE `entry`=175904;

-- Guarded Thunderbrew Ale Barrel
DELETE FROM `gameobject_template` WHERE `entry`=269;
INSERT INTO `gameobject_template` (`entry`, `patch`, `type`, `displayId`, `name`, `icon`, `faction`, `flags`, `size`, `data0`, `data1`, `data2`, `data3`, `data4`, `data5`, `data6`, `data7`, `data8`, `data9`, `data10`, `data11`, `data12`, `data13`, `data14`, `data15`, `data16`, `data17`, `data18`, `data19`, `data20`, `data21`, `data22`, `data23`, `mingold`, `maxgold`, `script_name`) VALUES (269, 0, 2, 32, 'Guarded Thunderbrew Ale Barrel', '', 84, 0, 1, 0, 192, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '');
INSERT INTO `gameobject_template` (`entry`, `patch`, `type`, `displayId`, `name`, `icon`, `faction`, `flags`, `size`, `data0`, `data1`, `data2`, `data3`, `data4`, `data5`, `data6`, `data7`, `data8`, `data9`, `data10`, `data11`, `data12`, `data13`, `data14`, `data15`, `data16`, `data17`, `data18`, `data19`, `data20`, `data21`, `data22`, `data23`, `mingold`, `maxgold`, `script_name`) VALUES (269, 7, 2, 32, 'Guarded Thunder Ale Barrel', '', 84, 0, 1, 0, 192, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '');

-- Corrupted Whipper Root
UPDATE `gameobject_template` SET `data1` = 3627 /*questList*/ WHERE `entry`=174606;

-- Corrupted Night Dragon
UPDATE `gameobject_template` SET `data1` = 3625 /*questList*/ WHERE `entry`=174608;

-- Cleansed Windblossom
UPDATE `gameobject_template` SET `data0` = 43 /*lockId*/ WHERE `entry`=174710;

-- Cleansed Night Dragon
UPDATE `gameobject_template` SET `data0` = 43 /*lockId*/ WHERE `entry`=174685;

-- Firework Rocket, Type 1 Purple
UPDATE `gameobject_template` SET `data3` = 196608 /*autoCloseTime*/ WHERE `entry`=180856;

-- PVP HOLIDAY HORDE CTF
UPDATE `gameobject_template` SET `displayId` = 6386 WHERE `entry`=180394 && `patch`=5;

-- Warlock Mount Ritual Circle
UPDATE `gameobject_template` SET `type` = 1 /*button*/ WHERE `entry`=179668;

-- Warlock Mount Quest Symbol 1
UPDATE `gameobject_template` SET `type` = 10 /*goober*/ WHERE `entry`=179669;

-- Warlock Mount Quest Symbol 2
UPDATE `gameobject_template` SET `type` = 10 /*goober*/ WHERE `entry`=179670;

-- Warlock Mount Quest Symbol 3
UPDATE `gameobject_template` SET `type` = 10 /*goober*/ WHERE `entry`=179671;


-- End of migration.
END IF;
END??
DELIMITER ;
CALL add_migration();
DROP PROCEDURE IF EXISTS add_migration;