DB: Add map_corpse_position table

1 files changed, 76 insertions, 0 deletions

diff --git a/sql/updates/world/3.4.x/2023_11_23_00_world.sql b/sql/updates/world/3.4.x/2023_11_23_00_world.sql
new file mode 100644
index 00000000000..c47c16caa9f
--- /dev/null
+++ b/sql/updates/world/3.4.x/2023_11_23_00_world.sql
@@ -0,0 +1,76 @@
+DROP TABLE IF EXISTS `map_corpse_position`;
+CREATE TABLE `map_corpse_position` ( `MapId` INT(10) UNSIGNED NOT NULL DEFAULT '0', `CorpseX` FLOAT NOT NULL DEFAULT '0', `CorpseY` FLOAT NOT NULL DEFAULT '0', PRIMARY KEY (`MapId`) USING BTREE) COLLATE='utf8mb4_unicode_ci' ENGINE=InnoDB;
+
+DELETE FROM `map_corpse_position` WHERE `MapId` IN (33, 34, 35, 36, 43, 44, 47, 48, 70, 90, 109, 129, 189, 209, 229, 230, 249, 269, 289, 309, 329, 349, 369, 389, 409, 429, 469, 509, 531, 532, 534, 540, 542, 543, 544, 545, 546, 547, 548, 555, 556, 557, 558, 560, 564, 565, 568, 574, 575, 576, 578, 580, 585, 595, 599, 600, 601, 602, 603, 604, 608, 615, 616, 619, 624, 631, 632, 649, 650, 658, 668);
+INSERT INTO `map_corpse_position` (`MapID`, `CorpseX`, `CorpseY`) VALUES 
+(33, -230.989, 1571.57),
+(34, -8762.38, 848.01),
+(35, -8762.48, 848.049),
+(36, -11207.8, 1681.15),
+(43, -751.131, -2209.24),
+(44, 2892.41, -811.241),
+(47, -4459.45, -1660.21),
+(48, 4249.12, 748.387),
+(70, -6060.18, -2955),
+(90, -5162.66, 931.599),
+(109, -10170.1, -3995.97),
+(129, -4662.88, -2535.87),
+(189, 2892.24, -811.264),
+(209, -6790.58, -2891.28),
+(229, -7522.53, -1233.04),
+(230, -7178.1, -928.64),
+(249, -4753.31, -3752.42),
+(269, -8750.83, -4193.51),
+(289, 1274.78, -2552.56),
+(309, -11916.1, -1224.58),
+(329, 3392.32, -3378.48),
+(349, -1432.7, 2924.98),
+(369, -8349.22, 517.348),
+(389, 1816.76, -4423.37),
+(409, -7510.56, -1036.7),
+(429, -3908.03, 1130),
+(469, -7663.41, -1218.67),
+(509, -8114.46, 1526.37),
+(531, -8111.72, 1526.79),
+(532, -11110.4, -2004.06),
+(534, -8178.51, -4182.05),
+(540, -306.758, 3064.44),
+(542, -295.419, 3151.99),
+(543, -360.05, 3067.9),
+(544, -330.234, 3106.64),
+(545, 764.219, 6915.08),
+(546, 764.628, 6768.07),
+(547, 742.158, 7011.33),
+(548, 775.786, 6865.24),
+(555, -3640.69, 4943.16),
+(556, -3361.86, 4665.59),
+(557, -3089.52, 4942.76),
+(558, -3363.44, 5156.46),
+(560, -8309.81, -4061.51),
+(564, -3644.53, 317.294),
+(565, 3525.45, 5144.15),
+(568, 6851.02, -7989.71),
+(574, 1211.76, -4868.42),
+(575, 1232.41, -4860.95),
+(576, 3899.93, 6985.44),
+(578, 3865.92, 6983.94),
+(580, 12551.8, -6774.56),
+(585, 12881.9, -7343.1),
+(595, -8756.09, -4457.42),
+(599, 8921.79, -966.807),
+(600, 4774.58, -2023.05),
+(601, 3672.22, 2171.27),
+(602, 9185.09, -1386.79),
+(603, 9359.37, -1115.18),
+(604, 6708.73, -4654.9),
+(608, 5689.49, 498.047),
+(615, 3438.15, 260.401),
+(616, 3869.98, 6984.33),
+(619, 3641.46, 2032.06),
+(624, 5488.12, 2840.33),
+(631, 5776.92, 2065.93),
+(632, 5670.79, 2003.63),
+(649, 8515.29, 736.137),
+(650, 8571.43, 792.221),
+(658, 5592.06, 2010.27),
+(668, 5628.88, 1973.29);