-- Add faction gating: an "Alliance"/"Horde" destination is only offered to (and reachable by) that
-- faction's own players, so a character can never wind up dumped in the middle of an enemy capital
-- to get jumped by guards. "Neutral" (sanctuary cities like Shattrath/Dalaran) stays open to
-- everyone. GM debug mode (WaygateNetwork.Debug) is the only override, matching the existing
-- "GM sees/travels everywhere regardless" bypass already used for attunement.
ALTER TABLE `mod_waygate_network_locations`
    ADD COLUMN `faction` ENUM('Alliance','Horde','Neutral') NOT NULL DEFAULT 'Neutral' AFTER `continent`;

UPDATE `mod_waygate_network_locations` SET `faction` = 'Alliance' WHERE `id` IN (1, 2, 4, 7);
UPDATE `mod_waygate_network_locations` SET `faction` = 'Horde' WHERE `id` IN (3, 5, 6, 8);
-- IDs 9 (Shattrath) and 10 (Dalaran) are real sanctuary cities open to both factions -- already
-- correct at the column's default ('Neutral'), listed here only for clarity.
UPDATE `mod_waygate_network_locations` SET `faction` = 'Neutral' WHERE `id` IN (9, 10);
