ALTER TABLE `creature_template` ADD COLUMN `spellDataId` INTEGER UNSIGNED NOT NULL DEFAULT 0 AFTER `InhabitType`; UPDATE `creature_template` SET `spellDataId` = '5880' WHERE `entry` = '30'; UPDATE `creature_template` SET `spellDataId` = '10495' WHERE `entry` = '43'; UPDATE `creature_template` SET `spellDataId` = '9081' WHERE `entry` = '113'; UPDATE `creature_template` SET `spellDataId` = '5943' WHERE `entry` = '118'; UPDATE `creature_template` SET `spellDataId` = '9073' WHERE `entry` = '119'; UPDATE `creature_template` SET `spellDataId` = '5884' WHERE `entry` = '120'; UPDATE `creature_template` SET `spellDataId` = '8834' WHERE `entry` = '154'; UPDATE `creature_template` SET `spellDataId` = '9085' WHERE `entry` = '157'; UPDATE `creature_template` SET `spellDataId` = '10503' WHERE `entry` = '217'; UPDATE `creature_template` SET `spellDataId` = '9077' WHERE `entry` = '330'; UPDATE `creature_template` SET `spellDataId` = '9063' WHERE `entry` = '345'; UPDATE `creature_template` SET `spellDataId` = '9076' WHERE `entry` = '390'; UPDATE `creature_template` SET `spellDataId` = '5888' WHERE `entry` = '442'; UPDATE `creature_template` SET `spellDataId` = '9088' WHERE `entry` = '454'; UPDATE `creature_template` SET `spellDataId` = '5908' WHERE `entry` = '471'; UPDATE `creature_template` SET `spellDataId` = '5891' WHERE `entry` = '505'; UPDATE `creature_template` SET `spellDataId` = '5960' WHERE `entry` = '521'; UPDATE `creature_template` SET `spellDataId` = '9078' WHERE `entry` = '524'; UPDATE `creature_template` SET `spellDataId` = '10502' WHERE `entry` = '539'; UPDATE `creature_template` SET `spellDataId` = '9086' WHERE `entry` = '547'; UPDATE `creature_template` SET `spellDataId` = '5894' WHERE `entry` = '569'; UPDATE `creature_template` SET `spellDataId` = '5911' WHERE `entry` = '574'; UPDATE `creature_template` SET `spellDataId` = '5909' WHERE `entry` = '616'; UPDATE `creature_template` SET `spellDataId` = '5949' WHERE `entry` = '628'; UPDATE `creature_template` SET `spellDataId` = '5828' WHERE `entry` = '681'; UPDATE `creature_template` SET `spellDataId` = '8264' WHERE `entry` = '682'; UPDATE `creature_template` SET `spellDataId` = '5829' WHERE `entry` = '683'; UPDATE `creature_template` SET `spellDataId` = '8880' WHERE `entry` = '684'; UPDATE `creature_template` SET `spellDataId` = '9080' WHERE `entry` = '708'; UPDATE `creature_template` SET `spellDataId` = '8279' WHERE `entry` = '728'; UPDATE `creature_template` SET `spellDataId` = '8278' WHERE `entry` = '729'; UPDATE `creature_template` SET `spellDataId` = '8887' WHERE `entry` = '731'; UPDATE `creature_template` SET `spellDataId` = '5830' WHERE `entry` = '736'; UPDATE `creature_template` SET `spellDataId` = '8265' WHERE `entry` = '767'; UPDATE `creature_template` SET `spellDataId` = '8881' WHERE `entry` = '768'; UPDATE `creature_template` SET `spellDataId` = '5903' WHERE `entry` = '769'; UPDATE `creature_template` SET `spellDataId` = '5797' WHERE `entry` = '822'; UPDATE `creature_template` SET `spellDataId` = '5946' WHERE `entry` = '833'; UPDATE `creature_template` SET `spellDataId` = '5944' WHERE `entry` = '834'; UPDATE `creature_template` SET `spellDataId` = '5845' WHERE `entry` = '922'; UPDATE `creature_template` SET `spellDataId` = '10506' WHERE `entry` = '930'; UPDATE `creature_template` SET `spellDataId` = '10507' WHERE `entry` = '949'; UPDATE `creature_template` SET `spellDataId` = '8263' WHERE `entry` = '976'; UPDATE `creature_template` SET `spellDataId` = '5854' WHERE `entry` = '1087'; UPDATE `creature_template` SET `spellDataId` = '5846' WHERE `entry` = '1088'; UPDATE `creature_template` SET `spellDataId` = '9059' WHERE `entry` = '1108'; UPDATE `creature_template` SET `spellDataId` = '10505' WHERE `entry` = '1111'; UPDATE `creature_template` SET `spellDataId` = '5910' WHERE `entry` = '1112'; UPDATE `creature_template` SET `spellDataId` = '9057' WHERE `entry` = '1114'; UPDATE `creature_template` SET `spellDataId` = '9068' WHERE `entry` = '1125'; UPDATE `creature_template` SET `spellDataId` = '9072' WHERE `entry` = '1126'; UPDATE `creature_template` SET `spellDataId` = '9070' WHERE `entry` = '1127'; UPDATE `creature_template` SET `spellDataId` = '5795' WHERE `entry` = '1129'; UPDATE `creature_template` SET `spellDataId` = '5812' WHERE `entry` = '1130'; UPDATE `creature_template` SET `spellDataId` = '5940' WHERE `entry` = '1131'; UPDATE `creature_template` SET `spellDataId` = '5959' WHERE `entry` = '1132'; UPDATE `creature_template` SET `spellDataId` = '5941' WHERE `entry` = '1133'; UPDATE `creature_template` SET `spellDataId` = '5937' WHERE `entry` = '1138'; UPDATE `creature_template` SET `spellDataId` = '5890' WHERE `entry` = '1185'; UPDATE `creature_template` SET `spellDataId` = '5801' WHERE `entry` = '1189'; UPDATE `creature_template` SET `spellDataId` = '9075' WHERE `entry` = '1190'; UPDATE `creature_template` SET `spellDataId` = '9087' WHERE `entry` = '1191'; UPDATE `creature_template` SET `spellDataId` = '9084' WHERE `entry` = '1192'; UPDATE `creature_template` SET `spellDataId` = '5885' WHERE `entry` = '1195'; UPDATE `creature_template` SET `spellDataId` = '5796' WHERE `entry` = '1196'; UPDATE `creature_template` SET `spellDataId` = '5816' WHERE `entry` = '1199'; UPDATE `creature_template` SET `spellDataId` = '5840' WHERE `entry` = '1216'; UPDATE `creature_template` SET `spellDataId` = '5815' WHERE `entry` = '1225'; UPDATE `creature_template` SET `spellDataId` = '5950' WHERE `entry` = '1258'; UPDATE `creature_template` SET `spellDataId` = '10524' WHERE `entry` = '1504'; UPDATE `creature_template` SET `spellDataId` = '5879' WHERE `entry` = '1505'; UPDATE `creature_template` SET `spellDataId` = '5935' WHERE `entry` = '1509'; UPDATE `creature_template` SET `spellDataId` = '5786' WHERE `entry` = '1553'; UPDATE `creature_template` SET `spellDataId` = '5886' WHERE `entry` = '1555'; UPDATE `creature_template` SET `spellDataId` = '9055' WHERE `entry` = '1557'; UPDATE `creature_template` SET `spellDataId` = '5881' WHERE `entry` = '1688'; UPDATE `creature_template` SET `spellDataId` = '9079' WHERE `entry` = '1689'; UPDATE `creature_template` SET `spellDataId` = '5847' WHERE `entry` = '1693'; UPDATE `creature_template` SET `spellDataId` = '8267' WHERE `entry` = '1713'; UPDATE `creature_template` SET `spellDataId` = '5945' WHERE `entry` = '1765'; UPDATE `creature_template` SET `spellDataId` = '5799' WHERE `entry` = '1778'; UPDATE `creature_template` SET `spellDataId` = '8311' WHERE `entry` = '1809'; UPDATE `creature_template` SET `spellDataId` = '8312' WHERE `entry` = '1811'; UPDATE `creature_template` SET `spellDataId` = '5810' WHERE `entry` = '1816'; UPDATE `creature_template` SET `spellDataId` = '5956' WHERE `entry` = '1817'; UPDATE `creature_template` SET `spellDataId` = '10514' WHERE `entry` = '1822'; UPDATE `creature_template` SET `spellDataId` = '5906' WHERE `entry` = '1824'; UPDATE `creature_template` SET `spellDataId` = '5938' WHERE `entry` = '1922'; UPDATE `creature_template` SET `spellDataId` = '5947' WHERE `entry` = '1923'; UPDATE `creature_template` SET `spellDataId` = '5814' WHERE `entry` = '1961'; UPDATE `creature_template` SET `spellDataId` = '9083' WHERE `entry` = '1984'; UPDATE `creature_template` SET `spellDataId` = '9082' WHERE `entry` = '1985'; UPDATE `creature_template` SET `spellDataId` = '5913' WHERE `entry` = '1994'; UPDATE `creature_template` SET `spellDataId` = '5859' WHERE `entry` = '1995'; UPDATE `creature_template` SET `spellDataId` = '5860' WHERE `entry` = '1997'; UPDATE `creature_template` SET `spellDataId` = '5882' WHERE `entry` = '1999'; UPDATE `creature_template` SET `spellDataId` = '5883' WHERE `entry` = '2000'; UPDATE `creature_template` SET `spellDataId` = '5887' WHERE `entry` = '2001'; UPDATE `creature_template` SET `spellDataId` = '5817' WHERE `entry` = '2042'; UPDATE `creature_template` SET `spellDataId` = '5821' WHERE `entry` = '2070'; UPDATE `creature_template` SET `spellDataId` = '5849' WHERE `entry` = '2089'; UPDATE `creature_template` SET `spellDataId` = '5798' WHERE `entry` = '2163'; UPDATE `creature_template` SET `spellDataId` = '5837' WHERE `entry` = '2232'; UPDATE `creature_template` SET `spellDataId` = '5823' WHERE `entry` = '2237'; UPDATE `creature_template` SET `spellDataId` = '5916' WHERE `entry` = '2321'; UPDATE `creature_template` SET `spellDataId` = '5919' WHERE `entry` = '2323'; UPDATE `creature_template` SET `spellDataId` = '5896' WHERE `entry` = '2348'; UPDATE `creature_template` SET `spellDataId` = '5895' WHERE `entry` = '2349'; UPDATE `creature_template` SET `spellDataId` = '5893' WHERE `entry` = '2350'; UPDATE `creature_template` SET `spellDataId` = '5804' WHERE `entry` = '2351'; UPDATE `creature_template` SET `spellDataId` = '5824' WHERE `entry` = '2384'; UPDATE `creature_template` SET `spellDataId` = '5826' WHERE `entry` = '2385'; UPDATE `creature_template` SET `spellDataId` = '5525' WHERE `entry` = '2406'; UPDATE `creature_template` SET `spellDataId` = '5924' WHERE `entry` = '2408'; UPDATE `creature_template` SET `spellDataId` = '5856' WHERE `entry` = '2476'; UPDATE `creature_template` SET `spellDataId` = '5928' WHERE `entry` = '2505'; UPDATE `creature_template` SET `spellDataId` = '5833' WHERE `entry` = '2522'; UPDATE `creature_template` SET `spellDataId` = '5898' WHERE `entry` = '2563'; UPDATE `creature_template` SET `spellDataId` = '5900' WHERE `entry` = '2565'; UPDATE `creature_template` SET `spellDataId` = '8303' WHERE `entry` = '2578'; UPDATE `creature_template` SET `spellDataId` = '8304' WHERE `entry` = '2579'; UPDATE `creature_template` SET `spellDataId` = '5958' WHERE `entry` = '2681'; UPDATE `creature_template` SET `spellDataId` = '5904' WHERE `entry` = '2686'; UPDATE `creature_template` SET `spellDataId` = '5952' WHERE `entry` = '2727'; UPDATE `creature_template` SET `spellDataId` = '8293' WHERE `entry` = '2728'; UPDATE `creature_template` SET `spellDataId` = '8294' WHERE `entry` = '2729'; UPDATE `creature_template` SET `spellDataId` = '8295' WHERE `entry` = '2730'; UPDATE `creature_template` SET `spellDataId` = '5831' WHERE `entry` = '2731'; UPDATE `creature_template` SET `spellDataId` = '5832' WHERE `entry` = '2732'; UPDATE `creature_template` SET `spellDataId` = '8266' WHERE `entry` = '2734'; UPDATE `creature_template` SET `spellDataId` = '5961' WHERE `entry` = '2753'; UPDATE `creature_template` SET `spellDataId` = '8275' WHERE `entry` = '2850'; UPDATE `creature_template` SET `spellDataId` = '8847' WHERE `entry` = '2924'; UPDATE `creature_template` SET `spellDataId` = '8864' WHERE `entry` = '2925'; UPDATE `creature_template` SET `spellDataId` = '8296' WHERE `entry` = '2926'; UPDATE `creature_template` SET `spellDataId` = '8314' WHERE `entry` = '2931'; UPDATE `creature_template` SET `spellDataId` = '9066' WHERE `entry` = '2954'; UPDATE `creature_template` SET `spellDataId` = '5915' WHERE `entry` = '2957'; UPDATE `creature_template` SET `spellDataId` = '5936' WHERE `entry` = '2958'; UPDATE `creature_template` SET `spellDataId` = '5939' WHERE `entry` = '2959'; UPDATE `creature_template` SET `spellDataId` = '5942' WHERE `entry` = '2960'; UPDATE `creature_template` SET `spellDataId` = '9065' WHERE `entry` = '2966'; UPDATE `creature_template` SET `spellDataId` = '5819' WHERE `entry` = '3035'; UPDATE `creature_template` SET `spellDataId` = '5921' WHERE `entry` = '3068'; UPDATE `creature_template` SET `spellDataId` = '9074' WHERE `entry` = '3098'; UPDATE `creature_template` SET `spellDataId` = '9069' WHERE `entry` = '3099'; UPDATE `creature_template` SET `spellDataId` = '9071' WHERE `entry` = '3100'; UPDATE `creature_template` SET `spellDataId` = '5835' WHERE `entry` = '3106'; UPDATE `creature_template` SET `spellDataId` = '5836' WHERE `entry` = '3108'; UPDATE `creature_template` SET `spellDataId` = '5800' WHERE `entry` = '3110'; UPDATE `creature_template` SET `spellDataId` = '5818' WHERE `entry` = '3121'; UPDATE `creature_template` SET `spellDataId` = '5864' WHERE `entry` = '3124'; UPDATE `creature_template` SET `spellDataId` = '5865' WHERE `entry` = '3127'; UPDATE `creature_template` SET `spellDataId` = '9067' WHERE `entry` = '3225'; UPDATE `creature_template` SET `spellDataId` = '8848' WHERE `entry` = '3226'; UPDATE `creature_template` SET `spellDataId` = '5822' WHERE `entry` = '3241'; UPDATE `creature_template` SET `spellDataId` = '5918' WHERE `entry` = '3245'; UPDATE `creature_template` SET `spellDataId` = '5917' WHERE `entry` = '3246'; UPDATE `creature_template` SET `spellDataId` = '8903' WHERE `entry` = '3247'; UPDATE `creature_template` SET `spellDataId` = '8904' WHERE `entry` = '3249'; UPDATE `creature_template` SET `spellDataId` = '8849' WHERE `entry` = '3250'; UPDATE `creature_template` SET `spellDataId` = '8850' WHERE `entry` = '3252'; UPDATE `creature_template` SET `spellDataId` = '5875' WHERE `entry` = '3281'; UPDATE `creature_template` SET `spellDataId` = '8902' WHERE `entry` = '3424'; UPDATE `creature_template` SET `spellDataId` = '5839' WHERE `entry` = '3460'; UPDATE `creature_template` SET `spellDataId` = '5923' WHERE `entry` = '3461'; UPDATE `creature_template` SET `spellDataId` = '8908' WHERE `entry` = '3472'; UPDATE `creature_template` SET `spellDataId` = '5857' WHERE `entry` = '3581'; UPDATE `creature_template` SET `spellDataId` = '9477' WHERE `entry` = '3619'; UPDATE `creature_template` SET `spellDataId` = '8898' WHERE `entry` = '3630'; UPDATE `creature_template` SET `spellDataId` = '8900' WHERE `entry` = '3631'; UPDATE `creature_template` SET `spellDataId` = '5934' WHERE `entry` = '3653'; UPDATE `creature_template` SET `spellDataId` = '5803' WHERE `entry` = '3809'; UPDATE `creature_template` SET `spellDataId` = '5805' WHERE `entry` = '3810'; UPDATE `creature_template` SET `spellDataId` = '5841' WHERE `entry` = '3812'; UPDATE `creature_template` SET `spellDataId` = '5897' WHERE `entry` = '3821'; UPDATE `creature_template` SET `spellDataId` = '5948' WHERE `entry` = '3823'; UPDATE `creature_template` SET `spellDataId` = '5951' WHERE `entry` = '3825'; UPDATE `creature_template` SET `spellDataId` = '5889' WHERE `entry` = '4005'; UPDATE `creature_template` SET `spellDataId` = '5892' WHERE `entry` = '4006'; UPDATE `creature_template` SET `spellDataId` = '10504' WHERE `entry` = '4040'; UPDATE `creature_template` SET `spellDataId` = '5825' WHERE `entry` = '4067'; UPDATE `creature_template` SET `spellDataId` = '8905' WHERE `entry` = '4117'; UPDATE `creature_template` SET `spellDataId` = '8907' WHERE `entry` = '4118'; UPDATE `creature_template` SET `spellDataId` = '8906' WHERE `entry` = '4119'; UPDATE `creature_template` SET `spellDataId` = '5827' WHERE `entry` = '4126'; UPDATE `creature_template` SET `spellDataId` = '8853' WHERE `entry` = '4139'; UPDATE `creature_template` SET `spellDataId` = '5867' WHERE `entry` = '4140'; UPDATE `creature_template` SET `spellDataId` = '5926' WHERE `entry` = '4143'; UPDATE `creature_template` SET `spellDataId` = '8836' WHERE `entry` = '4158'; UPDATE `creature_template` SET `spellDataId` = '10498' WHERE `entry` = '4263'; UPDATE `creature_template` SET `spellDataId` = '8287' WHERE `entry` = '4304'; UPDATE `creature_template` SET `spellDataId` = '5853' WHERE `entry` = '4341'; UPDATE `creature_template` SET `spellDataId` = '5851' WHERE `entry` = '4343'; UPDATE `creature_template` SET `spellDataId` = '5852' WHERE `entry` = '4344'; UPDATE `creature_template` SET `spellDataId` = '5855' WHERE `entry` = '4345'; UPDATE `creature_template` SET `spellDataId` = '8317' WHERE `entry` = '4346'; UPDATE `creature_template` SET `spellDataId` = '8318' WHERE `entry` = '4347'; UPDATE `creature_template` SET `spellDataId` = '8319' WHERE `entry` = '4348'; UPDATE `creature_template` SET `spellDataId` = '10508' WHERE `entry` = '4376'; UPDATE `creature_template` SET `spellDataId` = '10510' WHERE `entry` = '4377'; UPDATE `creature_template` SET `spellDataId` = '10509' WHERE `entry` = '4378'; UPDATE `creature_template` SET `spellDataId` = '10511' WHERE `entry` = '4379'; UPDATE `creature_template` SET `spellDataId` = '10512' WHERE `entry` = '4380'; UPDATE `creature_template` SET `spellDataId` = '5925' WHERE `entry` = '4396'; UPDATE `creature_template` SET `spellDataId` = '5927' WHERE `entry` = '4400'; UPDATE `creature_template` SET `spellDataId` = '5901' WHERE `entry` = '4411'; UPDATE `creature_template` SET `spellDataId` = '5902' WHERE `entry` = '4412'; UPDATE `creature_template` SET `spellDataId` = '5899' WHERE `entry` = '4413'; UPDATE `creature_template` SET `spellDataId` = '5794' WHERE `entry` = '4425'; UPDATE `creature_template` SET `spellDataId` = '5957' WHERE `entry` = '4482'; UPDATE `creature_template` SET `spellDataId` = '9089' WHERE `entry` = '4511'; UPDATE `creature_template` SET `spellDataId` = '9091' WHERE `entry` = '4512'; UPDATE `creature_template` SET `spellDataId` = '9090' WHERE `entry` = '4514'; UPDATE `creature_template` SET `spellDataId` = '5790' WHERE `entry` = '4538'; UPDATE `creature_template` SET `spellDataId` = '8300' WHERE `entry` = '4539'; UPDATE `creature_template` SET `spellDataId` = '8282' WHERE `entry` = '4662'; UPDATE `creature_template` SET `spellDataId` = '8280' WHERE `entry` = '4688'; UPDATE `creature_template` SET `spellDataId` = '8281' WHERE `entry` = '4691'; UPDATE `creature_template` SET `spellDataId` = '8305' WHERE `entry` = '4693'; UPDATE `creature_template` SET `spellDataId` = '8837' WHERE `entry` = '4694'; UPDATE `creature_template` SET `spellDataId` = '5866' WHERE `entry` = '4696'; UPDATE `creature_template` SET `spellDataId` = '5868' WHERE `entry` = '4697'; UPDATE `creature_template` SET `spellDataId` = '8852' WHERE `entry` = '4699'; UPDATE `creature_template` SET `spellDataId` = '8292' WHERE `entry` = '4724'; UPDATE `creature_template` SET `spellDataId` = '5922' WHERE `entry` = '4725'; UPDATE `creature_template` SET `spellDataId` = '5842' WHERE `entry` = '4821'; UPDATE `creature_template` SET `spellDataId` = '5843' WHERE `entry` = '4822'; UPDATE `creature_template` SET `spellDataId` = '5844' WHERE `entry` = '4823'; UPDATE `creature_template` SET `spellDataId` = '5929' WHERE `entry` = '4824'; UPDATE `creature_template` SET `spellDataId` = '5930' WHERE `entry` = '4825'; UPDATE `creature_template` SET `spellDataId` = '5858' WHERE `entry` = '4841'; UPDATE `creature_template` SET `spellDataId` = '5791' WHERE `entry` = '4861'; UPDATE `creature_template` SET `spellDataId` = '5792' WHERE `entry` = '4862'; UPDATE `creature_template` SET `spellDataId` = '5932' WHERE `entry` = '4887'; UPDATE `creature_template` SET `spellDataId` = '8299' WHERE `entry` = '4950'; UPDATE `creature_template` SET `spellDataId` = '10543' WHERE `entry` = '5048'; UPDATE `creature_template` SET `spellDataId` = '5848' WHERE `entry` = '5053'; UPDATE `creature_template` SET `spellDataId` = '8899' WHERE `entry` = '5056'; UPDATE `creature_template` SET `spellDataId` = '10544' WHERE `entry` = '5224'; UPDATE `creature_template` SET `spellDataId` = '10544' WHERE `entry` = '5225'; UPDATE `creature_template` SET `spellDataId` = '9054' WHERE `entry` = '5262'; UPDATE `creature_template` SET `spellDataId` = '5806' WHERE `entry` = '5268'; UPDATE `creature_template` SET `spellDataId` = '5807' WHERE `entry` = '5274'; UPDATE `creature_template` SET `spellDataId` = '5953' WHERE `entry` = '5286'; UPDATE `creature_template` SET `spellDataId` = '8865' WHERE `entry` = '5287'; UPDATE `creature_template` SET `spellDataId` = '8909' WHERE `entry` = '5291'; UPDATE `creature_template` SET `spellDataId` = '8320' WHERE `entry` = '5307'; UPDATE `creature_template` SET `spellDataId` = '8321' WHERE `entry` = '5308'; UPDATE `creature_template` SET `spellDataId` = '8322' WHERE `entry` = '5349'; UPDATE `creature_template` SET `spellDataId` = '5813' WHERE `entry` = '5352'; UPDATE `creature_template` SET `spellDataId` = '5963' WHERE `entry` = '5356'; UPDATE `creature_template` SET `spellDataId` = '5869' WHERE `entry` = '5422'; UPDATE `creature_template` SET `spellDataId` = '8857' WHERE `entry` = '5423'; UPDATE `creature_template` SET `spellDataId` = '8856' WHERE `entry` = '5424'; UPDATE `creature_template` SET `spellDataId` = '8283' WHERE `entry` = '5425'; UPDATE `creature_template` SET `spellDataId` = '8284' WHERE `entry` = '5426'; UPDATE `creature_template` SET `spellDataId` = '8285' WHERE `entry` = '5427'; UPDATE `creature_template` SET `spellDataId` = '8307' WHERE `entry` = '5428'; UPDATE `creature_template` SET `spellDataId` = '8308' WHERE `entry` = '5429'; UPDATE `creature_template` SET `spellDataId` = '8309' WHERE `entry` = '5430'; UPDATE `creature_template` SET `spellDataId` = '5931' WHERE `entry` = '5432'; UPDATE `creature_template` SET `spellDataId` = '8323' WHERE `entry` = '5708'; UPDATE `creature_template` SET `spellDataId` = '10543' WHERE `entry` = '5755'; UPDATE `creature_template` SET `spellDataId` = '8901' WHERE `entry` = '5756'; UPDATE `creature_template` SET `spellDataId` = '11587' WHERE `entry` = '5762'; UPDATE `creature_template` SET `spellDataId` = '5820' WHERE `entry` = '5766'; UPDATE `creature_template` SET `spellDataId` = '5876' WHERE `entry` = '5823'; UPDATE `creature_template` SET `spellDataId` = '10513' WHERE `entry` = '5856'; UPDATE `creature_template` SET `spellDataId` = '5877' WHERE `entry` = '5937'; UPDATE `creature_template` SET `spellDataId` = '8286' WHERE `entry` = '5986'; UPDATE `creature_template` SET `spellDataId` = '5870' WHERE `entry` = '5987'; UPDATE `creature_template` SET `spellDataId` = '8858' WHERE `entry` = '5988'; UPDATE `creature_template` SET `spellDataId` = '5871' WHERE `entry` = '5989'; UPDATE `creature_template` SET `spellDataId` = '8261' WHERE `entry` = '5992'; UPDATE `creature_template` SET `spellDataId` = '8306' WHERE `entry` = '6013'; UPDATE `creature_template` SET `spellDataId` = '5838' WHERE `entry` = '6250'; UPDATE `creature_template` SET `spellDataId` = '9053' WHERE `entry` = '6516'; UPDATE `creature_template` SET `spellDataId` = '9051' WHERE `entry` = '6585'; UPDATE `creature_template` SET `spellDataId` = '5802' WHERE `entry` = '6788'; UPDATE `creature_template` SET `spellDataId` = '5873' WHERE `entry` = '7022'; UPDATE `creature_template` SET `spellDataId` = '8298' WHERE `entry` = '7055'; UPDATE `creature_template` SET `spellDataId` = '8851' WHERE `entry` = '7078'; UPDATE `creature_template` SET `spellDataId` = '8315' WHERE `entry` = '7097'; UPDATE `creature_template` SET `spellDataId` = '8316' WHERE `entry` = '7098'; UPDATE `creature_template` SET `spellDataId` = '5861' WHERE `entry` = '7099'; UPDATE `creature_template` SET `spellDataId` = '10544' WHERE `entry` = '7268'; UPDATE `creature_template` SET `spellDataId` = '5914' WHERE `entry` = '7319'; UPDATE `creature_template` SET `spellDataId` = '8854' WHERE `entry` = '7405'; UPDATE `creature_template` SET `spellDataId` = '5834' WHERE `entry` = '7430'; UPDATE `creature_template` SET `spellDataId` = '8270' WHERE `entry` = '7432'; UPDATE `creature_template` SET `spellDataId` = '8268' WHERE `entry` = '7433'; UPDATE `creature_template` SET `spellDataId` = '5809' WHERE `entry` = '7444'; UPDATE `creature_template` SET `spellDataId` = '5811' WHERE `entry` = '7445'; UPDATE `creature_template` SET `spellDataId` = '5862' WHERE `entry` = '7455'; UPDATE `creature_template` SET `spellDataId` = '5863' WHERE `entry` = '7456'; UPDATE `creature_template` SET `spellDataId` = '8855' WHERE `entry` = '7803'; UPDATE `creature_template` SET `spellDataId` = '8310' WHERE `entry` = '8207'; UPDATE `creature_template` SET `spellDataId` = '8288' WHERE `entry` = '8208'; UPDATE `creature_template` SET `spellDataId` = '5962' WHERE `entry` = '8211'; UPDATE `creature_template` SET `spellDataId` = '5933' WHERE `entry` = '8213'; UPDATE `creature_template` SET `spellDataId` = '5912' WHERE `entry` = '8277'; UPDATE `creature_template` SET `spellDataId` = '8313' WHERE `entry` = '8299'; UPDATE `creature_template` SET `spellDataId` = '8289' WHERE `entry` = '8300'; UPDATE `creature_template` SET `spellDataId` = '5878' WHERE `entry` = '8301'; UPDATE `creature_template` SET `spellDataId` = '8262' WHERE `entry` = '8303'; UPDATE `creature_template` SET `spellDataId` = '8910' WHERE `entry` = '8336'; UPDATE `creature_template` SET `spellDataId` = '10544' WHERE `entry` = '8437'; UPDATE `creature_template` SET `spellDataId` = '5787' WHERE `entry` = '8600'; UPDATE `creature_template` SET `spellDataId` = '5788' WHERE `entry` = '8601'; UPDATE `creature_template` SET `spellDataId` = '5789' WHERE `entry` = '8602'; UPDATE `creature_template` SET `spellDataId` = '5905' WHERE `entry` = '8762'; UPDATE `creature_template` SET `spellDataId` = '5874' WHERE `entry` = '8926'; UPDATE `creature_template` SET `spellDataId` = '5793' WHERE `entry` = '8927'; UPDATE `creature_template` SET `spellDataId` = '5907' WHERE `entry` = '8933'; UPDATE `creature_template` SET `spellDataId` = '5808' WHERE `entry` = '8958'; UPDATE `creature_template` SET `spellDataId` = '5954' WHERE `entry` = '8959'; UPDATE `creature_template` SET `spellDataId` = '5955' WHERE `entry` = '8961'; UPDATE `creature_template` SET `spellDataId` = '8297' WHERE `entry` = '9416'; UPDATE `creature_template` SET `spellDataId` = '8301' WHERE `entry` = '9521'; UPDATE `creature_template` SET `spellDataId` = '9050' WHERE `entry` = '9622'; UPDATE `creature_template` SET `spellDataId` = '8860' WHERE `entry` = '9691'; UPDATE `creature_template` SET `spellDataId` = '5872' WHERE `entry` = '9695'; UPDATE `creature_template` SET `spellDataId` = '7344' WHERE `entry` = '9696'; UPDATE `creature_template` SET `spellDataId` = '8833' WHERE `entry` = '9698'; UPDATE `creature_template` SET `spellDataId` = '8276' WHERE `entry` = '10200'; UPDATE `creature_template` SET `spellDataId` = '10497' WHERE `entry` = '10359'; UPDATE `creature_template` SET `spellDataId` = '10515' WHERE `entry` = '10375'; UPDATE `creature_template` SET `spellDataId` = '8866' WHERE `entry` = '10644'; UPDATE `creature_template` SET `spellDataId` = '9001' WHERE `entry` = '11357'; UPDATE `creature_template` SET `spellDataId` = '11582' WHERE `entry` = '11359'; UPDATE `creature_template` SET `spellDataId` = '8274' WHERE `entry` = '11365'; UPDATE `creature_template` SET `spellDataId` = '10519' WHERE `entry` = '11370'; UPDATE `creature_template` SET `spellDataId` = '10530' WHERE `entry` = '11371'; UPDATE `creature_template` SET `spellDataId` = '10530' WHERE `entry` = '11372'; UPDATE `creature_template` SET `spellDataId` = '10530' WHERE `entry` = '11373'; UPDATE `creature_template` SET `spellDataId` = '5956' WHERE `entry` = '11614'; UPDATE `creature_template` SET `spellDataId` = '8859' WHERE `entry` = '11735'; UPDATE `creature_template` SET `spellDataId` = '8832' WHERE `entry` = '11736'; UPDATE `creature_template` SET `spellDataId` = '8861' WHERE `entry` = '11737'; UPDATE `creature_template` SET `spellDataId` = '10516' WHERE `entry` = '11739'; UPDATE `creature_template` SET `spellDataId` = '5945' WHERE `entry` = '11871'; UPDATE `creature_template` SET `spellDataId` = '5892' WHERE `entry` = '11921'; UPDATE `creature_template` SET `spellDataId` = '10500' WHERE `entry` = '12433'; UPDATE `creature_template` SET `spellDataId` = '5953' WHERE `entry` = '12800'; UPDATE `creature_template` SET `spellDataId` = '5953' WHERE `entry` = '12801'; UPDATE `creature_template` SET `spellDataId` = '5953' WHERE `entry` = '12802'; UPDATE `creature_template` SET `spellDataId` = '5953' WHERE `entry` = '12803'; UPDATE `creature_template` SET `spellDataId` = '11601' WHERE `entry` = '13599'; UPDATE `creature_template` SET `spellDataId` = '9062' WHERE `entry` = '13896'; UPDATE `creature_template` SET `spellDataId` = '5924' WHERE `entry` = '14223'; UPDATE `creature_template` SET `spellDataId` = '5858' WHERE `entry` = '14233'; UPDATE `creature_template` SET `spellDataId` = '5890' WHERE `entry` = '14266'; UPDATE `creature_template` SET `spellDataId` = '8841' WHERE `entry` = '14274'; UPDATE `creature_template` SET `spellDataId` = '5893' WHERE `entry` = '14279'; UPDATE `creature_template` SET `spellDataId` = '5954' WHERE `entry` = '14339'; UPDATE `creature_template` SET `spellDataId` = '5861' WHERE `entry` = '14343'; UPDATE `creature_template` SET `spellDataId` = '5808' WHERE `entry` = '14344'; UPDATE `creature_template` SET `spellDataId` = '8861' WHERE `entry` = '14476'; UPDATE `creature_template` SET `spellDataId` = '10517' WHERE `entry` = '14532'; UPDATE `creature_template` SET `spellDataId` = '10518' WHERE `entry` = '15041'; UPDATE `creature_template` SET `spellDataId` = '8272' WHERE `entry` = '15067'; UPDATE `creature_template` SET `spellDataId` = '8271' WHERE `entry` = '15068'; UPDATE `creature_template` SET `spellDataId` = '8272' WHERE `entry` = '15101'; UPDATE `creature_template` SET `spellDataId` = '10481' WHERE `entry` = '15649'; UPDATE `creature_template` SET `spellDataId` = '10391' WHERE `entry` = '15650'; UPDATE `creature_template` SET `spellDataId` = '11553' WHERE `entry` = '15651'; UPDATE `creature_template` SET `spellDataId` = '11094' WHERE `entry` = '15652'; UPDATE `creature_template` SET `spellDataId` = '11562' WHERE `entry` = '15653'; UPDATE `creature_template` SET `spellDataId` = '9161' WHERE `entry` = '16117'; UPDATE `creature_template` SET `spellDataId` = '10522' WHERE `entry` = '16170'; UPDATE `creature_template` SET `spellDataId` = '10523' WHERE `entry` = '16171'; UPDATE `creature_template` SET `spellDataId` = '11556' WHERE `entry` = '16347'; UPDATE `creature_template` SET `spellDataId` = '11092' WHERE `entry` = '16348'; UPDATE `creature_template` SET `spellDataId` = '11093' WHERE `entry` = '16349'; UPDATE `creature_template` SET `spellDataId` = '10496' WHERE `entry` = '16350'; UPDATE `creature_template` SET `spellDataId` = '10499' WHERE `entry` = '16351'; UPDATE `creature_template` SET `spellDataId` = '10501' WHERE `entry` = '16352'; UPDATE `creature_template` SET `spellDataId` = '11567' WHERE `entry` = '16932'; UPDATE `creature_template` SET `spellDataId` = '11565' WHERE `entry` = '16934'; UPDATE `creature_template` SET `spellDataId` = '10705' WHERE `entry` = '17034'; UPDATE `creature_template` SET `spellDataId` = '10708' WHERE `entry` = '17035'; UPDATE `creature_template` SET `spellDataId` = '10705' WHERE `entry` = '17039'; UPDATE `creature_template` SET `spellDataId` = '8311' WHERE `entry` = '17042'; UPDATE `creature_template` SET `spellDataId` = '10709' WHERE `entry` = '17053'; UPDATE `creature_template` SET `spellDataId` = '10711' WHERE `entry` = '17128'; UPDATE `creature_template` SET `spellDataId` = '10706' WHERE `entry` = '17129'; UPDATE `creature_template` SET `spellDataId` = '9504' WHERE `entry` = '17178'; UPDATE `creature_template` SET `spellDataId` = '11593' WHERE `entry` = '17198'; UPDATE `creature_template` SET `spellDataId` = '11594' WHERE `entry` = '17199'; UPDATE `creature_template` SET `spellDataId` = '5904' WHERE `entry` = '17236'; UPDATE `creature_template` SET `spellDataId` = '9613' WHERE `entry` = '17399'; UPDATE `creature_template` SET `spellDataId` = '9612' WHERE `entry` = '17401'; UPDATE `creature_template` SET `spellDataId` = '8267' WHERE `entry` = '17411'; UPDATE `creature_template` SET `spellDataId` = '11563' WHERE `entry` = '17526'; UPDATE `creature_template` SET `spellDataId` = '11564' WHERE `entry` = '17527'; UPDATE `creature_template` SET `spellDataId` = '11595' WHERE `entry` = '17556'; UPDATE `creature_template` SET `spellDataId` = '11596' WHERE `entry` = '17620'; UPDATE `creature_template` SET `spellDataId` = '11591' WHERE `entry` = '18033'; UPDATE `creature_template` SET `spellDataId` = '10483' WHERE `entry` = '18155'; UPDATE `creature_template` SET `spellDataId` = '10710' WHERE `entry` = '18220'; UPDATE `creature_template` SET `spellDataId` = '10707' WHERE `entry` = '18257'; UPDATE `creature_template` SET `spellDataId` = '10525' WHERE `entry` = '18464'; UPDATE `creature_template` SET `spellDataId` = '11577' WHERE `entry` = '18465'; UPDATE `creature_template` SET `spellDataId` = '10520' WHERE `entry` = '18466'; UPDATE `creature_template` SET `spellDataId` = '10521' WHERE `entry` = '18467'; UPDATE `creature_template` SET `spellDataId` = '11592' WHERE `entry` = '18476'; UPDATE `creature_template` SET `spellDataId` = '9612' WHERE `entry` = '18605'; UPDATE `creature_template` SET `spellDataId` = '9613' WHERE `entry` = '18614'; UPDATE `creature_template` SET `spellDataId` = '10480' WHERE `entry` = '18851'; UPDATE `creature_template` SET `spellDataId` = '10482' WHERE `entry` = '18854'; UPDATE `creature_template` SET `spellDataId` = '11573' WHERE `entry` = '18878'; UPDATE `creature_template` SET `spellDataId` = '11576' WHERE `entry` = '18884'; UPDATE `creature_template` SET `spellDataId` = '10712' WHERE `entry` = '18963'; UPDATE `creature_template` SET `spellDataId` = '10712' WHERE `entry` = '18996'; UPDATE `creature_template` SET `spellDataId` = '5830' WHERE `entry` = '19022'; UPDATE `creature_template` SET `spellDataId` = '5830' WHERE `entry` = '19023'; UPDATE `creature_template` SET `spellDataId` = '5830' WHERE `entry` = '19024'; UPDATE `creature_template` SET `spellDataId` = '5830' WHERE `entry` = '19025'; UPDATE `creature_template` SET `spellDataId` = '5830' WHERE `entry` = '19026'; UPDATE `creature_template` SET `spellDataId` = '5830' WHERE `entry` = '19027'; UPDATE `creature_template` SET `spellDataId` = '5830' WHERE `entry` = '19030'; UPDATE `creature_template` SET `spellDataId` = '5830' WHERE `entry` = '19031'; UPDATE `creature_template` SET `spellDataId` = '10713' WHERE `entry` = '19055'; UPDATE `creature_template` SET `spellDataId` = '11566' WHERE `entry` = '19189'; UPDATE `creature_template` SET `spellDataId` = '11570' WHERE `entry` = '19349'; UPDATE `creature_template` SET `spellDataId` = '11569' WHERE `entry` = '19350'; UPDATE `creature_template` SET `spellDataId` = '11586' WHERE `entry` = '19428'; UPDATE `creature_template` SET `spellDataId` = '10530' WHERE `entry` = '19784'; UPDATE `creature_template` SET `spellDataId` = '11588' WHERE `entry` = '19785'; UPDATE `creature_template` SET `spellDataId` = '10487' WHERE `entry` = '20038'; UPDATE `creature_template` SET `spellDataId` = '10486' WHERE `entry` = '20039'; UPDATE `creature_template` SET `spellDataId` = '11590' WHERE `entry` = '20058'; UPDATE `creature_template` SET `spellDataId` = '10709' WHERE `entry` = '20109'; UPDATE `creature_template` SET `spellDataId` = '11589' WHERE `entry` = '20330'; UPDATE `creature_template` SET `spellDataId` = '10480' WHERE `entry` = '20502'; UPDATE `creature_template` SET `spellDataId` = '10480' WHERE `entry` = '20517'; UPDATE `creature_template` SET `spellDataId` = '11572' WHERE `entry` = '20671'; UPDATE `creature_template` SET `spellDataId` = '11581' WHERE `entry` = '20673'; UPDATE `creature_template` SET `spellDataId` = '11586' WHERE `entry` = '20688'; UPDATE `creature_template` SET `spellDataId` = '11584' WHERE `entry` = '20749'; UPDATE `creature_template` SET `spellDataId` = '10540' WHERE `entry` = '20797'; UPDATE `creature_template` SET `spellDataId` = '11583' WHERE `entry` = '20999'; UPDATE `creature_template` SET `spellDataId` = '11571' WHERE `entry` = '21022'; UPDATE `creature_template` SET `spellDataId` = '9071' WHERE `entry` = '21033'; UPDATE `creature_template` SET `spellDataId` = '11585' WHERE `entry` = '21123'; UPDATE `creature_template` SET `spellDataId` = '10709' WHERE `entry` = '21468'; UPDATE `creature_template` SET `spellDataId` = '10856' WHERE `entry` = '21470'; UPDATE `creature_template` SET `spellDataId` = '10483' WHERE `entry` = '21544'; UPDATE `creature_template` SET `spellDataId` = '5918' WHERE `entry` = '21634'; UPDATE `creature_template` SET `spellDataId` = '10709' WHERE `entry` = '21804'; UPDATE `creature_template` SET `spellDataId` = '11579' WHERE `entry` = '21864'; UPDATE `creature_template` SET `spellDataId` = '11091' WHERE `entry` = '21956'; UPDATE `creature_template` SET `spellDataId` = '10525' WHERE `entry` = '22039'; UPDATE `creature_template` SET `spellDataId` = '11580' WHERE `entry` = '22100'; UPDATE `creature_template` SET `spellDataId` = '11568' WHERE `entry` = '22123'; UPDATE `creature_template` SET `spellDataId` = '11574' WHERE `entry` = '22191'; UPDATE `creature_template` SET `spellDataId` = '8858' WHERE `entry` = '22193'; UPDATE `creature_template` SET `spellDataId` = '11575' WHERE `entry` = '22255'; UPDATE `creature_template` SET `spellDataId` = '11578' WHERE `entry` = '22257'; UPDATE `creature_template` SET `spellDataId` = '10712' WHERE `entry` = '22265'; UPDATE `creature_template` SET `spellDataId` = '8841' WHERE `entry` = '22793'; UPDATE `creature_template` SET `spellDataId` = '11669' WHERE `entry` = '22807'; UPDATE `creature_template` SET `spellDataId` = '10708' WHERE `entry` = '23051'; UPDATE `creature_template` SET `spellDataId` = '11576' WHERE `entry` = '23219'