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,
"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", "74310");
INSERT INTO "stadium" VALUES ("3", "Liverpool", "Anfield", "54074");
INSERT INTO "stadium" VALUES ("4", "Glasgow", "Hampden Park", "51866");
INSERT INTO "stadium" VALUES ("5", "Cardiff", "Principality Stadium", "74500");
INSERT INTO "stadium" VALUES ("6", "Edinburgh", "Murrayfield Stadium", "67144");
INSERT INTO "stadium" VALUES ("7", "Bristol", "Ashton Gate", "27000");
INSERT INTO "stadium" VALUES ("8", "Leeds", "Elland Road", "37890");
INSERT INTO "stadium" VALUES ("9", "Newcastle", "St James' Park", "52354");
INSERT INTO "stadium" VALUES ("10", "Birmingham", "Villa Park", "42785");
INSERT INTO "stadium" VALUES ("11", "Sheffield", "Bramall Lane", "32702");
INSERT INTO "stadium" VALUES ("12", "Southampton", "St Mary's Stadium", "32505");
INSERT INTO "stadium" VALUES ("13", "Leicester", "King Power Stadium", "32262");
INSERT INTO "stadium" VALUES ("14", "Brighton", "Amex Stadium", "30750");
INSERT INTO "stadium" VALUES ("15", "Nottingham", "City Ground", "30445");
INSERT INTO "stadium" VALUES ("16", "Coventry", "Ricoh Arena", "32609");
INSERT INTO "stadium" VALUES ("17", "Derby", "Pride Park Stadium", "33597");
INSERT INTO "stadium" VALUES ("18", "Stoke-on-Trent", "bet365 Stadium", "30089");
INSERT INTO "stadium" VALUES ("19", "Sunderland", "Stadium of Light", "49000");
INSERT INTO "stadium" VALUES ("20", "Middlesbrough", "Riverside Stadium", "34742");
INSERT INTO "stadium" VALUES ("21", "Hull", "KCOM Stadium", "25400");
INSERT INTO "stadium" VALUES ("22", "Blackburn", "Ewood Park", "31367");
INSERT INTO "stadium" VALUES ("23", "Bolton", "University of Bolton Stadium", "28723");
INSERT INTO "stadium" VALUES ("24", "Reading", "Madejski Stadium", "24161");
INSERT INTO "stadium" VALUES ("25", "Norwich", "Carrow Road", "27244");
INSERT INTO "stadium" VALUES ("26", "Ipswich", "Portman Road", "30311");
INSERT INTO "stadium" VALUES ("27", "Portsmouth", "Fratton Park", "20700");
INSERT INTO "stadium" VALUES ("28", "Plymouth", "Home Park", "17900");
INSERT INTO "stadium" VALUES ("29", "Exeter", "St James Park", "8219");
INSERT INTO "stadium" VALUES ("30", "Cheltenham", "Whaddon Road", "7066");
INSERT INTO "stadium" VALUES ("31", "Carlisle", "Brunton Park", "17949");
INSERT INTO "stadium" VALUES ("32", "Doncaster", "Keepmoat Stadium", "15231");
INSERT INTO "stadium" VALUES ("33", "Rochdale", "Spotland Stadium", "10249");
INSERT INTO "stadium" VALUES ("34", "Burton upon Trent", "Pirelli Stadium", "6912");
INSERT INTO "stadium" VALUES ("35", "Fleetwood", "Highbury Stadium", "5327");
INSERT INTO "stadium" VALUES ("36", "Accrington", "Crown Ground", "5057");
INSERT INTO "stadium" VALUES ("37", "Morecambe", "Globe Arena", "6476");
INSERT INTO "stadium" VALUES ("38", "Harrogate", "CNG Stadium", "5000");
INSERT INTO "stadium" VALUES ("39", "Sutton", "Gander Green Lane", "5013");
INSERT INTO "stadium" VALUES ("40", "Bromley", "Hayes Lane", "5000");
INSERT INTO "stadium" VALUES ("41", "Dover", "Crabble Athletic Ground", "5000");
INSERT INTO "stadium" VALUES ("42", "Maidstone", "Gallagher Stadium", "4200");
INSERT INTO "stadium" VALUES ("43", "Woking", "Kingfield Stadium", "6036");
INSERT INTO "stadium" VALUES ("44", "Aldershot", "Recreation Ground", "7100");
INSERT INTO "stadium" VALUES ("45", "Eastleigh", "Silverlake Stadium", "5250");
INSERT INTO "stadium" VALUES ("46", "Yeovil", "Huish Park", "9565");
INSERT INTO "stadium" VALUES ("47", "Torquay", "Plainmoor", "6500");
INSERT INTO "stadium" VALUES ("48", "Weymouth", "Bob Lucas Stadium", "6600");
INSERT INTO "stadium" VALUES ("49", "Barnet", "The Hive Stadium", "6500");
INSERT INTO "stadium" VALUES ("50", "Borehamwood", "Meadow Park", "4500");
INSERT INTO "stadium" VALUES ("51", "Dagenham", "Victoria Road", "6078");
INSERT INTO "stadium" VALUES ("52", "Leyton", "Brisbane Road", "9271");
INSERT INTO "stadium" VALUES ("53", "Southend", "Roots Hall", "12392");
INSERT INTO "stadium" VALUES ("54", "Colchester", "JobServe Community Stadium", "10100");
INSERT INTO "stadium" VALUES ("55", "Cambridge", "Abbey Stadium", "8127");
INSERT INTO "stadium" VALUES ("56", "Northampton", "Sixfields Stadium", "7798");
INSERT INTO "stadium" VALUES ("57", "Peterborough", "London Road Stadium", "15314");
INSERT INTO "stadium" VALUES ("58", "Lincoln", "Sincil Bank", "10120");
INSERT INTO "stadium" VALUES ("59", "Grimsby", "Blundell Park", "9052");
INSERT INTO "stadium" VALUES ("60", "Scunthorpe", "Glanford Park", "9088");
INSERT INTO "stadium" VALUES ("61", "Mansfield", "Field Mill", "9186");
INSERT INTO "stadium" VALUES ("62", "Chesterfield", "Proact Stadium", "10504");
INSERT INTO "stadium" VALUES ("63", "Rotherham", "New York Stadium", "12021");
INSERT INTO "stadium" VALUES ("64", "Barnsley", "Oakwell", "23287");
INSERT INTO "stadium" VALUES ("65", "Bradford", "Valley Parade", "25136");
INSERT INTO "stadium" VALUES ("66", "Huddersfield", "John Smith's Stadium", "24121");
INSERT INTO "stadium" VALUES ("67", "Wakefield", "Belle Vue", "12000");
INSERT INTO "stadium" VALUES ("68", "Halifax", "The Shay", "10000");
INSERT INTO "stadium" VALUES ("69", "Oldham", "Boundary Park", "13512");
INSERT INTO "stadium" VALUES ("70", "Bury", "Gigg Lane", "11840");
INSERT INTO "stadium" VALUES ("71", "Rochdale", "Spotland Stadium", "10249");
INSERT INTO "stadium" VALUES ("72", "Salford", "Peninsula Stadium", "5108");
INSERT INTO "stadium" VALUES ("73", "Stockport", "Edgeley Park", "10841");
INSERT INTO "stadium" VALUES ("74", "Macclesfield", "Moss Rose", "6355");
INSERT INTO "stadium" VALUES ("75", "Crewe", "Gresty Road", "10153");
INSERT INTO "stadium" VALUES ("76", "Port Vale", "Vale Park", "15036");
INSERT INTO "stadium" VALUES ("77", "Walsall", "Bescot Stadium", "11300");
INSERT INTO "stadium" VALUES ("78", "Shrewsbury", "New Meadow", "9875");
INSERT INTO "stadium" VALUES ("79", "Telford", "New Bucks Head", "6380");
INSERT INTO "stadium" VALUES ("80", "Kidderminster", "Aggborough", "6238");
INSERT INTO "stadium" VALUES ("81", "Hereford", "Edgar Street", "5073");
INSERT INTO "stadium" VALUES ("82", "Worcester", "Sixways Stadium", "12067");
INSERT INTO "stadium" VALUES ("83", "Gloucester", "Kingsholm Stadium", "16115");
INSERT INTO "stadium" VALUES ("84", "Swindon", "County Ground", "15728");
INSERT INTO "stadium" VALUES ("85", "Oxford", "Kassam Stadium", "12500");
INSERT INTO "stadium" VALUES ("86", "Wycombe", "Adams Park", "10000");
INSERT INTO "stadium" VALUES ("87", "Luton", "Kenilworth Road", "10356");
INSERT INTO "stadium" VALUES ("88", "Stevenage", "Broadhall Way", "7800");
INSERT INTO "stadium" VALUES ("89", "Barnet", "The Hive Stadium", "6500");
INSERT INTO "stadium" VALUES ("90", "Wealdstone", "Grosvenor Vale", "4000");
INSERT INTO "stadium" VALUES ("91", "Dover", "Crabble Athletic Ground", "5000");
INSERT INTO "stadium" VALUES ("92", "Dartford", "Princes Park", "4100");
INSERT INTO "stadium" VALUES ("93", "Ebbsfleet", "Stonebridge Road", "5000");
INSERT INTO "stadium" VALUES ("94", "Gillingham", "Priestfield Stadium", "11582");
INSERT INTO "stadium" VALUES ("95", "Rochdale", "Spotland Stadium", "10249");
INSERT INTO "stadium" VALUES ("96", "Burton upon Trent", "Pirelli Stadium", "6912");
INSERT INTO "stadium" VALUES ("97", "Fleetwood", "Highbury Stadium", "5327");
INSERT INTO "stadium" VALUES ("98", "Accrington", "Crown Ground", "5057");
INSERT INTO "stadium" VALUES ("99", "Morecambe", "Globe Arena", "6476");
INSERT INTO "stadium" VALUES ("100", "Harrogate", "CNG Stadium", "5000");
INSERT INTO "concert" VALUES ("1", "Summer Fest", "Rock", "1");
INSERT INTO "concert" VALUES ("2", "Pop Mania", "Pop", "2");
INSERT INTO "concert" VALUES ("3", "Jazz Night", "Jazz", "3");
INSERT INTO "concert" VALUES ("4", "Classical Gala", "Classical", "4");
INSERT INTO "concert" VALUES ("5", "Indie Showcase", "Indie", "5");
INSERT INTO "concert" VALUES ("6", "Blues Bash", "Blues", "6");
INSERT INTO "concert" VALUES ("7", "Country Jamboree", "Country", "7");
INSERT INTO "concert" VALUES ("8", "Electronic Extravaganza", "Electronic", "8");
INSERT INTO "concert" VALUES ("9", "Hip Hop Hooray", "Hip Hop", "9");
INSERT INTO "concert" VALUES ("10", "Reggae Rhythm", "Reggae", "10");
INSERT INTO "concert" VALUES ("11", "World Music Festival", "World", "11");
INSERT INTO "concert" VALUES ("12", "Folk Fiesta", "Folk", "12");
INSERT INTO "concert" VALUES ("13", "Metal Mayhem", "Metal", "13");
INSERT INTO "concert" VALUES ("14", "Punk Power", "Punk", "14");
INSERT INTO "concert" VALUES ("15", "Soul Serenade", "Soul", "15");
INSERT INTO "concert" VALUES ("16", "R&B Rendezvous", "R&B", "16");
INSERT INTO "concert" VALUES ("17", "Gospel Gathering", "Gospel", "17");
INSERT INTO "concert" VALUES ("18", "Latin Live", "Latin", "18");
INSERT INTO "concert" VALUES ("19", "Dance Delight", "Dance", "19");
INSERT INTO "concert" VALUES ("20", "Acoustic Afternoon", "Acoustic", "20");
INSERT INTO "concert" VALUES ("21", "Stadium Rock Revival", "Rock", "29");
INSERT INTO "concert" VALUES ("22", "Pop Stars Live", "Pop", "30");
INSERT INTO "concert" VALUES ("23", "Jazz Legends", "Jazz", "34");
INSERT INTO "concert" VALUES ("24", "Orchestra Night", "Classical", "35");
INSERT INTO "concert" VALUES ("25", "New Wave Fest", "Indie", "36");
INSERT INTO "concert" VALUES ("26", "Blues Brothers Tribute", "Blues", "37");
INSERT INTO "concert" VALUES ("27", "Nashville Stars", "Country", "38");
INSERT INTO "concert" VALUES ("28", "EDM Explosion", "Electronic", "39");
INSERT INTO "concert" VALUES ("29", "Rap Battle Royale", "Hip Hop", "40");
INSERT INTO "concert" VALUES ("30", "Island Vibes", "Reggae", "41");
INSERT INTO "concert" VALUES ("31", "Global Rhythms", "World", "43");
INSERT INTO "concert" VALUES ("32", "Celtic Sounds", "Folk", "44");
INSERT INTO "concert" VALUES ("33", "Heavy Metal Thunder", "Metal", "45");
INSERT INTO "concert" VALUES ("34", "Anarchy in the UK", "Punk", "46");
INSERT INTO "concert" VALUES ("35", "Motown Magic", "Soul", "47");
INSERT INTO "concert" VALUES ("36", "Neo-Soul Sessions", "R&B", "48");
INSERT INTO "concert" VALUES ("37", "Choir Festival", "Gospel", "49");
INSERT INTO "concert" VALUES ("38", "Salsa Night", "Latin", "51");
INSERT INTO "concert" VALUES ("39", "Trance Party", "Dance", "52");
INSERT INTO "concert" VALUES ("40", "Unplugged Series", "Acoustic", "55");
INSERT INTO "concert" VALUES ("41", "Rock Anthems", "Rock", "56");
INSERT INTO "concert" VALUES ("42", "Pop Hits Live", "Pop", "59");
INSERT INTO "concert" VALUES ("43", "Jazz Fusion", "Jazz", "60");
INSERT INTO "concert" VALUES ("44", "Symphony Under the Stars", "Classical", "61");
INSERT INTO "concert" VALUES ("45", "Alternative Sounds", "Indie", "68");
INSERT INTO "concert" VALUES ("46", "Delta Blues", "Blues", "72");
INSERT INTO "concert" VALUES ("47", "Bluegrass Bonanza", "Country", "74");
INSERT INTO "concert" VALUES ("48", "Techno Takeover", "Electronic", "78");
INSERT INTO "concert" VALUES ("49", "Freestyle Flow", "Hip Hop", "79");
INSERT INTO "concert" VALUES ("50", "Dub Reggae", "Reggae", "80");
INSERT INTO "concert" VALUES ("51", "Ethno Groove", "World", "81");
INSERT INTO "concert" VALUES ("52", "Traditional Tunes", "Folk", "86");
INSERT INTO "concert" VALUES ("53", "Thrash Metal Fest", "Metal", "87");
INSERT INTO "concert" VALUES ("54", "Hardcore Punk", "Punk", "88");
INSERT INTO "concert" VALUES ("55", "Funk & Soul Night", "Soul", "89");
INSERT INTO "concert" VALUES ("56", "Contemporary R&B", "R&B", "91");
INSERT INTO "concert" VALUES ("57", "Spiritual Songs", "Gospel", "96");
INSERT INTO "concert" VALUES ("58", "Flamenco Fiesta", "Latin", "97");
INSERT INTO "concert" VALUES ("59", "House Party", "Dance", "98");
INSERT INTO "concert" VALUES ("60", "Singer-Songwriter Showcase", "Acoustic", "99");