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

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





INSERT INTO "Cartoon" VALUES ("1", "Adventure Time");
INSERT INTO "Cartoon" VALUES ("2", "Rick and Morty");
INSERT INTO "Cartoon" VALUES ("3", "Gravity Falls");
INSERT INTO "Cartoon" VALUES ("4", "BoJack Horseman");
INSERT INTO "Cartoon" VALUES ("5", "Steven Universe");
INSERT INTO "TV_Channel" VALUES ("CH01", "Adventure Time", "Animated fantasy series");
INSERT INTO "TV_Channel" VALUES ("CH02", "Rick and Morty", "Adult animated sci-fi");
INSERT INTO "TV_Channel" VALUES ("CH03", "Gravity Falls", "Mystery comedy");
INSERT INTO "TV_Channel" VALUES ("CH04", "BoJack Horseman", "Adult animated comedy-drama");
INSERT INTO "TV_Channel" VALUES ("CH05", "Steven Universe", "Animated musical fantasy");
INSERT INTO "TV_Channel" VALUES ("CH06", "Adventure Time", "Animated fantasy series");
INSERT INTO "TV_Channel" VALUES ("CH07", "Rick and Morty", "Adult animated sci-fi");
INSERT INTO "TV_Channel" VALUES ("CH08", "The Simpsons", "Animated sitcom");
INSERT INTO "TV_Channel" VALUES ("CH09", "The Simpsons", "Animated sitcom");
INSERT INTO "TV_Channel" VALUES ("CH10", "Futurama", "Animated sci-fi comedy");
INSERT INTO "TV_series" VALUES ("101", "S1E1", "8.5");
INSERT INTO "TV_series" VALUES ("102", "S1E2", "8.7");
INSERT INTO "TV_series" VALUES ("103", "S2E1", "9.0");
INSERT INTO "TV_series" VALUES ("104", "S2E2", "8.9");
INSERT INTO "TV_series" VALUES ("105", "S3E1", "9.2");
INSERT INTO "TV_series" VALUES ("106", "S3E2", "9.1");
INSERT INTO "TV_series" VALUES ("107", "S4E1", "8.8");
INSERT INTO "TV_series" VALUES ("108", "S4E2", "8.6");
INSERT INTO "TV_series" VALUES ("109", "S5E1", "9.3");
INSERT INTO "TV_series" VALUES ("110", "S5E2", "9.4");