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 ("CN", "Courage the Cowardly Dog");
INSERT INTO "TV_Channel" VALUES ("CN", "Dexter's Laboratory");
INSERT INTO "TV_Channel" VALUES ("CN", "Ed, Edd n Eddy");
INSERT INTO "TV_Channel" VALUES ("CN", "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 ("NIC", "Invader Zim");
INSERT INTO "TV_Channel" VALUES ("CN", "Johnny Bravo");
INSERT INTO "TV_series" VALUES ("101", "Pilot", "2010-04-05");
INSERT INTO "TV_series" VALUES ("102", "The Enchiridion!", "2010-04-12");
INSERT INTO "TV_series" VALUES ("103", "BoJack Horseman S1E1", "2014-08-22");
INSERT INTO "TV_series" VALUES ("104", "Courage Meets the Mummy", "1999-11-12");
INSERT INTO "TV_series" VALUES ("105", "Dexter's Laboratory S1E1", "1996-04-28");
INSERT INTO "TV_series" VALUES ("106", "Ed, Edd n Eddy: Pop Goes the Ed", "1999-01-04");
INSERT INTO "TV_series" VALUES ("107", "Foster's Home for Imaginary Friends: House of Bloo's", "2004-08-13");
INSERT INTO "TV_series" VALUES ("108", "Gravity Falls: Tourist Trapped", "2012-06-15");
INSERT INTO "TV_series" VALUES ("109", "Hey Arnold!: Downtown as Fruits", "1996-10-07");
INSERT INTO "TV_series" VALUES ("110", "Invader Zim: The Nightmare Begins", "2001-03-30");
INSERT INTO "TV_series" VALUES ("111", "Johnny Bravo: Johnny Bravo", "1997-07-07");