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_series" (
"id" FLOAT,
"Episode" TEXT,
"Air_Date" TEXT,
"Rating" TEXT,
"Viewers_m" TEXT,
PRIMARY KEY ("id")
);





INSERT INTO "Cartoon" VALUES ("1.0", "1999-01-01");
INSERT INTO "Cartoon" VALUES ("2.0", "2005-03-15");
INSERT INTO "Cartoon" VALUES ("3.0", "2010-07-22");
INSERT INTO "Cartoon" VALUES ("4.0", "1995-11-01");
INSERT INTO "Cartoon" VALUES ("5.0", "2008-09-10");
INSERT INTO "Cartoon" VALUES ("6.0", "2012-04-05");
INSERT INTO "Cartoon" VALUES ("7.0", "2001-02-28");
INSERT INTO "Cartoon" VALUES ("8.0", "2015-06-19");
INSERT INTO "Cartoon" VALUES ("9.0", "1998-12-12");
INSERT INTO "Cartoon" VALUES ("10.0", "2003-08-08");
INSERT INTO "TV_series" VALUES ("1.0", "Pilot", "1999-01-01", "8.5", "12.3");
INSERT INTO "TV_series" VALUES ("2.0", "The New Beginning", "2005-03-15", "9.1", "15.7");
INSERT INTO "TV_series" VALUES ("3.0", "Final Showdown", "2010-07-22", "9.5", "18.2");
INSERT INTO "TV_series" VALUES ("4.0", "First Steps", "1995-11-01", "7.9", "10.1");
INSERT INTO "TV_series" VALUES ("5.0", "Unexpected Twist", "2008-09-10", "8.8", "14.5");
INSERT INTO "TV_series" VALUES ("6.0", "The Great Escape", "2012-04-05", "9.2", "16.8");
INSERT INTO "TV_series" VALUES ("7.0", "Lost in Time", "2001-02-28", "8.2", "11.9");
INSERT INTO "TV_series" VALUES ("8.0", "Return of the Hero", "2015-06-19", "9.0", "17.0");
INSERT INTO "TV_series" VALUES ("9.0", "A New Friend", "1998-12-12", "7.5", "9.8");
INSERT INTO "TV_series" VALUES ("10.0", "The Secret Revealed", "2003-08-08", "8.7", "13.0");
INSERT INTO "TV_series" VALUES ("11.0", "The Last Stand", "2016-01-20", "9.5", "19.0");
INSERT INTO "TV_series" VALUES ("12.0", "The Reckoning", "2017-03-01", "9.3", "17.5");
INSERT INTO "TV_series" VALUES ("13.0", "The Awakening", "2018-05-15", "9.4", "18.0");
INSERT INTO "TV_series" VALUES ("14.0", "The Prophecy", "2019-07-10", "9.2", "16.5");
INSERT INTO "TV_series" VALUES ("15.0", "The Journey Home", "2020-09-25", "9.1", "15.0");
INSERT INTO "TV_series" VALUES ("16.0", "The Beginning of the End", "2021-11-11", "9.6", "20.0");
INSERT INTO "TV_series" VALUES ("17.0", "The Final Chapter", "2022-01-01", "9.7", "21.0");
INSERT INTO "TV_series" VALUES ("18.0", "The Legacy", "2023-03-03", "9.8", "22.0");
INSERT INTO "TV_series" VALUES ("19.0", "The New Era", "2024-05-05", "9.9", "23.0");
INSERT INTO "TV_series" VALUES ("20.0", "The Ultimate Sacrifice", "2025-07-07", "10.0", "24.0");