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

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





INSERT INTO "Cartoon" VALUES ("1", "SpongeBob SquarePants");
INSERT INTO "Cartoon" VALUES ("2", "The Simpsons");
INSERT INTO "Cartoon" VALUES ("3", "Tom and Jerry");
INSERT INTO "Cartoon" VALUES ("4", "Looney Tunes");
INSERT INTO "Cartoon" VALUES ("5", "Scooby-Doo, Where Are You!");
INSERT INTO "Cartoon" VALUES ("6", "Family Guy");
INSERT INTO "Cartoon" VALUES ("7", "South Park");
INSERT INTO "Cartoon" VALUES ("8", "Adventure Time");
INSERT INTO "Cartoon" VALUES ("9", "Rick and Morty");
INSERT INTO "Cartoon" VALUES ("10", "Avatar: The Last Airbender");
INSERT INTO "TV_series" VALUES ("1", "Pilot", "1999-05-01", "9.5", "2.5");
INSERT INTO "TV_series" VALUES ("2", "Treehouse of Horror V", "1994-10-30", "9.8", "22.2");
INSERT INTO "TV_series" VALUES ("3", "The Cat Concerto", "1947-04-26", "9.2", "N/A");
INSERT INTO "TV_series" VALUES ("4", "What's Opera, Doc?", "1957-10-06", "9.9", "N/A");
INSERT INTO "TV_series" VALUES ("5", "A Clue for Scooby Doo", "1969-09-13", "8.7", "N/A");
INSERT INTO "TV_series" VALUES ("6", "Road to Rhode Island", "2000-11-07", "9.0", "14.9");
INSERT INTO "TV_series" VALUES ("7", "Band in China", "2019-10-02", "8.5", "0.9");
INSERT INTO "TV_series" VALUES ("8", "Finn the Human", "2012-07-16", "9.3", "3.4");
INSERT INTO "TV_series" VALUES ("9", "The Ricklantis Mixup", "2017-07-30", "9.7", "2.3");
INSERT INTO "TV_series" VALUES ("10", "The Crossroads of Destiny", "2006-12-01", "9.6", "4.4");
INSERT INTO "TV_series" VALUES ("11", "Pizza Delivery", "1999-08-14", "9.1", "2.8");
INSERT INTO "TV_series" VALUES ("12", "Marge vs. the Monorail", "1993-01-14", "9.9", "21.0");
INSERT INTO "TV_series" VALUES ("13", "The Two Mouseketeers", "1952-03-15", "9.0", "N/A");
INSERT INTO "TV_series" VALUES ("14", "Rabbit of Seville", "1950-12-16", "9.6", "N/A");
INSERT INTO "TV_series" VALUES ("15", "The Headless Horseman of Halloween", "1976-10-23", "8.9", "N/A");
INSERT INTO "TV_series" VALUES ("16", "Stewie Kills Lois", "2007-11-04", "9.4", "10.0");
INSERT INTO "TV_series" VALUES ("17", "Scott Tenorman Must Die", "2001-07-11", "9.5", "3.5");
INSERT INTO "TV_series" VALUES ("18", "I Remember You", "2012-10-15", "9.8", "2.9");
INSERT INTO "TV_series" VALUES ("19", "Total Rickall", "2015-08-16", "9.6", "2.1");
INSERT INTO "TV_series" VALUES ("20", "Zuko Alone", "2006-05-12", "9.7", "4.1");