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 "TV_series" (
"id" FLOAT,
"Rating" TEXT,
"Share" FLOAT,
"18_49_Rating_Share" TEXT,
"Viewers_m" TEXT,
PRIMARY KEY ("id")
);





INSERT INTO "TV_series" VALUES ("1", "A", "0.1", "0.0/0", "0.00");
INSERT INTO "TV_series" VALUES ("2", "B", "0.2", "0.1/1", "0.01");
INSERT INTO "TV_series" VALUES ("3", "C", "0.3", "0.2/2", "0.02");
INSERT INTO "TV_series" VALUES ("4", "D", "0.4", "0.3/3", "0.03");
INSERT INTO "TV_series" VALUES ("5", "E", "0.5", "0.4/4", "0.04");
INSERT INTO "TV_series" VALUES ("6", "F", "0.6", "0.5/5", "0.05");
INSERT INTO "TV_series" VALUES ("7", "G", "0.7", "0.6/6", "0.06");
INSERT INTO "TV_series" VALUES ("8", "H", "0.8", "0.7/7", "0.07");
INSERT INTO "TV_series" VALUES ("9", "I", "0.9", "0.8/8", "0.08");
INSERT INTO "TV_series" VALUES ("10", "J", "1.0", "0.9/9", "0.09");
INSERT INTO "TV_series" VALUES ("11", "K", "0.0", "1.0/10", "0.10");