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", "53394");
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", "Birmingham", "Villa Park", "42785");
INSERT INTO "stadium" VALUES ("8", "Newcastle", "St James' Park", "52388");
INSERT INTO "stadium" VALUES ("9", "Leeds", "Elland Road", "37890");
INSERT INTO "stadium" VALUES ("10", "Sheffield", "Bramall Lane", "32702");
INSERT INTO "stadium" VALUES ("11", "Bristol", "Ashton Gate", "27000");
INSERT INTO "stadium" VALUES ("12", "Leicester", "King Power Stadium", "32262");
INSERT INTO "stadium" VALUES ("13", "Southampton", "St Mary's Stadium", "32505");
INSERT INTO "stadium" VALUES ("14", "Brighton", "Amex Stadium", "31800");
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", "Portsmouth", "Fratton Park", "20700");
INSERT INTO "stadium" VALUES ("26", "Plymouth", "Home Park", "17900");
INSERT INTO "stadium" VALUES ("27", "Oxford", "Kassam Stadium", "12500");
INSERT INTO "stadium" VALUES ("28", "Cambridge", "Abbey Stadium", "8127");
INSERT INTO "stadium" VALUES ("29", "Exeter", "St James Park", "8219");
INSERT INTO "stadium" VALUES ("30", "Carlisle", "Brunton Park", "17949");
INSERT INTO "stadium" VALUES ("31", "Chester", "Deva Stadium", "6500");
INSERT INTO "stadium" VALUES ("32", "Lincoln", "Sincil Bank", "10120");
INSERT INTO "stadium" VALUES ("33", "Shrewsbury", "New Meadow", "9875");
INSERT INTO "stadium" VALUES ("34", "Rochdale", "Spotland Stadium", "10249");
INSERT INTO "stadium" VALUES ("35", "Accrington", "Wham Stadium", "5057");
INSERT INTO "stadium" VALUES ("36", "Morecambe", "Mazuma Stadium", "6476");
INSERT INTO "stadium" VALUES ("37", "Harrogate", "CNG Stadium", "5000");
INSERT INTO "stadium" VALUES ("38", "Sutton", "Gander Green Lane", "5013");
INSERT INTO "stadium" VALUES ("39", "Barrow", "Holker Street", "5045");
INSERT INTO "stadium" VALUES ("40", "Aldershot", "Recreation Ground", "7100");
INSERT INTO "stadium" VALUES ("41", "Dover", "Crabble Athletic Ground", "5745");
INSERT INTO "stadium" VALUES ("42", "Maidstone", "Gallagher Stadium", "4200");
INSERT INTO "stadium" VALUES ("43", "Woking", "Kingfield Stadium", "6036");
INSERT INTO "stadium" VALUES ("44", "Bromley", "Hayes Lane", "5000");
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", "Altrincham", "Moss Lane", "6085");
INSERT INTO "stadium" VALUES ("50", "Stockport", "Edgeley Park", "10841");
INSERT INTO "stadium" VALUES ("51", "Solihull", "Damson Park", "5500");
INSERT INTO "stadium" VALUES ("52", "Grimsby", "Blundell Park", "9052");
INSERT INTO "stadium" VALUES ("53", "Scunthorpe", "Glanford Park", "9088");
INSERT INTO "stadium" VALUES ("54", "Hartlepool", "Victoria Park", "7856");
INSERT INTO "stadium" VALUES ("55", "Gateshead", "Gateshead International Stadium", "11800");
INSERT INTO "stadium" VALUES ("56", "Darlington", "Blackwell Meadows", "3300");
INSERT INTO "stadium" VALUES ("57", "York", "LNER Community Stadium", "8500");
INSERT INTO "stadium" VALUES ("58", "Boston", "Jakemans Community Stadium", "5000");
INSERT INTO "stadium" VALUES ("59", "Kidderminster", "Aggborough", "6238");
INSERT INTO "stadium" VALUES ("60", "Hereford", "Edgar Street", "5200");
INSERT INTO "stadium" VALUES ("61", "Gloucester", "Meadow Park", "4000");
INSERT INTO "stadium" VALUES ("62", "Chelmsford", "Melbourne Community Stadium", "3000");
INSERT INTO "stadium" VALUES ("63", "Braintree", "Cressing Road", "4000");
INSERT INTO "stadium" VALUES ("64", "Concord Rangers", "Thames Road", "1000");
INSERT INTO "stadium" VALUES ("65", "Dagenham", "Chigwell Construction Stadium", "6078");
INSERT INTO "stadium" VALUES ("66", "Barnet", "The Hive Stadium", "6500");
INSERT INTO "stadium" VALUES ("67", "Wealdstone", "Grosvenor Vale", "4000");
INSERT INTO "stadium" VALUES ("68", "Boreham Wood", "Meadow Park", "4500");
INSERT INTO "stadium" VALUES ("69", "Wrexham", "Racecourse Ground", "10771");
INSERT INTO "stadium" VALUES ("70", "Chesterfield", "Proact Stadium", "10504");
INSERT INTO "stadium" VALUES ("71", "Notts County", "Meadow Lane", "18816");
INSERT INTO "stadium" VALUES ("72", "King's Lynn", "The Walks", "5700");
INSERT INTO "stadium" VALUES ("73", "Wimborne", "New Cuthbury", "3000");
INSERT INTO "stadium" VALUES ("74", "Poole", "Black Gold Stadium", "3000");
INSERT INTO "stadium" VALUES ("75", "Dorchester", "The Avenue Stadium", "5000");
INSERT INTO "stadium" VALUES ("76", "Salisbury", "Raymond McEnhill Stadium", "5000");
INSERT INTO "stadium" VALUES ("77", "Tiverton", "Ian Moorcroft Stadium", "3000");
INSERT INTO "stadium" VALUES ("78", "Truro", "Treyew Road", "3000");
INSERT INTO "stadium" VALUES ("79", "Weston-super-Mare", "Woodspring Stadium", "3500");
INSERT INTO "stadium" VALUES ("80", "Bath", "Twerton Park", "3500");
INSERT INTO "stadium" VALUES ("81", "Chippenham", "Hardenhuish Park", "3000");
INSERT INTO "stadium" VALUES ("82", "Hungerford", "Bulpit Lane", "2500");
INSERT INTO "stadium" VALUES ("83", "Slough", "Arbour Park", "2000");
INSERT INTO "stadium" VALUES ("84", "Hampton & Richmond", "The Beveree Stadium", "3500");
INSERT INTO "stadium" VALUES ("85", "Dartford", "Princes Park", "4100");
INSERT INTO "stadium" VALUES ("86", "Billericay", "New Lodge", "3500");
INSERT INTO "stadium" VALUES ("87", "Hemel Hempstead", "Vauxhall Road", "3000");
INSERT INTO "stadium" VALUES ("88", "St Albans", "Clarence Park", "3000");
INSERT INTO "stadium" VALUES ("89", "Oxford City", "Marsh Lane", "3000");
INSERT INTO "stadium" VALUES ("90", "Blyth", "Croft Park", "4400");
INSERT INTO "stadium" VALUES ("91", "Spennymoor", "The Brewery Field", "3000");
INSERT INTO "stadium" VALUES ("92", "Farsley Celtic", "The Citadel", "3000");
INSERT INTO "stadium" VALUES ("93", "Guiseley", "Nethermoor Park", "3000");
INSERT INTO "stadium" VALUES ("94", "Bradford PA", "Horsfall Stadium", "3500");
INSERT INTO "stadium" VALUES ("95", "Curzon Ashton", "Tameside Stadium", "4000");
INSERT INTO "stadium" VALUES ("96", "Southport", "Haig Avenue", "6000");
INSERT INTO "stadium" VALUES ("97", "Kettering", "Latimer Park", "3500");
INSERT INTO "stadium" VALUES ("98", "Brackley", "St James Park", "3500");
INSERT INTO "stadium" VALUES ("99", "Leamington", "New Windmill Ground", "2300");
INSERT INTO "stadium" VALUES ("100", "AFC Fylde", "Mill Farm", "6000");
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", "Electronic Beats", "Electronic", "6");
INSERT INTO "concert" VALUES ("7", "Country Jamboree", "Country", "7");
INSERT INTO "concert" VALUES ("8", "Blues Bash", "Blues", "8");
INSERT INTO "concert" VALUES ("9", "Reggae Rhythm", "Reggae", "9");
INSERT INTO "concert" VALUES ("10", "Hip Hop Hype", "Hip Hop", "10");
INSERT INTO "concert" VALUES ("11", "Metal Mayhem", "Metal", "11");
INSERT INTO "concert" VALUES ("12", "Folk Festival", "Folk", "12");
INSERT INTO "concert" VALUES ("13", "World Music Expo", "World", "13");
INSERT INTO "concert" VALUES ("14", "Acoustic Sessions", "Acoustic", "14");
INSERT INTO "concert" VALUES ("15", "R&B Rendezvous", "R&B", "15");
INSERT INTO "concert" VALUES ("16", "Soul Serenade", "Soul", "16");
INSERT INTO "concert" VALUES ("17", "Gospel Gathering", "Gospel", "17");
INSERT INTO "concert" VALUES ("18", "Punk Power", "Punk", "18");
INSERT INTO "concert" VALUES ("19", "Disco Fever", "Disco", "19");
INSERT INTO "concert" VALUES ("20", "Techno Trance", "Techno", "20");
INSERT INTO "concert" VALUES ("21", "Dubstep Drop", "Dubstep", "21");
INSERT INTO "concert" VALUES ("22", "Grime Grind", "Grime", "22");
INSERT INTO "concert" VALUES ("23", "K-Pop Craze", "K-Pop", "23");
INSERT INTO "concert" VALUES ("24", "J-Pop Journey", "J-Pop", "24");
INSERT INTO "concert" VALUES ("25", "Latin Fiesta", "Latin", "25");
INSERT INTO "concert" VALUES ("26", "Afrobeat Affair", "Afrobeat", "26");
INSERT INTO "concert" VALUES ("27", "Bollywood Blast", "Bollywood", "27");
INSERT INTO "concert" VALUES ("28", "C-Pop Celebration", "C-Pop", "28");
INSERT INTO "concert" VALUES ("29", "Eurovision Extravaganza", "Eurovision", "29");
INSERT INTO "concert" VALUES ("30", "Soundtrack Symphony", "Soundtrack", "30");
INSERT INTO "concert" VALUES ("31", "Children's Concert", "Children", "31");
INSERT INTO "concert" VALUES ("32", "Comedy Show", "Comedy", "32");
INSERT INTO "concert" VALUES ("33", "Magic Show", "Magic", "33");
INSERT INTO "concert" VALUES ("34", "Dance Performance", "Dance", "34");
INSERT INTO "concert" VALUES ("35", "Theatre Play", "Theatre", "35");
INSERT INTO "concert" VALUES ("36", "Opera Night", "Opera", "36");
INSERT INTO "concert" VALUES ("37", "Ballet Gala", "Ballet", "37");
INSERT INTO "concert" VALUES ("38", "Circus Spectacular", "Circus", "38");
INSERT INTO "concert" VALUES ("39", "Fashion Show", "Fashion", "39");
INSERT INTO "concert" VALUES ("40", "Sports Event", "Sports", "40");
INSERT INTO "concert" VALUES ("41", "Gaming Convention", "Gaming", "41");
INSERT INTO "concert" VALUES ("42", "Tech Expo", "Tech", "42");
INSERT INTO "concert" VALUES ("43", "Food Festival", "Food", "43");
INSERT INTO "concert" VALUES ("44", "Art Exhibition", "Art", "44");
INSERT INTO "concert" VALUES ("45", "Book Fair", "Book", "45");
INSERT INTO "concert" VALUES ("46", "Science Fair", "Science", "46");
INSERT INTO "concert" VALUES ("47", "Car Show", "Car", "47");
INSERT INTO "concert" VALUES ("48", "Boat Show", "Boat", "48");
INSERT INTO "concert" VALUES ("49", "Air Show", "Air", "49");
INSERT INTO "concert" VALUES ("50", "Flower Show", "Flower", "50");
INSERT INTO "concert" VALUES ("51", "Pet Show", "Pet", "51");
INSERT INTO "concert" VALUES ("52", "Craft Fair", "Craft", "52");
INSERT INTO "concert" VALUES ("53", "Farmers Market", "Farmers", "53");
INSERT INTO "concert" VALUES ("54", "Christmas Market", "Christmas", "54");
INSERT INTO "concert" VALUES ("55", "Halloween Party", "Halloween", "55");
INSERT INTO "concert" VALUES ("56", "New Year's Eve Bash", "New Year", "56");
INSERT INTO "concert" VALUES ("57", "Valentine's Ball", "Valentine", "57");
INSERT INTO "concert" VALUES ("58", "St Patrick's Day Parade", "St Patrick", "58");
INSERT INTO "concert" VALUES ("59", "Easter Egg Hunt", "Easter", "59");
INSERT INTO "concert" VALUES ("60", "Summer Carnival", "Carnival", "60");
INSERT INTO "concert" VALUES ("61", "Winter Wonderland", "Winter", "61");
INSERT INTO "concert" VALUES ("62", "Autumn Harvest", "Autumn", "62");
INSERT INTO "concert" VALUES ("63", "Spring Bloom", "Spring", "63");
INSERT INTO "concert" VALUES ("64", "Charity Gala", "Charity", "64");
INSERT INTO "concert" VALUES ("65", "Fundraiser Concert", "Fundraiser", "65");
INSERT INTO "concert" VALUES ("66", "Benefit Show", "Benefit", "66");
INSERT INTO "concert" VALUES ("67", "Awareness Event", "Awareness", "67");
INSERT INTO "concert" VALUES ("68", "Community Festival", "Community", "68");
INSERT INTO "concert" VALUES ("69", "Local Talent Show", "Local Talent", "69");
INSERT INTO "concert" VALUES ("70", "School Play", "School", "70");
INSERT INTO "concert" VALUES ("71", "University Event", "University", "71");
INSERT INTO "concert" VALUES ("72", "Corporate Event", "Corporate", "72");
INSERT INTO "concert" VALUES ("73", "Private Party", "Private", "73");
INSERT INTO "concert" VALUES ("74", "Wedding Reception", "Wedding", "74");
INSERT INTO "concert" VALUES ("75", "Birthday Celebration", "Birthday", "75");
INSERT INTO "concert" VALUES ("76", "Anniversary Dinner", "Anniversary", "76");
INSERT INTO "concert" VALUES ("77", "Graduation Ceremony", "Graduation", "77");
INSERT INTO "concert" VALUES ("78", "Award Ceremony", "Award", "78");
INSERT INTO "concert" VALUES ("79", "Conference", "Conference", "79");
INSERT INTO "concert" VALUES ("80", "Seminar", "Seminar", "80");
INSERT INTO "concert" VALUES ("81", "Workshop", "Workshop", "81");
INSERT INTO "concert" VALUES ("82", "Lecture", "Lecture", "82");
INSERT INTO "concert" VALUES ("83", "Exhibition", "Exhibition", "83");
INSERT INTO "concert" VALUES ("84", "Trade Show", "Trade", "84");
INSERT INTO "concert" VALUES ("85", "Product Launch", "Product", "85");
INSERT INTO "concert" VALUES ("86", "Press Conference", "Press", "86");
INSERT INTO "concert" VALUES ("87", "Shareholder Meeting", "Shareholder", "87");
INSERT INTO "concert" VALUES ("88", "Board Meeting", "Board", "88");
INSERT INTO "concert" VALUES ("89", "Team Building", "Team Building", "89");
INSERT INTO "concert" VALUES ("90", "Training Session", "Training", "90");
INSERT INTO "concert" VALUES ("91", "Networking Event", "Networking", "91");
INSERT INTO "concert" VALUES ("92", "Recruitment Fair", "Recruitment", "92");
INSERT INTO "concert" VALUES ("93", "Job Fair", "Job", "93");
INSERT INTO "concert" VALUES ("94", "Career Day", "Career", "94");
INSERT INTO "concert" VALUES ("95", "Open Day", "Open", "95");
INSERT INTO "concert" VALUES ("96", "Orientation Day", "Orientation", "96");
INSERT INTO "concert" VALUES ("97", "Welcome Event", "Welcome", "97");
INSERT INTO "concert" VALUES ("98", "Farewell Party", "Farewell", "98");
INSERT INTO "concert" VALUES ("99", "Reunion", "Reunion", "99");
INSERT INTO "concert" VALUES ("100", "Alumni Event", "Alumni", "100");