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:
| Tunnel | Was | Now |
|---|---|---|
| Perth iFLY | Australia/Brisbane | Australia/Perth |
| Bali iFLY | Asia/Jakarta | Asia/Makassar |
| SkyVenture Gramado | Europe/London | America/Sao_Paulo |
| México BFP | America/St_Lucia | America/Mexico_City |
| Fly Tribe Oslo, MODERN Activity Center | Europe/London | Europe/Oslo |
| Bodyflight Göteborg, Fly Tribe Malmo | Europe/London | Europe/Stockholm |
Two tunnels also had the wrong country: MegaFly (Lørenskog) is now Norway, not Sweden, and LUXFLY is now Luxembourg, not Belgium.