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,
"Country" TEXT,
PRIMARY KEY ("uid")
);

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





INSERT INTO "airlines" VALUES ("1", "SkyHigh Airways", "USA");
INSERT INTO "airlines" VALUES ("2", "Global Wings", "UK");
INSERT INTO "airlines" VALUES ("3", "Sunset Flights", "Australia");
INSERT INTO "airlines" VALUES ("4", "Northern Lights Air", "Canada");
INSERT INTO "airlines" VALUES ("5", "Eastern Express", "China");
INSERT INTO "airlines" VALUES ("6", "Pacific Breeze", "New Zealand");
INSERT INTO "airlines" VALUES ("7", "Continental Air", "Germany");
INSERT INTO "airlines" VALUES ("8", "Desert Falcon", "UAE");
INSERT INTO "airlines" VALUES ("9", "Polar Star Airlines", "Russia");
INSERT INTO "airlines" VALUES ("10", "Island Hopper", "Philippines");
INSERT INTO "flights" VALUES ("1", "101", "JFK", "LAX");
INSERT INTO "flights" VALUES ("1", "102", "JFK", "ORD");
INSERT INTO "flights" VALUES ("1", "103", "LAX", "MIA");
INSERT INTO "flights" VALUES ("1", "104", "ORD", "DFW");
INSERT INTO "flights" VALUES ("1", "105", "DFW", "SEA");
INSERT INTO "flights" VALUES ("1", "106", "SEA", "ATL");
INSERT INTO "flights" VALUES ("1", "107", "ATL", "BOS");
INSERT INTO "flights" VALUES ("1", "108", "BOS", "MCO");
INSERT INTO "flights" VALUES ("1", "109", "MCO", "PHX");
INSERT INTO "flights" VALUES ("1", "110", "PHX", "JFK");
INSERT INTO "flights" VALUES ("2", "201", "LHR", "CDG");
INSERT INTO "flights" VALUES ("2", "202", "LHR", "FRA");
INSERT INTO "flights" VALUES ("2", "203", "CDG", "AMS");
INSERT INTO "flights" VALUES ("2", "204", "FRA", "MAD");
INSERT INTO "flights" VALUES ("2", "205", "MAD", "BCN");
INSERT INTO "flights" VALUES ("2", "206", "BCN", "LIS");
INSERT INTO "flights" VALUES ("2", "207", "LIS", "DUB");
INSERT INTO "flights" VALUES ("2", "208", "DUB", "MAN");
INSERT INTO "flights" VALUES ("2", "209", "MAN", "EDI");
INSERT INTO "flights" VALUES ("2", "210", "EDI", "LHR");
INSERT INTO "flights" VALUES ("3", "301", "SYD", "MEL");
INSERT INTO "flights" VALUES ("3", "302", "MEL", "BNE");
INSERT INTO "flights" VALUES ("3", "303", "BNE", "PER");
INSERT INTO "flights" VALUES ("3", "304", "PER", "ADL");
INSERT INTO "flights" VALUES ("3", "305", "ADL", "CNS");
INSERT INTO "flights" VALUES ("3", "306", "CNS", "HBA");
INSERT INTO "flights" VALUES ("3", "307", "HBA", "DRW");
INSERT INTO "flights" VALUES ("3", "308", "DRW", "SYD");
INSERT INTO "flights" VALUES ("3", "309", "SYD", "OOL");
INSERT INTO "flights" VALUES ("3", "310", "OOL", "MEL");
INSERT INTO "flights" VALUES ("4", "401", "YYZ", "YVR");
INSERT INTO "flights" VALUES ("4", "402", "YVR", "YYC");
INSERT INTO "flights" VALUES ("4", "403", "YYC", "YUL");
INSERT INTO "flights" VALUES ("4", "404", "YUL", "YEG");
INSERT INTO "flights" VALUES ("4", "405", "YEG", "YWG");
INSERT INTO "flights" VALUES ("4", "406", "YWG", "YHZ");
INSERT INTO "flights" VALUES ("4", "407", "YHZ", "YYZ");
INSERT INTO "flights" VALUES ("4", "408", "YYZ", "YOW");
INSERT INTO "flights" VALUES ("4", "409", "YOW", "YQB");
INSERT INTO "flights" VALUES ("4", "410", "YQB", "YYZ");
INSERT INTO "flights" VALUES ("5", "501", "PEK", "PVG");
INSERT INTO "flights" VALUES ("5", "502", "PVG", "CAN");
INSERT INTO "flights" VALUES ("5", "503", "CAN", "SZX");
INSERT INTO "flights" VALUES ("5", "504", "SZX", "CTU");
INSERT INTO "flights" VALUES ("5", "505", "CTU", "XIY");
INSERT INTO "flights" VALUES ("5", "506", "XIY", "HGH");
INSERT INTO "flights" VALUES ("5", "507", "HGH", "NKG");
INSERT INTO "flights" VALUES ("5", "508", "NKG", "CSX");
INSERT INTO "flights" VALUES ("5", "509", "CSX", "CKG");
INSERT INTO "flights" VALUES ("5", "510", "CKG", "PEK");
INSERT INTO "flights" VALUES ("6", "601", "AKL", "WLG");
INSERT INTO "flights" VALUES ("6", "602", "WLG", "CHC");
INSERT INTO "flights" VALUES ("6", "603", "CHC", "DUD");
INSERT INTO "flights" VALUES ("6", "604", "DUD", "ZQN");
INSERT INTO "flights" VALUES ("6", "605", "ZQN", "AKL");
INSERT INTO "flights" VALUES ("6", "606", "AKL", "HLZ");
INSERT INTO "flights" VALUES ("6", "607", "HLZ", "WLG");
INSERT INTO "flights" VALUES ("6", "608", "WLG", "CHC");
INSERT INTO "flights" VALUES ("6", "609", "CHC", "DUD");
INSERT INTO "flights" VALUES ("6", "610", "DUD", "ZQN");
INSERT INTO "flights" VALUES ("7", "701", "FRA", "MUC");
INSERT INTO "flights" VALUES ("7", "702", "MUC", "TXL");
INSERT INTO "flights" VALUES ("7", "703", "TXL", "HAM");
INSERT INTO "flights" VALUES ("7", "704", "HAM", "STR");
INSERT INTO "flights" VALUES ("7", "705", "STR", "CGN");
INSERT INTO "flights" VALUES ("7", "706", "CGN", "DUS");
INSERT INTO "flights" VALUES ("7", "707", "DUS", "FRA");
INSERT INTO "flights" VALUES ("7", "708", "FRA", "HAJ");
INSERT INTO "flights" VALUES ("7", "709", "HAJ", "BRE");
INSERT INTO "flights" VALUES ("7", "710", "BRE", "FRA");
INSERT INTO "flights" VALUES ("8", "801", "DXB", "AUH");
INSERT INTO "flights" VALUES ("8", "802", "AUH", "DOH");
INSERT INTO "flights" VALUES ("8", "803", "DOH", "BAH");
INSERT INTO "flights" VALUES ("8", "804", "BAH", "DXB");
INSERT INTO "flights" VALUES ("8", "805", "DXB", "MCT");
INSERT INTO "flights" VALUES ("8", "806", "MCT", "RUH");
INSERT INTO "flights" VALUES ("8", "807", "RUH", "JED");
INSERT INTO "flights" VALUES ("8", "808", "JED", "DMM");
INSERT INTO "flights" VALUES ("8", "809", "DMM", "DXB");
INSERT INTO "flights" VALUES ("8", "810", "DXB", "AUH");
INSERT INTO "flights" VALUES ("9", "901", "SVO", "LED");
INSERT INTO "flights" VALUES ("9", "902", "LED", "VVO");
INSERT INTO "flights" VALUES ("9", "903", "VVO", "KHV");
INSERT INTO "flights" VALUES ("9", "904", "KHV", "OVB");
INSERT INTO "flights" VALUES ("9", "905", "OVB", "KJA");
INSERT INTO "flights" VALUES ("9", "906", "KJA", "YKS");
INSERT INTO "flights" VALUES ("9", "907", "YKS", "IKT");
INSERT INTO "flights" VALUES ("9", "908", "IKT", "UFA");
INSERT INTO "flights" VALUES ("9", "909", "UFA", "SVO");
INSERT INTO "flights" VALUES ("9", "910", "SVO", "LED");
INSERT INTO "flights" VALUES ("10", "1001", "MNL", "CEB");
INSERT INTO "flights" VALUES ("10", "1002", "CEB", "DVO");
INSERT INTO "flights" VALUES ("10", "1003", "DVO", "ZAM");
INSERT INTO "flights" VALUES ("10", "1004", "ZAM", "CGY");
INSERT INTO "flights" VALUES ("10", "1005", "CGY", "ILO");
INSERT INTO "flights" VALUES ("10", "1006", "ILO", "SFS");
INSERT INTO "flights" VALUES ("10", "1007", "SFS", "TAC");
INSERT INTO "flights" VALUES ("10", "1008", "TAC", "BAG");
INSERT INTO "flights" VALUES ("10", "1009", "BAG", "MNL");
INSERT INTO "flights" VALUES ("10", "1010", "MNL", "CEB");