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

CREATE TABLE "singer" (
"Singer_ID" INT,
"Name" TEXT,
PRIMARY KEY ("Singer_ID")
);

CREATE TABLE "singer_in_concert" (
"concert_ID" INT,
"Singer_ID" TEXT,
PRIMARY KEY ("concert_ID", "Singer_ID"),
FOREIGN KEY ("concert_ID") REFERENCES "concert"("concert_ID"),
FOREIGN KEY ("Singer_ID") REFERENCES "singer"("Singer_ID")
);

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





INSERT INTO "concert" VALUES ("1", "Summer Fest", "Rock", "2023");
INSERT INTO "concert" VALUES ("2", "Winter Gala", "Pop", "2022");
INSERT INTO "concert" VALUES ("3", "Spring Jam", "Jazz", "2023");
INSERT INTO "concert" VALUES ("4", "Autumn Vibes", "Electronic", "2021");
INSERT INTO "concert" VALUES ("5", "Classical Night", "Classical", "2023");
INSERT INTO "concert" VALUES ("6", "Blues Bash", "Blues", "2022");
INSERT INTO "concert" VALUES ("7", "Country Jamboree", "Country", "2023");
INSERT INTO "concert" VALUES ("8", "Hip Hop Hype", "Hip Hop", "2021");
INSERT INTO "concert" VALUES ("9", "Reggae Rhythm", "Reggae", "2022");
INSERT INTO "concert" VALUES ("10", "World Music Fest", "World", "2023");
INSERT INTO "singer" VALUES ("1", "John Doe");
INSERT INTO "singer" VALUES ("2", "Jane Smith");
INSERT INTO "singer" VALUES ("3", "Alice Johnson");
INSERT INTO "singer" VALUES ("4", "Bob Williams");
INSERT INTO "singer" VALUES ("5", "Charlie Brown");
INSERT INTO "singer" VALUES ("6", "Diana Prince");
INSERT INTO "singer" VALUES ("7", "Eve Adams");
INSERT INTO "singer" VALUES ("8", "Frank White");
INSERT INTO "singer" VALUES ("9", "Grace Kelly");
INSERT INTO "singer" VALUES ("10", "Harry Potter");
INSERT INTO "singer" VALUES ("11", "Ivy Green");
INSERT INTO "singer" VALUES ("12", "Jack Black");
INSERT INTO "singer" VALUES ("13", "Karen Blue");
INSERT INTO "singer_in_concert" VALUES ("1", "1");
INSERT INTO "singer_in_concert" VALUES ("1", "2");
INSERT INTO "singer_in_concert" VALUES ("1", "3");
INSERT INTO "singer_in_concert" VALUES ("2", "4");
INSERT INTO "singer_in_concert" VALUES ("2", "5");
INSERT INTO "singer_in_concert" VALUES ("3", "6");
INSERT INTO "singer_in_concert" VALUES ("4", "7");
INSERT INTO "singer_in_concert" VALUES ("4", "8");
INSERT INTO "singer_in_concert" VALUES ("4", "9");
INSERT INTO "singer_in_concert" VALUES ("4", "10");
INSERT INTO "singer_in_concert" VALUES ("5", "11");
INSERT INTO "singer_in_concert" VALUES ("6", "12");
INSERT INTO "singer_in_concert" VALUES ("7", "13");
INSERT INTO "singer_in_concert" VALUES ("8", "1");
INSERT INTO "singer_in_concert" VALUES ("8", "4");
INSERT INTO "singer_in_concert" VALUES ("9", "2");
INSERT INTO "singer_in_concert" VALUES ("9", "5");
INSERT INTO "singer_in_concert" VALUES ("10", "3");
INSERT INTO "singer_in_concert" VALUES ("10", "6");
INSERT INTO "singer_in_concert" VALUES ("10", "7");
INSERT INTO "singer_in_concert" VALUES ("10", "11");
INSERT INTO "stadium" VALUES ("1", "Arena One");
INSERT INTO "stadium" VALUES ("2", "Grand Stadium");
INSERT INTO "stadium" VALUES ("3", "City Hall");
INSERT INTO "stadium" VALUES ("4", "Park Venue");
INSERT INTO "stadium" VALUES ("5", "Concert Hall");