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 "drivers" (
"driverId" INT,
"driverRef" TEXT,
"code" TEXT,
"forename" TEXT,
"surname" TEXT,
"nationality" TEXT,
PRIMARY KEY ("driverId")
);



INSERT INTO "drivers" VALUES ("1", "hamilton", "HAM", "Lewis", "Hamilton", "British");
INSERT INTO "drivers" VALUES ("2", "alonso", "ALO", "Fernando", "Alonso", "Spanish");
INSERT INTO "drivers" VALUES ("3", "vettel", "VET", "Sebastian", "Vettel", "German");
INSERT INTO "drivers" VALUES ("4", "raikkonen", "RAI", "Kimi", "Räikkönen", "Finnish");
INSERT INTO "drivers" VALUES ("5", "massa", "MAS", "Felipe", "Massa", "Brazilian");
INSERT INTO "drivers" VALUES ("6", "ricciardo", "RIC", "Daniel", "Ricciardo", "Australian");
INSERT INTO "drivers" VALUES ("7", "verstappen", "VER", "Max", "Verstappen", "Dutch");
INSERT INTO "drivers" VALUES ("8", "bottas", "BOT", "Valtteri", "Bottas", "Finnish");
INSERT INTO "drivers" VALUES ("9", "leclerc", "LEC", "Charles", "Leclerc", "Monegasque");
INSERT INTO "drivers" VALUES ("10", "sainz", "SAI", "Carlos", "Sainz", "Spanish");
INSERT INTO "drivers" VALUES ("11", "giovinazzi", "GIO", "Antonio", "Giovinazzi", "italian");
INSERT INTO "drivers" VALUES ("12", "fisichella", "FIS", "Giancarlo", "Fisichella", "italian");
INSERT INTO "drivers" VALUES ("13", "trulli", "TRU", "Jarno", "Trulli", "italian");
INSERT INTO "drivers" VALUES ("14", "liuzzi", "LIU", "Vitantonio", "Liuzzi", "italian");
INSERT INTO "drivers" VALUES ("15", "webber", "WEB", "Mark", "Webber", "Australian");
INSERT INTO "drivers" VALUES ("16", "rosberg", "ROS", "Nico", "Rosberg", "German");
INSERT INTO "drivers" VALUES ("17", "kubica", "KUB", "Robert", "Kubica", "Polish");
INSERT INTO "drivers" VALUES ("18", "button", "BUT", "Jenson", "Button", "British");
INSERT INTO "drivers" VALUES ("19", "perez", "PER", "Sergio", "Pérez", "Mexican");
INSERT INTO "drivers" VALUES ("20", "ocon", "OCO", "Esteban", "Ocon", "French");