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", "The Amazing World of Gumball", "Ben Jones");
INSERT INTO "Cartoon" VALUES ("2", "Adventure Time", "Pendleton Ward");
INSERT INTO "Cartoon" VALUES ("3", "Regular Show", "J.G. Quintel");
INSERT INTO "Cartoon" VALUES ("4", "Steven Universe", "Rebecca Sugar");
INSERT INTO "Cartoon" VALUES ("5", "We Bare Bears", "Daniel Chong");
INSERT INTO "Cartoon" VALUES ("6", "Dexter's Laboratory", "Genndy Tartakovsky");
INSERT INTO "Cartoon" VALUES ("7", "Powerpuff Girls", "Craig McCracken");
INSERT INTO "Cartoon" VALUES ("8", "Samurai Jack", "Genndy Tartakovsky");
INSERT INTO "Cartoon" VALUES ("9", "Foster's Home for Imaginary Friends", "Craig McCracken");
INSERT INTO "Cartoon" VALUES ("10", "Ben 10", "Man of Action");
INSERT INTO "Cartoon" VALUES ("11", "Chowder", "C.H. Greenblatt");
INSERT INTO "Cartoon" VALUES ("12", "Flapjack", "Thurop Van Orman");
INSERT INTO "Cartoon" VALUES ("13", "Courage the Cowardly Dog", "John R. Dilworth");
INSERT INTO "Cartoon" VALUES ("14", "Ed, Edd n Eddy", "Danny Antonucci");
INSERT INTO "Cartoon" VALUES ("15", "Johnny Bravo", "Van Partible");
INSERT INTO "Cartoon" VALUES ("16", "Cow and Chicken", "David Feiss");
INSERT INTO "Cartoon" VALUES ("17", "I Am Weasel", "David Feiss");
INSERT INTO "Cartoon" VALUES ("18", "The Grim Adventures of Billy & Mandy", "Maxwell Atoms");
INSERT INTO "Cartoon" VALUES ("19", "Kids Next Door", "Tom Warburton");
INSERT INTO "Cartoon" VALUES ("20", "My Gym Partner's a Monkey", "Tim Cahill");
INSERT INTO "Cartoon" VALUES ("21", "Camp Lazlo", "Joe Murray");
INSERT INTO "Cartoon" VALUES ("22", "Class of 3000", "Andre 3000");
INSERT INTO "Cartoon" VALUES ("23", "Robotboy", "Jan Van Rijsselberge");
INSERT INTO "Cartoon" VALUES ("24", "Megas XLR", "Jody Schaeffer");
INSERT INTO "Cartoon" VALUES ("25", "Sym-Bionic Titan", "Genndy Tartakovsky");
INSERT INTO "Cartoon" VALUES ("26", "Generator Rex", "Man of Action");
INSERT INTO "Cartoon" VALUES ("27", "Young Justice", "Brandon Vietti");
INSERT INTO "Cartoon" VALUES ("28", "Green Lantern: The Animated Series", "Giancarlo Volpe");
INSERT INTO "Cartoon" VALUES ("29", "Teen Titans Go!", "Michael Jelenic");
INSERT INTO "Cartoon" VALUES ("30", "Uncle Grandpa", "Peter Browngardt");
INSERT INTO "Cartoon" VALUES ("31", "Clarence", "Skyler Page");
INSERT INTO "Cartoon" VALUES ("32", "Over the Garden Wall", "Patrick McHale");
INSERT INTO "Cartoon" VALUES ("33", "OK K.O.! Let's Be Heroes", "Ian Jones-Quartey");
INSERT INTO "Cartoon" VALUES ("34", "Craig of the Creek", "Matt Burnett");
INSERT INTO "Cartoon" VALUES ("35", "Summer Camp Island", "Julia Pott");
INSERT INTO "Cartoon" VALUES ("36", "Victor and Valentino", "Diego Molano");
INSERT INTO "Cartoon" VALUES ("37", "Mao Mao: Heroes of Pure Heart", "Parker Simmons");
INSERT INTO "Cartoon" VALUES ("38", "Infinity Train", "Owen Dennis");
INSERT INTO "Cartoon" VALUES ("39", "The Fungies!", "Stephen P. Neary");
INSERT INTO "Cartoon" VALUES ("40", "Apple & Onion", "George Gendi");
INSERT INTO "Cartoon" VALUES ("41", "Primal", "Genndy Tartakovsky");
INSERT INTO "Cartoon" VALUES ("42", "Close Enough", "J.G. Quintel");
INSERT INTO "Cartoon" VALUES ("43", "Tig n' Seek", "Myke Chilian");
INSERT INTO "Cartoon" VALUES ("44", "The Midnight Gospel", "Duncan Trussell");
INSERT INTO "Cartoon" VALUES ("45", "Total Drama Island", "Tom McGillis");
INSERT INTO "Cartoon" VALUES ("46", "6teen", "Jennifer Pertsch");
INSERT INTO "Cartoon" VALUES ("47", "Stoked", "Jennifer Pertsch");
INSERT INTO "Cartoon" VALUES ("48", "Grojband", "Todd Kauffman");
INSERT INTO "Cartoon" VALUES ("49", "Total DramaRama", "Tom McGillis");
INSERT INTO "Cartoon" VALUES ("50", "The Looney Tunes Show", "Spike Brandt");
INSERT INTO "Cartoon" VALUES ("51", "Scooby-Doo! Mystery Incorporated", "Mitch Watson");
INSERT INTO "Cartoon" VALUES ("52", "The Tom and Jerry Show", "Darrell Van Citters");
INSERT INTO "Cartoon" VALUES ("53", "Wabbit", "Erik Kuska");
INSERT INTO "Cartoon" VALUES ("54", "New Looney Tunes", "Erik Kuska");
INSERT INTO "Cartoon" VALUES ("55", "Unikitty!", "Andrea Fernandez");
INSERT INTO "Cartoon" VALUES ("56", "DC Super Hero Girls", "Lauren Faust");
INSERT INTO "Cartoon" VALUES ("57", "ThunderCats Roar", "Victor Courtright");
INSERT INTO "Cartoon" VALUES ("58", "Mao Mao: Heroes of Pure Heart", "Ben Jones");
INSERT INTO "Cartoon" VALUES ("59", "The Powerpuff Girls 2016", "Nick Jennings");
INSERT INTO "Cartoon" VALUES ("60", "Ben 10 2016", "Man of Action");
INSERT INTO "Cartoon" VALUES ("61", "The Fungies!", "Ben Jones");
INSERT INTO "TV_Channel" VALUES ("CN", "Cartoon Network", "Animation");
INSERT INTO "TV_Channel" VALUES ("NICK", "Nickelodeon", "Animation");
INSERT INTO "TV_Channel" VALUES ("DIS", "Disney Channel", "Animation");
INSERT INTO "TV_Channel" VALUES ("ADULT", "Adult Swim", "Adult Animation");
INSERT INTO "TV_Channel" VALUES ("FOX", "Fox", "Animation");
INSERT INTO "TV_Channel" VALUES ("TBS", "TBS", "Comedy");
INSERT INTO "TV_Channel" VALUES ("TNT", "TNT", "Drama");
INSERT INTO "TV_Channel" VALUES ("AMC", "AMC", "Drama");
INSERT INTO "TV_Channel" VALUES ("HBO", "HBO", "Premium");
INSERT INTO "TV_Channel" VALUES ("FX", "FX", "Drama");
INSERT INTO "TV_series" VALUES ("101", "Pilot");
INSERT INTO "TV_series" VALUES ("102", "Season 1, Episode 1");
INSERT INTO "TV_series" VALUES ("103", "Season 1, Episode 2");
INSERT INTO "TV_series" VALUES ("104", "Season 2, Episode 1");
INSERT INTO "TV_series" VALUES ("105", "Finale");
INSERT INTO "TV_series" VALUES ("106", "Special Episode");
INSERT INTO "TV_series" VALUES ("107", "Holiday Special");
INSERT INTO "TV_series" VALUES ("108", "Crossover Episode");
INSERT INTO "TV_series" VALUES ("109", "Clip Show");
INSERT INTO "TV_series" VALUES ("110", "Behind the Scenes");