ratkosrb
192 lines
16 KiB
SQL
192 lines
16 KiB
SQL
DROP PROCEDURE IF EXISTS add_migration;
|
|
DELIMITER ??
|
|
CREATE PROCEDURE `add_migration`()
|
|
BEGIN
|
|
DECLARE v INT DEFAULT 1;
|
|
SET v = (SELECT COUNT(*) FROM `migrations` WHERE `id`='20241029210259');
|
|
IF v = 0 THEN
|
|
INSERT INTO `migrations` VALUES ('20241029210259');
|
|
-- Add your query below.
|
|
|
|
|
|
-- Assign zone names to all creature spells records.
|
|
UPDATE `creature_spells` SET `name`='Duskwood - Eliza' WHERE `entry`=3140;
|
|
UPDATE `creature_spells` SET `name`='Duskwood - Stitches' WHERE `entry`=4120;
|
|
UPDATE `creature_spells` SET `name`='Blackfathom Deeps - Aku\'mai Servant' WHERE `entry`=49780;
|
|
UPDATE `creature_spells` SET `name`='Silithus - Aluntir' WHERE `entry`=152880;
|
|
UPDATE `creature_spells` SET `name`='Eastern Plaguelands - Infected Mossflayer' WHERE `entry`=122610;
|
|
UPDATE `creature_spells` SET `name`='Naxxramas - Spectral Horse' WHERE `entry`=161490;
|
|
UPDATE `creature_spells` SET `name`='Eastern Plaguelands - Scarlet Trooper' WHERE `entry`=123520;
|
|
UPDATE `creature_spells` SET `name`='Elwynn Forest - Defias Bodyguard' WHERE `entry`=68660;
|
|
UPDATE `creature_spells` SET `name`='Sunken Temple - Hakkari Sapper' WHERE `entry`=83360;
|
|
UPDATE `creature_spells` SET `name`='Dire Maul - Xorothian Dreadsteed' WHERE `entry`=145020;
|
|
UPDATE `creature_spells` SET `name`='Naxxramas - Unrelenting Deathknight' WHERE `entry`=161250;
|
|
UPDATE `creature_spells` SET `name`='Blackrock Depths - Dark Screecher' WHERE `entry`=89270;
|
|
UPDATE `creature_spells` SET `name`='Silithus - The Duke of Shards' WHERE `entry`=152080;
|
|
UPDATE `creature_spells` SET `name`='Silithus - Azure Templar' WHERE `entry`=152110;
|
|
UPDATE `creature_spells` SET `name`='Ashenvale - Duriel Moonfire' WHERE `entry`=128600;
|
|
UPDATE `creature_spells` SET `name`='Ashenvale - Vorsha the Lasher' WHERE `entry`=129400;
|
|
UPDATE `creature_spells` SET `name`='Tanaris - Scorpid Duneburrower' WHERE `entry`=78030;
|
|
UPDATE `creature_spells` SET `name`='Zul\'Farrak - Gahz\'rilla' WHERE `entry`=72730;
|
|
UPDATE `creature_spells` SET `name`='Blackrock Depths - Ironhand Guardian' WHERE `entry`=89820;
|
|
UPDATE `creature_spells` SET `name`='Tanaris - Treasure Hunting Pirate' WHERE `entry`=78990;
|
|
UPDATE `creature_spells` SET `name`='Eastern Plaguelands - Fallen Hero' WHERE `entry`=109960;
|
|
UPDATE `creature_spells` SET `name`='Alterac Valley - Veteran Irondeep Raider' WHERE `entry`=135440;
|
|
UPDATE `creature_spells` SET `name`='Blackwing Lair - Black Drakonid' WHERE `entry`=142650;
|
|
UPDATE `creature_spells` SET `name`='Alterac Valley - Veteran Irondeep Surveyor' WHERE `entry`=135560;
|
|
UPDATE `creature_spells` SET `name`='Dire Maul - Mana Burst' WHERE `entry`=143970;
|
|
UPDATE `creature_spells` SET `name`='Blackwing Lair - Red Drakonid' WHERE `entry`=142640;
|
|
UPDATE `creature_spells` SET `name`='Silithus - Xil\'xix' WHERE `entry`=152860;
|
|
UPDATE `creature_spells` SET `name`='Blasted Lands - Razelikh the Defiler' WHERE `entry`=76640;
|
|
UPDATE `creature_spells` SET `name`='Badlands - Blacklash' WHERE `entry`=27570;
|
|
UPDATE `creature_spells` SET `name`='Arathi Highlands - Myzrael' WHERE `entry`=27550;
|
|
UPDATE `creature_spells` SET `name`='Silithus - Earthen Templar' WHERE `entry`=153070;
|
|
UPDATE `creature_spells` SET `name`='Duskwood - Enraged Gryphon' WHERE `entry`=95260;
|
|
UPDATE `creature_spells` SET `name`='Silverpine Forest - Nightlash' WHERE `entry`=19830;
|
|
UPDATE `creature_spells` SET `name`='Elwynn Forest - Forlorn Spirit' WHERE `entry`=20440;
|
|
UPDATE `creature_spells` SET `name`='Desolace - Kolkar Ambusher' WHERE `entry`=129770;
|
|
UPDATE `creature_spells` SET `name`='Zul\'Farrak - Sul\'lithuz Broodling' WHERE `entry`=81380;
|
|
UPDATE `creature_spells` SET `name`='Alterac Valley - Seasoned Irondeep Surveyor' WHERE `entry`=135550;
|
|
UPDATE `creature_spells` SET `name`='Eastern Plaguelands - Conquered Soul of the Blightcaller' WHERE `entry`=122080;
|
|
UPDATE `creature_spells` SET `name`='Naxxramas - Spirit of Mograine' WHERE `entry`=167750;
|
|
UPDATE `creature_spells` SET `name`='Razorfen Downs - Tomb Reaver' WHERE `entry`=73510;
|
|
UPDATE `creature_spells` SET `name`='Naxxramas - Sewage Slime' WHERE `entry`=163750;
|
|
UPDATE `creature_spells` SET `name`='Stranglethorn Vale - Gazban' WHERE `entry`=26240;
|
|
UPDATE `creature_spells` SET `name`='Eastern Plaguelands - Darrowshire Betrayer' WHERE `entry`=109470;
|
|
UPDATE `creature_spells` SET `name`='Badlands - Hematus' WHERE `entry`=27590;
|
|
UPDATE `creature_spells` SET `name`='Arathi Highlands - Vengeful Surge' WHERE `entry`=27760;
|
|
UPDATE `creature_spells` SET `name`='Molten Core - Flamewaker Healer' WHERE `entry`=116630;
|
|
UPDATE `creature_spells` SET `name`='Blackrock Spire - Gizrul the Slavener' WHERE `entry`=102680;
|
|
UPDATE `creature_spells` SET `name`='Blackwing Lair - Blue Drakonid' WHERE `entry`=142610;
|
|
UPDATE `creature_spells` SET `name`='Wailing Caverns - Mutanus the Devourer' WHERE `entry`=36540;
|
|
UPDATE `creature_spells` SET `name`='Ashenvale - Mystlash Flayer' WHERE `entry`=37220;
|
|
UPDATE `creature_spells` SET `name`='Hillsbrad Foothills - Searing Totem II' WHERE `entry`=39020;
|
|
UPDATE `creature_spells` SET `name`='Thousand Needles - Gravelsnout Digger' WHERE `entry`=41130;
|
|
UPDATE `creature_spells` SET `name`='Naxxramas - Unrelenting Trainee' WHERE `entry`=161240;
|
|
UPDATE `creature_spells` SET `name`='Ruins of Ahn\'Qiraj - Anubisath Swarmguard' WHERE `entry`=155380;
|
|
UPDATE `creature_spells` SET `name`='Naxxramas - Unrelenting Rider' WHERE `entry`=161260;
|
|
UPDATE `creature_spells` SET `name`='Blackrock Depths - Deep Stinger' WHERE `entry`=89260;
|
|
UPDATE `creature_spells` SET `name`='Orgrimmar - Summoned Succubus' WHERE `entry`=56770;
|
|
UPDATE `creature_spells` SET `name`='Razorfen Downs - Plaguemaw the Rotting' WHERE `entry`=73560;
|
|
UPDATE `creature_spells` SET `name`='Westfall - Defias Raider' WHERE `entry`=61800;
|
|
UPDATE `creature_spells` SET `name`='Naxxramas - Plagued Champion' WHERE `entry`=169830;
|
|
UPDATE `creature_spells` SET `name`='Blackrock Depths - Dredge Worm' WHERE `entry`=89250;
|
|
UPDATE `creature_spells` SET `name`='Alterac Mountains - Cyclonian' WHERE `entry`=62390;
|
|
UPDATE `creature_spells` SET `name`='The Barrens - Summoned Felhunter' WHERE `entry`=62680;
|
|
UPDATE `creature_spells` SET `name`='Naxxramas - Plagued Guardian' WHERE `entry`=169810;
|
|
UPDATE `creature_spells` SET `name`='The Barrens - Lunaclaw' WHERE `entry`=121380;
|
|
UPDATE `creature_spells` SET `name`='Blackrock Spire - Summoned Blackhand Veteran' WHERE `entry`=106810;
|
|
UPDATE `creature_spells` SET `name`='Tanaris - Treasure Hunting Swashbuckler' WHERE `entry`=79010;
|
|
UPDATE `creature_spells` SET `name`='Stratholme - Crimson Hammersmith' WHERE `entry`=111200;
|
|
UPDATE `creature_spells` SET `name`='Felwood - Infernal Bodyguard' WHERE `entry`=71350;
|
|
UPDATE `creature_spells` SET `name`='Zul\'Farrak - Nekrum Gutchewer' WHERE `entry`=77960;
|
|
UPDATE `creature_spells` SET `name`='Tanaris - Treasure Hunting Buccaneer' WHERE `entry`=79020;
|
|
UPDATE `creature_spells` SET `name`='Zul\'Farrak - Servant of Antu\'sul' WHERE `entry`=81560;
|
|
UPDATE `creature_spells` SET `name`='Blackwing Lair - Blackwing Legionnaire' WHERE `entry`=124160;
|
|
UPDATE `creature_spells` SET `name`='Sunken Temple - Nightmare Suppressor' WHERE `entry`=84970;
|
|
UPDATE `creature_spells` SET `name`='Blackrock Depths - Borer Beetle' WHERE `entry`=89320;
|
|
UPDATE `creature_spells` SET `name`='Blackrock Depths - Burrowing Thundersnout' WHERE `entry`=89280;
|
|
UPDATE `creature_spells` SET `name`='Blackrock Depths - Eviscerator' WHERE `entry`=90290;
|
|
UPDATE `creature_spells` SET `name`='Blackrock Depths - Ok\'thor the Breaker' WHERE `entry`=90300;
|
|
UPDATE `creature_spells` SET `name`='Blackrock Depths - Hedrum the Creeper' WHERE `entry`=90320;
|
|
UPDATE `creature_spells` SET `name`='Alterac Valley - Seasoned Irondeep Guard' WHERE `entry`=135520;
|
|
UPDATE `creature_spells` SET `name`='Eastern Plaguelands - Enraged Felbat' WHERE `entry`=95210;
|
|
UPDATE `creature_spells` SET `name`='Felwood - Arei' WHERE `entry`=95980;
|
|
UPDATE `creature_spells` SET `name`='Burning Steppes - Blackrock Raider' WHERE `entry`=96050;
|
|
UPDATE `creature_spells` SET `name`='Un\'Goro Crater - Lar\'korwi' WHERE `entry`=96840;
|
|
UPDATE `creature_spells` SET `name`='Un\'Goro Crater - Gorishi Hive Guard' WHERE `entry`=100400;
|
|
UPDATE `creature_spells` SET `name`='Blackrock Spire - Rookery Guardian' WHERE `entry`=102580;
|
|
UPDATE `creature_spells` SET `name`='Blackrock Spire - Burning Felhound' WHERE `entry`=102610;
|
|
UPDATE `creature_spells` SET `name`='Blackrock Spire - Burning Felguard' WHERE `entry`=102630;
|
|
UPDATE `creature_spells` SET `name`='Blackrock Spire - Solakar Flamewreath' WHERE `entry`=102640;
|
|
UPDATE `creature_spells` SET `name`='Darkshore - Xabraxxis' WHERE `entry`=103730;
|
|
UPDATE `creature_spells` SET `name`='Stratholme - Black Guard Sentry' WHERE `entry`=103940;
|
|
UPDATE `creature_spells` SET `name`='Naxxramas - Spirit of Blaumeux' WHERE `entry`=167760;
|
|
UPDATE `creature_spells` SET `name`='Blackrock Spire - Urok Doomhowl' WHERE `entry`=105840;
|
|
UPDATE `creature_spells` SET `name`='Stratholme - Bile Slime' WHERE `entry`=106970;
|
|
UPDATE `creature_spells` SET `name`='Western Plaguelands - Temporal Parasite' WHERE `entry`=107170;
|
|
UPDATE `creature_spells` SET `name`='Western Plaguelands - Farmer Dalson' WHERE `entry`=108360;
|
|
UPDATE `creature_spells` SET `name`='Stratholme - Undead Scarab' WHERE `entry`=108760;
|
|
UPDATE `creature_spells` SET `name`='Western Plaguelands - Rotting Worm' WHERE `entry`=109250;
|
|
UPDATE `creature_spells` SET `name`='Eastern Plaguelands - Darrowshire Defender' WHERE `entry`=109480;
|
|
UPDATE `creature_spells` SET `name`='Eastern Plaguelands - Marauding Corpse' WHERE `entry`=109510;
|
|
UPDATE `creature_spells` SET `name`='Naxxramas - Bile Sludge' WHERE `entry`=161420;
|
|
UPDATE `creature_spells` SET `name`='Eastern Plaguelands - Bloodletter' WHERE `entry`=109540;
|
|
UPDATE `creature_spells` SET `name`='Desolace - Magrami Spectre' WHERE `entry`=115600;
|
|
UPDATE `creature_spells` SET `name`='Alterac Valley - Whitewhisker Overseer' WHERE `entry`=116050;
|
|
UPDATE `creature_spells` SET `name`='Ashenvale - Reef Shark' WHERE `entry`=121230;
|
|
UPDATE `creature_spells` SET `name`='The Hinterlands - Great Shark' WHERE `entry`=121240;
|
|
UPDATE `creature_spells` SET `name`='Molten Core - Lava Spawn' WHERE `entry`=122650;
|
|
UPDATE `creature_spells` SET `name`='The Barrens - Burning Blade Toxicologist' WHERE `entry`=123190;
|
|
UPDATE `creature_spells` SET `name`='Eastern Plaguelands - Demetria' WHERE `entry`=123390;
|
|
UPDATE `creature_spells` SET `name`='Blackwing Lair - Death Talon Dragonspawn' WHERE `entry`=124220;
|
|
UPDATE `creature_spells` SET `name`='Alterac Valley - Veteran Coldmine Guard' WHERE `entry`=135350;
|
|
UPDATE `creature_spells` SET `name`='Alterac Valley - Veteran Coldmine Surveyor' WHERE `entry`=135380;
|
|
UPDATE `creature_spells` SET `name`='Alterac Valley - Seasoned Irondeep Raider' WHERE `entry`=135430;
|
|
UPDATE `creature_spells` SET `name`='Alterac Valley - Champion Irondeep Raider' WHERE `entry`=135450;
|
|
UPDATE `creature_spells` SET `name`='Alterac Valley - Veteran Irondeep Guard' WHERE `entry`=135530;
|
|
UPDATE `creature_spells` SET `name`='Blackwing Lair - Green Drakonid' WHERE `entry`=142620;
|
|
UPDATE `creature_spells` SET `name`='Blackwing Lair - Bronze Drakonid' WHERE `entry`=142630;
|
|
UPDATE `creature_spells` SET `name`='Blackwing Lair - Chromatic Drakonid' WHERE `entry`=143020;
|
|
UPDATE `creature_spells` SET `name`='Dire Maul - Eye of Immol\'thar' WHERE `entry`=143960;
|
|
UPDATE `creature_spells` SET `name`='Dire Maul - Lord Hel\'nurath' WHERE `entry`=145060;
|
|
UPDATE `creature_spells` SET `name`='Eastern Plaguelands - Terrordale Spirit' WHERE `entry`=145640;
|
|
UPDATE `creature_spells` SET `name`='Blackwing Lair - Corrupted Infernal' WHERE `entry`=146680;
|
|
UPDATE `creature_spells` SET `name`='Zul\'Gurub - Hazza\'rah' WHERE `entry`=150830;
|
|
UPDATE `creature_spells` SET `name`='Zul\'Gurub - Wushoolay' WHERE `entry`=150850;
|
|
UPDATE `creature_spells` SET `name`='Silithus - The Duke of Cynders' WHERE `entry`=152060;
|
|
UPDATE `creature_spells` SET `name`='Silithus - Hoary Templar' WHERE `entry`=152120;
|
|
UPDATE `creature_spells` SET `name`='Silithus - The Duke of Zephyrs' WHERE `entry`=152200;
|
|
UPDATE `creature_spells` SET `name`='Silithus - Arakis' WHERE `entry`=152900;
|
|
UPDATE `creature_spells` SET `name`='Ruins of Ahn\'Qiraj - Mana Fiend' WHERE `entry`=155270;
|
|
UPDATE `creature_spells` SET `name`='Ruins of Ahn\'Qiraj - Anubisath Warrior' WHERE `entry`=155370;
|
|
UPDATE `creature_spells` SET `name`='Naxxramas - Spectral Trainee' WHERE `entry`=161270;
|
|
UPDATE `creature_spells` SET `name`='Naxxramas - Spectral Rider' WHERE `entry`=161500;
|
|
UPDATE `creature_spells` SET `name`='Naxxramas - Naxxramas Follower' WHERE `entry`=165050;
|
|
UPDATE `creature_spells` SET `name`='Naxxramas - Spirit of Zeliek' WHERE `entry`=167770;
|
|
UPDATE `creature_spells` SET `name`='Naxxramas - Spirit of Korth\'azz' WHERE `entry`=167780;
|
|
UPDATE `creature_spells` SET `name`='Naxxramas - Plagued Warrior' WHERE `entry`=169840;
|
|
UPDATE `creature_spells` SET `name`='Silverpine Forest - Deathstalker Faerleia' WHERE `entry`=20580;
|
|
UPDATE `creature_spells` SET `name`='Blackrock Spire - Pyroguard Emberseer' WHERE `entry`=98160;
|
|
UPDATE `creature_spells` SET `name`='Blackrock Spire - Blackhand Incarcerator' WHERE `entry`=103160;
|
|
UPDATE `creature_spells` SET `name`='Alterac Valley - Seasoned Coldmine Guard' WHERE `entry`=135340;
|
|
UPDATE `creature_spells` SET `name`='Alterac Valley - Champion Irondeep Surveyor' WHERE `entry`=135570;
|
|
UPDATE `creature_spells` SET `name`='Alterac Valley - Champion Irondeep Guard' WHERE `entry`=135540;
|
|
UPDATE `creature_spells` SET `name`='Alterac Valley - Seasoned Coldmine Surveyor' WHERE `entry`=135370;
|
|
UPDATE `creature_spells` SET `name`='Sunken Temple - Jade' WHERE `entry`=10630;
|
|
UPDATE `creature_spells` SET `name`='Felwood - Kroshius' WHERE `entry`=144670;
|
|
UPDATE `creature_spells` SET `name`='Zul\'Gurub - Gri\'lek' WHERE `entry`=150820;
|
|
UPDATE `creature_spells` SET `name`='Stonetalon Mountains - Enraged Hippogryph' WHERE `entry`=95270;
|
|
UPDATE `creature_spells` SET `name`='Eastern Plaguelands - Davil Lightfire' WHERE `entry`=109440;
|
|
UPDATE `creature_spells` SET `name`='Eastern Plaguelands - Horgus the Ravager' WHERE `entry`=109460;
|
|
UPDATE `creature_spells` SET `name`='Eastern Plaguelands - Silver Hand Disciple' WHERE `entry`=109490;
|
|
UPDATE `creature_spells` SET `name`='Alterac Valley - Champion Coldmine Guard' WHERE `entry`=135360;
|
|
UPDATE `creature_spells` SET `name`='Alterac Valley - Champion Coldmine Surveyor' WHERE `entry`=135390;
|
|
UPDATE `creature_spells` SET `name`='Alterac Valley - Seasoned Coldmine Invader' WHERE `entry`=135490;
|
|
UPDATE `creature_spells` SET `name`='Alterac Valley - Veteran Coldmine Invader' WHERE `entry`=135500;
|
|
UPDATE `creature_spells` SET `name`='Alterac Valley - Champion Coldmine Invader' WHERE `entry`=135510;
|
|
UPDATE `creature_spells` SET `name`='Moonglade - Nightmare Phantasm' WHERE `entry`=156290;
|
|
UPDATE `creature_spells` SET `name`='Stonetalon Mountains - Goggeroc' WHERE `entry`=119200;
|
|
UPDATE `creature_spells` SET `name`='Scholomance - Bone Mage' WHERE `entry`=161200;
|
|
UPDATE `creature_spells` SET `name`='Stonetalon Mountains - Windshear Tunnel Rat' WHERE `entry`=40010;
|
|
UPDATE `creature_spells` SET `name`='Eastern Plaguelands - Captain Redpath' WHERE `entry`=109370;
|
|
UPDATE `creature_spells` SET `name`='Blackrock Spire - Spectral Assassin' WHERE `entry`=160660;
|
|
UPDATE `creature_spells` SET `name`='Eastern Plaguelands - Redpath the Corrupted' WHERE `entry`=109380;
|
|
UPDATE `creature_spells` SET `name`='Eastern Plaguelands - Redpath Militia' WHERE `entry`=109500;
|
|
UPDATE `creature_spells` SET `name`='Stratholme - Black Guard Swordsmith' WHERE `entry`=111210;
|
|
UPDATE `creature_spells` SET `name`='Hillsbrad Foothills - Milton Beats' WHERE `entry`=130820;
|
|
UPDATE `creature_spells` SET `name`='Silithus - The Duke of Fathoms' WHERE `entry`=152070;
|
|
UPDATE `creature_spells` SET `name`='Naxxramas - Plagued Construct' WHERE `entry`=169820;
|
|
|
|
-- Remove some unused spell lists.
|
|
DELETE FROM `creature_spells` WHERE `entry` IN (72860, 1600000, 1600010, 1600020, 1600030, 1600040, 1600050, 9876000);
|
|
UPDATE `creature_template` SET `spell_list_id`=73510 WHERE `entry`=7351;
|
|
|
|
|
|
-- End of migration.
|
|
END IF;
|
|
END??
|
|
DELIMITER ;
|
|
CALL add_migration();
|
|
DROP PROCEDURE IF EXISTS add_migration;
|