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 "conductor" (
"Conductor_ID" INT,
"Name" TEXT,
"Nationality" TEXT,
PRIMARY KEY ("Conductor_ID")
);

CREATE TABLE "orchestra" (
"Orchestra_ID" INT,
"Orchestra" TEXT,
"Record_Company" TEXT,
PRIMARY KEY ("Orchestra_ID")
);

CREATE TABLE "performance" (
"Performance_ID" INT,
"Type" TEXT,
PRIMARY KEY ("Performance_ID")
);





INSERT INTO "conductor" VALUES ("1", "Ludwig van Beethoven", "German");
INSERT INTO "conductor" VALUES ("2", "Leonard Bernstein", "USA");
INSERT INTO "conductor" VALUES ("3", "Gustavo Dudamel", "Venezuelan");
INSERT INTO "conductor" VALUES ("4", "Marin Alsop", "USA");
INSERT INTO "conductor" VALUES ("5", "Riccardo Muti", "Italian");
INSERT INTO "conductor" VALUES ("6", "Valery Gergiev", "Russian");
INSERT INTO "conductor" VALUES ("7", "Seiji Ozawa", "Japanese");
INSERT INTO "conductor" VALUES ("8", "Claudio Abbado", "Italian");
INSERT INTO "conductor" VALUES ("9", "Daniel Barenboim", "Argentinian/Israeli");
INSERT INTO "conductor" VALUES ("10", "Esa-Pekka Salonen", "Finnish");
INSERT INTO "conductor" VALUES ("11", "John Williams", "USA");
INSERT INTO "conductor" VALUES ("12", "Mariss Jansons", "Latvian");
INSERT INTO "conductor" VALUES ("13", "Zubin Mehta", "Indian");
INSERT INTO "conductor" VALUES ("14", "Pierre Boulez", "NULL");
INSERT INTO "conductor" VALUES ("15", "Carlos Kleiber", "Austrian/German");