text: ﻿/*
    routes
    ------
    Exporting all rows
  */
  INSERT INTO routes (routeid, fromPort, toPort, routeStr) VALUES (1, 'LHR', 'CDG', 'LHRCDG');
  INSERT INTO routes (routeid, fromPort, toPort, routeStr) VALUES (2, 'LHR', 'AMS', 'LHRAMS');
  INSERT INTO routes (routeid, fromPort, toPort, routeStr) VALUES (3, 'LHR', 'MAD', 'LHRMAD');
  INSERT INTO routes (routeid, fromPort, toPort, routeStr) VALUES (4, 'LHR', 'BCN', 'LHRBCN');
  INSERT INTO routes (routeid, fromPort, toPort, routeStr) VALUES (5, 'LHR', 'FCO', 'LHRFCO');
  INSERT INTO routes (routeid, fromPort, toPort, routeStr) VALUES (6, 'LHR', 'DUB', 'LHRDUB');
  INSERT INTO routes (routeid, fromPort, toPort, routeStr) VALUES (7, 'LHR', 'ZRH', 'LHRZRH');
  INSERT INTO routes (routeid, fromPort, toPort, routeStr) VALUES (8, 'LHR', 'CPH', 'LHRCPH');
  INSERT INTO routes (routeid, fromPort, toPort, routeStr) VALUES (9, 'LHR', 'VIE', 'LHRVIE');
  INSERT INTO routes (routeid, fromPort, toPort, routeStr) VALUES (10, 'LHR', 'TXL', 'LHRTXL');
  INSERT INTO routes (routeid, fromPort, toPort, routeStr) VALUES (11, 'CDG', 'LHR', 'CDGLHR');
  INSERT INTO routes (routeid, fromPort, toPort, routeStr) VALUES (12, 'CDG', 'AMS', 'CDGAMS');
  INSERT INTO routes (routeid, fromPort, toPort, routeStr) VALUES (13, 'CDG', 'MAD', 'CDGMAD');
  INSERT INTO routes (routeid, fromPort, toPort, routeStr) VALUES (14, 'CDG', 'BCN', 'CDGBCN');
  INSERT INTO routes (routeid, fromPort, toPort, routeStr) VALUES (15, 'CDG', 'FCO', 'CDGFCO');
  INSERT INTO routes (routeid, fromPort, toPort, routeStr) VALUES (16, 'CDG', 'DUB', 'CDGDUB');
  INSERT INTO routes (routeid, fromPort, toPort, routeStr) VALUES (17, 'CDG', 'ZRH', 'CDGZRH');
  INSERT INTO routes (routeid, fromPort, toPort, routeStr) VALUES (18, 'CDG', 'CPH', 'CDGCPH');
  INSERT INTO routes (routeid, fromPort, toPort, routeStr) VALUES (19, 'CDG', 'VIE', 'CDGVIE');
  INSERT INTO routes (routeid, fromPort, toPort, routeStr) VALUES (20, 'CDG', 'TXL', 'CDGTXL');
  INSERT INTO routes (routeid, fromPort, toPort, routeStr) VALUES (21, 'AMS', 'LHR', 'AMSLHR');
  INSERT INTO routes (routeid, fromPort, toPort, routeStr) VALUES (22, 'AMS', 'CDG', 'AMSCDG');
  INSERT INTO routes (routeid, fromPort, toPort, routeStr) VALUES (23, 'AMS', 'MAD', 'AMSMAD');
  INSERT INTO routes (routeid, fromPort, toPort, routeStr) VALUES (24, 'AMS', 'BCN', 'AMSBCN');
  INSERT INTO routes (routeid, fromPort, toPort, routeStr) VALUES (25, 'AMS', 'FCO', 'AMSFCO');
  INSERT INTO routes (routeid, fromPort, toPort, routeStr) VALUES (26, 'AMS', 'DUB', 'AMSDUB');
  INSERT INTO routes (routeid, fromPort, toPort, routeStr) VALUES (27, 'AMS', 'ZRH', 'AMSZRH');
  INSERT INTO routes (routeid, fromPort, toPort, routeStr) VALUES (28, 'AMS', 'CPH', 'AMSCPH');
  INSERT INTO routes (routeid, fromPort, toPort, routeStr) VALUES (29, 'AMS', 'VIE', 'AMSVIE');
  INSERT INTO routes (routeid, fromPort, toPort, routeStr) VALUES (30, 'AMS', 'TXL', 'AMSTXL');
  INSERT INTO routes (routeid, fromPort, toPort, routeStr) VALUES (31, 'MAD', 'LHR', 'MADLHR');
  INSERT INTO routes (routeid, fromPort, toPort, routeStr) VALUES (32, 'MAD', 'CDG', 'MADCDG');
  INSERT INTO routes (routeid, fromPort, toPort, routeStr) VALUES (33, 'MAD', 'AMS', 'MADAMS');
  INSERT INTO routes (routeid, fromPort, toPort, routeStr) VALUES (34, 'MAD', 'BCN', 'MADBCN');
  INSERT INTO routes (routeid, fromPort, toPort, routeStr) VALUES (35, 'MAD', 'FCO', 'MADFCO');
  INSERT INTO routes (routeid, fromPort, toPort, routeStr) VALUES (36, 'MAD', 'DUB', 'MADDUB');
  INSERT INTO routes (routeid, fromPort, toPort, routeStr) VALUES (37, 'MAD', 'ZRH', 'MADZRH');
  INSERT INTO routes (routeid, fromPort, toPort, routeStr) VALUES (38, 'MAD', 'CPH', 'MADCPH');
  INSERT INTO routes (routeid, fromPort, toPort, routeStr) VALUES (39, 'MAD', 'VIE', 'MADVIE');
  INSERT INTO routes (routeid, fromPort, toPort, routeStr) VALUES (40, 'MAD', 'TXL', 'MADTXL');
  INSERT INTO routes (routeid, fromPort, toPort, routeStr) VALUES (41, 'BCN', 'LHR', 'BCNLHR');
  INSERT INTO routes (routeid, fromPort, toPort, routeStr) VALUES (42, 'BCN', 'CDG', 'BCNCDG');
  INSERT INTO routes (routeid, fromPort, toPort, routeStr) VALUES (43, 'BCN', 'AMS', 'BCNAMS');
  INSERT INTO routes (routeid, fromPort, toPort, routeStr) VALUES (44, 'BCN', 'MAD', 'BCNMAD');
  INSERT INTO routes (routeid, fromPort, toPort, routeStr) VALUES (45, 'BCN', 'FCO', 'BCNFCO');
  INSERT INTO routes (routeid, fromPort, toPort, routeStr) VALUES (46, 'BCN', 'DUB', 'BCNDUB');
  INSERT INTO routes (routeid, fromPort, toPort, routeStr) VALUES (47, 'BCN', 'ZRH', 'BCNZRH');
  INSERT INTO routes (routeid, fromPort, toPort, routeStr) VALUES (48, 'BCN', 'CPH', 'BCNCPH');
  INSERT INTO routes (routeid, fromPort, toPort, routeStr) VALUES (49, 'BCN', 'VIE', 'BCNVIE');
  INSERT INTO routes (routeid, fromPort, toPort, routeStr) VALUES (50, 'BCN', 'TXL', 'BCNTXL');
  INSERT INTO routes (routeid, fromPort, toPort, routeStr) VALUES (51, 'FCO', 'LHR', 'FCOLHR');
  INSERT INTO routes (routeid, fromPort, toPort, routeStr) VALUES (52, 'FCO', 'CDG', 'FCOCDG');
  INSERT INTO routes (routeid, fromPort, toPort, routeStr) VALUES (53, 'FCO', 'AMS', 'FCOAMS');
  INSERT INTO routes (routeid, fromPort, toPort, routeStr) VALUES (54, 'FCO', 'MAD', 'FCOMAD');
  INSERT INTO routes (routeid, fromPort, toPort, routeStr) VALUES (55, 'FCO', 'BCN', 'FCOBCN');
  INSERT INTO routes (routeid, fromPort, toPort, routeStr) VALUES (56, 'FCO', 'DUB', 'FCODUB');
  INSERT INTO routes (routeid, fromPort, toPort, routeStr) VALUES (57, 'FCO', 'ZRH', 'FCOZRH');
  INSERT INTO routes (routeid, fromPort, toPort, routeStr) VALUES (58, 'FCO', 'CPH', 'FCOCPH');
  INSERT INTO routes (routeid, fromPort, toPort, routeStr) VALUES (59, 'FCO', 'VIE', 'FCOVIE');
  INSERT INTO routes (routeid, fromPort, toPort, routeStr) VALUES (60, 'FCO', 'TXL', 'FCOTXL');
  INSERT INTO routes (routeid, fromPort, toPort, routeStr) VALUES (61, 'DUB', 'LHR', 'DUBLHR');
  INSERT INTO routes (routeid, fromPort, toPort, routeStr) VALUES (62, 'DUB', 'CDG', 'DUBCDG');
  INSERT INTO routes (routeid, fromPort, toPort, routeStr) VALUES (63, 'DUB', 'AMS', 'DUBAMS');
  INSERT INTO routes (routeid, fromPort, toPort, routeStr) VALUES (64, 'DUB', 'MAD', 'DUBMAD');
  INSERT INTO routes (routeid, fromPort, toPort, routeStr) VALUES (65, 'DUB', 'BCN', 'DUBBCN');
  INSERT INTO routes (routeid, fromPort, toPort, routeStr) VALUES (66, 'DUB', 'FCO', 'DUBFCO');
  INSERT INTO routes (routeid, fromPort, toPort, routeStr) VALUES (67, 'DUB', 'ZRH', 'DUBZRH');
  INSERT INTO routes (routeid, fromPort, toPort, routeStr) VALUES (68, 'DUB', 'CPH', 'DUBCPH');
  INSERT INTO routes (routeid, fromPort, toPort, routeStr) VALUES (69, 'DUB', 'VIE', 'DUBVIE');
  INSERT INTO routes (routeid, fromPort, toPort, routeStr) VALUES (70, 'DUB', 'TXL', 'DUBTXL');
  INSERT INTO routes (routeid, fromPort, toPort, routeStr) VALUES (71, 'ZRH', 'LHR', 'ZRHLHR');
  INSERT INTO routes (routeid, fromPort, toPort, routeStr) VALUES (72, 'ZRH', 'CDG', 'ZRHCDG');
  INSERT INTO routes (routeid, fromPort, toPort, routeStr) VALUES (73, 'ZRH', 'AMS', 'ZRHAMS');
  INSERT INTO routes (routeid, fromPort, toPort, routeStr) VALUES (74, 'ZRH', 'MAD', 'ZRHMAD');
  INSERT INTO routes (routeid, fromPort, toPort, routeStr) VALUES (75, 'ZRH', 'BCN', 'ZRHBCN');
  INSERT INTO routes (routeid, fromPort, toPort, routeStr) VALUES (76, 'ZRH', 'FCO', 'ZRHFCO');
  INSERT INTO routes (routeid, fromPort, toPort, routeStr) VALUES (77, 'ZRH', 'DUB', 'ZRHDUB');
  INSERT INTO routes (routeid, fromPort, toPort, routeStr) VALUES (78, 'ZRH', 'CPH', 'ZRHCPH');
  INSERT INTO routes (routeid, fromPort, toPort, routeStr) VALUES (79, 'ZRH', 'VIE', 'ZRHVIE');
  INSERT INTO routes (routeid, fromPort, toPort, routeStr) VALUES (80, 'ZRH', 'TXL', 'ZRHTXL');
  INSERT INTO routes (routeid, fromPort, toPort, routeStr) VALUES (81, 'CPH', 'LHR', 'CPHLHR');
  INSERT INTO routes (routeid, fromPort, toPort, routeStr) VALUES (82, 'CPH', 'CDG', 'CPHCDG');
  INSERT INTO routes (routeid, fromPort, toPort, routeStr) VALUES (83, 'CPH', 'AMS', 'CPHAMS');
  INSERT INTO routes (routeid, fromPort, toPort, routeStr) VALUES (84, 'CPH', 'MAD', 'CPHMAD');
  INSERT INTO routes (routeid, fromPort, toPort, routeStr) VALUES (85, 'CPH', 'BCN', 'CPHBCN');
  INSERT INTO routes (routeid, fromPort, toPort, routeStr) VALUES (86, 'CPH', 'FCO', 'CPHFCO');
  INSERT INTO routes (routeid, fromPort, toPort, routeStr) VALUES (87, 'CPH', 'DUB', 'CPHDUB');
  INSERT INTO routes (routeid, fromPort, toPort, routeStr) VALUES (88, 'CPH', 'ZRH', 'CPHZRH');
  INSERT INTO routes (routeid, fromPort, toPort, routeStr) VALUES (89, 'CPH', 'VIE', 'CPHVIE');
  INSERT INTO routes (routeid, fromPort, toPort, routeStr) VALUES (90, 'CPH', 'TXL', 'CPHTXL');
  INSERT INTO routes (routeid, fromPort, toPort, routeStr) VALUES (91, 'VIE', 'LHR', 'VIELHR');
  INSERT INTO routes (routeid, fromPort, toPort, routeStr) VALUES (92, 'VIE', 'CDG', 'VIECDG');
  INSERT INTO routes (routeid, fromPort, toPort, routeStr) VALUES (93, 'VIE', 'AMS', 'VIEAMS');
  INSERT INTO routes (routeid, fromPort, toPort, routeStr) VALUES (94, 'VIE', 'MAD', 'VIEMAD');
  INSERT INTO routes (routeid, fromPort, toPort, routeStr) VALUES (95, 'VIE', 'BCN', 'VIEBCN');
  INSERT INTO routes (routeid, fromPort, toPort, routeStr) VALUES (96, 'VIE', 'FCO', 'VIEFCO');
  INSERT INTO routes (routeid, fromPort, toPort, routeStr) VALUES (97, 'VIE', 'DUB', 'VIEDUB');
  INSERT INTO routes (routeid, fromPort, toPort, routeStr) VALUES (98, 'VIE', 'ZRH', 'VIEZRH');
  INSERT INTO routes (routeid, fromPort, toPort, routeStr) VALUES (99, 'VIE', 'CPH', 'VIECPH');
  INSERT INTO routes (routeid, fromPort, toPort, routeStr) VALUES (100, 'VIE', 'TXL', 'VIETXL');
  INSERT INTO routes (routeid, fromPort, toPort, routeStr) VALUES (101, 'TXL', 'LHR', 'TXLLHR');
  INSERT INTO routes (routeid, fromPort, toPort, routeStr) VALUES (102, 'TXL', 'CDG', 'TXLCDG');
  INSERT INTO routes (routeid, fromPort, toPort, routeStr) VALUES (103, 'TXL', 'AMS', 'TXLAMS');
  INSERT INTO routes (routeid, fromPort, toPort, routeStr) VALUES (104, 'TXL', 'MAD', 'TXLMAD');
  INSERT INTO routes (routeid, fromPort, toPort, routeStr) VALUES (105, 'TXL', 'BCN', 'TXLBCN');
  INSERT INTO routes (routeid, fromPort, toPort, routeStr) VALUES (106, 'TXL', 'FCO', 'TXLFCO');
  INSERT INTO routes (routeid, fromPort, toPort, routeStr) VALUES (107, 'TXL', 'DUB', 'TXLDUB');
  INSERT INTO routes (routeid, fromPort, toPort, routeStr) VALUES (108, 'TXL', 'ZRH', 'TXLZRH');
  INSERT INTO routes (routeid, fromPort, toPort, routeStr) VALUES (109, 'TXL', 'CPH', 'TXLCPH');
  INSERT INTO routes (routeid, fromPort, toPort, routeStr) VALUES (110, 'TXL', 'VIE', 'TXLVIE');
  /* 110 row(s) exported */
  
  