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

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





INSERT INTO "airlines" VALUES ("1", "Southwest Airlines", "SWA");
INSERT INTO "airlines" VALUES ("2", "Delta Air Lines", "DAL");
INSERT INTO "airlines" VALUES ("3", "United Airlines", "UAL");
INSERT INTO "airlines" VALUES ("4", "American Airlines", "AAL");
INSERT INTO "airlines" VALUES ("5", "Alaska Airlines", "ASA");
INSERT INTO "airlines" VALUES ("6", "JetBlue Airways", "JBU");
INSERT INTO "airlines" VALUES ("7", "Spirit Airlines", "SIA");
INSERT INTO "airlines" VALUES ("8", "Frontier Airlines", "FTA");
INSERT INTO "airlines" VALUES ("9", "Allegiant Air", "AAY");
INSERT INTO "airlines" VALUES ("10", "Hawaiian Airlines", "HAL");
INSERT INTO "flights" VALUES ("1", "101", "LAX", "SFO");
INSERT INTO "flights" VALUES ("1", "102", "SFO", "LAX");
INSERT INTO "flights" VALUES ("1", "103", "LAX", "DEN");
INSERT INTO "flights" VALUES ("1", "104", "DEN", "LAX");
INSERT INTO "flights" VALUES ("1", "105", "SFO", "SEA");
INSERT INTO "flights" VALUES ("1", "106", "SEA", "SFO");
INSERT INTO "flights" VALUES ("1", "107", "DEN", "ORD");
INSERT INTO "flights" VALUES ("1", "108", "ORD", "DEN");
INSERT INTO "flights" VALUES ("1", "109", "LAX", "JFK");
INSERT INTO "flights" VALUES ("1", "110", "JFK", "LAX");
INSERT INTO "flights" VALUES ("1", "111", "SFO", "BOS");
INSERT INTO "flights" VALUES ("1", "112", "BOS", "SFO");
INSERT INTO "flights" VALUES ("1", "113", "DEN", "MIA");
INSERT INTO "flights" VALUES ("1", "114", "MIA", "DEN");
INSERT INTO "flights" VALUES ("1", "115", "LAX", "DFW");
INSERT INTO "flights" VALUES ("1", "116", "DFW", "LAX");
INSERT INTO "flights" VALUES ("1", "117", "SFO", "ATL");
INSERT INTO "flights" VALUES ("1", "118", "ATL", "SFO");
INSERT INTO "flights" VALUES ("1", "119", "DEN", "PHX");
INSERT INTO "flights" VALUES ("1", "120", "PHX", "DEN");
INSERT INTO "flights" VALUES ("1", "121", "LAX", "LAS");
INSERT INTO "flights" VALUES ("1", "122", "LAS", "LAX");
INSERT INTO "flights" VALUES ("1", "123", "SFO", "PDX");
INSERT INTO "flights" VALUES ("1", "124", "PDX", "SFO");
INSERT INTO "flights" VALUES ("1", "125", "DEN", "SLC");
INSERT INTO "flights" VALUES ("1", "126", "SLC", "DEN");
INSERT INTO "flights" VALUES ("1", "127", "LAX", "SAN");
INSERT INTO "flights" VALUES ("1", "128", "SAN", "LAX");
INSERT INTO "flights" VALUES ("1", "129", "SFO", "SAN");
INSERT INTO "flights" VALUES ("1", "130", "SAN", "SFO");
INSERT INTO "flights" VALUES ("1", "131", "DEN", "AUS");
INSERT INTO "flights" VALUES ("1", "132", "AUS", "DEN");
INSERT INTO "flights" VALUES ("1", "133", "LAX", "SEA");
INSERT INTO "flights" VALUES ("1", "134", "SEA", "LAX");
INSERT INTO "flights" VALUES ("1", "135", "SFO", "LAX");
INSERT INTO "flights" VALUES ("1", "136", "LAX", "SFO");
INSERT INTO "flights" VALUES ("1", "137", "LAX", "DEN");
INSERT INTO "flights" VALUES ("1", "138", "DEN", "LAX");
INSERT INTO "flights" VALUES ("1", "139", "SFO", "SEA");
INSERT INTO "flights" VALUES ("1", "140", "SEA", "SFO");
INSERT INTO "flights" VALUES ("1", "141", "DEN", "ORD");
INSERT INTO "flights" VALUES ("1", "142", "ORD", "DEN");
INSERT INTO "flights" VALUES ("1", "143", "LAX", "JFK");
INSERT INTO "flights" VALUES ("1", "144", "JFK", "LAX");
INSERT INTO "flights" VALUES ("1", "145", "SFO", "BOS");
INSERT INTO "flights" VALUES ("1", "146", "BOS", "SFO");
INSERT INTO "flights" VALUES ("1", "147", "DEN", "MIA");
INSERT INTO "flights" VALUES ("1", "148", "MIA", "DEN");
INSERT INTO "flights" VALUES ("1", "149", "LAX", "DFW");
INSERT INTO "flights" VALUES ("1", "150", "DFW", "LAX");
INSERT INTO "flights" VALUES ("1", "151", "SFO", "ATL");
INSERT INTO "flights" VALUES ("1", "152", "ATL", "SFO");
INSERT INTO "flights" VALUES ("1", "153", "DEN", "PHX");
INSERT INTO "flights" VALUES ("1", "154", "PHX", "DEN");
INSERT INTO "flights" VALUES ("1", "155", "LAX", "LAS");
INSERT INTO "flights" VALUES ("1", "156", "LAS", "LAX");
INSERT INTO "flights" VALUES ("1", "157", "SFO", "PDX");
INSERT INTO "flights" VALUES ("1", "158", "PDX", "SFO");
INSERT INTO "flights" VALUES ("1", "159", "DEN", "SLC");
INSERT INTO "flights" VALUES ("1", "160", "SLC", "DEN");
INSERT INTO "flights" VALUES ("1", "161", "LAX", "SAN");
INSERT INTO "flights" VALUES ("1", "162", "SAN", "LAX");
INSERT INTO "flights" VALUES ("1", "163", "SFO", "SAN");
INSERT INTO "flights" VALUES ("1", "164", "SAN", "SFO");
INSERT INTO "flights" VALUES ("1", "165", "DEN", "AUS");
INSERT INTO "flights" VALUES ("1", "166", "AUS", "DEN");
INSERT INTO "flights" VALUES ("1", "167", "LAX", "SEA");
INSERT INTO "flights" VALUES ("1", "168", "SEA", "LAX");
INSERT INTO "flights" VALUES ("1", "169", "LAX", "SFO");
INSERT INTO "flights" VALUES ("1", "170", "SFO", "LAX");
INSERT INTO "flights" VALUES ("1", "171", "LAX", "DEN");
INSERT INTO "flights" VALUES ("1", "172", "DEN", "LAX");
INSERT INTO "flights" VALUES ("1", "173", "SFO", "SEA");
INSERT INTO "flights" VALUES ("1", "174", "SEA", "SFO");
INSERT INTO "flights" VALUES ("1", "175", "DEN", "ORD");
INSERT INTO "flights" VALUES ("1", "176", "ORD", "DEN");
INSERT INTO "flights" VALUES ("1", "177", "LAX", "JFK");
INSERT INTO "flights" VALUES ("1", "178", "JFK", "LAX");
INSERT INTO "flights" VALUES ("1", "179", "SFO", "BOS");
INSERT INTO "flights" VALUES ("1", "180", "BOS", "SFO");
INSERT INTO "flights" VALUES ("1", "181", "DEN", "MIA");
INSERT INTO "flights" VALUES ("1", "182", "MIA", "DEN");
INSERT INTO "flights" VALUES ("1", "183", "LAX", "DFW");
INSERT INTO "flights" VALUES ("1", "184", "DFW", "LAX");
INSERT INTO "flights" VALUES ("1", "185", "SFO", "ATL");
INSERT INTO "flights" VALUES ("1", "186", "ATL", "SFO");
INSERT INTO "flights" VALUES ("1", "187", "DEN", "PHX");
INSERT INTO "flights" VALUES ("1", "188", "PHX", "DEN");
INSERT INTO "flights" VALUES ("1", "189", "LAX", "LAS");
INSERT INTO "flights" VALUES ("1", "190", "LAS", "LAX");
INSERT INTO "flights" VALUES ("1", "191", "SFO", "PDX");
INSERT INTO "flights" VALUES ("1", "192", "PDX", "SFO");
INSERT INTO "flights" VALUES ("1", "193", "DEN", "SLC");
INSERT INTO "flights" VALUES ("1", "194", "SLC", "DEN");
INSERT INTO "flights" VALUES ("1", "195", "LAX", "SAN");
INSERT INTO "flights" VALUES ("1", "196", "SAN", "LAX");
INSERT INTO "flights" VALUES ("1", "197", "SFO", "SAN");
INSERT INTO "flights" VALUES ("1", "198", "SAN", "SFO");
INSERT INTO "flights" VALUES ("1", "199", "DEN", "AUS");
INSERT INTO "flights" VALUES ("1", "200", "AUS", "DEN");
INSERT INTO "flights" VALUES ("2", "201", "ATL", "JFK");
INSERT INTO "flights" VALUES ("2", "202", "JFK", "ATL");
INSERT INTO "flights" VALUES ("2", "203", "ATL", "LAX");
INSERT INTO "flights" VALUES ("2", "204", "LAX", "ATL");
INSERT INTO "flights" VALUES ("2", "205", "ATL", "ORD");
INSERT INTO "flights" VALUES ("2", "206", "ORD", "ATL");
INSERT INTO "flights" VALUES ("2", "207", "ATL", "DFW");
INSERT INTO "flights" VALUES ("2", "208", "DFW", "ATL");
INSERT INTO "flights" VALUES ("2", "209", "ATL", "SEA");
INSERT INTO "flights" VALUES ("2", "210", "SEA", "ATL");
INSERT INTO "flights" VALUES ("2", "211", "ATL", "MIA");
INSERT INTO "flights" VALUES ("2", "212", "MIA", "ATL");
INSERT INTO "flights" VALUES ("2", "213", "ATL", "DEN");
INSERT INTO "flights" VALUES ("2", "214", "DEN", "ATL");
INSERT INTO "flights" VALUES ("2", "215", "ATL", "SFO");
INSERT INTO "flights" VALUES ("2", "216", "SFO", "ATL");
INSERT INTO "flights" VALUES ("2", "217", "ATL", "BOS");
INSERT INTO "flights" VALUES ("2", "218", "BOS", "ATL");
INSERT INTO "flights" VALUES ("2", "219", "ATL", "PHX");
INSERT INTO "flights" VALUES ("2", "220", "PHX", "ATL");
INSERT INTO "flights" VALUES ("3", "301", "ORD", "LAX");
INSERT INTO "flights" VALUES ("3", "302", "LAX", "ORD");
INSERT INTO "flights" VALUES ("3", "303", "ORD", "SFO");
INSERT INTO "flights" VALUES ("3", "304", "SFO", "ORD");
INSERT INTO "flights" VALUES ("3", "305", "ORD", "DEN");
INSERT INTO "flights" VALUES ("3", "306", "DEN", "ORD");
INSERT INTO "flights" VALUES ("3", "307", "ORD", "JFK");
INSERT INTO "flights" VALUES ("3", "308", "JFK", "ORD");
INSERT INTO "flights" VALUES ("3", "309", "ORD", "EWR");
INSERT INTO "flights" VALUES ("3", "310", "EWR", "ORD");
INSERT INTO "flights" VALUES ("4", "401", "DFW", "LAX");
INSERT INTO "flights" VALUES ("4", "402", "LAX", "DFW");
INSERT INTO "flights" VALUES ("4", "403", "DFW", "ORD");
INSERT INTO "flights" VALUES ("4", "404", "ORD", "DFW");
INSERT INTO "flights" VALUES ("4", "405", "DFW", "JFK");
INSERT INTO "flights" VALUES ("4", "406", "JFK", "DFW");
INSERT INTO "flights" VALUES ("4", "407", "DFW", "MIA");
INSERT INTO "flights" VALUES ("4", "408", "MIA", "DFW");
INSERT INTO "flights" VALUES ("5", "501", "SEA", "LAX");
INSERT INTO "flights" VALUES ("5", "502", "LAX", "SEA");
INSERT INTO "flights" VALUES ("5", "503", "SEA", "SFO");
INSERT INTO "flights" VALUES ("5", "504", "SFO", "SEA");
INSERT INTO "flights" VALUES ("6", "601", "JFK", "LAX");
INSERT INTO "flights" VALUES ("6", "602", "LAX", "JFK");
INSERT INTO "flights" VALUES ("7", "701", "MIA", "LAX");
INSERT INTO "flights" VALUES ("7", "702", "LAX", "MIA");
INSERT INTO "flights" VALUES ("8", "801", "DEN", "LAS");
INSERT INTO "flights" VALUES ("8", "802", "LAS", "DEN");
INSERT INTO "flights" VALUES ("9", "901", "LAS", "LAX");
INSERT INTO "flights" VALUES ("9", "902", "LAX", "LAS");
INSERT INTO "flights" VALUES ("10", "1001", "HNL", "LAX");
INSERT INTO "flights" VALUES ("10", "1002", "LAX", "HNL");