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

CREATE TABLE "TV_Channel" (
"id" TEXT,
"Country" TEXT,
"Language" TEXT,
"Pixel_aspect_ratio_PAR" TEXT,
PRIMARY KEY ("id")
);

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





INSERT INTO "TV_Channel" VALUES ("CH001", "United States", "Spanish", "16:9");
INSERT INTO "TV_Channel" VALUES ("CH002", "France", "French", "4:3");
INSERT INTO "TV_Channel" VALUES ("CH003", "Germany", "German", "16:9");
INSERT INTO "TV_Channel" VALUES ("CH004", "Japan", "Japanese", "21:9");
INSERT INTO "TV_Channel" VALUES ("CH005", "Brazil", "Portuguese", "16:9");
INSERT INTO "TV_Channel" VALUES ("CH006", "India", "Hindi", "4:3");
INSERT INTO "TV_Channel" VALUES ("CH007", "Russia", "Russian", "16:10");
INSERT INTO "TV_Channel" VALUES ("CH008", "South Korea", "Korean", "16:9");
INSERT INTO "TV_Channel" VALUES ("CH009", "Canada", "English", "16:9");
INSERT INTO "TV_Channel" VALUES ("CH010", "Mexico", "Spanish", "4:3");
INSERT INTO "TV_Channel" VALUES ("CH011", "Egypt", "Arabic", "NULL");
INSERT INTO "TV_Channel" VALUES ("CH012", "Sweden", "Swedish", "5:4");
INSERT INTO "TV_Channel" VALUES ("CH013", "Netherlands", "Dutch", "16:9");
INSERT INTO "TV_Channel" VALUES ("CH014", "China", "Mandarin", "16:9");
INSERT INTO "TV_Channel" VALUES ("CH015", "Finland", "Finnish", "NULL");
INSERT INTO "TV_Channel" VALUES ("CH016", "Norway", "Norwegian", "16:9");
INSERT INTO "TV_Channel" VALUES ("CH017", "Poland", "Polish", "4:3");
INSERT INTO "TV_Channel" VALUES ("CH018", "Turkey", "Turkish", "16:9");
INSERT INTO "TV_Channel" VALUES ("CH019", "Greece", "Greek", "21:9");
INSERT INTO "TV_Channel" VALUES ("CH020", "Italy", "Italian", "16:9");
INSERT INTO "TV_Channel" VALUES ("CH021", "Belgium", "French", "16:9");
INSERT INTO "TV_Channel" VALUES ("CH022", "Belgium", "Dutch", "4:3");
INSERT INTO "TV_Channel" VALUES ("CH023", "United Kingdom", "English", "16:9");
INSERT INTO "TV_Channel" VALUES ("CH024", "Ireland", "English", "NULL");
INSERT INTO "TV_Channel" VALUES ("CH025", "Morocco", "Arabic", "16:9");
INSERT INTO "TV_Channel" VALUES ("CH026", "South Africa", "Zulu", "16:9");
INSERT INTO "TV_Channel" VALUES ("CH027", "South Africa", "English", "4:3");
INSERT INTO "TV_Channel" VALUES ("CH028", "Argentina", "Spanish", "16:9");
INSERT INTO "TV_Channel" VALUES ("CH029", "Chile", "Spanish", "4:3");
INSERT INTO "TV_Channel" VALUES ("CH030", "New Zealand", "Maori", "NULL");