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 "circuits" (
"circuitId" INT,
"name" TEXT,
PRIMARY KEY ("circuitId")
);

CREATE TABLE "drivers" (
"driverId" INT,
"forename" TEXT,
"surname" TEXT,
PRIMARY KEY ("driverId")
);

CREATE TABLE "races" (
"raceId" INT,
"year" INT,
"name" TEXT,
PRIMARY KEY ("raceId")
);



INSERT INTO "circuits" VALUES ("1", "Albert Park Grand Prix Circuit");
INSERT INTO "circuits" VALUES ("2", "Sepang International Circuit");
INSERT INTO "circuits" VALUES ("3", "Bahrain International Circuit");
INSERT INTO "circuits" VALUES ("4", "Circuit de Barcelona-Catalunya");
INSERT INTO "circuits" VALUES ("5", "Istanbul Park");
INSERT INTO "circuits" VALUES ("6", "Circuit de Monaco");
INSERT INTO "circuits" VALUES ("7", "Circuit Gilles Villeneuve");
INSERT INTO "circuits" VALUES ("8", "Circuit de Nevers Magny-Cours");
INSERT INTO "circuits" VALUES ("9", "Silverstone Circuit");
INSERT INTO "circuits" VALUES ("10", "Hockenheimring");
INSERT INTO "circuits" VALUES ("11", "Hungaroring");
INSERT INTO "circuits" VALUES ("12", "Circuit de Spa-Francorchamps");
INSERT INTO "circuits" VALUES ("13", "Autodromo Nazionale Monza");
INSERT INTO "circuits" VALUES ("14", "Shanghai International Circuit");
INSERT INTO "circuits" VALUES ("15", "Suzuka Circuit");
INSERT INTO "circuits" VALUES ("16", "Autódromo José Carlos Pace");
INSERT INTO "circuits" VALUES ("17", "Adelaide Street Circuit");
INSERT INTO "circuits" VALUES ("18", "Kyalami");
INSERT INTO "circuits" VALUES ("19", "Circuit Paul Ricard");
INSERT INTO "circuits" VALUES ("20", "Brands Hatch");
INSERT INTO "circuits" VALUES ("21", "Zandvoort");
INSERT INTO "circuits" VALUES ("22", "Autódromo do Estoril");
INSERT INTO "circuits" VALUES ("23", "Imola");
INSERT INTO "circuits" VALUES ("24", "Nürburgring");
INSERT INTO "circuits" VALUES ("25", "Jerez");
INSERT INTO "circuits" VALUES ("26", "Fuji Speedway");
INSERT INTO "circuits" VALUES ("27", "Indianapolis Motor Speedway");
INSERT INTO "circuits" VALUES ("28", "Yas Marina Circuit");
INSERT INTO "circuits" VALUES ("29", "Marina Bay Street Circuit");
INSERT INTO "circuits" VALUES ("30", "Baku City Circuit");
INSERT INTO "drivers" VALUES ("1", "Lewis", "Hamilton");
INSERT INTO "drivers" VALUES ("2", "Max", "Verstappen");
INSERT INTO "drivers" VALUES ("3", "Charles", "Leclerc");
INSERT INTO "drivers" VALUES ("4", "Sergio", "Pérez");
INSERT INTO "drivers" VALUES ("5", "George", "Russell");
INSERT INTO "drivers" VALUES ("6", "Carlos", "Sainz");
INSERT INTO "drivers" VALUES ("7", "Lando", "Norris");
INSERT INTO "drivers" VALUES ("8", "Fernando", "Alonso");
INSERT INTO "drivers" VALUES ("9", "Sebastian", "Vettel");
INSERT INTO "drivers" VALUES ("10", "Daniel", "Ricciardo");
INSERT INTO "races" VALUES ("1", "2008", "Australian Grand Prix");
INSERT INTO "races" VALUES ("2", "2008", "Malaysian Grand Prix");
INSERT INTO "races" VALUES ("3", "2008", "Bahrain Grand Prix");
INSERT INTO "races" VALUES ("4", "2008", "Spanish Grand Prix");
INSERT INTO "races" VALUES ("5", "2008", "Turkish Grand Prix");
INSERT INTO "races" VALUES ("6", "2008", "Monaco Grand Prix");
INSERT INTO "races" VALUES ("7", "2008", "Canadian Grand Prix");
INSERT INTO "races" VALUES ("8", "2008", "French Grand Prix");
INSERT INTO "races" VALUES ("9", "2008", "British Grand Prix");
INSERT INTO "races" VALUES ("10", "2008", "German Grand Prix");
INSERT INTO "races" VALUES ("11", "2008", "Hungarian Grand Prix");
INSERT INTO "races" VALUES ("12", "2008", "European Grand Prix");
INSERT INTO "races" VALUES ("13", "2008", "Belgian Grand Prix");
INSERT INTO "races" VALUES ("14", "2008", "Italian Grand Prix");
INSERT INTO "races" VALUES ("15", "2008", "Singapore Grand Prix");
INSERT INTO "races" VALUES ("16", "2008", "Japanese Grand Prix");
INSERT INTO "races" VALUES ("17", "2008", "Chinese Grand Prix");
INSERT INTO "races" VALUES ("18", "2008", "Brazilian Grand Prix");
INSERT INTO "races" VALUES ("19", "2009", "Australian Grand Prix");
INSERT INTO "races" VALUES ("20", "2009", "Malaysian Grand Prix");
INSERT INTO "races" VALUES ("21", "2009", "Chinese Grand Prix");
INSERT INTO "races" VALUES ("22", "2009", "Bahrain Grand Prix");
INSERT INTO "races" VALUES ("23", "2009", "Spanish Grand Prix");
INSERT INTO "races" VALUES ("24", "2009", "Monaco Grand Prix");
INSERT INTO "races" VALUES ("25", "2009", "Turkish Grand Prix");
INSERT INTO "races" VALUES ("26", "2009", "British Grand Prix");
INSERT INTO "races" VALUES ("27", "2009", "German Grand Prix");
INSERT INTO "races" VALUES ("28", "2009", "Hungarian Grand Prix");
INSERT INTO "races" VALUES ("29", "2009", "European Grand Prix");
INSERT INTO "races" VALUES ("30", "2009", "Belgian Grand Prix");
INSERT INTO "races" VALUES ("31", "2009", "Italian Grand Prix");
INSERT INTO "races" VALUES ("32", "2009", "Singapore Grand Prix");
INSERT INTO "races" VALUES ("33", "2009", "Japanese Grand Prix");
INSERT INTO "races" VALUES ("34", "2009", "Brazilian Grand Prix");
INSERT INTO "races" VALUES ("35", "2009", "Abu Dhabi Grand Prix");
INSERT INTO "races" VALUES ("36", "2010", "Bahrain Grand Prix");
INSERT INTO "races" VALUES ("37", "2010", "Australian Grand Prix");
INSERT INTO "races" VALUES ("38", "2010", "Malaysian Grand Prix");
INSERT INTO "races" VALUES ("39", "2010", "Chinese Grand Prix");
INSERT INTO "races" VALUES ("40", "2010", "Spanish Grand Prix");
INSERT INTO "races" VALUES ("41", "2010", "Monaco Grand Prix");
INSERT INTO "races" VALUES ("42", "2010", "Turkish Grand Prix");
INSERT INTO "races" VALUES ("43", "2010", "Canadian Grand Prix");
INSERT INTO "races" VALUES ("44", "2010", "European Grand Prix");
INSERT INTO "races" VALUES ("45", "2010", "British Grand Prix");
INSERT INTO "races" VALUES ("46", "2010", "German Grand Prix");
INSERT INTO "races" VALUES ("47", "2010", "Hungarian Grand Prix");
INSERT INTO "races" VALUES ("48", "2010", "Belgian Grand Prix");
INSERT INTO "races" VALUES ("49", "2010", "Italian Grand Prix");
INSERT INTO "races" VALUES ("50", "2010", "Singapore Grand Prix");
INSERT INTO "races" VALUES ("51", "2010", "Japanese Grand Prix");
INSERT INTO "races" VALUES ("52", "2010", "Korean Grand Prix");
INSERT INTO "races" VALUES ("53", "2010", "Brazilian Grand Prix");
INSERT INTO "races" VALUES ("54", "2010", "Abu Dhabi Grand Prix");
INSERT INTO "races" VALUES ("55", "2011", "Australian Grand Prix");
INSERT INTO "races" VALUES ("56", "2011", "Malaysian Grand Prix");
INSERT INTO "races" VALUES ("57", "2011", "Chinese Grand Prix");
INSERT INTO "races" VALUES ("58", "2011", "Turkish Grand Prix");
INSERT INTO "races" VALUES ("59", "2011", "Spanish Grand Prix");
INSERT INTO "races" VALUES ("60", "2011", "Monaco Grand Prix");
INSERT INTO "races" VALUES ("61", "2011", "Canadian Grand Prix");
INSERT INTO "races" VALUES ("62", "2011", "European Grand Prix");
INSERT INTO "races" VALUES ("63", "2011", "British Grand Prix");
INSERT INTO "races" VALUES ("64", "2011", "German Grand Prix");
INSERT INTO "races" VALUES ("65", "2011", "Hungarian Grand Prix");
INSERT INTO "races" VALUES ("66", "2011", "Belgian Grand Prix");
INSERT INTO "races" VALUES ("67", "2011", "Italian Grand Prix");
INSERT INTO "races" VALUES ("68", "2011", "Singapore Grand Prix");
INSERT INTO "races" VALUES ("69", "2011", "Japanese Grand Prix");
INSERT INTO "races" VALUES ("70", "2011", "Korean Grand Prix");
INSERT INTO "races" VALUES ("71", "2011", "Indian Grand Prix");
INSERT INTO "races" VALUES ("72", "2011", "Abu Dhabi Grand Prix");
INSERT INTO "races" VALUES ("73", "2011", "Brazilian Grand Prix");
INSERT INTO "races" VALUES ("74", "2012", "Australian Grand Prix");
INSERT INTO "races" VALUES ("75", "2012", "Malaysian Grand Prix");
INSERT INTO "races" VALUES ("76", "2012", "Chinese Grand Prix");
INSERT INTO "races" VALUES ("77", "2012", "Bahrain Grand Prix");
INSERT INTO "races" VALUES ("78", "2012", "Spanish Grand Prix");
INSERT INTO "races" VALUES ("79", "2012", "Monaco Grand Prix");
INSERT INTO "races" VALUES ("80", "2012", "Canadian Grand Prix");
INSERT INTO "races" VALUES ("81", "2012", "European Grand Prix");
INSERT INTO "races" VALUES ("82", "2012", "British Grand Prix");
INSERT INTO "races" VALUES ("83", "2012", "German Grand Prix");
INSERT INTO "races" VALUES ("84", "2012", "Hungarian Grand Prix");
INSERT INTO "races" VALUES ("85", "2012", "Belgian Grand Prix");
INSERT INTO "races" VALUES ("86", "2012", "Italian Grand Prix");
INSERT INTO "races" VALUES ("87", "2012", "Singapore Grand Prix");
INSERT INTO "races" VALUES ("88", "2012", "Japanese Grand Prix");
INSERT INTO "races" VALUES ("89", "2012", "Korean Grand Prix");
INSERT INTO "races" VALUES ("90", "2012", "Indian Grand Prix");
INSERT INTO "races" VALUES ("91", "2012", "Abu Dhabi Grand Prix");
INSERT INTO "races" VALUES ("92", "2012", "United States Grand Prix");
INSERT INTO "races" VALUES ("93", "2012", "Brazilian Grand Prix");
INSERT INTO "races" VALUES ("94", "2013", "Australian Grand Prix");
INSERT INTO "races" VALUES ("95", "2013", "Malaysian Grand Prix");
INSERT INTO "races" VALUES ("96", "2013", "Chinese Grand Prix");
INSERT INTO "races" VALUES ("97", "2013", "Bahrain Grand Prix");
INSERT INTO "races" VALUES ("98", "2013", "Spanish Grand Prix");
INSERT INTO "races" VALUES ("99", "2013", "Monaco Grand Prix");
INSERT INTO "races" VALUES ("100", "2013", "Canadian Grand Prix");
INSERT INTO "races" VALUES ("101", "2013", "British Grand Prix");
INSERT INTO "races" VALUES ("102", "2013", "German Grand Prix");
INSERT INTO "races" VALUES ("103", "2013", "Hungarian Grand Prix");
INSERT INTO "races" VALUES ("104", "2013", "Belgian Grand Prix");
INSERT INTO "races" VALUES ("105", "2013", "Italian Grand Prix");
INSERT INTO "races" VALUES ("106", "2013", "Singapore Grand Prix");
INSERT INTO "races" VALUES ("107", "2013", "Korean Grand Prix");
INSERT INTO "races" VALUES ("108", "2013", "Japanese Grand Prix");
INSERT INTO "races" VALUES ("109", "2013", "Indian Grand Prix");
INSERT INTO "races" VALUES ("110", "2013", "Abu Dhabi Grand Prix");
INSERT INTO "races" VALUES ("111", "2013", "United States Grand Prix");
INSERT INTO "races" VALUES ("112", "2013", "Brazilian Grand Prix");
INSERT INTO "races" VALUES ("113", "2014", "Australian Grand Prix");
INSERT INTO "races" VALUES ("114", "2014", "Malaysian Grand Prix");
INSERT INTO "races" VALUES ("115", "2014", "Bahrain Grand Prix");
INSERT INTO "races" VALUES ("116", "2014", "Chinese Grand Prix");
INSERT INTO "races" VALUES ("117", "2014", "Spanish Grand Prix");
INSERT INTO "races" VALUES ("118", "2014", "Monaco Grand Prix");
INSERT INTO "races" VALUES ("119", "2014", "Canadian Grand Prix");
INSERT INTO "races" VALUES ("120", "2014", "Austrian Grand Prix");
INSERT INTO "races" VALUES ("121", "2014", "British Grand Prix");
INSERT INTO "races" VALUES ("122", "2014", "German Grand Prix");
INSERT INTO "races" VALUES ("123", "2014", "Hungarian Grand Prix");
INSERT INTO "races" VALUES ("124", "2014", "Belgian Grand Prix");
INSERT INTO "races" VALUES ("125", "2014", "Italian Grand Prix");
INSERT INTO "races" VALUES ("126", "2014", "Singapore Grand Prix");
INSERT INTO "races" VALUES ("127", "2014", "Japanese Grand Prix");
INSERT INTO "races" VALUES ("128", "2014", "Russian Grand Prix");
INSERT INTO "races" VALUES ("129", "2014", "United States Grand Prix");
INSERT INTO "races" VALUES ("130", "2014", "Brazilian Grand Prix");
INSERT INTO "races" VALUES ("131", "2014", "Abu Dhabi Grand Prix");
INSERT INTO "races" VALUES ("132", "2015", "Australian Grand Prix");
INSERT INTO "races" VALUES ("133", "2015", "Malaysian Grand Prix");
INSERT INTO "races" VALUES ("134", "2015", "Chinese Grand Prix");
INSERT INTO "races" VALUES ("135", "2015", "Bahrain Grand Prix");
INSERT INTO "races" VALUES ("136", "2015", "Spanish Grand Prix");
INSERT INTO "races" VALUES ("137", "2015", "Monaco Grand Prix");
INSERT INTO "races" VALUES ("138", "2015", "Canadian Grand Prix");
INSERT INTO "races" VALUES ("139", "2015", "Austrian Grand Prix");
INSERT INTO "races" VALUES ("140", "2015", "British Grand Prix");
INSERT INTO "races" VALUES ("141", "2015", "Hungarian Grand Prix");
INSERT INTO "races" VALUES ("142", "2015", "Belgian Grand Prix");
INSERT INTO "races" VALUES ("143", "2015", "Italian Grand Prix");
INSERT INTO "races" VALUES ("144", "2015", "Singapore Grand Prix");
INSERT INTO "races" VALUES ("145", "2015", "Japanese Grand Prix");
INSERT INTO "races" VALUES ("146", "2015", "Russian Grand Prix");
INSERT INTO "races" VALUES ("147", "2015", "United States Grand Prix");
INSERT INTO "races" VALUES ("148", "2015", "Mexican Grand Prix");
INSERT INTO "races" VALUES ("149", "2015", "Brazilian Grand Prix");
INSERT INTO "races" VALUES ("150", "2015", "Abu Dhabi Grand Prix");
INSERT INTO "races" VALUES ("151", "2016", "Australian Grand Prix");
INSERT INTO "races" VALUES ("152", "2016", "Bahrain Grand Prix");
INSERT INTO "races" VALUES ("153", "2016", "Chinese Grand Prix");
INSERT INTO "races" VALUES ("154", "2016", "Russian Grand Prix");
INSERT INTO "races" VALUES ("155", "2016", "Spanish Grand Prix");
INSERT INTO "races" VALUES ("156", "2016", "Monaco Grand Prix");
INSERT INTO "races" VALUES ("157", "2016", "Canadian Grand Prix");
INSERT INTO "races" VALUES ("158", "2016", "European Grand Prix");
INSERT INTO "races" VALUES ("159", "2016", "Austrian Grand Prix");
INSERT INTO "races" VALUES ("160", "2016", "British Grand Prix");
INSERT INTO "races" VALUES ("161", "2016", "Hungarian Grand Prix");
INSERT INTO "races" VALUES ("162", "2016", "German Grand Prix");
INSERT INTO "races" VALUES ("163", "2016", "Belgian Grand Prix");
INSERT INTO "races" VALUES ("164", "2016", "Italian Grand Prix");
INSERT INTO "races" VALUES ("165", "2016", "Singapore Grand Prix");
INSERT INTO "races" VALUES ("166", "2016", "Malaysian Grand Prix");
INSERT INTO "races" VALUES ("167", "2016", "Japanese Grand Prix");
INSERT INTO "races" VALUES ("168", "2016", "United States Grand Prix");
INSERT INTO "races" VALUES ("169", "2016", "Mexican Grand Prix");
INSERT INTO "races" VALUES ("170", "2016", "Brazilian Grand Prix");
INSERT INTO "races" VALUES ("171", "2016", "Abu Dhabi Grand Prix");
INSERT INTO "races" VALUES ("172", "2017", "Australian Grand Prix");
INSERT INTO "races" VALUES ("173", "2017", "Chinese Grand Prix");
INSERT INTO "races" VALUES ("174", "2017", "Bahrain Grand Prix");
INSERT INTO "races" VALUES ("175", "2017", "Russian Grand Prix");
INSERT INTO "races" VALUES ("176", "2017", "Spanish Grand Prix");
INSERT INTO "races" VALUES ("177", "2017", "Monaco Grand Prix");
INSERT INTO "races" VALUES ("178", "2017", "Canadian Grand Prix");
INSERT INTO "races" VALUES ("179", "2017", "Azerbaijan Grand Prix");
INSERT INTO "races" VALUES ("180", "2017", "Austrian Grand Prix");
INSERT INTO "races" VALUES ("181", "2017", "British Grand Prix");
INSERT INTO "races" VALUES ("182", "2017", "Hungarian Grand Prix");
INSERT INTO "races" VALUES ("183", "2017", "Belgian Grand Prix");
INSERT INTO "races" VALUES ("184", "2017", "Italian Grand Prix");
INSERT INTO "races" VALUES ("185", "2017", "Singapore Grand Prix");
INSERT INTO "races" VALUES ("186", "2017", "Malaysian Grand Prix");
INSERT INTO "races" VALUES ("187", "2017", "Japanese Grand Prix");
INSERT INTO "races" VALUES ("188", "2017", "United States Grand Prix");
INSERT INTO "races" VALUES ("189", "2017", "Mexican Grand Prix");
INSERT INTO "races" VALUES ("190", "2017", "Brazilian Grand Prix");
INSERT INTO "races" VALUES ("191", "2017", "Abu Dhabi Grand Prix");
INSERT INTO "races" VALUES ("192", "2018", "Australian Grand Prix");
INSERT INTO "races" VALUES ("193", "2018", "Bahrain Grand Prix");
INSERT INTO "races" VALUES ("194", "2018", "Chinese Grand Prix");
INSERT INTO "races" VALUES ("195", "2018", "Azerbaijan Grand Prix");
INSERT INTO "races" VALUES ("196", "2018", "Spanish Grand Prix");
INSERT INTO "races" VALUES ("197", "2018", "Monaco Grand Prix");
INSERT INTO "races" VALUES ("198", "2018", "Canadian Grand Prix");
INSERT INTO "races" VALUES ("199", "2018", "French Grand Prix");
INSERT INTO "races" VALUES ("200", "2018", "Austrian Grand Prix");
INSERT INTO "races" VALUES ("201", "2018", "British Grand Prix");
INSERT INTO "races" VALUES ("202", "2018", "German Grand Prix");
INSERT INTO "races" VALUES ("203", "2018", "Hungarian Grand Prix");
INSERT INTO "races" VALUES ("204", "2018", "Belgian Grand Prix");
INSERT INTO "races" VALUES ("205", "2018", "Italian Grand Prix");
INSERT INTO "races" VALUES ("206", "2018", "Singapore Grand Prix");
INSERT INTO "races" VALUES ("207", "2018", "Russian Grand Prix");
INSERT INTO "races" VALUES ("208", "2018", "Japanese Grand Prix");
INSERT INTO "races" VALUES ("209", "2018", "United States Grand Prix");
INSERT INTO "races" VALUES ("210", "2018", "Mexican Grand Prix");
INSERT INTO "races" VALUES ("211", "2018", "Brazilian Grand Prix");
INSERT INTO "races" VALUES ("212", "2018", "Abu Dhabi Grand Prix");
INSERT INTO "races" VALUES ("213", "2019", "Australian Grand Prix");
INSERT INTO "races" VALUES ("214", "2019", "Bahrain Grand Prix");
INSERT INTO "races" VALUES ("215", "2019", "Chinese Grand Prix");
INSERT INTO "races" VALUES ("216", "2019", "Azerbaijan Grand Prix");
INSERT INTO "races" VALUES ("217", "2019", "Spanish Grand Prix");
INSERT INTO "races" VALUES ("218", "2019", "Monaco Grand Prix");
INSERT INTO "races" VALUES ("219", "2019", "Canadian Grand Prix");
INSERT INTO "races" VALUES ("220", "2019", "French Grand Prix");
INSERT INTO "races" VALUES ("221", "2019", "Austrian Grand Prix");