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

CREATE TABLE "singer" (
"Singer_ID" INT,
"Country" TEXT,
PRIMARY KEY ("Singer_ID")
);

CREATE TABLE "stadium" (
"Stadium_ID" INT,
"Location" TEXT,
"Name" TEXT,
"Capacity" INT,
PRIMARY KEY ("Stadium_ID")
);





INSERT INTO "stadium" VALUES ("1", "New York, USA", "Liberty Arena", "5000");
INSERT INTO "stadium" VALUES ("2", "London, UK", "Royal Grounds", "7500");
INSERT INTO "stadium" VALUES ("3", "Berlin, Germany", "Olympic Stadium", "10000");
INSERT INTO "stadium" VALUES ("4", "Tokyo, Japan", "Sakura Dome", "9999");
INSERT INTO "stadium" VALUES ("5", "Sydney, Australia", "Harbor Field", "5001");
INSERT INTO "stadium" VALUES ("6", "Toronto, Canada", "Maple Leaf Park", "6000");
INSERT INTO "stadium" VALUES ("7", "Paris, France", "Eiffel Arena", "8000");
INSERT INTO "stadium" VALUES ("8", "Moscow, Russia", "Red Square Stadium", "10001");
INSERT INTO "stadium" VALUES ("9", "Rio de Janeiro, Brazil", "Copacabana Grounds", "4999");
INSERT INTO "stadium" VALUES ("10", "Cape Town, South Africa", "Table Mountain Arena", "7000");
INSERT INTO "stadium" VALUES ("11", "Dubai, UAE", "Desert Dome", "10000");
INSERT INTO "stadium" VALUES ("12", "Seoul, South Korea", "Han River Stadium", "5000");
INSERT INTO "stadium" VALUES ("13", "Mexico City, Mexico", "Aztec Arena", "8500");
INSERT INTO "stadium" VALUES ("14", "Rome, Italy", "Colosseum Field", "5200");
INSERT INTO "stadium" VALUES ("15", "Los Angeles, USA", "Sunset Stadium", "10000");