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

CREATE TABLE "TV_series" (
"id" FLOAT,
"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", "English", "Comedy");
INSERT INTO "TV_Channel" VALUES ("CH02", "Rick and Morty", "English", "Sci-Fi");
INSERT INTO "TV_Channel" VALUES ("CH03", "Gravity Falls", "English", "Mystery");
INSERT INTO "TV_Channel" VALUES ("CH04", "BoJack Horseman", "English", "Drama");
INSERT INTO "TV_Channel" VALUES ("CH05", "Steven Universe", "English", "Fantasy");
INSERT INTO "TV_Channel" VALUES ("CH06", "Rick and Morty", "Spanish", "Sci-Fi");
INSERT INTO "TV_Channel" VALUES ("CH07", "Adventure Time", "French", "Comedy");
INSERT INTO "TV_Channel" VALUES ("CH08", "Gravity Falls", "French", "Mystery");
INSERT INTO "TV_Channel" VALUES ("CH09", "BoJack Horseman", "German", "Drama");
INSERT INTO "TV_Channel" VALUES ("CH10", "Steven Universe", "German", "Fantasy");
INSERT INTO "TV_Channel" VALUES ("CH11", "New Series", "English", "Documentary");
INSERT INTO "TV_Channel" VALUES ("CH12", "New Series", "English", "Documentary");
INSERT INTO "TV_series" VALUES ("1", "8.5");
INSERT INTO "TV_series" VALUES ("2", "9.2");
INSERT INTO "TV_series" VALUES ("3", "8.8");
INSERT INTO "TV_series" VALUES ("4", "8.0");
INSERT INTO "TV_series" VALUES ("5", "8.7");
INSERT INTO "TV_series" VALUES ("6", "7.5");