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 "orchestra" (
"Orchestra_ID" INT,
"Record_Company" TEXT,
"Major_Record_Format" TEXT,
PRIMARY KEY ("Orchestra_ID")
);

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





INSERT INTO "orchestra" VALUES ("1", "Sony Classical", "CD");
INSERT INTO "orchestra" VALUES ("2", "Deutsche Grammophon", "Vinyl");
INSERT INTO "orchestra" VALUES ("3", "Warner Classics", "Digital Download");
INSERT INTO "orchestra" VALUES ("4", "Decca Records", "CD");
INSERT INTO "orchestra" VALUES ("5", "Naxos", "Digital Download");
INSERT INTO "orchestra" VALUES ("6", "Harmonia Mundi", "CD");
INSERT INTO "orchestra" VALUES ("7", "Alpha Classics", "Vinyl");
INSERT INTO "orchestra" VALUES ("8", "Chandos Records", "CD");
INSERT INTO "orchestra" VALUES ("9", "Erato", "Digital Download");
INSERT INTO "orchestra" VALUES ("10", "Pentatone", "SACD");
INSERT INTO "orchestra" VALUES ("11", "BIS Records", "SACD");
INSERT INTO "orchestra" VALUES ("12", "Onyx Classics", "CD");
INSERT INTO "orchestra" VALUES ("13", "Linn Records", "Digital Download");
INSERT INTO "orchestra" VALUES ("14", "Hyperion Records", "CD");
INSERT INTO "orchestra" VALUES ("15", "ECM New Series", "CD");
INSERT INTO "performance" VALUES ("1", "Concert", "2.5");
INSERT INTO "performance" VALUES ("2", "Opera", "1.8");
INSERT INTO "performance" VALUES ("3", "Ballet", "0.9");
INSERT INTO "performance" VALUES ("4", "Symphony", "3.1");
INSERT INTO "performance" VALUES ("5", "Chamber Music", "0.7");
INSERT INTO "performance" VALUES ("6", "Recital", "0.5");
INSERT INTO "performance" VALUES ("7", "Festival", "4.2");
INSERT INTO "performance" VALUES ("8", "Live Stream", "1.5");
INSERT INTO "performance" VALUES ("9", "Recording Session", "0.3");
INSERT INTO "performance" VALUES ("10", "Masterclass", "0.2");