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

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

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





INSERT INTO "Cartoon" VALUES ("1.0", "Teen Titans Go!", "Ben Jones");
INSERT INTO "Cartoon" VALUES ("2.0", "Justice League Action", "Brandon Vietti");
INSERT INTO "Cartoon" VALUES ("3.0", "The Amazing World of Gumball", "Mic Graves");
INSERT INTO "Cartoon" VALUES ("4.0", "Adventure Time", "Adam Muto");
INSERT INTO "Cartoon" VALUES ("5.0", "Regular Show", "J.G. Quintel");
INSERT INTO "Cartoon" VALUES ("6.0", "Young Justice", "Brandon Vietti");
INSERT INTO "Cartoon" VALUES ("7.0", "Ben 10", "Ben Jones");
INSERT INTO "Cartoon" VALUES ("8.0", "Steven Universe", "Rebecca Sugar");
INSERT INTO "TV_Channel" VALUES ("CN", "Teen Titans Go!", "Cartoon");
INSERT INTO "TV_Channel" VALUES ("DC", "Justice League Action", "Cartoon");
INSERT INTO "TV_Channel" VALUES ("AD", "The Amazing World of Gumball", "Cartoon");
INSERT INTO "TV_Channel" VALUES ("AT", "Adventure Time", "Cartoon");
INSERT INTO "TV_Channel" VALUES ("RS", "Regular Show", "Cartoon");
INSERT INTO "TV_Channel" VALUES ("YJ", "Young Justice", "Cartoon");
INSERT INTO "TV_Channel" VALUES ("B10", "Ben 10", "Cartoon");
INSERT INTO "TV_Channel" VALUES ("SU", "Steven Universe", "Cartoon");
INSERT INTO "TV_Channel" VALUES ("HBO", "Game of Thrones", "TV Series");
INSERT INTO "TV_Channel" VALUES ("AMC", "The Walking Dead", "TV Series");
INSERT INTO "TV_series" VALUES ("1.0", "The Night Begins to Shine");
INSERT INTO "TV_series" VALUES ("2.0", "Party of One");
INSERT INTO "TV_series" VALUES ("3.0", "The Job");
INSERT INTO "TV_series" VALUES ("4.0", "The Answer");
INSERT INTO "TV_series" VALUES ("5.0", "The Comet");
INSERT INTO "TV_series" VALUES ("6.0", "The Last One");
INSERT INTO "TV_series" VALUES ("7.0", "The Long Night");
INSERT INTO "TV_series" VALUES ("8.0", "Days Gone Bye");