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_makers" (
"Id" INT UNIQUE,
"FullName" TEXT,
PRIMARY KEY ("Id")
);

CREATE TABLE "car_names" (
"MakeId" INT,
"Model" TEXT,
"Make" TEXT,
PRIMARY KEY ("MakeId"),
FOREIGN KEY ("Model") REFERENCES "model_list"("Model")
);

CREATE TABLE "model_list" (
"ModelId" INT,
"Maker" INT,
"Model" TEXT UNIQUE,
PRIMARY KEY ("ModelId"),
FOREIGN KEY ("Maker") REFERENCES "car_makers"("Id")
);





INSERT INTO "car_makers" VALUES ("1", "Toyota Motor Corporation");
INSERT INTO "car_makers" VALUES ("2", "Honda Motor Co.");
INSERT INTO "car_makers" VALUES ("3", "Ford Motor Company");
INSERT INTO "car_makers" VALUES ("4", "General Motors");
INSERT INTO "car_makers" VALUES ("5", "Volkswagen AG");
INSERT INTO "car_makers" VALUES ("6", "BMW AG");
INSERT INTO "car_makers" VALUES ("7", "Mercedes-Benz Group AG");
INSERT INTO "car_makers" VALUES ("8", "Nissan Motor Corporation");
INSERT INTO "car_makers" VALUES ("9", "Hyundai Motor Company");
INSERT INTO "car_makers" VALUES ("10", "Stellantis N.V.");
INSERT INTO "car_makers" VALUES ("11", "Tesla, Inc.");
INSERT INTO "car_makers" VALUES ("12", "Subaru Corporation");
INSERT INTO "car_makers" VALUES ("13", "Mazda Motor Corporation");
INSERT INTO "car_makers" VALUES ("14", "Volvo Car Corporation");
INSERT INTO "car_makers" VALUES ("15", "Kia Corporation");
INSERT INTO "car_makers" VALUES ("16", "Porsche AG");
INSERT INTO "car_makers" VALUES ("17", "Ferrari S.p.A.");
INSERT INTO "car_makers" VALUES ("18", "Aston Martin Lagonda Global Holdings plc");
INSERT INTO "car_makers" VALUES ("19", "Jaguar Land Rover Automotive PLC");
INSERT INTO "car_makers" VALUES ("20", "Suzuki Motor Corporation");
INSERT INTO "car_makers" VALUES ("21", "Mitsubishi Motors Corporation");
INSERT INTO "car_makers" VALUES ("22", "Rivian Automotive, Inc.");
INSERT INTO "car_makers" VALUES ("23", "Lucid Group, Inc.");
INSERT INTO "car_makers" VALUES ("24", "Polestar Performance AB");
INSERT INTO "car_makers" VALUES ("25", "BYD Auto");
INSERT INTO "car_makers" VALUES ("26", "Geely Automobile Holdings Limited");
INSERT INTO "car_makers" VALUES ("27", "Chery Automobile Co. Ltd.");
INSERT INTO "car_makers" VALUES ("28", "Great Wall Motor Company Limited");
INSERT INTO "car_makers" VALUES ("29", "SAIC Motor Corporation Limited");
INSERT INTO "car_makers" VALUES ("30", "Tata Motors Limited");
INSERT INTO "car_makers" VALUES ("31", "Mahindra & Mahindra Limited");
INSERT INTO "car_makers" VALUES ("32", "No Models Maker");
INSERT INTO "model_list" VALUES ("101", "1", "Camry");
INSERT INTO "model_list" VALUES ("102", "1", "Corolla");
INSERT INTO "model_list" VALUES ("103", "1", "RAV4");
INSERT INTO "model_list" VALUES ("104", "1", "Highlander");
INSERT INTO "model_list" VALUES ("105", "1", "Tacoma");
INSERT INTO "model_list" VALUES ("106", "1", "Sienna");
INSERT INTO "model_list" VALUES ("107", "1", "Prius");
INSERT INTO "model_list" VALUES ("108", "1", "Tundra");
INSERT INTO "model_list" VALUES ("109", "1", "4Runner");
INSERT INTO "model_list" VALUES ("110", "1", "Supra");
INSERT INTO "model_list" VALUES ("201", "2", "Civic");
INSERT INTO "model_list" VALUES ("202", "2", "CR-V");
INSERT INTO "model_list" VALUES ("203", "2", "Accord");
INSERT INTO "model_list" VALUES ("204", "2", "Pilot");
INSERT INTO "model_list" VALUES ("205", "2", "Ridgeline");
INSERT INTO "model_list" VALUES ("206", "2", "Odyssey");
INSERT INTO "model_list" VALUES ("207", "2", "HR-V");
INSERT INTO "model_list" VALUES ("301", "3", "F-150");
INSERT INTO "model_list" VALUES ("302", "3", "Explorer");
INSERT INTO "model_list" VALUES ("303", "3", "Escape");
INSERT INTO "model_list" VALUES ("304", "3", "Mustang");
INSERT INTO "model_list" VALUES ("305", "3", "Bronco");
INSERT INTO "model_list" VALUES ("306", "3", "Ranger");
INSERT INTO "model_list" VALUES ("307", "3", "Maverick");
INSERT INTO "model_list" VALUES ("401", "4", "Silverado");
INSERT INTO "model_list" VALUES ("402", "4", "Equinox");
INSERT INTO "model_list" VALUES ("403", "4", "Tahoe");
INSERT INTO "model_list" VALUES ("404", "4", "Malibu");
INSERT INTO "model_list" VALUES ("405", "4", "Colorado");
INSERT INTO "model_list" VALUES ("406", "4", "Blazer");
INSERT INTO "model_list" VALUES ("501", "5", "Jetta");
INSERT INTO "model_list" VALUES ("502", "5", "Tiguan");
INSERT INTO "model_list" VALUES ("503", "5", "Atlas");
INSERT INTO "model_list" VALUES ("504", "5", "Golf");
INSERT INTO "model_list" VALUES ("505", "5", "Passat");
INSERT INTO "model_list" VALUES ("601", "6", "3 Series");
INSERT INTO "model_list" VALUES ("602", "6", "X5");
INSERT INTO "model_list" VALUES ("603", "6", "5 Series");
INSERT INTO "model_list" VALUES ("604", "6", "X3");
INSERT INTO "model_list" VALUES ("701", "7", "C-Class");
INSERT INTO "model_list" VALUES ("702", "7", "E-Class");
INSERT INTO "model_list" VALUES ("703", "7", "GLC");
INSERT INTO "model_list" VALUES ("801", "8", "Altima");
INSERT INTO "model_list" VALUES ("802", "8", "Rogue");
INSERT INTO "model_list" VALUES ("803", "8", "Titan");
INSERT INTO "model_list" VALUES ("901", "9", "Elantra");
INSERT INTO "model_list" VALUES ("902", "9", "Tucson");
INSERT INTO "model_list" VALUES ("903", "9", "Santa Fe");
INSERT INTO "model_list" VALUES ("1001", "10", "Ram 1500");
INSERT INTO "model_list" VALUES ("1002", "10", "Jeep Wrangler");
INSERT INTO "model_list" VALUES ("1003", "10", "Dodge Charger");
INSERT INTO "model_list" VALUES ("1101", "11", "Model 3");
INSERT INTO "model_list" VALUES ("1102", "11", "Model Y");
INSERT INTO "model_list" VALUES ("1103", "11", "Model S");
INSERT INTO "model_list" VALUES ("1201", "12", "Outback");
INSERT INTO "model_list" VALUES ("1202", "12", "Forester");
INSERT INTO "model_list" VALUES ("1301", "13", "CX-5");
INSERT INTO "model_list" VALUES ("1302", "13", "Mazda3");
INSERT INTO "model_list" VALUES ("1401", "14", "XC60");
INSERT INTO "model_list" VALUES ("1402", "14", "S60");
INSERT INTO "model_list" VALUES ("1501", "15", "Telluride");
INSERT INTO "model_list" VALUES ("1502", "15", "Sportage");
INSERT INTO "model_list" VALUES ("1601", "16", "911");
INSERT INTO "model_list" VALUES ("1602", "16", "Cayenne");
INSERT INTO "model_list" VALUES ("1701", "17", "Roma");
INSERT INTO "model_list" VALUES ("1702", "17", "SF90 Stradale");
INSERT INTO "model_list" VALUES ("1801", "18", "Vantage");
INSERT INTO "model_list" VALUES ("1802", "18", "DB11");
INSERT INTO "model_list" VALUES ("1901", "19", "F-PACE");
INSERT INTO "model_list" VALUES ("1902", "19", "Range Rover");
INSERT INTO "model_list" VALUES ("2001", "20", "Swift");
INSERT INTO "model_list" VALUES ("2002", "20", "Vitara");
INSERT INTO "model_list" VALUES ("2101", "21", "Outlander");
INSERT INTO "model_list" VALUES ("2102", "21", "Eclipse Cross");
INSERT INTO "model_list" VALUES ("2201", "22", "R1T");
INSERT INTO "model_list" VALUES ("2202", "22", "R1S");
INSERT INTO "model_list" VALUES ("2301", "23", "Air");
INSERT INTO "model_list" VALUES ("2401", "24", "Polestar 2");
INSERT INTO "model_list" VALUES ("2501", "25", "Han");
INSERT INTO "model_list" VALUES ("2502", "25", "Tang");
INSERT INTO "model_list" VALUES ("2601", "26", "Coolray");
INSERT INTO "model_list" VALUES ("2602", "26", "Xingyue L");
INSERT INTO "model_list" VALUES ("2701", "27", "Tiggo 8");
INSERT INTO "model_list" VALUES ("2702", "27", "Arrizo 5");
INSERT INTO "model_list" VALUES ("2801", "28", "Haval H6");
INSERT INTO "model_list" VALUES ("2802", "28", "Tank 300");
INSERT INTO "model_list" VALUES ("2901", "29", "MG ZS");
INSERT INTO "model_list" VALUES ("2902", "29", "Roewe RX5");
INSERT INTO "model_list" VALUES ("3001", "30", "Nexon");
INSERT INTO "model_list" VALUES ("3002", "30", "Punch");
INSERT INTO "model_list" VALUES ("3101", "31", "Thar");
INSERT INTO "model_list" VALUES ("3102", "31", "XUV700");
INSERT INTO "car_names" VALUES ("1", "Camry", "Toyota");
INSERT INTO "car_names" VALUES ("2", "Civic", "Honda");
INSERT INTO "car_names" VALUES ("3", "F-150", "Ford");
INSERT INTO "car_names" VALUES ("4", "Silverado", "Chevrolet");
INSERT INTO "car_names" VALUES ("5", "Jetta", "Volkswagen");
INSERT INTO "car_names" VALUES ("6", "3 Series", "BMW");
INSERT INTO "car_names" VALUES ("7", "C-Class", "Mercedes-Benz");
INSERT INTO "car_names" VALUES ("8", "Altima", "Nissan");
INSERT INTO "car_names" VALUES ("9", "Elantra", "Hyundai");
INSERT INTO "car_names" VALUES ("10", "Ram 1500", "Ram");
INSERT INTO "car_names" VALUES ("11", "Model 3", "Tesla");
INSERT INTO "car_names" VALUES ("12", "Outback", "Subaru");
INSERT INTO "car_names" VALUES ("13", "CX-5", "Mazda");
INSERT INTO "car_names" VALUES ("14", "XC60", "Volvo");
INSERT INTO "car_names" VALUES ("15", "Telluride", "Kia");
INSERT INTO "car_names" VALUES ("16", "911", "Porsche");
INSERT INTO "car_names" VALUES ("17", "Roma", "Ferrari");
INSERT INTO "car_names" VALUES ("18", "Vantage", "Aston Martin");
INSERT INTO "car_names" VALUES ("19", "F-PACE", "Jaguar");
INSERT INTO "car_names" VALUES ("20", "Swift", "Suzuki");
INSERT INTO "car_names" VALUES ("21", "Outlander", "Mitsubishi");
INSERT INTO "car_names" VALUES ("22", "R1T", "Rivian");
INSERT INTO "car_names" VALUES ("23", "Air", "Lucid");
INSERT INTO "car_names" VALUES ("24", "Polestar 2", "Polestar");
INSERT INTO "car_names" VALUES ("25", "Han", "BYD");
INSERT INTO "car_names" VALUES ("26", "Coolray", "Geely");
INSERT INTO "car_names" VALUES ("27", "Tiggo 8", "Chery");
INSERT INTO "car_names" VALUES ("28", "Haval H6", "Great Wall");
INSERT INTO "car_names" VALUES ("29", "MG ZS", "MG");
INSERT INTO "car_names" VALUES ("30", "Nexon", "Tata");
INSERT INTO "car_names" VALUES ("31", "Thar", "Mahindra");