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

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





INSERT INTO "stadium" VALUES ("1", "London", "Wembley Stadium", "90000");
INSERT INTO "stadium" VALUES ("2", "Manchester", "Old Trafford", "74000");
INSERT INTO "stadium" VALUES ("3", "Liverpool", "Anfield", "54000");
INSERT INTO "stadium" VALUES ("4", "Glasgow", "Hampden Park", "52000");
INSERT INTO "stadium" VALUES ("5", "Cardiff", "Principality Stadium", "74500");
INSERT INTO "stadium" VALUES ("6", "Dublin", "Croke Park", "82300");
INSERT INTO "stadium" VALUES ("7", "Edinburgh", "Murrayfield Stadium", "67000");
INSERT INTO "stadium" VALUES ("8", "Birmingham", "Villa Park", "42000");
INSERT INTO "stadium" VALUES ("9", "Newcastle", "St James' Park", "52000");
INSERT INTO "stadium" VALUES ("10", "Bristol", "Ashton Gate", "27000");
INSERT INTO "concert" VALUES ("1", "Summer Fest", "Pop Hits", "1", "2014");
INSERT INTO "concert" VALUES ("2", "Rock Mania", "Classic Rock", "2", "2014");
INSERT INTO "concert" VALUES ("3", "Pop Explosion", "Top 40", "1", "2015");
INSERT INTO "concert" VALUES ("4", "Jazz Night", "Smooth Jazz", "3", "2014");
INSERT INTO "concert" VALUES ("5", "Country Jamboree", "Nashville Stars", "4", "2015");
INSERT INTO "concert" VALUES ("6", "Electronic Beats", "EDM Festival", "2", "2015");
INSERT INTO "concert" VALUES ("7", "Blues Bash", "Delta Blues", "5", "2014");
INSERT INTO "concert" VALUES ("8", "World Music Gala", "Global Rhythms", "6", "2015");
INSERT INTO "concert" VALUES ("9", "Indie Showcase", "Alternative Sounds", "7", "2014");
INSERT INTO "concert" VALUES ("10", "Classical Serenade", "Orchestral Masterpieces", "8", "2015");
INSERT INTO "concert" VALUES ("11", "Hip Hop Summit", "Rap Legends", "1", "2016");
INSERT INTO "concert" VALUES ("12", "Reggae Fest", "Island Vibes", "2", "2013");
INSERT INTO "concert" VALUES ("13", "Folk Festival", "Acoustic Tunes", "3", "2015");
INSERT INTO "concert" VALUES ("14", "Metal Mayhem", "Heavy Riffs", "4", "2014");
INSERT INTO "concert" VALUES ("15", "Soul Sessions", "R&B Grooves", "5", "2015");
INSERT INTO "concert" VALUES ("16", "Gospel Gathering", "Inspirational Songs", "6", "2014");
INSERT INTO "concert" VALUES ("17", "Punk Rock Riot", "Anarchy Anthems", "7", "2015");
INSERT INTO "concert" VALUES ("18", "Disco Fever", "70s Dance", "8", "2014");
INSERT INTO "concert" VALUES ("19", "New Wave Night", "80s Synth", "9", "2015");
INSERT INTO "concert" VALUES ("20", "Techno Rave", "Underground Beats", "10", "2014");
INSERT INTO "concert" VALUES ("21", "Pop Revival", "90s Nostalgia", "1", "2014");
INSERT INTO "concert" VALUES ("22", "Rock Legends", "Greatest Hits", "1", "2015");
INSERT INTO "concert" VALUES ("23", "Jazz Fusion", "Modern Jazz", "3", "2015");
INSERT INTO "concert" VALUES ("24", "Country Crossover", "Pop-Country", "4", "2014");
INSERT INTO "concert" VALUES ("25", "Electronic Dance", "Trance & House", "2", "2014");
INSERT INTO "concert" VALUES ("26", "Blues Revival", "Contemporary Blues", "5", "2015");
INSERT INTO "concert" VALUES ("27", "World Fusion", "Cross-Cultural", "6", "2014");
INSERT INTO "concert" VALUES ("28", "Indie Pop", "Catchy Tunes", "7", "2015");
INSERT INTO "concert" VALUES ("29", "Classical Crossover", "Modern Classics", "8", "2014");
INSERT INTO "concert" VALUES ("30", "Hip Hop Old School", "Golden Era", "9", "2014");
INSERT INTO "concert" VALUES ("31", "Reggae Roots", "Authentic Reggae", "10", "2015");