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,
"Edispl" FLOAT,
"Horsepower" TEXT,
"Accelerate" FLOAT,
PRIMARY KEY ("Id"),
FOREIGN KEY ("Id") REFERENCES "car_names"("MakeId")
);





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", "Porsche 911");
INSERT INTO "car_names" VALUES ("9", "Nissan GT-R");
INSERT INTO "car_names" VALUES ("10", "Subaru WRX");
INSERT INTO "car_names" VALUES ("11", "Mazda MX-5");
INSERT INTO "car_names" VALUES ("12", "Tesla Model S");
INSERT INTO "car_names" VALUES ("13", "Ferrari 488");
INSERT INTO "car_names" VALUES ("14", "Lamborghini Huracan");
INSERT INTO "car_names" VALUES ("15", "Bugatti Chiron");
INSERT INTO "cars_data" VALUES ("1", "30.5", "1.8", "139", "10.5");
INSERT INTO "cars_data" VALUES ("2", "32.0", "1.5", "158", "9.8");
INSERT INTO "cars_data" VALUES ("3", "20.0", "5.0", "395", "6.5");
INSERT INTO "cars_data" VALUES ("4", "19.5", "5.3", "355", "6.7");
INSERT INTO "cars_data" VALUES ("5", "28.0", "2.0", "255", "5.8");
INSERT INTO "cars_data" VALUES ("6", "27.5", "2.0", "255", "5.9");
INSERT INTO "cars_data" VALUES ("7", "29.0", "2.0", "201", "6.3");
INSERT INTO "cars_data" VALUES ("8", "22.0", "3.0", "379", "4.0");
INSERT INTO "cars_data" VALUES ("9", "19.0", "3.8", "565", "2.9");
INSERT INTO "cars_data" VALUES ("10", "25.0", "2.4", "271", "5.5");
INSERT INTO "cars_data" VALUES ("11", "34.0", "2.0", "181", "6.5");
INSERT INTO "cars_data" VALUES ("12", "100.0", "0.0", "670", "3.1");
INSERT INTO "cars_data" VALUES ("13", "15.0", "3.9", "661", "3.0");
INSERT INTO "cars_data" VALUES ("14", "14.0", "5.2", "602", "3.2");
INSERT INTO "cars_data" VALUES ("15", "8.0", "8.0", "1500", "2.4");