sindoring/moonwell-core-vanilla
1
0
Fork 0
Code Issues Pull Requests Packages Projects Releases Wiki Activity
Files
development
moonwell-core-vanilla/sql/migrations/20230703190442_world.sql
T
NickTyrer c913a8ba9c Water Barrel / Food Crate - Dun Morogh (#2030)
2023-07-07 06:50:24 +01:00

211 lines
18 KiB
SQL
Raw Permalink Blame History

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`='20230703190442');
IF v=0 THEN
INSERT INTO `migrations` VALUES ('20230703190442');
-- Add your query below.
SET @OGUID = 24573;
SET @PTEMPLATE = 162;
-- Dun Morogh 3658 / 3719
DELETE FROM `pool_template` WHERE `entry` IN (SELECT `pool_entry` FROM `pool_gameobject` WHERE `guid` IN (1462, 9467, 12759, 88000, 88001, 88002, 88003, 88004, 88005, 88006, 88007, 88010, 88011, 88012, 88013, 88038, 88039, 88040, 88041, 88042, 88043, 88044, 88045, 88046, 88047, 88048, 88049, 88050, 88051, 88052, 88053, 88054, 88055, 88056, 88057, 88058, 88059, 88060, 88061, 88062, 88063, 88064, 88065, 88066, 88067, 88068, 88069, 88070, 88071, 88072, 88073, 88074, 88075, 88076, 88077, 88078, 88079, 88080, 88081, 88082, 88083, 88084, 88085, 88086, 88087, 88088, 88089, 88090, 88091, 88092, 88093, 10063, 10173, 10677, 10734, 10838, 10847, 10946, 29306, 29317, 29609, 29626, 29640, 31414, 32369, 88008, 88009));
DELETE FROM `gameobject` WHERE `guid` IN (1462, 9467, 12759, 88000, 88001, 88002, 88003, 88004, 88005, 88006, 88007, 88010, 88011, 88012, 88013, 88038, 88039, 88040, 88041, 88042, 88043, 88044, 88045, 88046, 88047, 88048, 88049, 88050, 88051, 88052, 88053, 88054, 88055, 88056, 88057, 88058, 88059, 88060, 88061, 88062, 88063, 88064, 88065, 88066, 88067, 88068, 88069, 88070, 88071, 88072, 88073, 88074, 88075, 88076, 88077, 88078, 88079, 88080, 88081, 88082, 88083, 88084, 88085, 88086, 88087, 88088, 88089, 88090, 88091, 88092, 88093, 10063, 10173, 10677, 10734, 10838, 10847, 10946, 29306, 29317, 29609, 29626, 29640, 31414, 32369, 88008, 88009);
DELETE FROM `pool_gameobject` WHERE `guid` IN (1462, 9467, 12759, 88000, 88001, 88002, 88003, 88004, 88005, 88006, 88007, 88010, 88011, 88012, 88013, 88038, 88039, 88040, 88041, 88042, 88043, 88044, 88045, 88046, 88047, 88048, 88049, 88050, 88051, 88052, 88053, 88054, 88055, 88056, 88057, 88058, 88059, 88060, 88061, 88062, 88063, 88064, 88065, 88066, 88067, 88068, 88069, 88070, 88071, 88072, 88073, 88074, 88075, 88076, 88077, 88078, 88079, 88080, 88081, 88082, 88083, 88084, 88085, 88086, 88087, 88088, 88089, 88090, 88091, 88092, 88093, 10063, 10173, 10677, 10734, 10838, 10847, 10946, 29306, 29317, 29609, 29626, 29640, 31414, 32369, 88008, 88009);
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, 0, -5862.66, -1538.93, 371.974, -2.14675, 0, 0, 0.878817, -0.477159, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+2, 3658, 0, -5662.8, -1553.14, 387.125, 0.436332, 0, 0, 0.21644, 0.976296, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+3, 3658, 0, -5637.03, -505.798, 396.955, 3.00197, 0, 0, 0.997564, 0.069757, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+4, 3658, 0, -5602.55, -2006.01, 395.767, -0.872665, 0, 0, 0.422618, -0.906308, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+5, 3658, 0, -5569.67, -462.497, 402.397, -1.69297, 0, 0, 0.748956, -0.66262, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+6, 3658, 0, -5566.9, 106.377, 482.453, -1.23918, 0, 0, 0.580703, -0.814116, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+7, 3658, 0, -5521.79, -1299.64, 405.023, 0.331613, 0, 0, 0.165048, 0.986286, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+8, 3658, 0, -5470.22, -636.681, 393.521, 0.331613, 0, 0, 0.165048, 0.986286, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+9, 3658, 0, -5468.16, -635.275, 393.725, 0.331613, 0, 0, 0.165048, 0.986286, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+10, 3658, 0, -5416.44, -1249.67, 444.115, -1.22173, 0, 0, 0.573576, -0.819152, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+11, 3658, 0, -5371.96, 287.039, 394.127, -1.0472, 0, 0, 0.5, -0.866025, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+12, 3658, 0, -5316.5, -1053.26, 393.347, -1.79769, 0, 0, -0.782608, 0.622514, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+13, 3658, 0, -5123.81, -2339.11, 400.498, 2.21657, 0, 0, 0.894934, 0.446198, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+14, 3658, 0, -5077.23, 494.845, 401.821, -2.47837, 0, 0, 0.945519, -0.325568, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+15, 3658, 0, -5073.84, 445.727, 410.966, 0.10472, 0, 0, 0.052336, 0.99863, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+16, 3658, 0, -5060.36, -249.986, 442.184, -1.53589, 0, 0, 0.694658, -0.71934, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+17, 3658, 0, -5932.59, -2040.1, 408.249, 0.139624, 0, 0, 0.0697556, 0.997564, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+18, 3658, 0, -5877.41, -2003.39, 401.197, 3.05433, 0, 0, 0.999048, 0.0436193, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+19, 3658, 0, -5826.51, -1588.39, 363.242, 0.890117, 0, 0, 0.430511, 0.902586, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+20, 3658, 0, -5784.28, 435.891, 427.16, 1.32645, 0, 0, 0.615661, 0.788011, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+21, 3658, 0, -5688.71, -1617.47, 383.204, 1.13446, 0, 0, 0.537299, 0.843392, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+22, 3658, 0, -5552.64, 525.477, 383.305, 5.44543, 0, 0, -0.406736, 0.913546, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+23, 3658, 0, -5459.02, -2432.54, 401.572, 5.41052, 0, 0, -0.422618, 0.906308, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+24, 3658, 0, -5352.76, -221.747, 443.94, 5.09636, 0, 0, -0.559193, 0.829038, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+25, 3658, 0, -5339.09, 572.927, 384.472, 3.76991, 0, 0, -0.951056, 0.309017, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+26, 3658, 0, -5227.97, -2343.18, 398.827, 5.89921, 0, 0, -0.190808, 0.981627, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+27, 3658, 0, -5071.2, -14.6764, 395.701, 3.50812, 0, 0, -0.983254, 0.182238, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+28, 3658, 0, -5719.55, -1585.04, 383.204, 6.17847, 0, 0, -0.0523357, 0.99863, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+29, 3658, 0, -5531.22, 556.98, 394.625, 1.32645, 0, 0, 0.615661, 0.788011, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+30, 3719, 0, -5862.66, -1538.93, 371.974, -2.14675, 0, 0, 0.878817, -0.477159, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+31, 3719, 0, -5662.8, -1553.14, 387.125, 0.436332, 0, 0, 0.21644, 0.976296, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+32, 3719, 0, -5637.03, -505.798, 396.955, 3.00197, 0, 0, 0.997564, 0.069757, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+33, 3719, 0, -5602.55, -2006.01, 395.767, -0.872665, 0, 0, 0.422618, -0.906308, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+34, 3719, 0, -5569.67, -462.497, 402.397, -1.69297, 0, 0, 0.748956, -0.66262, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+35, 3719, 0, -5566.9, 106.377, 482.453, -1.23918, 0, 0, 0.580703, -0.814116, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+36, 3719, 0, -5521.79, -1299.64, 405.023, 0.331613, 0, 0, 0.165048, 0.986286, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+37, 3719, 0, -5470.22, -636.681, 393.521, 0.331613, 0, 0, 0.165048, 0.986286, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+38, 3719, 0, -5468.16, -635.275, 393.725, 0.331613, 0, 0, 0.165048, 0.986286, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+39, 3719, 0, -5416.44, -1249.67, 444.115, -1.22173, 0, 0, 0.573576, -0.819152, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+40, 3719, 0, -5371.96, 287.039, 394.127, -1.0472, 0, 0, 0.5, -0.866025, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+41, 3719, 0, -5316.5, -1053.26, 393.347, -1.79769, 0, 0, -0.782608, 0.622514, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+42, 3719, 0, -5123.81, -2339.11, 400.498, 2.21657, 0, 0, 0.894934, 0.446198, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+43, 3719, 0, -5077.23, 494.845, 401.821, -2.47837, 0, 0, 0.945519, -0.325568, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+44, 3719, 0, -5073.84, 445.727, 410.966, 0.10472, 0, 0, 0.052336, 0.99863, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+45, 3719, 0, -5060.36, -249.986, 442.184, -1.53589, 0, 0, 0.694658, -0.71934, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+46, 3719, 0, -5932.59, -2040.1, 408.249, 0.139624, 0, 0, 0.0697556, 0.997564, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+47, 3719, 0, -5877.41, -2003.39, 401.197, 3.05433, 0, 0, 0.999048, 0.0436193, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+48, 3719, 0, -5826.51, -1588.39, 363.242, 0.890117, 0, 0, 0.430511, 0.902586, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+49, 3719, 0, -5784.28, 435.891, 427.16, 1.32645, 0, 0, 0.615661, 0.788011, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+50, 3719, 0, -5688.71, -1617.47, 383.204, 1.13446, 0, 0, 0.537299, 0.843392, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+51, 3719, 0, -5552.64, 525.477, 383.305, 5.44543, 0, 0, -0.406736, 0.913546, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+52, 3719, 0, -5459.02, -2432.54, 401.572, 5.41052, 0, 0, -0.422618, 0.906308, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+53, 3719, 0, -5352.76, -221.747, 443.94, 5.09636, 0, 0, -0.559193, 0.829038, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+54, 3719, 0, -5339.09, 572.927, 384.472, 3.76991, 0, 0, -0.951056, 0.309017, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+55, 3719, 0, -5227.97, -2343.18, 398.827, 5.89921, 0, 0, -0.190808, 0.981627, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+56, 3719, 0, -5071.2, -14.6764, 395.701, 3.50812, 0, 0, -0.983254, 0.182238, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+57, 3719, 0, -5719.55, -1585.04, 383.204, 6.17847, 0, 0, -0.0523357, 0.99863, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+58, 3719, 0, -5531.22, 556.98, 394.625, 1.32645, 0, 0, 0.615661, 0.788011, 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 - Dun Morogh', 0, 10),
(@PTEMPLATE+2, 1, 'Water Barrel / Food Crate - Dun Morogh', 0, 10),
(@PTEMPLATE+3, 1, 'Water Barrel / Food Crate - Dun Morogh', 0, 10),
(@PTEMPLATE+4, 1, 'Water Barrel / Food Crate - Dun Morogh', 0, 10),
(@PTEMPLATE+5, 1, 'Water Barrel / Food Crate - Dun Morogh', 0, 10),
(@PTEMPLATE+6, 1, 'Water Barrel / Food Crate - Dun Morogh', 0, 10),
(@PTEMPLATE+7, 1, 'Water Barrel / Food Crate - Dun Morogh', 0, 10),
(@PTEMPLATE+8, 1, 'Water Barrel / Food Crate - Dun Morogh', 0, 10),
(@PTEMPLATE+9, 1, 'Water Barrel / Food Crate - Dun Morogh', 0, 10),
(@PTEMPLATE+10, 1, 'Water Barrel / Food Crate - Dun Morogh', 0, 10),
(@PTEMPLATE+11, 1, 'Water Barrel / Food Crate - Dun Morogh', 0, 10),
(@PTEMPLATE+12, 1, 'Water Barrel / Food Crate - Dun Morogh', 0, 10),
(@PTEMPLATE+13, 1, 'Water Barrel / Food Crate - Dun Morogh', 0, 10),
(@PTEMPLATE+14, 1, 'Water Barrel / Food Crate - Dun Morogh', 0, 10),
(@PTEMPLATE+15, 1, 'Water Barrel / Food Crate - Dun Morogh', 0, 10),
(@PTEMPLATE+16, 1, 'Water Barrel / Food Crate - Dun Morogh', 0, 10),
(@PTEMPLATE+17, 1, 'Water Barrel / Food Crate - Dun Morogh', 0, 10),
(@PTEMPLATE+18, 1, 'Water Barrel / Food Crate - Dun Morogh', 0, 10),
(@PTEMPLATE+19, 1, 'Water Barrel / Food Crate - Dun Morogh', 0, 10),
(@PTEMPLATE+20, 1, 'Water Barrel / Food Crate - Dun Morogh', 0, 10),
(@PTEMPLATE+21, 1, 'Water Barrel / Food Crate - Dun Morogh', 0, 10),
(@PTEMPLATE+22, 1, 'Water Barrel / Food Crate - Dun Morogh', 0, 10),
(@PTEMPLATE+23, 1, 'Water Barrel / Food Crate - Dun Morogh', 0, 10),
(@PTEMPLATE+24, 1, 'Water Barrel / Food Crate - Dun Morogh', 0, 10),
(@PTEMPLATE+25, 1, 'Water Barrel / Food Crate - Dun Morogh', 0, 10),
(@PTEMPLATE+26, 1, 'Water Barrel / Food Crate - Dun Morogh', 0, 10),
(@PTEMPLATE+27, 1, 'Water Barrel / Food Crate - Dun Morogh', 0, 10),
(@PTEMPLATE+28, 1, 'Water Barrel / Food Crate - Dun Morogh', 0, 10),
(@PTEMPLATE+29, 1, 'Water Barrel / Food Crate - Dun Morogh', 0, 10);
INSERT INTO `pool_gameobject` (`guid`, `pool_entry`, `description`, `patch_min`, `patch_max`) VALUES
(@OGUID+1, @PTEMPLATE+1, 'Water Barrel / Food Crate - Dun Morogh', 0, 10),
(@OGUID+2, @PTEMPLATE+2, 'Water Barrel / Food Crate - Dun Morogh', 0, 10),
(@OGUID+3, @PTEMPLATE+3, 'Water Barrel / Food Crate - Dun Morogh', 0, 10),
(@OGUID+4, @PTEMPLATE+4, 'Water Barrel / Food Crate - Dun Morogh', 0, 10),
(@OGUID+5, @PTEMPLATE+5, 'Water Barrel / Food Crate - Dun Morogh', 0, 10),
(@OGUID+6, @PTEMPLATE+6, 'Water Barrel / Food Crate - Dun Morogh', 0, 10),
(@OGUID+7, @PTEMPLATE+7, 'Water Barrel / Food Crate - Dun Morogh', 0, 10),
(@OGUID+8, @PTEMPLATE+8, 'Water Barrel / Food Crate - Dun Morogh', 0, 10),
(@OGUID+9, @PTEMPLATE+9, 'Water Barrel / Food Crate - Dun Morogh', 0, 10),
(@OGUID+10, @PTEMPLATE+10, 'Water Barrel / Food Crate - Dun Morogh', 0, 10),
(@OGUID+11, @PTEMPLATE+11, 'Water Barrel / Food Crate - Dun Morogh', 0, 10),
(@OGUID+12, @PTEMPLATE+12, 'Water Barrel / Food Crate - Dun Morogh', 0, 10),
(@OGUID+13, @PTEMPLATE+13, 'Water Barrel / Food Crate - Dun Morogh', 0, 10),
(@OGUID+14, @PTEMPLATE+14, 'Water Barrel / Food Crate - Dun Morogh', 0, 10),
(@OGUID+15, @PTEMPLATE+15, 'Water Barrel / Food Crate - Dun Morogh', 0, 10),
(@OGUID+16, @PTEMPLATE+16, 'Water Barrel / Food Crate - Dun Morogh', 0, 10),
(@OGUID+17, @PTEMPLATE+17, 'Water Barrel / Food Crate - Dun Morogh', 0, 10),
(@OGUID+18, @PTEMPLATE+18, 'Water Barrel / Food Crate - Dun Morogh', 0, 10),
(@OGUID+19, @PTEMPLATE+19, 'Water Barrel / Food Crate - Dun Morogh', 0, 10),
(@OGUID+20, @PTEMPLATE+20, 'Water Barrel / Food Crate - Dun Morogh', 0, 10),
(@OGUID+21, @PTEMPLATE+21, 'Water Barrel / Food Crate - Dun Morogh', 0, 10),
(@OGUID+22, @PTEMPLATE+22, 'Water Barrel / Food Crate - Dun Morogh', 0, 10),
(@OGUID+23, @PTEMPLATE+23, 'Water Barrel / Food Crate - Dun Morogh', 0, 10),
(@OGUID+24, @PTEMPLATE+24, 'Water Barrel / Food Crate - Dun Morogh', 0, 10),
(@OGUID+25, @PTEMPLATE+25, 'Water Barrel / Food Crate - Dun Morogh', 0, 10),
(@OGUID+26, @PTEMPLATE+26, 'Water Barrel / Food Crate - Dun Morogh', 0, 10),
(@OGUID+27, @PTEMPLATE+27, 'Water Barrel / Food Crate - Dun Morogh', 0, 10),
(@OGUID+28, @PTEMPLATE+28, 'Water Barrel / Food Crate - Dun Morogh', 0, 10),
(@OGUID+29, @PTEMPLATE+29, 'Water Barrel / Food Crate - Dun Morogh', 0, 10),
(@OGUID+30, @PTEMPLATE+1, 'Water Barrel / Food Crate - Dun Morogh', 0, 10),
(@OGUID+31, @PTEMPLATE+2, 'Water Barrel / Food Crate - Dun Morogh', 0, 10),
(@OGUID+32, @PTEMPLATE+3, 'Water Barrel / Food Crate - Dun Morogh', 0, 10),
(@OGUID+33, @PTEMPLATE+4, 'Water Barrel / Food Crate - Dun Morogh', 0, 10),
(@OGUID+34, @PTEMPLATE+5, 'Water Barrel / Food Crate - Dun Morogh', 0, 10),
(@OGUID+35, @PTEMPLATE+6, 'Water Barrel / Food Crate - Dun Morogh', 0, 10),
(@OGUID+36, @PTEMPLATE+7, 'Water Barrel / Food Crate - Dun Morogh', 0, 10),
(@OGUID+37, @PTEMPLATE+8, 'Water Barrel / Food Crate - Dun Morogh', 0, 10),
(@OGUID+38, @PTEMPLATE+9, 'Water Barrel / Food Crate - Dun Morogh', 0, 10),
(@OGUID+39, @PTEMPLATE+10, 'Water Barrel / Food Crate - Dun Morogh', 0, 10),
(@OGUID+40, @PTEMPLATE+11, 'Water Barrel / Food Crate - Dun Morogh', 0, 10),
(@OGUID+41, @PTEMPLATE+12, 'Water Barrel / Food Crate - Dun Morogh', 0, 10),
(@OGUID+42, @PTEMPLATE+13, 'Water Barrel / Food Crate - Dun Morogh', 0, 10),
(@OGUID+43, @PTEMPLATE+14, 'Water Barrel / Food Crate - Dun Morogh', 0, 10),
(@OGUID+44, @PTEMPLATE+15, 'Water Barrel / Food Crate - Dun Morogh', 0, 10),
(@OGUID+45, @PTEMPLATE+16, 'Water Barrel / Food Crate - Dun Morogh', 0, 10),
(@OGUID+46, @PTEMPLATE+17, 'Water Barrel / Food Crate - Dun Morogh', 0, 10),
(@OGUID+47, @PTEMPLATE+18, 'Water Barrel / Food Crate - Dun Morogh', 0, 10),
(@OGUID+48, @PTEMPLATE+19, 'Water Barrel / Food Crate - Dun Morogh', 0, 10),
(@OGUID+49, @PTEMPLATE+20, 'Water Barrel / Food Crate - Dun Morogh', 0, 10),
(@OGUID+50, @PTEMPLATE+21, 'Water Barrel / Food Crate - Dun Morogh', 0, 10),
(@OGUID+51, @PTEMPLATE+22, 'Water Barrel / Food Crate - Dun Morogh', 0, 10),
(@OGUID+52, @PTEMPLATE+23, 'Water Barrel / Food Crate - Dun Morogh', 0, 10),
(@OGUID+53, @PTEMPLATE+24, 'Water Barrel / Food Crate - Dun Morogh', 0, 10),
(@OGUID+54, @PTEMPLATE+25, 'Water Barrel / Food Crate - Dun Morogh', 0, 10),
(@OGUID+55, @PTEMPLATE+26, 'Water Barrel / Food Crate - Dun Morogh', 0, 10),
(@OGUID+56, @PTEMPLATE+27, 'Water Barrel / Food Crate - Dun Morogh', 0, 10),
(@OGUID+57, @PTEMPLATE+28, 'Water Barrel / Food Crate - Dun Morogh', 0, 10),
(@OGUID+58, @PTEMPLATE+29, 'Water Barrel / Food Crate - Dun Morogh', 0, 10);
INSERT INTO `pool_template` (`entry`, `max_limit`, `description`, `flags`, `instance`, `patch_min`, `patch_max`) VALUES
(@PTEMPLATE+30, 12, 'Dun Morogh - 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+30, 0, 'Water Barrel / Food Crate - Dun Morogh', 0),
(@PTEMPLATE+2, @PTEMPLATE+30, 0, 'Water Barrel / Food Crate - Dun Morogh', 0),
(@PTEMPLATE+3, @PTEMPLATE+30, 0, 'Water Barrel / Food Crate - Dun Morogh', 0),
(@PTEMPLATE+4, @PTEMPLATE+30, 0, 'Water Barrel / Food Crate - Dun Morogh', 0),
(@PTEMPLATE+5, @PTEMPLATE+30, 0, 'Water Barrel / Food Crate - Dun Morogh', 0),
(@PTEMPLATE+6, @PTEMPLATE+30, 0, 'Water Barrel / Food Crate - Dun Morogh', 0),
(@PTEMPLATE+7, @PTEMPLATE+30, 0, 'Water Barrel / Food Crate - Dun Morogh', 0),
(@PTEMPLATE+8, @PTEMPLATE+30, 0, 'Water Barrel / Food Crate - Dun Morogh', 0),
(@PTEMPLATE+9, @PTEMPLATE+30, 0, 'Water Barrel / Food Crate - Dun Morogh', 0),
(@PTEMPLATE+10, @PTEMPLATE+30, 0, 'Water Barrel / Food Crate - Dun Morogh', 0),
(@PTEMPLATE+11, @PTEMPLATE+30, 0, 'Water Barrel / Food Crate - Dun Morogh', 0),
(@PTEMPLATE+12, @PTEMPLATE+30, 0, 'Water Barrel / Food Crate - Dun Morogh', 0),
(@PTEMPLATE+13, @PTEMPLATE+30, 0, 'Water Barrel / Food Crate - Dun Morogh', 0),
(@PTEMPLATE+14, @PTEMPLATE+30, 0, 'Water Barrel / Food Crate - Dun Morogh', 0),
(@PTEMPLATE+15, @PTEMPLATE+30, 0, 'Water Barrel / Food Crate - Dun Morogh', 0),
(@PTEMPLATE+16, @PTEMPLATE+30, 0, 'Water Barrel / Food Crate - Dun Morogh', 0),
(@PTEMPLATE+17, @PTEMPLATE+30, 0, 'Water Barrel / Food Crate - Dun Morogh', 0),
(@PTEMPLATE+18, @PTEMPLATE+30, 0, 'Water Barrel / Food Crate - Dun Morogh', 0),
(@PTEMPLATE+19, @PTEMPLATE+30, 0, 'Water Barrel / Food Crate - Dun Morogh', 0),
(@PTEMPLATE+20, @PTEMPLATE+30, 0, 'Water Barrel / Food Crate - Dun Morogh', 0),
(@PTEMPLATE+21, @PTEMPLATE+30, 0, 'Water Barrel / Food Crate - Dun Morogh', 0),
(@PTEMPLATE+22, @PTEMPLATE+30, 0, 'Water Barrel / Food Crate - Dun Morogh', 0),
(@PTEMPLATE+23, @PTEMPLATE+30, 0, 'Water Barrel / Food Crate - Dun Morogh', 0),
(@PTEMPLATE+24, @PTEMPLATE+30, 0, 'Water Barrel / Food Crate - Dun Morogh', 0),
(@PTEMPLATE+25, @PTEMPLATE+30, 0, 'Water Barrel / Food Crate - Dun Morogh', 0),
(@PTEMPLATE+26, @PTEMPLATE+30, 0, 'Water Barrel / Food Crate - Dun Morogh', 0),
(@PTEMPLATE+27, @PTEMPLATE+30, 0, 'Water Barrel / Food Crate - Dun Morogh', 0),
(@PTEMPLATE+28, @PTEMPLATE+30, 0, 'Water Barrel / Food Crate - Dun Morogh', 0),
(@PTEMPLATE+29, @PTEMPLATE+30, 0, 'Water Barrel / Food Crate - Dun Morogh', 0);
-- End of migration.
END IF;
END??
delimiter ;
CALL add_migration();
DROP PROCEDURE IF EXISTS add_migration;
Reference in New Issue View Git Blame Copy Permalink