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),
"email_address" VARCHAR(50),
PRIMARY KEY ("owner_id")
);

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





INSERT INTO "Owners" VALUES ("1", "Alice", "Johnson", "North Carolina", "alice.johnson@example.com");
INSERT INTO "Owners" VALUES ("2", "Bob", "Smith", "South Carolina", "bob.smith@example.com");
INSERT INTO "Owners" VALUES ("3", "Carol", "Williams", "North Dakota", "carol.williams@example.com");
INSERT INTO "Owners" VALUES ("4", "David", "Brown", "California", "david.brown@example.com");
INSERT INTO "Owners" VALUES ("5", "Eve", "Davis", "New York", "eve.davis@example.com");
INSERT INTO "Owners" VALUES ("6", "Frank", "Miller", "Northampton", "frank.miller@example.com");
INSERT INTO "Owners" VALUES ("7", "Grace", "Wilson", "Florida", "grace.wilson@example.com");
INSERT INTO "Owners" VALUES ("8", "Hank", "Moore", "Northwest Territories", "hank.moore@example.com");
INSERT INTO "Owners" VALUES ("9", "Ivy", "Taylor", "Texas", "ivy.taylor@example.com");
INSERT INTO "Owners" VALUES ("10", "Jack", "Anderson", "Ohio", "jack.anderson@example.com");
INSERT INTO "Professionals" VALUES ("1", "Laura", "Northampton", "King");
INSERT INTO "Professionals" VALUES ("2", "Mike", "Charlotte", "Scott");
INSERT INTO "Professionals" VALUES ("3", "Nina", "Fargo", "Adams");
INSERT INTO "Professionals" VALUES ("4", "Oscar", "Raleigh", "Baker");
INSERT INTO "Professionals" VALUES ("5", "Pam", "Austin", "Clark");
INSERT INTO "Professionals" VALUES ("6", "Quinn", "Seattle", "Evans");
INSERT INTO "Professionals" VALUES ("7", "Rachel", "Bismarck", "Green");
INSERT INTO "Professionals" VALUES ("8", "Steve", "Tallahassee", "Hill");
INSERT INTO "Professionals" VALUES ("9", "Tina", "Anchorage", "Johnson");
INSERT INTO "Professionals" VALUES ("10", "Uma", "Denver", "Lewis");