PRAGMA foreign_keys = ON;

PRAGMA writable_schema = 1;
DELETE FROM sqlite_master WHERE type IN ("table", "index", "trigger");
PRAGMA writable_schema = 0;
VACUUM;

CREATE TABLE "airlines" (
"uid" INT,
"Airline" TEXT,
"Abbreviation" TEXT,
"Country" TEXT,
PRIMARY KEY ("uid")
);

CREATE TABLE "airports" (
"AirportCode" TEXT,
"AirportName" TEXT,
PRIMARY KEY ("AirportCode")
);

CREATE TABLE "flights" (
"Airline" INT,
"FlightNo" INT,
"SourceAirport" TEXT,
"DestAirport" TEXT,
PRIMARY KEY ("Airline", "FlightNo"),
FOREIGN KEY ("SourceAirport") REFERENCES "airports"("AirportCode"),
FOREIGN KEY ("DestAirport") REFERENCES "airports"("AirportCode")
);





INSERT INTO "airlines" VALUES ("1", "Global Air", "GA", "USA");
INSERT INTO "airlines" VALUES ("2", "Skyways", "SW", "UK");
INSERT INTO "airlines" VALUES ("3", "Sunshine Airlines", "SA", "Australia");
INSERT INTO "airlines" VALUES ("4", "Northern Wings", "NW", "Canada");
INSERT INTO "airlines" VALUES ("5", "Eastern Express", "EE", "China");
INSERT INTO "airlines" VALUES ("6", "Pacific Blue", "PB", "New Zealand");
INSERT INTO "airports" VALUES ("JFK", "John F. Kennedy International Airport");
INSERT INTO "airports" VALUES ("LHR", "London Heathrow Airport");
INSERT INTO "airports" VALUES ("SYD", "Sydney Kingsford Smith Airport");
INSERT INTO "airports" VALUES ("YYZ", "Toronto Pearson International Airport");
INSERT INTO "airports" VALUES ("PEK", "Beijing Capital International Airport");
INSERT INTO "airports" VALUES ("AKL", "Auckland Airport");
INSERT INTO "airports" VALUES ("SFO", "San Francisco International Airport");
INSERT INTO "airports" VALUES ("LGW", "London Gatwick Airport");
INSERT INTO "airports" VALUES ("MEL", "Melbourne Airport");
INSERT INTO "airports" VALUES ("YVR", "Vancouver International Airport");
INSERT INTO "flights" VALUES ("1", "101", "JFK", "LHR");
INSERT INTO "flights" VALUES ("1", "102", "JFK", "SFO");
INSERT INTO "flights" VALUES ("1", "103", "SFO", "JFK");
INSERT INTO "flights" VALUES ("1", "104", "LHR", "JFK");
INSERT INTO "flights" VALUES ("1", "105", "LHR", "LGW");
INSERT INTO "flights" VALUES ("1", "106", "LGW", "LHR");
INSERT INTO "flights" VALUES ("1", "107", "JFK", "YYZ");
INSERT INTO "flights" VALUES ("1", "108", "YYZ", "JFK");
INSERT INTO "flights" VALUES ("1", "109", "JFK", "PEK");
INSERT INTO "flights" VALUES ("1", "110", "PEK", "JFK");
INSERT INTO "flights" VALUES ("1", "111", "JFK", "AKL");
INSERT INTO "flights" VALUES ("1", "112", "AKL", "JFK");
INSERT INTO "flights" VALUES ("1", "113", "SFO", "LHR");
INSERT INTO "flights" VALUES ("1", "114", "LHR", "SFO");
INSERT INTO "flights" VALUES ("1", "115", "SFO", "PEK");
INSERT INTO "flights" VALUES ("1", "116", "PEK", "SFO");
INSERT INTO "flights" VALUES ("1", "117", "YYZ", "LHR");
INSERT INTO "flights" VALUES ("1", "118", "LHR", "YYZ");
INSERT INTO "flights" VALUES ("1", "119", "AKL", "SYD");
INSERT INTO "flights" VALUES ("1", "120", "SYD", "AKL");
INSERT INTO "flights" VALUES ("1", "121", "MEL", "SYD");
INSERT INTO "flights" VALUES ("1", "122", "SYD", "MEL");
INSERT INTO "flights" VALUES ("1", "123", "YVR", "JFK");
INSERT INTO "flights" VALUES ("1", "124", "JFK", "YVR");
INSERT INTO "flights" VALUES ("1", "125", "YVR", "LHR");
INSERT INTO "flights" VALUES ("1", "126", "LHR", "YVR");
INSERT INTO "flights" VALUES ("1", "127", "MEL", "AKL");
INSERT INTO "flights" VALUES ("1", "128", "AKL", "MEL");
INSERT INTO "flights" VALUES ("1", "129", "PEK", "YYZ");
INSERT INTO "flights" VALUES ("1", "130", "YYZ", "PEK");
INSERT INTO "flights" VALUES ("1", "131", "SFO", "YVR");
INSERT INTO "flights" VALUES ("1", "132", "YVR", "SFO");
INSERT INTO "flights" VALUES ("1", "133", "LGW", "MEL");
INSERT INTO "flights" VALUES ("1", "134", "MEL", "LGW");
INSERT INTO "flights" VALUES ("1", "135", "JFK", "MEL");
INSERT INTO "flights" VALUES ("1", "136", "MEL", "JFK");
INSERT INTO "flights" VALUES ("1", "137", "SYD", "LHR");
INSERT INTO "flights" VALUES ("1", "138", "LHR", "SYD");
INSERT INTO "flights" VALUES ("1", "139", "AKL", "YVR");
INSERT INTO "flights" VALUES ("1", "140", "YVR", "AKL");
INSERT INTO "flights" VALUES ("1", "141", "PEK", "LGW");
INSERT INTO "flights" VALUES ("1", "142", "LGW", "PEK");
INSERT INTO "flights" VALUES ("1", "143", "YYZ", "MEL");
INSERT INTO "flights" VALUES ("1", "144", "MEL", "YYZ");
INSERT INTO "flights" VALUES ("1", "145", "SFO", "AKL");
INSERT INTO "flights" VALUES ("1", "146", "AKL", "SFO");
INSERT INTO "flights" VALUES ("1", "147", "JFK", "LGW");
INSERT INTO "flights" VALUES ("1", "148", "LGW", "JFK");
INSERT INTO "flights" VALUES ("1", "149", "SYD", "YVR");
INSERT INTO "flights" VALUES ("1", "150", "YVR", "SYD");
INSERT INTO "flights" VALUES ("1", "151", "PEK", "AKL");
INSERT INTO "flights" VALUES ("1", "152", "AKL", "PEK");
INSERT INTO "flights" VALUES ("1", "153", "LHR", "AKL");
INSERT INTO "flights" VALUES ("1", "154", "AKL", "LHR");
INSERT INTO "flights" VALUES ("1", "155", "YYZ", "AKL");
INSERT INTO "flights" VALUES ("1", "156", "AKL", "YYZ");
INSERT INTO "flights" VALUES ("1", "157", "MEL", "SFO");
INSERT INTO "flights" VALUES ("1", "158", "SFO", "MEL");
INSERT INTO "flights" VALUES ("1", "159", "JFK", "SYD");
INSERT INTO "flights" VALUES ("1", "160", "SYD", "JFK");
INSERT INTO "flights" VALUES ("1", "161", "LHR", "MEL");
INSERT INTO "flights" VALUES ("1", "162", "MEL", "LHR");
INSERT INTO "flights" VALUES ("1", "163", "YVR", "PEK");
INSERT INTO "flights" VALUES ("1", "164", "PEK", "YVR");
INSERT INTO "flights" VALUES ("1", "165", "LGW", "SYD");
INSERT INTO "flights" VALUES ("1", "166", "SYD", "LGW");
INSERT INTO "flights" VALUES ("1", "167", "AKL", "LGW");
INSERT INTO "flights" VALUES ("1", "168", "LGW", "AKL");
INSERT INTO "flights" VALUES ("1", "169", "YYZ", "LHR");
INSERT INTO "flights" VALUES ("1", "170", "LHR", "YYZ");
INSERT INTO "flights" VALUES ("1", "171", "SFO", "JFK");
INSERT INTO "flights" VALUES ("1", "172", "JFK", "SFO");
INSERT INTO "flights" VALUES ("1", "173", "MEL", "YYZ");
INSERT INTO "flights" VALUES ("1", "174", "YYZ", "MEL");
INSERT INTO "flights" VALUES ("1", "175", "SYD", "PEK");
INSERT INTO "flights" VALUES ("1", "176", "PEK", "SYD");
INSERT INTO "flights" VALUES ("1", "177", "AKL", "JFK");
INSERT INTO "flights" VALUES ("1", "178", "JFK", "AKL");
INSERT INTO "flights" VALUES ("1", "179", "LHR", "PEK");
INSERT INTO "flights" VALUES ("1", "180", "PEK", "LHR");
INSERT INTO "flights" VALUES ("1", "181", "YVR", "LGW");
INSERT INTO "flights" VALUES ("1", "182", "LGW", "YVR");
INSERT INTO "flights" VALUES ("1", "183", "MEL", "AKL");
INSERT INTO "flights" VALUES ("1", "184", "AKL", "MEL");
INSERT INTO "flights" VALUES ("1", "185", "SFO", "YYZ");
INSERT INTO "flights" VALUES ("1", "186", "YYZ", "SFO");
INSERT INTO "flights" VALUES ("1", "187", "JFK", "LHR");
INSERT INTO "flights" VALUES ("1", "188", "LHR", "JFK");
INSERT INTO "flights" VALUES ("1", "189", "SYD", "MEL");
INSERT INTO "flights" VALUES ("1", "190", "MEL", "SYD");
INSERT INTO "flights" VALUES ("1", "191", "PEK", "JFK");
INSERT INTO "flights" VALUES ("1", "192", "JFK", "PEK");
INSERT INTO "flights" VALUES ("1", "193", "LGW", "SFO");
INSERT INTO "flights" VALUES ("1", "194", "SFO", "LGW");
INSERT INTO "flights" VALUES ("1", "195", "AKL", "SYD");
INSERT INTO "flights" VALUES ("1", "196", "SYD", "AKL");
INSERT INTO "flights" VALUES ("1", "197", "YYZ", "JFK");
INSERT INTO "flights" VALUES ("1", "198", "JFK", "YYZ");
INSERT INTO "flights" VALUES ("1", "199", "LHR", "SFO");
INSERT INTO "flights" VALUES ("1", "200", "SFO", "LHR");
INSERT INTO "flights" VALUES ("2", "1", "LHR", "JFK");
INSERT INTO "flights" VALUES ("2", "2", "LHR", "LGW");
INSERT INTO "flights" VALUES ("2", "3", "LGW", "LHR");
INSERT INTO "flights" VALUES ("2", "4", "LHR", "YYZ");
INSERT INTO "flights" VALUES ("2", "5", "YYZ", "LHR");
INSERT INTO "flights" VALUES ("2", "6", "LGW", "PEK");
INSERT INTO "flights" VALUES ("2", "7", "PEK", "LGW");
INSERT INTO "flights" VALUES ("2", "8", "LHR", "SYD");
INSERT INTO "flights" VALUES ("2", "9", "SYD", "LHR");
INSERT INTO "flights" VALUES ("2", "10", "LGW", "AKL");
INSERT INTO "flights" VALUES ("2", "11", "AKL", "LGW");
INSERT INTO "flights" VALUES ("2", "12", "LHR", "MEL");
INSERT INTO "flights" VALUES ("2", "13", "MEL", "LHR");
INSERT INTO "flights" VALUES ("2", "14", "LGW", "SFO");
INSERT INTO "flights" VALUES ("2", "15", "SFO", "LGW");
INSERT INTO "flights" VALUES ("2", "16", "LHR", "PEK");
INSERT INTO "flights" VALUES ("2", "17", "PEK", "LHR");
INSERT INTO "flights" VALUES ("2", "18", "LGW", "JFK");
INSERT INTO "flights" VALUES ("2", "19", "JFK", "LGW");
INSERT INTO "flights" VALUES ("2", "20", "LHR", "AKL");
INSERT INTO "flights" VALUES ("2", "21", "AKL", "LHR");
INSERT INTO "flights" VALUES ("2", "22", "LGW", "MEL");
INSERT INTO "flights" VALUES ("2", "23", "MEL", "LGW");
INSERT INTO "flights" VALUES ("2", "24", "LHR", "SYD");
INSERT INTO "flights" VALUES ("2", "25", "SYD", "LHR");
INSERT INTO "flights" VALUES ("2", "26", "LGW", "YYZ");
INSERT INTO "flights" VALUES ("2", "27", "YYZ", "LGW");
INSERT INTO "flights" VALUES ("2", "28", "LHR", "JFK");
INSERT INTO "flights" VALUES ("2", "29", "JFK", "LHR");
INSERT INTO "flights" VALUES ("2", "30", "LGW", "PEK");
INSERT INTO "flights" VALUES ("2", "31", "PEK", "LGW");
INSERT INTO "flights" VALUES ("2", "32", "LHR", "SFO");
INSERT INTO "flights" VALUES ("2", "33", "SFO", "LHR");
INSERT INTO "flights" VALUES ("2", "34", "LGW", "AKL");
INSERT INTO "flights" VALUES ("2", "35", "AKL", "LGW");
INSERT INTO "flights" VALUES ("2", "36", "LHR", "MEL");
INSERT INTO "flights" VALUES ("2", "37", "MEL", "LHR");
INSERT INTO "flights" VALUES ("2", "38", "LGW", "SFO");
INSERT INTO "flights" VALUES ("2", "39", "SFO", "LGW");
INSERT INTO "flights" VALUES ("2", "40", "LHR", "PEK");
INSERT INTO "flights" VALUES ("2", "41", "PEK", "LHR");
INSERT INTO "flights" VALUES ("2", "42", "LGW", "JFK");
INSERT INTO "flights" VALUES ("2", "43", "JFK", "LGW");
INSERT INTO "flights" VALUES ("2", "44", "LHR", "AKL");
INSERT INTO "flights" VALUES ("2", "45", "AKL", "LHR");
INSERT INTO "flights" VALUES ("2", "46", "LGW", "MEL");
INSERT INTO "flights" VALUES ("2", "47", "MEL", "LGW");
INSERT INTO "flights" VALUES ("2", "48", "LHR", "SYD");
INSERT INTO "flights" VALUES ("2", "49", "SYD", "LHR");
INSERT INTO "flights" VALUES ("2", "50", "LGW", "YYZ");
INSERT INTO "flights" VALUES ("2", "51", "YYZ", "LGW");
INSERT INTO "flights" VALUES ("2", "52", "LHR", "JFK");
INSERT INTO "flights" VALUES ("2", "53", "JFK", "LHR");
INSERT INTO "flights" VALUES ("2", "54", "LGW", "PEK");
INSERT INTO "flights" VALUES ("2", "55", "PEK", "LGW");
INSERT INTO "flights" VALUES ("2", "56", "LHR", "SFO");
INSERT INTO "flights" VALUES ("2", "57", "SFO", "LHR");
INSERT INTO "flights" VALUES ("2", "58", "LGW", "AKL");
INSERT INTO "flights" VALUES ("2", "59", "AKL", "LGW");
INSERT INTO "flights" VALUES ("2", "60", "LHR", "MEL");
INSERT INTO "flights" VALUES ("2", "61", "MEL", "LHR");
INSERT INTO "flights" VALUES ("2", "62", "LGW", "SFO");
INSERT INTO "flights" VALUES ("2", "63", "SFO", "LGW");
INSERT INTO "flights" VALUES ("2", "64", "LHR", "PEK");
INSERT INTO "flights" VALUES ("2", "65", "PEK", "LHR");
INSERT INTO "flights" VALUES ("2", "66", "LGW", "JFK");
INSERT INTO "flights" VALUES ("2", "67", "JFK", "LGW");
INSERT INTO "flights" VALUES ("2", "68", "LHR", "AKL");
INSERT INTO "flights" VALUES ("2", "69", "AKL", "LHR");
INSERT INTO "flights" VALUES ("2", "70", "LGW", "MEL");
INSERT INTO "flights" VALUES ("2", "71", "MEL", "LGW");
INSERT INTO "flights" VALUES ("2", "72", "LHR", "SYD");
INSERT INTO "flights" VALUES ("2", "73", "SYD", "LHR");
INSERT INTO "flights" VALUES ("2", "74", "LGW", "YYZ");
INSERT INTO "flights" VALUES ("2", "75", "YYZ", "LGW");
INSERT INTO "flights" VALUES ("2", "76", "LHR", "JFK");
INSERT INTO "flights" VALUES ("2", "77", "JFK", "LHR");
INSERT INTO "flights" VALUES ("2", "78", "LGW", "PEK");
INSERT INTO "flights" VALUES ("2", "79", "PEK", "LGW");
INSERT INTO "flights" VALUES ("2", "80", "LHR", "SFO");
INSERT INTO "flights" VALUES ("2", "81", "SFO", "LHR");
INSERT INTO "flights" VALUES ("2", "82", "LGW", "AKL");
INSERT INTO "flights" VALUES ("2", "83", "AKL", "LGW");
INSERT INTO "flights" VALUES ("2", "84", "LHR", "MEL");
INSERT INTO "flights" VALUES ("2", "85", "MEL", "LHR");
INSERT INTO "flights" VALUES ("2", "86", "LGW", "SFO");
INSERT INTO "flights" VALUES ("2", "87", "SFO", "LGW");
INSERT INTO "flights" VALUES ("2", "88", "LHR", "PEK");
INSERT INTO "flights" VALUES ("2", "89", "PEK", "LHR");
INSERT INTO "flights" VALUES ("2", "90", "LGW", "JFK");
INSERT INTO "flights" VALUES ("2", "91", "JFK", "LGW");
INSERT INTO "flights" VALUES ("2", "92", "LHR", "AKL");
INSERT INTO "flights" VALUES ("2", "93", "AKL", "LHR");
INSERT INTO "flights" VALUES ("2", "94", "LGW", "MEL");
INSERT INTO "flights" VALUES ("2", "95", "MEL", "LGW");
INSERT INTO "flights" VALUES ("2", "96", "LHR", "SYD");
INSERT INTO "flights" VALUES ("2", "97", "SYD", "LHR");
INSERT INTO "flights" VALUES ("2", "98", "LGW", "YYZ");
INSERT INTO "flights" VALUES ("2", "99", "YYZ", "LGW");
INSERT INTO "flights" VALUES ("2", "100", "LHR", "JFK");
INSERT INTO "flights" VALUES ("3", "1", "SYD", "MEL");
INSERT INTO "flights" VALUES ("3", "2", "MEL", "SYD");
INSERT INTO "flights" VALUES ("3", "3", "SYD", "AKL");
INSERT INTO "flights" VALUES ("3", "4", "AKL", "SYD");
INSERT INTO "flights" VALUES ("3", "5", "SYD", "PEK");
INSERT INTO "flights" VALUES ("3", "6", "PEK", "SYD");
INSERT INTO "flights" VALUES ("3", "7", "SYD", "JFK");
INSERT INTO "flights" VALUES ("3", "8", "JFK", "SYD");
INSERT INTO "flights" VALUES ("3", "9", "SYD", "LHR");
INSERT INTO "flights" VALUES ("3", "10", "LHR", "SYD");
INSERT INTO "flights" VALUES ("3", "11", "SYD", "YVR");
INSERT INTO "flights" VALUES ("3", "12", "YVR", "SYD");
INSERT INTO "flights" VALUES ("3", "13", "SYD", "LGW");
INSERT INTO "flights" VALUES ("3", "14", "LGW", "SYD");
INSERT INTO "flights" VALUES ("3", "15", "SYD", "YYZ");
INSERT INTO "flights" VALUES ("3", "16", "YYZ", "SYD");
INSERT INTO "flights" VALUES ("3", "17", "SYD", "MEL");
INSERT INTO "flights" VALUES ("3", "18", "MEL", "SYD");
INSERT INTO "flights" VALUES ("3", "19", "SYD", "AKL");
INSERT INTO "flights" VALUES ("3", "20", "AKL", "SYD");
INSERT INTO "flights" VALUES ("3", "21", "SYD", "PEK");
INSERT INTO "flights" VALUES ("3", "22", "PEK", "SYD");
INSERT INTO "flights" VALUES ("3", "23", "SYD", "JFK");
INSERT INTO "flights" VALUES ("3", "24", "JFK", "SYD");
INSERT INTO "flights" VALUES ("3", "25", "SYD", "LHR");
INSERT INTO "flights" VALUES ("3", "26", "LHR", "SYD");
INSERT INTO "flights" VALUES ("3", "27", "SYD", "YVR");
INSERT INTO "flights" VALUES ("3", "28", "YVR", "SYD");
INSERT INTO "flights" VALUES ("3", "29", "SYD", "LGW");
INSERT INTO "flights" VALUES ("3", "30", "LGW", "SYD");
INSERT INTO "flights" VALUES ("3", "31", "SYD", "YYZ");
INSERT INTO "flights" VALUES ("3", "32", "YYZ", "SYD");
INSERT INTO "flights" VALUES ("3", "33", "SYD", "MEL");
INSERT INTO "flights" VALUES ("3", "34", "MEL", "SYD");
INSERT INTO "flights" VALUES ("3", "35", "SYD", "AKL");
INSERT INTO "flights" VALUES ("3", "36", "AKL", "SYD");
INSERT INTO "flights" VALUES ("3", "37", "SYD", "PEK");
INSERT INTO "flights" VALUES ("3", "38", "PEK", "SYD");
INSERT INTO "flights" VALUES ("3", "39", "SYD", "JFK");
INSERT INTO "flights" VALUES ("3", "40", "JFK", "SYD");
INSERT INTO "flights" VALUES ("3", "41", "SYD", "LHR");
INSERT INTO "flights" VALUES ("3", "42", "LHR", "SYD");
INSERT INTO "flights" VALUES ("3", "43", "SYD", "YVR");
INSERT INTO "flights" VALUES ("3", "44", "YVR", "SYD");
INSERT INTO "flights" VALUES ("3", "45", "SYD", "LGW");
INSERT INTO "flights" VALUES ("3", "46", "LGW", "SYD");
INSERT INTO "flights" VALUES ("3", "47", "SYD", "YYZ");
INSERT INTO "flights" VALUES ("3", "48", "YYZ", "SYD");
INSERT INTO "flights" VALUES ("3", "49", "SYD", "MEL");
INSERT INTO "flights" VALUES ("3", "50", "MEL", "SYD");
INSERT INTO "flights" VALUES ("4", "1", "YYZ", "JFK");
INSERT INTO "flights" VALUES ("4", "2", "JFK", "YYZ");
INSERT INTO "flights" VALUES ("4", "3", "YYZ", "LHR");
INSERT INTO "flights" VALUES ("4", "4", "LHR", "YYZ");
INSERT INTO "flights" VALUES ("4", "5", "YYZ", "PEK");
INSERT INTO "flights" VALUES ("4", "6", "PEK", "YYZ");
INSERT INTO "flights" VALUES ("4", "7", "YYZ", "SYD");
INSERT INTO "flights" VALUES ("4", "8", "SYD", "YYZ");
INSERT INTO "flights" VALUES ("4", "9", "YYZ", "LGW");
INSERT INTO "flights" VALUES ("4", "10", "LGW", "YYZ");
INSERT INTO "flights" VALUES ("4", "11", "YYZ", "AKL");
INSERT INTO "flights" VALUES ("4", "12", "AKL", "YYZ");
INSERT INTO "flights" VALUES ("4", "13", "YYZ", "MEL");
INSERT INTO "flights" VALUES ("4", "14", "MEL", "YYZ");
INSERT INTO "flights" VALUES ("4", "15", "YYZ", "SFO");
INSERT INTO "flights" VALUES ("4", "16", "SFO", "YYZ");
INSERT INTO "flights" VALUES ("4", "17", "YYZ", "YVR");
INSERT INTO "flights" VALUES ("4", "18", "YVR", "YYZ");
INSERT INTO "flights" VALUES ("4", "19", "YYZ", "JFK");
INSERT INTO "flights" VALUES ("4", "20", "JFK", "YYZ");
INSERT INTO "flights" VALUES ("5", "1", "PEK", "JFK");
INSERT INTO "flights" VALUES ("5", "2", "JFK", "PEK");
INSERT INTO "flights" VALUES ("5", "3", "PEK", "LHR");
INSERT INTO "flights" VALUES ("5", "4", "LHR", "PEK");
INSERT INTO "flights" VALUES ("5", "5", "PEK", "SYD");
INSERT INTO "flights" VALUES ("5", "6", "SYD", "PEK");
INSERT INTO "flights" VALUES ("5", "7", "PEK", "LGW");
INSERT INTO "flights" VALUES ("5", "8", "LGW", "PEK");
INSERT INTO "flights" VALUES ("5", "9", "PEK", "AKL");
INSERT INTO "flights" VALUES ("5", "10", "AKL", "PEK");
INSERT INTO "flights" VALUES ("5", "11", "PEK", "MEL");
INSERT INTO "flights" VALUES ("5", "12", "MEL", "PEK");
INSERT INTO "flights" VALUES ("5", "13", "PEK", "SFO");
INSERT INTO "flights" VALUES ("5", "14", "SFO", "PEK");
INSERT INTO "flights" VALUES ("5", "15", "PEK", "YVR");
INSERT INTO "flights" VALUES ("5", "16", "YVR", "PEK");
INSERT INTO "flights" VALUES ("5", "17", "PEK", "JFK");
INSERT INTO "flights" VALUES ("5", "18", "JFK", "PEK");
INSERT INTO "flights" VALUES ("5", "19", "PEK", "LHR");
INSERT INTO "flights" VALUES ("5", "20", "LHR", "PEK");
INSERT INTO "flights" VALUES ("6", "1", "AKL", "SYD");
INSERT INTO "flights" VALUES ("6", "2", "SYD", "AKL");
INSERT INTO "flights" VALUES ("6", "3", "AKL", "MEL");
INSERT INTO "flights" VALUES ("6", "4", "MEL", "AKL");
INSERT INTO "flights" VALUES ("6", "5", "AKL", "JFK");
INSERT INTO "flights" VALUES ("6", "6", "JFK", "AKL");
INSERT INTO "flights" VALUES ("6", "7", "AKL", "LHR");
INSERT INTO "flights" VALUES ("6", "8", "LHR", "AKL");
INSERT INTO "flights" VALUES ("6", "9", "AKL", "LGW");
INSERT INTO "flights" VALUES ("6", "10", "LGW", "AKL");
INSERT INTO "flights" VALUES ("6", "11", "AKL", "PEK");
INSERT INTO "flights" VALUES ("6", "12", "PEK", "AKL");
INSERT INTO "flights" VALUES ("6", "13", "AKL", "YYZ");
INSERT INTO "flights" VALUES ("6", "14", "YYZ", "AKL");
INSERT INTO "flights" VALUES ("6", "15", "AKL", "YVR");
INSERT INTO "flights" VALUES ("6", "16", "YVR", "AKL");
INSERT INTO "flights" VALUES ("6", "17", "AKL", "SFO");
INSERT INTO "flights" VALUES ("6", "18", "SFO", "AKL");
INSERT INTO "flights" VALUES ("6", "19", "AKL", "MEL");
INSERT INTO "flights" VALUES ("6", "20", "MEL", "AKL");