-- Add continent grouping so the travel menu can be organized as continent -> destination instead of
-- one long flat list, now that destinations are starting to grow past the original 8 capitals.
-- Exodar/Silvermoon are grouped by their racial/geographic continent (Kalimdor/Eastern Kingdoms
-- respectively), not by their raw `map` id (530), which they share with genuine Outland zones for an
-- unrelated client-data reason -- grouping by raw map id would put them in a nonsensical "Outland"
-- bucket from a player's point of view.
ALTER TABLE `mod_waygate_network_locations`
    ADD COLUMN `continent` ENUM('Eastern Kingdoms','Kalimdor','Outland','Northrend') NOT NULL DEFAULT 'Eastern Kingdoms' AFTER `name`;

UPDATE `mod_waygate_network_locations` SET `continent` = 'Eastern Kingdoms' WHERE `id` IN (1, 2, 3, 8);
UPDATE `mod_waygate_network_locations` SET `continent` = 'Kalimdor' WHERE `id` IN (4, 5, 6, 7);

-- First non-capital destinations: one each in Outland and Northrend, to actually exercise the new
-- continent grouping (and the WaygateNetwork.CrossMapCostCopper cost path) before curating a full
-- quest-hub list.
DELETE FROM `mod_waygate_network_locations` WHERE `id` IN (9, 10);
INSERT INTO `mod_waygate_network_locations`
    (`id`, `name`, `continent`, `map`, `zone`, `position_x`, `position_y`, `position_z`, `orientation`)
VALUES
    (9,  'Shattrath City', 'Outland',   530, 3703, -1838.16, 5301.79, -12.428, 5.9517),
    (10, 'Dalaran',        'Northrend', 571, 4395,  5807.98,  588.487, 660.94,  1.66594);
