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





INSERT INTO "Cartoon" VALUES ("1.0", "The Simpsons", "1989-12-17");
INSERT INTO "Cartoon" VALUES ("2.0", "Tom and Jerry", "1940-02-10");
INSERT INTO "Cartoon" VALUES ("3.0", "Looney Tunes", "1930-04-19");
INSERT INTO "Cartoon" VALUES ("4.0", "Scooby-Doo, Where Are You!", "1969-09-13");
INSERT INTO "Cartoon" VALUES ("5.0", "SpongeBob SquarePants", "1999-05-01");
INSERT INTO "Cartoon" VALUES ("6.0", "Family Guy", "1999-01-31");
INSERT INTO "Cartoon" VALUES ("7.0", "South Park", "1997-08-13");
INSERT INTO "TV_series" VALUES ("1.0", "Pilot", "2004-09-22", "10.0");
INSERT INTO "TV_series" VALUES ("2.0", "The One Where Monica Gets a Roommate", "1994-09-22", "21.5");
INSERT INTO "TV_series" VALUES ("3.0", "A Love of a Lifetime", "2005-05-18", "23.0");
INSERT INTO "TV_series" VALUES ("4.0", "The Last One, Part 2", "2004-05-06", "52.5");
INSERT INTO "TV_series" VALUES ("5.0", "The Big Bang", "2007-09-24", "9.5");
INSERT INTO "TV_series" VALUES ("6.0", "The Staircase", "2005-03-29", "12.1");
INSERT INTO "TV_series" VALUES ("7.0", "The Finale", "2014-03-31", "18.4");
INSERT INTO "TV_series" VALUES ("8.0", "The Pilot", "2005-03-27", "16.2");
INSERT INTO "TV_series" VALUES ("9.0", "The First Day", "2006-09-25", "14.5");
INSERT INTO "TV_series" VALUES ("10.0", "The Last Episode", "2010-05-23", "13.0");