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 "Cartoon" VALUES ("6.0", "Scooby-Doo");
INSERT INTO "Cartoon" VALUES ("7.0", "Adventure Time");
INSERT INTO "Cartoon" VALUES ("8.0", "Rick and Morty");
INSERT INTO "TV_Channel" VALUES ("CH001", "The Big Bang Theory", "English", "Comedy");
INSERT INTO "TV_Channel" VALUES ("CH002", "Friends", "English", "Comedy");
INSERT INTO "TV_Channel" VALUES ("CH003", "Game of Thrones", "English", "Drama");
INSERT INTO "TV_Channel" VALUES ("CH004", "Money Heist", "Spanish", "Crime");
INSERT INTO "TV_Channel" VALUES ("CH005", "The Crown", "English", "Drama");
INSERT INTO "TV_Channel" VALUES ("CH006", "Dark", "German", "Sci-Fi");
INSERT INTO "TV_Channel" VALUES ("CH007", "The Office", "English", "Comedy");
INSERT INTO "TV_Channel" VALUES ("CH008", "Breaking Bad", "English", "Drama");
INSERT INTO "TV_Channel" VALUES ("CH009", "Squid Game", "Korean", "Thriller");
INSERT INTO "TV_Channel" VALUES ("CH010", "The Mandalorian", "English", "Sci-Fi");
INSERT INTO "TV_Channel" VALUES ("CH011", "Friends", "English", "Comedy");
INSERT INTO "TV_Channel" VALUES ("CH012", "The Big Bang Theory", "English", "Comedy");
INSERT INTO "TV_Channel" VALUES ("CH013", "Lupin", "French", "Mystery");
INSERT INTO "TV_Channel" VALUES ("CH014", "Narcos", "English", "Crime");
INSERT INTO "TV_Channel" VALUES ("CH015", "The Queen's Gambit", "English", "Drama");
INSERT INTO "TV_series" VALUES ("101.0", "Pilot");
INSERT INTO "TV_series" VALUES ("102.0", "The One Where Monica Gets a Roommate");
INSERT INTO "TV_series" VALUES ("103.0", "Winter Is Coming");
INSERT INTO "TV_series" VALUES ("104.0", "Bella Ciao");
INSERT INTO "TV_series" VALUES ("105.0", "Wolferton Splash");
INSERT INTO "TV_series" VALUES ("106.0", "Secrets");
INSERT INTO "TV_series" VALUES ("107.0", "Pilot");
INSERT INTO "TV_series" VALUES ("108.0", "Pilot");
INSERT INTO "TV_series" VALUES ("109.0", "Red Light, Green Light");
INSERT INTO "TV_series" VALUES ("110.0", "Chapter 1: The Mandalorian");