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.5");
INSERT INTO "performance" VALUES ("2", "Live show", "7.2", "2", "22.1");
INSERT INTO "performance" VALUES ("3", "Semi-final", "6.8", "3", "20.3");
INSERT INTO "performance" VALUES ("4", "Semi-final", "6.5", "4", "19.8");
INSERT INTO "performance" VALUES ("5", "Live final", "9.1", "1", "28.0");
INSERT INTO "performance" VALUES ("6", "Live show", "7.0", "3", "21.5");
INSERT INTO "performance" VALUES ("7", "Semi-final", "6.0", "5", "18.0");
INSERT INTO "performance" VALUES ("8", "Live show", "7.5", "2", "23.0");
INSERT INTO "performance" VALUES ("9", "Live final", "9.5", "1", "29.5");
INSERT INTO "performance" VALUES ("10", "Live show", "6.9", "4", "20.0");
INSERT INTO "performance" VALUES ("11", "Semi-final", "5.8", "6", "17.5");
INSERT INTO "performance" VALUES ("12", "Live show", "7.1", "3", "22.0");
INSERT INTO "performance" VALUES ("13", "Live final", "8.8", "2", "27.0");
INSERT INTO "performance" VALUES ("14", "Live show", "6.7", "5", "19.5");
INSERT INTO "performance" VALUES ("15", "Semi-final", "5.5", "7", "16.0");
INSERT INTO "show" VALUES ("Winner Announced");
INSERT INTO "show" VALUES ("Top 3 Revealed");
INSERT INTO "show" VALUES ("Elimination");
INSERT INTO "show" VALUES ("Judges' Choice");
INSERT INTO "show" VALUES ("Audience Vote");