FlagFlayer
51 lines
1.8 KiB
SQL
51 lines
1.8 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`='20220925222431');
|
|
IF v=0 THEN
|
|
INSERT INTO `migrations` VALUES ('20220925222431');
|
|
-- Add your query below.
|
|
|
|
INSERT INTO `game_graveyard_zone` (`id`, `ghost_zone`, `faction`, `patch_min`, `patch_max`) VALUES
|
|
-- Set Mulgore, Red Cloud Mesa GY for Brambleblade Ravine, Kodo Rock, Campe Narache
|
|
(34, 358, 67, 0, 10),
|
|
(34, 637, 67, 0, 10),
|
|
(34, 221, 67, 0, 10),
|
|
-- Set Durotar, Valley of Trials for Spirit Rock, The Den, Hidden Path, Burning Blade Coven until patch 1.6
|
|
(709, 639, 67, 0, 3),
|
|
(709, 364, 67, 0, 3),
|
|
(709, 638, 67, 0, 3),
|
|
(709, 365, 67, 0, 3),
|
|
-- Set Durotar, Valley of Trials graveyard for Durotar from patch 1.6 onward
|
|
(709, 14, 67, 4, 10),
|
|
-- Set Tirisfal Glades, Deathknell GY for Shadow Grave, Night Web's Hollow
|
|
(94, 2117, 67, 0, 10),
|
|
(94, 155, 67, 0, 10),
|
|
-- Set Aldrassil, Teldrassil GY for Aldrassil, Shadowthread Cave
|
|
(93, 256, 469, 0, 10),
|
|
(93, 257, 469, 0, 10),
|
|
-- Set Anvilmar, Dun Morogh GY for Anvilmar
|
|
(100, 77, 469, 0, 10),
|
|
-- Set Northshire, Elwynn Forest GY for Northshire Abbey, Echo Ridge Mine, Northshire Vineyards
|
|
(105, 24, 469, 0, 10),
|
|
(105, 34, 469, 0, 10),
|
|
(105, 59, 469, 0, 10);
|
|
|
|
-- Remove invalid Camp Taurajo graveyard for Stonetalon Mountains
|
|
DELETE FROM `game_graveyard_zone` WHERE `id`=229 AND `ghost_zone`=406;
|
|
|
|
-- Remove invalid Horde-only Wetlands graveyard for Loch Modan
|
|
DELETE FROM `game_graveyard_zone` WHERE `id`=7 AND `faction`=67 AND `ghost_zone`=38;
|
|
|
|
-- Set Durotar, Valley of Trials for Valley of Trials until patch 1.6
|
|
UPDATE `game_graveyard_zone` SET `patch_max`=3 WHERE `id`=709 AND `ghost_zone`=363;
|
|
|
|
-- End of migration.
|
|
END IF;
|
|
END??
|
|
delimiter ;
|
|
CALL add_migration();
|
|
DROP PROCEDURE IF EXISTS add_migration;
|