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 "performance" (
"Performance_ID" INT,
"Type" TEXT,
"Official_ratings_(millions)" FLOAT,
"Weekly_rank" TEXT,
PRIMARY KEY ("Performance_ID")
);

CREATE TABLE "show" (
"Show_ID" INT,
"Attendance" FLOAT
);





INSERT INTO "performance" VALUES ("1", "Concert", "8.5", "1");
INSERT INTO "performance" VALUES ("2", "Play", "6.2", "3");
INSERT INTO "performance" VALUES ("3", "Opera", "9.1", "1");
INSERT INTO "performance" VALUES ("4", "Ballet", "7.8", "2");
INSERT INTO "performance" VALUES ("5", "Concert", "5.5", "5");
INSERT INTO "performance" VALUES ("6", "Play", "7.0", "2");
INSERT INTO "performance" VALUES ("7", "Opera", "8.0", "1");
INSERT INTO "performance" VALUES ("8", "Ballet", "6.5", "4");
INSERT INTO "performance" VALUES ("9", "Concert", "9.9", "1");
INSERT INTO "performance" VALUES ("10", "Play", "4.0", "7");
INSERT INTO "show" VALUES ("1", "1500.0");
INSERT INTO "show" VALUES ("2", "1200.0");
INSERT INTO "show" VALUES ("3", "2000.0");
INSERT INTO "show" VALUES ("4", "1800.0");
INSERT INTO "show" VALUES ("5", "1000.0");
INSERT INTO "show" VALUES ("6", "1350.0");
INSERT INTO "show" VALUES ("7", "1900.0");
INSERT INTO "show" VALUES ("8", "1100.0");
INSERT INTO "show" VALUES ("9", "2200.0");
INSERT INTO "show" VALUES ("10", "800.0");
INSERT INTO "show" VALUES ("11", "1600.0");
INSERT INTO "show" VALUES ("12", "1450.0");