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

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





INSERT INTO "Cartoon" VALUES ("1", "The Simpsons", "1989-12-17");
INSERT INTO "Cartoon" VALUES ("2", "Tom and Jerry", "1940-02-10");
INSERT INTO "Cartoon" VALUES ("3", "Looney Tunes", "1930-04-19");
INSERT INTO "Cartoon" VALUES ("4", "Scooby-Doo, Where Are You!", "1969-09-13");
INSERT INTO "Cartoon" VALUES ("5", "Family Guy", "1999-01-31");
INSERT INTO "Cartoon" VALUES ("6", "South Park", "1997-08-13");
INSERT INTO "Cartoon" VALUES ("7", "SpongeBob SquarePants", "1999-05-01");
INSERT INTO "Cartoon" VALUES ("8", "Adventure Time", "2010-04-05");
INSERT INTO "Cartoon" VALUES ("9", "Rick and Morty", "2013-12-02");
INSERT INTO "Cartoon" VALUES ("10", "Gravity Falls", "2012-06-15");
INSERT INTO "TV_series" VALUES ("1", "Bart Gets an 'F'", "1990-01-21", "8.5");
INSERT INTO "TV_series" VALUES ("2", "The Way We Was", "1991-01-31", "9.2");
INSERT INTO "TV_series" VALUES ("3", "Rosebud", "1993-10-21", "9.5");
INSERT INTO "TV_series" VALUES ("4", "Who Shot Mr. Burns? Part One", "1995-05-21", "9.0");
INSERT INTO "TV_series" VALUES ("5", "A Love of a Lifetime", "2005-03-20", "7.8");
INSERT INTO "TV_series" VALUES ("6", "The Itchy & Scratchy & Poochie Show", "1997-02-09", "8.0");
INSERT INTO "TV_series" VALUES ("7", "Homer's Enemy", "1997-05-04", "8.3");
INSERT INTO "TV_series" VALUES ("8", "Marge vs. the Monorail", "1993-01-14", "9.1");
INSERT INTO "TV_series" VALUES ("9", "Cape Feare", "1993-10-07", "9.4");
INSERT INTO "TV_series" VALUES ("10", "You Only Move Twice", "1996-11-03", "9.6");
INSERT INTO "TV_series" VALUES ("11", "The City of New York vs. Homer Simpson", "1997-09-21", "8.7");
INSERT INTO "TV_series" VALUES ("12", "The Principal and the Pauper", "1997-09-28", "7.5");
INSERT INTO "TV_series" VALUES ("13", "Lisa's Wedding", "1995-02-19", "8.9");
INSERT INTO "TV_series" VALUES ("14", "Treehouse of Horror V", "1994-10-30", "9.3");
INSERT INTO "TV_series" VALUES ("15", "Lemon of Troy", "1995-05-14", "8.6");