Skip to Content

Tunnels record their owner, POS and time zone

Shipped 2026-11-04

A tool we are building next needs to know who owns each iFLY network tunnel and which point-of-sale system it runs (TUN-942).

New columns

Migration 0024 adds two columns to channel_tunnels and fills them from ops’ list of 4 November:

  • owner: corporate, franchisee or third party.
  • pos: Convergence, FuseMetrix, Tunn3l, or unknown when ops do not know. The values are the same keys the booking connectors use.

Tunnels not on the list (independent tunnels, closed or unbuilt sites) are left empty. Rows were matched to the list by city and country, because several of our titles differ from ops’ names. The migration only fills empty values, so it never overwrites an edit.

Admin

CMS › Tunnels shows Owner and POS columns, and the tunnel form has Owner, POS and Time zone fields. Time zone was missing from the form, so a tunnel added in admin got the column default, Europe/London; that is how Miami had the wrong time zone until migration 0013. It is now required, and offers 56 zones covering the countries we have tunnels in rather than every zone in the world. The list lives in api/src/config/tunnels.js and admin’s constants.

Time zone corrections

Migration 0024 also moves every stored time zone onto that list. Most changes only swap an old alias for the canonical name (Poland → Europe/Warsaw). Eight tunnels had the wrong offset and are corrected:

TunnelWasNow
Perth iFLYAustralia/BrisbaneAustralia/Perth
Bali iFLYAsia/JakartaAsia/Makassar
SkyVenture GramadoEurope/LondonAmerica/Sao_Paulo
México BFPAmerica/St_LuciaAmerica/Mexico_City
Fly Tribe Oslo, MODERN Activity CenterEurope/LondonEurope/Oslo
Bodyflight Göteborg, Fly Tribe MalmoEurope/LondonEurope/Stockholm

Two tunnels also had the wrong country: MegaFly (Lørenskog) is now Norway, not Sweden, and LUXFLY is now Luxembourg, not Belgium.

Last updated on