ALTER TABLE nn_fleet_routing ADD COLUMN IF NOT EXISTS hostname VARCHAR(100) DEFAULT NULL AFTER node_role;
UPDATE nn_fleet_routing SET hostname = 'sparrow.birdsofnorden.se' WHERE node_role = 'dns';
UPDATE nn_fleet_routing SET hostname = 'brewbox.hopkraft.nl' WHERE node_role = 'proxy';
UPDATE nn_fleet_routing SET hostname = 'dev.adriancodez.com' WHERE node_role = 'filter';
UPDATE nn_fleet_routing SET hostname = 'vault.pixelnostalgia.jp' WHERE node_role = 'shield';
UPDATE nn_fleet_routing SET hostname = 'lava.rockpiles.is' WHERE node_role = 'origin';
UPDATE nn_fleet_routing SET hostname = 'calc.budgetnerds.sg' WHERE node_role = 'payment';
UPDATE nn_fleet_routing SET hostname = 'puzzles.chessgrind.ro' WHERE node_role = 'email';
