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

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

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





INSERT INTO "Cartoon" VALUES ("1", "Adventure Time", "Ben Jones", "Pendleton Ward");
INSERT INTO "Cartoon" VALUES ("2", "Young Justice", "Brandon Vietti", "Greg Weisman");
INSERT INTO "Cartoon" VALUES ("3", "Gravity Falls", "Alex Hirsch", "Alex Hirsch");
INSERT INTO "Cartoon" VALUES ("4", "The Amazing World of Gumball", "Ben Jones", "Ben Bocquelet");
INSERT INTO "Cartoon" VALUES ("5", "Steven Universe", "Rebecca Sugar", "Rebecca Sugar");
INSERT INTO "Cartoon" VALUES ("6", "Teen Titans Go!", "Brandon Vietti", "Michael Jelenic");
INSERT INTO "Cartoon" VALUES ("7", "Regular Show", "J.G. Quintel", "J.G. Quintel");
INSERT INTO "Cartoon" VALUES ("8", "Over the Garden Wall", "Patrick McHale", "Patrick McHale");
INSERT INTO "Cartoon" VALUES ("9", "Clarence", "Ben Jones", "Skyler Page");
INSERT INTO "Cartoon" VALUES ("10", "Ben 10", "Brandon Vietti", "Man of Action");
INSERT INTO "TV_Channel" VALUES ("CN", "Cartoon Network");
INSERT INTO "TV_Channel" VALUES ("DIS", "Disney Channel");
INSERT INTO "TV_Channel" VALUES ("NICK", "Nickelodeon");
INSERT INTO "TV_Channel" VALUES ("PBS", "PBS Kids");
INSERT INTO "TV_Channel" VALUES ("NETFLIX", "Netflix");
INSERT INTO "TV_series" VALUES ("1", "Pilot");
INSERT INTO "TV_series" VALUES ("2", "The Beginning");
INSERT INTO "TV_series" VALUES ("3", "The Return");
INSERT INTO "TV_series" VALUES ("4", "Finale");
INSERT INTO "TV_series" VALUES ("5", "Special Episode");
INSERT INTO "TV_series" VALUES ("6", "Season 1, Episode 1");
INSERT INTO "TV_series" VALUES ("7", "Season 2, Episode 5");
INSERT INTO "TV_series" VALUES ("8", "Season 3, Episode 10");
INSERT INTO "TV_series" VALUES ("9", "Season 4, Episode 3");
INSERT INTO "TV_series" VALUES ("10", "Season 5, Episode 7");