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 "car_names" (
"MakeId" INT,
"Model" TEXT,
PRIMARY KEY ("MakeId")
);

CREATE TABLE "cars_data" (
"Id" INT,
"MPG" TEXT,
"Horsepower" TEXT,
"Weight" INT,
"Year" INT,
PRIMARY KEY ("Id")
);





INSERT INTO "car_names" VALUES ("1", "Toyota Corolla");
INSERT INTO "car_names" VALUES ("2", "Honda Civic");
INSERT INTO "car_names" VALUES ("3", "Ford F-150");
INSERT INTO "car_names" VALUES ("4", "Chevrolet Silverado");
INSERT INTO "car_names" VALUES ("5", "BMW 3 Series");
INSERT INTO "car_names" VALUES ("6", "Mercedes-Benz C-Class");
INSERT INTO "car_names" VALUES ("7", "Audi A4");
INSERT INTO "car_names" VALUES ("8", "Volkswagen Golf");
INSERT INTO "car_names" VALUES ("9", "Nissan Altima");
INSERT INTO "car_names" VALUES ("10", "Hyundai Elantra");
INSERT INTO "cars_data" VALUES ("1", "30", "120", "2500", "1990");
INSERT INTO "cars_data" VALUES ("2", "28", "110", "2700", "1990");
INSERT INTO "cars_data" VALUES ("3", "18", "200", "4500", "1990");
INSERT INTO "cars_data" VALUES ("4", "25", "150", "3500", "1991");
INSERT INTO "cars_data" VALUES ("5", "22", "180", "3800", "1991");
INSERT INTO "cars_data" VALUES ("6", "15", "250", "4200", "1991");
INSERT INTO "cars_data" VALUES ("7", "32", "100", "2200", "1992");
INSERT INTO "cars_data" VALUES ("8", "20", "160", "3100", "1992");
INSERT INTO "cars_data" VALUES ("9", "17", "220", "4100", "1992");
INSERT INTO "cars_data" VALUES ("10", "29", "130", "2900", "1993");
INSERT INTO "cars_data" VALUES ("11", "24", "170", "3600", "1993");
INSERT INTO "cars_data" VALUES ("12", "16", "230", "4300", "1993");
INSERT INTO "cars_data" VALUES ("13", "35", "90", "2000", "1994");
INSERT INTO "cars_data" VALUES ("14", "26", "140", "3050", "1994");
INSERT INTO "cars_data" VALUES ("15", "19", "210", "3950", "1994");
INSERT INTO "cars_data" VALUES ("16", "21", "190", "3700", "1995");
INSERT INTO "cars_data" VALUES ("17", "14", "260", "4600", "1995");
INSERT INTO "cars_data" VALUES ("18", "31", "115", "2650", "1996");
INSERT INTO "cars_data" VALUES ("19", "23", "165", "3200", "1996");
INSERT INTO "cars_data" VALUES ("20", "13", "270", "4700", "1996");
INSERT INTO "cars_data" VALUES ("21", "27", "135", "2800", "1997");
INSERT INTO "cars_data" VALUES ("22", "20", "175", "3400", "1997");
INSERT INTO "cars_data" VALUES ("23", "12", "280", "4800", "1997");
INSERT INTO "cars_data" VALUES ("24", "33", "95", "2100", "1998");
INSERT INTO "cars_data" VALUES ("25", "25", "145", "3000", "1998");
INSERT INTO "cars_data" VALUES ("26", "18", "205", "3900", "1998");
INSERT INTO "cars_data" VALUES ("27", "29", "125", "2750", "1999");
INSERT INTO "cars_data" VALUES ("28", "22", "185", "3750", "1999");
INSERT INTO "cars_data" VALUES ("29", "15", "245", "4400", "1999");
INSERT INTO "cars_data" VALUES ("30", "30", "105", "2450", "2000");
INSERT INTO "cars_data" VALUES ("31", "24", "155", "3300", "2000");
INSERT INTO "cars_data" VALUES ("32", "17", "235", "4250", "2000");