moonwell-core-vanilla/sql/migrations/20230706181314_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`='20230706181314');
IF v=0 THEN
INSERT INTO `migrations` VALUES ('20230706181314');
-- Add your query below.


SET @OGUID = 38985;
SET @PTEMPLATE = 2723;

-- 148 Darkshore / 3662 / 3705 / Food Crate / Barrel of Milk
DELETE FROM `pool_template` WHERE `entry` IN (SELECT `pool_entry` FROM `pool_gameobject` WHERE `guid` IN (48497, 48517, 48523, 48552, 48560, 48561, 48617, 48631, 48649, 48703, 48768));
DELETE FROM `gameobject` WHERE `guid` IN (48497, 48517, 48523, 48552, 48560, 48561, 48617, 48631, 48649, 48703, 48768);
DELETE FROM `pool_gameobject` WHERE `guid` IN (48497, 48517, 48523, 48552, 48560, 48561, 48617, 48631, 48649, 48703, 48768);

INSERT INTO `gameobject` (`guid`, `id`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecsmin`, `spawntimesecsmax`, `animprogress`, `state`, `spawn_flags`, `visibility_mod`, `patch_min`, `patch_max`) VALUES
(@OGUID+1, 3662, 1, 4615.11, 55.1214, 69.5783, 0.733038, 0, 0, 0.358368, 0.93358, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+2, 3662, 1, 4678.39, 854.646, 0.067275, -0.855212, 0, 0, 0.414693, -0.909961, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+3, 3662, 1, 5004.29, 595.286, -0.009527, -2.04204, 0, 0, 0.85264, -0.522498, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+4, 3662, 1, 5689.33, 535.131, -0.138535, -2.94961, 0, 0, 0.995396, -0.095846, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+5, 3662, 1, 5847, 362.63, 21.3515, 0.261799, 0, 0, 0.130526, 0.991445, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+6, 3662, 1, 5969.26, 306.881, 21.6972, 0.942478, 0, 0, 0.45399, 0.891007, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+7, 3662, 1, 6533.32, 449.291, 7.14775, -1.0472, 0, 0, 0.5, -0.866025, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+8, 3662, 1, 6855.48, -519.677, 42.0321, 2.35619, 0, 0, 0.92388, 0.382683, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+9, 3662, 1, 6950.54, 451.91, -0.431376, 2.1293, 0, 0, 0.87462, 0.48481, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+10, 3662, 1, 7149.68, -693.176, 47.652, 1.65806, 0, 0, 0.737277, 0.67559, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+11, 3662, 1, 7726.56, -759.902, -0.136312, 0.610865, 0, 0, 0.300706, 0.953717, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+12, 3662, 1, 4426.08, 893.556, -0.042792, 2.9845, 0, 0, 0.996917, 0.0784664, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+13, 3662, 1, 4549.36, 147.76, 59.6469, 3.29869, 0, 0, -0.996917, 0.0784664, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+14, 3662, 1, 4617.77, 637.363, 6.31306, 5.00909, 0, 0, -0.594823, 0.803857, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+15, 3662, 1, 4647.16, 148.539, 57.4412, 2.18166, 0, 0, 0.887011, 0.461749, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+16, 3662, 1, 4650.62, 30.5862, 65.7867, 3.52557, 0, 0, -0.981627, 0.190812, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+17, 3662, 1, 4829.92, 708.399, -0.045442, 2.9845, 0, 0, 0.996917, 0.0784664, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+18, 3662, 1, 4917.39, 321.139, 36.771, 3.73501, 0, 0, -0.956305, 0.292372, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+19, 3662, 1, 5145.29, 617.566, -0.037272, 0.558504, 0, 0, 0.275637, 0.961262, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+20, 3662, 1, 5315.07, 564.513, -0.190099, 4.95674, 0, 0, -0.615661, 0.788011, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+21, 3662, 1, 5834.3, 539.571, -0.057862, 4.2237, 0, 0, -0.857167, 0.515038, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+22, 3662, 1, 5876.97, 302.757, 21.2154, 1.41372, 0, 0, 0.649447, 0.760406, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+23, 3662, 1, 5885.77, 346.45, 21.2875, 4.64258, 0, 0, -0.731354, 0.681998, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+24, 3662, 1, 5975.67, 354.649, 21.6378, 2.3911, 0, 0, 0.930417, 0.366502, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+25, 3662, 1, 6008.86, 357.106, 21.7976, 0.366518, 0, 0, 0.182235, 0.983255, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+26, 3662, 1, 6220.96, 597.689, -0.113123, 0.506145, 0, 0, 0.25038, 0.968148, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+27, 3662, 1, 6409.04, 534.059, 8.64784, 4.01426, 0, 0, -0.906307, 0.422619, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+28, 3662, 1, 6440.99, 357.079, 23.3301, 3.57793, 0, 0, -0.976295, 0.216442, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+29, 3662, 1, 6780.85, 518.787, -0.042954, 0.139624, 0, 0, 0.0697556, 0.997564, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+30, 3662, 1, 6803.02, -415.348, 40.6263, 4.85202, 0, 0, -0.656058, 0.75471, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+31, 3662, 1, 6808.16, -369.19, 40.3489, 3.28124, 0, 0, -0.997563, 0.0697661, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+32, 3662, 1, 6885.71, -481.783, 40.1436, 5.044, 0, 0, -0.580703, 0.814116, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+33, 3662, 1, 7178.08, -811.719, 39.9113, 5.044, 0, 0, -0.580703, 0.814116, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+34, 3662, 1, 7217.81, -840.879, 36.1172, 2.21657, 0, 0, 0.894934, 0.446199, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+35, 3662, 1, 7317.87, -363.313, -0.36937, 2.32129, 0, 0, 0.91706, 0.39875, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+36, 3662, 1, 7495.82, -711.328, -0.171201, 6.26573, 0, 0, -0.00872612, 0.999962, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+37, 3705, 1, 4615.11, 55.1214, 69.5783, 0.733038, 0, 0, 0.358368, 0.93358, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+38, 3705, 1, 4678.39, 854.646, 0.067275, -0.855212, 0, 0, 0.414693, -0.909961, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+39, 3705, 1, 5004.29, 595.286, -0.009527, -2.04204, 0, 0, 0.85264, -0.522498, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+40, 3705, 1, 5689.33, 535.131, -0.138535, -2.94961, 0, 0, 0.995396, -0.095846, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+41, 3705, 1, 5847, 362.63, 21.3515, 0.261799, 0, 0, 0.130526, 0.991445, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+42, 3705, 1, 5969.26, 306.881, 21.6972, 0.942478, 0, 0, 0.45399, 0.891007, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+43, 3705, 1, 6533.32, 449.291, 7.14775, -1.0472, 0, 0, 0.5, -0.866025, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+44, 3705, 1, 6855.48, -519.677, 42.0321, 2.35619, 0, 0, 0.92388, 0.382683, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+45, 3705, 1, 6950.54, 451.91, -0.431376, 2.1293, 0, 0, 0.87462, 0.48481, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+46, 3705, 1, 7149.68, -693.176, 47.652, 1.65806, 0, 0, 0.737277, 0.67559, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+47, 3705, 1, 7726.56, -759.902, -0.136312, 0.610865, 0, 0, 0.300706, 0.953717, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+48, 3705, 1, 4426.08, 893.556, -0.042792, 2.9845, 0, 0, 0.996917, 0.0784664, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+49, 3705, 1, 4549.36, 147.76, 59.6469, 3.29869, 0, 0, -0.996917, 0.0784664, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+50, 3705, 1, 4617.77, 637.363, 6.31306, 5.00909, 0, 0, -0.594823, 0.803857, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+51, 3705, 1, 4647.16, 148.539, 57.4412, 2.18166, 0, 0, 0.887011, 0.461749, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+52, 3705, 1, 4650.62, 30.5862, 65.7867, 3.52557, 0, 0, -0.981627, 0.190812, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+53, 3705, 1, 4829.92, 708.399, -0.045442, 2.9845, 0, 0, 0.996917, 0.0784664, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+54, 3705, 1, 4917.39, 321.139, 36.771, 3.73501, 0, 0, -0.956305, 0.292372, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+55, 3705, 1, 5145.29, 617.566, -0.037272, 0.558504, 0, 0, 0.275637, 0.961262, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+56, 3705, 1, 5315.07, 564.513, -0.190099, 4.95674, 0, 0, -0.615661, 0.788011, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+57, 3705, 1, 5834.3, 539.571, -0.057862, 4.2237, 0, 0, -0.857167, 0.515038, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+58, 3705, 1, 5876.97, 302.757, 21.2154, 1.41372, 0, 0, 0.649447, 0.760406, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+59, 3705, 1, 5885.77, 346.45, 21.2875, 4.64258, 0, 0, -0.731354, 0.681998, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+60, 3705, 1, 5975.67, 354.649, 21.6378, 2.3911, 0, 0, 0.930417, 0.366502, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+61, 3705, 1, 6008.86, 357.106, 21.7976, 0.366518, 0, 0, 0.182235, 0.983255, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+62, 3705, 1, 6220.96, 597.689, -0.113123, 0.506145, 0, 0, 0.25038, 0.968148, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+63, 3705, 1, 6409.04, 534.059, 8.64784, 4.01426, 0, 0, -0.906307, 0.422619, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+64, 3705, 1, 6440.99, 357.079, 23.3301, 3.57793, 0, 0, -0.976295, 0.216442, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+65, 3705, 1, 6780.85, 518.787, -0.042954, 0.139624, 0, 0, 0.0697556, 0.997564, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+66, 3705, 1, 6803.02, -415.348, 40.6263, 4.85202, 0, 0, -0.656058, 0.75471, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+67, 3705, 1, 6808.16, -369.19, 40.3489, 3.28124, 0, 0, -0.997563, 0.0697661, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+68, 3705, 1, 6885.71, -481.783, 40.1436, 5.044, 0, 0, -0.580703, 0.814116, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+69, 3705, 1, 7178.08, -811.719, 39.9113, 5.044, 0, 0, -0.580703, 0.814116, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+70, 3705, 1, 7217.81, -840.879, 36.1172, 2.21657, 0, 0, 0.894934, 0.446199, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+71, 3705, 1, 7317.87, -363.313, -0.36937, 2.32129, 0, 0, 0.91706, 0.39875, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+72, 3705, 1, 7495.82, -711.328, -0.171201, 6.26573, 0, 0, -0.00872612, 0.999962, 180, 180, 100, 1, 0, 0, 0, 10);

INSERT INTO `pool_template` (`entry`, `max_limit`, `description`, `patch_min`, `patch_max`) VALUES
(@PTEMPLATE+1, 1, 'Food Crate / Barrel of Milk - Darkshore', 0, 10),
(@PTEMPLATE+2, 1, 'Food Crate / Barrel of Milk - Darkshore', 0, 10),
(@PTEMPLATE+3, 1, 'Food Crate / Barrel of Milk - Darkshore', 0, 10),
(@PTEMPLATE+4, 1, 'Food Crate / Barrel of Milk - Darkshore', 0, 10),
(@PTEMPLATE+5, 1, 'Food Crate / Barrel of Milk - Darkshore', 0, 10),
(@PTEMPLATE+6, 1, 'Food Crate / Barrel of Milk - Darkshore', 0, 10),
(@PTEMPLATE+7, 1, 'Food Crate / Barrel of Milk - Darkshore', 0, 10),
(@PTEMPLATE+8, 1, 'Food Crate / Barrel of Milk - Darkshore', 0, 10),
(@PTEMPLATE+9, 1, 'Food Crate / Barrel of Milk - Darkshore', 0, 10),
(@PTEMPLATE+10, 1, 'Food Crate / Barrel of Milk - Darkshore', 0, 10),
(@PTEMPLATE+11, 1, 'Food Crate / Barrel of Milk - Darkshore', 0, 10),
(@PTEMPLATE+12, 1, 'Food Crate / Barrel of Milk - Darkshore', 0, 10),
(@PTEMPLATE+13, 1, 'Food Crate / Barrel of Milk - Darkshore', 0, 10),
(@PTEMPLATE+14, 1, 'Food Crate / Barrel of Milk - Darkshore', 0, 10),
(@PTEMPLATE+15, 1, 'Food Crate / Barrel of Milk - Darkshore', 0, 10),
(@PTEMPLATE+16, 1, 'Food Crate / Barrel of Milk - Darkshore', 0, 10),
(@PTEMPLATE+17, 1, 'Food Crate / Barrel of Milk - Darkshore', 0, 10),
(@PTEMPLATE+18, 1, 'Food Crate / Barrel of Milk - Darkshore', 0, 10),
(@PTEMPLATE+19, 1, 'Food Crate / Barrel of Milk - Darkshore', 0, 10),
(@PTEMPLATE+20, 1, 'Food Crate / Barrel of Milk - Darkshore', 0, 10),
(@PTEMPLATE+21, 1, 'Food Crate / Barrel of Milk - Darkshore', 0, 10),
(@PTEMPLATE+22, 1, 'Food Crate / Barrel of Milk - Darkshore', 0, 10),
(@PTEMPLATE+23, 1, 'Food Crate / Barrel of Milk - Darkshore', 0, 10),
(@PTEMPLATE+24, 1, 'Food Crate / Barrel of Milk - Darkshore', 0, 10),
(@PTEMPLATE+25, 1, 'Food Crate / Barrel of Milk - Darkshore', 0, 10),
(@PTEMPLATE+26, 1, 'Food Crate / Barrel of Milk - Darkshore', 0, 10),
(@PTEMPLATE+27, 1, 'Food Crate / Barrel of Milk - Darkshore', 0, 10),
(@PTEMPLATE+28, 1, 'Food Crate / Barrel of Milk - Darkshore', 0, 10),
(@PTEMPLATE+29, 1, 'Food Crate / Barrel of Milk - Darkshore', 0, 10),
(@PTEMPLATE+30, 1, 'Food Crate / Barrel of Milk - Darkshore', 0, 10),
(@PTEMPLATE+31, 1, 'Food Crate / Barrel of Milk - Darkshore', 0, 10),
(@PTEMPLATE+32, 1, 'Food Crate / Barrel of Milk - Darkshore', 0, 10),
(@PTEMPLATE+33, 1, 'Food Crate / Barrel of Milk - Darkshore', 0, 10),
(@PTEMPLATE+34, 1, 'Food Crate / Barrel of Milk - Darkshore', 0, 10),
(@PTEMPLATE+35, 1, 'Food Crate / Barrel of Milk - Darkshore', 0, 10),
(@PTEMPLATE+36, 1, 'Food Crate / Barrel of Milk - Darkshore', 0, 10);

INSERT INTO `pool_gameobject` (`guid`, `pool_entry`, `description`, `patch_min`, `patch_max`) VALUES 
(@OGUID+1, @PTEMPLATE+1, 'Food Crate / Barrel of Milk - Darkshore', 0, 10),
(@OGUID+2, @PTEMPLATE+2, 'Food Crate / Barrel of Milk - Darkshore', 0, 10),
(@OGUID+3, @PTEMPLATE+3, 'Food Crate / Barrel of Milk - Darkshore', 0, 10),
(@OGUID+4, @PTEMPLATE+4, 'Food Crate / Barrel of Milk - Darkshore', 0, 10),
(@OGUID+5, @PTEMPLATE+5, 'Food Crate / Barrel of Milk - Darkshore', 0, 10),
(@OGUID+6, @PTEMPLATE+6, 'Food Crate / Barrel of Milk - Darkshore', 0, 10),
(@OGUID+7, @PTEMPLATE+7, 'Food Crate / Barrel of Milk - Darkshore', 0, 10),
(@OGUID+8, @PTEMPLATE+8, 'Food Crate / Barrel of Milk - Darkshore', 0, 10),
(@OGUID+9, @PTEMPLATE+9, 'Food Crate / Barrel of Milk - Darkshore', 0, 10),
(@OGUID+10, @PTEMPLATE+10, 'Food Crate / Barrel of Milk - Darkshore', 0, 10),
(@OGUID+11, @PTEMPLATE+11, 'Food Crate / Barrel of Milk - Darkshore', 0, 10),
(@OGUID+12, @PTEMPLATE+12, 'Food Crate / Barrel of Milk - Darkshore', 0, 10),
(@OGUID+13, @PTEMPLATE+13, 'Food Crate / Barrel of Milk - Darkshore', 0, 10),
(@OGUID+14, @PTEMPLATE+14, 'Food Crate / Barrel of Milk - Darkshore', 0, 10),
(@OGUID+15, @PTEMPLATE+15, 'Food Crate / Barrel of Milk - Darkshore', 0, 10),
(@OGUID+16, @PTEMPLATE+16, 'Food Crate / Barrel of Milk - Darkshore', 0, 10),
(@OGUID+17, @PTEMPLATE+17, 'Food Crate / Barrel of Milk - Darkshore', 0, 10),
(@OGUID+18, @PTEMPLATE+18, 'Food Crate / Barrel of Milk - Darkshore', 0, 10),
(@OGUID+19, @PTEMPLATE+19, 'Food Crate / Barrel of Milk - Darkshore', 0, 10),
(@OGUID+20, @PTEMPLATE+20, 'Food Crate / Barrel of Milk - Darkshore', 0, 10),
(@OGUID+21, @PTEMPLATE+21, 'Food Crate / Barrel of Milk - Darkshore', 0, 10),
(@OGUID+22, @PTEMPLATE+22, 'Food Crate / Barrel of Milk - Darkshore', 0, 10),
(@OGUID+23, @PTEMPLATE+23, 'Food Crate / Barrel of Milk - Darkshore', 0, 10),
(@OGUID+24, @PTEMPLATE+24, 'Food Crate / Barrel of Milk - Darkshore', 0, 10),
(@OGUID+25, @PTEMPLATE+25, 'Food Crate / Barrel of Milk - Darkshore', 0, 10),
(@OGUID+26, @PTEMPLATE+26, 'Food Crate / Barrel of Milk - Darkshore', 0, 10),
(@OGUID+27, @PTEMPLATE+27, 'Food Crate / Barrel of Milk - Darkshore', 0, 10),
(@OGUID+28, @PTEMPLATE+28, 'Food Crate / Barrel of Milk - Darkshore', 0, 10),
(@OGUID+29, @PTEMPLATE+29, 'Food Crate / Barrel of Milk - Darkshore', 0, 10),
(@OGUID+30, @PTEMPLATE+30, 'Food Crate / Barrel of Milk - Darkshore', 0, 10),
(@OGUID+31, @PTEMPLATE+31, 'Food Crate / Barrel of Milk - Darkshore', 0, 10),
(@OGUID+32, @PTEMPLATE+32, 'Food Crate / Barrel of Milk - Darkshore', 0, 10),
(@OGUID+33, @PTEMPLATE+33, 'Food Crate / Barrel of Milk - Darkshore', 0, 10),
(@OGUID+34, @PTEMPLATE+34, 'Food Crate / Barrel of Milk - Darkshore', 0, 10),
(@OGUID+35, @PTEMPLATE+35, 'Food Crate / Barrel of Milk - Darkshore', 0, 10),
(@OGUID+36, @PTEMPLATE+36, 'Food Crate / Barrel of Milk - Darkshore', 0, 10),
(@OGUID+37, @PTEMPLATE+1, 'Food Crate / Barrel of Milk - Darkshore', 0, 10),
(@OGUID+38, @PTEMPLATE+2, 'Food Crate / Barrel of Milk - Darkshore', 0, 10),
(@OGUID+39, @PTEMPLATE+3, 'Food Crate / Barrel of Milk - Darkshore', 0, 10),
(@OGUID+40, @PTEMPLATE+4, 'Food Crate / Barrel of Milk - Darkshore', 0, 10),
(@OGUID+41, @PTEMPLATE+5, 'Food Crate / Barrel of Milk - Darkshore', 0, 10),
(@OGUID+42, @PTEMPLATE+6, 'Food Crate / Barrel of Milk - Darkshore', 0, 10),
(@OGUID+43, @PTEMPLATE+7, 'Food Crate / Barrel of Milk - Darkshore', 0, 10),
(@OGUID+44, @PTEMPLATE+8, 'Food Crate / Barrel of Milk - Darkshore', 0, 10),
(@OGUID+45, @PTEMPLATE+9, 'Food Crate / Barrel of Milk - Darkshore', 0, 10),
(@OGUID+46, @PTEMPLATE+10, 'Food Crate / Barrel of Milk - Darkshore', 0, 10),
(@OGUID+47, @PTEMPLATE+11, 'Food Crate / Barrel of Milk - Darkshore', 0, 10),
(@OGUID+48, @PTEMPLATE+12, 'Food Crate / Barrel of Milk - Darkshore', 0, 10),
(@OGUID+49, @PTEMPLATE+13, 'Food Crate / Barrel of Milk - Darkshore', 0, 10),
(@OGUID+50, @PTEMPLATE+14, 'Food Crate / Barrel of Milk - Darkshore', 0, 10),
(@OGUID+51, @PTEMPLATE+15, 'Food Crate / Barrel of Milk - Darkshore', 0, 10),
(@OGUID+52, @PTEMPLATE+16, 'Food Crate / Barrel of Milk - Darkshore', 0, 10),
(@OGUID+53, @PTEMPLATE+17, 'Food Crate / Barrel of Milk - Darkshore', 0, 10),
(@OGUID+54, @PTEMPLATE+18, 'Food Crate / Barrel of Milk - Darkshore', 0, 10),
(@OGUID+55, @PTEMPLATE+19, 'Food Crate / Barrel of Milk - Darkshore', 0, 10),
(@OGUID+56, @PTEMPLATE+20, 'Food Crate / Barrel of Milk - Darkshore', 0, 10),
(@OGUID+57, @PTEMPLATE+21, 'Food Crate / Barrel of Milk - Darkshore', 0, 10),
(@OGUID+58, @PTEMPLATE+22, 'Food Crate / Barrel of Milk - Darkshore', 0, 10),
(@OGUID+59, @PTEMPLATE+23, 'Food Crate / Barrel of Milk - Darkshore', 0, 10),
(@OGUID+60, @PTEMPLATE+24, 'Food Crate / Barrel of Milk - Darkshore', 0, 10),
(@OGUID+61, @PTEMPLATE+25, 'Food Crate / Barrel of Milk - Darkshore', 0, 10),
(@OGUID+62, @PTEMPLATE+26, 'Food Crate / Barrel of Milk - Darkshore', 0, 10),
(@OGUID+63, @PTEMPLATE+27, 'Food Crate / Barrel of Milk - Darkshore', 0, 10),
(@OGUID+64, @PTEMPLATE+28, 'Food Crate / Barrel of Milk - Darkshore', 0, 10),
(@OGUID+65, @PTEMPLATE+29, 'Food Crate / Barrel of Milk - Darkshore', 0, 10),
(@OGUID+66, @PTEMPLATE+30, 'Food Crate / Barrel of Milk - Darkshore', 0, 10),
(@OGUID+67, @PTEMPLATE+31, 'Food Crate / Barrel of Milk - Darkshore', 0, 10),
(@OGUID+68, @PTEMPLATE+32, 'Food Crate / Barrel of Milk - Darkshore', 0, 10),
(@OGUID+69, @PTEMPLATE+33, 'Food Crate / Barrel of Milk - Darkshore', 0, 10),
(@OGUID+70, @PTEMPLATE+34, 'Food Crate / Barrel of Milk - Darkshore', 0, 10),
(@OGUID+71, @PTEMPLATE+35, 'Food Crate / Barrel of Milk - Darkshore', 0, 10),
(@OGUID+72, @PTEMPLATE+36, 'Food Crate / Barrel of Milk - Darkshore', 0, 10);

INSERT INTO `pool_template` (`entry`, `max_limit`, `description`, `flags`, `instance`, `patch_min`, `patch_max`) VALUES
(@PTEMPLATE+37, 17, 'Darkshore - Food Crate / Barrel of Milk (Master Pool)', 0, 0, 0, 10);
INSERT INTO `pool_pool` (`pool_id`, `mother_pool`, `chance`, `description`, `flags`) VALUES
(@PTEMPLATE+1, @PTEMPLATE+37, 0, 'Food Crate / Barrel of Milk - Darkshore', 0),
(@PTEMPLATE+2, @PTEMPLATE+37, 0, 'Food Crate / Barrel of Milk - Darkshore', 0),
(@PTEMPLATE+3, @PTEMPLATE+37, 0, 'Food Crate / Barrel of Milk - Darkshore', 0),
(@PTEMPLATE+4, @PTEMPLATE+37, 0, 'Food Crate / Barrel of Milk - Darkshore', 0),
(@PTEMPLATE+5, @PTEMPLATE+37, 0, 'Food Crate / Barrel of Milk - Darkshore', 0),
(@PTEMPLATE+6, @PTEMPLATE+37, 0, 'Food Crate / Barrel of Milk - Darkshore', 0),
(@PTEMPLATE+7, @PTEMPLATE+37, 0, 'Food Crate / Barrel of Milk - Darkshore', 0),
(@PTEMPLATE+8, @PTEMPLATE+37, 0, 'Food Crate / Barrel of Milk - Darkshore', 0),
(@PTEMPLATE+9, @PTEMPLATE+37, 0, 'Food Crate / Barrel of Milk - Darkshore', 0),
(@PTEMPLATE+10, @PTEMPLATE+37, 0, 'Food Crate / Barrel of Milk - Darkshore', 0),
(@PTEMPLATE+11, @PTEMPLATE+37, 0, 'Food Crate / Barrel of Milk - Darkshore', 0),
(@PTEMPLATE+12, @PTEMPLATE+37, 0, 'Food Crate / Barrel of Milk - Darkshore', 0),
(@PTEMPLATE+13, @PTEMPLATE+37, 0, 'Food Crate / Barrel of Milk - Darkshore', 0),
(@PTEMPLATE+14, @PTEMPLATE+37, 0, 'Food Crate / Barrel of Milk - Darkshore', 0),
(@PTEMPLATE+15, @PTEMPLATE+37, 0, 'Food Crate / Barrel of Milk - Darkshore', 0),
(@PTEMPLATE+16, @PTEMPLATE+37, 0, 'Food Crate / Barrel of Milk - Darkshore', 0),
(@PTEMPLATE+17, @PTEMPLATE+37, 0, 'Food Crate / Barrel of Milk - Darkshore', 0),
(@PTEMPLATE+18, @PTEMPLATE+37, 0, 'Food Crate / Barrel of Milk - Darkshore', 0),
(@PTEMPLATE+19, @PTEMPLATE+37, 0, 'Food Crate / Barrel of Milk - Darkshore', 0),
(@PTEMPLATE+20, @PTEMPLATE+37, 0, 'Food Crate / Barrel of Milk - Darkshore', 0),
(@PTEMPLATE+21, @PTEMPLATE+37, 0, 'Food Crate / Barrel of Milk - Darkshore', 0),
(@PTEMPLATE+22, @PTEMPLATE+37, 0, 'Food Crate / Barrel of Milk - Darkshore', 0),
(@PTEMPLATE+23, @PTEMPLATE+37, 0, 'Food Crate / Barrel of Milk - Darkshore', 0),
(@PTEMPLATE+24, @PTEMPLATE+37, 0, 'Food Crate / Barrel of Milk - Darkshore', 0),
(@PTEMPLATE+25, @PTEMPLATE+37, 0, 'Food Crate / Barrel of Milk - Darkshore', 0),
(@PTEMPLATE+26, @PTEMPLATE+37, 0, 'Food Crate / Barrel of Milk - Darkshore', 0),
(@PTEMPLATE+27, @PTEMPLATE+37, 0, 'Food Crate / Barrel of Milk - Darkshore', 0),
(@PTEMPLATE+28, @PTEMPLATE+37, 0, 'Food Crate / Barrel of Milk - Darkshore', 0),
(@PTEMPLATE+29, @PTEMPLATE+37, 0, 'Food Crate / Barrel of Milk - Darkshore', 0),
(@PTEMPLATE+30, @PTEMPLATE+37, 0, 'Food Crate / Barrel of Milk - Darkshore', 0),
(@PTEMPLATE+31, @PTEMPLATE+37, 0, 'Food Crate / Barrel of Milk - Darkshore', 0),
(@PTEMPLATE+32, @PTEMPLATE+37, 0, 'Food Crate / Barrel of Milk - Darkshore', 0),
(@PTEMPLATE+33, @PTEMPLATE+37, 0, 'Food Crate / Barrel of Milk - Darkshore', 0),
(@PTEMPLATE+34, @PTEMPLATE+37, 0, 'Food Crate / Barrel of Milk - Darkshore', 0),
(@PTEMPLATE+35, @PTEMPLATE+37, 0, 'Food Crate / Barrel of Milk - Darkshore', 0),
(@PTEMPLATE+36, @PTEMPLATE+37, 0, 'Food Crate / Barrel of Milk - Darkshore', 0);


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