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

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

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





INSERT INTO "concert" VALUES ("1", "Summer Fest", "Pop");
INSERT INTO "concert" VALUES ("2", "Winter Gala", "Classical");
INSERT INTO "concert" VALUES ("3", "Rock Night", "Rock");
INSERT INTO "concert" VALUES ("4", "Jazz Evening", "Jazz");
INSERT INTO "concert" VALUES ("5", "Indie Vibes", "Indie");
INSERT INTO "singer" VALUES ("1", "Alice Johnson");
INSERT INTO "singer" VALUES ("2", "Bob Smith");
INSERT INTO "singer" VALUES ("3", "Catherine Lee");
INSERT INTO "singer" VALUES ("4", "David Brown");
INSERT INTO "singer" VALUES ("5", "Eva Green");
INSERT INTO "singer" VALUES ("6", "Frank White");
INSERT INTO "singer" VALUES ("7", "Grace Kim");
INSERT INTO "singer" VALUES ("8", "Henry Adams");
INSERT INTO "singer" VALUES ("9", "Isabel Clark");
INSERT INTO "singer" VALUES ("10", "Jack Turner");
INSERT INTO "stadium" VALUES ("1", "Grand Arena");
INSERT INTO "stadium" VALUES ("2", "City Hall");
INSERT INTO "stadium" VALUES ("3", "Open Air Theater");
INSERT INTO "stadium" VALUES ("4", "Downtown Club");
INSERT INTO "stadium" VALUES ("5", "Riverside Pavilion");