diff options
| -rw-r--r-- | sql/updates/world/master/2022_03_19_00_world_2021_10_01_00_world.sql | 385 |
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); |