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


SET @OGUID = 46838;
SET @PTEMPLATE = 4122;

-- 17 Barrens 3705 / 3662   Food Crate / Barrel of Milk
DELETE FROM `pool_template` WHERE `entry` IN (SELECT `pool_entry` FROM `pool_gameobject` WHERE `guid` IN (13314, 13315, 13317, 13318, 13319, 13320, 13321, 13322, 13323, 13324, 13498, 13499, 13500, 13501, 13502, 13503, 13504, 13505, 13506, 13507, 13508, 13509, 13510, 42434));
DELETE FROM `gameobject` WHERE `guid` IN (13314, 13315, 13317, 13318, 13319, 13320, 13321, 13322, 13323, 13324, 13498, 13499, 13500, 13501, 13502, 13503, 13504, 13505, 13506, 13507, 13508, 13509, 13510, 42434);
DELETE FROM `pool_gameobject` WHERE `guid` IN (13314, 13315, 13317, 13318, 13319, 13320, 13321, 13322, 13323, 13324, 13498, 13499, 13500, 13501, 13502, 13503, 13504, 13505, 13506, 13507, 13508, 13509, 13510, 42434);

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, -4087.37, -2362.9, 108.909, 5.99774, 0, 0, 0.142237, -0.989833, 180, 180, 0, 1, 0, 0, 0, 10),
(@OGUID+2, 3662, 1, -2379.59, -2008.88, 104.932, 0.942478, 0, 0, 0.45399, 0.891007, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+3, 3662, 1, -2319.36, -2239.31, 91.6668, -1.46608, 0, 0, 0.669131, -0.743145, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+4, 3662, 1, -2100.22, -1721.59, 91.862, 1.93731, 0, 0, 0.824126, 0.566406, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+5, 3662, 1, -2099.96, -3635.59, 72.0328, 0.663225, 0, 0, 0.325568, 0.945519, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+6, 3662, 1, -1926.58, -1760.03, 92.2422, -1.39626, 0, 0, 0.642788, -0.766044, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+7, 3662, 1, -1500.99, -3655.18, 92.3257, -2.02458, 0, 0, 0.848048, -0.529919, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+8, 3662, 1, -1153.94, -2799.71, 92.0468, -2.19912, 0, 0, 0.891007, -0.45399, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+9, 3662, 1, -1028, -3653.23, 22.7998, -0.174533, 0, 0, 0.087156, -0.996195, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+10, 3662, 1, -854.131, -2756.05, 91.6667, -2.72271, 0, 0, 0.978148, -0.207912, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+11, 3662, 1, -632.53, -3259.49, 98.9583, 1.48353, 0, 0, 0.67559, 0.737277, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+12, 3662, 1, -592.604, -2269.13, 211.345, 2.51327, 0, 0, 0.951057, 0.309017, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+13, 3662, 1, -559.372, -2675.07, 96.1342, 2.98451, 0, 0, 0.996917, 0.078459, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+14, 3662, 1, -433.125, -2562.22, 97.0162, 0.034907, 0, 0, 0.017452, 0.999848, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+15, 3662, 1, -421.76, -2668.49, 95.9021, -1.67552, 0, 0, 0.743145, -0.669131, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+16, 3662, 1, -93.8536, -2032.68, 91.6667, 1.15192, 0, 0, 0.544639, 0.838671, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+17, 3662, 1, -52.6214, -3408.97, 91.6756, 2.54818, 0, 0, 0.956305, 0.292372, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+18, 3662, 1, -8.96408, -3581.63, 27.6868, -0.174533, 0, 0, 0.087156, -0.996195, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+19, 3662, 1, 267.824, -1938, 91.7747, -2.26893, 0, 0, 0.906308, -0.422618, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+20, 3662, 1, 280.97, -3044.65, 95.8988, -1.43117, 0, 0, 0.656059, -0.75471, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+21, 3662, 1, 304.412, -2201.58, 213.531, -1.37881, 0, 0, 0.636078, -0.771625, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+22, 3662, 1, 796.585, -1806.48, 91.6667, 1.51844, 0, 0, 0.688355, 0.725374, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+23, 3662, 1, 893.934, -2337.83, 91.6819, 0.488692, 0, 0, 0.241922, 0.970296, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+24, 3662, 1, 1212.8, -2923.98, 91.6667, -1.39626, 0, 0, 0.642788, -0.766044, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+25, 3662, 1, -2398.4, -1902.35, 96.7421, 1.44862, 0, 0, 0.66262, 0.748956, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+26, 3662, 1, -2308.04, -1921.46, 96.054, 5.77704, 0, 0, -0.25038, 0.968148, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+27, 3662, 1, -2250.77, -2378.82, 91.6667, 2.58308, 0, 0, 0.961261, 0.27564, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+28, 3662, 1, -2202.83, -3674.46, 92.6469, 0.558504, 0, 0, 0.275637, 0.961262, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+29, 3662, 1, -2083.3, -2560, 91.6667, 2.25147, 0, 0, 0.902585, 0.430512, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+30, 3662, 1, -2050.93, -3709.55, 21.76, 5.51524, 0, 0, -0.374606, 0.927184, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+31, 3662, 1, -1868.54, -1919.41, 95.8218, 2.9845, 0, 0, 0.996917, 0.0784664, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+32, 3662, 1, -1778.43, -2373.48, 91.6805, 2.28638, 0, 0, 0.909961, 0.414694, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+33, 3662, 1, -1703.04, -3618.65, 91.6183, 4.55531, 0, 0, -0.760406, 0.649449, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+34, 3662, 1, -1586.95, -3676.65, 92.0282, 3.99681, 0, 0, -0.909961, 0.414694, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+35, 3662, 1, -1559.75, -2879.16, 91.7626, 6.0912, 0, 0, -0.0958452, 0.995396, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+36, 3662, 1, -1433.23, -1502.28, 94.4547, 5.58505, 0, 0, -0.34202, 0.939693, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+37, 3662, 1, -1348.67, -3101.59, 91.6667, 2.37364, 0, 0, 0.927183, 0.374608, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+38, 3662, 1, -1000.51, -1607.58, 91.6893, 3.194, 0, 0, -0.999657, 0.0262016, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+39, 3662, 1, -990.31, -3630.36, 19.2121, 5.88176, 0, 0, -0.199368, 0.979925, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+40, 3662, 1, -969.161, -2023.22, 83.2662, 3.73501, 0, 0, -0.956305, 0.292372, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+41, 3662, 1, -760.656, -3722.24, 42.3295, 1.18682, 0, 0, 0.559193, 0.829038, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+42, 3662, 1, -631.272, -3187.12, 92.4601, 2.28638, 0, 0, 0.909961, 0.414694, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+43, 3662, 1, -564.232, -2971.11, 91.7302, 4.31097, 0, 0, -0.833885, 0.551938, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+44, 3662, 1, -514.018, -2638.07, 95.906, 4.32842, 0, 0, -0.829037, 0.559194, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+45, 3662, 1, -441.453, -2693.34, 95.8103, 0.785397, 0, 0, 0.382683, 0.92388, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+46, 3662, 1, -410.122, -2619.54, 95.7346, 2.04204, 0, 0, 0.85264, 0.522499, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+47, 3662, 1, -406.046, -2719.08, 97.3079, 1.50098, 0, 0, 0.681998, 0.731354, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+48, 3662, 1, -402.188, -1368.43, 94.1801, 1.39626, 0, 0, 0.642787, 0.766045, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+49, 3662, 1, -401.265, -2669.53, 95.6651, 4.72984, 0, 0, -0.700909, 0.713251, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+50, 3662, 1, -388.343, -2540, 99.665, 0.733038, 0, 0, 0.358368, 0.93358, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+51, 3662, 1, -381.143, -2631.65, 95.6601, 0.855211, 0, 0, 0.414693, 0.909961, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+52, 3662, 1, -368.118, -2527.41, 95.8255, 3.64774, 0, 0, -0.968147, 0.250381, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+53, 3662, 1, -352.642, -2574.17, 95.8596, 3.52557, 0, 0, -0.981627, 0.190812, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+54, 3662, 1, -305.976, -1958.97, 90.5368, 2.42601, 0, 0, 0.936672, 0.350207, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+55, 3662, 1, -243.686, -1657.45, 91.8565, 0.488691, 0, 0, 0.241921, 0.970296, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+56, 3662, 1, -231.364, -3309.16, 91.6667, 2.91469, 0, 0, 0.993571, 0.113208, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+57, 3662, 1, -104.579, -3178.88, 92.9682, 4.88692, 0, 0, -0.642787, 0.766045, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+58, 3662, 1, -54.1091, -1417.72, 91.8804, 1.15192, 0, 0, 0.544639, 0.838671, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+59, 3662, 1, -33.6399, -2217.06, 91.6667, 4.88692, 0, 0, -0.642787, 0.766045, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+60, 3662, 1, 28.3732, -1741.48, 105.533, 3.03684, 0, 0, 0.998629, 0.0523532, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+61, 3662, 1, 32.1527, -2679.62, 106.975, 5.88176, 0, 0, -0.199368, 0.979925, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+62, 3662, 1, 239.135, -2907.64, 98.0577, 5.44543, 0, 0, -0.406736, 0.913546, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+63, 3662, 1, 296.142, -3657.13, 27.3071, 2.25147, 0, 0, 0.902585, 0.430512, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+64, 3662, 1, 538.788, -1606.36, 91.9143, 5.60251, 0, 0, -0.333807, 0.942641, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+65, 3662, 1, 578.248, -2215.55, 91.6667, 2.32129, 0, 0, 0.91706, 0.39875, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+66, 3662, 1, 789.091, -1325.27, 89.3905, 6.24828, 0, 0, -0.0174522, 0.999848, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+67, 3662, 1, 888.969, -3683.73, 26.8595, 1.81514, 0, 0, 0.788011, 0.615662, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+68, 3662, 1, 911.14, -2736.14, 99.8214, 2.67035, 0, 0, 0.972369, 0.233448, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+69, 3662, 1, 1014.08, -2230.34, 93.1673, 0.733038, 0, 0, 0.358368, 0.93358, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+70, 3662, 1, 1022.89, -3066.16, 91.7332, 5.2709, 0, 0, -0.484809, 0.87462, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+71, 3662, 1, 1243.1, -2208.07, 113.436, 5.84685, 0, 0, -0.216439, 0.976296, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+72, 3662, 1, 316.125, -2265.66, 243.059, 4.29351, 0, 0, -0.83867, 0.54464, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+73, 3705, 1, -4087.37, -2362.9, 108.909, 5.99774, 0, 0, 0.142237, -0.989833, 180, 180, 0, 1, 0, 0, 0, 10),
(@OGUID+74, 3705, 1, -2379.59, -2008.88, 104.932, 0.942478, 0, 0, 0.45399, 0.891007, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+75, 3705, 1, -2319.36, -2239.31, 91.6668, -1.46608, 0, 0, 0.669131, -0.743145, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+76, 3705, 1, -2100.22, -1721.59, 91.862, 1.93731, 0, 0, 0.824126, 0.566406, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+77, 3705, 1, -2099.96, -3635.59, 72.0328, 0.663225, 0, 0, 0.325568, 0.945519, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+78, 3705, 1, -1926.58, -1760.03, 92.2422, -1.39626, 0, 0, 0.642788, -0.766044, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+79, 3705, 1, -1500.99, -3655.18, 92.3257, -2.02458, 0, 0, 0.848048, -0.529919, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+80, 3705, 1, -1153.94, -2799.71, 92.0468, -2.19912, 0, 0, 0.891007, -0.45399, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+81, 3705, 1, -1028, -3653.23, 22.7998, -0.174533, 0, 0, 0.087156, -0.996195, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+82, 3705, 1, -854.131, -2756.05, 91.6667, -2.72271, 0, 0, 0.978148, -0.207912, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+83, 3705, 1, -632.53, -3259.49, 98.9583, 1.48353, 0, 0, 0.67559, 0.737277, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+84, 3705, 1, -592.604, -2269.13, 211.345, 2.51327, 0, 0, 0.951057, 0.309017, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+85, 3705, 1, -559.372, -2675.07, 96.1342, 2.98451, 0, 0, 0.996917, 0.078459, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+86, 3705, 1, -433.125, -2562.22, 97.0162, 0.034907, 0, 0, 0.017452, 0.999848, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+87, 3705, 1, -421.76, -2668.49, 95.9021, -1.67552, 0, 0, 0.743145, -0.669131, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+88, 3705, 1, -93.8536, -2032.68, 91.6667, 1.15192, 0, 0, 0.544639, 0.838671, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+89, 3705, 1, -52.6214, -3408.97, 91.6756, 2.54818, 0, 0, 0.956305, 0.292372, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+90, 3705, 1, -8.96408, -3581.63, 27.6868, -0.174533, 0, 0, 0.087156, -0.996195, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+91, 3705, 1, 267.824, -1938, 91.7747, -2.26893, 0, 0, 0.906308, -0.422618, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+92, 3705, 1, 280.97, -3044.65, 95.8988, -1.43117, 0, 0, 0.656059, -0.75471, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+93, 3705, 1, 304.412, -2201.58, 213.531, -1.37881, 0, 0, 0.636078, -0.771625, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+94, 3705, 1, 796.585, -1806.48, 91.6667, 1.51844, 0, 0, 0.688355, 0.725374, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+95, 3705, 1, 893.934, -2337.83, 91.6819, 0.488692, 0, 0, 0.241922, 0.970296, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+96, 3705, 1, 1212.8, -2923.98, 91.6667, -1.39626, 0, 0, 0.642788, -0.766044, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+97, 3705, 1, -2398.4, -1902.35, 96.7421, 1.44862, 0, 0, 0.66262, 0.748956, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+98, 3705, 1, -2308.04, -1921.46, 96.054, 5.77704, 0, 0, -0.25038, 0.968148, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+99, 3705, 1, -2250.77, -2378.82, 91.6667, 2.58308, 0, 0, 0.961261, 0.27564, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+100, 3705, 1, -2202.83, -3674.46, 92.6469, 0.558504, 0, 0, 0.275637, 0.961262, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+101, 3705, 1, -2083.3, -2560, 91.6667, 2.25147, 0, 0, 0.902585, 0.430512, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+102, 3705, 1, -2050.93, -3709.55, 21.76, 5.51524, 0, 0, -0.374606, 0.927184, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+103, 3705, 1, -1868.54, -1919.41, 95.8218, 2.9845, 0, 0, 0.996917, 0.0784664, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+104, 3705, 1, -1778.43, -2373.48, 91.6805, 2.28638, 0, 0, 0.909961, 0.414694, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+105, 3705, 1, -1703.04, -3618.65, 91.6183, 4.55531, 0, 0, -0.760406, 0.649449, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+106, 3705, 1, -1586.95, -3676.65, 92.0282, 3.99681, 0, 0, -0.909961, 0.414694, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+107, 3705, 1, -1559.75, -2879.16, 91.7626, 6.0912, 0, 0, -0.0958452, 0.995396, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+108, 3705, 1, -1433.23, -1502.28, 94.4547, 5.58505, 0, 0, -0.34202, 0.939693, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+109, 3705, 1, -1348.67, -3101.59, 91.6667, 2.37364, 0, 0, 0.927183, 0.374608, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+110, 3705, 1, -1000.51, -1607.58, 91.6893, 3.194, 0, 0, -0.999657, 0.0262016, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+111, 3705, 1, -990.31, -3630.36, 19.2121, 5.88176, 0, 0, -0.199368, 0.979925, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+112, 3705, 1, -969.161, -2023.22, 83.2662, 3.73501, 0, 0, -0.956305, 0.292372, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+113, 3705, 1, -760.656, -3722.24, 42.3295, 1.18682, 0, 0, 0.559193, 0.829038, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+114, 3705, 1, -631.272, -3187.12, 92.4601, 2.28638, 0, 0, 0.909961, 0.414694, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+115, 3705, 1, -564.232, -2971.11, 91.7302, 4.31097, 0, 0, -0.833885, 0.551938, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+116, 3705, 1, -514.018, -2638.07, 95.906, 4.32842, 0, 0, -0.829037, 0.559194, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+117, 3705, 1, -441.453, -2693.34, 95.8103, 0.785397, 0, 0, 0.382683, 0.92388, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+118, 3705, 1, -410.122, -2619.54, 95.7346, 2.04204, 0, 0, 0.85264, 0.522499, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+119, 3705, 1, -406.046, -2719.08, 97.3079, 1.50098, 0, 0, 0.681998, 0.731354, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+120, 3705, 1, -402.188, -1368.43, 94.1801, 1.39626, 0, 0, 0.642787, 0.766045, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+121, 3705, 1, -401.265, -2669.53, 95.6651, 4.72984, 0, 0, -0.700909, 0.713251, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+122, 3705, 1, -388.343, -2540, 99.665, 0.733038, 0, 0, 0.358368, 0.93358, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+123, 3705, 1, -381.143, -2631.65, 95.6601, 0.855211, 0, 0, 0.414693, 0.909961, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+124, 3705, 1, -368.118, -2527.41, 95.8255, 3.64774, 0, 0, -0.968147, 0.250381, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+125, 3705, 1, -352.642, -2574.17, 95.8596, 3.52557, 0, 0, -0.981627, 0.190812, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+126, 3705, 1, -305.976, -1958.97, 90.5368, 2.42601, 0, 0, 0.936672, 0.350207, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+127, 3705, 1, -243.686, -1657.45, 91.8565, 0.488691, 0, 0, 0.241921, 0.970296, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+128, 3705, 1, -231.364, -3309.16, 91.6667, 2.91469, 0, 0, 0.993571, 0.113208, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+129, 3705, 1, -104.579, -3178.88, 92.9682, 4.88692, 0, 0, -0.642787, 0.766045, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+130, 3705, 1, -54.1091, -1417.72, 91.8804, 1.15192, 0, 0, 0.544639, 0.838671, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+131, 3705, 1, -33.6399, -2217.06, 91.6667, 4.88692, 0, 0, -0.642787, 0.766045, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+132, 3705, 1, 28.3732, -1741.48, 105.533, 3.03684, 0, 0, 0.998629, 0.0523532, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+133, 3705, 1, 32.1527, -2679.62, 106.975, 5.88176, 0, 0, -0.199368, 0.979925, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+134, 3705, 1, 239.135, -2907.64, 98.0577, 5.44543, 0, 0, -0.406736, 0.913546, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+135, 3705, 1, 296.142, -3657.13, 27.3071, 2.25147, 0, 0, 0.902585, 0.430512, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+136, 3705, 1, 538.788, -1606.36, 91.9143, 5.60251, 0, 0, -0.333807, 0.942641, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+137, 3705, 1, 578.248, -2215.55, 91.6667, 2.32129, 0, 0, 0.91706, 0.39875, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+138, 3705, 1, 789.091, -1325.27, 89.3905, 6.24828, 0, 0, -0.0174522, 0.999848, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+139, 3705, 1, 888.969, -3683.73, 26.8595, 1.81514, 0, 0, 0.788011, 0.615662, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+140, 3705, 1, 911.14, -2736.14, 99.8214, 2.67035, 0, 0, 0.972369, 0.233448, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+141, 3705, 1, 1014.08, -2230.34, 93.1673, 0.733038, 0, 0, 0.358368, 0.93358, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+142, 3705, 1, 1022.89, -3066.16, 91.7332, 5.2709, 0, 0, -0.484809, 0.87462, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+143, 3705, 1, 1243.1, -2208.07, 113.436, 5.84685, 0, 0, -0.216439, 0.976296, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+144, 3705, 1, 316.125, -2265.66, 243.059, 4.29351, 0, 0, -0.83867, 0.54464, 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 - Barrens', 0, 10),
(@PTEMPLATE+2, 1, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@PTEMPLATE+3, 1, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@PTEMPLATE+4, 1, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@PTEMPLATE+5, 1, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@PTEMPLATE+6, 1, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@PTEMPLATE+7, 1, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@PTEMPLATE+8, 1, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@PTEMPLATE+9, 1, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@PTEMPLATE+10, 1, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@PTEMPLATE+11, 1, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@PTEMPLATE+12, 1, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@PTEMPLATE+13, 1, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@PTEMPLATE+14, 1, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@PTEMPLATE+15, 1, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@PTEMPLATE+16, 1, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@PTEMPLATE+17, 1, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@PTEMPLATE+18, 1, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@PTEMPLATE+19, 1, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@PTEMPLATE+20, 1, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@PTEMPLATE+21, 1, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@PTEMPLATE+22, 1, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@PTEMPLATE+23, 1, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@PTEMPLATE+24, 1, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@PTEMPLATE+25, 1, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@PTEMPLATE+26, 1, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@PTEMPLATE+27, 1, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@PTEMPLATE+28, 1, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@PTEMPLATE+29, 1, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@PTEMPLATE+30, 1, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@PTEMPLATE+31, 1, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@PTEMPLATE+32, 1, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@PTEMPLATE+33, 1, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@PTEMPLATE+34, 1, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@PTEMPLATE+35, 1, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@PTEMPLATE+36, 1, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@PTEMPLATE+37, 1, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@PTEMPLATE+38, 1, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@PTEMPLATE+39, 1, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@PTEMPLATE+40, 1, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@PTEMPLATE+41, 1, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@PTEMPLATE+42, 1, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@PTEMPLATE+43, 1, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@PTEMPLATE+44, 1, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@PTEMPLATE+45, 1, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@PTEMPLATE+46, 1, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@PTEMPLATE+47, 1, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@PTEMPLATE+48, 1, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@PTEMPLATE+49, 1, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@PTEMPLATE+50, 1, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@PTEMPLATE+51, 1, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@PTEMPLATE+52, 1, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@PTEMPLATE+53, 1, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@PTEMPLATE+54, 1, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@PTEMPLATE+55, 1, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@PTEMPLATE+56, 1, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@PTEMPLATE+57, 1, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@PTEMPLATE+58, 1, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@PTEMPLATE+59, 1, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@PTEMPLATE+60, 1, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@PTEMPLATE+61, 1, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@PTEMPLATE+62, 1, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@PTEMPLATE+63, 1, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@PTEMPLATE+64, 1, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@PTEMPLATE+65, 1, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@PTEMPLATE+66, 1, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@PTEMPLATE+67, 1, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@PTEMPLATE+68, 1, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@PTEMPLATE+69, 1, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@PTEMPLATE+70, 1, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@PTEMPLATE+71, 1, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@PTEMPLATE+72, 1, 'Food Crate / Barrel of Milk - Barrens', 0, 10);

INSERT INTO `pool_gameobject` (`guid`, `pool_entry`, `description`, `patch_min`, `patch_max`) VALUES 
(@OGUID+1, @PTEMPLATE+1, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@OGUID+2, @PTEMPLATE+2, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@OGUID+3, @PTEMPLATE+3, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@OGUID+4, @PTEMPLATE+4, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@OGUID+5, @PTEMPLATE+5, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@OGUID+6, @PTEMPLATE+6, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@OGUID+7, @PTEMPLATE+7, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@OGUID+8, @PTEMPLATE+8, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@OGUID+9, @PTEMPLATE+9, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@OGUID+10, @PTEMPLATE+10, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@OGUID+11, @PTEMPLATE+11, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@OGUID+12, @PTEMPLATE+12, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@OGUID+13, @PTEMPLATE+13, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@OGUID+14, @PTEMPLATE+14, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@OGUID+15, @PTEMPLATE+15, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@OGUID+16, @PTEMPLATE+16, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@OGUID+17, @PTEMPLATE+17, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@OGUID+18, @PTEMPLATE+18, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@OGUID+19, @PTEMPLATE+19, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@OGUID+20, @PTEMPLATE+20, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@OGUID+21, @PTEMPLATE+21, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@OGUID+22, @PTEMPLATE+22, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@OGUID+23, @PTEMPLATE+23, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@OGUID+24, @PTEMPLATE+24, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@OGUID+25, @PTEMPLATE+25, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@OGUID+26, @PTEMPLATE+26, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@OGUID+27, @PTEMPLATE+27, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@OGUID+28, @PTEMPLATE+28, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@OGUID+29, @PTEMPLATE+29, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@OGUID+30, @PTEMPLATE+30, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@OGUID+31, @PTEMPLATE+31, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@OGUID+32, @PTEMPLATE+32, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@OGUID+33, @PTEMPLATE+33, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@OGUID+34, @PTEMPLATE+34, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@OGUID+35, @PTEMPLATE+35, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@OGUID+36, @PTEMPLATE+36, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@OGUID+37, @PTEMPLATE+37, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@OGUID+38, @PTEMPLATE+38, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@OGUID+39, @PTEMPLATE+39, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@OGUID+40, @PTEMPLATE+40, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@OGUID+41, @PTEMPLATE+41, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@OGUID+42, @PTEMPLATE+42, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@OGUID+43, @PTEMPLATE+43, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@OGUID+44, @PTEMPLATE+44, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@OGUID+45, @PTEMPLATE+45, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@OGUID+46, @PTEMPLATE+46, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@OGUID+47, @PTEMPLATE+47, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@OGUID+48, @PTEMPLATE+48, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@OGUID+49, @PTEMPLATE+49, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@OGUID+50, @PTEMPLATE+50, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@OGUID+51, @PTEMPLATE+51, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@OGUID+52, @PTEMPLATE+52, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@OGUID+53, @PTEMPLATE+53, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@OGUID+54, @PTEMPLATE+54, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@OGUID+55, @PTEMPLATE+55, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@OGUID+56, @PTEMPLATE+56, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@OGUID+57, @PTEMPLATE+57, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@OGUID+58, @PTEMPLATE+58, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@OGUID+59, @PTEMPLATE+59, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@OGUID+60, @PTEMPLATE+60, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@OGUID+61, @PTEMPLATE+61, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@OGUID+62, @PTEMPLATE+62, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@OGUID+63, @PTEMPLATE+63, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@OGUID+64, @PTEMPLATE+64, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@OGUID+65, @PTEMPLATE+65, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@OGUID+66, @PTEMPLATE+66, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@OGUID+67, @PTEMPLATE+67, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@OGUID+68, @PTEMPLATE+68, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@OGUID+69, @PTEMPLATE+69, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@OGUID+70, @PTEMPLATE+70, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@OGUID+71, @PTEMPLATE+71, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@OGUID+72, @PTEMPLATE+72, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@OGUID+73, @PTEMPLATE+1, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@OGUID+74, @PTEMPLATE+2, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@OGUID+75, @PTEMPLATE+3, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@OGUID+76, @PTEMPLATE+4, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@OGUID+77, @PTEMPLATE+5, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@OGUID+78, @PTEMPLATE+6, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@OGUID+79, @PTEMPLATE+7, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@OGUID+80, @PTEMPLATE+8, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@OGUID+81, @PTEMPLATE+9, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@OGUID+82, @PTEMPLATE+10, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@OGUID+83, @PTEMPLATE+11, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@OGUID+84, @PTEMPLATE+12, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@OGUID+85, @PTEMPLATE+13, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@OGUID+86, @PTEMPLATE+14, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@OGUID+87, @PTEMPLATE+15, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@OGUID+88, @PTEMPLATE+16, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@OGUID+89, @PTEMPLATE+17, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@OGUID+90, @PTEMPLATE+18, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@OGUID+91, @PTEMPLATE+19, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@OGUID+92, @PTEMPLATE+20, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@OGUID+93, @PTEMPLATE+21, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@OGUID+94, @PTEMPLATE+22, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@OGUID+95, @PTEMPLATE+23, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@OGUID+96, @PTEMPLATE+24, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@OGUID+97, @PTEMPLATE+25, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@OGUID+98, @PTEMPLATE+26, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@OGUID+99, @PTEMPLATE+27, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@OGUID+100, @PTEMPLATE+28, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@OGUID+101, @PTEMPLATE+29, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@OGUID+102, @PTEMPLATE+30, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@OGUID+103, @PTEMPLATE+31, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@OGUID+104, @PTEMPLATE+32, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@OGUID+105, @PTEMPLATE+33, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@OGUID+106, @PTEMPLATE+34, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@OGUID+107, @PTEMPLATE+35, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@OGUID+108, @PTEMPLATE+36, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@OGUID+109, @PTEMPLATE+37, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@OGUID+110, @PTEMPLATE+38, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@OGUID+111, @PTEMPLATE+39, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@OGUID+112, @PTEMPLATE+40, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@OGUID+113, @PTEMPLATE+41, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@OGUID+114, @PTEMPLATE+42, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@OGUID+115, @PTEMPLATE+43, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@OGUID+116, @PTEMPLATE+44, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@OGUID+117, @PTEMPLATE+45, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@OGUID+118, @PTEMPLATE+46, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@OGUID+119, @PTEMPLATE+47, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@OGUID+120, @PTEMPLATE+48, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@OGUID+121, @PTEMPLATE+49, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@OGUID+122, @PTEMPLATE+50, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@OGUID+123, @PTEMPLATE+51, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@OGUID+124, @PTEMPLATE+52, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@OGUID+125, @PTEMPLATE+53, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@OGUID+126, @PTEMPLATE+54, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@OGUID+127, @PTEMPLATE+55, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@OGUID+128, @PTEMPLATE+56, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@OGUID+129, @PTEMPLATE+57, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@OGUID+130, @PTEMPLATE+58, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@OGUID+131, @PTEMPLATE+59, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@OGUID+132, @PTEMPLATE+60, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@OGUID+133, @PTEMPLATE+61, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@OGUID+134, @PTEMPLATE+62, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@OGUID+135, @PTEMPLATE+63, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@OGUID+136, @PTEMPLATE+64, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@OGUID+137, @PTEMPLATE+65, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@OGUID+138, @PTEMPLATE+66, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@OGUID+139, @PTEMPLATE+67, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@OGUID+140, @PTEMPLATE+68, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@OGUID+141, @PTEMPLATE+69, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@OGUID+142, @PTEMPLATE+70, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@OGUID+143, @PTEMPLATE+71, 'Food Crate / Barrel of Milk - Barrens', 0, 10),
(@OGUID+144, @PTEMPLATE+72, 'Food Crate / Barrel of Milk - Barrens', 0, 10);

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

DELETE FROM `gameobject` WHERE `guid` IN (46839, 46911);
DELETE FROM `pool_gameobject` WHERE `guid` IN (46839, 46911);
DELETE FROM `pool_pool` WHERE `pool_id` = 4123;
DELETE FROM `pool_template` WHERE `entry` = 4123;


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