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


UPDATE `creature` SET `position_x` = -6776.9443, `position_y` = -2912.7114, `position_z` = 241.57184, `orientation` = 5.8294, `movement_type` = 2, `wander_distance` = 0 WHERE `guid`= 7704;
DELETE FROM `creature_movement` WHERE `id` = 7704;
SET @POINT := 0;
INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`) VALUES
(7704, (@POINT := @POINT + 1), -6776.9443, -2912.7114, 241.57184, 100), -- PathType: None
(7704, (@POINT := @POINT + 1), -6779.4634, -2870.8586, 241.06668, 100),
(7704, (@POINT := @POINT + 1), -6775.6226, -2838.4246, 244.15646, 100),
(7704, (@POINT := @POINT + 1), -6767.9497, -2819.5535, 240.88239, 100),
(7704, (@POINT := @POINT + 1), -6750.389, -2810.6487, 242.19193, 100),
(7704, (@POINT := @POINT + 1), -6730.217, -2781.9268, 241.71173, 100),
(7704, (@POINT := @POINT + 1), -6730.8735, -2749.1172, 242.91309, 100),
(7704, (@POINT := @POINT + 1), -6751.873, -2737.4922, 242.49774, 100),
(7704, (@POINT := @POINT + 1), -6784.23, -2743.225, 241.66669, 100),
(7704, (@POINT := @POINT + 1), -6806.9927, -2781.5884, 241.919, 100),
(7704, (@POINT := @POINT + 1), -6817.571, -2741.2654, 242.08292, 100),
(7704, (@POINT := @POINT + 1), -6800.767, -2698.5938, 241.70569, 100),
(7704, (@POINT := @POINT + 1), -6801.872, -2679.1108, 242.3571, 100),
(7704, (@POINT := @POINT + 1), -6823.2363, -2656.6797, 241.76585, 100),
(7704, (@POINT := @POINT + 1), -6860.4673, -2666.8088, 243.29454, 100),
(7704, (@POINT := @POINT + 1), -6895.131, -2680.9124, 242.13773, 100),
(7704, (@POINT := @POINT + 1), -6913.781, -2704.091, 241.70174, 100),
(7704, (@POINT := @POINT + 1), -6915.889, -2720.0894, 241.86537, 100),
(7704, (@POINT := @POINT + 1), -6898.7744, -2750.7844, 241.68134, 100),
(7704, (@POINT := @POINT + 1), -6906.999, -2773.4365, 242.416, 100),
(7704, (@POINT := @POINT + 1), -6926.28, -2799.1965, 241.66669, 100),
(7704, (@POINT := @POINT + 1), -6910.492, -2827.1404, 242.56451, 100),
(7704, (@POINT := @POINT + 1), -6902.024, -2849.407, 241.86577, 100),
(7704, (@POINT := @POINT + 1), -6877.299, -2844.6846, 241.67926, 100),
(7704, (@POINT := @POINT + 1), -6870.5767, -2877.1926, 243.25183, 100),
(7704, (@POINT := @POINT + 1), -6844.1685, -2883.2202, 242.4075, 100),
(7704, (@POINT := @POINT + 1), -6817.455, -2897.704, 243.5643, 100),
(7704, (@POINT := @POINT + 1), -6799.8696, -2909.407, 242.83934, 100);

UPDATE `creature` SET `position_x` = -7088.9766, `position_y` = -2951.76, `position_z` = 242.21342, `orientation` = 5.8294, `movement_type` = 2, `wander_distance` = 0 WHERE `guid`= 7138;
DELETE FROM `creature_movement` WHERE `id` = 7138;
SET @POINT := 0;
INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`) VALUES
(7138, (@POINT := @POINT + 1), -7088.9766, -2951.76, 242.21342, 100),
(7138, (@POINT := @POINT + 1), -7108.636, -2923.7773, 242.95102, 100),
(7138, (@POINT := @POINT + 1), -7087.418, -2915.5403, 242.46259, 100),
(7138, (@POINT := @POINT + 1), -7053.658, -2909.6377, 241.96663, 100),
(7138, (@POINT := @POINT + 1), -7041.259, -2911.3152, 241.66669, 100),
(7138, (@POINT := @POINT + 1), -7028.4453, -2870.3728, 241.99654, 100),
(7138, (@POINT := @POINT + 1), -7072.404, -2853.5032, 242.81898, 100),
(7138, (@POINT := @POINT + 1), -7089.6763, -2845.9036, 243.20244, 100),
(7138, (@POINT := @POINT + 1), -7092.5137, -2824.7834, 242.619, 100),
(7138, (@POINT := @POINT + 1), -7055.203, -2758.053, 241.72018, 100),
(7138, (@POINT := @POINT + 1), -7035.7905, -2758.2366, 242.63919, 100),
(7138, (@POINT := @POINT + 1), -7011.946, -2760.3704, 241.81885, 100),
(7138, (@POINT := @POINT + 1), -6994.8115, -2776.8108, 242.1589, 100),
(7138, (@POINT := @POINT + 1), -6973.576, -2807.3313, 242.88092, 100),
(7138, (@POINT := @POINT + 1), -6969.995, -2840.062, 242.49529, 100),
(7138, (@POINT := @POINT + 1), -6985.1074, -2856.4707, 242.75085, 100),
(7138, (@POINT := @POINT + 1), -6977.11, -2891.9797, 242.53224, 100),
(7138, (@POINT := @POINT + 1), -6972.747, -2915.4648, 241.71477, 100),
(7138, (@POINT := @POINT + 1), -6985.565, -2934.6987, 242.5477, 100),
(7138, (@POINT := @POINT + 1), -6973.0503, -2954.876, 241.66669, 100),
(7138, (@POINT := @POINT + 1), -6964.292, -2977.8013, 241.69873, 100),
(7138, (@POINT := @POINT + 1), -6979.968, -2994.0833, 241.66736, 100),
(7138, (@POINT := @POINT + 1), -7004.36, -3004.1772, 241.70206, 100),
(7138, (@POINT := @POINT + 1), -7030.537, -2996.673, 241.66667, 100),
(7138, (@POINT := @POINT + 1), -7049.1016, -2979.7004, 242.19534, 100),
(7138, (@POINT := @POINT + 1), -7077.788, -2977.5845, 241.96362, 100);

UPDATE `creature` SET `position_x` = -6878.75, `position_y` = -2911.5344, `position_z` = 242.32265, `orientation` = 5.8294, `movement_type` = 2, `wander_distance` = 0 WHERE `guid`= 7707;
DELETE FROM `creature_movement` WHERE `id` = 7707;
SET @POINT := 0;
INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`) VALUES
(7707, (@POINT := @POINT + 1), -6878.75, -2911.5344, 242.32265, 100),
(7707, (@POINT := @POINT + 1), -6903.979, -2901.4321, 244.99, 100),
(7707, (@POINT := @POINT + 1), -6924.8774, -2893.0034, 242.10716, 100),
(7707, (@POINT := @POINT + 1), -6957.3535, -2891.903, 241.66669, 100),
(7707, (@POINT := @POINT + 1), -6981.312, -2897.3179, 242.69778, 100),
(7707, (@POINT := @POINT + 1), -7002.924, -2892.6235, 243.2631, 100),
(7707, (@POINT := @POINT + 1), -7026.779, -2876.7515, 242.11038, 100),
(7707, (@POINT := @POINT + 1), -7043.8877, -2875.601, 241.67969, 100),
(7707, (@POINT := @POINT + 1), -7062.029, -2878.5476, 241.71848, 100),
(7707, (@POINT := @POINT + 1), -7090.0933, -2887.645, 241.70193, 100),
(7707, (@POINT := @POINT + 1), -7105.675, -2880.095, 241.66862, 100),
(7707, (@POINT := @POINT + 1), -7131.9844, -2879.1802, 242.62231, 100),
(7707, (@POINT := @POINT + 1), -7149.9956, -2883.7922, 245.74123, 100),
(7707, (@POINT := @POINT + 1), -7131.9844, -2879.1802, 242.62231, 100),
(7707, (@POINT := @POINT + 1), -7105.675, -2880.095, 241.66862, 100),
(7707, (@POINT := @POINT + 1), -7090.0933, -2887.645, 241.70193, 100),
(7707, (@POINT := @POINT + 1), -7062.029, -2878.5476, 241.71848, 100),
(7707, (@POINT := @POINT + 1), -7043.8877, -2875.601, 241.67969, 100),
(7707, (@POINT := @POINT + 1), -7026.779, -2876.7515, 242.11038, 100),
(7707, (@POINT := @POINT + 1), -7002.924, -2892.6235, 243.2631, 100),
(7707, (@POINT := @POINT + 1), -6981.312, -2897.3179, 242.69778, 100),
(7707, (@POINT := @POINT + 1), -6957.3535, -2891.903, 241.66669, 100),
(7707, (@POINT := @POINT + 1), -6924.8774, -2893.0034, 242.10716, 100),
(7707, (@POINT := @POINT + 1), -6903.979, -2901.4321, 244.99, 100);

UPDATE `creature` SET `position_x` = -7110.766, `position_y` = -2517.365, `position_z` = 315.26923, `orientation` = 5.8294, `movement_type` = 2, `wander_distance` = 0 WHERE `guid`= 7867;
DELETE FROM `creature_movement` WHERE `id` = 7867;
SET @POINT := 0;
INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`) VALUES
(7867, (@POINT := @POINT + 1), -7110.766, -2517.365, 315.26923, 100),
(7867, (@POINT := @POINT + 1), -7118.793, -2523.3223, 307.289, 100),
(7867, (@POINT := @POINT + 1), -7122.369, -2525.957, 306.0859, 100),
(7867, (@POINT := @POINT + 1), -7128.541, -2533.8281, 301.78793, 100),
(7867, (@POINT := @POINT + 1), -7128.9155, -2542.5461, 299.16, 100),
(7867, (@POINT := @POINT + 1), -7121.863, -2547.4604, 297.27448, 100),
(7867, (@POINT := @POINT + 1), -7122.746, -2554.0217, 293.18506, 100),
(7867, (@POINT := @POINT + 1), -7109.9844, -2566.713, 289.60727, 100),
(7867, (@POINT := @POINT + 1), -7094.0063, -2580.1948, 274.42517, 100),
(7867, (@POINT := @POINT + 1), -7098.5923, -2591.1096, 272.20026, 100),
(7867, (@POINT := @POINT + 1), -7096.244, -2606.8047, 268.41284, 100),
(7867, (@POINT := @POINT + 1), -7085.743, -2630.3738, 262.41043, 100),
(7867, (@POINT := @POINT + 1), -7094.135, -2652.873, 251.88158, 100),
(7867, (@POINT := @POINT + 1), -7112.79, -2674.3293, 241.75685, 100),
(7867, (@POINT := @POINT + 1), -7113.3735, -2703.2874, 241.68956, 100),
(7867, (@POINT := @POINT + 1), -7118.7456, -2726.1362, 242.12993, 100),
(7867, (@POINT := @POINT + 1), -7137.9375, -2728.3008, 247.28658, 100),
(7867, (@POINT := @POINT + 1), -7156.9004, -2727.4102, 257.19318, 100),
(7867, (@POINT := @POINT + 1), -7172.9316, -2717.205, 263.17603, 100),
(7867, (@POINT := @POINT + 1), -7156.9004, -2727.4102, 257.19318, 100),
(7867, (@POINT := @POINT + 1), -7137.9375, -2728.3008, 247.28658, 100),
(7867, (@POINT := @POINT + 1), -7118.7456, -2726.1362, 242.12993, 100),
(7867, (@POINT := @POINT + 1), -7113.3735, -2703.2874, 241.68956, 100),
(7867, (@POINT := @POINT + 1), -7112.79, -2674.3293, 241.75685, 100),
(7867, (@POINT := @POINT + 1), -7094.135, -2652.873, 251.88158, 100),
(7867, (@POINT := @POINT + 1), -7085.743, -2630.3738, 262.41043, 100),
(7867, (@POINT := @POINT + 1), -7096.244, -2606.8047, 268.41284, 100),
(7867, (@POINT := @POINT + 1), -7098.5923, -2591.1096, 272.20026, 100),
(7867, (@POINT := @POINT + 1), -7094.0063, -2580.1948, 274.42517, 100),
(7867, (@POINT := @POINT + 1), -7109.9844, -2566.713, 289.60727, 100),
(7867, (@POINT := @POINT + 1), -7122.746, -2554.0217, 293.18506, 100),
(7867, (@POINT := @POINT + 1), -7121.863, -2547.4604, 297.27448, 100),
(7867, (@POINT := @POINT + 1), -7128.9155, -2542.5461, 299.16, 100),
(7867, (@POINT := @POINT + 1), -7128.541, -2533.8281, 301.78793, 100),
(7867, (@POINT := @POINT + 1), -7122.369, -2525.957, 306.0859, 100),
(7867, (@POINT := @POINT + 1), -7118.793, -2523.3223, 307.289, 100);

UPDATE `creature` SET `position_x` = -7091.703, `position_y` = -2645.0586, `position_z` = 256.21695, `orientation` = 5.8294, `movement_type` = 2, `wander_distance` = 0 WHERE `guid`= 7847;
DELETE FROM `creature_movement` WHERE `id` = 7847;
SET @POINT := 0;
INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`) VALUES
(7847, (@POINT := @POINT + 1), -7091.703, -2645.0586, 256.21695, 100),
(7847, (@POINT := @POINT + 1), -7108.608, -2672.5544, 242.21964, 100),
(7847, (@POINT := @POINT + 1), -7131.044, -2681.8262, 241.84015, 100),
(7847, (@POINT := @POINT + 1), -7159.6772, -2686.1628, 244.50394, 100),
(7847, (@POINT := @POINT + 1), -7178.8105, -2674.161, 245.71843, 100),
(7847, (@POINT := @POINT + 1), -7179.9336, -2656.4934, 243.66843, 100),
(7847, (@POINT := @POINT + 1), -7191.954, -2636.1733, 245.92719, 100),
(7847, (@POINT := @POINT + 1), -7209.4487, -2614.8823, 250.92014, 100),
(7847, (@POINT := @POINT + 1), -7184.1196, -2600.8071, 247.03857, 100),
(7847, (@POINT := @POINT + 1), -7188.5503, -2575.361, 245.45767, 100),
(7847, (@POINT := @POINT + 1), -7218.1157, -2558.0852, 257.99463, 100),
(7847, (@POINT := @POINT + 1), -7238.841, -2550.2483, 273.74146, 100),
(7847, (@POINT := @POINT + 1), -7247.207, -2532.71, 280.56787, 100),
(7847, (@POINT := @POINT + 1), -7252.17, -2518.2249, 283.13757, 100),
(7847, (@POINT := @POINT + 1), -7247.207, -2532.71, 280.56787, 100),
(7847, (@POINT := @POINT + 1), -7238.841, -2550.2483, 273.74146, 100),
(7847, (@POINT := @POINT + 1), -7218.1157, -2558.0852, 257.99463, 100),
(7847, (@POINT := @POINT + 1), -7188.5503, -2575.361, 245.45767, 100),
(7847, (@POINT := @POINT + 1), -7184.1196, -2600.8071, 247.03857, 100),
(7847, (@POINT := @POINT + 1), -7209.4487, -2614.8823, 250.92014, 100),
(7847, (@POINT := @POINT + 1), -7191.954, -2636.1733, 245.92719, 100),
(7847, (@POINT := @POINT + 1), -7179.9336, -2656.4934, 243.66843, 100),
(7847, (@POINT := @POINT + 1), -7178.8105, -2674.161, 245.71843, 100),
(7847, (@POINT := @POINT + 1), -7159.6772, -2686.1628, 244.50394, 100),
(7847, (@POINT := @POINT + 1), -7131.044, -2681.8262, 241.84015, 100),
(7847, (@POINT := @POINT + 1), -7108.608, -2672.5544, 242.21964, 100);

UPDATE `creature` SET `position_x` = -7196.9424, `position_y` = -2710.4268, `position_z` = 268.24127, `orientation` = 5.8294, `movement_type` = 2, `wander_distance` = 0 WHERE `guid`= 7851;
DELETE FROM `creature_movement` WHERE `id` = 7851;
SET @POINT := 0;
INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`) VALUES
(7851, (@POINT := @POINT + 1), -7196.9424, -2710.4268, 268.24127, 100),
(7851, (@POINT := @POINT + 1), -7201.9087, -2696.711, 259.70654, 100),
(7851, (@POINT := @POINT + 1), -7199.1484, -2688.1504, 255.0003, 100),
(7851, (@POINT := @POINT + 1), -7194.7466, -2678.2925, 251.0323, 100),
(7851, (@POINT := @POINT + 1), -7187.6216, -2659.4287, 245.55986, 100),
(7851, (@POINT := @POINT + 1), -7177.5337, -2626.6836, 246.07841, 100),
(7851, (@POINT := @POINT + 1), -7174.8145, -2597.7844, 249.67822, 100),
(7851, (@POINT := @POINT + 1), -7166.9014, -2577.0261, 253.66383, 100),
(7851, (@POINT := @POINT + 1), -7171.5225, -2553.8484, 250.35423, 100),
(7851, (@POINT := @POINT + 1), -7183.666, -2540.157, 247.24037, 100),
(7851, (@POINT := @POINT + 1), -7192.14, -2523.294, 248.46405, 100),
(7851, (@POINT := @POINT + 1), -7180.3857, -2492.4934, 249.59561, 100),
(7851, (@POINT := @POINT + 1), -7181.7603, -2476.9739, 246.92215, 100),
(7851, (@POINT := @POINT + 1), -7197.8228, -2472.0037, 245.98572, 100),
(7851, (@POINT := @POINT + 1), -7232.143, -2474.0154, 258.9044, 100),
(7851, (@POINT := @POINT + 1), -7245.9634, -2492.9197, 271.76425, 100),
(7851, (@POINT := @POINT + 1), -7232.143, -2474.0154, 258.9044, 100),
(7851, (@POINT := @POINT + 1), -7197.8228, -2472.0037, 245.98572, 100),
(7851, (@POINT := @POINT + 1), -7181.7603, -2476.9739, 246.92215, 100),
(7851, (@POINT := @POINT + 1), -7180.3857, -2492.4934, 249.59561, 100),
(7851, (@POINT := @POINT + 1), -7192.14, -2523.294, 248.46405, 100),
(7851, (@POINT := @POINT + 1), -7183.666, -2540.157, 247.24037, 100),
(7851, (@POINT := @POINT + 1), -7171.5225, -2553.8484, 250.35423, 100),
(7851, (@POINT := @POINT + 1), -7166.9014, -2577.0261, 253.66383, 100),
(7851, (@POINT := @POINT + 1), -7174.8145, -2597.7844, 249.67822, 100),
(7851, (@POINT := @POINT + 1), -7177.5337, -2626.6836, 246.07841, 100),
(7851, (@POINT := @POINT + 1), -7187.6216, -2659.4287, 245.55986, 100),
(7851, (@POINT := @POINT + 1), -7194.7466, -2678.2925, 251.0323, 100),
(7851, (@POINT := @POINT + 1), -7199.1484, -2688.1504, 255.0003, 100),
(7851, (@POINT := @POINT + 1), -7201.9087, -2696.711, 259.70654, 100);

UPDATE `creature` SET `position_x` = -7051.4907, `position_y` = -2478.0754, `position_z` = 243.89229, `orientation` = 5.8294, `movement_type` = 2, `wander_distance` = 0 WHERE `guid`= 7608;
DELETE FROM `creature_movement` WHERE `id` = 7608;
SET @POINT := 0;
INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`) VALUES
(7608, (@POINT := @POINT + 1), -7051.4907, -2478.0754, 243.89229, 100),
(7608, (@POINT := @POINT + 1), -7069.9795, -2460.9614, 250.75137, 100),
(7608, (@POINT := @POINT + 1), -7083.955, -2453.538, 257.4748, 100),
(7608, (@POINT := @POINT + 1), -7092.9087, -2428.1582, 246.42758, 100),
(7608, (@POINT := @POINT + 1), -7078.921, -2404.8872, 241.7638, 100),
(7608, (@POINT := @POINT + 1), -7066.292, -2384.5227, 241.66667, 100),
(7608, (@POINT := @POINT + 1), -7062.1235, -2362.4912, 240.42508, 100),
(7608, (@POINT := @POINT + 1), -7056.498, -2332.5269, 245.50703, 100),
(7608, (@POINT := @POINT + 1), -7057.1313, -2319.394, 251.676, 100),
(7608, (@POINT := @POINT + 1), -7047.9175, -2307.275, 257.23865, 100),
(7608, (@POINT := @POINT + 1), -7051.62, -2293.6155, 262.73862, 100),
(7608, (@POINT := @POINT + 1), -7035.7954, -2277.1526, 265.8334, 100),
(7608, (@POINT := @POINT + 1), -7051.62, -2293.6155, 262.73862, 100),
(7608, (@POINT := @POINT + 1), -7047.9175, -2307.275, 257.23865, 100),
(7608, (@POINT := @POINT + 1), -7057.1313, -2319.394, 251.676, 100),
(7608, (@POINT := @POINT + 1), -7056.498, -2332.5269, 245.50703, 100),
(7608, (@POINT := @POINT + 1), -7062.1235, -2362.4912, 240.42508, 100),
(7608, (@POINT := @POINT + 1), -7066.292, -2384.5227, 241.66667, 100),
(7608, (@POINT := @POINT + 1), -7078.921, -2404.8872, 241.7638, 100),
(7608, (@POINT := @POINT + 1), -7092.9087, -2428.1582, 246.42758, 100),
(7608, (@POINT := @POINT + 1), -7083.955, -2453.538, 257.4748, 100),
(7608, (@POINT := @POINT + 1), -7069.9795, -2460.9614, 250.75137, 100);

UPDATE `creature` SET `position_x` = -6958.654, `position_y` = -2546.8032, `position_z` = 248.27197, `orientation` = 5.8294, `movement_type` = 2, `wander_distance` = 0 WHERE `guid`= 7404;
DELETE FROM `creature_movement` WHERE `id` = 7404;
SET @POINT := 0;
INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`) VALUES
(7404, (@POINT := @POINT + 1), -6958.654, -2546.8032, 248.27197, 100),
(7404, (@POINT := @POINT + 1), -6981.45, -2524.181, 241.66669, 100),
(7404, (@POINT := @POINT + 1), -7007.2456, -2511.1345, 241.99915, 100),
(7404, (@POINT := @POINT + 1), -7018.94, -2479.4507, 242.43282, 100),
(7404, (@POINT := @POINT + 1), -7008.72, -2468.894, 241.73154, 100),
(7404, (@POINT := @POINT + 1), -7001.2324, -2442.4146, 242.31415, 100),
(7404, (@POINT := @POINT + 1), -7012.3433, -2412.9753, 241.66667, 100),
(7404, (@POINT := @POINT + 1), -7016.97, -2397.4368, 241.66667, 100),
(7404, (@POINT := @POINT + 1), -7014.2476, -2366.2417, 241.93608, 100),
(7404, (@POINT := @POINT + 1), -7003.3755, -2351.7979, 241.75424, 100),
(7404, (@POINT := @POINT + 1), -6990.011, -2335.7893, 241.66678, 100),
(7404, (@POINT := @POINT + 1), -6983.487, -2317.2585, 245.42456, 100),
(7404, (@POINT := @POINT + 1), -6990.011, -2335.7893, 241.66678, 100),
(7404, (@POINT := @POINT + 1), -7003.3755, -2351.7979, 241.75424, 100),
(7404, (@POINT := @POINT + 1), -7014.2476, -2366.2417, 241.93608, 100),
(7404, (@POINT := @POINT + 1), -7016.97, -2397.4368, 241.66667, 100),
(7404, (@POINT := @POINT + 1), -7012.3433, -2412.9753, 241.66667, 100),
(7404, (@POINT := @POINT + 1), -7001.2324, -2442.4146, 242.31415, 100),
(7404, (@POINT := @POINT + 1), -7008.72, -2468.894, 241.73154, 100),
(7404, (@POINT := @POINT + 1), -7018.94, -2479.4507, 242.43282, 100),
(7404, (@POINT := @POINT + 1), -7007.2456, -2511.1345, 241.99915, 100),
(7404, (@POINT := @POINT + 1), -6981.45, -2524.181, 241.66669, 100);

UPDATE `creature` SET `position_x` = -6711.9336, `position_y` = -2459.027, `position_z` = 272.65225, `orientation` = 5.8294, `movement_type` = 2, `wander_distance` = 0 WHERE `guid`= 7713;
DELETE FROM `creature_movement` WHERE `id` = 7713;
SET @POINT := 0;
INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`) VALUES
(7713, (@POINT := @POINT + 1), -6711.9336, -2459.027, 272.65225, 100),
(7713, (@POINT := @POINT + 1), -6712.157, -2468.2727, 266.88318, 100),
(7713, (@POINT := @POINT + 1), -6710.4946, -2472.5107, 262.8584, 100),
(7713, (@POINT := @POINT + 1), -6706.5713, -2475.7993, 259.27594, 100),
(7713, (@POINT := @POINT + 1), -6705.4707, -2485.3354, 253.56667, 100),
(7713, (@POINT := @POINT + 1), -6704.592, -2515.336, 243.81813, 100),
(7713, (@POINT := @POINT + 1), -6697.011, -2542.7625, 242.05928, 100),
(7713, (@POINT := @POINT + 1), -6707.1177, -2572.2002, 241.66669, 100),
(7713, (@POINT := @POINT + 1), -6729.526, -2613.8242, 241.66196, 100),
(7713, (@POINT := @POINT + 1), -6738.8438, -2637.7395, 241.68471, 100),
(7713, (@POINT := @POINT + 1), -6739.8003, -2663.257, 241.64047, 100),
(7713, (@POINT := @POINT + 1), -6753.2275, -2680.4492, 243.03142, 100),
(7713, (@POINT := @POINT + 1), -6756.0117, -2709.4844, 241.66669, 100),
(7713, (@POINT := @POINT + 1), -6733.76, -2723.9446, 241.66667, 100),
(7713, (@POINT := @POINT + 1), -6713.6704, -2727.9202, 241.98186, 100),
(7713, (@POINT := @POINT + 1), -6690.677, -2750.184, 241.71361, 100),
(7713, (@POINT := @POINT + 1), -6670.4814, -2782.377, 241.68198, 100),
(7713, (@POINT := @POINT + 1), -6656.277, -2794.1284, 242.65814, 100),
(7713, (@POINT := @POINT + 1), -6637.4595, -2814.0554, 245.54596, 100),
(7713, (@POINT := @POINT + 1), -6656.277, -2794.1284, 242.65814, 100),
(7713, (@POINT := @POINT + 1), -6670.4814, -2782.377, 241.68198, 100),
(7713, (@POINT := @POINT + 1), -6690.677, -2750.184, 241.71361, 100),
(7713, (@POINT := @POINT + 1), -6713.6704, -2727.9202, 241.98186, 100),
(7713, (@POINT := @POINT + 1), -6733.76, -2723.9446, 241.66667, 100),
(7713, (@POINT := @POINT + 1), -6756.0117, -2709.4844, 241.66669, 100),
(7713, (@POINT := @POINT + 1), -6753.2275, -2680.4492, 243.03142, 100),
(7713, (@POINT := @POINT + 1), -6739.8003, -2663.257, 241.64047, 100),
(7713, (@POINT := @POINT + 1), -6738.8438, -2637.7395, 241.68471, 100),
(7713, (@POINT := @POINT + 1), -6729.526, -2613.8242, 241.66196, 100),
(7713, (@POINT := @POINT + 1), -6707.1177, -2572.2002, 241.66669, 100),
(7713, (@POINT := @POINT + 1), -6697.011, -2542.7625, 242.05928, 100),
(7713, (@POINT := @POINT + 1), -6704.592, -2515.336, 243.81813, 100),
(7713, (@POINT := @POINT + 1), -6705.4707, -2485.3354, 253.56667, 100),
(7713, (@POINT := @POINT + 1), -6706.5713, -2475.7993, 259.27594, 100),
(7713, (@POINT := @POINT + 1), -6710.4946, -2472.5107, 262.8584, 100),
(7713, (@POINT := @POINT + 1), -6712.157, -2468.2727, 266.88318, 100);


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