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 "concert" (
"concert_ID" INT,
"Year" TEXT,
PRIMARY KEY ("concert_ID")
);

CREATE TABLE "stadium" (
"Stadium_ID" INT,
"Capacity" INT,
"Highest" INT,
"Average" INT,
PRIMARY KEY ("Stadium_ID")
);





INSERT INTO "concert" VALUES ("1", "2014");
INSERT INTO "concert" VALUES ("2", "2015");
INSERT INTO "concert" VALUES ("3", "2016");
INSERT INTO "concert" VALUES ("4", "2017");
INSERT INTO "concert" VALUES ("5", "2018");
INSERT INTO "stadium" VALUES ("1", "50000", "75000", "45000");
INSERT INTO "stadium" VALUES ("2", "30000", "35000", "28000");
INSERT INTO "stadium" VALUES ("3", "15000", "20000", "14000");
INSERT INTO "stadium" VALUES ("4", "10000", "12000", "9000");
INSERT INTO "stadium" VALUES ("5", "8000", "9000", "7000");
INSERT INTO "stadium" VALUES ("6", "20000", "25000", "18000");
INSERT INTO "stadium" VALUES ("7", "45000", "60000", "40000");
INSERT INTO "stadium" VALUES ("8", "12000", "15000", "11000");
INSERT INTO "stadium" VALUES ("9", "6000", "7000", "5500");
INSERT INTO "stadium" VALUES ("10", "35000", "40000", "32000");