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,
"Original_air_date" 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.0", "Tom and Jerry", "William Hanna", "1940-02-10");
INSERT INTO "Cartoon" VALUES ("2.0", "Looney Tunes", "Chuck Jones", "1930-04-19");
INSERT INTO "Cartoon" VALUES ("3.0", "The Flintstones", "Joseph Barbera", "1960-09-30");
INSERT INTO "Cartoon" VALUES ("4.0", "Scooby-Doo, Where Are You!", "William Hanna", "1969-09-13");
INSERT INTO "Cartoon" VALUES ("5.0", "The Simpsons", "Matt Groening", "1987-04-19");
INSERT INTO "Cartoon" VALUES ("6.0", "SpongeBob SquarePants", "Stephen Hillenburg", "1999-05-01");
INSERT INTO "Cartoon" VALUES ("7.0", "Adventure Time", "Pendleton Ward", "2010-04-05");
INSERT INTO "Cartoon" VALUES ("8.0", "Gravity Falls", "Alex Hirsch", "2012-06-15");
INSERT INTO "Cartoon" VALUES ("9.0", "Rick and Morty", "Justin Roiland", "2013-12-02");
INSERT INTO "Cartoon" VALUES ("10.0", "Steven Universe", "Rebecca Sugar", "2013-11-04");
INSERT INTO "TV_Channel" VALUES ("CN", "Cartoon Network");
INSERT INTO "TV_Channel" VALUES ("NICK", "Nickelodeon");
INSERT INTO "TV_Channel" VALUES ("FOX", "Fox Broadcasting Company");
INSERT INTO "TV_Channel" VALUES ("DIS", "Disney Channel");
INSERT INTO "TV_Channel" VALUES ("ADSM", "Adult Swim");
INSERT INTO "TV_series" VALUES ("1.0", "Puss Gets the Boot", "1940-02-10");
INSERT INTO "TV_series" VALUES ("2.0", "Sinkin' in the Bathtub", "1930-04-19");
INSERT INTO "TV_series" VALUES ("3.0", "The Flintstone Flyer", "1960-09-30");
INSERT INTO "TV_series" VALUES ("4.0", "What a Night for a Knight", "1969-09-13");
INSERT INTO "TV_series" VALUES ("5.0", "Good Night", "1987-04-19");
INSERT INTO "TV_series" VALUES ("6.0", "Help Wanted", "1999-05-01");
INSERT INTO "TV_series" VALUES ("7.0", "Slumber Party Panic", "2010-04-05");
INSERT INTO "TV_series" VALUES ("8.0", "Tourist Trapped", "2012-06-15");
INSERT INTO "TV_series" VALUES ("9.0", "Pilot", "2013-12-02");
INSERT INTO "TV_series" VALUES ("10.0", "Gem Glow", "2013-11-04");