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", "Los Angeles, USA", "Sunset Dome", "9999");
INSERT INTO "stadium" VALUES ("3", "London, UK", "Thames Stadium", "10000");
INSERT INTO "stadium" VALUES ("4", "Berlin, Germany", "Brandenburg Field", "7500");
INSERT INTO "stadium" VALUES ("5", "Tokyo, Japan", "Sakura Park", "5001");
INSERT INTO "stadium" VALUES ("6", "Sydney, Australia", "Harbor Grounds", "4999");
INSERT INTO "stadium" VALUES ("7", "Cape Town, South Africa", "Table Mountain Arena", "10001");
INSERT INTO "stadium" VALUES ("8", "Rio de Janeiro, Brazil", "Copacabana Stadium", "8000");
INSERT INTO "stadium" VALUES ("9", "Moscow, Russia", "Red Square Stadium", "6000");
INSERT INTO "stadium" VALUES ("10", "Toronto, Canada", "Maple Leaf Field", "100");
INSERT INTO "stadium" VALUES ("11", "Paris, France", "Eiffel Grounds", "5200");
INSERT INTO "stadium" VALUES ("12", "Dubai, UAE", "Desert Arena", "9800");
INSERT INTO "stadium" VALUES ("13", "Mumbai, India", "Gateway Stadium", "4998");
INSERT INTO "stadium" VALUES ("14", "Mexico City, Mexico", "Aztec Field", "7000");
INSERT INTO "stadium" VALUES ("15", "Seoul, South Korea", "Han River Stadium", "10002");
INSERT INTO "concert" VALUES ("1", "Rock Fest", "2019");
INSERT INTO "concert" VALUES ("2", "Jazz Nights", "2020");
INSERT INTO "concert" VALUES ("3", "Pop Gala", "2021");
INSERT INTO "singer" VALUES ("1", "USA");
INSERT INTO "singer" VALUES ("2", "UK");
INSERT INTO "singer" VALUES ("3", "Japan");
INSERT INTO "singer" VALUES ("4", "Brazil");
INSERT INTO "singer" VALUES ("5", "Germany");