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", "Jetblue Airways", "JBU");
INSERT INTO "airlines" VALUES ("2", "American Airlines", "AAL");
INSERT INTO "airlines" VALUES ("3", "Delta Airlines", "DAL");
INSERT INTO "airlines" VALUES ("4", "Southwest Airlines", "SWA");
INSERT INTO "airlines" VALUES ("5", "United Airlines", "UAL");
INSERT INTO "airlines" VALUES ("6", "Alaska Airlines", "ASA");
INSERT INTO "airlines" VALUES ("7", "Spirit Airlines", "NKS");
INSERT INTO "airlines" VALUES ("8", "Frontier Airlines", "FFT");
INSERT INTO "airlines" VALUES ("9", "Allegiant Air", "AAY");
INSERT INTO "airlines" VALUES ("10", "Hawaiian Airlines", "HAL");
INSERT INTO "flights" VALUES ("1", "101", "JFK", "LAX");
INSERT INTO "flights" VALUES ("1", "102", "LAX", "JFK");
INSERT INTO "flights" VALUES ("1", "201", "BOS", "MIA");
INSERT INTO "flights" VALUES ("1", "202", "MIA", "BOS");
INSERT INTO "flights" VALUES ("2", "301", "DFW", "ORD");
INSERT INTO "flights" VALUES ("3", "401", "ATL", "DEN");
INSERT INTO "flights" VALUES ("4", "501", "MDW", "LAS");
INSERT INTO "flights" VALUES ("5", "601", "SFO", "SEA");
INSERT INTO "flights" VALUES ("1", "103", "JFK", "SFO");
INSERT INTO "flights" VALUES ("1", "104", "SFO", "JFK");
INSERT INTO "flights" VALUES ("1", "203", "BOS", "ORD");
INSERT INTO "flights" VALUES ("1", "204", "ORD", "BOS");
INSERT INTO "flights" VALUES ("1", "301", "LAX", "SEA");
INSERT INTO "flights" VALUES ("1", "302", "SEA", "LAX");
INSERT INTO "flights" VALUES ("1", "401", "MIA", "DEN");
INSERT INTO "flights" VALUES ("1", "402", "DEN", "MIA");
INSERT INTO "flights" VALUES ("1", "501", "LAS", "JFK");
INSERT INTO "flights" VALUES ("1", "502", "JFK", "LAS");
INSERT INTO "flights" VALUES ("1", "601", "ORD", "LAX");
INSERT INTO "flights" VALUES ("1", "602", "LAX", "ORD");
INSERT INTO "flights" VALUES ("1", "701", "SEA", "BOS");
INSERT INTO "flights" VALUES ("1", "702", "BOS", "SEA");
INSERT INTO "flights" VALUES ("1", "801", "DEN", "SFO");
INSERT INTO "flights" VALUES ("1", "802", "SFO", "DEN");
INSERT INTO "flights" VALUES ("1", "901", "MIA", "LAS");
INSERT INTO "flights" VALUES ("1", "902", "LAS", "MIA");
INSERT INTO "flights" VALUES ("1", "1001", "JFK", "DEN");
INSERT INTO "flights" VALUES ("1", "1002", "DEN", "JFK");
INSERT INTO "flights" VALUES ("1", "1101", "BOS", "LAX");
INSERT INTO "flights" VALUES ("1", "1102", "LAX", "BOS");
INSERT INTO "flights" VALUES ("1", "1201", "ORD", "MIA");
INSERT INTO "flights" VALUES ("1", "1202", "MIA", "ORD");
INSERT INTO "flights" VALUES ("1", "1301", "SEA", "LAS");
INSERT INTO "flights" VALUES ("1", "1302", "LAS", "SEA");
INSERT INTO "flights" VALUES ("1", "1401", "DEN", "BOS");
INSERT INTO "flights" VALUES ("1", "1402", "BOS", "DEN");
INSERT INTO "flights" VALUES ("1", "1501", "SFO", "MIA");
INSERT INTO "flights" VALUES ("1", "1502", "MIA", "SFO");
INSERT INTO "flights" VALUES ("1", "1601", "LAS", "ORD");
INSERT INTO "flights" VALUES ("1", "1602", "ORD", "LAS");
INSERT INTO "flights" VALUES ("1", "1701", "JFK", "SEA");
INSERT INTO "flights" VALUES ("1", "1702", "SEA", "JFK");
INSERT INTO "flights" VALUES ("1", "1801", "LAX", "DEN");
INSERT INTO "flights" VALUES ("1", "1802", "DEN", "LAX");
INSERT INTO "flights" VALUES ("1", "1901", "MIA", "BOS");
INSERT INTO "flights" VALUES ("1", "1902", "BOS", "MIA");
INSERT INTO "flights" VALUES ("1", "2001", "ORD", "SFO");
INSERT INTO "flights" VALUES ("1", "2002", "SFO", "ORD");
INSERT INTO "flights" VALUES ("1", "2101", "SEA", "MIA");
INSERT INTO "flights" VALUES ("1", "2102", "MIA", "SEA");
INSERT INTO "flights" VALUES ("1", "2201", "DEN", "LAS");
INSERT INTO "flights" VALUES ("1", "2202", "LAS", "DEN");
INSERT INTO "flights" VALUES ("1", "2301", "BOS", "JFK");
INSERT INTO "flights" VALUES ("1", "2302", "JFK", "BOS");
INSERT INTO "flights" VALUES ("1", "2401", "LAX", "ORD");
INSERT INTO "flights" VALUES ("1", "2402", "ORD", "LAX");
INSERT INTO "flights" VALUES ("1", "2501", "MIA", "SEA");
INSERT INTO "flights" VALUES ("1", "2502", "SEA", "MIA");
INSERT INTO "flights" VALUES ("1", "2601", "SFO", "DEN");
INSERT INTO "flights" VALUES ("1", "2602", "DEN", "SFO");
INSERT INTO "flights" VALUES ("1", "2701", "LAS", "BOS");
INSERT INTO "flights" VALUES ("1", "2702", "BOS", "LAS");
INSERT INTO "flights" VALUES ("1", "2801", "ORD", "JFK");
INSERT INTO "flights" VALUES ("1", "2802", "JFK", "ORD");
INSERT INTO "flights" VALUES ("1", "2901", "SEA", "LAX");
INSERT INTO "flights" VALUES ("1", "2902", "LAX", "SEA");
INSERT INTO "flights" VALUES ("1", "3001", "DEN", "MIA");
INSERT INTO "flights" VALUES ("1", "3002", "MIA", "DEN");
INSERT INTO "flights" VALUES ("1", "3101", "BOS", "SFO");
INSERT INTO "flights" VALUES ("1", "3102", "SFO", "BOS");
INSERT INTO "flights" VALUES ("1", "3201", "JFK", "LAS");
INSERT INTO "flights" VALUES ("1", "3202", "LAS", "JFK");
INSERT INTO "flights" VALUES ("1", "3301", "LAX", "MIA");
INSERT INTO "flights" VALUES ("1", "3302", "MIA", "LAX");
INSERT INTO "flights" VALUES ("1", "3401", "ORD", "SEA");
INSERT INTO "flights" VALUES ("1", "3402", "SEA", "ORD");
INSERT INTO "flights" VALUES ("1", "3501", "DEN", "BOS");
INSERT INTO "flights" VALUES ("1", "3502", "BOS", "DEN");
INSERT INTO "flights" VALUES ("1", "3601", "SFO", "JFK");
INSERT INTO "flights" VALUES ("1", "3602", "JFK", "SFO");
INSERT INTO "flights" VALUES ("1", "3701", "LAS", "LAX");
INSERT INTO "flights" VALUES ("1", "3702", "LAX", "LAS");
INSERT INTO "flights" VALUES ("1", "3801", "MIA", "ORD");
INSERT INTO "flights" VALUES ("1", "3802", "ORD", "MIA");
INSERT INTO "flights" VALUES ("1", "3901", "SEA", "DEN");
INSERT INTO "flights" VALUES ("1", "3902", "DEN", "SEA");
INSERT INTO "flights" VALUES ("1", "4001", "BOS", "LAS");
INSERT INTO "flights" VALUES ("1", "4002", "LAS", "BOS");
INSERT INTO "flights" VALUES ("1", "4101", "JFK", "MIA");
INSERT INTO "flights" VALUES ("1", "4102", "MIA", "JFK");
INSERT INTO "flights" VALUES ("1", "4201", "LAX", "SFO");
INSERT INTO "flights" VALUES ("1", "4202", "SFO", "LAX");
INSERT INTO "flights" VALUES ("1", "4301", "ORD", "DEN");
INSERT INTO "flights" VALUES ("1", "4302", "DEN", "ORD");
INSERT INTO "flights" VALUES ("1", "4401", "SEA", "BOS");
INSERT INTO "flights" VALUES ("1", "4402", "BOS", "SEA");
INSERT INTO "flights" VALUES ("1", "4501", "LAS", "JFK");
INSERT INTO "flights" VALUES ("1", "4502", "JFK", "LAS");
INSERT INTO "flights" VALUES ("1", "4601", "MIA", "LAX");
INSERT INTO "flights" VALUES ("1", "4602", "LAX", "MIA");
INSERT INTO "flights" VALUES ("1", "4701", "DEN", "ORD");
INSERT INTO "flights" VALUES ("1", "4702", "ORD", "DEN");
INSERT INTO "flights" VALUES ("1", "4801", "SFO", "SEA");
INSERT INTO "flights" VALUES ("1", "4802", "SEA", "SFO");
INSERT INTO "flights" VALUES ("1", "4901", "BOS", "MIA");
INSERT INTO "flights" VALUES ("1", "4902", "MIA", "BOS");
INSERT INTO "flights" VALUES ("1", "5001", "JFK", "ORD");
INSERT INTO "flights" VALUES ("1", "5002", "ORD", "JFK");