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", "42700");
INSERT INTO "stadium" VALUES ("9", "Newcastle", "St James' Park", "52300");
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", "2015");
INSERT INTO "concert" VALUES ("3", "Pop Explosion", "Top 40", "1", "2014");
INSERT INTO "concert" VALUES ("4", "Jazz Night", "Smooth Jazz", "3", "2016");
INSERT INTO "concert" VALUES ("5", "Country Jamboree", "Nashville Stars", "4", "2015");
INSERT INTO "concert" VALUES ("6", "EDM Rave", "Electronic Beats", "1", "2017");
INSERT INTO "concert" VALUES ("7", "Blues Festival", "Soulful Sounds", "5", "2014");
INSERT INTO "concert" VALUES ("8", "Indie Showcase", "Alternative Vibes", "2", "2018");
INSERT INTO "concert" VALUES ("9", "Classical Gala", "Orchestral Masterpieces", "6", "2019");
INSERT INTO "concert" VALUES ("10", "Hip Hop Summit", "Rhyme & Rhythm", "1", "2015");
INSERT INTO "concert" VALUES ("11", "Reggae Fest", "Island Rhythms", "7", "2014");
INSERT INTO "concert" VALUES ("12", "Metal Mayhem", "Heavy Riffs", "8", "2016");
INSERT INTO "concert" VALUES ("13", "Folk Gathering", "Acoustic Tunes", "9", "2017");
INSERT INTO "concert" VALUES ("14", "World Music Expo", "Global Sounds", "10", "2018");
INSERT INTO "concert" VALUES ("15", "Pop Extravaganza", "Chart Toppers", "1", "2016");
INSERT INTO "concert" VALUES ("16", "Rock Legends", "Iconic Bands", "2", "2017");
INSERT INTO "concert" VALUES ("17", "Jazz Fusion", "Modern Jazz", "3", "2018");
INSERT INTO "concert" VALUES ("18", "Country Roads", "New Country", "4", "2019");
INSERT INTO "concert" VALUES ("19", "Dance Party", "Club Anthems", "1", "2019");
INSERT INTO "concert" VALUES ("20", "Acoustic Sessions", "Unplugged", "5", "2015");
INSERT INTO "concert" VALUES ("21", "Blues & Brews", "Craft Beer & Blues", "6", "2016");
INSERT INTO "concert" VALUES ("22", "Indie Rock Fest", "Emerging Artists", "2", "2019");
INSERT INTO "concert" VALUES ("23", "Symphony Night", "Classical Classics", "7", "2017");
INSERT INTO "concert" VALUES ("24", "Rap Battle", "Freestyle", "1", "2018");
INSERT INTO "concert" VALUES ("25", "Global Rhythms", "Diverse Sounds", "8", "2019");
INSERT INTO "concert" VALUES ("26", "Pop Mania", "Latest Hits", "1", "2019");
INSERT INTO "concert" VALUES ("27", "Rock Revival", "80s Rock", "2", "2014");
INSERT INTO "concert" VALUES ("28", "Jazz in the Park", "Outdoor Jazz", "3", "2015");
INSERT INTO "concert" VALUES ("29", "Country Fest", "Big Names", "4", "2016");
INSERT INTO "concert" VALUES ("30", "Electronic Beats", "DJ Sets", "1", "2014");