All pastes #618986 Raw Edit

Untitled

public text v1 · immutable
·published 2007-07-14 10:39 UTC
rendered paste body
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'