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 "Cartoon" (
"id" FLOAT,
"Title" TEXT,
PRIMARY KEY ("id")
);

CREATE TABLE "TV_Channel" (
"id" TEXT,
"series_name" TEXT,
"Language" TEXT,
"Content" TEXT,
PRIMARY KEY ("id")
);

CREATE TABLE "TV_series" (
"id" FLOAT,
"Episode" TEXT,
PRIMARY KEY ("id")
);





INSERT INTO "Cartoon" VALUES ("1.0", "Tom and Jerry");
INSERT INTO "Cartoon" VALUES ("2.0", "Looney Tunes");
INSERT INTO "Cartoon" VALUES ("3.0", "Scooby-Doo");
INSERT INTO "Cartoon" VALUES ("4.0", "The Flintstones");
INSERT INTO "Cartoon" VALUES ("5.0", "SpongeBob SquarePants");
INSERT INTO "Cartoon" VALUES ("6.0", "The Simpsons");
INSERT INTO "Cartoon" VALUES ("7.0", "Family Guy");
INSERT INTO "TV_Channel" VALUES ("CH001", "Sky Radio", "English", "Music and Entertainment");
INSERT INTO "TV_Channel" VALUES ("CH002", "BBC One", "English", "News, Drama, and Documentaries");
INSERT INTO "TV_Channel" VALUES ("CH003", "ZDF", "German", "News, Sports, and Culture");
INSERT INTO "TV_Channel" VALUES ("CH004", "TV Globo", "Portuguese", "Novelas and Variety Shows");
INSERT INTO "TV_Channel" VALUES ("CH005", "Sky News", "English", "24/7 News Coverage");
INSERT INTO "TV_Channel" VALUES ("CH006", "Cartoon Network", "English", "Children's Cartoons");
INSERT INTO "TV_Channel" VALUES ("CH007", "Sky Sports", "English", "Live Sports Broadcasts");
INSERT INTO "TV_Channel" VALUES ("CH008", "Discovery Channel", "English", "Documentaries and Reality Shows");
INSERT INTO "TV_series" VALUES ("101.0", "Pilot Episode");
INSERT INTO "TV_series" VALUES ("102.0", "Season 1, Episode 2");
INSERT INTO "TV_series" VALUES ("103.0", "The Final Chapter");
INSERT INTO "TV_series" VALUES ("104.0", "Special Episode");
INSERT INTO "TV_series" VALUES ("105.0", "Premiere");
INSERT INTO "TV_series" VALUES ("106.0", "Mid-Season Finale");
INSERT INTO "TV_series" VALUES ("107.0", "Reunion Show");