NickTyrer
252 lines
17 KiB
SQL
252 lines
17 KiB
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`='20250712123136');
|
|
IF v = 0 THEN
|
|
INSERT INTO `migrations` VALUES ('20250712123136');
|
|
-- Add your query below.
|
|
|
|
|
|
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
|
|
(6087, 7046, 0, 0, 0, 0, 0, 769.29901123046880000000, 1937.90002441406250000000, -1.00000000000000000000, 1.32500004768372080000, 300, 900, 20, 100, 0, 1, 0, 0, 0, 10);
|
|
|
|
SET @MOVID = 3297;
|
|
UPDATE `creature` SET `wander_distance`=0,`movement_type`=2,`position_x`=-8276.903,`position_y`=-1374.8982,`position_z`=170.14882 WHERE `guid`=@MOVID;
|
|
DELETE FROM `creature_movement` WHERE `id` = @MOVID;
|
|
SET @POINT := 0;
|
|
INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`) VALUES
|
|
(@MOVID, (@POINT := @POINT + 1), -8276.903, -1374.8982, 170.14882, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8248.569, -1394.3069, 156.48671, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8232.245, -1388.5055, 151.35811, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8213.244, -1387.9492, 144.621, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8187.617, -1373.4078, 141.08673, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8182.317, -1357.6813, 135.82643, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8156.627, -1333.8954, 137.08704, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8122.4497, -1308.1586, 133.51921, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8089.5835, -1292.2653, 136.22623, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8122.4497, -1308.1586, 133.51921, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8156.627, -1333.8954, 137.08704, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8182.317, -1357.6813, 135.82643, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8187.617, -1373.4078, 141.08673, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8213.244, -1387.9492, 144.621, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8232.245, -1388.5055, 151.35811, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8248.569, -1394.3069, 156.48671, 100);
|
|
|
|
SET @MOVID = 3300;
|
|
UPDATE `creature` SET `wander_distance`=0,`movement_type`=2,`position_x`=-8095.0425,`position_y`=-2124.8826,`position_z`=133.43738 WHERE `guid`=@MOVID;
|
|
DELETE FROM `creature_movement` WHERE `id` = @MOVID;
|
|
SET @POINT := 0;
|
|
INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`) VALUES
|
|
(@MOVID, (@POINT := @POINT + 1), -8095.0425, -2124.8826, 133.43738, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8124.0312, -2098.1958, 132.639, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8135.0557, -2070.5483, 131.37178, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8159.9697, -2037.0293, 136.71048, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8139.5923, -2064.4368, 131.64632, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8182.5845, -2033.3633, 146.46582, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8209.151, -1999.3633, 144.6915, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8229.272, -1957.9, 142.89095, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8268.463, -1943.7305, 146.50415, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8302.705, -1932.5508, 144.92598, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8325.673, -1904.846, 160.99939, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8338.679, -1882.0251, 167.8216, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8340.845, -1849.9127, 168.53629, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8338.679, -1882.0251, 167.8216, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8325.673, -1904.846, 160.99939, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8302.705, -1932.5508, 144.92598, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8268.463, -1943.7305, 146.50415, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8229.272, -1957.9, 142.89095, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8209.151, -1999.3633, 144.6915, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8182.5845, -2033.3633, 146.46582, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8139.5923, -2064.4368, 131.64632, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8159.9697, -2037.0293, 136.71048, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8135.0557, -2070.5483, 131.37178, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8124.0312, -2098.1958, 132.639, 100);
|
|
|
|
SET @MOVID = 3301;
|
|
UPDATE `creature` SET `wander_distance`=0,`movement_type`=2,`position_x`=-7891.5103,`position_y`=-1013.994,`position_z`=137.71967 WHERE `guid`=@MOVID;
|
|
DELETE FROM `creature_movement` WHERE `id` = @MOVID;
|
|
SET @POINT := 0;
|
|
INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`) VALUES
|
|
(@MOVID, (@POINT := @POINT + 1), -7891.5103, -1013.994, 137.71967, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -7932.4106, -991.90234, 131.91534, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -7955.0156, -950.6009, 134.12901, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -7948.0713, -920.3411, 131.59714, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -7953.653, -881.10345, 129.08481, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -7975.9517, -849.6788, 130.68076, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -7993.7275, -811.499, 129.91948, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8024.173, -787.2034, 129.67657, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8055.329, -777.452, 131.28864, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8086.328, -770.9561, 131.68925, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8110.627, -755.1543, 134.53264, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8136.369, -734.6985, 137.61859, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8141.612, -752.7918, 134.2293, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8156.79, -786.2441, 129.8628, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8184.1006, -813.03766, 129.49083, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8156.79, -786.2441, 129.8628, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8141.612, -752.7918, 134.2293, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8136.369, -734.6985, 137.61859, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8110.627, -755.1543, 134.53264, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8086.328, -770.9561, 131.68925, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8055.329, -777.452, 131.28864, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8024.173, -787.2034, 129.67657, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -7993.7275, -811.499, 129.91948, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -7975.9517, -849.6788, 130.68076, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -7953.653, -881.10345, 129.08481, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -7948.0713, -920.3411, 131.59714, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -7955.0156, -950.6009, 134.12901, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -7932.4106, -991.90234, 131.91534, 100);
|
|
|
|
SET @MOVID = 3302;
|
|
UPDATE `creature` SET `wander_distance`=0,`movement_type`=2,`position_x`=-8304.778,`position_y`=-1953.7252,`position_z`=144.83127 WHERE `guid`=@MOVID;
|
|
DELETE FROM `creature_movement` WHERE `id` = @MOVID;
|
|
SET @POINT := 0;
|
|
INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`) VALUES
|
|
(@MOVID, (@POINT := @POINT + 1), -8304.778, -1953.7252, 144.83127, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8281.424, -1995.3574, 147.05557, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8245.48, -1986.7361, 146.87619, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8228.036, -2001.2009, 142.98119, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8188.022, -2026.6649, 145.85123, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8164.221, -2042.4696, 140.19736, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8139.377, -2075.024, 132.2787, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8149.3604, -2105.3625, 133.46922, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8177.2837, -2140.55, 135.73965, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8195.6875, -2163.2964, 133.86261, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8200.622, -2194.1753, 132.69647, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8201.55, -2223.9211, 132.98145, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8196.974, -2260.519, 132.57193, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8201.55, -2223.9211, 132.98145, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8200.622, -2194.1753, 132.69647, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8195.6875, -2163.2964, 133.86261, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8177.2837, -2140.55, 135.73965, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8149.3604, -2105.3625, 133.46922, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8139.377, -2075.024, 132.2787, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8164.221, -2042.4696, 140.19736, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8188.022, -2026.6649, 145.85123, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8228.036, -2001.2009, 142.98119, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8245.48, -1986.7361, 146.87619, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8281.424, -1995.3574, 147.05557, 100);
|
|
|
|
SET @MOVID = 3303;
|
|
UPDATE `creature` SET `wander_distance`=0,`movement_type`=2,`position_x`=-8191.8384,`position_y`=-851.15344,`position_z`=131.45049 WHERE `guid`=@MOVID;
|
|
DELETE FROM `creature_movement` WHERE `id` = @MOVID;
|
|
SET @POINT := 0;
|
|
INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`) VALUES
|
|
(@MOVID, (@POINT := @POINT + 1), -8191.8384, -851.15344, 131.45049, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8193.783, -882.35803, 133.3449, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8198.333, -906.25964, 133.1636, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8194.351, -949.52527, 133.81879, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8186.5923, -978.08856, 134.75945, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8206.944, -999.7561, 144.63896, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8226.378, -1020.5859, 144.87201, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8253.752, -1041.0597, 147.0334, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8283.334, -1018.9456, 157.08206, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8306.552, -1007.3849, 172.94354, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8329.227, -996.4523, 180.73784, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8352.944, -976.6074, 186.05515, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8384.176, -960.4847, 194.41013, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8410.112, -959.533, 200.6547, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8432.333, -940.71124, 214.35498, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8410.112, -959.533, 200.6547, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8384.176, -960.4847, 194.41013, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8352.944, -976.6074, 186.05515, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8329.227, -996.4523, 180.73784, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8306.552, -1007.3849, 172.94354, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8283.334, -1018.9456, 157.08206, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8253.752, -1041.0597, 147.0334, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8226.378, -1020.5859, 144.87201, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8206.944, -999.7561, 144.63896, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8186.5923, -978.08856, 134.75945, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8194.351, -949.52527, 133.81879, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8198.333, -906.25964, 133.1636, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8193.783, -882.35803, 133.3449, 100);
|
|
|
|
SET @MOVID = 6087;
|
|
UPDATE `creature` SET `wander_distance`=0,`movement_type`=2,`position_x`=-8233.136,`position_y`=-1259.2134,`position_z`=142.82474 WHERE `guid`=@MOVID;
|
|
DELETE FROM `creature_movement` WHERE `id` = @MOVID;
|
|
SET @POINT := 0;
|
|
INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`) VALUES
|
|
(@MOVID, (@POINT := @POINT + 1), -8233.136, -1259.2134, 142.82474, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8241.008, -1222.0096, 142.55655, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8240.933, -1192.1224, 142.55655, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8218.833, -1159.2101, 142.65984, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8207.445, -1111.5508, 147.58736, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8218.43, -1082.7361, 145.4217, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8237.375, -1061.8856, 143.03264, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8234.343, -1021.2225, 144.0289, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8204.092, -1013.8113, 146.75606, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8197.037, -986.68555, 139.61156, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8178.578, -982.69366, 135.19235, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8153.178, -1010.1317, 134.25548, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8140.151, -1055.7783, 132.30621, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8139.6787, -1088.9814, 131.71991, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8147.5166, -1116.4622, 134.88683, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8156.1606, -1159.8253, 137.78009, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8152.112, -1190.5287, 136.3153, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8128.9985, -1231.4294, 133.0803, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8152.112, -1190.5287, 136.3153, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8156.1606, -1159.8253, 137.78009, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8147.5166, -1116.4622, 134.88683, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8139.6787, -1088.9814, 131.71991, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8140.151, -1055.7783, 132.30621, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8153.178, -1010.1317, 134.25548, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8178.578, -982.69366, 135.19235, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8197.037, -986.68555, 139.61156, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8204.092, -1013.8113, 146.75606, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8234.343, -1021.2225, 144.0289, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8237.375, -1061.8856, 143.03264, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8218.43, -1082.7361, 145.4217, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8207.445, -1111.5508, 147.58736, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8218.833, -1159.2101, 142.65984, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8240.933, -1192.1224, 142.55655, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8241.008, -1222.0096, 142.55655, 100);
|
|
|
|
SET @MOVID = 4602;
|
|
UPDATE `creature` SET `wander_distance`=0,`movement_type`=2,`position_x`=-8379.346,`position_y`=-987.76196,`position_z`=187.36035 WHERE `guid`=@MOVID;
|
|
DELETE FROM `creature_movement` WHERE `id` = @MOVID;
|
|
SET @POINT := 0;
|
|
INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`) VALUES
|
|
(@MOVID, (@POINT := @POINT + 1), -8379.346, -987.76196, 187.36035, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8347.01, -1004.2602, 186.72144, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8317.509, -1006.3348, 177.87779, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8291.703, -1017.2834, 162.59137, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8255.247, -1039.1394, 147.49077, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8223.769, -1058.5443, 142.60179, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8193.513, -1084.2135, 148.96994, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8151.9414, -1095.2988, 135.29819, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8119.654, -1085.2294, 130.39948, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8072.6855, -1075.1035, 129.61156, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8040.4487, -1055.8219, 130.88481, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8020.368, -1028.7192, 130.10533, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8002.77, -992.1246, 128.11139, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -7996.493, -960.4993, 128.08041, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -7986.4785, -915.4425, 129.48541, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -7970.4375, -884.61804, 129.08978, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -7972.9766, -860.09753, 130.7237, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -7990.7446, -828.2292, 131.00607, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8017.8115, -802.21704, 131.37456, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8052.5894, -776.60394, 131.17813, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8081.4487, -765.6528, 132.47754, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8122.9673, -759.2025, 133.50381, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8155.389, -781.4237, 129.62036, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8184.405, -813.0994, 129.51363, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8193.629, -846.69965, 131.5964, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8192.331, -886.122, 132.98537, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8199.4, -911.2051, 132.9773, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8210.492, -950.4794, 133.33333, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8245.052, -975.30164, 135.9822, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8255.406, -991.2207, 142.86629, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8258.869, -1031.1998, 148.60999, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8294.398, -1014.0278, 165.9485, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8326.279, -988.7189, 180.07904, 100),
|
|
(@MOVID, (@POINT := @POINT + 1), -8354.638, -956.4075, 190.76584, 100);
|
|
|
|
|
|
-- End of migration.
|
|
END IF;
|
|
END??
|
|
DELIMITER ;
|
|
CALL add_migration();
|
|
DROP PROCEDURE IF EXISTS add_migration;
|