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

CREATE TABLE "singer_in_concert" (
"concert_ID" INT,
"Singer_ID" TEXT,
PRIMARY KEY ("concert_ID", "Singer_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", "Madison Square Garden", "20000");
INSERT INTO "stadium" VALUES ("3", "Staples Center", "19000");
INSERT INTO "stadium" VALUES ("4", "O2 Arena", "20000");
INSERT INTO "stadium" VALUES ("5", "Red Rocks Amphitheatre", "9525");
INSERT INTO "stadium" VALUES ("6", "Sydney Opera House", "2679");
INSERT INTO "stadium" VALUES ("7", "Royal Albert Hall", "5272");
INSERT INTO "stadium" VALUES ("8", "Tokyo Dome", "55000");
INSERT INTO "stadium" VALUES ("9", "Allianz Arena", "75000");
INSERT INTO "stadium" VALUES ("10", "Camp Nou", "99354");
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", "Jazz Night", "Smooth Jazz", "3", "2016");
INSERT INTO "concert" VALUES ("4", "EDM Explosion", "Electronic Dance", "1", "2014");
INSERT INTO "concert" VALUES ("5", "Country Jamboree", "Nashville Stars", "5", "2017");
INSERT INTO "concert" VALUES ("6", "Classical Gala", "Orchestral Masterpieces", "6", "2018");
INSERT INTO "concert" VALUES ("7", "Pop Idol Show", "New Talents", "1", "2015");
INSERT INTO "concert" VALUES ("8", "Blues Festival", "Soulful Sounds", "2", "2016");
INSERT INTO "concert" VALUES ("9", "Hip Hop Summit", "Rap Battles", "3", "2017");
INSERT INTO "concert" VALUES ("10", "World Music Expo", "Global Rhythms", "4", "2018");
INSERT INTO "concert" VALUES ("11", "Indie Showcase", "Alternative Vibes", "1", "2019");
INSERT INTO "concert" VALUES ("12", "Metal Mayhem", "Heavy Riffs", "2", "2014");
INSERT INTO "concert" VALUES ("13", "Acoustic Sessions", "Unplugged", "5", "2015");
INSERT INTO "concert" VALUES ("14", "Reggae Fest", "Island Grooves", "4", "2016");
INSERT INTO "concert" VALUES ("15", "Opera Night", "Arias and Duets", "7", "2017");
INSERT INTO "concert" VALUES ("16", "K-Pop Extravaganza", "Korean Wave", "8", "2018");
INSERT INTO "concert" VALUES ("17", "Folk Gathering", "Traditional Tunes", "5", "2019");
INSERT INTO "concert" VALUES ("18", "Latin Fiesta", "Salsa and Merengue", "3", "2014");
INSERT INTO "concert" VALUES ("19", "Gospel Celebration", "Inspirational Songs", "2", "2015");
INSERT INTO "concert" VALUES ("20", "Punk Rock Riot", "Rebellious Anthems", "1", "2016");
INSERT INTO "concert" VALUES ("21", "Jazz Fusion", "Experimental Sounds", "3", "2014");
INSERT INTO "concert" VALUES ("22", "Blues Rock", "Electric Blues", "2", "2014");
INSERT INTO "concert" VALUES ("23", "Pop Rock", "Catchy Tunes", "1", "2014");
INSERT INTO "concert" VALUES ("24", "Classical Crossover", "Modern Classics", "6", "2014");
INSERT INTO "concert" VALUES ("25", "World Fusion", "Diverse Sounds", "4", "2014");
INSERT INTO "concert" VALUES ("26", "Stadium Rock", "Anthems", "1", "2014");
INSERT INTO "concert" VALUES ("27", "Arena Pop", "Chart Toppers", "1", "2015");
INSERT INTO "concert" VALUES ("28", "Festival Vibes", "Multi-genre", "1", "2016");
INSERT INTO "concert" VALUES ("29", "Concert Series", "Various Artists", "1", "2017");
INSERT INTO "concert" VALUES ("30", "Music Marathon", "All Day Event", "1", "2018");
INSERT INTO "concert" VALUES ("31", "Annual Gala", "Charity Event", "1", "2019");
INSERT INTO "concert" VALUES ("32", "Summer Jam", "Outdoor Concert", "1", "2020");
INSERT INTO "concert" VALUES ("33", "Winter Wonderland", "Holiday Concert", "1", "2021");
INSERT INTO "concert" VALUES ("34", "Spring Awakening", "New Beginnings", "1", "2022");
INSERT INTO "concert" VALUES ("35", "Autumn Leaves", "Folk and Acoustic", "1", "2023");
INSERT INTO "concert" VALUES ("36", "Rock Revival", "Classic Rock", "2", "2014");
INSERT INTO "concert" VALUES ("37", "Pop Explosion", "Top 40", "2", "2015");
INSERT INTO "concert" VALUES ("38", "Jazz Masters", "Legendary Artists", "2", "2016");
INSERT INTO "concert" VALUES ("39", "EDM Fest", "Dance Party", "2", "2017");
INSERT INTO "concert" VALUES ("40", "Country Stars", "Grand Ole Opry", "2", "2018");
INSERT INTO "concert" VALUES ("41", "Classical Greats", "Symphony Orchestra", "2", "2019");
INSERT INTO "concert" VALUES ("42", "Blues Legends", "Guitar Heroes", "2", "2020");
INSERT INTO "concert" VALUES ("43", "Hip Hop Icons", "Rap Legends", "2", "2021");
INSERT INTO "concert" VALUES ("44", "World Rhythms", "International Artists", "2", "2022");
INSERT INTO "concert" VALUES ("45", "Indie Gems", "Underground Bands", "2", "2023");
INSERT INTO "concert" VALUES ("46", "Metal Mania", "Heavy Metal", "2", "2014");
INSERT INTO "concert" VALUES ("47", "Acoustic Delights", "Unplugged Sessions", "2", "2015");
INSERT INTO "concert" VALUES ("48", "Reggae Vibes", "Caribbean Sounds", "2", "2016");
INSERT INTO "concert" VALUES ("49", "Opera Highlights", "Famous Arias", "2", "2017");
INSERT INTO "concert" VALUES ("50", "K-Pop Sensation", "Idol Groups", "2", "2018");
INSERT INTO "concert" VALUES ("51", "Folk Roots", "Traditional Music", "2", "2019");
INSERT INTO "concert" VALUES ("52", "Latin Beats", "Dance Party", "2", "2020");
INSERT INTO "concert" VALUES ("53", "Gospel Choir", "Inspirational Music", "2", "2021");
INSERT INTO "concert" VALUES ("54", "Punk Rock Anthems", "Rebellious Music", "2", "2022");
INSERT INTO "concert" VALUES ("55", "Jazz Fusion Fest", "Experimental Jazz", "2", "2023");
INSERT INTO "concert" VALUES ("56", "Blues Rock Revival", "Electric Blues", "2", "2014");
INSERT INTO "concert" VALUES ("57", "Pop Rock Party", "Catchy Tunes", "2", "2015");
INSERT INTO "concert" VALUES ("58", "Classical Crossover Live", "Modern Classics", "2", "2016");
INSERT INTO "concert" VALUES ("59", "World Fusion Fest", "Diverse Sounds", "2", "2017");
INSERT INTO "concert" VALUES ("60", "Stadium Rock Legends", "Anthems", "2", "2018");
INSERT INTO "concert" VALUES ("61", "Arena Pop Stars", "Chart Toppers", "2", "2019");
INSERT INTO "concert" VALUES ("62", "Festival Fun", "Multi-genre", "2", "2020");
INSERT INTO "concert" VALUES ("63", "Concert Extravaganza", "Various Artists", "2", "2021");
INSERT INTO "concert" VALUES ("64", "Music Fest", "All Day Event", "2", "2022");
INSERT INTO "concert" VALUES ("65", "Gala Concert", "Charity Event", "2", "2023");
INSERT INTO "concert" VALUES ("66", "Summer Concert", "Outdoor Event", "2", "2014");
INSERT INTO "concert" VALUES ("67", "Winter Concert", "Holiday Event", "2", "2015");
INSERT INTO "concert" VALUES ("68", "Spring Concert", "New Music", "2", "2016");
INSERT INTO "concert" VALUES ("69", "Autumn Concert", "Folk and Acoustic", "2", "2017");
INSERT INTO "concert" VALUES ("70", "Rock Concert", "Loud Music", "2", "2018");
INSERT INTO "concert" VALUES ("71", "Pop Concert", "Mainstream", "2", "2019");
INSERT INTO "concert" VALUES ("72", "Jazz Concert", "Smooth Sounds", "2", "2020");
INSERT INTO "concert" VALUES ("73", "EDM Concert", "Dance Music", "2", "2021");
INSERT INTO "concert" VALUES ("74", "Country Concert", "Southern Charm", "2", "2022");
INSERT INTO "concert" VALUES ("75", "Classical Concert", "Orchestral", "2", "2023");
INSERT INTO "concert" VALUES ("76", "Blues Concert", "Soulful", "2", "2014");
INSERT INTO "concert" VALUES ("77", "Hip Hop Concert", "Rap", "2", "2015");
INSERT INTO "concert" VALUES ("78", "World Music Concert", "Global", "2", "2016");
INSERT INTO "concert" VALUES ("79", "Indie Concert", "Alternative", "2", "2017");
INSERT INTO "concert" VALUES ("80", "Metal Concert", "Heavy", "2", "2018");
INSERT INTO "concert" VALUES ("81", "Acoustic Concert", "Unplugged", "2", "2019");
INSERT INTO "concert" VALUES ("82", "Reggae Concert", "Island", "2", "2020");
INSERT INTO "concert" VALUES ("83", "Opera Concert", "Dramatic", "2", "2021");
INSERT INTO "concert" VALUES ("84", "K-Pop Concert", "Idol", "2", "2022");
INSERT INTO "concert" VALUES ("85", "Folk Concert", "Traditional", "2", "2023");
INSERT INTO "concert" VALUES ("86", "Latin Concert", "Fiesta", "2", "2014");
INSERT INTO "concert" VALUES ("87", "Gospel Concert", "Inspirational", "2", "2015");
INSERT INTO "concert" VALUES ("88", "Punk Concert", "Rebellious", "2", "2016");
INSERT INTO "concert" VALUES ("89", "Jazz Fusion Concert", "Experimental", "2", "2017");
INSERT INTO "concert" VALUES ("90", "Blues Rock Concert", "Electric", "2", "2018");
INSERT INTO "concert" VALUES ("91", "Pop Rock Concert", "Catchy", "2", "2019");
INSERT INTO "concert" VALUES ("92", "Classical Crossover Concert", "Modern", "2", "2020");
INSERT INTO "concert" VALUES ("93", "World Fusion Concert", "Diverse", "2", "2021");
INSERT INTO "concert" VALUES ("94", "Stadium Rock Concert", "Anthems", "2", "2022");
INSERT INTO "concert" VALUES ("95", "Arena Pop Concert", "Chart Toppers", "2", "2023");
INSERT INTO "concert" VALUES ("96", "Festival Concert", "Multi-genre", "2", "2014");
INSERT INTO "concert" VALUES ("97", "Concert Series Event", "Various Artists", "2", "2015");
INSERT INTO "concert" VALUES ("98", "Music Marathon Event", "All Day", "2", "2016");
INSERT INTO "concert" VALUES ("99", "Annual Gala Event", "Charity", "2", "2017");
INSERT INTO "concert" VALUES ("100", "Summer Jam Event", "Outdoor", "2", "2018");
INSERT INTO "concert" VALUES ("101", "Winter Wonderland Event", "Holiday", "2", "2019");
INSERT INTO "concert" VALUES ("102", "Spring Awakening Event", "New", "2", "2020");
INSERT INTO "concert" VALUES ("103", "Autumn Leaves Event", "Folk", "2", "2021");
INSERT INTO "concert" VALUES ("104", "Rock Revival Event", "Classic", "2", "2022");
INSERT INTO "concert" VALUES ("105", "Pop Explosion Event", "Top 40", "2", "2023");
INSERT INTO "concert" VALUES ("106", "Jazz Masters Event", "Legendary", "2", "2014");
INSERT INTO "concert" VALUES ("107", "EDM Fest Event", "Dance", "2", "2015");
INSERT INTO "concert" VALUES ("108", "Country Stars Event", "Nashville", "2", "2016");
INSERT INTO "concert" VALUES ("109", "Classical Greats Event", "Symphony", "2", "2017");
INSERT INTO "concert" VALUES ("110", "Blues Legends Event", "Guitar", "2", "2018");
INSERT INTO "concert" VALUES ("111", "Hip Hop Icons Event", "Rap", "2", "2019");
INSERT INTO "concert" VALUES ("112", "World Rhythms Event", "International", "2", "2020");
INSERT INTO "concert" VALUES ("113", "Indie Gems Event", "Underground", "2", "2021");
INSERT INTO "concert" VALUES ("114", "Metal Mania Event", "Heavy", "2", "2022");
INSERT INTO "concert" VALUES ("115", "Acoustic Delights Event", "Unplugged", "2", "2023");
INSERT INTO "concert" VALUES ("116", "Reggae Vibes Event", "Caribbean", "2", "2014");
INSERT INTO "concert" VALUES ("117", "Opera Highlights Event", "Famous", "2", "2015");
INSERT INTO "concert" VALUES ("118", "K-Pop Sensation Event", "Idol", "2", "2016");
INSERT INTO "concert" VALUES ("119", "Folk Roots Event", "Traditional", "2", "2017");
INSERT INTO "concert" VALUES ("120", "Latin Beats Event", "Dance", "2", "2018");
INSERT INTO "concert" VALUES ("121", "Gospel Choir Event", "Inspirational", "2", "2019");
INSERT INTO "concert" VALUES ("122", "Punk Rock Anthems Event", "Rebellious", "2", "2020");
INSERT INTO "concert" VALUES ("123", "Jazz Fusion Fest Event", "Experimental", "2", "2021");
INSERT INTO "concert" VALUES ("124", "Blues Rock Revival Event", "Electric", "2", "2022");
INSERT INTO "concert" VALUES ("125", "Pop Rock Party Event", "Catchy", "2", "2023");
INSERT INTO "concert" VALUES ("126", "Classical Crossover Live Event", "Modern", "2", "2014");
INSERT INTO "concert" VALUES ("127", "World Fusion Fest Event", "Diverse", "2", "2015");
INSERT INTO "concert" VALUES ("128", "Stadium Rock Legends Event", "Anthems", "2", "2016");
INSERT INTO "concert" VALUES ("129", "Arena Pop Stars Event", "Chart Toppers", "2", "2017");
INSERT INTO "concert" VALUES ("130", "Festival Fun Event", "Multi-genre", "2", "2018");
INSERT INTO "concert" VALUES ("131", "Concert Extravaganza Event", "Various Artists", "2", "2019");
INSERT INTO "concert" VALUES ("132", "Music Fest Event", "All Day", "2", "2020");
INSERT INTO "concert" VALUES ("133", "Gala Concert Event", "Charity", "2", "2021");
INSERT INTO "concert" VALUES ("134", "Summer Concert Event", "Outdoor", "2", "2022");
INSERT INTO "concert" VALUES ("135", "Winter Concert Event", "Holiday", "2", "2023");
INSERT INTO "concert" VALUES ("136", "Spring Concert Event", "New Music", "2", "2014");
INSERT INTO "concert" VALUES ("137", "Autumn Concert Event", "Folk and Acoustic", "2", "2015");
INSERT INTO "concert" VALUES ("138", "Rock Concert Event", "Loud Music", "2", "2016");
INSERT INTO "concert" VALUES ("139", "Pop Concert Event", "Mainstream", "2", "2017");
INSERT INTO "concert" VALUES ("140", "Jazz Concert Event", "Smooth Sounds", "2", "2018");
INSERT INTO "concert" VALUES ("141", "EDM Concert Event", "Dance Music", "2", "2019");
INSERT INTO "concert" VALUES ("142", "Country Concert Event", "Southern Charm", "2", "2020");
INSERT INTO "concert" VALUES ("143", "Classical Concert Event", "Orchestral", "2", "2021");
INSERT INTO "concert" VALUES ("144", "Blues Concert Event", "Soulful", "2", "2022");
INSERT INTO "concert" VALUES ("145", "Hip Hop Concert Event", "Rap", "2", "2023");
INSERT INTO "concert" VALUES ("146", "World Music Concert Event", "Global", "2", "2014");
INSERT INTO "concert" VALUES ("147", "Indie Concert Event", "Alternative", "2", "2015");
INSERT INTO "concert" VALUES ("148", "Metal Concert Event", "Heavy", "2", "2016");
INSERT INTO "concert" VALUES ("149", "Acoustic Concert Event", "Unplugged", "2", "2017");
INSERT INTO "concert" VALUES ("150", "Reggae Concert Event", "Island", "2", "2018");
INSERT INTO "concert" VALUES ("151", "Opera Concert Event", "Dramatic", "2", "2019");
INSERT INTO "concert" VALUES ("152", "K-Pop Concert Event", "Idol", "2", "2020");
INSERT INTO "concert" VALUES ("153", "Folk Concert Event", "Traditional", "2", "2021");
INSERT INTO "concert" VALUES ("154", "Latin Concert Event", "Fiesta", "2", "2022");
INSERT INTO "concert" VALUES ("155", "Gospel Concert Event", "Inspirational", "2", "2023");
INSERT INTO "concert" VALUES ("156", "Punk Concert Event", "Rebellious", "2", "2014");
INSERT INTO "concert" VALUES ("157", "Jazz Fusion Concert Event", "Experimental", "2", "2015");
INSERT INTO "concert" VALUES ("158", "Blues Rock Concert Event", "Electric", "2", "2016");
INSERT INTO "concert" VALUES ("159", "Pop Rock Concert Event", "Catchy", "2", "2017");
INSERT INTO "concert" VALUES ("160", "Classical Crossover Concert Event", "Modern", "2", "2018");
INSERT INTO "concert" VALUES ("161", "World Fusion Concert Event", "Diverse", "2", "2019");
INSERT INTO "concert" VALUES ("162", "Stadium Rock Concert Event", "Anthems", "2", "2020");
INSERT INTO "concert" VALUES ("163", "Arena Pop Concert Event", "Chart Toppers", "2", "2021");
INSERT INTO "concert" VALUES ("164", "Festival Concert Event", "Multi-genre", "2", "2022");
INSERT INTO "concert" VALUES ("165", "Concert Series Event", "Various Artists", "2", "2023");
INSERT INTO "concert" VALUES ("166", "Music Marathon Event", "All Day", "2", "2014");
INSERT INTO "concert" VALUES ("167", "Annual Gala Event", "Charity", "2", "2015");
INSERT INTO "concert" VALUES ("168", "Summer Jam Event", "Outdoor", "2", "2016");
INSERT INTO "concert" VALUES ("169", "Winter Wonderland Event", "Holiday", "2", "2017");
INSERT INTO "concert" VALUES ("170", "Spring Awakening Event", "New", "2", "2018");
INSERT INTO "concert" VALUES ("171", "Autumn Leaves Event", "Folk", "2", "2019");
INSERT INTO "concert" VALUES ("172", "Rock Revival Event", "Classic", "2", "2020");
INSERT INTO "concert" VALUES ("173", "Pop Explosion Event", "Top 40", "2", "2021");
INSERT INTO "concert" VALUES ("174", "Jazz Masters Event", "Legendary", "2", "2022");
INSERT INTO "concert" VALUES ("175", "EDM Fest Event", "Dance", "2", "2023");
INSERT INTO "concert" VALUES ("176", "Country Stars Event", "Nashville", "2", "2014");
INSERT INTO "concert" VALUES ("177", "Classical Greats Event", "Symphony", "2", "2015");
INSERT INTO "concert" VALUES ("178", "Blues Legends Event", "Guitar", "2", "2016");
INSERT INTO "concert" VALUES ("179", "Hip Hop Icons Event", "Rap", "2", "2017");
INSERT INTO "concert" VALUES ("180", "World Rhythms Event", "International", "2", "2018");
INSERT INTO "concert" VALUES ("181", "Indie Gems Event", "Underground", "2", "2019");
INSERT INTO "concert" VALUES ("182", "Metal Mania Event", "Heavy", "2", "2020");
INSERT INTO "concert" VALUES ("183", "Acoustic Delights Event", "Unplugged", "2", "2021");
INSERT INTO "concert" VALUES ("184", "Reggae Vibes Event", "Caribbean", "2", "2022");
INSERT INTO "concert" VALUES ("185", "Opera Highlights Event", "Famous", "2", "2023");
INSERT INTO "concert" VALUES ("186", "K-Pop Sensation Event", "Idol", "2", "2014");
INSERT INTO "concert" VALUES ("187", "Folk Roots Event", "Traditional", "2", "2015");
INSERT INTO "concert" VALUES ("188", "Latin Beats Event", "Dance", "2", "2016");
INSERT INTO "concert" VALUES ("189", "Gospel Choir Event", "Inspirational", "2", "2017");
INSERT INTO "concert" VALUES ("190", "Punk Rock Anthems Event", "Rebellious", "2", "2018");
INSERT INTO "concert" VALUES ("191", "Jazz Fusion Fest Event", "Experimental", "2", "2019");
INSERT INTO "concert" VALUES ("192", "Blues Rock Revival Event", "Electric", "2", "2020");
INSERT INTO "concert" VALUES ("193", "Pop Rock Party Event", "Catchy", "2", "2021");