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 "races" (
"raceId" INT,
"year" INT,
"round" INT,
"circuitId" INT,
"name" TEXT,
"date" DATE,
PRIMARY KEY ("raceId")
);



INSERT INTO "races" VALUES ("1", "2017", "1", "1", "Australian Grand Prix", "2017-03-26");
INSERT INTO "races" VALUES ("2", "2017", "2", "2", "Chinese Grand Prix", "2017-04-09");
INSERT INTO "races" VALUES ("3", "2017", "3", "3", "Bahrain Grand Prix", "2017-04-16");
INSERT INTO "races" VALUES ("4", "2017", "4", "4", "Russian Grand Prix", "2017-04-30");
INSERT INTO "races" VALUES ("5", "2017", "5", "5", "Spanish Grand Prix", "2017-05-14");
INSERT INTO "races" VALUES ("6", "2000", "1", "1", "Australian Grand Prix", "2000-03-12");
INSERT INTO "races" VALUES ("7", "2000", "2", "6", "Brazilian Grand Prix", "2000-03-26");
INSERT INTO "races" VALUES ("8", "2000", "3", "7", "San Marino Grand Prix", "2000-04-09");
INSERT INTO "races" VALUES ("9", "2017", "6", "8", "Monaco Grand Prix", "2017-05-28");
INSERT INTO "races" VALUES ("10", "2000", "4", "8", "Monaco Grand Prix", "2000-06-04");
INSERT INTO "races" VALUES ("11", "2017", "7", "9", "Canadian Grand Prix", "2017-06-11");
INSERT INTO "races" VALUES ("12", "2000", "5", "9", "Canadian Grand Prix", "2000-06-18");
INSERT INTO "races" VALUES ("13", "2017", "8", "10", "Azerbaijan Grand Prix", "2017-06-25");
INSERT INTO "races" VALUES ("14", "2000", "6", "11", "French Grand Prix", "2000-07-02");
INSERT INTO "races" VALUES ("15", "2017", "9", "12", "Austrian Grand Prix", "2017-07-09");
INSERT INTO "races" VALUES ("16", "2000", "7", "12", "Austrian Grand Prix", "2000-07-16");
INSERT INTO "races" VALUES ("17", "2017", "10", "13", "British Grand Prix", "2017-07-16");
INSERT INTO "races" VALUES ("18", "2000", "8", "13", "British Grand Prix", "2000-07-23");
INSERT INTO "races" VALUES ("19", "2017", "11", "14", "Hungarian Grand Prix", "2017-07-30");
INSERT INTO "races" VALUES ("20", "2000", "9", "14", "Hungarian Grand Prix", "2000-08-13");
INSERT INTO "races" VALUES ("21", "2017", "12", "15", "Belgian Grand Prix", "2017-08-27");
INSERT INTO "races" VALUES ("22", "2000", "10", "15", "Belgian Grand Prix", "2000-08-27");
INSERT INTO "races" VALUES ("23", "2017", "13", "16", "Italian Grand Prix", "2017-09-03");
INSERT INTO "races" VALUES ("24", "2000", "11", "16", "Italian Grand Prix", "2000-09-10");
INSERT INTO "races" VALUES ("25", "2017", "14", "17", "Singapore Grand Prix", "2017-09-17");
INSERT INTO "races" VALUES ("26", "2000", "12", "18", "United States Grand Prix", "2000-09-24");
INSERT INTO "races" VALUES ("27", "2017", "15", "19", "Malaysian Grand Prix", "2017-10-01");
INSERT INTO "races" VALUES ("28", "2000", "13", "19", "Malaysian Grand Prix", "2000-10-08");
INSERT INTO "races" VALUES ("29", "2017", "16", "20", "Japanese Grand Prix", "2017-10-08");
INSERT INTO "races" VALUES ("30", "2000", "14", "20", "Japanese Grand Prix", "2000-10-08");
INSERT INTO "races" VALUES ("31", "2017", "17", "21", "United States Grand Prix", "2017-10-22");
INSERT INTO "races" VALUES ("32", "2000", "15", "22", "Japanese Grand Prix", "2000-10-22");
INSERT INTO "races" VALUES ("33", "2017", "18", "23", "Mexican Grand Prix", "2017-10-29");
INSERT INTO "races" VALUES ("34", "2000", "16", "23", "Mexican Grand Prix", "2000-10-29");
INSERT INTO "races" VALUES ("35", "2017", "19", "24", "Brazilian Grand Prix", "2017-11-12");
INSERT INTO "races" VALUES ("36", "2000", "17", "24", "Brazilian Grand Prix", "2000-11-12");
INSERT INTO "races" VALUES ("37", "2017", "20", "25", "Abu Dhabi Grand Prix", "2017-11-26");
INSERT INTO "races" VALUES ("38", "2000", "18", "25", "Abu Dhabi Grand Prix", "2000-11-26");
INSERT INTO "races" VALUES ("39", "2016", "1", "1", "Australian Grand Prix", "2016-03-20");
INSERT INTO "races" VALUES ("40", "2018", "1", "1", "Australian Grand Prix", "2018-03-25");