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


-- Add ability to specify subpath inside waypoints.
ALTER TABLE `creature_movement`
	ADD COLUMN `path_id` INT UNSIGNED NOT NULL DEFAULT '0' AFTER `script_id`;
ALTER TABLE `creature_movement_special`
	ADD COLUMN `path_id` INT UNSIGNED NOT NULL DEFAULT '0' AFTER `script_id`;
ALTER TABLE `creature_movement_template`
	ADD COLUMN `path_id` INT UNSIGNED NOT NULL DEFAULT '0' AFTER `script_id`;

-- Correct waypoints for Pridewing Soarer.
UPDATE `creature` SET `movement_type`=2 WHERE `guid`=32374;
DELETE FROM `creature_movement` WHERE `id`=32374;
INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `waittime`, `wander_distance`, `script_id`, `path_id`) VALUES (32374, 1, 1274.96, 998.782, 261.414, 100, 30000, 3, 0, 3237401);
INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `waittime`, `wander_distance`, `script_id`, `path_id`) VALUES (32374, 2, 1395.66, 1133.55, 253.876, 100, 30000, 3, 0, 3237402);
INSERT INTO `creature_movement_special` (`id`, `point`, `position_x`, `position_y`, `position_z`) VALUES 
(3237401, 1, 1387.64, 1133.09, 248.428),
(3237401, 2, 1396.62, 1132.77, 252.803),
(3237401, 3, 1400.68, 1132.62, 254.776),
(3237401, 4, 1406.69, 1127.44, 258.387),
(3237401, 5, 1409.68, 1123.71, 255.582),
(3237401, 6, 1414.02, 1121.01, 249.165),
(3237401, 7, 1416.11, 1117.24, 236.443),
(3237401, 8, 1421.44, 1112.35, 215.387),
(3237401, 9, 1425.69, 1107.29, 201.693),
(3237401, 10, 1438.73, 1084.49, 187.471),
(3237401, 11, 1446.57, 1071.35, 180.943),
(3237401, 12, 1452.5, 1049.66, 175.776),
(3237401, 13, 1436.59, 1029.14, 176.471),
(3237401, 14, 1424.26, 1014.05, 176.471),
(3237401, 15, 1410.04, 1001.95, 170.137),
(3237401, 16, 1398.42, 994.845, 170.61),
(3237401, 17, 1394.7, 975.518, 170.971),
(3237401, 18, 1379.78, 954.346, 175.971),
(3237401, 19, 1368.1, 928.627, 179.026),
(3237401, 20, 1358.26, 916.91, 181.943),
(3237401, 21, 1348.86, 897.846, 188.415),
(3237401, 22, 1336.86, 887.012, 195.498),
(3237401, 23, 1313.8, 880.434, 202.418),
(3237401, 24, 1296.83, 883.685, 221.386),
(3237401, 25, 1285.43, 889.878, 232.88),
(3237401, 26, 1273.14, 900.961, 244.577),
(3237401, 27, 1262.02, 910.496, 262.151),
(3237401, 28, 1252.22, 920.432, 276.769),
(3237401, 29, 1246.96, 925.998, 286.275),
(3237401, 30, 1243.22, 931.168, 290.864),
(3237401, 31, 1236.76, 942.648, 297.08),
(3237401, 32, 1236.67, 950.701, 295.497),
(3237401, 33, 1243.75, 966.164, 284.997),
(3237401, 34, 1250.26, 975.396, 280.359),
(3237401, 35, 1253.98, 980.958, 272.831),
(3237401, 36, 1260.66, 984.847, 270.386),
(3237401, 37, 1267.97, 992.074, 261.108),
(3237401, 38, 1274.96, 998.782, 261.414),
(3237401, 39, 1274.96, 998.782, 261.414);
INSERT INTO `creature_movement_special` (`id`, `point`, `position_x`, `position_y`, `position_z`) VALUES 
(3237402, 1, 1271.17, 995.105, 250.358),
(3237402, 2, 1274.09, 998.519, 259.289),
(3237402, 3, 1275.1, 999.694, 262.364),
(3237402, 4, 1281.85, 999.434, 262.975),
(3237402, 5, 1288.66, 1000.07, 255.17),
(3237402, 6, 1313.98, 1000.74, 212.531),
(3237402, 7, 1330.31, 1003.52, 197.698),
(3237402, 8, 1337.21, 1012.44, 189.42),
(3237402, 9, 1343.12, 1024.66, 187.337),
(3237402, 10, 1354.53, 1039.49, 184.864),
(3237402, 11, 1367.97, 1048.17, 184.781),
(3237402, 12, 1379.21, 1059.91, 182.337),
(3237402, 13, 1403, 1075.96, 183.503),
(3237402, 14, 1432.6, 1088.25, 177.642),
(3237402, 15, 1454.16, 1062.88, 178.476),
(3237402, 16, 1446.95, 1040.85, 176.281),
(3237402, 17, 1436.27, 1026.84, 176.337),
(3237402, 18, 1421.5, 1006.3, 171.753),
(3237402, 19, 1397.21, 994.459, 171.67),
(3237402, 20, 1372.54, 995.34, 175.059),
(3237402, 21, 1356.78, 1008.53, 176.42),
(3237402, 22, 1354.12, 1026.88, 178.503),
(3237402, 23, 1356.12, 1059.95, 194.836),
(3237402, 24, 1356.27, 1082.76, 206.836),
(3237402, 25, 1356.05, 1093.33, 211.781),
(3237402, 26, 1360.27, 1104.55, 215.923),
(3237402, 27, 1368.5, 1116.55, 220.34),
(3237402, 28, 1379.23, 1124.18, 244.757),
(3237402, 29, 1385.14, 1128.52, 254.068),
(3237402, 30, 1391.94, 1132.41, 256.561),
(3237402, 31, 1395.66, 1133.55, 253.876),
(3237402, 32, 1395.66, 1133.55, 253.876);

-- Correct waypoints for Pridewing Soarer.
UPDATE `creature` SET `movement_type`=2 WHERE `guid`=32376;
DELETE FROM `creature_movement` WHERE `id`=32376;
INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `waittime`, `wander_distance`, `path_id`) VALUES (32376, 1, 1588.57, 872.573, 184.32, 100, 30000, 3, 3237601);
INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `waittime`, `wander_distance`, `path_id`) VALUES (32376, 2, 1767.44, 1039.39, 228.905, 100, 30000, 3, 3237602);
INSERT INTO `creature_movement_special` (`id`, `point`, `position_x`, `position_y`, `position_z`) VALUES 
(3237601, 1, 1765.87, 1040.09, 217.624),
(3237601, 2, 1766.04, 1037.96, 227.392),
(3237601, 3, 1766.09, 1037.38, 230.042),
(3237601, 4, 1759.48, 1034.44, 234.07),
(3237601, 5, 1754.04, 1031.02, 229.237),
(3237601, 6, 1747.28, 1027.67, 218.681),
(3237601, 7, 1731.85, 1020.52, 187.987),
(3237601, 8, 1725.09, 998.122, 168.681),
(3237601, 9, 1705.45, 985.035, 151.848),
(3237601, 10, 1682.25, 982.822, 151.848),
(3237601, 11, 1662.47, 979.501, 151.848),
(3237601, 12, 1644.07, 977.984, 151.848),
(3237601, 13, 1624.68, 967.497, 151.848),
(3237601, 14, 1598.07, 947.549, 151.848),
(3237601, 15, 1580.34, 934.014, 151.848),
(3237601, 16, 1560.31, 921.705, 153.765),
(3237601, 17, 1545.36, 908.896, 151.848),
(3237601, 18, 1537.41, 891.779, 147.932),
(3237601, 19, 1533.62, 872.735, 151.848),
(3237601, 20, 1542.36, 852.207, 151.848),
(3237601, 21, 1562.16, 836.722, 154.931),
(3237601, 22, 1583.79, 825.638, 151.848),
(3237601, 23, 1603.56, 821.713, 155.459),
(3237601, 24, 1627.16, 827.142, 151.848),
(3237601, 25, 1647.43, 839.484, 154.376),
(3237601, 26, 1659.28, 856.68, 151.848),
(3237601, 27, 1658.28, 878.404, 151.848),
(3237601, 28, 1651.84, 895.148, 151.848),
(3237601, 29, 1641.19, 911.85, 151.848),
(3237601, 30, 1623.35, 918.965, 151.848),
(3237601, 31, 1597.23, 916.092, 157.598),
(3237601, 32, 1585.17, 898.823, 169.042),
(3237601, 33, 1584.06, 879.774, 187.403),
(3237601, 34, 1588.57, 872.573, 184.32),
(3237601, 35, 1588.57, 872.573, 184.32);
INSERT INTO `creature_movement_special` (`id`, `point`, `position_x`, `position_y`, `position_z`) VALUES 
(3237602, 1, 1577.96, 877.011, 180.776),
(3237602, 2, 1587.21, 873.962, 183.062),
(3237602, 3, 1591.53, 872.536, 184.131),
(3237602, 4, 1600.41, 868.411, 182.298),
(3237602, 5, 1609.13, 869.052, 177.603),
(3237602, 6, 1630.69, 862.247, 158.826),
(3237602, 7, 1667.96, 859.623, 160.159),
(3237602, 8, 1701.84, 848.873, 155.576),
(3237602, 9, 1744.76, 848.956, 161.103),
(3237602, 10, 1778.24, 855.889, 164.964),
(3237602, 11, 1768.1, 883.739, 164.77),
(3237602, 12, 1782.73, 906.242, 178.992),
(3237602, 13, 1798.13, 914.202, 174.714),
(3237602, 14, 1811.73, 931.175, 173.048),
(3237602, 15, 1819.88, 952.545, 171.103),
(3237602, 16, 1817.88, 980.602, 168.27),
(3237602, 17, 1815.68, 1006.06, 170.103),
(3237602, 18, 1814.61, 1026.83, 186.103),
(3237602, 19, 1800.21, 1036.99, 204.798),
(3237602, 20, 1790.95, 1039.24, 221.275),
(3237602, 21, 1783.2, 1038.36, 229.046),
(3237602, 22, 1773.79, 1039.23, 230.44),
(3237602, 23, 1767.44, 1039.39, 228.905),
(3237602, 24, 1767.44, 1039.39, 228.905);

-- This is the same spawn as 32376.
DELETE FROM `creature` WHERE `guid`=32375;
DELETE FROM `creature_movement` WHERE `id`=32375;

-- Blackrock Drake drake should use cyclic movement.
UPDATE `creature` SET `movement_type`=3 WHERE `guid`=3344;

-- Add missing Soaring Razorbeak.
INSERT INTO `creature` (`guid`, `id`, `id2`, `id3`, `id4`, `id5`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecsmin`, `spawntimesecsmax`, `wander_distance`, `health_percent`, `mana_percent`, `movement_type`, `spawn_flags`, `visibility_mod`, `patch_min`, `patch_max`) VALUES (92913, 8276, 0, 0, 0, 0, 0, 406.208, -3035.6, 168.384, 4.9824, 350, 350, 0, 100, 0, 3, 0, 0, 0, 10);
INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`) VALUES 
(92913, 1, 406.208, -3035.6, 168.384),
(92913, 2, 407.741, -3026.06, 170.978),
(92913, 3, 408.382, -3022.08, 172.061),
(92913, 4, 408.764, -3001.82, 180.172),
(92913, 5, 390.414, -2980.69, 186.311),
(92913, 6, 360.406, -2967.07, 181.061),
(92913, 7, 333.604, -2964.41, 169.95),
(92913, 8, 312.323, -2950.05, 169.95),
(92913, 9, 292.41, -2925.48, 169.95),
(92913, 10, 262.347, -2894.73, 169.95),
(92913, 11, 232.491, -2859.15, 169.95),
(92913, 12, 209.593, -2823.02, 169.95),
(92913, 13, 183.598, -2800.43, 169.95),
(92913, 14, 167.489, -2779.08, 169.95),
(92913, 15, 141.492, -2772.1, 169.95),
(92913, 16, 105.78, -2778.33, 169.95),
(92913, 17, 89.8152, -2776.24, 169.95),
(92913, 18, 64.9773, -2790.8, 169.95),
(92913, 19, 50.3032, -2804.86, 169.95),
(92913, 20, 41.9684, -2823.31, 169.95),
(92913, 21, 46.2215, -2853.43, 172.255),
(92913, 22, 33.4274, -2886.25, 169.95),
(92913, 23, 3.64811, -2911.17, 169.95),
(92913, 24, -38.4928, -2938.7, 169.95),
(92913, 25, -49.6163, -2971.41, 169.95),
(92913, 26, -53.8288, -3017.34, 169.95),
(92913, 27, -38.2822, -3042.15, 169.95),
(92913, 28, -13.7435, -3070.38, 169.95),
(92913, 29, 19.4945, -3085.11, 169.95),
(92913, 30, 55.17, -3105.96, 169.95),
(92913, 31, 91.0723, -3112.04, 169.95),
(92913, 32, 121.827, -3113.41, 169.95),
(92913, 33, 144.154, -3128.86, 169.95),
(92913, 34, 172.052, -3135.79, 169.95),
(92913, 35, 198.632, -3119.66, 169.95),
(92913, 36, 214.294, -3097.13, 169.95),
(92913, 37, 215.762, -3067.86, 169.95),
(92913, 38, 213.489, -3032.99, 169.95),
(92913, 39, 191.565, -2997.42, 169.95),
(92913, 40, 157.876, -2987.23, 169.95),
(92913, 41, 143.048, -2974.78, 169.95),
(92913, 42, 143.945, -2951.89, 169.7),
(92913, 43, 161.382, -2943.69, 169.95),
(92913, 44, 181.436, -2949.3, 169.95),
(92913, 45, 199.697, -2960.48, 169.95),
(92913, 46, 211.579, -2973.65, 169.95),
(92913, 47, 234.624, -2994.18, 169.95),
(92913, 48, 234.424, -3036.44, 169.95),
(92913, 49, 254.7, -3059.21, 169.95),
(92913, 50, 286.733, -3084.27, 169.95),
(92913, 51, 308.465, -3084.5, 169.95),
(92913, 52, 341.858, -3070.79, 169.95),
(92913, 53, 368.416, -3064.39, 169.95),
(92913, 54, 391.328, -3055.33, 171.311),
(92913, 55, 404.253, -3043.25, 171.478),
(92913, 56, 407.741, -3026.06, 170.978),
(92913, 57, 407.741, -3026.06, 170.978);

-- Add missing Brood of Nozdormu.
INSERT INTO `creature` (`guid`, `id`, `id2`, `id3`, `id4`, `id5`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecsmin`, `spawntimesecsmax`, `wander_distance`, `health_percent`, `mana_percent`, `movement_type`, `spawn_flags`, `visibility_mod`, `patch_min`, `patch_max`) VALUES (42903, 15185, 0, 0, 0, 0, 1, -8100.03, 1834.71, 128.845, 0.522566, 600, 600, 0, 100, 100, 3, 0, 0, 6, 10);
INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`) VALUES 
(42903, 1, -8100.03, 1834.71, 128.845),
(42903, 2, -8099.8, 1826, 123.925),
(42903, 3, -8099.74, 1823.73, 122.641),
(42903, 4, -8099.92, 1801.21, 120.668),
(42903, 5, -8099.98, 1769.6, 108.002),
(42903, 6, -8099.46, 1719.34, 108.002),
(42903, 7, -8099.24, 1691, 107.168),
(42903, 8, -8099.05, 1666.93, 101.641),
(42903, 9, -8099.48, 1635.89, 108.002),
(42903, 10, -8088.04, 1604.1, 108.002),
(42903, 11, -8067.24, 1586.31, 108.002),
(42903, 12, -8061.24, 1557.51, 108.002),
(42903, 13, -8083.52, 1536.59, 108.002),
(42903, 14, -8099.11, 1503.03, 108.002),
(42903, 15, -8100.23, 1478.06, 108.002),
(42903, 16, -8095.02, 1460.6, 108.002),
(42903, 17, -8079.55, 1447.47, 108.002),
(42903, 18, -8057.83, 1431.13, 108.002),
(42903, 19, -8039.18, 1411.03, 108.002),
(42903, 20, -8033.14, 1379.13, 108.002),
(42903, 21, -8008.06, 1359.89, 108.002),
(42903, 22, -8014.91, 1333.99, 108.002),
(42903, 23, -8027.03, 1296.12, 108.002),
(42903, 24, -7999.15, 1267.96, 108.002),
(42903, 25, -7972.29, 1256.33, 108.002),
(42903, 26, -7960.03, 1274.41, 108.002),
(42903, 27, -7954.57, 1288.29, 108.002),
(42903, 28, -7957.11, 1309.45, 108.002),
(42903, 29, -7964.04, 1334.08, 108.002),
(42903, 30, -7967.83, 1356.21, 108.002),
(42903, 31, -7979.55, 1375, 108.002),
(42903, 32, -7994.98, 1384.57, 108.002),
(42903, 33, -8014.83, 1389.91, 108.002),
(42903, 34, -8053.32, 1379.91, 108.002),
(42903, 35, -8068.52, 1399.2, 108.002),
(42903, 36, -8079.5, 1424.43, 108.002),
(42903, 37, -8082.93, 1452.81, 108.002),
(42903, 38, -8086.57, 1486.08, 108.002),
(42903, 39, -8075.36, 1512.26, 108.002),
(42903, 40, -8065.1, 1532.65, 108.002),
(42903, 41, -8051.26, 1562.5, 108.002),
(42903, 42, -8045.08, 1601.08, 108.002),
(42903, 43, -8049.93, 1635.22, 108.002),
(42903, 44, -8055.19, 1678.51, 108.002),
(42903, 45, -8054.07, 1710.28, 108.002),
(42903, 46, -8063.63, 1754.54, 108.002),
(42903, 47, -8082.12, 1764.45, 108.002),
(42903, 48, -8086.07, 1782.36, 112.113),
(42903, 49, -8088.21, 1801.82, 119.057),
(42903, 50, -8092.13, 1817.43, 117.641),
(42903, 51, -8092.89, 1833.92, 122.168),
(42903, 52, -8107.47, 1871.69, 128.446),
(42903, 53, -8114.38, 1856.47, 122.363),
(42903, 54, -8099.8, 1826, 123.925),
(42903, 55, -8099.8, 1826, 123.925);

-- Add missing Brood of Nozdormu.
INSERT INTO `creature` (`guid`, `id`, `id2`, `id3`, `id4`, `id5`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecsmin`, `spawntimesecsmax`, `wander_distance`, `health_percent`, `mana_percent`, `movement_type`, `spawn_flags`, `visibility_mod`, `patch_min`, `patch_max`) VALUES (42920, 15185, 0, 0, 0, 0, 1, -7667.3, 2041.83, 192.263, 0.522566, 600, 600, 0, 100, 100, 3, 0, 0, 6, 10);
INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`) VALUES 
(42920, 1, -7667.3, 2041.83, 192.263),
(42920, 2, -7674.82, 2035.26, 191.629),
(42920, 3, -7679.21, 2031.43, 191.26),
(42920, 4, -7690.24, 2020.24, 191.26),
(42920, 5, -7717.44, 1985.56, 191.26),
(42920, 6, -7724.16, 1975.75, 191.26),
(42920, 7, -7740.5, 1956.56, 191.26),
(42920, 8, -7747.92, 1944.78, 191.26),
(42920, 9, -7758.78, 1931.23, 191.26),
(42920, 10, -7784.46, 1911.18, 191.26),
(42920, 11, -7809.51, 1896.79, 191.26),
(42920, 12, -7837.97, 1888.7, 191.26),
(42920, 13, -7855.2, 1885.57, 191.26),
(42920, 14, -7871.06, 1868.77, 191.26),
(42920, 15, -7876.91, 1847.75, 191.26),
(42920, 16, -7880.95, 1818.83, 191.26),
(42920, 17, -7890.37, 1791.6, 191.26),
(42920, 18, -7920.55, 1759.56, 191.26),
(42920, 19, -7933.46, 1725, 191.26),
(42920, 20, -7949.3, 1706.04, 191.26),
(42920, 21, -7955, 1683.4, 191.26),
(42920, 22, -7971.42, 1667.72, 191.26),
(42920, 23, -7990.93, 1635.73, 191.26),
(42920, 24, -7997.99, 1606.83, 191.26),
(42920, 25, -8010.63, 1581.05, 191.26),
(42920, 26, -8033.25, 1573.85, 191.26),
(42920, 27, -8060.14, 1569.48, 191.26),
(42920, 28, -8092.81, 1564.88, 191.26),
(42920, 29, -8096.4, 1541.73, 191.26),
(42920, 30, -8092.07, 1521.85, 191.26),
(42920, 31, -8072.09, 1500.61, 191.26),
(42920, 32, -8072.61, 1478.55, 191.26),
(42920, 33, -8041.02, 1462.95, 191.26),
(42920, 34, -8013.81, 1448.77, 191.26),
(42920, 35, -7996.25, 1426.33, 191.26),
(42920, 36, -7968.74, 1390.65, 191.26),
(42920, 37, -7927.57, 1397.45, 191.26),
(42920, 38, -7912.8, 1412.86, 191.26),
(42920, 39, -7899.07, 1427.05, 191.26),
(42920, 40, -7899.71, 1450.88, 191.26),
(42920, 41, -7914.69, 1490.06, 191.26),
(42920, 42, -7924.58, 1501.21, 191.26),
(42920, 43, -7936.9, 1514.69, 191.26),
(42920, 44, -7953.49, 1528.96, 191.26),
(42920, 45, -7968.81, 1536.15, 191.26),
(42920, 46, -7985.88, 1544.26, 191.26),
(42920, 47, -8017.87, 1557.94, 191.26),
(42920, 48, -8049.92, 1564.56, 191.26),
(42920, 49, -8072.12, 1578.81, 191.26),
(42920, 50, -8080.22, 1600.49, 191.26),
(42920, 51, -8076.47, 1618.49, 191.26),
(42920, 52, -8067.91, 1640.46, 191.26),
(42920, 53, -8051.11, 1654.4, 191.26),
(42920, 54, -8023.06, 1666.22, 191.26),
(42920, 55, -7998.85, 1670.47, 191.26),
(42920, 56, -7977.98, 1675.11, 191.26),
(42920, 57, -7960.27, 1689.31, 191.26),
(42920, 58, -7949.88, 1713.04, 191.26),
(42920, 59, -7932.66, 1730.64, 191.26),
(42920, 60, -7908.3, 1772.9, 191.26),
(42920, 61, -7907.11, 1787.82, 191.26),
(42920, 62, -7884.36, 1806.3, 191.26),
(42920, 63, -7845.26, 1813.97, 191.26),
(42920, 64, -7808.99, 1831.99, 191.26),
(42920, 65, -7786.75, 1846.68, 191.26),
(42920, 66, -7767.55, 1863.79, 191.26),
(42920, 67, -7746.6, 1878.44, 191.26),
(42920, 68, -7732.98, 1890.91, 191.26),
(42920, 69, -7720.87, 1907.01, 191.26),
(42920, 70, -7702.14, 1927.73, 191.26),
(42920, 71, -7689.2, 1933.11, 191.26),
(42920, 72, -7677.33, 1942.47, 191.26),
(42920, 73, -7657.08, 1966.32, 191.26),
(42920, 74, -7634.61, 1999.73, 191.26),
(42920, 75, -7637.86, 2018.34, 191.26),
(42920, 76, -7626.9, 2058.21, 191.26),
(42920, 77, -7639.52, 2070.94, 191.26),
(42920, 78, -7674.82, 2035.26, 191.629),
(42920, 79, -7674.82, 2035.26, 191.629);

-- Remove wander distance from this Brood of Nozdormu spawn.
UPDATE `creature` SET `wander_distance`=0 WHERE `guid`=42902;


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