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", "SpongeBob SquarePants", "1999-05-01");
INSERT INTO "Cartoon" VALUES ("6", "Family Guy", "1999-01-31");
INSERT INTO "Cartoon" VALUES ("7", "South Park", "1997-08-13");
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", "Pilot", "2004-09-22", "1");
INSERT INTO "TV_series" VALUES ("2", "The One Where Monica Gets a Roommate", "1994-09-22", "2");
INSERT INTO "TV_series" VALUES ("3", "Winter Is Coming", "2011-04-17", "3");
INSERT INTO "TV_series" VALUES ("4", "A Love of a Lifetime", "2005-03-08", "5");
INSERT INTO "TV_series" VALUES ("5", "The Big Bran Hypothesis", "2007-09-24", "4");
INSERT INTO "TV_series" VALUES ("6", "The Gang Gets Cereal", "2005-08-04", "6");
INSERT INTO "TV_series" VALUES ("7", "The National Anthem", "2011-12-04", "7");
INSERT INTO "TV_series" VALUES ("8", "The Eleventh Hour", "2010-04-03", "8");
INSERT INTO "TV_series" VALUES ("9", "Rose", "2005-03-26", "9");
INSERT INTO "TV_series" VALUES ("10", "The Reichenbach Fall", "2012-01-15", "10");
INSERT INTO "TV_series" VALUES ("11", "A Love of a Lifetime", "2010-07-15", "12");
INSERT INTO "TV_series" VALUES ("12", "Another Episode", "2008-11-20", "15");