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 Camry");
INSERT INTO "car_names" VALUES ("2", "Honda Civic");
INSERT INTO "car_names" VALUES ("3", "Ford F-150");
INSERT INTO "car_names" VALUES ("4", "BMW 3 Series");
INSERT INTO "car_names" VALUES ("5", "Mercedes-Benz C-Class");
INSERT INTO "car_names" VALUES ("6", "Chevrolet Silverado");
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 Grand Cherokee");
INSERT INTO "car_names" VALUES ("11", "Audi A4");
INSERT INTO "car_names" VALUES ("12", "Hyundai Elantra");
INSERT INTO "car_names" VALUES ("13", "Kia Sorento");
INSERT INTO "car_names" VALUES ("14", "Mazda CX-5");
INSERT INTO "car_names" VALUES ("15", "Tesla Model 3");
INSERT INTO "cars_data" VALUES ("1", "28", "180", "3200", "2010");
INSERT INTO "cars_data" VALUES ("2", "35", "140", "2800", "2012");
INSERT INTO "cars_data" VALUES ("3", "18", "300", "5000", "2015");
INSERT INTO "cars_data" VALUES ("4", "25", "220", "3500", "2011");
INSERT INTO "cars_data" VALUES ("5", "23", "250", "3800", "2013");
INSERT INTO "cars_data" VALUES ("6", "17", "320", "5200", "2016");
INSERT INTO "cars_data" VALUES ("7", "30", "170", "3100", "2014");
INSERT INTO "cars_data" VALUES ("8", "32", "160", "2900", "2010");
INSERT INTO "cars_data" VALUES ("9", "26", "190", "3600", "2012");
INSERT INTO "cars_data" VALUES ("10", "20", "280", "4500", "2015");
INSERT INTO "cars_data" VALUES ("11", "24", "210", "3400", "2011");
INSERT INTO "cars_data" VALUES ("12", "33", "150", "2700", "2013");
INSERT INTO "cars_data" VALUES ("13", "22", "200", "4000", "2014");
INSERT INTO "cars_data" VALUES ("14", "29", "175", "3300", "2010");
INSERT INTO "cars_data" VALUES ("15", "120", "283", "3860", "2018");
INSERT INTO "cars_data" VALUES ("16", "27", "195", "3000", "2016");
INSERT INTO "cars_data" VALUES ("17", "21", "260", "4100", "2017");
INSERT INTO "cars_data" VALUES ("18", "31", "165", "2950", "2018");
INSERT INTO "cars_data" VALUES ("19", "28", "185", "3250", "2019");
INSERT INTO "cars_data" VALUES ("20", "25", "230", "3900", "2019");
INSERT INTO "cars_data" VALUES ("21", "26", "200", "3000", "2010");
INSERT INTO "cars_data" VALUES ("22", "27", "210", "4000", "2011");
INSERT INTO "cars_data" VALUES ("23", "28", "220", "3500", "2012");
INSERT INTO "cars_data" VALUES ("24", "29", "230", "3600", "2013");
INSERT INTO "cars_data" VALUES ("25", "30", "240", "3700", "2014");
INSERT INTO "cars_data" VALUES ("26", "31", "250", "3800", "2015");
INSERT INTO "cars_data" VALUES ("27", "32", "260", "3900", "2016");
INSERT INTO "cars_data" VALUES ("28", "33", "270", "4000", "2017");
INSERT INTO "cars_data" VALUES ("29", "34", "280", "3000", "2018");
INSERT INTO "cars_data" VALUES ("30", "35", "290", "3100", "2019");