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

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

CREATE TABLE "cars_data" (
"Id" INT,
PRIMARY KEY ("Id"),
FOREIGN KEY ("Id") REFERENCES "car_names"("MakeId")
);

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", "Ford", "Ford Motor Company");
INSERT INTO "car_makers" VALUES ("2", "Honda", "Honda Motor Co.");
INSERT INTO "car_makers" VALUES ("3", "Toyota", "Toyota Motor Corporation");
INSERT INTO "car_makers" VALUES ("4", "BMW", "Bayerische Motoren Werke AG");
INSERT INTO "car_makers" VALUES ("5", "Mercedes-Benz", "Mercedes-Benz Group AG");
INSERT INTO "car_makers" VALUES ("6", "Audi", "Audi AG");
INSERT INTO "car_makers" VALUES ("7", "Nissan", "Nissan Motor Corporation");
INSERT INTO "car_makers" VALUES ("8", "Chevrolet", "Chevrolet");
INSERT INTO "car_makers" VALUES ("9", "Volkswagen", "Volkswagen AG");
INSERT INTO "car_makers" VALUES ("10", "Hyundai", "Hyundai Motor Company");
INSERT INTO "model_list" VALUES ("101", "1", "F-150");
INSERT INTO "model_list" VALUES ("102", "1", "Mustang");
INSERT INTO "model_list" VALUES ("103", "1", "Explorer");
INSERT INTO "model_list" VALUES ("104", "2", "Civic");
INSERT INTO "model_list" VALUES ("105", "2", "CR-V");
INSERT INTO "model_list" VALUES ("106", "3", "Camry");
INSERT INTO "model_list" VALUES ("107", "3", "Corolla");
INSERT INTO "model_list" VALUES ("108", "4", "3 Series");
INSERT INTO "model_list" VALUES ("109", "4", "X5");
INSERT INTO "model_list" VALUES ("110", "5", "C-Class");
INSERT INTO "model_list" VALUES ("111", "5", "E-Class");
INSERT INTO "model_list" VALUES ("112", "6", "A4");
INSERT INTO "model_list" VALUES ("113", "6", "Q5");
INSERT INTO "model_list" VALUES ("114", "7", "Altima");
INSERT INTO "model_list" VALUES ("115", "7", "Rogue");
INSERT INTO "model_list" VALUES ("116", "8", "Silverado");
INSERT INTO "model_list" VALUES ("117", "8", "Malibu");
INSERT INTO "model_list" VALUES ("118", "9", "Jetta");
INSERT INTO "model_list" VALUES ("119", "9", "Golf");
INSERT INTO "model_list" VALUES ("120", "10", "Elantra");
INSERT INTO "model_list" VALUES ("121", "10", "Tucson");
INSERT INTO "model_list" VALUES ("122", "1", "Focus");
INSERT INTO "model_list" VALUES ("123", "2", "Accord");
INSERT INTO "model_list" VALUES ("124", "3", "RAV4");
INSERT INTO "model_list" VALUES ("125", "4", "5 Series");
INSERT INTO "model_list" VALUES ("126", "5", "S-Class");
INSERT INTO "model_list" VALUES ("127", "6", "A6");
INSERT INTO "model_list" VALUES ("128", "7", "Titan");
INSERT INTO "model_list" VALUES ("129", "8", "Equinox");
INSERT INTO "model_list" VALUES ("130", "9", "Passat");
INSERT INTO "model_list" VALUES ("131", "10", "Sonata");
INSERT INTO "model_list" VALUES ("132", "1", "Escape");
INSERT INTO "model_list" VALUES ("133", "2", "Pilot");
INSERT INTO "model_list" VALUES ("134", "3", "Highlander");
INSERT INTO "model_list" VALUES ("135", "4", "X3");
INSERT INTO "model_list" VALUES ("136", "5", "GLC");
INSERT INTO "model_list" VALUES ("137", "6", "Q7");
INSERT INTO "model_list" VALUES ("138", "7", "Sentra");
INSERT INTO "model_list" VALUES ("139", "8", "Tahoe");
INSERT INTO "model_list" VALUES ("140", "9", "Tiguan");
INSERT INTO "model_list" VALUES ("141", "10", "Santa Fe");
INSERT INTO "model_list" VALUES ("142", "1", "Bronco");
INSERT INTO "model_list" VALUES ("143", "1", "Ranger");
INSERT INTO "model_list" VALUES ("144", "1", "Edge");
INSERT INTO "model_list" VALUES ("145", "1", "Maverick");
INSERT INTO "model_list" VALUES ("146", "1", "Transit");
INSERT INTO "model_list" VALUES ("147", "1", "Expedition");
INSERT INTO "model_list" VALUES ("148", "1", "Mach-E");
INSERT INTO "model_list" VALUES ("149", "1", "Lightning");
INSERT INTO "model_list" VALUES ("150", "1", "Super Duty");
INSERT INTO "car_names" VALUES ("1", "F-150", "Ford F-150");
INSERT INTO "car_names" VALUES ("2", "Mustang", "Ford Mustang");
INSERT INTO "car_names" VALUES ("3", "Explorer", "Ford Explorer");
INSERT INTO "car_names" VALUES ("4", "Civic", "Honda Civic");
INSERT INTO "car_names" VALUES ("5", "CR-V", "Honda CR-V");
INSERT INTO "car_names" VALUES ("6", "Camry", "Toyota Camry");
INSERT INTO "car_names" VALUES ("7", "Corolla", "Toyota Corolla");
INSERT INTO "car_names" VALUES ("8", "3 Series", "BMW 3 Series");
INSERT INTO "car_names" VALUES ("9", "X5", "BMW X5");
INSERT INTO "car_names" VALUES ("10", "C-Class", "Mercedes-Benz C-Class");
INSERT INTO "car_names" VALUES ("11", "E-Class", "Mercedes-Benz E-Class");
INSERT INTO "car_names" VALUES ("12", "A4", "Audi A4");
INSERT INTO "car_names" VALUES ("13", "Q5", "Audi Q5");
INSERT INTO "car_names" VALUES ("14", "Altima", "Nissan Altima");
INSERT INTO "car_names" VALUES ("15", "Rogue", "Nissan Rogue");
INSERT INTO "car_names" VALUES ("16", "Silverado", "Chevrolet Silverado");
INSERT INTO "car_names" VALUES ("17", "Malibu", "Chevrolet Malibu");
INSERT INTO "car_names" VALUES ("18", "Jetta", "Volkswagen Jetta");
INSERT INTO "car_names" VALUES ("19", "Golf", "Volkswagen Golf");
INSERT INTO "car_names" VALUES ("20", "Elantra", "Hyundai Elantra");
INSERT INTO "car_names" VALUES ("21", "Tucson", "Hyundai Tucson");
INSERT INTO "car_names" VALUES ("22", "Focus", "Ford Focus");
INSERT INTO "car_names" VALUES ("23", "Accord", "Honda Accord");
INSERT INTO "car_names" VALUES ("24", "RAV4", "Toyota RAV4");
INSERT INTO "car_names" VALUES ("25", "5 Series", "BMW 5 Series");
INSERT INTO "car_names" VALUES ("26", "S-Class", "Mercedes-Benz S-Class");
INSERT INTO "car_names" VALUES ("27", "A6", "Audi A6");
INSERT INTO "car_names" VALUES ("28", "Titan", "Nissan Titan");
INSERT INTO "car_names" VALUES ("29", "Equinox", "Chevrolet Equinox");
INSERT INTO "car_names" VALUES ("30", "Passat", "Volkswagen Passat");
INSERT INTO "car_names" VALUES ("31", "Sonata", "Hyundai Sonata");
INSERT INTO "car_names" VALUES ("32", "Escape", "Ford Escape");
INSERT INTO "car_names" VALUES ("33", "Pilot", "Honda Pilot");
INSERT INTO "car_names" VALUES ("34", "Highlander", "Toyota Highlander");
INSERT INTO "car_names" VALUES ("35", "X3", "BMW X3");
INSERT INTO "car_names" VALUES ("36", "GLC", "Mercedes-Benz GLC");
INSERT INTO "car_names" VALUES ("37", "Q7", "Audi Q7");
INSERT INTO "car_names" VALUES ("38", "Sentra", "Nissan Sentra");
INSERT INTO "car_names" VALUES ("39", "Tahoe", "Chevrolet Tahoe");
INSERT INTO "car_names" VALUES ("40", "Tiguan", "Volkswagen Tiguan");
INSERT INTO "car_names" VALUES ("41", "Santa Fe", "Hyundai Santa Fe");
INSERT INTO "car_names" VALUES ("42", "Bronco", "Ford Bronco");
INSERT INTO "car_names" VALUES ("43", "Ranger", "Ford Ranger");
INSERT INTO "car_names" VALUES ("44", "Edge", "Ford Edge");
INSERT INTO "car_names" VALUES ("45", "Maverick", "Ford Maverick");
INSERT INTO "car_names" VALUES ("46", "Transit", "Ford Transit");
INSERT INTO "car_names" VALUES ("47", "Expedition", "Ford Expedition");
INSERT INTO "car_names" VALUES ("48", "Mach-E", "Ford Mustang Mach-E");
INSERT INTO "car_names" VALUES ("49", "Lightning", "Ford F-150 Lightning");
INSERT INTO "car_names" VALUES ("50", "Super Duty", "Ford F-Series Super Duty");
INSERT INTO "car_names" VALUES ("51", "F-150", "Ford F-150 Raptor");
INSERT INTO "car_names" VALUES ("52", "Mustang", "Ford Mustang GT");
INSERT INTO "car_names" VALUES ("53", "Explorer", "Ford Explorer ST");
INSERT INTO "car_names" VALUES ("54", "Civic", "Honda Civic Type R");
INSERT INTO "car_names" VALUES ("55", "CR-V", "Honda CR-V Hybrid");
INSERT INTO "car_names" VALUES ("56", "Camry", "Toyota Camry TRD");
INSERT INTO "car_names" VALUES ("57", "Corolla", "Toyota Corolla Cross");
INSERT INTO "car_names" VALUES ("58", "3 Series", "BMW M3");
INSERT INTO "car_names" VALUES ("59", "X5", "BMW X5 M");
INSERT INTO "car_names" VALUES ("60", "C-Class", "Mercedes-AMG C 63");
INSERT INTO "car_names" VALUES ("61", "E-Class", "Mercedes-AMG E 53");
INSERT INTO "car_names" VALUES ("62", "A4", "Audi S4");
INSERT INTO "car_names" VALUES ("63", "Q5", "Audi SQ5");
INSERT INTO "car_names" VALUES ("64", "Altima", "Nissan Altima SR");
INSERT INTO "car_names" VALUES ("65", "Rogue", "Nissan Rogue Sport");
INSERT INTO "car_names" VALUES ("66", "Silverado", "Chevrolet Silverado HD");
INSERT INTO "car_names" VALUES ("67", "Malibu", "Chevrolet Malibu RS");
INSERT INTO "car_names" VALUES ("68", "Jetta", "Volkswagen Jetta GLI");
INSERT INTO "car_names" VALUES ("69", "Golf", "Volkswagen Golf GTI");
INSERT INTO "car_names" VALUES ("70", "Elantra", "Hyundai Elantra N");
INSERT INTO "car_names" VALUES ("71", "Tucson", "Hyundai Tucson Hybrid");
INSERT INTO "car_names" VALUES ("72", "Focus", "Ford Focus RS");
INSERT INTO "car_names" VALUES ("73", "Accord", "Honda Accord Hybrid");
INSERT INTO "car_names" VALUES ("74", "RAV4", "Toyota RAV4 Prime");
INSERT INTO "car_names" VALUES ("75", "5 Series", "BMW M5");
INSERT INTO "car_names" VALUES ("76", "S-Class", "Mercedes-AMG S 63");
INSERT INTO "car_names" VALUES ("77", "A6", "Audi RS 6 Avant");
INSERT INTO "car_names" VALUES ("78", "Titan", "Nissan Titan XD");
INSERT INTO "car_names" VALUES ("79", "Equinox", "Chevrolet Equinox RS");
INSERT INTO "car_names" VALUES ("80", "Passat", "Volkswagen Passat R-Line");
INSERT INTO "car_names" VALUES ("81", "Sonata", "Hyundai Sonata N Line");
INSERT INTO "car_names" VALUES ("82", "Escape", "Ford Escape Hybrid");
INSERT INTO "car_names" VALUES ("83", "Pilot", "Honda Pilot Black Edition");
INSERT INTO "car_names" VALUES ("84", "Highlander", "Toyota Highlander Hybrid");
INSERT INTO "car_names" VALUES ("85", "X3", "BMW X3 M");
INSERT INTO "car_names" VALUES ("86", "GLC", "Mercedes-AMG GLC 43");
INSERT INTO "car_names" VALUES ("87", "Q7", "Audi SQ7");
INSERT INTO "car_names" VALUES ("88", "Sentra", "Nissan Sentra SR");
INSERT INTO "car_names" VALUES ("89", "Tahoe", "Chevrolet Tahoe Z71");
INSERT INTO "car_names" VALUES ("90", "Tiguan", "Volkswagen Tiguan R-Line");
INSERT INTO "car_names" VALUES ("91", "Santa Fe", "Hyundai Santa Fe Calligraphy");
INSERT INTO "car_names" VALUES ("92", "Bronco", "Ford Bronco Sport");
INSERT INTO "car_names" VALUES ("93", "Ranger", "Ford Ranger Raptor");
INSERT INTO "car_names" VALUES ("94", "Edge", "Ford Edge ST");
INSERT INTO "car_names" VALUES ("95", "Maverick", "Ford Maverick Hybrid");
INSERT INTO "car_names" VALUES ("96", "Transit", "Ford Transit Connect");
INSERT INTO "car_names" VALUES ("97", "Expedition", "Ford Expedition Max");
INSERT INTO "car_names" VALUES ("98", "Mach-E", "Ford Mustang Mach-E GT");
INSERT INTO "car_names" VALUES ("99", "Lightning", "Ford F-150 Lightning Pro");
INSERT INTO "car_names" VALUES ("100", "Super Duty", "Ford F-450 Super Duty");
INSERT INTO "cars_data" VALUES ("1");
INSERT INTO "cars_data" VALUES ("2");
INSERT INTO "cars_data" VALUES ("3");
INSERT INTO "cars_data" VALUES ("4");
INSERT INTO "cars_data" VALUES ("5");
INSERT INTO "cars_data" VALUES ("6");
INSERT INTO "cars_data" VALUES ("7");
INSERT INTO "cars_data" VALUES ("8");
INSERT INTO "cars_data" VALUES ("9");
INSERT INTO "cars_data" VALUES ("10");
INSERT INTO "cars_data" VALUES ("11");
INSERT INTO "cars_data" VALUES ("12");
INSERT INTO "cars_data" VALUES ("13");
INSERT INTO "cars_data" VALUES ("14");
INSERT INTO "cars_data" VALUES ("15");
INSERT INTO "cars_data" VALUES ("16");
INSERT INTO "cars_data" VALUES ("17");
INSERT INTO "cars_data" VALUES ("18");
INSERT INTO "cars_data" VALUES ("19");
INSERT INTO "cars_data" VALUES ("20");
INSERT INTO "cars_data" VALUES ("21");
INSERT INTO "cars_data" VALUES ("22");
INSERT INTO "cars_data" VALUES ("23");
INSERT INTO "cars_data" VALUES ("24");
INSERT INTO "cars_data" VALUES ("25");
INSERT INTO "cars_data" VALUES ("26");
INSERT INTO "cars_data" VALUES ("27");
INSERT INTO "cars_data" VALUES ("28");
INSERT INTO "cars_data" VALUES ("29");
INSERT INTO "cars_data" VALUES ("30");
INSERT INTO "cars_data" VALUES ("31");
INSERT INTO "cars_data" VALUES ("32");
INSERT INTO "cars_data" VALUES ("33");
INSERT INTO "cars_data" VALUES ("34");
INSERT INTO "cars_data" VALUES ("35");
INSERT INTO "cars_data" VALUES ("36");
INSERT INTO "cars_data" VALUES ("37");
INSERT INTO "cars_data" VALUES ("38");
INSERT INTO "cars_data" VALUES ("39");
INSERT INTO "cars_data" VALUES ("40");
INSERT INTO "cars_data" VALUES ("41");
INSERT INTO "cars_data" VALUES ("42");
INSERT INTO "cars_data" VALUES ("43");
INSERT INTO "cars_data" VALUES ("44");
INSERT INTO "cars_data" VALUES ("45");
INSERT INTO "cars_data" VALUES ("46");
INSERT INTO "cars_data" VALUES ("47");
INSERT INTO "cars_data" VALUES ("48");
INSERT INTO "cars_data" VALUES ("49");
INSERT INTO "cars_data" VALUES ("50");
INSERT INTO "cars_data" VALUES ("51");
INSERT INTO "cars_data" VALUES ("52");
INSERT INTO "cars_data" VALUES ("53");
INSERT INTO "cars_data" VALUES ("54");
INSERT INTO "cars_data" VALUES ("55");
INSERT INTO "cars_data" VALUES ("56");
INSERT INTO "cars_data" VALUES ("57");
INSERT INTO "cars_data" VALUES ("58");
INSERT INTO "cars_data" VALUES ("59");
INSERT INTO "cars_data" VALUES ("60");
INSERT INTO "cars_data" VALUES ("61");
INSERT INTO "cars_data" VALUES ("62");
INSERT INTO "cars_data" VALUES ("63");
INSERT INTO "cars_data" VALUES ("64");
INSERT INTO "cars_data" VALUES ("65");
INSERT INTO "cars_data" VALUES ("66");
INSERT INTO "cars_data" VALUES ("67");
INSERT INTO "cars_data" VALUES ("68");
INSERT INTO "cars_data" VALUES ("69");
INSERT INTO "cars_data" VALUES ("70");
INSERT INTO "cars_data" VALUES ("71");
INSERT INTO "cars_data" VALUES ("72");
INSERT INTO "cars_data" VALUES ("73");
INSERT INTO "cars_data" VALUES ("74");
INSERT INTO "cars_data" VALUES ("75");
INSERT INTO "cars_data" VALUES ("76");
INSERT INTO "cars_data" VALUES ("77");
INSERT INTO "cars_data" VALUES ("78");
INSERT INTO "cars_data" VALUES ("79");
INSERT INTO "cars_data" VALUES ("80");
INSERT INTO "cars_data" VALUES ("81");
INSERT INTO "cars_data" VALUES ("82");
INSERT INTO "cars_data" VALUES ("83");
INSERT INTO "cars_data" VALUES ("84");
INSERT INTO "cars_data" VALUES ("85");
INSERT INTO "cars_data" VALUES ("86");
INSERT INTO "cars_data" VALUES ("87");
INSERT INTO "cars_data" VALUES ("88");
INSERT INTO "cars_data" VALUES ("89");
INSERT INTO "cars_data" VALUES ("90");
INSERT INTO "cars_data" VALUES ("91");
INSERT INTO "cars_data" VALUES ("92");
INSERT INTO "cars_data" VALUES ("93");
INSERT INTO "cars_data" VALUES ("94");
INSERT INTO "cars_data" VALUES ("95");
INSERT INTO "cars_data" VALUES ("96");
INSERT INTO "cars_data" VALUES ("97");
INSERT INTO "cars_data" VALUES ("98");
INSERT INTO "cars_data" VALUES ("99");
INSERT INTO "cars_data" VALUES ("100");