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 "Owners" (
"owner_id" INT,
"first_name" VARCHAR(50),
"last_name" VARCHAR(50),
"state" VARCHAR(20),
"zip_code" VARCHAR(20),
"email_address" VARCHAR(50),
PRIMARY KEY ("owner_id")
);

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





INSERT INTO "Owners" VALUES ("1", "John", "Smith", "North Carolina", "27514", "john.smith@example.com");
INSERT INTO "Owners" VALUES ("2", "Alice", "Johnson", "South Dakota", "57006", "alice.johnson@example.com");
INSERT INTO "Owners" VALUES ("3", "Robert", "Brown", "North Dakota", "58102", "robert.brown@example.com");
INSERT INTO "Owners" VALUES ("4", "Emily", "Davis", "California", "90001", "emily.davis@example.com");
INSERT INTO "Owners" VALUES ("5", "Michael", "Wilson", "New York", "10001", "michael.wilson@example.com");
INSERT INTO "Owners" VALUES ("6", "Jessica", "Taylor", "Northwest Territories", "X1A 1A1", "jessica.taylor@example.com");
INSERT INTO "Owners" VALUES ("7", "David", "Anderson", "Florida", "33101", "david.anderson@example.com");
INSERT INTO "Owners" VALUES ("8", "Sarah", "Thomas", "Northampton", "NN1 1AA", "sarah.thomas@example.com");
INSERT INTO "Owners" VALUES ("9", "Daniel", "Martinez", "Texas", "73301", "daniel.martinez@example.com");
INSERT INTO "Owners" VALUES ("10", "Laura", "Moore", "North Rhine-Westphalia", "40210", "laura.moore@example.com");
INSERT INTO "Professionals" VALUES ("1", "Miller");
INSERT INTO "Professionals" VALUES ("2", "Garcia");
INSERT INTO "Professionals" VALUES ("3", "Rodriguez");
INSERT INTO "Professionals" VALUES ("4", "Martinez");
INSERT INTO "Professionals" VALUES ("5", "Hernandez");