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

CREATE TABLE "singer" (
"Singer_ID" INT,
"Name" TEXT,
"Song_Name" TEXT,
"Song_release_year" TEXT,
"Age" INT,
"Is_male" BOOLEAN,
PRIMARY KEY ("Singer_ID")
);





INSERT INTO "concert" VALUES ("1", "Rock Fest");
INSERT INTO "concert" VALUES ("2", "Pop Mania");
INSERT INTO "concert" VALUES ("3", "Jazz Night");
INSERT INTO "concert" VALUES ("4", "Country Jamboree");
INSERT INTO "concert" VALUES ("5", "Electronic Beats");
INSERT INTO "singer" VALUES ("1", "John Legend", "All of Me", "2013", "45", "1");
INSERT INTO "singer" VALUES ("2", "Adele", "Rolling in the Deep", "2010", "36", "0");
INSERT INTO "singer" VALUES ("3", "Ed Sheeran", "Shape of You", "2017", "33", "1");
INSERT INTO "singer" VALUES ("4", "Taylor Swift", "Blank Space", "2014", "34", "0");
INSERT INTO "singer" VALUES ("5", "Elton John", "Rocket Man", "1972", "77", "1");
INSERT INTO "singer" VALUES ("6", "Billie Eilish", "Bad Guy", "2019", "22", "0");
INSERT INTO "singer" VALUES ("7", "Paul McCartney", "Yesterday", "1965", "82", "1");
INSERT INTO "singer" VALUES ("8", "Dua Lipa", "Don't Start Now", "2019", "28", "0");
INSERT INTO "singer" VALUES ("9", "Sting", "Fields of Gold", "1993", "72", "1");
INSERT INTO "singer" VALUES ("10", "Ariana Grande", "Thank U, Next", "2018", "30", "0");
INSERT INTO "singer" VALUES ("11", "Mariah Carey", "All I Want for Christmas Is You", "1994", "55", "0");
INSERT INTO "singer" VALUES ("12", "Bruno Mars", "Uptown Funk", "2014", "38", "1");
INSERT INTO "singer" VALUES ("13", "Madonna", "Like a Prayer", "1989", "65", "0");
INSERT INTO "singer" VALUES ("14", "Stevie Wonder", "Superstition", "1972", "74", "1");
INSERT INTO "singer" VALUES ("15", "Beyoncé", "Single Ladies", "2008", "42", "0");