sindoring/moonwell-core-vanilla
1
0
Fork 0
Code Issues Pull Requests Packages Projects Releases Wiki Activity
Files
development
moonwell-core-vanilla/sql/migrations/20230706182138_world.sql
T

223 lines
19 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`='20230706182138');
IF v=0 THEN
INSERT INTO `migrations` VALUES ('20230706182138');
-- Add your query below.
SET @OGUID = 42360;
SET @PTEMPLATE = 4212;
-- 331 Ashenvale 3659 / 3695 / Barrel of Melon Juice / Food Crate
DELETE FROM `pool_template` WHERE `entry` IN (SELECT `pool_entry` FROM `pool_gameobject` WHERE `guid` IN (47896, 47897, 47898, 47899, 47900, 47976, 47977, 47978, 47979, 47980, 47981));
DELETE FROM `gameobject` WHERE `guid` IN (47896, 47897, 47898, 47899, 47900, 47976, 47977, 47978, 47979, 47980, 47981);
DELETE FROM `pool_gameobject` WHERE `guid` IN (47896, 47897, 47898, 47899, 47900, 47976, 47977, 47978, 47979, 47980, 47981);
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, 3659, 1, 1711.78, -3438.29, 144.293, 0.820305, 0, 0, 0.398749, 0.91706, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+2, 3659, 1, 1768.68, -2032.74, 109.836, 2.32129, 0, 0, 0.91706, 0.398749, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+3, 3659, 1, 2188.77, -3203.47, 103.816, 2.30383, 0, 0, 0.913545, 0.406737, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+4, 3659, 1, 2321.68, -1433.86, 87.0652, -1.91986, 0, 0, 0.819152, -0.573576, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+5, 3659, 1, 2471.38, -2152.43, 202.284, 2.23402, 0, 0, 0.898794, 0.438371, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+6, 3659, 1, 2506.74, -3429.32, 104.121, -2.44346, 0, 0, 0.939693, -0.34202, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+7, 3659, 1, 2751.67, 687.588, 104.479, -2.37365, 0, 0, 0.927184, -0.374607, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+8, 3659, 1, 2941.95, -106.883, 96.973, -1.69297, 0, 0, 0.748956, -0.66262, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+9, 3659, 1, 3179.82, -280.294, 121.935, -1.01229, 0, 0, 0.48481, -0.87462, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+10, 3659, 1, 3268.22, -601.467, 161.684, -1.22173, 0, 0, 0.573576, -0.819152, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+11, 3659, 1, 3351.38, 990.952, 4.481, 1.44862, 0, 0, 0.66262, 0.748956, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+12, 3659, 1, 1578.86, -2511.86, 98.2333, 6.23083, 0, 0, -0.0261765, 0.999657, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+13, 3659, 1, 1733.59, -3462.76, 144.32, 6.24828, 0, 0, -0.0174522, 0.999848, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+14, 3659, 1, 1893.49, -2643.31, 83.303, 0.279252, 0, 0, 0.139173, 0.990268, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+15, 3659, 1, 2191.35, -3324.79, 121.881, 6.21337, 0, 0, -0.0348988, 0.999391, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+16, 3659, 1, 2198.34, -1431.95, 90.1891, 2.49582, 0, 0, 0.948323, 0.317306, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+17, 3659, 1, 2261.5, -3475.08, 122.688, 1.53589, 0, 0, 0.694658, 0.71934, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+18, 3659, 1, 2384.05, -1188.15, 90.7989, 4.2237, 0, 0, -0.857167, 0.515038, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+19, 3659, 1, 2392.46, -3412.58, 109.834, 4.4855, 0, 0, -0.782608, 0.622515, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+20, 3659, 1, 2409.38, -3462.7, 92.8319, 4.57276, 0, 0, -0.754709, 0.656059, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+21, 3659, 1, 2770.5, -2946.57, 143.687, 1.44862, 0, 0, 0.66262, 0.748956, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+22, 3659, 1, 2955.71, -2827.86, 212.757, 0.244346, 0, 0, 0.121869, 0.992546, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+23, 3659, 1, 3014.11, -86.2626, 99.7133, 4.57276, 0, 0, -0.754709, 0.656059, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+24, 3659, 1, 3038.85, -181.763, 104.629, 1.0472, 0, 0, 0.5, 0.866025, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+25, 3659, 1, 3103.12, 155.436, 26.1187, 0.942477, 0, 0, 0.45399, 0.891007, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+26, 3659, 1, 3164.44, -126.437, 101.086, 4.15388, 0, 0, -0.874619, 0.48481, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+27, 3659, 1, 3254.42, 128.79, 11.1681, 4.86947, 0, 0, -0.649447, 0.760406, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+28, 3659, 1, 3261.61, -347.651, 153.75, 3.4383, 0, 0, -0.989016, 0.147811, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+29, 3659, 1, 3456.91, -359.061, 134.502, 5.21854, 0, 0, -0.507538, 0.861629, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+30, 3659, 1, 3815.17, 163.152, 7.47225, 2.9496, 0, 0, 0.995396, 0.0958512, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+31, 3659, 1, 1680.01, -3430.6, 144.527, 1.58825, 0, 0, 0.71325, 0.70091, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+32, 3695, 1, 1711.78, -3438.29, 144.293, 0.820305, 0, 0, 0.398749, 0.91706, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+33, 3695, 1, 1768.68, -2032.74, 109.836, 2.32129, 0, 0, 0.91706, 0.398749, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+34, 3695, 1, 2188.77, -3203.47, 103.816, 2.30383, 0, 0, 0.913545, 0.406737, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+35, 3695, 1, 2321.68, -1433.86, 87.0652, -1.91986, 0, 0, 0.819152, -0.573576, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+36, 3695, 1, 2471.38, -2152.43, 202.284, 2.23402, 0, 0, 0.898794, 0.438371, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+37, 3695, 1, 2506.74, -3429.32, 104.121, -2.44346, 0, 0, 0.939693, -0.34202, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+38, 3695, 1, 2751.67, 687.588, 104.479, -2.37365, 0, 0, 0.927184, -0.374607, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+39, 3695, 1, 2941.95, -106.883, 96.973, -1.69297, 0, 0, 0.748956, -0.66262, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+40, 3695, 1, 3179.82, -280.294, 121.935, -1.01229, 0, 0, 0.48481, -0.87462, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+41, 3695, 1, 3268.22, -601.467, 161.684, -1.22173, 0, 0, 0.573576, -0.819152, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+42, 3695, 1, 3351.38, 990.952, 4.481, 1.44862, 0, 0, 0.66262, 0.748956, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+43, 3695, 1, 1578.86, -2511.86, 98.2333, 6.23083, 0, 0, -0.0261765, 0.999657, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+44, 3695, 1, 1733.59, -3462.76, 144.32, 6.24828, 0, 0, -0.0174522, 0.999848, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+45, 3695, 1, 1893.49, -2643.31, 83.303, 0.279252, 0, 0, 0.139173, 0.990268, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+46, 3695, 1, 2191.35, -3324.79, 121.881, 6.21337, 0, 0, -0.0348988, 0.999391, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+47, 3695, 1, 2198.34, -1431.95, 90.1891, 2.49582, 0, 0, 0.948323, 0.317306, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+48, 3695, 1, 2261.5, -3475.08, 122.688, 1.53589, 0, 0, 0.694658, 0.71934, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+49, 3695, 1, 2384.05, -1188.15, 90.7989, 4.2237, 0, 0, -0.857167, 0.515038, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+50, 3695, 1, 2392.46, -3412.58, 109.834, 4.4855, 0, 0, -0.782608, 0.622515, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+51, 3695, 1, 2409.38, -3462.7, 92.8319, 4.57276, 0, 0, -0.754709, 0.656059, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+52, 3695, 1, 2770.5, -2946.57, 143.687, 1.44862, 0, 0, 0.66262, 0.748956, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+53, 3695, 1, 2955.71, -2827.86, 212.757, 0.244346, 0, 0, 0.121869, 0.992546, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+54, 3695, 1, 3014.11, -86.2626, 99.7133, 4.57276, 0, 0, -0.754709, 0.656059, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+55, 3695, 1, 3038.85, -181.763, 104.629, 1.0472, 0, 0, 0.5, 0.866025, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+56, 3695, 1, 3103.12, 155.436, 26.1187, 0.942477, 0, 0, 0.45399, 0.891007, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+57, 3695, 1, 3164.44, -126.437, 101.086, 4.15388, 0, 0, -0.874619, 0.48481, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+58, 3695, 1, 3254.42, 128.79, 11.1681, 4.86947, 0, 0, -0.649447, 0.760406, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+59, 3695, 1, 3261.61, -347.651, 153.75, 3.4383, 0, 0, -0.989016, 0.147811, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+60, 3695, 1, 3456.91, -359.061, 134.502, 5.21854, 0, 0, -0.507538, 0.861629, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+61, 3695, 1, 3815.17, 163.152, 7.47225, 2.9496, 0, 0, 0.995396, 0.0958512, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+62, 3695, 1, 1680.01, -3430.6, 144.527, 1.58825, 0, 0, 0.71325, 0.70091, 180, 180, 100, 1, 0, 0, 0, 10);
INSERT INTO `pool_template` (`entry`, `max_limit`, `description`, `patch_min`, `patch_max`) VALUES
(@PTEMPLATE+1, 1, 'Barrel of Melon Juice / Food Crate - Ashenvale', 0, 10),
(@PTEMPLATE+2, 1, 'Barrel of Melon Juice / Food Crate - Ashenvale', 0, 10),
(@PTEMPLATE+3, 1, 'Barrel of Melon Juice / Food Crate - Ashenvale', 0, 10),
(@PTEMPLATE+4, 1, 'Barrel of Melon Juice / Food Crate - Ashenvale', 0, 10),
(@PTEMPLATE+5, 1, 'Barrel of Melon Juice / Food Crate - Ashenvale', 0, 10),
(@PTEMPLATE+6, 1, 'Barrel of Melon Juice / Food Crate - Ashenvale', 0, 10),
(@PTEMPLATE+7, 1, 'Barrel of Melon Juice / Food Crate - Ashenvale', 0, 10),
(@PTEMPLATE+8, 1, 'Barrel of Melon Juice / Food Crate - Ashenvale', 0, 10),
(@PTEMPLATE+9, 1, 'Barrel of Melon Juice / Food Crate - Ashenvale', 0, 10),
(@PTEMPLATE+10, 1, 'Barrel of Melon Juice / Food Crate - Ashenvale', 0, 10),
(@PTEMPLATE+11, 1, 'Barrel of Melon Juice / Food Crate - Ashenvale', 0, 10),
(@PTEMPLATE+12, 1, 'Barrel of Melon Juice / Food Crate - Ashenvale', 0, 10),
(@PTEMPLATE+13, 1, 'Barrel of Melon Juice / Food Crate - Ashenvale', 0, 10),
(@PTEMPLATE+14, 1, 'Barrel of Melon Juice / Food Crate - Ashenvale', 0, 10),
(@PTEMPLATE+15, 1, 'Barrel of Melon Juice / Food Crate - Ashenvale', 0, 10),
(@PTEMPLATE+16, 1, 'Barrel of Melon Juice / Food Crate - Ashenvale', 0, 10),
(@PTEMPLATE+17, 1, 'Barrel of Melon Juice / Food Crate - Ashenvale', 0, 10),
(@PTEMPLATE+18, 1, 'Barrel of Melon Juice / Food Crate - Ashenvale', 0, 10),
(@PTEMPLATE+19, 1, 'Barrel of Melon Juice / Food Crate - Ashenvale', 0, 10),
(@PTEMPLATE+20, 1, 'Barrel of Melon Juice / Food Crate - Ashenvale', 0, 10),
(@PTEMPLATE+21, 1, 'Barrel of Melon Juice / Food Crate - Ashenvale', 0, 10),
(@PTEMPLATE+22, 1, 'Barrel of Melon Juice / Food Crate - Ashenvale', 0, 10),
(@PTEMPLATE+23, 1, 'Barrel of Melon Juice / Food Crate - Ashenvale', 0, 10),
(@PTEMPLATE+24, 1, 'Barrel of Melon Juice / Food Crate - Ashenvale', 0, 10),
(@PTEMPLATE+25, 1, 'Barrel of Melon Juice / Food Crate - Ashenvale', 0, 10),
(@PTEMPLATE+26, 1, 'Barrel of Melon Juice / Food Crate - Ashenvale', 0, 10),
(@PTEMPLATE+27, 1, 'Barrel of Melon Juice / Food Crate - Ashenvale', 0, 10),
(@PTEMPLATE+28, 1, 'Barrel of Melon Juice / Food Crate - Ashenvale', 0, 10),
(@PTEMPLATE+29, 1, 'Barrel of Melon Juice / Food Crate - Ashenvale', 0, 10),
(@PTEMPLATE+30, 1, 'Barrel of Melon Juice / Food Crate - Ashenvale', 0, 10),
(@PTEMPLATE+31, 1, 'Barrel of Melon Juice / Food Crate - Ashenvale', 0, 10);
INSERT INTO `pool_gameobject` (`guid`, `pool_entry`, `description`, `patch_min`, `patch_max`) VALUES
(@OGUID+1, @PTEMPLATE+1, 'Barrel of Melon Juice / Food Crate - Ashenvale', 0, 10),
(@OGUID+2, @PTEMPLATE+2, 'Barrel of Melon Juice / Food Crate - Ashenvale', 0, 10),
(@OGUID+3, @PTEMPLATE+3, 'Barrel of Melon Juice / Food Crate - Ashenvale', 0, 10),
(@OGUID+4, @PTEMPLATE+4, 'Barrel of Melon Juice / Food Crate - Ashenvale', 0, 10),
(@OGUID+5, @PTEMPLATE+5, 'Barrel of Melon Juice / Food Crate - Ashenvale', 0, 10),
(@OGUID+6, @PTEMPLATE+6, 'Barrel of Melon Juice / Food Crate - Ashenvale', 0, 10),
(@OGUID+7, @PTEMPLATE+7, 'Barrel of Melon Juice / Food Crate - Ashenvale', 0, 10),
(@OGUID+8, @PTEMPLATE+8, 'Barrel of Melon Juice / Food Crate - Ashenvale', 0, 10),
(@OGUID+9, @PTEMPLATE+9, 'Barrel of Melon Juice / Food Crate - Ashenvale', 0, 10),
(@OGUID+10, @PTEMPLATE+10, 'Barrel of Melon Juice / Food Crate - Ashenvale', 0, 10),
(@OGUID+11, @PTEMPLATE+11, 'Barrel of Melon Juice / Food Crate - Ashenvale', 0, 10),
(@OGUID+12, @PTEMPLATE+12, 'Barrel of Melon Juice / Food Crate - Ashenvale', 0, 10),
(@OGUID+13, @PTEMPLATE+13, 'Barrel of Melon Juice / Food Crate - Ashenvale', 0, 10),
(@OGUID+14, @PTEMPLATE+14, 'Barrel of Melon Juice / Food Crate - Ashenvale', 0, 10),
(@OGUID+15, @PTEMPLATE+15, 'Barrel of Melon Juice / Food Crate - Ashenvale', 0, 10),
(@OGUID+16, @PTEMPLATE+16, 'Barrel of Melon Juice / Food Crate - Ashenvale', 0, 10),
(@OGUID+17, @PTEMPLATE+17, 'Barrel of Melon Juice / Food Crate - Ashenvale', 0, 10),
(@OGUID+18, @PTEMPLATE+18, 'Barrel of Melon Juice / Food Crate - Ashenvale', 0, 10),
(@OGUID+19, @PTEMPLATE+19, 'Barrel of Melon Juice / Food Crate - Ashenvale', 0, 10),
(@OGUID+20, @PTEMPLATE+20, 'Barrel of Melon Juice / Food Crate - Ashenvale', 0, 10),
(@OGUID+21, @PTEMPLATE+21, 'Barrel of Melon Juice / Food Crate - Ashenvale', 0, 10),
(@OGUID+22, @PTEMPLATE+22, 'Barrel of Melon Juice / Food Crate - Ashenvale', 0, 10),
(@OGUID+23, @PTEMPLATE+23, 'Barrel of Melon Juice / Food Crate - Ashenvale', 0, 10),
(@OGUID+24, @PTEMPLATE+24, 'Barrel of Melon Juice / Food Crate - Ashenvale', 0, 10),
(@OGUID+25, @PTEMPLATE+25, 'Barrel of Melon Juice / Food Crate - Ashenvale', 0, 10),
(@OGUID+26, @PTEMPLATE+26, 'Barrel of Melon Juice / Food Crate - Ashenvale', 0, 10),
(@OGUID+27, @PTEMPLATE+27, 'Barrel of Melon Juice / Food Crate - Ashenvale', 0, 10),
(@OGUID+28, @PTEMPLATE+28, 'Barrel of Melon Juice / Food Crate - Ashenvale', 0, 10),
(@OGUID+29, @PTEMPLATE+29, 'Barrel of Melon Juice / Food Crate - Ashenvale', 0, 10),
(@OGUID+30, @PTEMPLATE+30, 'Barrel of Melon Juice / Food Crate - Ashenvale', 0, 10),
(@OGUID+31, @PTEMPLATE+31, 'Barrel of Melon Juice / Food Crate - Ashenvale', 0, 10),
(@OGUID+32, @PTEMPLATE+1, 'Barrel of Melon Juice / Food Crate - Ashenvale', 0, 10),
(@OGUID+33, @PTEMPLATE+2, 'Barrel of Melon Juice / Food Crate - Ashenvale', 0, 10),
(@OGUID+34, @PTEMPLATE+3, 'Barrel of Melon Juice / Food Crate - Ashenvale', 0, 10),
(@OGUID+35, @PTEMPLATE+4, 'Barrel of Melon Juice / Food Crate - Ashenvale', 0, 10),
(@OGUID+36, @PTEMPLATE+5, 'Barrel of Melon Juice / Food Crate - Ashenvale', 0, 10),
(@OGUID+37, @PTEMPLATE+6, 'Barrel of Melon Juice / Food Crate - Ashenvale', 0, 10),
(@OGUID+38, @PTEMPLATE+7, 'Barrel of Melon Juice / Food Crate - Ashenvale', 0, 10),
(@OGUID+39, @PTEMPLATE+8, 'Barrel of Melon Juice / Food Crate - Ashenvale', 0, 10),
(@OGUID+40, @PTEMPLATE+9, 'Barrel of Melon Juice / Food Crate - Ashenvale', 0, 10),
(@OGUID+41, @PTEMPLATE+10, 'Barrel of Melon Juice / Food Crate - Ashenvale', 0, 10),
(@OGUID+42, @PTEMPLATE+11, 'Barrel of Melon Juice / Food Crate - Ashenvale', 0, 10),
(@OGUID+43, @PTEMPLATE+12, 'Barrel of Melon Juice / Food Crate - Ashenvale', 0, 10),
(@OGUID+44, @PTEMPLATE+13, 'Barrel of Melon Juice / Food Crate - Ashenvale', 0, 10),
(@OGUID+45, @PTEMPLATE+14, 'Barrel of Melon Juice / Food Crate - Ashenvale', 0, 10),
(@OGUID+46, @PTEMPLATE+15, 'Barrel of Melon Juice / Food Crate - Ashenvale', 0, 10),
(@OGUID+47, @PTEMPLATE+16, 'Barrel of Melon Juice / Food Crate - Ashenvale', 0, 10),
(@OGUID+48, @PTEMPLATE+17, 'Barrel of Melon Juice / Food Crate - Ashenvale', 0, 10),
(@OGUID+49, @PTEMPLATE+18, 'Barrel of Melon Juice / Food Crate - Ashenvale', 0, 10),
(@OGUID+50, @PTEMPLATE+19, 'Barrel of Melon Juice / Food Crate - Ashenvale', 0, 10),
(@OGUID+51, @PTEMPLATE+20, 'Barrel of Melon Juice / Food Crate - Ashenvale', 0, 10),
(@OGUID+52, @PTEMPLATE+21, 'Barrel of Melon Juice / Food Crate - Ashenvale', 0, 10),
(@OGUID+53, @PTEMPLATE+22, 'Barrel of Melon Juice / Food Crate - Ashenvale', 0, 10),
(@OGUID+54, @PTEMPLATE+23, 'Barrel of Melon Juice / Food Crate - Ashenvale', 0, 10),
(@OGUID+55, @PTEMPLATE+24, 'Barrel of Melon Juice / Food Crate - Ashenvale', 0, 10),
(@OGUID+56, @PTEMPLATE+25, 'Barrel of Melon Juice / Food Crate - Ashenvale', 0, 10),
(@OGUID+57, @PTEMPLATE+26, 'Barrel of Melon Juice / Food Crate - Ashenvale', 0, 10),
(@OGUID+58, @PTEMPLATE+27, 'Barrel of Melon Juice / Food Crate - Ashenvale', 0, 10),
(@OGUID+59, @PTEMPLATE+28, 'Barrel of Melon Juice / Food Crate - Ashenvale', 0, 10),
(@OGUID+60, @PTEMPLATE+29, 'Barrel of Melon Juice / Food Crate - Ashenvale', 0, 10),
(@OGUID+61, @PTEMPLATE+30, 'Barrel of Melon Juice / Food Crate - Ashenvale', 0, 10),
(@OGUID+62, @PTEMPLATE+31, 'Barrel of Melon Juice / Food Crate - Ashenvale', 0, 10);
INSERT INTO `pool_template` (`entry`, `max_limit`, `description`, `flags`, `instance`, `patch_min`, `patch_max`) VALUES
(@PTEMPLATE+32, 14, 'Ashenvale - Barrel of Melon Juice / Food Crate (Master Pool)', 0, 0, 0, 10);
INSERT INTO `pool_pool` (`pool_id`, `mother_pool`, `chance`, `description`, `flags`) VALUES
(@PTEMPLATE+1, @PTEMPLATE+32, 0, 'Barrel of Melon Juice / Food Crate - Ashenvale', 0),
(@PTEMPLATE+2, @PTEMPLATE+32, 0, 'Barrel of Melon Juice / Food Crate - Ashenvale', 0),
(@PTEMPLATE+3, @PTEMPLATE+32, 0, 'Barrel of Melon Juice / Food Crate - Ashenvale', 0),
(@PTEMPLATE+4, @PTEMPLATE+32, 0, 'Barrel of Melon Juice / Food Crate - Ashenvale', 0),
(@PTEMPLATE+5, @PTEMPLATE+32, 0, 'Barrel of Melon Juice / Food Crate - Ashenvale', 0),
(@PTEMPLATE+6, @PTEMPLATE+32, 0, 'Barrel of Melon Juice / Food Crate - Ashenvale', 0),
(@PTEMPLATE+7, @PTEMPLATE+32, 0, 'Barrel of Melon Juice / Food Crate - Ashenvale', 0),
(@PTEMPLATE+8, @PTEMPLATE+32, 0, 'Barrel of Melon Juice / Food Crate - Ashenvale', 0),
(@PTEMPLATE+9, @PTEMPLATE+32, 0, 'Barrel of Melon Juice / Food Crate - Ashenvale', 0),
(@PTEMPLATE+10, @PTEMPLATE+32, 0, 'Barrel of Melon Juice / Food Crate - Ashenvale', 0),
(@PTEMPLATE+11, @PTEMPLATE+32, 0, 'Barrel of Melon Juice / Food Crate - Ashenvale', 0),
(@PTEMPLATE+12, @PTEMPLATE+32, 0, 'Barrel of Melon Juice / Food Crate - Ashenvale', 0),
(@PTEMPLATE+13, @PTEMPLATE+32, 0, 'Barrel of Melon Juice / Food Crate - Ashenvale', 0),
(@PTEMPLATE+14, @PTEMPLATE+32, 0, 'Barrel of Melon Juice / Food Crate - Ashenvale', 0),
(@PTEMPLATE+15, @PTEMPLATE+32, 0, 'Barrel of Melon Juice / Food Crate - Ashenvale', 0),
(@PTEMPLATE+16, @PTEMPLATE+32, 0, 'Barrel of Melon Juice / Food Crate - Ashenvale', 0),
(@PTEMPLATE+17, @PTEMPLATE+32, 0, 'Barrel of Melon Juice / Food Crate - Ashenvale', 0),
(@PTEMPLATE+18, @PTEMPLATE+32, 0, 'Barrel of Melon Juice / Food Crate - Ashenvale', 0),
(@PTEMPLATE+19, @PTEMPLATE+32, 0, 'Barrel of Melon Juice / Food Crate - Ashenvale', 0),
(@PTEMPLATE+20, @PTEMPLATE+32, 0, 'Barrel of Melon Juice / Food Crate - Ashenvale', 0),
(@PTEMPLATE+21, @PTEMPLATE+32, 0, 'Barrel of Melon Juice / Food Crate - Ashenvale', 0),
(@PTEMPLATE+22, @PTEMPLATE+32, 0, 'Barrel of Melon Juice / Food Crate - Ashenvale', 0),
(@PTEMPLATE+23, @PTEMPLATE+32, 0, 'Barrel of Melon Juice / Food Crate - Ashenvale', 0),
(@PTEMPLATE+24, @PTEMPLATE+32, 0, 'Barrel of Melon Juice / Food Crate - Ashenvale', 0),
(@PTEMPLATE+25, @PTEMPLATE+32, 0, 'Barrel of Melon Juice / Food Crate - Ashenvale', 0),
(@PTEMPLATE+26, @PTEMPLATE+32, 0, 'Barrel of Melon Juice / Food Crate - Ashenvale', 0),
(@PTEMPLATE+27, @PTEMPLATE+32, 0, 'Barrel of Melon Juice / Food Crate - Ashenvale', 0),
(@PTEMPLATE+28, @PTEMPLATE+32, 0, 'Barrel of Melon Juice / Food Crate - Ashenvale', 0),
(@PTEMPLATE+29, @PTEMPLATE+32, 0, 'Barrel of Melon Juice / Food Crate - Ashenvale', 0),
(@PTEMPLATE+30, @PTEMPLATE+32, 0, 'Barrel of Melon Juice / Food Crate - Ashenvale', 0),
(@PTEMPLATE+31, @PTEMPLATE+32, 0, 'Barrel of Melon Juice / Food Crate - Ashenvale', 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