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 Music", "CD");
INSERT INTO "orchestra" VALUES ("2", "Universal Music Group", "Vinyl");
INSERT INTO "orchestra" VALUES ("3", "Warner Music Group", "Digital");
INSERT INTO "orchestra" VALUES ("4", "Sony Music", "CD");
INSERT INTO "orchestra" VALUES ("5", "Universal Music Group", "Digital");
INSERT INTO "orchestra" VALUES ("6", "Warner Music Group", "Vinyl");
INSERT INTO "orchestra" VALUES ("7", "Independent Label", "CD");
INSERT INTO "orchestra" VALUES ("8", "Independent Label", "Digital");
INSERT INTO "orchestra" VALUES ("9", "Sony Music", "Vinyl");
INSERT INTO "orchestra" VALUES ("10", "Universal Music Group", "CD");
INSERT INTO "orchestra" VALUES ("11", "Warner Music Group", "Digital");
INSERT INTO "orchestra" VALUES ("12", "Independent Label", "CD");
INSERT INTO "performance" VALUES ("1", "Concert", "2.5");
INSERT INTO "performance" VALUES ("2", "Studio Recording", "1.8");
INSERT INTO "performance" VALUES ("3", "Live Stream", "3.1");
INSERT INTO "performance" VALUES ("4", "Concert", "2.0");
INSERT INTO "performance" VALUES ("5", "Studio Recording", "1.5");
INSERT INTO "performance" VALUES ("6", "Live Stream", "2.9");
INSERT INTO "performance" VALUES ("7", "Concert", "2.7");
INSERT INTO "performance" VALUES ("8", "Studio Recording", "1.9");
INSERT INTO "performance" VALUES ("9", "Live Stream", "3.5");
INSERT INTO "performance" VALUES ("10", "Concert", "2.2");
INSERT INTO "performance" VALUES ("11", "Studio Recording", "1.6");
INSERT INTO "performance" VALUES ("12", "Live Stream", "3.0");