[svn] * Last minute cleanup before the public release

--HG--
branch : trunk
rename : src/bindings/scripts/sql/mangos_full_scripts.sql => src/bindings/scripts/sql/full_scripts.sql
rename : src/bindings/scripts/sql/scriptdev2_structure.sql => src/bindings/scripts/sql/scripts_structure.sql

1 files changed, 0 insertions, 374 deletions

diff --git a/src/bindings/scripts/sql/old/mangos_old_spells.sql b/src/bindings/scripts/sql/old/mangos_old_spells.sql
deleted file mode 100644
index 8419cacd226..00000000000
--- a/src/bindings/scripts/sql/old/mangos_old_spells.sql
+++ /dev/null
@@ -1,374 +0,0 @@
-/* Old spell queries from Scriptdev revision 55. Not supported by scriptdev anylonger */
-/* To be used in ordinary database developement. Can be added in any changeset/revision as database developers sees fit */
-
-UPDATE `creature_template` SET `spell1` = 116 WHERE `entry` = 946;
-UPDATE `creature_template` SET `spell1` = 16415 WHERE `entry` = 4063;
-UPDATE `creature_template` SET `spell1` = 205 WHERE `entry` = 1867;
-UPDATE `creature_template` SET `spell1` = 705 WHERE `entry` = 1915;
-UPDATE `creature_template` SET `spell1` = 145, `spell2` = 134 WHERE `entry` = 1914;
-UPDATE `creature_template` SET `spell1` = 837, `spell2` = 122 WHERE `entry` = 1889;
-UPDATE `creature_template` SET `spell1` = 8406, `spell2` = 865 WHERE `entry` = 314;
-UPDATE `creature_template` SET `spell1` = 6041, `spell2` = 6364 WHERE `entry` = 2570;
-UPDATE `creature_template` SET `spell1` = 8407, `spell2` = 12486 WHERE `entry` = 2567;
-UPDATE `creature_template` SET `spell1` = 6041 WHERE `entry` = 697;
-UPDATE `creature_template` SET `spell1` = 8402, `spell2` = 8423 WHERE `entry` = 1653;
-UPDATE `creature_template` SET `spell1` = 8402 WHERE `entry` = 1562;
-UPDATE `creature_template` SET `spell1` = 7641, `spell2` = 11707 WHERE `entry` = 1564;
-UPDATE `creature_template` SET `spell1` = 1106 WHERE `entry` = 3218;
-UPDATE `creature_template` SET `spell1` = 837 WHERE `entry` = 2591;
-UPDATE `creature_template` SET `spell1` = 837 WHERE `entry` = 2255;
-UPDATE `creature_template` SET `spell1` = 205 WHERE `entry` = 1539;
-UPDATE `creature_template` SET `spell1` = 15264, `spell2` = 6060, `spell3` = 988 WHERE `entry` = 4299;
-UPDATE `creature_template` SET `spell1` = 984, `spell2` = 1026 WHERE `entry` = 4296;
-UPDATE `creature_template` SET `spell1` = 8438, `spell2` = 2601 WHERE `entry` = 4300;
-UPDATE `creature_template` SET `spell1` = 1088, `spell2` = 992 WHERE `entry` = 533;
-UPDATE `creature_template` SET `spell1` = 7322 WHERE `entry` = 203;
-UPDATE `creature_template` SET `spell1` = 1106, `spell2` = 2941 WHERE `entry` = 2577;
-UPDATE `creature_template` SET `spell1` = 548, `spell2` = 6535 WHERE `entry` = 3273;
-UPDATE `creature_template` SET `spell1` = 529 WHERE `entry` = 1183;
-UPDATE `creature_template` SET `spell1` = 992, `spell2` = 705 WHERE `entry` = 436;
-UPDATE `creature_template` SET `spell1` = 5177 WHERE `entry` = 7235;
-UPDATE `creature_template` SET `spell1` = 5177 WHERE `entry` = 2012;
-UPDATE `creature_template` SET `spell1` = 403, `spell2` = 770 WHERE `entry` = 1397;
-UPDATE `creature_template` SET `spell1` = 2136 WHERE `entry` = 1174;
-UPDATE `creature_template` SET `spell1` = 143 WHERE `entry` = 2018;
-UPDATE `creature_template` SET `spell1` =  915, `spell2` =  2606 WHERE `entry` =  1399;
-UPDATE `creature_template` SET `spell1` =  915, `spell2` =  8293 WHERE `entry` =  3783;
-UPDATE `creature_template` SET `spell1` =  984 WHERE `entry` =  3732;
-UPDATE `creature_template` SET `spell1` =  13480 WHERE `entry` =  3725;
-UPDATE `creature_template` SET `spell1` =  13480 WHERE `entry` =  3728;
-UPDATE `creature_template` SET `spell1` =  9672, `spell2` =  7101 WHERE `entry` =  3662;
-UPDATE `creature_template` SET `spell1` =  18089 WHERE `entry` =  2207;
-UPDATE `creature_template` SET `spell1` =  8402, `spell2` =  10215 WHERE `entry` =  7026;
-UPDATE `creature_template` SET `spell1` =  11659, `spell2` =  8402 WHERE `entry` =  7028;
-UPDATE `creature_template` SET `spell1` =  7918, `spell2` =  6685 WHERE `entry` =  7038;
-UPDATE `creature_template` SET `spell1` = 676, `spell2` = 53, `spell3` = 0 WHERE `entry` = 6866;
-UPDATE `creature_template` SET `spell1` = 53, `spell2` = 0, `spell3` = 0 WHERE `entry` = 122;
-UPDATE `creature_template` SET `spell1` = 71, `spell2` = 1671 WHERE `entry` = 449;
-UPDATE `creature_template` SET `spell1` = 6554 WHERE `entry` = 121;
-UPDATE `creature_template` SET `spell1` = 53 WHERE `entry` = 590;
-UPDATE `creature_template` SET `spell1` = 12166 WHERE `entry` = 3232;
-UPDATE `creature_template` SET `spell1` = 403 WHERE `entry` = 2953;
-UPDATE `creature_template` SET `spell1` = 3385 WHERE `entry` = 2954;
-UPDATE `creature_template` SET `spell1` = 15657, `spell2` = 17230, `spell3` = 16509, `spell4` = 0 WHERE `entry` = 1707;
-UPDATE `creature_template` SET `spell1` = 6253, `spell2` = 16244, `spell3` = 8242, `spell4` = 16509 WHERE `entry` = 1711;
-UPDATE `creature_template` SET `spell1` = 6547, `spell2` = 2590, `spell3` = 6253 WHERE `entry` = 1708;
-UPDATE `creature_template` SET `spell1` = 11554, `spell2` = 8242, `spell3` = 6253 WHERE `entry` = 1715;
-UPDATE `creature_template` SET `spell1` = 1768, `spell2` = 17230, `spell3` = 16509 WHERE `entry` = 1706;
-UPDATE `creature_template` SET `spell1` = 5115 WHERE `entry` = 1729;
-UPDATE `creature_template` SET `spell1` = 9915 WHERE `entry` = 1732;
-UPDATE `creature_template` SET `spell1` = 143 WHERE `entry` = 1726;
-UPDATE `creature_template` SET `spell1` = 143 WHERE `entry` = 619;
-UPDATE `creature_template` SET `spell1` = 6660 WHERE `entry` = 657;
-UPDATE `creature_template` SET `spell1` = 6660, `spell2` = 6685 WHERE `entry` = 4417;
-UPDATE `creature_template` SET `spell1` = 6685 WHERE `entry` = 598;
-UPDATE `creature_template` SET `spell1` = 6016 WHERE `entry` = 4416;
-UPDATE `creature_template` SET `spell1` = 5115, `spell2` = 6435 WHERE `entry` = 594;
-UPDATE `creature_template` SET `spell1` = 9915 WHERE `entry` = 634;
-UPDATE `creature_template` SET `spell1` = 205 WHERE `entry` = 1725;
-UPDATE `creature_template` SET `spell1` = 133, `spell2` = 205, `spell3` = 113 WHERE `entry` = 4418;
-UPDATE `creature_template` SET `spell1` = 6136, `spell2` = 116 WHERE `entry` = 474;
-UPDATE `creature_template` SET `spell1` = 3140, `spell2` = 12486, `spell3` = 3443 WHERE `entry` = 910;
-UPDATE `creature_template` SET `spell1` = 744, `spell2` = 7992, `spell3` = 2590 WHERE `entry` = 909;
-UPDATE `creature_template` SET `spell1` = 8646 WHERE `entry` = 116;
-UPDATE `creature_template` SET `spell1` = 53 WHERE `entry` = 504;
-UPDATE `creature_template` SET `spell1` = 2764 WHERE `entry` = 95;
-UPDATE `creature_template` SET `spell1` = 53, `spell2` = 133 WHERE `entry` = 94;
-UPDATE `creature_template` SET `spell1` = 168 WHERE `entry` = 589;
-UPDATE `creature_template` SET `spell1` = 8382, `spell2` = 8733 WHERE `entry` = 4819;
-UPDATE `creature_template` SET `spell1` = 6145, `spell2` = 71, `spell3` = 22691 WHERE `entry` = 4818;
-UPDATE `creature_template` SET `spell1` = 14109, `spell2` = 3358, `spell3` = 8733, `spell4` = 12024 WHERE `entry` = 4820;
-UPDATE `creature_template` SET `spell1` = 7357 WHERE `entry` = 4359;
-UPDATE `creature_template` SET `spell1` = 7357 WHERE `entry` = 1024;
-UPDATE `creature_template` SET `spell1` = 1777, `spell2` = 6533 WHERE `entry` = 1028;
-UPDATE `creature_template` SET `spell1` = 10177 WHERE `entry` = 1418;
-UPDATE `creature_template` SET `spell1` = 744, `spell2` = 1707 WHERE `entry` = 1026;
-UPDATE `creature_template` SET `spell1` = 7372, `spell2` = 2457 WHERE `entry` = 1027;
-UPDATE `creature_template` SET `spell1` = 15869 WHERE `entry` = 1029;
-UPDATE `creature_template` SET `spell1` = 7357 WHERE `entry` = 747;
-UPDATE `creature_template` SET `spell1` = 7357 WHERE `entry` = 171;
-UPDATE `creature_template` SET `spell1` = 7357 WHERE `entry` = 544;
-UPDATE `creature_template` SET `spell1` = 7357 WHERE `entry` = 545;
-UPDATE `creature_template` SET `spell1` = 7357 WHERE `entry` = 578;
-UPDATE `creature_template` SET `spell1` = 744, `spell2` = 865 WHERE `entry` = 127;
-UPDATE `creature_template` SET `spell1` = 13519, `spell2` = 6074 WHERE `entry` = 517;
-UPDATE `creature_template` SET `spell1` = 10277 WHERE `entry` = 458;
-UPDATE `creature_template` SET `spell1` = 7357 WHERE `entry` = 126;
-UPDATE `creature_template` SET `spell1` = 205, `spell2` = 331 WHERE `entry` = 548;
-UPDATE `creature_template` SET `spell1` = 2589 WHERE `entry` = 732;
-UPDATE `creature_template` SET `spell1` = 3368 WHERE `entry` = 46;
-UPDATE `creature_template` SET `spell1` = 6268 WHERE `entry` = 1083;
-UPDATE `creature_template` SET `spell1` = 3393 WHERE `entry` = 422;
-UPDATE `creature_template` SET `spell1` = 3288 WHERE `entry` = 1011;
-UPDATE `creature_template` SET `spell1` = 8016 WHERE `entry` = 1008;
-UPDATE `creature_template` SET `spell1` = 8016 WHERE `entry` = 1007;
-UPDATE `creature_template` SET `spell1` = 205 WHERE `entry` = 1009;
-UPDATE `creature_template` SET `spell1` = 547, `spell2` = 548 WHERE `entry` = 1013;
-UPDATE `creature_template` SET `spell1` = 744 WHERE `entry` = 434;
-UPDATE `creature_template` SET `spell1` = 3150 WHERE `entry` = 433;
-UPDATE `creature_template` SET `spell1` = 6205 WHERE `entry` = 432;
-UPDATE `creature_template` SET `spell1` = 705 WHERE `entry` = 429;
-UPDATE `creature_template` SET `spell1` = 71, `spell2` = 8380, `spell3` = 8629 WHERE `entry` = 568;
-UPDATE `creature_template` SET `spell1` = 744 WHERE `entry` = 579;
-UPDATE `creature_template` SET `spell1` = 6730, `spell2` = 6016 WHERE `entry` = 448;
-UPDATE `creature_template` SET `spell1` = 6730, `spell2` = 6016 WHERE `entry` = 500;
-UPDATE `creature_template` SET `spell1` = 8016, `spell2` = 0 WHERE `entry` = 123;
-UPDATE `creature_template` SET `spell1` = 1160 WHERE `entry` = 124;
-UPDATE `creature_template` SET `spell1` = 3368 WHERE `entry` = 501;
-UPDATE `creature_template` SET `spell1` = 3237 WHERE `entry` = 1674;
-UPDATE `creature_template` SET `spell1` = 3237 WHERE `entry` = 1772;
-UPDATE `creature_template` SET `spell1` = 3237, `spell2` = 695 WHERE `entry` = 1773;
-UPDATE `creature_template` SET `spell1` = 3237 WHERE `entry` = 1939;
-UPDATE `creature_template` SET `spell1` = 3237 WHERE `entry` = 1940;
-UPDATE `creature_template` SET `spell1` = 3237 WHERE `entry` = 1942;
-UPDATE `creature_template` SET `spell1` = 3237 WHERE `entry` = 1944;
-UPDATE `creature_template` SET `spell1` = 2480 WHERE `entry` = 3112;
-UPDATE `creature_template` SET `spell1` = 5280 WHERE `entry` = 3111;
-UPDATE `creature_template` SET `spell1` = 3248 WHERE `entry` = 3114;
-UPDATE `creature_template` SET `spell1` = 6950, `spell2` = 774 WHERE `entry` = 3113;
-UPDATE `creature_template` SET `spell1` = 548, `spell2` = 8045, `spell3` = 8052 WHERE `entry` = 3269;
-UPDATE `creature_template` SET `spell1` = 594, `spell2` = 8092, `spell3` = 2052 WHERE `entry` = 3458;
-UPDATE `creature_template` SET `spell1` = 594, `spell2` = 598, `spell3` = 8102, `spell4` = 6074 WHERE `entry` = 3271;
-UPDATE `creature_template` SET `spell1` = 1978, `spell2` = 3044 WHERE `entry` = 3265;
-UPDATE `creature_template` SET `spell1` = 13446, `spell2` = 12323, `spell3` = 13443 WHERE `entry` = 3459;
-UPDATE `creature_template` SET `spell1` = 22356 WHERE `entry` = 3267;
-UPDATE `creature_template` SET `spell1` = 3427 WHERE `entry` = 712;
-UPDATE `creature_template` SET `spell1` = 5164 WHERE `entry` = 446;
-UPDATE `creature_template` SET `spell1` = 331, `spell2` = 548 WHERE `entry` = 430;
-UPDATE `creature_template` SET `spell1` = 7919 WHERE `entry` = 424;
-UPDATE `creature_template` SET `spell1` = 3148 WHERE `entry` = 1115;
-UPDATE `creature_template` SET `spell1` = 5164 WHERE `entry` = 1117;
-UPDATE `creature_template` SET `spell1` = 53 WHERE `entry` = 1116;
-UPDATE `creature_template` SET `spell1` = 5164 WHERE `entry` = 1118;
-UPDATE `creature_template` SET `spell1` = 10277 WHERE `entry` = 1162;
-UPDATE `creature_template` SET `spell1` = 529 WHERE `entry` = 1166;
-UPDATE `creature_template` SET `spell1` = 1776 WHERE `entry` = 1163;
-UPDATE `creature_template` SET `spell1` = 11976 WHERE `entry` = 1164;
-UPDATE `creature_template` SET `spell1` = 331 WHERE `entry` = 1197;
-UPDATE `creature_template` SET `spell1` = 2121 WHERE `entry` = 1165;
-UPDATE `creature_template` SET `spell1` = 7405, `spell2` = 71 WHERE `entry` = 1167;
-UPDATE `creature_template` SET `spell1` = 11660, `spell2` = 17926, `spell3` = 6215, `spell4` = 11672 WHERE `entry` = 1789;
-UPDATE `creature_template` SET `spell1` = 348, `spell2` = 686 WHERE `entry` = 4473;
-UPDATE `creature_template` SET `spell1` = 15580, `spell2` = 15613, `spell3` = 23600, `spell4` = 16406 WHERE `entry` = 10391;
-UPDATE `creature_template` SET `spell1` = 3416 WHERE `entry` = 531;
-UPDATE `creature_template` SET `spell1` = 7369 WHERE `entry` = 1783;
-UPDATE `creature_template` SET `spell1` = 838 WHERE `entry` = 7341;
-UPDATE `creature_template` SET `spell1` = 15580, `spell2` = 15613, `spell3` = 16406 WHERE `entry` = 10390;
-UPDATE `creature_template` SET `spell1` = 9734, `spell2` = 6074 WHERE `entry` = 787;
-UPDATE `creature_template` SET `spell1` = 7322, `spell2` = 12486 WHERE `entry` = 203;
-UPDATE `creature_template` SET `spell1` = 7992 WHERE `entry` = 1110;
-UPDATE `creature_template` SET `spell1` = 17312, `spell2` = 992, `spell3` = 984 WHERE `entry` = 7340;
-UPDATE `creature_template` SET `spell1` = 22940, `spell2` = 1411 WHERE `entry` = 1784;
-UPDATE `creature_template` SET `spell1` = 705, `spell2` = 1014 WHERE `entry` = 7342;
-UPDATE `creature_template` SET `spell1` = 8699 WHERE `entry` = 785;
-UPDATE `creature_template` SET `spell1` = 7373 WHERE `entry` = 48;
-UPDATE `creature_template` SET `spell1` = 19644, `spell2` = 21949, `spell3` = 19642 WHERE `entry` = 6488;
-UPDATE `creature_template` SET `spell1` = 10179, `spell2` = 22645, `spell3` = 13009, `spell4` = 12556 WHERE `entry` = 7358;
-UPDATE `creature_template` SET `spell1` = 10148, `spell2` = 12470 WHERE `entry` = 7357;
-UPDATE `creature_template` SET `spell1` = 12947, `spell2` = 12946 WHERE `entry` = 7356;
-UPDATE `creature_template` SET `spell1` = 12255, `spell2` = 12252, `spell3` = 12254 WHERE `entry` = 7355;
-UPDATE `creature_template` SET `spell1` = 10892, `spell2` = 11659 WHERE `entry` = 7354;
-UPDATE `creature_template` SET `spell1` = 21667, `spell2` = 21331, `spell3` = 21793 WHERE `entry` = 12225;
-UPDATE `creature_template` SET `spell1` = 21080, `spell2` = 8817 WHERE `entry` = 12236;
-UPDATE `creature_template` SET `spell1` = 24375, `spell2` = 15580 WHERE `entry` = 12237;
-UPDATE `creature_template` SET `spell1` = 21909, `spell2` = 21832, `spell3` = 19128, `spell4` = 21869 WHERE `entry` = 12201;
-UPDATE `creature_template` SET `spell1` = 21911, `spell2` = 15584, `spell3` = 21749 WHERE `entry` = 12258;
-UPDATE `creature_template` SET `spell1` = 21833, `spell2` = 22334 WHERE `entry` = 13601;
-UPDATE `creature_template` SET `spell1` = 21687, `spell2` = 21547, `spell3` = 21707 WHERE `entry` = 13282;
-UPDATE `creature_template` SET `spell1` = 9770, `spell2` = 16145, `spell3` = 1604, `spell4` = 9776 WHERE `entry` = 6206;
-UPDATE `creature_template` SET `spell1` = 9770, `spell2` = 1604, `spell3` = 12540 WHERE `entry` = 6208;
-UPDATE `creature_template` SET `spell1` = 10851 WHERE `entry` = 6209;
-UPDATE `creature_template` SET `spell1` = 1604, `spell2` = 6409, `spell3` = 3420 WHERE `entry` = 6215;
-UPDATE `creature_template` SET `spell1` = 9459, `spell2` = 1604, `spell3` = 10341, `spell4` = 11638 WHERE `entry` = 6219;
-UPDATE `creature_template` SET `spell1` = 16169, `spell2` = 5568, `spell3` = 10887 WHERE `entry` = 6229;
-UPDATE `creature_template` SET `spell1` = 3053, `spell2` = 16412 WHERE `entry` = 6228;
-UPDATE `creature_template` SET `spell1` = 11082, `spell2` = 11085, `spell3` = 11084 WHERE `entry` = 6235;
-UPDATE `creature_template` SET `spell1` = 1604 WHERE `entry` = 7361;
-UPDATE `creature_template` SET `spell1` = 6660, `spell2` = 8858 WHERE `entry` = 6407;
-UPDATE `creature_template` SET `spell1` = 8211, `spell2` = 10341, `spell3` = 1604, `spell4` = 9459 WHERE `entry` = 6220;
-UPDATE `creature_template` SET `spell1` = 10341, `spell2` = 1604, `spell3` = 9459 WHERE `entry` = 6218;
-UPDATE `creature_template` SET `spell1` = 1604, `spell2` = 11264, `spell3` = 12024 WHERE `entry` = 7603;
-UPDATE `creature_template` SET `spell1` = 6660, `spell2` = 2643, `spell3` = 5116 WHERE `entry` = 6223;
-UPDATE `creature_template` SET `spell1` = 13398, `spell2` = 1604, `spell3` = 12024 WHERE `entry` = 6222;
-UPDATE `creature_template` SET `spell1` = 11820, `spell2` = 1604 WHERE `entry` = 6234;
-UPDATE `creature_template` SET `spell1` = 1604 WHERE `entry` = 6233;
-UPDATE `creature_template` SET `spell1` = 11306, `spell2` = 10733 WHERE `entry` = 6226;
-UPDATE `creature_template` SET `spell1` = 22519, `spell2` = 11264 WHERE `entry` = 6227;
-UPDATE `creature_template` SET `spell1` = 10346, `spell2` = 1604, `spell3` = 17174 WHERE `entry` = 6225;
-UPDATE `creature_template` SET `spell1` = 6533, `spell2` = 1604, `spell3` = 11820, `spell4` = 11084 WHERE `entry` = 6230;
-UPDATE `creature_template` SET `spell1` = 10341, `spell2` = 9459 WHERE `entry` = 7079;
-UPDATE `creature_template` SET `spell1` = 22689, `spell2` = 22662, `spell3` = 19319 WHERE `entry` = 11492;
-UPDATE `creature_template` SET `spell1` = 15708, `spell2` = 23511 WHERE `entry` = 14325;
-UPDATE `creature_template` SET `spell1` = 10947, `spell2` = 10151 WHERE `entry` = 14324;
-UPDATE `creature_template` SET `spell1` = 15580, `spell2` = 15655, `spell3` = 22572, `spell4` = 20691 WHERE `entry` = 14321;
-UPDATE `creature_template` SET `spell1` = 15580, `spell2` = 15655, `spell3` = 20691 WHERE `entry` = 14326;
-UPDATE `creature_template` SET `spell1` = 15580, `spell2` = 17307, `spell3` = 20691 WHERE `entry` = 14323;
-UPDATE `creature_template` SET `spell1` = 22419, `spell2` = 22420, `spell3` = 22421 WHERE `entry` = 13280;
-UPDATE `creature_template` SET `spell1` = 22422 WHERE `entry` = 14122;
-UPDATE `creature_template` SET `spell1` = 5116, `spell2` = 20904, `spell3` = 14290, `spell4` = 14295 WHERE `entry` = 11488;
-UPDATE `creature_template` SET `spell1` = 16128, `spell2` = 15550, `spell3` = 22899 WHERE `entry` = 11496;
-UPDATE `creature_template` SET `spell1` = 22909 WHERE `entry` = 14396;
-UPDATE `creature_template` SET `spell1` = 15708, `spell2` = 24375 WHERE `entry` = 11501;
-UPDATE `creature_template` SET `spell1` = 11668, `spell2` = 14887 WHERE `entry` = 14327;
-UPDATE `creature_template` SET `spell1` = 10984 WHERE `entry` = 14506;
-UPDATE `creature_template` SET `spell1` = 10894, `spell2` = 10947, `spell3` = 18807 WHERE `entry` = 11487;
-UPDATE `creature_template` SET `spell1` = 20691, `spell2` = 22920 WHERE `entry` = 11486;
-UPDATE `creature_template` SET `spell1` = 22424, `spell2` = 10151, `spell3` = 16144 WHERE `entry` = 14354;
-UPDATE `creature_template` SET `spell1` = 20691, `spell2` = 24375 WHERE `entry` = 11498;
-UPDATE `creature_template` SET `spell1` = 15550, `spell2` = 22924, `spell3` = 22994 WHERE `entry` = 11489;
-UPDATE `creature_template` SET `spell1` = 22478, `spell2` = 22651 WHERE `entry` = 11490;
-UPDATE `creature_template` SET `spell1` = 20832, `spell2` = 16102, `spell3` = 15530, `spell4` = 16170 WHERE `entry` = 11444;
-UPDATE `creature_template` SET `spell1` = 22572, `spell2` = 22916 WHERE `entry` = 11450;
-UPDATE `creature_template` SET `spell1` = 13737, `spell2` = 20677, `spell3` = 24317 WHERE `entry` = 11441;
-UPDATE `creature_template` SET `spell1` = 19474 WHERE `entry` = 11457;
-UPDATE `creature_template` SET `spell1` = 22460, `spell2` = 22272 WHERE `entry` = 13197;
-UPDATE `creature_template` SET `spell1`=512, `spell2`=1010, `spell3`=0, `spell4`=0 WHERE `entry`=10415;
-UPDATE `creature_template` SET `spell1`=1096, `spell2`=0, `spell3`=0, `spell4`=0 WHERE `entry`=10917;
-UPDATE `creature_template` SET `spell1`=20603, `spell2`=15398, `spell3`=9256, `spell4`=20741 WHERE `entry`=10813;
-UPDATE `creature_template` SET `spell1`=16565, `spell2`=16867, `spell3`=18327, `spell4`=0 WHERE `entry`=10436;
-UPDATE `creature_template` SET `spell1`=16866, `spell2`=1604, `spell3`=0, `spell4`=0 WHERE `entry`=10697;
-UPDATE `creature_template` SET `spell1`=1604, `spell2`=16866, `spell3`=0, `spell4`=0 WHERE `entry`=10416;
-UPDATE `creature_template` SET `spell1`=17439, `spell2`=15584, `spell3`=1604, `spell4`=0 WHERE `entry`=10394;
-UPDATE `creature_template` SET `spell1`=1604, `spell2`=5884, `spell3`=0, `spell4`=0 WHERE `entry`=11121;
-UPDATE `creature_template` SET `spell1`=16140, `spell2`=1604, `spell3`=0, `spell4`=0 WHERE `entry`=10383;
-UPDATE `creature_template` SET `spell1`=1604, `spell2`=3589, `spell3`=0, `spell4`=0 WHERE `entry`=8530;
-UPDATE `creature_template` SET `spell1`=23382, `spell2`=15615, `spell3`=16496, `spell4`=0 WHERE `entry`=10997;
-UPDATE `creature_template` SET `spell1`=13020, `spell2`=23413, `spell3`=0, `spell4`=0 WHERE `entry`=10425;
-UPDATE `creature_template` SET `spell1`=17293, `spell2`=23462, `spell3`=17274, `spell4`=0 WHERE `entry`=10811;
-UPDATE `creature_template` SET `spell1`=1604, `spell2`=15749, `spell3`=11972, `spell4`=13534 WHERE `entry`=13118;
-UPDATE `creature_template` SET `spell1`=11831, `spell2`=23412, `spell3`=1604, `spell4`=0 WHERE `entry`=10419;
-UPDATE `creature_template` SET `spell1`=5101, `spell2`=17143, `spell3`=13005, `spell4`=0 WHERE `entry`=12337;
-UPDATE `creature_template` SET `spell1`=13005, `spell2`=1604, `spell3`=20005, `spell4`=0 WHERE `entry`=10421;
-UPDATE `creature_template` SET `spell1`=36647, `spell2`=17143, `spell3`=1604, `spell4`=0 WHERE `entry`=10424;
-UPDATE `creature_template` SET `spell1`=15749, `spell2`=33871, `spell3`=1604, `spell4`=0 WHERE `entry`=10418;
-UPDATE `creature_template` SET `spell1`=17445, `spell2`=1604, `spell3`=39077, `spell4`=0 WHERE `entry`=11120;
-UPDATE `creature_template` SET `spell1`=17287, `spell2`=1604, `spell3`=22645, `spell4`=0 WHERE `entry`=10420;
-UPDATE `creature_template` SET `spell1`=22645, `spell2`=17165, `spell3`=22947, `spell4`=0 WHERE `entry`=10426;
-UPDATE `creature_template` SET `spell1`=36033, `spell2`=17145, `spell3`=1604, `spell4`=0 WHERE `entry`=11043;
-UPDATE `creature_template` SET `spell1`=36176, `spell2`=36947, `spell3`=1604, `spell4`=0 WHERE `entry`=10423;
-UPDATE `creature_template` SET `spell1`=38094, `spell2`=1604, `spell3`=6788, `spell4`=0 WHERE `entry`=11054;
-UPDATE `creature_template` SET `spell1`=15451, `spell2`=16927, `spell3`=16144, `spell4`=15534 WHERE `entry`=10422;
-UPDATE `creature_template` SET `spell1`=22412, `spell2`=4962, `spell3`=1604, `spell4`=3589 WHERE `entry`=10413;
-UPDATE `creature_template` SET `spell1`=15471, `spell2`=1604, `spell3`=3589, `spell4`=16430 WHERE `entry`=10412;
-UPDATE `creature_template` SET `spell1`=16401, `spell2`=12023, `spell3`=1604, `spell4`=20812 WHERE `entry`=8556;
-UPDATE `creature_template` SET `spell1`=4629, `spell2`=20549, `spell3`=20812, `spell4`=21949 WHERE `entry`=11859;
-UPDATE `creature_template` SET `spell1`=1604, `spell2`=15530, `spell3`=15531, `spell4`=16458 WHERE `entry`=15607;
-UPDATE `creature_template` SET `spell1`=16388, `spell2`=0, `spell3`=0, `spell4`=0 WHERE `entry`=10557;
-UPDATE `creature_template` SET `spell1`=18200, `spell2`=1604, `spell3`=9791, `spell4`=16458 WHERE `entry`=10407;
-UPDATE `creature_template` SET `spell1`=7964, `spell2`=20712, `spell3`=1604, `spell4`=23511 WHERE `entry`=11058;
-UPDATE `creature_template` SET `spell1`=16249, `spell2`=16143, `spell3`=16449, `spell4`=0 WHERE `entry`=11136;
-UPDATE `creature_template` SET `spell1`=22687, `spell2`=1604, `spell3`=0, `spell4`=0 WHERE `entry`=10385;
-UPDATE `creature_template` SET `spell1`=12538, `spell2`=15608, `spell3`=16172, `spell4`=1604 WHERE `entry`=10406;
-UPDATE `creature_template` SET `spell1`=17286, `spell2`=1604, `spell3`=20830, `spell4`=0 WHERE `entry`=10812;
-UPDATE `creature_template` SET `spell1`=3589, `spell2`=16867, `spell3`=1604, `spell4`=0 WHERE `entry`=8541;
-UPDATE `creature_template` SET `spell1`=17685, `spell2`=18663, `spell3`=19643, `spell4`=20812 WHERE `entry`=16101;
-UPDATE `creature_template` SET `spell1`=16793, `spell2`=10887, `spell3`=14099, `spell4`=1604 WHERE `entry`=10435;
-UPDATE `creature_template` SET `spell1`=15850, `spell2`=16249, `spell3`=20743, `spell4`=16869 WHERE `entry`=10438;
-UPDATE `creature_template` SET `spell1`=12734, `spell2`=16172, `spell3`=1604, `spell4`=6788 WHERE `entry`=11032;
-UPDATE `creature_template` SET `spell1`=16143, `spell2`=1604, `spell3`=15043, `spell4`=0 WHERE `entry`=10382;
-UPDATE `creature_template` SET `spell1`=1604, `spell2`=6788, `spell3`=0, `spell4`=0 WHERE `entry`=11197;
-UPDATE `creature_template` SET `spell1`=1604, `spell2`=6788, `spell3`=0, `spell4`=0 WHERE `entry`=11030;
-UPDATE `creature_template` SET `spell1`=5568, `spell2`=17307, `spell3`=1604, `spell4`=6788 WHERE `entry`=10439;
-UPDATE `creature_template` SET `spell1`=19813, `spell2`=4283, `spell3`=0, `spell4`=0 WHERE `entry`=11658;
-UPDATE `creature_template` SET `spell1`=19393, `spell2`=0, `spell3`=0, `spell4`=0 WHERE `entry`=11668;
-UPDATE `creature_template` SET `spell1`=25787, `spell2`=0, `spell3`=0, `spell4`=0 WHERE `entry`=12101;
-UPDATE `creature_template` SET `spell1`=19364, `spell2`=19365, `spell3`=19369, `spell4`=19367 WHERE `entry`=11673;
-UPDATE `creature_template` SET `spell1`=4283, `spell2`=19813, `spell3`=0, `spell4`=0 WHERE `entry`=11659;
-UPDATE `creature_template` SET `spell1`=20228, `spell2`=0, `spell3`=0, `spell4`=0 WHERE `entry`=12143;
-UPDATE `creature_template` SET `spell1`=20203, `spell2`=0, `spell3`=0, `spell4`=0 WHERE `entry`=11669;
-UPDATE `creature_template` SET `spell1`=24668, `spell2`=23952, `spell3`=10960, `spell4`=0 WHERE `entry`=11663;
-UPDATE `creature_template` SET `spell1`=23952, `spell2`=20294, `spell3`=0, `spell4`=0 WHERE `entry`=11662;
-UPDATE `creature_template` SET `spell1`=20677, `spell2`=20740, `spell3`=0, `spell4`=0 WHERE `entry`=12119;
-UPDATE `creature_template` SET `spell1`=20623, `spell2`=0, `spell3`=0, `spell4`=0 WHERE `entry`=11664;
-UPDATE `creature_template` SET `spell1`=19778, `spell2`=19771, `spell3`=0, `spell4`=0 WHERE `entry`=11671;
-UPDATE `creature_template` SET `spell1`=21081, `spell2`=19730, `spell3`=0, `spell4`=0 WHERE `entry`=11661;
-UPDATE `creature_template` SET `spell1`=19626, `spell2`=19630, `spell3`=19631, `spell4`=0 WHERE `entry`=11667;
-UPDATE `creature_template` SET `spell1`=19798, `spell2`=19496, `spell3`=0, `spell4`=0 WHERE `entry`=12806;
-UPDATE `creature_template` SET `spell1`=19635, `spell2`=0, `spell3`=0, `spell4`=0 WHERE `entry`=11666;
-UPDATE `creature_template` SET `spell1`=19642, `spell2`=19644, `spell3`=0, `spell4`=0 WHERE `entry`=12100;
-UPDATE `creature_template` SET `spell1`=19641, `spell2`=0, `spell3`=0, `spell4`=0 WHERE `entry`=12076;
-UPDATE `creature_template` SET `spell1`=20294, `spell2`=0, `spell3`=0, `spell4`=0 WHERE `entry`=12099;
-UPDATE `creature_template` SET `spell1`=18108, `spell2`=0, `spell3`=0, `spell4`=0 WHERE `entry`=12265;
-UPDATE `creature_template` SET `spell1`=22689, `spell2`=19319, `spell3`=0, `spell4`=0 WHERE `entry`=11672;
-UPDATE `creature_template` SET `spell1`=35178, `spell2`=15749, `spell3`=0, `spell4`=0 WHERE `entry`=10509;
-UPDATE `creature_template` SET `spell1`=35178, `spell2`=0, `spell3`=0, `spell4`=0 WHERE `entry`=9819;
-UPDATE `creature_template` SET `spell1`=30688, `spell2`=0, `spell3`=0, `spell4`=0 WHERE `entry`=10319;
-UPDATE `creature_template` SET `spell1`=20816, `spell2`=0, `spell3`=0, `spell4`=0 WHERE `entry`=9817;
-UPDATE `creature_template` SET `spell1`=32192, `spell2`=18108, `spell3`=0, `spell4`=0 WHERE `entry`=9818;
-UPDATE `creature_template` SET `spell1`=23462, `spell2`=23341, `spell3`=17274, `spell4`=0 WHERE `entry`=9816;
-UPDATE `creature_template` SET `spell1`=24317, `spell2`=0, `spell3`=0, `spell4`=0 WHERE `entry`=10258;
-UPDATE `creature_template` SET `spell1`=145, `spell2`=0, `spell3`=0, `spell4`=0 WHERE `entry`=10161;
-UPDATE `creature_template` SET `spell1`=0, `spell2`=0, `spell3`=0, `spell4`=0 WHERE `entry`=10683;
-UPDATE `creature_template` SET `spell1`=28725, `spell2`=0, `spell3`=0, `spell4`=0 WHERE `entry`=10264;
-UPDATE `creature_template` SET `spell1`=12461, `spell2`=22591, `spell3`=16172, `spell4`=24317 WHERE `entry`=10899;
-UPDATE `creature_template` SET `spell1`=12461, `spell2`=0, `spell3`=0, `spell4`=0 WHERE `entry`=10317;
-UPDATE `creature_template` SET `spell1`=0, `spell2`=0, `spell3`=0, `spell4`=0 WHERE `entry`=10762;
-UPDATE `creature_template` SET `spell1`=0, `spell2`=0, `spell3`=0, `spell4`=0 WHERE `entry`=10742;
-UPDATE `creature_template` SET `spell1`=30014, `spell2`=32370, `spell3`=0, `spell4`=0 WHERE `entry`=10447;
-UPDATE `creature_template` SET `spell1`=22414, `spell2`=23512, `spell3`=0, `spell4`=0 WHERE `entry`=10442;
-UPDATE `creature_template` SET `spell1`=20691, `spell2`=15589, `spell3`=23931, `spell4`=0 WHERE `entry`=10429;
-UPDATE `creature_template` SET `spell1`=20667, `spell2`=20712, `spell3`=18763, `spell4`=0 WHERE `entry`=10339;
-UPDATE `creature_template` SET `spell1`=11286, `spell2`=0, `spell3`=0, `spell4`=0 WHERE `entry`=10318;
-UPDATE `creature_template` SET `spell1`=23462, `spell2`=25668, `spell3`=0, `spell4`=0 WHERE `entry`=10372;
-UPDATE `creature_template` SET `spell1`=28168, `spell2`=27580, `spell3`=0, `spell4`=0 WHERE `entry`=10371;
-UPDATE `creature_template` SET `spell1`=23462, `spell2`=0, `spell3`=0, `spell4`=0 WHERE `entry`=10083;
-UPDATE `creature_template` SET `spell1`=20741, `spell2`=24668, `spell3`=0, `spell4`=0 WHERE `entry`=10162;
-UPDATE `creature_template` SET `spell1`=17883, `spell2`=16785, `spell3`=0, `spell4`=0 WHERE `entry`=10430;
-UPDATE `creature_template` SET `spell1`=23462, `spell2`=20691, `spell3`=23023, `spell4`=23931 WHERE `entry`=10363;
-UPDATE `creature_template` SET `spell1`=20276, `spell2`=0, `spell3`=0, `spell4`=0 WHERE `entry`=10814;
-UPDATE `creature_template` SET `spell1`=13496, `spell2`=0, `spell3`=0, `spell4`=0 WHERE `entry`=11598;
-UPDATE `creature_template` SET `spell1`=27559, `spell2`=20691, `spell3`=12020, `spell4`=30138 WHERE `entry`=10487;
-UPDATE `creature_template` SET `spell1`=17715, `spell2`=27559, `spell3`=20276, `spell4`=0 WHERE `entry`=10491;
-UPDATE `creature_template` SET `spell1`=11660, `spell2`=18807, `spell3`=0, `spell4`=0 WHERE `entry`=10470;
-UPDATE `creature_template` SET `spell1`=18270, `spell2`=0, `spell3`=0, `spell4`=0 WHERE `entry`=10481;
-UPDATE `creature_template` SET `spell1`=18116, `spell2`=17695, `spell3`=20741, `spell4`=15584 WHERE `entry`=10433;
-UPDATE `creature_template` SET `spell1`=17472, `spell2`=15584, `spell3`=0, `spell4`=0 WHERE `entry`=10482;
-UPDATE `creature_template` SET `spell1`=18106, `spell2`=18116, `spell3`=15584, `spell4`=0 WHERE `entry`=11261;
-UPDATE `creature_template` SET `spell1`=18116, `spell2`=20741, `spell3`=18144, `spell4`=0 WHERE `entry`=10506;
-UPDATE `creature_template` SET `spell1`=11672, `spell2`=12020, `spell3`=18116, `spell4`=0 WHERE `entry`=10505;
-UPDATE `creature_template` SET `spell1`=16359, `spell2`=3584, `spell3`=18116, `spell4`=0 WHERE `entry`=10901;
-UPDATE `creature_template` SET `spell1`=24375, `spell2`=18813, `spell3`=18116, `spell4`=0 WHERE `entry`=11622;
-UPDATE `creature_template` SET `spell1`=15550, `spell2`=20691, `spell3`=18116, `spell4`=0 WHERE `entry`=10507;
-UPDATE `creature_template` SET `spell1`=11668, `spell2`=11700, `spell3`=18116, `spell4`=0 WHERE `entry`=10504;
-UPDATE `creature_template` SET `spell1`=24673, `spell2`=18270, `spell3`=18116, `spell4`=0 WHERE `entry`=10503;
-UPDATE `creature_template` SET `spell1`=15584, `spell2`=17472, `spell3`=0, `spell4`=0 WHERE `entry`=11439;
-UPDATE `creature_template` SET `spell1`=18116, `spell2`=19460, `spell3`=6215, `spell4`=15487 WHERE `entry`=10502;
-UPDATE `creature_template` SET `spell1`=18702, `spell2`=10212, `spell3`=18116, `spell4`=0 WHERE `entry`=1853;
-UPDATE `creature_template` SET `spell1`=16350, `spell2`=21369, `spell3`=8398, `spell4`=18033 WHERE `entry`=10508;
-UPDATE `creature_template` SET `spell1`=27224, `spell2`=30900, `spell3`=3609, `spell4`=0 WHERE `entry`=14861;
-UPDATE `creature_template` SET `spell1`=18278, `spell2`=29405, `spell3`=12020, `spell4`=0 WHERE `entry`=10498;
-UPDATE `creature_template` SET `spell1`=24063, `spell2`=18270, `spell3`=0, `spell4`=0 WHERE `entry`=10495;
-UPDATE `creature_template` SET `spell1`=12020, `spell2`=18278, `spell3`=25304, `spell4`=0 WHERE `entry`=11263;
-UPDATE `creature_template` SET `spell1`=16469, `spell2`=25349, `spell3`=0, `spell4`=0 WHERE `entry`=11551;
-UPDATE `creature_template` SET `spell1`=25304, `spell2`=11660, `spell3`=12020, `spell4`=0 WHERE `entry`=10477;
-UPDATE `creature_template` SET `spell1`=25304, `spell2`=12020, `spell3`=10161, `spell4`=0 WHERE `entry`=10472;
-UPDATE `creature_template` SET `spell1`=15571, `spell2`=0, `spell3`=0, `spell4`=0 WHERE `entry`=10475;
-UPDATE `creature_template` SET `spell1`=25304, `spell2`=10161, `spell3`=10473, `spell4`=0 WHERE `entry`=10469;
-UPDATE `creature_template` SET `spell1`=11660, `spell2`=15571, `spell3`=10161, `spell4`=0 WHERE `entry`=11284;
-UPDATE `creature_template` SET `spell1`=17689, `spell2`=15571, `spell3`=18270, `spell4`=0 WHERE `entry`=10480;
-UPDATE `creature_template` SET `spell1`=15571, `spell2`=30138, `spell3`=0, `spell4`=0 WHERE `entry`=10497;
-UPDATE `creature_template` SET `spell1`=15571, `spell2`=30138, `spell3`=0, `spell4`=0 WHERE `entry`=10479;
-UPDATE `creature_template` SET `spell1`=17504, `spell2`=12867, `spell3`=0, `spell4`=0 WHERE `entry`=14513;
-UPDATE `creature_template` SET `spell1`=17504, `spell2`=12867, `spell3`=24673, `spell4`=0 WHERE `entry`=14520;
-UPDATE `creature_template` SET `spell1`=30138, `spell2`=11660, `spell3`=0, `spell4`=0 WHERE `entry`=14521;
-UPDATE `creature_template` SET `spell1`=11556, `spell2`=8140, `spell3`=23262, `spell4`=0 WHERE `entry`=14518;
-UPDATE `creature_template` SET `spell1`=10894, `spell2`=23244, `spell3`=0, `spell4`=0 WHERE `entry`=14519;
-UPDATE `creature_template` SET `spell1`=11556, `spell2`=8140, `spell3`=15571, `spell4`=0 WHERE `entry`=14514;
-UPDATE `creature_template` SET `spell1`=15571, `spell2`=23244, `spell3`=0, `spell4`=0 WHERE `entry`=14512;
-UPDATE `creature_template` SET `spell1`=12292, `spell2`=15571, `spell3`=28168, `spell4`=0 WHERE `entry`=10488;
-UPDATE `creature_template` SET `spell1`=15571, `spell2`=24063, `spell3`=18270, `spell4`=12021 WHERE `entry`=10485;
-UPDATE `creature_template` SET `spell1`=10161, `spell2`=13021, `spell3`=20883, `spell4`=0 WHERE `entry`=11257;
-UPDATE `creature_template` SET `spell1`=15571, `spell2`=0, `spell3`=0, `spell4`=0 WHERE `entry`=10478;
-UPDATE `creature_template` SET `spell1`=17504, `spell2`=26554, `spell3`=35011, `spell4`=0 WHERE `entry`=10486;
-UPDATE `creature_template` SET `spell1`=19627, `spell2`=18816, `spell3`=13021, `spell4`=0 WHERE `entry`=10432;
-UPDATE `creature_template` SET `spell1`=18807, `spell2`=10876, `spell3`=0, `spell4`=0 WHERE `entry`=10471;
-UPDATE `creature_template` SET `spell1`=10876, `spell2`=25304, `spell3`=18647, `spell4`=0 WHERE `entry`=10500;
-UPDATE `creature_template` SET `spell1`=29684, `spell2`=25051, `spell3`=0, `spell4`=0 WHERE `entry`=10489;
-
-UPDATE `creature_template` SET `spell1` = 24317, `spell2` = 19644 WHERE `entry` =  8890;
-UPDATE `creature_template` SET `spell1` = 30901, `spell2` = 27581, `spell3` = 34510 WHERE `entry` = 8891;
-UPDATE `creature_template` SET `spell1` = 29560, `spell2` = 19644 WHERE `entry` = 8892;
-UPDATE `creature_template` SET `spell1` = 40082, `spell2` = 30901 WHERE `entry` = 8893;
-UPDATE `creature_template` SET `spell1` = 8812,  `spell2` = 10961, `spell3` = 10947 WHERE `entry` = 8894;
-UPDATE `creature_template` SET `spell1` = 25292, `spell2` = 1020 WHERE `entry` = 8895;
-UPDATE `creature_template` SET `spell1` = 17143, `spell2` = 10293, `spell3` = 25292 WHERE `entry` = 8898;