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", "Ben 10", "Ben Jones");
INSERT INTO "Cartoon" VALUES ("2.0", "Justice League Action", "Brandon Vietti");
INSERT INTO "Cartoon" VALUES ("3.0", "Teen Titans Go!", "Michael Jelenic");
INSERT INTO "Cartoon" VALUES ("4.0", "Young Justice", "Brandon Vietti");
INSERT INTO "Cartoon" VALUES ("5.0", "Generator Rex", "Man of Action");
INSERT INTO "Cartoon" VALUES ("6.0", "The Amazing World of Gumball", "Ben Bocquelet");
INSERT INTO "Cartoon" VALUES ("7.0", "Steven Universe", "Rebecca Sugar");
INSERT INTO "Cartoon" VALUES ("8.0", "Adventure Time", "Pendleton Ward");
INSERT INTO "Cartoon" VALUES ("9.0", "Regular Show", "J.G. Quintel");
INSERT INTO "Cartoon" VALUES ("10.0", "Dexter's Laboratory", "Genndy Tartakovsky");
INSERT INTO "TV_Channel" VALUES ("CN", "Ben 10", "Cartoon");
INSERT INTO "TV_Channel" VALUES ("DC", "Justice League Action", "Cartoon");
INSERT INTO "TV_Channel" VALUES ("DC", "Young Justice", "Cartoon");
INSERT INTO "TV_Channel" VALUES ("CN", "Teen Titans Go!", "Cartoon");
INSERT INTO "TV_Channel" VALUES ("CN", "Generator Rex", "Cartoon");
INSERT INTO "TV_Channel" VALUES ("CN", "The Amazing World of Gumball", "Cartoon");
INSERT INTO "TV_Channel" VALUES ("CN", "Steven Universe", "Cartoon");
INSERT INTO "TV_Channel" VALUES ("CN", "Adventure Time", "Cartoon");
INSERT INTO "TV_Channel" VALUES ("CN", "Regular Show", "Cartoon");
INSERT INTO "TV_Channel" VALUES ("CN", "Dexter's Laboratory", "Cartoon");
INSERT INTO "TV_series" VALUES ("1.0", "Omniverse");
INSERT INTO "TV_series" VALUES ("2.0", "Season 1, Episode 1");
INSERT INTO "TV_series" VALUES ("3.0", "The Night Begins to Shine");
INSERT INTO "TV_series" VALUES ("4.0", "Independence Day");
INSERT INTO "TV_series" VALUES ("5.0", "The Architect");
INSERT INTO "TV_series" VALUES ("6.0", "The Responsible");
INSERT INTO "TV_series" VALUES ("7.0", "Jailbreak");
INSERT INTO "TV_series" VALUES ("8.0", "Finn the Human");
INSERT INTO "TV_series" VALUES ("9.0", "The Power");
INSERT INTO "TV_series" VALUES ("10.0", "Dee Dee and the Amazing Race");