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 "Dogs" (
"dog_id" INT,
"age" VARCHAR(20),
"date_of_birth" DATETIME,
"date_arrived" DATETIME,
"date_adopted" DATETIME,
PRIMARY KEY ("dog_id")
);

CREATE TABLE "Sizes" (
"size_code" VARCHAR(10),
"size_description" VARCHAR(80),
PRIMARY KEY ("size_code")
);





INSERT INTO "Dogs" VALUES ("1", "2 years", "2021-05-10", "2021-06-01", "2023-06-01");
INSERT INTO "Dogs" VALUES ("2", "6 months", "2023-01-15", "2023-02-01", "NULL");
INSERT INTO "Dogs" VALUES ("3", "10 years", "2013-04-20", "2013-05-01", "2020-12-15");
INSERT INTO "Dogs" VALUES ("4", "3 years", "2020-03-10", "2020-04-01", "NULL");
INSERT INTO "Dogs" VALUES ("5", "1 year", "2022-07-25", "2022-08-01", "2023-05-20");
INSERT INTO "Dogs" VALUES ("6", "4 months", "2023-02-10", "2023-02-15", "NULL");
INSERT INTO "Dogs" VALUES ("7", "8 years", "2015-11-05", "2015-12-01", "2022-01-10");
INSERT INTO "Dogs" VALUES ("8", "5 years", "2018-06-30", "2018-07-15", "NULL");
INSERT INTO "Dogs" VALUES ("9", "7 years", "2016-09-12", "2016-10-01", "2021-11-20");
INSERT INTO "Dogs" VALUES ("10", "9 months", "2022-09-01", "2022-09-10", "NULL");
INSERT INTO "Sizes" VALUES ("S", "Small");
INSERT INTO "Sizes" VALUES ("M", "Medium");
INSERT INTO "Sizes" VALUES ("L", "Large");
INSERT INTO "Sizes" VALUES ("XL", "Extra Large");