1 files changed, 493 insertions, 0 deletions
diff --git a/sql/updates/world/master/2016_11_21_00_world.sql b/sql/updates/world/master/2016_11_21_00_world.sql
new file mode 100644
index 00000000000..863b1cf77b9
--- /dev/null
+++ b/sql/updates/world/master/2016_11_21_00_world.sql
@@ -0,0 +1,493 @@
+DELETE FROM `creature_model_info` WHERE `DisplayID` IN (39, 140, 268, 483, 580, 1016, 1017, 1018, 1213, 6810, 10819, 15501, 15589, 16196, 16623, 18147, 18163, 19018, 19286, 21906, 22167, 22253, 22587, 22588, 22106, 22254, 22640, 22658, 23816, 24815, 24824, 25087, 25101, 25185, 25186, 25720, 25721, 26128, 26129, 26130, 26142, 26144, 26147, 26149, 26151, 26152, 26153, 26855, 28141, 28372, 28816, 29065, 29372, 38357, 38915, 39063, 39064, 40054, 45027, 45575, 45919, 46038, 46348, 47567, 54299, 56193, 59165, 59580, 61609, 62172, 62181, 62206, 62208, 62209, 62210, 62211, 62212, 62214, 62215, 62229, 62383, 62538, 62561, 62608, 63725, 64360, 65025, 70810, 71040, 65819, 65635, 65848, 66358, 67606, 68614, 69319, 70826, 70827, 70915, 71750);
+
+DELETE FROM `creature_model_info` WHERE `DisplayID` IN (72711, 72728, 73014, 73095, 73116, 73153, 73156, 73159, 73160, 73161, 73162, 73164, 73165, 73193, 73194, 73195, 73196, 73197, 73198, 73199, 73201, 73202, 73203, 73235, 73236, 73237, 73244, 73245, 73247, 73248, 73249, 73250, 73251, 73252, 73253, 73254, 73255, 73256, 73257, 73261, 73262, 73271, 73284, 73289, 73299, 73301, 73302, 73303, 73304, 73305, 73306, 73307, 73308, 73309, 73310, 73311, 73312, 73313, 73314, 73323, 73324, 73325, 73326, 73334, 73336, 73337, 73338, 73339, 73341, 73342, 73343, 73344, 73346, 73348, 73354, 73355, 73356, 73357, 73358, 73359, 73370, 73372, 73393, 73417, 73418, 73419, 73420, 73457, 73458, 73461, 73462, 73464, 73465, 73466, 73467, 73468, 73469, 73470, 73471, 73472, 73474, 73482, 73483, 73484, 73485, 73486, 73487, 73488, 73492, 73520, 73521, 73525, 73528, 73533, 73534, 73535, 73537, 73538, 73539, 73540, 73541, 73542, 73543, 73544, 73545, 73546, 73547, 73549, 73580, 73581, 73591, 73592, 73595, 73598, 73601, 73602, 73603, 73604, 73607, 73608, 73612, 73613, 73626, 73627, 73628, 73629, 73630, 73631, 73632, 73633, 73634, 73635, 73642, 73643, 73644, 73645, 73646, 73647, 73648, 73649, 73650, 73659, 73661, 73662, 73663, 73671, 73673, 73675, 73676, 73684, 73689, 73690, 73691, 73692, 73693, 73694, 73695, 73696, 73697, 73699, 73704, 73705, 73706, 73707, 73708, 73709, 73721, 73724, 73727, 73728, 73729, 73730, 73731, 73732, 73734, 73745, 73746, 73747, 73748, 73753, 73754, 73755, 73756, 73759, 73764, 73779, 73790, 73795, 73796, 73797, 73802, 73803, 73804, 73807, 73808, 73809, 73810, 73811, 73812, 73813, 73814, 73815, 73816, 73818, 73819, 73820, 73822, 73825, 73830, 73831, 73833, 73834, 73835, 73836, 73837, 73838, 73839, 73840, 73847, 73848, 73849, 73850, 73853, 73854, 73855, 73856, 73857, 73858, 73859, 73862, 73864, 73866, 73867, 73868, 73869, 73873, 73874, 73876, 73877, 73878, 73879, 73880, 73883, 73884, 73885, 73886, 73890, 73891, 73892, 73893, 73894, 73895, 73896, 73897, 73898, 73899, 73913, 73914, 73915, 73916, 73917, 73918, 73919, 73920, 73921, 73922, 73923, 73924, 73925, 73926, 73934, 73937, 73939, 73940, 73944, 73946, 73947, 73951, 73954, 73956, 73957, 73958, 73960, 73967, 73974, 73975, 73986, 73989, 73990, 73991, 73992, 73993, 73994, 73995, 73996, 73997, 73998, 73999, 74002, 74015, 74021, 74024, 74025, 74026, 74027, 74028, 74029, 74030, 74032, 74033, 74035, 74036, 74037, 74038, 74039, 74040, 74041, 74046, 74047, 74048, 74065, 74075, 74089, 74091, 74092, 74102, 74103, 74104, 74106, 74108, 74111, 74112, 74113, 74114, 74115, 74116, 74117, 74120, 74121, 74122, 74123, 74124, 74125, 74126, 74127, 74128, 74158, 74164, 74166, 74168, 74170, 74171, 74172, 74173, 74174, 74175, 74189, 74192, 74194, 74199, 74200, 74219, 74223, 74226, 74229, 74230, 74231, 74232, 74233, 74234, 74235, 74236, 74237, 74238, 74239, 74240, 74241, 74244, 74245, 74247, 74248, 74249, 74250, 74251, 74252, 74254, 74255, 74256, 74257, 74258, 74259, 74260, 74261, 74266, 74286, 74291, 74294, 74295, 74296, 74298, 74300, 74301, 74302, 74323, 74333, 74334, 74335, 74336, 74348, 74351, 74353, 74354, 74357, 74358, 74362, 74363, 74364, 74365, 74380, 74381, 74382, 74391, 74392, 74393, 74394, 74402, 74403, 74405, 74406, 74407, 74408, 74420, 74421, 74422, 74423, 74425, 74435, 74437, 74441, 74462, 74463, 74484, 74494, 74512, 74516, 74517, 74518, 74519, 74526, 74537, 74558, 74560, 74561, 74562, 74563, 74570, 74575, 74576, 74600, 74601, 74613, 74615, 74631, 74659, 74666, 74667, 74669, 74670, 74777);
+INSERT INTO `creature_model_info` (`DisplayID`) VALUES
+(72711),
+(72728),
+(73014),
+(73095),
+(73116),
+(73153),
+(73156),
+(73159),
+(73160),
+(73161),
+(73162),
+(73164),
+(73165),
+(73193),
+(73194),
+(73195),
+(73196),
+(73197),
+(73198),
+(73199),
+(73201),
+(73202),
+(73203),
+(73235),
+(73236),
+(73237),
+(73244),
+(73245),
+(73247),
+(73248),
+(73249),
+(73250),
+(73251),
+(73252),
+(73253),
+(73254),
+(73255),
+(73256),
+(73257),
+(73261),
+(73262),
+(73271),
+(73284),
+(73289),
+(73299),
+(73301),
+(73302),
+(73303),
+(73304),
+(73305),
+(73306),
+(73307),
+(73308),
+(73309),
+(73310),
+(73311),
+(73312),
+(73313),
+(73314),
+(73323),
+(73324),
+(73325),
+(73326),
+(73334),
+(73336),
+(73337),
+(73338),
+(73339),
+(73341),
+(73342),
+(73343),
+(73344),
+(73346),
+(73348),
+(73354),
+(73355),
+(73356),
+(73357),
+(73358),
+(73359),
+(73370),
+(73372),
+(73393),
+(73417),
+(73418),
+(73419),
+(73420),
+(73457),
+(73458),
+(73461),
+(73462),
+(73464),
+(73465),
+(73466),
+(73467),
+(73468),
+(73469),
+(73470),
+(73471),
+(73472),
+(73474),
+(73482),
+(73483),
+(73484),
+(73485),
+(73486),
+(73487),
+(73488),
+(73492),
+(73520),
+(73521),
+(73525),
+(73528),
+(73533),
+(73534),
+(73535),
+(73537),
+(73538),
+(73539),
+(73540),
+(73541),
+(73542),
+(73543),
+(73544),
+(73545),
+(73546),
+(73547),
+(73549),
+(73580),
+(73581),
+(73591),
+(73592),
+(73595),
+(73598),
+(73601),
+(73602),
+(73603),
+(73604),
+(73607),
+(73608),
+(73612),
+(73613),
+(73626),
+(73627),
+(73628),
+(73629),
+(73630),
+(73631),
+(73632),
+(73633),
+(73634),
+(73635),
+(73642),
+(73643),
+(73644),
+(73645),
+(73646),
+(73647),
+(73648),
+(73649),
+(73650),
+(73659),
+(73661),
+(73662),
+(73663),
+(73671),
+(73673),
+(73675),
+(73676),
+(73684),
+(73689),
+(73690),
+(73691),
+(73692),
+(73693),
+(73694),
+(73695),
+(73696),
+(73697),
+(73699),
+(73704),
+(73705),
+(73706),
+(73707),
+(73708),
+(73709),
+(73721),
+(73724),
+(73727),
+(73728),
+(73729),
+(73730),
+(73731),
+(73732),
+(73734),
+(73745),
+(73746),
+(73747),
+(73748),
+(73753),
+(73754),
+(73755),
+(73756),
+(73759),
+(73764),
+(73779),
+(73790),
+(73795),
+(73796),
+(73797),
+(73802),
+(73803),
+(73804),
+(73807),
+(73808),
+(73809),
+(73810),
+(73811),
+(73812),
+(73813),
+(73814),
+(73815),
+(73816),
+(73818),
+(73819),
+(73820),
+(73822),
+(73825),
+(73830),
+(73831),
+(73833),
+(73834),
+(73835),
+(73836),
+(73837),
+(73838),
+(73839),
+(73840),
+(73847),
+(73848),
+(73849),
+(73850),
+(73853),
+(73854),
+(73855),
+(73856),
+(73857),
+(73858),
+(73859),
+(73862),
+(73864),
+(73866),
+(73867),
+(73868),
+(73869),
+(73873),
+(73874),
+(73876),
+(73877),
+(73878),
+(73879),
+(73880),
+(73883),
+(73884),
+(73885),
+(73886),
+(73890),
+(73891),
+(73892),
+(73893),
+(73894),
+(73895),
+(73896),
+(73897),
+(73898),
+(73899),
+(73913),
+(73914),
+(73915),
+(73916),
+(73917),
+(73918),
+(73919),
+(73920),
+(73921),
+(73922),
+(73923),
+(73924),
+(73925),
+(73926),
+(73934),
+(73937),
+(73939),
+(73940),
+(73944),
+(73946),
+(73947),
+(73951),
+(73954),
+(73956),
+(73957),
+(73958),
+(73960),
+(73967),
+(73974),
+(73975),
+(73986),
+(73989),
+(73990),
+(73991),
+(73992),
+(73993),
+(73994),
+(73995),
+(73996),
+(73997),
+(73998),
+(73999),
+(74002),
+(74015),
+(74021),
+(74024),
+(74025),
+(74026),
+(74027),
+(74028),
+(74029),
+(74030),
+(74032),
+(74033),
+(74035),
+(74036),
+(74037),
+(74038),
+(74039),
+(74040),
+(74041),
+(74046),
+(74047),
+(74048),
+(74065),
+(74075),
+(74089),
+(74091),
+(74092),
+(74102),
+(74103),
+(74104),
+(74106),
+(74108),
+(74111),
+(74112),
+(74113),
+(74114),
+(74115),
+(74116),
+(74117),
+(74120),
+(74121),
+(74122),
+(74123),
+(74124),
+(74125),
+(74126),
+(74127),
+(74128),
+(74158),
+(74164),
+(74166),
+(74168),
+(74170),
+(74171),
+(74172),
+(74173),
+(74174),
+(74175),
+(74189),
+(74192),
+(74194),
+(74199),
+(74200),
+(74219),
+(74223),
+(74226),
+(74229),
+(74230),
+(74231),
+(74232),
+(74233),
+(74234),
+(74235),
+(74236),
+(74237),
+(74238),
+(74239),
+(74240),
+(74241),
+(74244),
+(74245),
+(74247),
+(74248),
+(74249),
+(74250),
+(74251),
+(74252),
+(74254),
+(74255),
+(74256),
+(74257),
+(74258),
+(74259),
+(74260),
+(74261),
+(74266),
+(74286),
+(74291),
+(74294),
+(74295),
+(74296),
+(74298),
+(74300),
+(74301),
+(74302),
+(74323),
+(74333),
+(74334),
+(74335),
+(74336),
+(74348),
+(74351),
+(74353),
+(74354),
+(74357),
+(74358),
+(74362),
+(74363),
+(74364),
+(74365),
+(74380),
+(74381),
+(74382),
+(74391),
+(74392),
+(74393),
+(74394),
+(74402),
+(74403),
+(74405),
+(74406),
+(74407),
+(74408),
+(74420),
+(74421),
+(74422),
+(74423),
+(74425),
+(74435),
+(74437),
+(74441),
+(74462),
+(74463),
+(74484),
+(74494),
+(74512),
+(74516),
+(74517),
+(74518),
+(74519),
+(74526),
+(74537),
+(74558),
+(74560),
+(74561),
+(74562),
+(74563),
+(74570),
+(74575),
+(74576),
+(74600),
+(74601),
+(74613),
+(74615),
+(74631),
+(74659),
+(74666),
+(74667),
+(74669),
+(74670),
+(74777);