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,
"Share" TEXT,
PRIMARY KEY ("Performance_ID")
);

CREATE TABLE "show" (
"Result" TEXT
);





INSERT INTO "performance" VALUES ("1", "Live show", "8.5", "1", "25.0");
INSERT INTO "performance" VALUES ("2", "Semi-final", "7.2", "2", "22.5");
INSERT INTO "performance" VALUES ("3", "Auditions", "6.8", "3", "20.0");
INSERT INTO "performance" VALUES ("4", "Live final", "9.1", "1", "28.0");
INSERT INTO "performance" VALUES ("5", "Live show", "7.5", "2", "23.0");
INSERT INTO "performance" VALUES ("6", "Auditions", "6.5", "4", "19.5");
INSERT INTO "performance" VALUES ("7", "Semi-final", "7.0", "3", "21.0");
INSERT INTO "performance" VALUES ("8", "Live final", "9.5", "1", "30.0");
INSERT INTO "performance" VALUES ("9", "Live show", "8.0", "2", "24.0");
INSERT INTO "performance" VALUES ("10", "Auditions", "6.0", "5", "18.0");
INSERT INTO "show" VALUES ("Success");
INSERT INTO "show" VALUES ("Failure");
INSERT INTO "show" VALUES ("Moderate");