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 "Cartoon" VALUES ("8.0", "Adventure Time", "2010-04-05");
INSERT INTO "Cartoon" VALUES ("9.0", "Rick and Morty", "2013-12-02");
INSERT INTO "Cartoon" VALUES ("10.0", "Gravity Falls", "2012-06-15");
INSERT INTO "TV_series" VALUES ("1.0", "Bart the Genius", "1990-01-14", "24.6");
INSERT INTO "TV_series" VALUES ("2.0", "A Love of a Lifetime", "2005-03-10", "15.2");
INSERT INTO "TV_series" VALUES ("3.0", "The Cat Concerto", "1947-04-26", "N/A");
INSERT INTO "TV_series" VALUES ("4.0", "What's Opera, Doc?", "1957-07-06", "N/A");
INSERT INTO "TV_series" VALUES ("5.0", "A Clue for Scooby Doo", "1969-09-20", "N/A");
INSERT INTO "TV_series" VALUES ("6.0", "Help Wanted", "1999-05-01", "N/A");
INSERT INTO "TV_series" VALUES ("7.0", "Death Has a Shadow", "1999-01-31", "12.8");
INSERT INTO "TV_series" VALUES ("8.0", "Cartman Gets an Anal Probe", "1997-08-13", "N/A");
INSERT INTO "TV_series" VALUES ("9.0", "Slumber Party Panic", "2010-04-05", "N/A");
INSERT INTO "TV_series" VALUES ("10.0", "Pilot", "2013-12-02", "N/A");
INSERT INTO "TV_series" VALUES ("11.0", "Tourist Trapped", "2012-06-15", "N/A");
INSERT INTO "TV_series" VALUES ("12.0", "A Love of a Lifetime", "2010-07-20", "10.5");
INSERT INTO "TV_series" VALUES ("13.0", "Another Love of a Lifetime", "2012-01-01", "8.9");