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 Flintstones");
INSERT INTO "Cartoon" VALUES ("4.0", "Scooby-Doo");
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 "Cartoon" VALUES ("8.0", "Adventure Time");
INSERT INTO "Cartoon" VALUES ("9.0", "Rick and Morty");
INSERT INTO "Cartoon" VALUES ("10.0", "South Park");
INSERT INTO "TV_Channel" VALUES ("CH001", "Cartoon Network", "English", "Animation");
INSERT INTO "TV_Channel" VALUES ("CH002", "Nickelodeon", "English", "Animation");
INSERT INTO "TV_Channel" VALUES ("CH003", "Disney Channel", "English", "Kids");
INSERT INTO "TV_Channel" VALUES ("CH004", "Adult Swim", "English", "Adult Animation");
INSERT INTO "TV_Channel" VALUES ("CH005", "Comedy Central", "English", "Comedy");
INSERT INTO "TV_Channel" VALUES ("CH006", "HBO", "English", "Drama");
INSERT INTO "TV_Channel" VALUES ("CH007", "Netflix", "English", "Streaming");
INSERT INTO "TV_Channel" VALUES ("CH008", "Cartoon Network", "Spanish", "Animation");
INSERT INTO "TV_Channel" VALUES ("CH009", "Nickelodeon", "Spanish", "Animation");
INSERT INTO "TV_Channel" VALUES ("CH010", "Disney Channel", "French", "Kids");
INSERT INTO "TV_Channel" VALUES ("CH011", "Adult Swim", "English", "Adult Animation");
INSERT INTO "TV_Channel" VALUES ("CH012", "Comedy Central", "English", "Comedy");
INSERT INTO "TV_Channel" VALUES ("CH013", "HBO", "English", "Drama");
INSERT INTO "TV_Channel" VALUES ("CH014", "Netflix", "English", "Streaming");
INSERT INTO "TV_series" VALUES ("101.0", "Pilot");
INSERT INTO "TV_series" VALUES ("102.0", "The One With The Couch");
INSERT INTO "TV_series" VALUES ("103.0", "The Last One");
INSERT INTO "TV_series" VALUES ("201.0", "Winter Is Coming");
INSERT INTO "TV_series" VALUES ("202.0", "The Battle of the Bastards");
INSERT INTO "TV_series" VALUES ("301.0", "Chapter One");
INSERT INTO "TV_series" VALUES ("302.0", "The Upside Down");
INSERT INTO "TV_series" VALUES ("401.0", "The Rickshank Rickdemption");
INSERT INTO "TV_series" VALUES ("402.0", "Pickle Rick");
INSERT INTO "TV_series" VALUES ("501.0", "Band Geeks");