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,
"concert_Name" TEXT,
"Theme" TEXT,
"Stadium_ID" TEXT,
PRIMARY KEY ("concert_ID"),
FOREIGN KEY ("Stadium_ID") REFERENCES "stadium"("Stadium_ID")
);

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





INSERT INTO "stadium" VALUES ("1", "Wembley Stadium", "90000");
INSERT INTO "stadium" VALUES ("2", "Camp Nou", "99354");
INSERT INTO "stadium" VALUES ("3", "Santiago Bernabeu", "81044");
INSERT INTO "stadium" VALUES ("4", "Old Trafford", "74879");
INSERT INTO "stadium" VALUES ("5", "Allianz Arena", "75000");
INSERT INTO "stadium" VALUES ("6", "Anfield", "54074");
INSERT INTO "stadium" VALUES ("7", "San Siro", "80018");
INSERT INTO "stadium" VALUES ("8", "Estadio Azteca", "87523");
INSERT INTO "stadium" VALUES ("9", "Rose Bowl", "92542");
INSERT INTO "stadium" VALUES ("10", "MetLife Stadium", "82500");
INSERT INTO "concert" VALUES ("1", "Summer Fest", "Pop Extravaganza", "2");
INSERT INTO "concert" VALUES ("2", "Rock Mania", "Classic Rock Hits", "1");
INSERT INTO "concert" VALUES ("3", "Global Rhythms", "World Music Showcase", "2");
INSERT INTO "concert" VALUES ("4", "Jazz Night", "Smooth Jazz Melodies", "3");
INSERT INTO "concert" VALUES ("5", "Country Jamboree", "Nashville Stars", "4");
INSERT INTO "concert" VALUES ("6", "Electronic Beats", "EDM Festival", "2");
INSERT INTO "concert" VALUES ("7", "Acoustic Sessions", "Unplugged Performances", "5");
INSERT INTO "concert" VALUES ("8", "Hip Hop Nation", "Rap Battle Royale", "2");
INSERT INTO "concert" VALUES ("9", "Classical Gala", "Orchestral Masterpieces", "6");
INSERT INTO "concert" VALUES ("10", "Indie Fest", "Alternative Sounds", "7");
INSERT INTO "concert" VALUES ("11", "Pop Explosion", "Top 40 Hits", "2");
INSERT INTO "concert" VALUES ("12", "Metal Mayhem", "Heavy Metal Concert", "8");
INSERT INTO "concert" VALUES ("13", "Blues Bash", "Soulful Blues", "9");
INSERT INTO "concert" VALUES ("14", "Reggae Vibes", "Island Rhythms", "10");
INSERT INTO "concert" VALUES ("15", "Latin Fiesta", "Salsa and Merengue", "2");
INSERT INTO "concert" VALUES ("16", "Folk Fusion", "Traditional and Modern Folk", "1");
INSERT INTO "concert" VALUES ("17", "Gospel Celebration", "Inspirational Music", "2");