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


SET @OGUID = 44008;
SET @PTEMPLATE = 3815;

-- 14 Durotar 3658 / 3719 / Water Barrel / Food Crate
DELETE FROM `pool_template` WHERE `entry` IN (SELECT `pool_entry` FROM `pool_gameobject` WHERE `guid` IN (12346, 12350, 12351, 12391, 12392, 12393, 12394, 12395, 12397, 12498, 12501, 12502, 12505, 12549, 12550, 12551, 12553, 12602, 88050, 88051, 88052, 88053, 88054, 88055, 88056, 88057, 88058, 88059, 88060, 88061, 88062, 88063, 88064, 88065, 88066, 88067, 88068, 88069, 88070, 88071));
DELETE FROM `gameobject` WHERE `guid` IN (12346, 12350, 12351, 12391, 12392, 12393, 12394, 12395, 12397, 12498, 12501, 12502, 12505, 12549, 12550, 12551, 12553, 12602, 88050, 88051, 88052, 88053, 88054, 88055, 88056, 88057, 88058, 88059, 88060, 88061, 88062, 88063, 88064, 88065, 88066, 88067, 88068, 88069, 88070, 88071);
DELETE FROM `pool_gameobject` WHERE `guid` IN (12346, 12350, 12351, 12391, 12392, 12393, 12394, 12395, 12397, 12498, 12501, 12502, 12505, 12549, 12550, 12551, 12553, 12602, 88050, 88051, 88052, 88053, 88054, 88055, 88056, 88057, 88058, 88059, 88060, 88061, 88062, 88063, 88064, 88065, 88066, 88067, 88068, 88069, 88070, 88071);

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, 3658, 1, -1642.23, -5284.79, -0.033276, 0.523599, 0, 0, 0.258819, 0.965926, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+2, 3658, 1, -1336.29, -5200.97, -0.091026, -0.680679, 0, 0, 0.333807, -0.942641, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+3, 3658, 1, -1123.15, -5575.75, 7.39658, 0.226893, 0, 0, 0.113203, 0.993572, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+4, 3658, 1, -1045.77, -4608.98, 25.831, 0.034907, 0, 0, 0.017452, 0.999848, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+5, 3658, 1, -758.5, -5366.35, -0.032768, -2.05949, 0, 0, 0.857167, -0.515038, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+6, 3658, 1, -639.43, -5185.13, 0.112274, 2.60054, 0, 0, 0.96363, 0.267238, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+7, 3658, 1, -153.696, -5023.12, 21.9477, -0.10472, 0, 0, 0.052336, -0.99863, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+8, 3658, 1, 319.082, -4768.63, 11.9896, 1.72787, 0, 0, 0, 0, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+9, 3658, 1, 339.336, -4700.81, 16.4578, 1.91986, 0, 0, 0.819152, 0.573576, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+10, 3658, 1, 382.927, -4597.71, 54.7897, 0.610865, 0, 0, 0.300706, 0.953717, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+11, 3658, 1, 387.24, -4586.66, 76.1843, 0.680678, 0, 0, 0.333807, 0.942641, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+12, 3658, 1, 563.076, -4090.13, 15.6692, 1.16937, 0, 0, 0.551937, 0.833886, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+13, 3658, 1, 665.216, -4540.14, 8.83067, -1.78024, 0, 0, 0.777146, -0.62932, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+14, 3658, 1, 787.201, -4530.7, 5.7406, 1.78024, 0, 0, 0.777146, 0.62932, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+15, 3658, 1, 915.418, -4633.35, 18.9878, 1.41372, 0, 0, 0.649448, 0.760406, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+16, 3658, 1, 933.269, -5104.26, -0.032131, 0.471239, 0, 0, 0.233445, 0.97237, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+17, 3658, 1, 946.095, -4704.73, 23.0614, 3.00197, 0, 0, 0.997564, 0.069757, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+18, 3658, 1, 992.105, -4407.13, 14.5778, -2.94961, 0, 0, 0.995396, -0.095846, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+19, 3658, 1, 1269, -4178.72, 26.0548, 1.39626, 0, 0, 0.642788, 0.766044, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+20, 3658, 1, -1550.4, -5221.86, -0.031495, 2.42601, 0, 0, 0.936672, 0.350207, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+21, 3658, 1, -1404.75, -5116.98, -0.015283, 2.9845, 0, 0, 0.996917, 0.0784664, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+22, 3658, 1, -1295.43, -5368.52, -0.16403, 0.436332, 0, 0, 0.216439, 0.976296, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+23, 3658, 1, -1241.68, -5507.15, 5.7288, 1.27409, 0, 0, 0.594822, 0.803857, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+24, 3658, 1, -1004.27, -5600.04, -0.21399, 5.98648, 0, 0, -0.147809, 0.989016, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+25, 3658, 1, -970.388, -4401.15, 29.2641, 3.73501, 0, 0, -0.956305, 0.292372, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+26, 3658, 1, -968.305, -5199.9, 0.064211, 0.366518, 0, 0, 0.182235, 0.983255, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+27, 3658, 1, -805.108, -5698.99, 0.052685, 5.68977, 0, 0, -0.292372, 0.956305, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+28, 3658, 1, -641.353, -5689.82, -0.171481, 5.2709, 0, 0, -0.484809, 0.87462, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+29, 3658, 1, -515.953, -5243.47, 0.036085, 0.767944, 0, 0, 0.374606, 0.927184, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+30, 3658, 1, -366.615, -5211.02, -0.034382, 1.53589, 0, 0, 0.694658, 0.71934, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+31, 3658, 1, -236.963, -5121.01, 25.2436, 2.16421, 0, 0, 0.882947, 0.469473, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+32, 3658, 1, -174.109, -4986.14, 22.5386, 6.14356, 0, 0, -0.0697556, 0.997564, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+33, 3658, 1, 74.5528, -4218.84, 60.8336, 2.07694, 0, 0, 0.861629, 0.507539, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+34, 3658, 1, 269.646, -4701.72, 11.6288, 1.39626, 0, 0, 0.642787, 0.766045, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+35, 3658, 1, 289.618, -4771.3, 11.769, 5.77704, 0, 0, -0.25038, 0.968148, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+36, 3658, 1, 290.396, -4706.11, 12.8422, 4.5204, 0, 0, -0.771625, 0.636078, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+37, 3658, 1, 292.627, -4828.49, 10.5234, 0.855211, 0, 0, 0.414693, 0.909961, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+38, 3658, 1, 298.88, -4663.11, 16.7712, 4.41568, 0, 0, -0.803857, 0.594823, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+39, 3658, 1, 319.151, -4667.86, 16.0833, 0.767944, 0, 0, 0.374606, 0.927184, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+40, 3658, 1, 321.553, -4768.17, 11.6718, 3.38594, 0, 0, -0.992546, 0.12187, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+41, 3658, 1, 325.073, -3795.73, 26.4866, 0.90757, 0, 0, 0.438371, 0.898794, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+42, 3658, 1, 331.565, -4831.89, 10.5238, 6.21337, 0, 0, -0.0348988, 0.999391, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+43, 3658, 1, 333.578, -4705.01, 14.4859, 1.91986, 0, 0, 0.819152, 0.573577, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+44, 3658, 1, 565.234, -4092.94, 15.7267, 1.16937, 0, 0, 0.551936, 0.833886, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+45, 3658, 1, 570.299, -5131.24, 0.080435, 2.79252, 0, 0, 0.984807, 0.173652, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+46, 3658, 1, 627.12, -4443.5, 11.6634, 3.61284, 0, 0, -0.972369, 0.233448, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+47, 3658, 1, 737.128, -4604.47, -3.30816, 5.55015, 0, 0, -0.358368, 0.93358, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+48, 3658, 1, 758.13, -4565.89, 1.62941, 3.42085, 0, 0, -0.990268, 0.139175, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+49, 3658, 1, 771.55, -4460.79, 15.6685, 2.30383, 0, 0, 0.913545, 0.406738, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+50, 3658, 1, 859.703, -4170.78, -14.1103, 4.50295, 0, 0, -0.777145, 0.629321, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+51, 3658, 1, 993.55, -4672.15, 26.9618, 5.86431, 0, 0, -0.207911, 0.978148, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+52, 3658, 1, 1001.38, -3919.05, 18.7792, 3.99681, 0, 0, -0.909961, 0.414694, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+53, 3658, 1, 1080.22, -5111.17, -0.058121, 4.08407, 0, 0, -0.891006, 0.453991, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+54, 3658, 1, 1102.29, -4951.8, 15.6024, 3.82227, 0, 0, -0.942641, 0.333808, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+55, 3658, 1, 1143.52, -4695.76, 17.7529, 0.226892, 0, 0, 0.113203, 0.993572, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+56, 3658, 1, 1266.49, -5030.35, -0.039411, 0.802851, 0, 0, 0.390731, 0.920505, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+57, 3658, 1, 1466.76, -4926.21, -0.066952, 4.95674, 0, 0, -0.615661, 0.788011, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+58, 3658, 1, -1166.98, -5145.53, -0.077441, 5.48033, 0, 0, -0.390731, 0.920505, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+59, 3658, 1, -912.076, -4474.18, 29.7029, 0.0349062, 0, 0, 0.0174522, 0.999848, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+60, 3658, 1, 390.932, -5124.09, -0.05675, 2.65289, 0, 0, 0.970295, 0.241925, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+61, 3658, 1, 758.85, -4251.66, 18.3729, 1.8675, 0, 0, 0.803857, 0.594823, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+62, 3719, 1, -1642.23, -5284.79, -0.033276, 0.523599, 0, 0, 0.258819, 0.965926, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+63, 3719, 1, -1336.29, -5200.97, -0.091026, -0.680679, 0, 0, 0.333807, -0.942641, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+64, 3719, 1, -1123.15, -5575.75, 7.39658, 0.226893, 0, 0, 0.113203, 0.993572, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+65, 3719, 1, -1045.77, -4608.98, 25.831, 0.034907, 0, 0, 0.017452, 0.999848, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+66, 3719, 1, -758.5, -5366.35, -0.032768, -2.05949, 0, 0, 0.857167, -0.515038, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+67, 3719, 1, -639.43, -5185.13, 0.112274, 2.60054, 0, 0, 0.96363, 0.267238, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+68, 3719, 1, -153.696, -5023.12, 21.9477, -0.10472, 0, 0, 0.052336, -0.99863, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+69, 3719, 1, 319.082, -4768.63, 11.9896, 1.72787, 0, 0, 0, 0, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+70, 3719, 1, 339.336, -4700.81, 16.4578, 1.91986, 0, 0, 0.819152, 0.573576, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+71, 3719, 1, 382.927, -4597.71, 54.7897, 0.610865, 0, 0, 0.300706, 0.953717, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+72, 3719, 1, 387.24, -4586.66, 76.1843, 0.680678, 0, 0, 0.333807, 0.942641, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+73, 3719, 1, 563.076, -4090.13, 15.6692, 1.16937, 0, 0, 0.551937, 0.833886, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+74, 3719, 1, 665.216, -4540.14, 8.83067, -1.78024, 0, 0, 0.777146, -0.62932, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+75, 3719, 1, 787.201, -4530.7, 5.7406, 1.78024, 0, 0, 0.777146, 0.62932, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+76, 3719, 1, 915.418, -4633.35, 18.9878, 1.41372, 0, 0, 0.649448, 0.760406, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+77, 3719, 1, 933.269, -5104.26, -0.032131, 0.471239, 0, 0, 0.233445, 0.97237, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+78, 3719, 1, 946.095, -4704.73, 23.0614, 3.00197, 0, 0, 0.997564, 0.069757, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+79, 3719, 1, 992.105, -4407.13, 14.5778, -2.94961, 0, 0, 0.995396, -0.095846, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+80, 3719, 1, 1269, -4178.72, 26.0548, 1.39626, 0, 0, 0.642788, 0.766044, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+81, 3719, 1, -1550.4, -5221.86, -0.031495, 2.42601, 0, 0, 0.936672, 0.350207, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+82, 3719, 1, -1404.75, -5116.98, -0.015283, 2.9845, 0, 0, 0.996917, 0.0784664, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+83, 3719, 1, -1295.43, -5368.52, -0.16403, 0.436332, 0, 0, 0.216439, 0.976296, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+84, 3719, 1, -1241.68, -5507.15, 5.7288, 1.27409, 0, 0, 0.594822, 0.803857, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+85, 3719, 1, -1004.27, -5600.04, -0.21399, 5.98648, 0, 0, -0.147809, 0.989016, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+86, 3719, 1, -970.388, -4401.15, 29.2641, 3.73501, 0, 0, -0.956305, 0.292372, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+87, 3719, 1, -968.305, -5199.9, 0.064211, 0.366518, 0, 0, 0.182235, 0.983255, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+88, 3719, 1, -805.108, -5698.99, 0.052685, 5.68977, 0, 0, -0.292372, 0.956305, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+89, 3719, 1, -641.353, -5689.82, -0.171481, 5.2709, 0, 0, -0.484809, 0.87462, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+90, 3719, 1, -515.953, -5243.47, 0.036085, 0.767944, 0, 0, 0.374606, 0.927184, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+91, 3719, 1, -366.615, -5211.02, -0.034382, 1.53589, 0, 0, 0.694658, 0.71934, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+92, 3719, 1, -236.963, -5121.01, 25.2436, 2.16421, 0, 0, 0.882947, 0.469473, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+93, 3719, 1, -174.109, -4986.14, 22.5386, 6.14356, 0, 0, -0.0697556, 0.997564, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+94, 3719, 1, 74.5528, -4218.84, 60.8336, 2.07694, 0, 0, 0.861629, 0.507539, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+95, 3719, 1, 269.646, -4701.72, 11.6288, 1.39626, 0, 0, 0.642787, 0.766045, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+96, 3719, 1, 289.618, -4771.3, 11.769, 5.77704, 0, 0, -0.25038, 0.968148, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+97, 3719, 1, 290.396, -4706.11, 12.8422, 4.5204, 0, 0, -0.771625, 0.636078, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+98, 3719, 1, 292.627, -4828.49, 10.5234, 0.855211, 0, 0, 0.414693, 0.909961, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+99, 3719, 1, 298.88, -4663.11, 16.7712, 4.41568, 0, 0, -0.803857, 0.594823, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+100, 3719, 1, 319.151, -4667.86, 16.0833, 0.767944, 0, 0, 0.374606, 0.927184, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+101, 3719, 1, 321.553, -4768.17, 11.6718, 3.38594, 0, 0, -0.992546, 0.12187, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+102, 3719, 1, 325.073, -3795.73, 26.4866, 0.90757, 0, 0, 0.438371, 0.898794, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+103, 3719, 1, 331.565, -4831.89, 10.5238, 6.21337, 0, 0, -0.0348988, 0.999391, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+104, 3719, 1, 333.578, -4705.01, 14.4859, 1.91986, 0, 0, 0.819152, 0.573577, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+105, 3719, 1, 565.234, -4092.94, 15.7267, 1.16937, 0, 0, 0.551936, 0.833886, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+106, 3719, 1, 570.299, -5131.24, 0.080435, 2.79252, 0, 0, 0.984807, 0.173652, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+107, 3719, 1, 627.12, -4443.5, 11.6634, 3.61284, 0, 0, -0.972369, 0.233448, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+108, 3719, 1, 737.128, -4604.47, -3.30816, 5.55015, 0, 0, -0.358368, 0.93358, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+109, 3719, 1, 758.13, -4565.89, 1.62941, 3.42085, 0, 0, -0.990268, 0.139175, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+110, 3719, 1, 771.55, -4460.79, 15.6685, 2.30383, 0, 0, 0.913545, 0.406738, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+111, 3719, 1, 859.703, -4170.78, -14.1103, 4.50295, 0, 0, -0.777145, 0.629321, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+112, 3719, 1, 993.55, -4672.15, 26.9618, 5.86431, 0, 0, -0.207911, 0.978148, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+113, 3719, 1, 1001.38, -3919.05, 18.7792, 3.99681, 0, 0, -0.909961, 0.414694, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+114, 3719, 1, 1080.22, -5111.17, -0.058121, 4.08407, 0, 0, -0.891006, 0.453991, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+115, 3719, 1, 1102.29, -4951.8, 15.6024, 3.82227, 0, 0, -0.942641, 0.333808, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+116, 3719, 1, 1143.52, -4695.76, 17.7529, 0.226892, 0, 0, 0.113203, 0.993572, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+117, 3719, 1, 1266.49, -5030.35, -0.039411, 0.802851, 0, 0, 0.390731, 0.920505, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+118, 3719, 1, 1466.76, -4926.21, -0.066952, 4.95674, 0, 0, -0.615661, 0.788011, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+119, 3719, 1, -1166.98, -5145.53, -0.077441, 5.48033, 0, 0, -0.390731, 0.920505, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+120, 3719, 1, -912.076, -4474.18, 29.7029, 0.0349062, 0, 0, 0.0174522, 0.999848, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+121, 3719, 1, 390.932, -5124.09, -0.05675, 2.65289, 0, 0, 0.970295, 0.241925, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+122, 3719, 1, 758.85, -4251.66, 18.3729, 1.8675, 0, 0, 0.803857, 0.594823, 180, 180, 100, 1, 0, 0, 0, 10);

INSERT INTO `pool_template` (`entry`, `max_limit`, `description`, `patch_min`, `patch_max`) VALUES
(@PTEMPLATE+1, 1, 'Water Barrel / Food Crate - Durotar', 0, 10),
(@PTEMPLATE+2, 1, 'Water Barrel / Food Crate - Durotar', 0, 10),
(@PTEMPLATE+3, 1, 'Water Barrel / Food Crate - Durotar', 0, 10),
(@PTEMPLATE+4, 1, 'Water Barrel / Food Crate - Durotar', 0, 10),
(@PTEMPLATE+5, 1, 'Water Barrel / Food Crate - Durotar', 0, 10),
(@PTEMPLATE+6, 1, 'Water Barrel / Food Crate - Durotar', 0, 10),
(@PTEMPLATE+7, 1, 'Water Barrel / Food Crate - Durotar', 0, 10),
(@PTEMPLATE+8, 1, 'Water Barrel / Food Crate - Durotar', 0, 10),
(@PTEMPLATE+9, 1, 'Water Barrel / Food Crate - Durotar', 0, 10),
(@PTEMPLATE+10, 1, 'Water Barrel / Food Crate - Durotar', 0, 10),
(@PTEMPLATE+11, 1, 'Water Barrel / Food Crate - Durotar', 0, 10),
(@PTEMPLATE+12, 1, 'Water Barrel / Food Crate - Durotar', 0, 10),
(@PTEMPLATE+13, 1, 'Water Barrel / Food Crate - Durotar', 0, 10),
(@PTEMPLATE+14, 1, 'Water Barrel / Food Crate - Durotar', 0, 10),
(@PTEMPLATE+15, 1, 'Water Barrel / Food Crate - Durotar', 0, 10),
(@PTEMPLATE+16, 1, 'Water Barrel / Food Crate - Durotar', 0, 10),
(@PTEMPLATE+17, 1, 'Water Barrel / Food Crate - Durotar', 0, 10),
(@PTEMPLATE+18, 1, 'Water Barrel / Food Crate - Durotar', 0, 10),
(@PTEMPLATE+19, 1, 'Water Barrel / Food Crate - Durotar', 0, 10),
(@PTEMPLATE+20, 1, 'Water Barrel / Food Crate - Durotar', 0, 10),
(@PTEMPLATE+21, 1, 'Water Barrel / Food Crate - Durotar', 0, 10),
(@PTEMPLATE+22, 1, 'Water Barrel / Food Crate - Durotar', 0, 10),
(@PTEMPLATE+23, 1, 'Water Barrel / Food Crate - Durotar', 0, 10),
(@PTEMPLATE+24, 1, 'Water Barrel / Food Crate - Durotar', 0, 10),
(@PTEMPLATE+25, 1, 'Water Barrel / Food Crate - Durotar', 0, 10),
(@PTEMPLATE+26, 1, 'Water Barrel / Food Crate - Durotar', 0, 10),
(@PTEMPLATE+27, 1, 'Water Barrel / Food Crate - Durotar', 0, 10),
(@PTEMPLATE+28, 1, 'Water Barrel / Food Crate - Durotar', 0, 10),
(@PTEMPLATE+29, 1, 'Water Barrel / Food Crate - Durotar', 0, 10),
(@PTEMPLATE+30, 1, 'Water Barrel / Food Crate - Durotar', 0, 10),
(@PTEMPLATE+31, 1, 'Water Barrel / Food Crate - Durotar', 0, 10),
(@PTEMPLATE+32, 1, 'Water Barrel / Food Crate - Durotar', 0, 10),
(@PTEMPLATE+33, 1, 'Water Barrel / Food Crate - Durotar', 0, 10),
(@PTEMPLATE+34, 1, 'Water Barrel / Food Crate - Durotar', 0, 10),
(@PTEMPLATE+35, 1, 'Water Barrel / Food Crate - Durotar', 0, 10),
(@PTEMPLATE+36, 1, 'Water Barrel / Food Crate - Durotar', 0, 10),
(@PTEMPLATE+37, 1, 'Water Barrel / Food Crate - Durotar', 0, 10),
(@PTEMPLATE+38, 1, 'Water Barrel / Food Crate - Durotar', 0, 10),
(@PTEMPLATE+39, 1, 'Water Barrel / Food Crate - Durotar', 0, 10),
(@PTEMPLATE+40, 1, 'Water Barrel / Food Crate - Durotar', 0, 10),
(@PTEMPLATE+41, 1, 'Water Barrel / Food Crate - Durotar', 0, 10),
(@PTEMPLATE+42, 1, 'Water Barrel / Food Crate - Durotar', 0, 10),
(@PTEMPLATE+43, 1, 'Water Barrel / Food Crate - Durotar', 0, 10),
(@PTEMPLATE+44, 1, 'Water Barrel / Food Crate - Durotar', 0, 10),
(@PTEMPLATE+45, 1, 'Water Barrel / Food Crate - Durotar', 0, 10),
(@PTEMPLATE+46, 1, 'Water Barrel / Food Crate - Durotar', 0, 10),
(@PTEMPLATE+47, 1, 'Water Barrel / Food Crate - Durotar', 0, 10),
(@PTEMPLATE+48, 1, 'Water Barrel / Food Crate - Durotar', 0, 10),
(@PTEMPLATE+49, 1, 'Water Barrel / Food Crate - Durotar', 0, 10),
(@PTEMPLATE+50, 1, 'Water Barrel / Food Crate - Durotar', 0, 10),
(@PTEMPLATE+51, 1, 'Water Barrel / Food Crate - Durotar', 0, 10),
(@PTEMPLATE+52, 1, 'Water Barrel / Food Crate - Durotar', 0, 10),
(@PTEMPLATE+53, 1, 'Water Barrel / Food Crate - Durotar', 0, 10),
(@PTEMPLATE+54, 1, 'Water Barrel / Food Crate - Durotar', 0, 10),
(@PTEMPLATE+55, 1, 'Water Barrel / Food Crate - Durotar', 0, 10),
(@PTEMPLATE+56, 1, 'Water Barrel / Food Crate - Durotar', 0, 10),
(@PTEMPLATE+57, 1, 'Water Barrel / Food Crate - Durotar', 0, 10),
(@PTEMPLATE+58, 1, 'Water Barrel / Food Crate - Durotar', 0, 10),
(@PTEMPLATE+59, 1, 'Water Barrel / Food Crate - Durotar', 0, 10),
(@PTEMPLATE+60, 1, 'Water Barrel / Food Crate - Durotar', 0, 10),
(@PTEMPLATE+61, 1, 'Water Barrel / Food Crate - Durotar', 0, 10);

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

INSERT INTO `pool_template` (`entry`, `max_limit`, `description`, `flags`, `instance`, `patch_min`, `patch_max`) VALUES
(@PTEMPLATE+62, 28, 'Durotar - Water Barrel / Food Crate (Master Pool)', 0, 0, 0, 10);
INSERT INTO `pool_pool` (`pool_id`, `mother_pool`, `chance`, `description`, `flags`) VALUES
(@PTEMPLATE+1, @PTEMPLATE+62, 0, 'Water Barrel / Food Crate - Durotar', 0),
(@PTEMPLATE+2, @PTEMPLATE+62, 0, 'Water Barrel / Food Crate - Durotar', 0),
(@PTEMPLATE+3, @PTEMPLATE+62, 0, 'Water Barrel / Food Crate - Durotar', 0),
(@PTEMPLATE+4, @PTEMPLATE+62, 0, 'Water Barrel / Food Crate - Durotar', 0),
(@PTEMPLATE+5, @PTEMPLATE+62, 0, 'Water Barrel / Food Crate - Durotar', 0),
(@PTEMPLATE+6, @PTEMPLATE+62, 0, 'Water Barrel / Food Crate - Durotar', 0),
(@PTEMPLATE+7, @PTEMPLATE+62, 0, 'Water Barrel / Food Crate - Durotar', 0),
(@PTEMPLATE+8, @PTEMPLATE+62, 0, 'Water Barrel / Food Crate - Durotar', 0),
(@PTEMPLATE+9, @PTEMPLATE+62, 0, 'Water Barrel / Food Crate - Durotar', 0),
(@PTEMPLATE+10, @PTEMPLATE+62, 0, 'Water Barrel / Food Crate - Durotar', 0),
(@PTEMPLATE+11, @PTEMPLATE+62, 0, 'Water Barrel / Food Crate - Durotar', 0),
(@PTEMPLATE+12, @PTEMPLATE+62, 0, 'Water Barrel / Food Crate - Durotar', 0),
(@PTEMPLATE+13, @PTEMPLATE+62, 0, 'Water Barrel / Food Crate - Durotar', 0),
(@PTEMPLATE+14, @PTEMPLATE+62, 0, 'Water Barrel / Food Crate - Durotar', 0),
(@PTEMPLATE+15, @PTEMPLATE+62, 0, 'Water Barrel / Food Crate - Durotar', 0),
(@PTEMPLATE+16, @PTEMPLATE+62, 0, 'Water Barrel / Food Crate - Durotar', 0),
(@PTEMPLATE+17, @PTEMPLATE+62, 0, 'Water Barrel / Food Crate - Durotar', 0),
(@PTEMPLATE+18, @PTEMPLATE+62, 0, 'Water Barrel / Food Crate - Durotar', 0),
(@PTEMPLATE+19, @PTEMPLATE+62, 0, 'Water Barrel / Food Crate - Durotar', 0),
(@PTEMPLATE+20, @PTEMPLATE+62, 0, 'Water Barrel / Food Crate - Durotar', 0),
(@PTEMPLATE+21, @PTEMPLATE+62, 0, 'Water Barrel / Food Crate - Durotar', 0),
(@PTEMPLATE+22, @PTEMPLATE+62, 0, 'Water Barrel / Food Crate - Durotar', 0),
(@PTEMPLATE+23, @PTEMPLATE+62, 0, 'Water Barrel / Food Crate - Durotar', 0),
(@PTEMPLATE+24, @PTEMPLATE+62, 0, 'Water Barrel / Food Crate - Durotar', 0),
(@PTEMPLATE+25, @PTEMPLATE+62, 0, 'Water Barrel / Food Crate - Durotar', 0),
(@PTEMPLATE+26, @PTEMPLATE+62, 0, 'Water Barrel / Food Crate - Durotar', 0),
(@PTEMPLATE+27, @PTEMPLATE+62, 0, 'Water Barrel / Food Crate - Durotar', 0),
(@PTEMPLATE+28, @PTEMPLATE+62, 0, 'Water Barrel / Food Crate - Durotar', 0),
(@PTEMPLATE+29, @PTEMPLATE+62, 0, 'Water Barrel / Food Crate - Durotar', 0),
(@PTEMPLATE+30, @PTEMPLATE+62, 0, 'Water Barrel / Food Crate - Durotar', 0),
(@PTEMPLATE+31, @PTEMPLATE+62, 0, 'Water Barrel / Food Crate - Durotar', 0),
(@PTEMPLATE+32, @PTEMPLATE+62, 0, 'Water Barrel / Food Crate - Durotar', 0),
(@PTEMPLATE+33, @PTEMPLATE+62, 0, 'Water Barrel / Food Crate - Durotar', 0),
(@PTEMPLATE+34, @PTEMPLATE+62, 0, 'Water Barrel / Food Crate - Durotar', 0),
(@PTEMPLATE+35, @PTEMPLATE+62, 0, 'Water Barrel / Food Crate - Durotar', 0),
(@PTEMPLATE+36, @PTEMPLATE+62, 0, 'Water Barrel / Food Crate - Durotar', 0),
(@PTEMPLATE+37, @PTEMPLATE+62, 0, 'Water Barrel / Food Crate - Durotar', 0),
(@PTEMPLATE+38, @PTEMPLATE+62, 0, 'Water Barrel / Food Crate - Durotar', 0),
(@PTEMPLATE+39, @PTEMPLATE+62, 0, 'Water Barrel / Food Crate - Durotar', 0),
(@PTEMPLATE+40, @PTEMPLATE+62, 0, 'Water Barrel / Food Crate - Durotar', 0),
(@PTEMPLATE+41, @PTEMPLATE+62, 0, 'Water Barrel / Food Crate - Durotar', 0),
(@PTEMPLATE+42, @PTEMPLATE+62, 0, 'Water Barrel / Food Crate - Durotar', 0),
(@PTEMPLATE+43, @PTEMPLATE+62, 0, 'Water Barrel / Food Crate - Durotar', 0),
(@PTEMPLATE+44, @PTEMPLATE+62, 0, 'Water Barrel / Food Crate - Durotar', 0),
(@PTEMPLATE+45, @PTEMPLATE+62, 0, 'Water Barrel / Food Crate - Durotar', 0),
(@PTEMPLATE+46, @PTEMPLATE+62, 0, 'Water Barrel / Food Crate - Durotar', 0),
(@PTEMPLATE+47, @PTEMPLATE+62, 0, 'Water Barrel / Food Crate - Durotar', 0),
(@PTEMPLATE+48, @PTEMPLATE+62, 0, 'Water Barrel / Food Crate - Durotar', 0),
(@PTEMPLATE+49, @PTEMPLATE+62, 0, 'Water Barrel / Food Crate - Durotar', 0),
(@PTEMPLATE+50, @PTEMPLATE+62, 0, 'Water Barrel / Food Crate - Durotar', 0),
(@PTEMPLATE+51, @PTEMPLATE+62, 0, 'Water Barrel / Food Crate - Durotar', 0),
(@PTEMPLATE+52, @PTEMPLATE+62, 0, 'Water Barrel / Food Crate - Durotar', 0),
(@PTEMPLATE+53, @PTEMPLATE+62, 0, 'Water Barrel / Food Crate - Durotar', 0),
(@PTEMPLATE+54, @PTEMPLATE+62, 0, 'Water Barrel / Food Crate - Durotar', 0),
(@PTEMPLATE+55, @PTEMPLATE+62, 0, 'Water Barrel / Food Crate - Durotar', 0),
(@PTEMPLATE+56, @PTEMPLATE+62, 0, 'Water Barrel / Food Crate - Durotar', 0),
(@PTEMPLATE+57, @PTEMPLATE+62, 0, 'Water Barrel / Food Crate - Durotar', 0),
(@PTEMPLATE+58, @PTEMPLATE+62, 0, 'Water Barrel / Food Crate - Durotar', 0),
(@PTEMPLATE+59, @PTEMPLATE+62, 0, 'Water Barrel / Food Crate - Durotar', 0),
(@PTEMPLATE+60, @PTEMPLATE+62, 0, 'Water Barrel / Food Crate - Durotar', 0),
(@PTEMPLATE+61, @PTEMPLATE+62, 0, 'Water Barrel / Food Crate - Durotar', 0);


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