DB/Addon: Delete 1026 `creature_addon` rows and overwrite 98 `creature_template_addon` (phase 2.1)

Conversion done with https://gist.github.com/4505135 (C#)
Thanks to Aokromes for the idea

1 files changed, 221 insertions, 0 deletions

diff --git a/sql/updates/world/2013_01_10_04_world_creature_addon.sql b/sql/updates/world/2013_01_10_04_world_creature_addon.sql
new file mode 100644
index 00000000000..74f2356e7a7
--- /dev/null
+++ b/sql/updates/world/2013_01_10_04_world_creature_addon.sql
@@ -0,0 +1,221 @@
+DELETE FROM `creature_addon` WHERE `guid` IN
+(79195, 79207, 79222, 79227, 126407, 126408, 126409, 126410, 126411,
+126412, 71567, 71570, 71575, 71576, 71577, 102518, 102524, 54194, 54195,
+54196, 54197, 54198, 54199, 54209, 54254, 54255, 54256, 54809, 54859,
+55363, 56312, 56313, 56318, 92035, 101717, 101718, 101739, 101742,
+101743, 101744, 101745, 101747, 101751, 101753, 101754, 101755, 101761,
+101762, 101764, 101765, 101766, 101767, 101768, 101769, 101773, 101774,
+101775, 101776, 101778, 101781, 101782, 101783, 101784, 101785, 101786,
+101787, 101788, 101789, 101791, 101792, 101793, 101794, 101795, 101796,
+101797, 126391, 126392, 126393, 126394, 126395, 70671, 70679, 70683,
+70685, 68923, 68924, 68925, 68926, 68927, 68928, 68929, 135402, 135401,
+135400, 135399, 135398, 135397, 135396, 135395, 135394, 135393, 75032,
+75034, 75035, 75036, 75038, 75039, 75041, 75044, 75045, 75046, 75047,
+75048, 75049, 75052, 75054, 75055, 75056, 75057, 75058, 75059, 75062,
+75063, 75069, 75070, 75073, 75074, 75075, 75077, 75078, 75080, 75081,
+75082, 75083, 75084, 75085, 75086, 75087, 75088, 75089, 75091, 75095,
+75096, 75097, 75098, 75102, 73687, 73688, 73690, 73692, 71705, 71706,
+67246, 67247, 133044, 133045, 133046, 133047, 133048, 133049, 133050,
+132870, 132871, 132872, 132873, 132874, 132875, 132876, 132877, 132878,
+132879, 132880, 132881, 132882, 132883, 132884, 132885, 132886, 132887,
+132888, 132889, 132890, 132891, 132892, 132893, 132894, 132895, 132896,
+132897, 132898, 132899, 132900, 132901, 132902, 132903, 132904, 132905,
+132906, 132907, 79345, 79346, 203436, 203437, 203438, 203439, 203440,
+41517, 41518, 41520, 41521, 41522, 41523, 41524, 41525, 41526, 41527,
+41528, 41529, 41530, 41531, 41533, 41534, 41535, 41536, 41537, 41538,
+41539, 41540, 41541, 41542, 41543, 41544, 41545, 41546, 41547, 41548,
+41549, 41550, 41551, 41552, 41553, 41554, 41555, 129911, 129929, 129935,
+71272, 71276, 71277, 71279, 71281, 71282, 65563, 65564, 60256, 60258,
+60271, 60273, 60274, 60277, 60278, 60279, 72457, 72460, 101350, 101351,
+101352, 101353, 101354, 101365, 101366, 101367, 101368, 101369, 101371,
+101372, 101373, 101374, 101375, 101376, 101377, 101378, 101379, 101380,
+101381, 101382, 101383, 101384, 101385, 101386, 101387, 101389, 101390,
+101391, 101392, 101393, 101394, 101395, 101396, 101397, 101398, 101399,
+101402, 101403, 101404, 101405, 101407, 101412, 71189, 71190, 70656,
+70646, 70644, 70643, 70641, 70635, 70633, 70632, 70624, 70623, 70622,
+105663, 105679, 105680, 105697, 105698, 105701, 105703, 105704, 105705,
+105706, 105707, 105708, 105709, 105710, 105724, 105726, 105729, 109729,
+109730, 109731, 71055, 71061, 71064, 82576, 82583, 82584, 82586, 82593,
+82594, 82595, 82598, 28363, 27800, 27798, 27796, 27765, 27728, 27692,
+27691, 27568, 33513, 33514, 33515, 33516, 135432, 135431, 135430,
+135429, 135428, 135427, 28671, 28670, 28669, 28668, 118222, 118223,
+118226, 118227, 118228, 118229, 131095, 131098, 131102, 131104, 71163,
+71166, 71167, 71168, 71169, 71171, 58162, 58167, 58170, 58172, 58173,
+58183, 58187, 58188, 58193, 58194, 31822, 43670, 56612, 135493, 135492,
+135491, 135490, 135488, 135487, 135486, 135485, 135484, 135483, 135482,
+135481, 135480, 135479, 135478, 70835, 70839, 66766, 66777, 67386,
+67388, 67389, 9365, 9363, 9362, 107198, 107199, 132455, 132456, 135606,
+135605, 135604, 135603, 135602, 132650, 132651, 64158, 64159, 64162,
+64163, 64170, 64186, 64191, 64195, 64196, 124849, 124850, 124851,
+124852, 124853, 124854, 124855, 124856, 124857, 124858, 124859, 124860,
+124861, 124862, 124863, 124864, 124865, 124870, 124871, 124872, 124873,
+124874, 124875, 124876, 124877, 124878, 124879, 124880, 124881, 124882,
+60305, 60330, 60331, 60332, 126397, 126398, 126399, 126400, 135426,
+135425, 135424, 135423, 135422, 51560, 51561, 51562, 51563, 51648,
+51826, 52055, 52117, 52118, 52120, 52565, 52566, 52567, 52568, 52569,
+52570, 52571, 52588, 52589, 52590, 52591, 52592, 52593, 84081, 84263,
+84278, 84327, 84595, 84596, 86148, 86151, 86226, 88910, 89436, 89443,
+89907, 89908, 89909, 90198, 90199, 90201, 90220, 90255, 90420, 90424,
+6001, 5999, 5998, 5995, 68142, 68143, 68144, 68151, 68154, 68157, 68162,
+68164, 68166, 68170, 68176, 68177, 68181, 68184, 68185, 69399, 69402,
+69404, 62073, 62074, 62075, 62080, 135421, 135420, 14575, 14574, 97435,
+97436, 97437, 97438, 97439, 97443, 66878, 66879, 123933, 123936, 123937,
+84989, 135438, 135437, 135436, 135435, 135434, 135433, 67912, 67914,
+67915, 67917, 67919, 67920, 67924, 135921, 135922, 135681, 135680,
+135679, 135678, 135677, 135676, 135675, 74885, 74888, 11056, 10920,
+103444, 103474, 135601, 135600, 135599, 135598, 135597, 81249, 81250,
+81349, 123754, 123755, 123756, 123758, 123760, 123768, 123769, 123770,
+123771, 123772, 123773, 123774, 123775, 123776, 123777, 123778, 123779,
+123780, 123781, 123783, 123784, 123785, 123786, 123787, 123788, 123789,
+123790, 123793, 123795, 123796, 123797, 123802, 123803, 123804, 123805,
+123806, 123807, 123809, 123810, 123825, 123826, 7376, 7375, 7374, 7373,
+7372, 6527, 6526, 6525, 6524, 6523, 3348, 3347, 3346, 3345, 39097,
+39124, 39150, 39162, 39169, 39171, 39182, 39193, 39217, 39224, 39225,
+39235, 39236, 39334, 39337, 39404, 39492, 39495, 39502, 39503, 39504,
+39505, 39507, 39508, 39509, 39511, 39692, 39693, 39694, 39695, 39698,
+39700, 39702, 39711, 40588, 40614, 40622, 40746, 40771, 40777, 40803,
+40805, 40808, 40814, 40815, 40817, 40818, 40821, 122419, 122420, 122421,
+122422, 70799, 70800, 84363, 84612, 86147, 86150, 86197, 86383, 89524,
+89526, 89527, 89528, 89529, 89774, 89775, 89776, 89777, 89778, 89779,
+89780, 89781, 89782, 89783, 89791, 89792, 89793, 89794, 89795, 89796,
+89797, 89798, 89810, 89811, 89812, 89813, 89814, 89815, 89816, 89817,
+89818, 89819, 90003, 90004, 90005, 90006, 90010, 90011, 90012, 90013,
+90235, 90325, 90360, 90361, 90363, 90365, 90369, 77395, 77396, 77397,
+77398, 77399, 77400, 77412, 77413, 77415, 77416, 77420, 77421, 77422,
+77423, 77424, 77425, 77431, 77446, 77447, 77454, 77455, 77456, 77457,
+77458, 77459, 77460, 77462, 77464, 77465, 77466, 77467, 77468, 77469,
+77470, 77471, 77472, 77473, 77474, 77475, 77476, 77477, 77478, 82587,
+82591, 82596, 82601, 126401, 126402, 126403, 126404, 126405, 126406,
+43680, 43674, 56326, 57163, 98042, 98043, 128319, 128320, 128321,
+128322, 128323, 128324, 128325, 128326, 128327, 128328, 128329, 128330,
+128331, 128332, 128333, 128334, 128335, 128336, 128337, 128338, 128339,
+128340, 128341, 128342, 128343, 128344, 128345, 128346, 128347, 128348,
+128349, 128350, 135494, 135503, 135502, 135501, 135500, 135499, 135498,
+135497, 135496, 135495, 70697, 70698, 103482, 103483, 103485, 103488,
+58673, 58684, 58685, 72498, 72499, 72502, 58937, 58938, 58939, 58943,
+58946, 58948, 58949, 58952, 58953, 58954, 58955, 135419, 135418, 135417,
+135416, 135415, 135414, 135413, 135412, 135411, 135410, 135409, 135408,
+135407, 135406, 135405, 135404, 135403, 128137, 128138, 128139, 128140,
+128141, 128142, 128143, 128144, 128145, 128146, 128147, 128148, 128149,
+128150, 128151, 128152, 128153, 128154, 128155, 128156, 128157, 128158,
+128159, 128160, 128161, 128162, 128163, 128164, 128165, 128166, 128167,
+128168, 128169, 128170, 202639, 202638, 202637, 135616, 135615, 135614,
+135613, 135612, 135611, 85072, 85071, 85070, 85069, 85068, 85067, 85066,
+85065, 14740, 49852, 132542, 132544, 132545, 132546, 132543, 132539,
+132547, 132540, 132541, 132550, 132548, 132549, 132551, 132552, 68045,
+68057, 68068, 46355, 46356, 46357, 46358, 46359, 46360, 46361, 46362,
+46363, 46364, 46365, 46366, 46367, 46368, 46369, 46370, 46371, 46372,
+46373, 46374, 46375, 46376, 46377, 46378, 46379, 46380, 46381, 46382,
+46383, 46384, 46385, 46386, 46387, 46388, 46389, 46390, 46391, 46392);
+
+DELETE FROM `creature_template_addon` WHERE `entry` IN
+(641, 30682, 20089, 30281, 16117, 28221, 30648, 19755, 19337, 16171,
+21419, 20929, 20140, 18830, 21728, 22986, 636, 18815, 7456, 29038,
+19984, 18272, 17149, 20453, 17467, 19961, 19740, 29036, 24467, 19944,
+16335, 7396, 16177, 18207, 27629, 19952, 16867, 14864, 16459, 19792,
+18595, 18858, 1179, 890, 16482, 21804, 18117, 32498, 17151, 30680,
+16176, 454, 48, 18975, 19415, 17282, 16175, 2738, 18955, 18638, 10928,
+16178, 18912, 17645, 17260, 21405, 1027, 32596, 16481, 11328, 6827,
+10556, 8960, 31070, 19784, 157, 22082, 16334, 30681, 14869, 26645,
+16068, 16460, 19762, 26965, 16912, 20474, 16943, 16174, 16173, 16030,
+17269, 16488, 33229, 15351, 21763, 18952, 3681);
+
+INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `auras`) VALUES
+(641, 0, 0, 0, 4097, 0, ''),
+(30682, 0, 0, 0, 1, 0, '57740'),
+(20089, 0, 0, 0, 4097, 0, '34827'),
+(30281, 0, 0, 1, 257, 0, ''),
+(16117, 0, 0, 0, 4097, 0, ''),
+(28221, 0, 0, 0, 1, 0, ''),
+(30648, 0, 0, 0, 1, 0, '57560'),
+(19755, 0, 0, 0, 4097, 0, ''),
+(19337, 0, 0, 0, 4098, 0, ''),
+(16171, 0, 0, 0, 1, 0, ''),
+(21419, 0, 0, 0, 4097, 0, ''),
+(20929, 0, 0, 0, 4097, 333, ''),
+(20140, 0, 0, 0, 4097, 0, ''),
+(18830, 0, 0, 8, 4097, 0, ''),
+(21728, 0, 0, 0, 1, 0, ''),
+(22986, 0, 0, 0, 1, 0, ''),
+(636, 0, 0, 33554432, 4097, 0, '6408'),
+(18815, 0, 0, 0, 257, 0, ''),
+(7456, 0, 0, 0, 4097, 0, ''),
+(29038, 0, 0, 65536, 1, 0, ''),
+(19984, 0, 0, 2, 4097, 0, ''),
+(18272, 0, 0, 0, 4097, 28, ''),
+(17149, 0, 0, 0, 4097, 0, ''),
+(20453, 0, 0, 0, 4097, 28, ''),
+(17467, 0, 0, 0, 1, 0, ''),
+(19961, 0, 0, 0, 4097, 0, ''),
+(19740, 0, 0, 0, 4097, 27, ''),
+(29036, 0, 0, 0, 1, 0, ''),
+(24467, 0, 0, 7, 0, 0, ''),
+(19944, 0, 0, 2, 4097, 333, ''),
+(16335, 0, 0, 0, 4097, 233, ''),
+(7396, 0, 0, 0, 4097, 0, ''),
+(16177, 0, 0, 0, 1, 0, ''),
+(18207, 0, 0, 8, 4097, 0, ''),
+(27629, 0, 0, 50331648, 0, 0, ''),
+(19952, 0, 0, 0, 4097, 0, '12544'),
+(16867, 0, 0, 0, 4097, 0, ''),
+(14864, 0, 0, 0, 4097, 0, ''),
+(16459, 0, 0, 0, 1, 0, ''),
+(19792, 0, 0, 8, 4097, 0, ''),
+(18595, 0, 0, 0, 4097, 0, ''),
+(18858, 0, 0, 0, 4097, 333, ''),
+(1179, 0, 0, 0, 4097, 0, ''),
+(890, 0, 0, 0, 1, 0, ''),
+(16482, 0, 0, 0, 1, 0, ''),
+(21804, 0, 0, 0, 1, 0, ''),
+(18117, 0, 0, 0, 4097, 0, ''),
+(32498, 0, 0, 0, 1, 0, ''),
+(17151, 0, 0, 0, 4097, 0, ''),
+(30680, 0, 0, 0, 1, 0, '57740'),
+(16176, 0, 0, 0, 1, 0, ''),
+(454, 0, 0, 0, 4097, 0, ''),
+(48, 0, 0, 0, 4097, 0, ''),
+(18975, 0, 0, 0, 4097, 0, ''),
+(19415, 0, 0, 0, 4097, 0, '13864'),
+(17282, 0, 0, 0, 4096, 0, ''),
+(16175, 0, 0, 0, 1, 0, ''),
+(2738, 0, 2410, 0, 4097, 0, ''),
+(18955, 0, 0, 0, 1, 0, ''),
+(18638, 0, 0, 8, 4097, 0, ''),
+(10928, 0, 0, 0, 1, 0, ''),
+(16178, 0, 0, 0, 1, 0, ''),
+(18912, 0, 0, 0, 4097, 0, '35230'),
+(17645, 0, 0, 0, 1, 0, ''),
+(17260, 0, 0, 0, 1, 0, ''),
+(21405, 0, 0, 0, 4097, 173, ''),
+(1027, 0, 0, 0, 4097, 0, ''),
+(32596, 0, 27913, 0, 257, 0, ''),
+(16481, 0, 0, 0, 1, 0, ''),
+(11328, 0, 0, 0, 4097, 0, ''),
+(6827, 0, 0, 0, 1, 0, ''),
+(10556, 0, 0, 0, 4096, 0, ''),
+(8960, 0, 0, 0, 4097, 0, ''),
+(31070, 0, 0, 50331649, 1, 0, ''),
+(19784, 0, 0, 7, 4097, 0, ''),
+(157, 0, 0, 0, 4097, 0, ''),
+(22082, 0, 0, 0, 4097, 333, ''),
+(16334, 0, 0, 0, 4097, 233, ''),
+(30681, 0, 0, 0, 1, 0, '57740'),
+(14869, 0, 0, 0, 4097, 0, ''),
+(26645, 0, 0, 0, 257, 69, ''),
+(16068, 0, 0, 0, 1, 0, ''),
+(16460, 0, 0, 0, 1, 0, ''),
+(19762, 0, 0, 7, 4097, 0, ''),
+(26965, 0, 0, 0, 1, 0, '31261'),
+(16912, 0, 207, 0, 4097, 0, ''),
+(20474, 0, 0, 0, 4097, 0, ''),
+(16943, 0, 0, 0, 4097, 233, ''),
+(16174, 0, 0, 0, 1, 0, ''),
+(16173, 0, 0, 0, 1, 0, ''),
+(16030, 0, 0, 0, 1, 0, ''),
+(17269, 0, 0, 0, 2, 0, ''),
+(16488, 0, 0, 0, 1, 0, ''),
+(33229, 0, 0, 0, 1, 0, ''),
+(15351, 0, 0, 0, 4097, 0, ''),
+(21763, 0, 0, 65536, 1, 0, ''),
+(18952, 0, 0, 0, 4097, 69, ''),
+(3681, 0, 0, 0, 4097, 0, '');