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 "Laboratory" (
"ID" INT,
"Date" DATE,
"HCT" FLOAT,
PRIMARY KEY ("ID", "Date")
);



INSERT INTO "Laboratory" VALUES ("1", "1991-01-15", "25.5");
INSERT INTO "Laboratory" VALUES ("2", "1991-02-20", "30.1");
INSERT INTO "Laboratory" VALUES ("3", "1991-03-10", "28.0");
INSERT INTO "Laboratory" VALUES ("4", "1991-04-05", "27.3");
INSERT INTO "Laboratory" VALUES ("5", "1992-01-01", "26.0");
INSERT INTO "Laboratory" VALUES ("6", "1991-05-12", "29.0");
INSERT INTO "Laboratory" VALUES ("7", "1991-06-18", "24.9");
INSERT INTO "Laboratory" VALUES ("8", "1991-07-22", "31.5");
INSERT INTO "Laboratory" VALUES ("9", "1991-08-01", "26.8");
INSERT INTO "Laboratory" VALUES ("10", "1990-12-25", "27.5");
INSERT INTO "Laboratory" VALUES ("11", "1991-09-03", "28.5");
INSERT INTO "Laboratory" VALUES ("12", "1991-10-10", "25.0");
INSERT INTO "Laboratory" VALUES ("13", "1991-11-15", "27.0");
INSERT INTO "Laboratory" VALUES ("14", "1991-12-01", "28.9");
INSERT INTO "Laboratory" VALUES ("15", "1991-01-20", "26.5");