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,
"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", "Porsche 911");
INSERT INTO "car_names" VALUES ("8", "Nissan GT-R");
INSERT INTO "car_names" VALUES ("9", "Subaru WRX");
INSERT INTO "car_names" VALUES ("10", "Mazda MX-5");
INSERT INTO "car_names" VALUES ("11", "Ferrari 488");
INSERT INTO "car_names" VALUES ("12", "Lamborghini Huracan");
INSERT INTO "car_names" VALUES ("13", "Bugatti Chiron");
INSERT INTO "car_names" VALUES ("14", "Tesla Model S");
INSERT INTO "car_names" VALUES ("15", "Audi R8");
INSERT INTO "cars_data" VALUES ("1", "30.5", "90", "2500", "12.5");
INSERT INTO "cars_data" VALUES ("2", "32.0", "110", "2600", "11.8");
INSERT INTO "cars_data" VALUES ("3", "18.0", "250", "5000", "8.0");
INSERT INTO "cars_data" VALUES ("4", "17.5", "270", "5200", "7.5");
INSERT INTO "cars_data" VALUES ("5", "28.0", "180", "3500", "7.0");
INSERT INTO "cars_data" VALUES ("6", "26.0", "200", "3600", "6.8");
INSERT INTO "cars_data" VALUES ("7", "20.0", "370", "3200", "4.5");
INSERT INTO "cars_data" VALUES ("8", "19.0", "480", "3800", "3.5");
INSERT INTO "cars_data" VALUES ("9", "22.0", "260", "3300", "5.0");
INSERT INTO "cars_data" VALUES ("10", "28.0", "150", "2300", "6.5");
INSERT INTO "cars_data" VALUES ("11", "15.0", "670", "3000", "3.0");
INSERT INTO "cars_data" VALUES ("12", "14.0", "610", "3100", "2.8");
INSERT INTO "cars_data" VALUES ("13", "10.0", "1500", "4400", "2.4");
INSERT INTO "cars_data" VALUES ("14", "Electric", "760", "4900", "2.5");
INSERT INTO "cars_data" VALUES ("15", "18.0", "540", "3600", "3.2");