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

CREATE TABLE "Owners" (
"owner_id" INT,
"first_name" VARCHAR(50),
PRIMARY KEY ("owner_id")
);





INSERT INTO "Dogs" VALUES ("1", "Buddy", "5", "2018-01-15");
INSERT INTO "Dogs" VALUES ("2", "Lucy", "3", "2020-03-20");
INSERT INTO "Dogs" VALUES ("3", "Max", "7", "2016-05-10");
INSERT INTO "Dogs" VALUES ("4", "Daisy", "2", "2021-07-01");
INSERT INTO "Dogs" VALUES ("5", "Charlie", "6", "2017-09-25");
INSERT INTO "Dogs" VALUES ("6", "Bella", "4", "2019-11-12");
INSERT INTO "Dogs" VALUES ("7", "Rocky", "8", "2015-02-28");
INSERT INTO "Dogs" VALUES ("8", "Luna", "1", "2022-04-05");
INSERT INTO "Dogs" VALUES ("9", "Cooper", "5", "2018-06-18");
INSERT INTO "Dogs" VALUES ("10", "Zoe", "3", "2020-08-01");
INSERT INTO "Dogs" VALUES ("11", "Milo", "9", "2014-10-03");
INSERT INTO "Dogs" VALUES ("12", "Sophie", "2", "2021-12-14");
INSERT INTO "Dogs" VALUES ("13", "Bear", "6", "2017-03-07");
INSERT INTO "Dogs" VALUES ("14", "Ruby", "4", "2019-05-22");
INSERT INTO "Dogs" VALUES ("15", "Duke", "7", "2016-07-09");
INSERT INTO "Owners" VALUES ("1", "Alice");
INSERT INTO "Owners" VALUES ("2", "Bob");
INSERT INTO "Owners" VALUES ("3", "Charlie");
INSERT INTO "Owners" VALUES ("4", "Diana");
INSERT INTO "Owners" VALUES ("5", "Eve");
INSERT INTO "Owners" VALUES ("6", "Frank");
INSERT INTO "Owners" VALUES ("7", "Grace");
INSERT INTO "Owners" VALUES ("8", "Henry");
INSERT INTO "Owners" VALUES ("9", "Ivy");
INSERT INTO "Owners" VALUES ("10", "Jack");