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 "constructorStandings" (
"constructorStandingsId" INT,
"constructorId" INT,
PRIMARY KEY ("constructorStandingsId")
);

CREATE TABLE "driverStandings" (
"driverStandingsId" INT,
"driverId" INT,
PRIMARY KEY ("driverStandingsId")
);

CREATE TABLE "races" (
"raceId" INT UNIQUE,
"year" INT,
"round" INT,
PRIMARY KEY ("raceId")
);



INSERT INTO "constructorStandings" VALUES ("1", "101");
INSERT INTO "constructorStandings" VALUES ("2", "102");
INSERT INTO "constructorStandings" VALUES ("3", "103");
INSERT INTO "driverStandings" VALUES ("1", "201");
INSERT INTO "driverStandings" VALUES ("2", "202");
INSERT INTO "driverStandings" VALUES ("3", "203");
INSERT INTO "races" VALUES ("1", "2008", "1");
INSERT INTO "races" VALUES ("2", "2009", "1");
INSERT INTO "races" VALUES ("3", "2009", "2");
INSERT INTO "races" VALUES ("4", "2009", "3");
INSERT INTO "races" VALUES ("5", "2010", "1");
INSERT INTO "races" VALUES ("6", "2011", "1");
INSERT INTO "races" VALUES ("7", "2009", "4");
INSERT INTO "races" VALUES ("8", "2007", "1");
INSERT INTO "races" VALUES ("9", "2009", "5");
INSERT INTO "races" VALUES ("10", "2012", "1");