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", "The Simpsons");
INSERT INTO "Cartoon" VALUES ("4.0", "Family Guy");
INSERT INTO "Cartoon" VALUES ("5.0", "SpongeBob SquarePants");
INSERT INTO "TV_Channel" VALUES ("CH001", "Sky Radio", "English", "Music and Talk Shows");
INSERT INTO "TV_Channel" VALUES ("CH002", "News Channel 24/7", "English", "Breaking News and Current Affairs");
INSERT INTO "TV_Channel" VALUES ("CH003", "Kids Fun Zone", "English", "Children's Educational Programs");
INSERT INTO "TV_Channel" VALUES ("CH004", "Movie Mania", "Spanish", "Action and Drama Movies");
INSERT INTO "TV_Channel" VALUES ("CH005", "Documentary World", "English", "Nature and Science Documentaries");
INSERT INTO "TV_Channel" VALUES ("CH006", "Sports Live", "English", "Live Sports Broadcasts");
INSERT INTO "TV_Channel" VALUES ("CH007", "Cooking Delights", "French", "Culinary Shows");
INSERT INTO "TV_Channel" VALUES ("CH008", "Travel Adventures", "English", "Travel Vlogs and Guides");
INSERT INTO "TV_series" VALUES ("101.0", "Episode 1: The Beginning");
INSERT INTO "TV_series" VALUES ("102.0", "Episode 2: A New Hope");
INSERT INTO "TV_series" VALUES ("103.0", "Episode 3: The Empire Strikes Back");
INSERT INTO "TV_series" VALUES ("104.0", "Episode 4: Return of the Jedi");
INSERT INTO "TV_series" VALUES ("105.0", "Episode 5: The Phantom Menace");
INSERT INTO "TV_series" VALUES ("106.0", "Episode 6: Attack of the Clones");
INSERT INTO "TV_series" VALUES ("107.0", "Episode 7: Revenge of the Sith");