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

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





INSERT INTO "Cartoon" VALUES ("1.0", "Tom and Jerry");
INSERT INTO "Cartoon" VALUES ("2.0", "Looney Tunes");
INSERT INTO "Cartoon" VALUES ("3.0", "The Simpsons");
INSERT INTO "Cartoon" VALUES ("4.0", "Scooby-Doo");
INSERT INTO "Cartoon" VALUES ("5.0", "SpongeBob SquarePants");
INSERT INTO "Cartoon" VALUES ("6.0", "Family Guy");
INSERT INTO "Cartoon" VALUES ("7.0", "Rick and Morty");
INSERT INTO "Cartoon" VALUES ("8.0", "Adventure Time");
INSERT INTO "Cartoon" VALUES ("9.0", "Steven Universe");
INSERT INTO "Cartoon" VALUES ("10.0", "Gravity Falls");
INSERT INTO "TV_Channel" VALUES ("CNN", "USA", "English", "News", "16:9");
INSERT INTO "TV_Channel" VALUES ("BBC One", "UK", "English", "General", "16:9");
INSERT INTO "TV_Channel" VALUES ("TF1", "France", "French", "General", "16:9");
INSERT INTO "TV_Channel" VALUES ("ZDF", "Germany", "German", "General", "16:9");
INSERT INTO "TV_Channel" VALUES ("NHK", "Japan", "Japanese", "General", "4:3");
INSERT INTO "TV_Channel" VALUES ("CCTV-1", "China", "Mandarin", "General", "16:9");
INSERT INTO "TV_Channel" VALUES ("Globo", "Brazil", "Portuguese", "General", "16:9");
INSERT INTO "TV_Channel" VALUES ("TV Azteca", "Mexico", "Spanish", "General", "4:3");
INSERT INTO "TV_Channel" VALUES ("Al Jazeera", "Qatar", "Arabic", "News", "16:9");
INSERT INTO "TV_Channel" VALUES ("RT", "Russia", "Russian", "News", "16:9");
INSERT INTO "TV_Channel" VALUES ("Rai 1", "Italy", "Italian", "General", "16:9");
INSERT INTO "TV_Channel" VALUES ("SBS", "South Korea", "Korean", "General", "16:9");
INSERT INTO "TV_Channel" VALUES ("CBC", "Canada", "English", "General", "16:9");
INSERT INTO "TV_Channel" VALUES ("ABC", "Australia", "English", "General", "16:9");
INSERT INTO "TV_Channel" VALUES ("TVN", "Poland", "Polish", "General", "16:9");
INSERT INTO "TV_series" VALUES ("1.0", "Pilot");
INSERT INTO "TV_series" VALUES ("2.0", "The One With The Blackout");
INSERT INTO "TV_series" VALUES ("3.0", "The One Where Everybody Finds Out");
INSERT INTO "TV_series" VALUES ("4.0", "The Last One, Part 2");
INSERT INTO "TV_series" VALUES ("5.0", "Winter Is Coming");
INSERT INTO "TV_series" VALUES ("6.0", "The Battle of the Bastards");
INSERT INTO "TV_series" VALUES ("7.0", "The Iron Throne");
INSERT INTO "TV_series" VALUES ("8.0", "Chapter One");
INSERT INTO "TV_series" VALUES ("9.0", "The End of the F***ing World");
INSERT INTO "TV_series" VALUES ("10.0", "The Final Problem");