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 "Breeds" (
"breed_code" VARCHAR(10),
"breed_name" VARCHAR(80),
PRIMARY KEY ("breed_code")
);

CREATE TABLE "Dogs" (
"dog_id" INT,
"name" VARCHAR(50),
PRIMARY KEY ("dog_id")
);

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

CREATE TABLE "Professionals" (
"professional_id" INT,
"first_name" VARCHAR(50),
"last_name" VARCHAR(50),
PRIMARY KEY ("professional_id")
);





INSERT INTO "Breeds" VALUES ("LAB", "Labrador Retriever");
INSERT INTO "Breeds" VALUES ("GER", "German Shepherd");
INSERT INTO "Breeds" VALUES ("GOL", "Golden Retriever");
INSERT INTO "Breeds" VALUES ("POO", "Poodle");
INSERT INTO "Breeds" VALUES ("BUL", "Bulldog");
INSERT INTO "Breeds" VALUES ("BEA", "Beagle");
INSERT INTO "Breeds" VALUES ("DACH", "Dachshund");
INSERT INTO "Breeds" VALUES ("ROT", "Rottweiler");
INSERT INTO "Breeds" VALUES ("BOX", "Boxer");
INSERT INTO "Breeds" VALUES ("HUS", "Siberian Husky");
INSERT INTO "Dogs" VALUES ("1", "Buddy");
INSERT INTO "Dogs" VALUES ("2", "Max");
INSERT INTO "Dogs" VALUES ("3", "Bella");
INSERT INTO "Dogs" VALUES ("4", "Lucy");
INSERT INTO "Dogs" VALUES ("5", "Charlie");
INSERT INTO "Dogs" VALUES ("6", "Daisy");
INSERT INTO "Dogs" VALUES ("7", "Cooper");
INSERT INTO "Dogs" VALUES ("8", "Luna");
INSERT INTO "Dogs" VALUES ("9", "Rocky");
INSERT INTO "Dogs" VALUES ("10", "Sadie");
INSERT INTO "Dogs" VALUES ("11", "Milo");
INSERT INTO "Dogs" VALUES ("12", "Zoe");
INSERT INTO "Dogs" VALUES ("13", "Oliver");
INSERT INTO "Dogs" VALUES ("14", "Lily");
INSERT INTO "Dogs" VALUES ("15", "Leo");
INSERT INTO "Dogs" VALUES ("16", "Chloe");
INSERT INTO "Dogs" VALUES ("17", "Jack");
INSERT INTO "Dogs" VALUES ("18", "Sophie");
INSERT INTO "Dogs" VALUES ("19", "Duke");
INSERT INTO "Dogs" VALUES ("20", "Ruby");
INSERT INTO "Owners" VALUES ("1", "John", "Doe");
INSERT INTO "Owners" VALUES ("2", "Jane", "Smith");
INSERT INTO "Owners" VALUES ("3", "Michael", "Johnson");
INSERT INTO "Owners" VALUES ("4", "Emily", "Davis");
INSERT INTO "Owners" VALUES ("5", "David", "Brown");
INSERT INTO "Owners" VALUES ("6", "Sarah", "Miller");
INSERT INTO "Owners" VALUES ("7", "Chris", "Wilson");
INSERT INTO "Owners" VALUES ("8", "Jessica", "Moore");
INSERT INTO "Owners" VALUES ("9", "Daniel", "Taylor");
INSERT INTO "Owners" VALUES ("10", "Ashley", "Anderson");
INSERT INTO "Owners" VALUES ("11", "Max", "White");
INSERT INTO "Owners" VALUES ("12", "Bella", "Green");
INSERT INTO "Owners" VALUES ("13", "Charlie", "Black");
INSERT INTO "Owners" VALUES ("14", "Lucy", "King");
INSERT INTO "Owners" VALUES ("15", "Oliver", "Wright");
INSERT INTO "Professionals" VALUES ("1", "Robert", "Clark");
INSERT INTO "Professionals" VALUES ("2", "Linda", "Hall");
INSERT INTO "Professionals" VALUES ("3", "William", "Allen");
INSERT INTO "Professionals" VALUES ("4", "Elizabeth", "Young");
INSERT INTO "Professionals" VALUES ("5", "James", "Hernandez");
INSERT INTO "Professionals" VALUES ("6", "Patricia", "Lewis");
INSERT INTO "Professionals" VALUES ("7", "Richard", "Scott");
INSERT INTO "Professionals" VALUES ("8", "Jennifer", "Hill");
INSERT INTO "Professionals" VALUES ("9", "Charles", "Adams");
INSERT INTO "Professionals" VALUES ("10", "Susan", "Baker");
INSERT INTO "Professionals" VALUES ("11", "Buddy", "Fisher");
INSERT INTO "Professionals" VALUES ("12", "Daisy", "Cook");
INSERT INTO "Professionals" VALUES ("13", "Luna", "Morgan");
INSERT INTO "Professionals" VALUES ("14", "Rocky", "Bell");
INSERT INTO "Professionals" VALUES ("15", "Sadie", "Carter");