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

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





INSERT INTO "Cartoon" VALUES ("1", "Adventure Time");
INSERT INTO "Cartoon" VALUES ("2", "BoJack Horseman");
INSERT INTO "Cartoon" VALUES ("3", "Courage the Cowardly Dog");
INSERT INTO "Cartoon" VALUES ("4", "Dexter's Laboratory");
INSERT INTO "Cartoon" VALUES ("5", "Ed, Edd n Eddy");
INSERT INTO "Cartoon" VALUES ("6", "Foster's Home for Imaginary Friends");
INSERT INTO "Cartoon" VALUES ("7", "Gravity Falls");
INSERT INTO "Cartoon" VALUES ("8", "Hey Arnold!");
INSERT INTO "Cartoon" VALUES ("9", "Invader Zim");
INSERT INTO "Cartoon" VALUES ("10", "Johnny Bravo");
INSERT INTO "TV_Channel" VALUES ("CN", "Adventure Time");
INSERT INTO "TV_Channel" VALUES ("NET", "BoJack Horseman");
INSERT INTO "TV_Channel" VALUES ("CN2", "Courage the Cowardly Dog");
INSERT INTO "TV_Channel" VALUES ("CN3", "Dexter's Laboratory");
INSERT INTO "TV_Channel" VALUES ("CN4", "Ed, Edd n Eddy");
INSERT INTO "TV_Channel" VALUES ("CN5", "Foster's Home for Imaginary Friends");
INSERT INTO "TV_Channel" VALUES ("DIS", "Gravity Falls");
INSERT INTO "TV_Channel" VALUES ("NIC", "Hey Arnold!");
INSERT INTO "TV_Channel" VALUES ("CN6", "Invader Zim");
INSERT INTO "TV_Channel" VALUES ("CN7", "Johnny Bravo");
INSERT INTO "TV_series" VALUES ("101", "Pilot", "2010-04-05");
INSERT INTO "TV_series" VALUES ("102", "The Party", "2011-06-12");
INSERT INTO "TV_series" VALUES ("103", "Nightmare", "2012-09-23");
INSERT INTO "TV_series" VALUES ("104", "Experiment", "2013-11-15");
INSERT INTO "TV_series" VALUES ("105", "The Big Game", "2014-01-20");
INSERT INTO "TV_series" VALUES ("106", "Imaginary Friends", "2015-03-30");
INSERT INTO "TV_series" VALUES ("107", "Mystery Shack", "2016-07-07");
INSERT INTO "TV_series" VALUES ("108", "Arnold's Day", "2017-10-10");
INSERT INTO "TV_series" VALUES ("109", "Zim's Plan", "2018-12-25");
INSERT INTO "TV_series" VALUES ("110", "Bravo's Return", "2019-05-05");