DB/Misc: Add creature_movement_info for future use

Ref #25964

(cherry picked from commit 389979e8a3110511a99362ed1fb0cdcd4c667e60)

1 files changed, 385 insertions, 0 deletions

diff --git a/sql/updates/world/master/2022_03_19_00_world_2021_10_01_00_world.sql b/sql/updates/world/master/2022_03_19_00_world_2021_10_01_00_world.sql
new file mode 100644
index 00000000000..fd956d4f5ab
--- /dev/null
+++ b/sql/updates/world/master/2022_03_19_00_world_2021_10_01_00_world.sql
@@ -0,0 +1,385 @@
+--
+DROP TABLE IF EXISTS `creature_movement_info`;
+CREATE TABLE `creature_movement_info` (
+  `MovementID` int unsigned NOT NULL DEFAULT '0' COMMENT 'creature_template.movementId value',
+  `WalkSpeed` float DEFAULT NULL,
+  `RunSpeed` float DEFAULT NULL,
+  PRIMARY KEY (`MovementID`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
+
+INSERT INTO `creature_movement_info` (`MovementID`, `WalkSpeed`, `RunSpeed`) VALUES
+(1,0,5),
+(41,0.4,0),
+(42,0.5,0),
+(43,1,0),
+(44,1.5,0),
+(45,2,0),
+(46,2.25,0),
+(47,2.5,0),
+(48,3,0),
+(49,3.3,0),
+(50,3.5,0),
+(51,4,0),
+(52,4.5,0),
+(53,5,0),
+(54,6,0),
+(55,7,0),
+(56,NULL,0),
+(57,8,0),
+(58,10,0),
+(59,20,0),
+(60,0.01,0.01),
+(61,0.5,0.5),
+(62,0.7,0.7),
+(63,0,1),
+(64,1,1),
+(65,1,1.5),
+(66,1.5,1.5),
+(67,1.75,1.75),
+(68,0,2),
+(69,1,2),
+(70,2,2),
+(71,0,2.5),
+(72,2.5,2.5),
+(73,0,3),
+(74,2,3),
+(75,2.5,3),
+(76,3,3),
+(77,3.3,3.3),
+(78,0,3.5),
+(79,3.5,3.5),
+(80,0,4),
+(81,1.6,4),
+(82,2,4),
+(83,3,4),
+(84,4,4),
+(85,0,4.4),
+(86,4.5,4.5),
+(87,4,4.75),
+(88,0,5),
+(89,1,5),
+(90,2,5),
+(91,3,5),
+(92,3.5,5),
+(93,4,5),
+(94,5,5),
+(95,NULL,5.3),
+(96,0,5.5),
+(97,3,5.5),
+(98,5.5,5.5),
+(99,5.8,5.8),
+(100,0,6),
+(101,1.8,6),
+(102,2,6),
+(103,3,6),
+(104,4,6),
+(105,5,6),
+(106,6,6),
+(107,NULL,NULL),
+(108,0,6.2),
+(109,0,6.25),
+(110,0,6.5),
+(111,5,6.5),
+(112,3,6.9),
+(113,0,7),
+(114,2,7),
+(115,3,7),
+(116,4,7),
+(117,5,7),
+(118,7,7),
+(119,0,7.2),
+(120,4,7.5),
+(121,0,8),
+(122,1,8),
+(123,2,8),
+(124,3,8),
+(125,4,8),
+(126,4.5,8),
+(127,5,8),
+(128,6,8),
+(129,8,8),
+(130,0,8.5),
+(131,4,8.5),
+(132,5,8.5),
+(133,0,9),
+(134,4,9),
+(135,5,9),
+(136,6,9),
+(137,7,9),
+(138,9,9),
+(139,30,9),
+(140,0,9.7),
+(141,4,9.7),
+(142,5,9.7),
+(143,NULL,NULL),
+(144,0,10),
+(145,1,10),
+(146,2.4,10),
+(147,3,10),
+(148,3.2,10),
+(149,3.5,10),
+(150,4,10),
+(151,5,10),
+(152,6,10),
+(153,6.5,10),
+(154,7,10),
+(155,8,10),
+(156,10,10),
+(157,0,11),
+(158,3,11),
+(159,4,11),
+(160,6,11),
+(161,7,11),
+(162,11,11),
+(163,0,11.5),
+(164,0,12),
+(165,3,12),
+(166,3.75,12),
+(167,4,12),
+(168,4.5,12),
+(169,5,12),
+(170,6,12),
+(171,7,12),
+(172,8,12),
+(173,10,12),
+(174,12,12),
+(175,30,12),
+(176,0,13),
+(177,4,13),
+(178,5,13),
+(179,8,13),
+(180,0,14),
+(181,2,14),
+(182,3,14),
+(183,4,14),
+(184,5,14),
+(185,6,14),
+(186,7,14),
+(187,8,14),
+(188,0,15),
+(189,3,15),
+(190,4,15),
+(191,5,15),
+(192,6,15),
+(193,7,15),
+(194,8,15),
+(195,9,15),
+(196,10,15),
+(197,15,15),
+(198,30,15),
+(199,0,16),
+(200,4,16),
+(201,5,16),
+(202,6,16),
+(203,7,16),
+(204,8,16),
+(205,12,16),
+(206,16,16),
+(207,0,17),
+(208,5,17),
+(209,9,17),
+(210,0,18),
+(211,3.5,18),
+(212,4,18),
+(213,6,18),
+(214,7,18),
+(215,8,18),
+(216,10,18),
+(217,18,18),
+(218,0,19),
+(219,8,19),
+(220,0,20),
+(221,4,20),
+(222,5,20),
+(223,6,20),
+(224,7,20),
+(225,8,20),
+(226,9,20),
+(227,10,20),
+(228,12,20),
+(229,15,20),
+(230,16,20),
+(231,20,20),
+(232,0,21),
+(233,10,21),
+(234,20,21),
+(235,30,21),
+(236,0,22),
+(237,6,22),
+(238,NULL,22),
+(239,12,22),
+(240,15,22),
+(241,0,24),
+(242,8,24),
+(243,10,24),
+(244,12,24),
+(245,24,24),
+(246,0,25),
+(247,3,25),
+(248,9,25),
+(249,10,25),
+(250,12,25),
+(251,25,25),
+(252,NULL,26),
+(253,0,27),
+(254,10,28),
+(255,14,28),
+(256,15,28),
+(257,16,28),
+(258,20,28),
+(259,0,30),
+(260,10,30),
+(261,12,30),
+(262,15,30),
+(263,18,30),
+(264,NULL,30),
+(265,30,30),
+(266,20,33),
+(267,3,35),
+(268,12,35),
+(269,0,40),
+(270,20,40),
+(271,0,45),
+(272,50,50),
+(273,0,60),
+(274,1.25,0),
+(301,NULL,NULL),
+(321,7,12),
+(341,7,12),
+(361,NULL,NULL),
+(381,5,10),
+(401,0,7),
+(421,2.5,7),
+(441,0,10),
+(461,NULL,NULL),
+(481,6.5,6.5),
+(501,0,7),
+(521,NULL,NULL),
+(541,0,10),
+(561,NULL,NULL),
+(581,NULL,NULL),
+(601,NULL,NULL),
+(602,0,80),
+(641,7,20),
+(661,4,10),
+(681,NULL,NULL),
+(701,3,6.5),
+(721,3,10),
+(741,5,12),
+(761,0,10),
+(781,NULL,NULL),
+(801,4,4),
+(821,2,2),
+(841,0,8),
+(861,13,13),
+(862,15,15),
+(863,NULL,NULL),
+(864,17,17),
+(865,NULL,NULL),
+(866,0,3),
+(867,NULL,NULL),
+(868,1.5,8),
+(869,0,0),
+(870,4,4),
+(871,NULL,NULL),
+(872,1,1),
+(873,0.4,0.4),
+(875,0,9.5),
+(884,NULL,NULL),
+(885,2,3),
+(888,2,2),
+(894,9,18),
+(903,0.25,0.5),
+(907,NULL,NULL),
+(908,12,20),
+(911,NULL,NULL),
+(912,14,14),
+(913,3,3),
+(915,1.5,6),
+(916,3,3),
+(917,NULL,NULL),
+(918,9,6),
+(922,2,2),
+(923,NULL,NULL),
+(924,4,9),
+(925,8,8),
+(926,NULL,NULL),
+(927,NULL,NULL),
+(928,NULL,NULL),
+(929,NULL,NULL),
+(930,NULL,NULL),
+(931,NULL,NULL),
+(935,0,7.5),
+(936,NULL,NULL),
+(937,NULL,NULL),
+(938,NULL,NULL),
+(939,NULL,NULL),
+(940,NULL,NULL),
+(941,1,1),
+(942,3,7),
+(943,NULL,NULL),
+(944,NULL,NULL),
+(945,NULL,NULL),
+(947,NULL,NULL),
+(948,NULL,NULL),
+(949,NULL,NULL),
+(950,NULL,NULL),
+(951,NULL,NULL),
+(952,NULL,NULL),
+(953,NULL,NULL),
+(954,NULL,NULL),
+(955,NULL,NULL),
+(956,NULL,NULL),
+(957,NULL,NULL),
+(958,NULL,NULL),
+(959,NULL,NULL),
+(960,NULL,NULL),
+(961,NULL,NULL),
+(962,4,12),
+(963,NULL,NULL),
+(964,NULL,NULL),
+(965,NULL,NULL),
+(966,NULL,NULL),
+(967,NULL,NULL),
+(968,NULL,NULL),
+(969,NULL,NULL),
+(970,NULL,NULL),
+(971,NULL,NULL),
+(972,NULL,NULL),
+(973,NULL,NULL),
+(974,NULL,NULL),
+(975,NULL,NULL),
+(977,NULL,NULL),
+(978,NULL,NULL),
+(979,NULL,NULL),
+(980,NULL,NULL),
+(981,NULL,NULL),
+(982,NULL,NULL),
+(983,NULL,NULL),
+(984,NULL,NULL),
+(985,NULL,NULL),
+(986,NULL,NULL),
+(987,NULL,NULL),
+(988,NULL,NULL),
+(989,NULL,NULL),
+(990,NULL,NULL),
+(991,NULL,NULL),
+(992,NULL,NULL),
+(993,NULL,NULL),
+(994,NULL,NULL),
+(996,NULL,NULL),
+(997,NULL,NULL),
+(999,NULL,NULL),
+(1000,NULL,NULL),
+(1001,NULL,NULL),
+(1003,NULL,NULL),
+(1779,NULL,NULL),
+(1780,NULL,NULL),
+(1881,NULL,NULL),
+(1882,NULL,NULL),
+(1883,NULL,NULL),
+(1884,NULL,NULL),
+(1885,NULL,NULL),
+(1886,NULL,NULL),
+(1887,NULL,NULL),
+(1888,NULL,NULL);