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", "74310");
INSERT INTO "stadium" VALUES ("5", "Allianz Arena", "75000");
INSERT INTO "stadium" VALUES ("6", "Anfield", "53394");
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", "Jazz Night", "Smooth Jazz", "3");
INSERT INTO "concert" VALUES ("4", "Global Beats", "World Music Fusion", "2");
INSERT INTO "concert" VALUES ("5", "Acoustic Sessions", "Unplugged Melodies", "4");
INSERT INTO "concert" VALUES ("6", "EDM Explosion", "Electronic Dance Party", "2");
INSERT INTO "concert" VALUES ("7", "Country Jamboree", "Nashville Stars", "5");
INSERT INTO "concert" VALUES ("8", "Hip Hop Summit", "Rhyme and Rhythm", "1");
INSERT INTO "concert" VALUES ("9", "Classical Gala", "Orchestral Masterpieces", "6");
INSERT INTO "concert" VALUES ("10", "Indie Fest", "Alternative Sounds", "2");
INSERT INTO "concert" VALUES ("11", "Blues Bash", "Soulful Harmonies", "7");
INSERT INTO "concert" VALUES ("12", "Reggae Roots", "Island Vibes", "2");
INSERT INTO "concert" VALUES ("13", "Metal Mayhem", "Heavy Riffs", "8");
INSERT INTO "concert" VALUES ("14", "Pop Revival", "90s Throwback", "2");
INSERT INTO "concert" VALUES ("15", "Folk Fusion", "Traditional Tunes", "9");
INSERT INTO "concert" VALUES ("16", "Gospel Celebration", "Inspirational Songs", "10");
INSERT INTO "concert" VALUES ("17", "Latin Rhythms", "Salsa and Merengue", "2");
INSERT INTO "concert" VALUES ("18", "Punk Rock Riot", "Rebellious Anthems", "1");
INSERT INTO "concert" VALUES ("19", "R&B Groove", "Smooth Vocals", "2");
INSERT INTO "concert" VALUES ("20", "World Tour Finale", "Grand Spectacle", "2");