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 "stadium" (
"Stadium_ID" INT,
"Capacity" INT,
"Highest" INT,
"Lowest" INT,
"Average" INT,
PRIMARY KEY ("Stadium_ID")
);





INSERT INTO "stadium" VALUES ("1", "10000", "9000", "5000", "7000");
INSERT INTO "stadium" VALUES ("2", "15000", "14000", "8000", "11000");
INSERT INTO "stadium" VALUES ("3", "5000", "4500", "2000", "3000");
INSERT INTO "stadium" VALUES ("4", "20000", "18000", "10000", "14000");
INSERT INTO "stadium" VALUES ("5", "8000", "7500", "4000", "5500");
INSERT INTO "stadium" VALUES ("6", "12000", "11000", "6000", "8500");
INSERT INTO "stadium" VALUES ("7", "3000", "2800", "1500", "2000");
INSERT INTO "stadium" VALUES ("8", "25000", "23000", "12000", "17000");
INSERT INTO "stadium" VALUES ("9", "7000", "6500", "3500", "4800");
INSERT INTO "stadium" VALUES ("10", "18000", "17000", "9000", "13000");