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,
"abandoned_yn" VARCHAR(1),
"name" VARCHAR(50),
"age" VARCHAR(20),
"date_of_birth" DATETIME,
"gender" VARCHAR(1),
"weight" VARCHAR(20),
"date_adopted" DATETIME,
PRIMARY KEY ("dog_id")
);





INSERT INTO "Dogs" VALUES ("1", "1", "Buddy", "3 years", "2020-01-15", "M", "25 lbs", "");
INSERT INTO "Dogs" VALUES ("2", "0", "Lucy", "5 years", "2018-03-20", "F", "15 lbs", "2023-01-10");
INSERT INTO "Dogs" VALUES ("3", "1", "Max", "2 years", "2021-07-01", "M", "40 lbs", "");
INSERT INTO "Dogs" VALUES ("4", "1", "Daisy", "1 year", "2022-11-10", "F", "10 lbs", "");
INSERT INTO "Dogs" VALUES ("5", "0", "Charlie", "7 years", "2016-05-25", "M", "30 lbs", "2022-11-01");
INSERT INTO "Dogs" VALUES ("6", "1", "Bella", "4 years", "2019-09-05", "F", "20 lbs", "");
INSERT INTO "Dogs" VALUES ("7", "0", "Rocky", "6 months", "2023-04-01", "M", "5 lbs", "2023-10-15");
INSERT INTO "Dogs" VALUES ("8", "1", "Luna", "8 years", "2015-02-14", "F", "50 lbs", "");
INSERT INTO "Dogs" VALUES ("9", "1", "Cooper", "1.5 years", "2022-01-20", "M", "35 lbs", "");
INSERT INTO "Dogs" VALUES ("10", "0", "Zoe", "9 years", "2014-08-12", "F", "12 lbs", "2023-03-01");
INSERT INTO "Dogs" VALUES ("11", "1", "Duke", "3 months", "2023-07-01", "M", "8 lbs", "");
INSERT INTO "Dogs" VALUES ("12", "1", "Sadie", "2.5 years", "2021-05-18", "F", "28 lbs", "");