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,
"owner_id" INT,
"name" VARCHAR(50),
"age" VARCHAR(20),
"date_of_birth" DATETIME,
"date_arrived" DATETIME,
PRIMARY KEY ("dog_id"),
FOREIGN KEY ("owner_id") REFERENCES "Owners"("owner_id")
);

CREATE TABLE "Owners" (
"owner_id" INT UNIQUE,
"last_name" VARCHAR(50),
"email_address" VARCHAR(50),
PRIMARY KEY ("owner_id")
);





INSERT INTO "Owners" VALUES ("1", "Smith", "john.smith@example.com");
INSERT INTO "Owners" VALUES ("2", "Johnson", "jane.johnson@example.com");
INSERT INTO "Owners" VALUES ("3", "Williams", "bob.williams@example.com");
INSERT INTO "Owners" VALUES ("4", "Brown", "alice.brown@example.com");
INSERT INTO "Owners" VALUES ("5", "Davis", "charlie.davis@example.com");
INSERT INTO "Owners" VALUES ("6", "Miller", "diana.miller@example.com");
INSERT INTO "Owners" VALUES ("7", "Wilson", "frank.wilson@example.com");
INSERT INTO "Owners" VALUES ("8", "Moore", "grace.moore@example.com");
INSERT INTO "Owners" VALUES ("9", "Taylor", "henry.taylor@example.com");
INSERT INTO "Owners" VALUES ("10", "Anderson", "ivy.anderson@example.com");
INSERT INTO "Dogs" VALUES ("1", "1", "Buddy", "5 years", "2018-01-15 00:00:00", "2018-03-01 00:00:00");
INSERT INTO "Dogs" VALUES ("2", "2", "Lucy", "2 years", "2021-05-20 00:00:00", "2021-07-01 00:00:00");
INSERT INTO "Dogs" VALUES ("3", "3", "Max", "7 years", "2016-03-10 00:00:00", "2016-05-01 00:00:00");
INSERT INTO "Dogs" VALUES ("4", "4", "Bella", "1 year", "2022-11-01 00:00:00", "2023-01-01 00:00:00");
INSERT INTO "Dogs" VALUES ("5", "5", "Charlie", "3 years", "2020-09-05 00:00:00", "2020-11-01 00:00:00");
INSERT INTO "Dogs" VALUES ("6", "6", "Daisy", "6 months", "2023-06-15 00:00:00", "2023-08-01 00:00:00");
INSERT INTO "Dogs" VALUES ("7", "7", "Rocky", "4 years", "2019-07-25 00:00:00", "2019-09-01 00:00:00");
INSERT INTO "Dogs" VALUES ("8", "8", "Luna", "9 months", "2023-03-01 00:00:00", "2023-05-01 00:00:00");
INSERT INTO "Dogs" VALUES ("9", "9", "Cooper", "8 years", "2015-02-10 00:00:00", "2015-04-01 00:00:00");
INSERT INTO "Dogs" VALUES ("10", "10", "Molly", "1 year", "2022-10-20 00:00:00", "2022-12-01 00:00:00");
INSERT INTO "Dogs" VALUES ("11", "1", "Zoe", "6 months", "2023-06-15 00:00:00", "2023-08-10 00:00:00");
INSERT INTO "Dogs" VALUES ("12", "2", "Oliver", "6 months", "2023-06-15 00:00:00", "2023-08-15 00:00:00");
INSERT INTO "Dogs" VALUES ("13", "3", "Sophie", "6 months", "2023-06-16 00:00:00", "2023-08-05 00:00:00");