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,
"Country" TEXT,
"Song_Name" TEXT,
"Song_release_year" TEXT,
"Age" INT,
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", "Classical Gala");
INSERT INTO "singer" VALUES ("1", "Frank Sinatra", "USA", "My Way", "1969", "82");
INSERT INTO "singer" VALUES ("2", "Aretha Franklin", "USA", "Respect", "1967", "76");
INSERT INTO "singer" VALUES ("3", "Elvis Presley", "USA", "Hound Dog", "1956", "42");
INSERT INTO "singer" VALUES ("4", "Adele", "UK", "Rolling in the Deep", "2010", "35");
INSERT INTO "singer" VALUES ("5", "Ed Sheeran", "UK", "Shape of You", "2017", "32");
INSERT INTO "singer" VALUES ("6", "Taylor Swift", "USA", "Blank Space", "2014", "33");
INSERT INTO "singer" VALUES ("7", "Justin Bieber", "Canada", "Baby", "2010", "29");
INSERT INTO "singer" VALUES ("8", "Billie Eilish", "USA", "Bad Guy", "2019", "21");
INSERT INTO "singer" VALUES ("9", "Celine Dion", "Canada", "My Heart Will Go On", "1997", "55");
INSERT INTO "singer" VALUES ("10", "Andrea Bocelli", "Italy", "Con te partirò", "1995", "65");
INSERT INTO "singer" VALUES ("11", "Mariah Carey", "USA", "All I Want for Christmas Is You", "1994", "54");
INSERT INTO "singer" VALUES ("12", "Beyoncé", "USA", "Single Ladies", "2008", "42");
INSERT INTO "singer" VALUES ("13", "Freddie Mercury", "UK", "Bohemian Rhapsody", "1975", "45");
INSERT INTO "singer" VALUES ("14", "Whitney Houston", "USA", "I Will Always Love You", "1992", "48");
INSERT INTO "singer" VALUES ("15", "Michael Jackson", "USA", "Thriller", "1982", "50");