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", "Nissan Altima");
INSERT INTO "car_names" VALUES ("8", "Volkswagen Jetta");
INSERT INTO "car_names" VALUES ("9", "Subaru Outback");
INSERT INTO "car_names" VALUES ("10", "Jeep Wrangler");
INSERT INTO "cars_data" VALUES ("1", "25", "120", "2800", "1990");
INSERT INTO "cars_data" VALUES ("2", "30", "100", "2500", "1990");
INSERT INTO "cars_data" VALUES ("3", "18", "200", "4500", "1990");
INSERT INTO "cars_data" VALUES ("4", "22", "150", "3500", "1991");
INSERT INTO "cars_data" VALUES ("5", "28", "130", "3000", "1991");
INSERT INTO "cars_data" VALUES ("6", "20", "180", "4000", "1991");
INSERT INTO "cars_data" VALUES ("7", "26", "110", "2700", "1992");
INSERT INTO "cars_data" VALUES ("8", "32", "90", "2400", "1992");
INSERT INTO "cars_data" VALUES ("9", "15", "220", "5000", "1992");
INSERT INTO "cars_data" VALUES ("10", "24", "140", "3200", "1993");
INSERT INTO "cars_data" VALUES ("11", "29", "125", "2900", "1993");
INSERT INTO "cars_data" VALUES ("12", "21", "170", "3800", "1993");
INSERT INTO "cars_data" VALUES ("13", "27", "115", "2600", "1994");
INSERT INTO "cars_data" VALUES ("14", "31", "95", "2300", "1994");
INSERT INTO "cars_data" VALUES ("15", "19", "210", "4800", "1994");
INSERT INTO "cars_data" VALUES ("16", "23", "160", "3400", "1995");
INSERT INTO "cars_data" VALUES ("17", "28", "135", "3100", "1995");
INSERT INTO "cars_data" VALUES ("18", "20", "190", "4200", "1995");
INSERT INTO "cars_data" VALUES ("19", "25", "120", "2800", "1996");
INSERT INTO "cars_data" VALUES ("20", "30", "100", "2500", "1996");
INSERT INTO "cars_data" VALUES ("21", "18", "200", "4500", "1996");
INSERT INTO "cars_data" VALUES ("22", "22", "150", "3500", "1997");
INSERT INTO "cars_data" VALUES ("23", "28", "130", "3000", "1997");
INSERT INTO "cars_data" VALUES ("24", "20", "180", "4000", "1997");
INSERT INTO "cars_data" VALUES ("25", "26", "110", "2700", "1998");
INSERT INTO "cars_data" VALUES ("26", "32", "90", "2400", "1998");
INSERT INTO "cars_data" VALUES ("27", "15", "220", "5000", "1998");
INSERT INTO "cars_data" VALUES ("28", "24", "140", "3200", "1999");
INSERT INTO "cars_data" VALUES ("29", "29", "125", "2900", "1999");
INSERT INTO "cars_data" VALUES ("30", "21", "170", "3800", "1999");