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

CREATE TABLE "Professionals" (
"professional_id" INT,
"state" VARCHAR(20),
"email_address" VARCHAR(50),
PRIMARY KEY ("professional_id")
);





INSERT INTO "Owners" VALUES ("1", "Hawaii", "owner1@hawaii.com", "808-555-1234");
INSERT INTO "Owners" VALUES ("2", "Wisconsin", "owner2@wisconsin.com", "414-555-5678");
INSERT INTO "Owners" VALUES ("3", "California", "owner3@california.com", "310-555-9012");
INSERT INTO "Owners" VALUES ("4", "Texas", "owner4@texas.com", "512-555-3456");
INSERT INTO "Owners" VALUES ("5", "Hawaii", "owner5@hawaii.com", "808-555-7890");
INSERT INTO "Professionals" VALUES ("1", "Hawaii", "pro1@hawaii.com");
INSERT INTO "Professionals" VALUES ("2", "Wisconsin", "pro2@wisconsin.com");
INSERT INTO "Professionals" VALUES ("3", "New York", "pro3@newyork.com");
INSERT INTO "Professionals" VALUES ("4", "Florida", "pro4@florida.com");
INSERT INTO "Professionals" VALUES ("5", "Hawaii", "pro5@hawaii.com");
INSERT INTO "Professionals" VALUES ("6", "Wisconsin", "pro6@wisconsin.com");
INSERT INTO "Professionals" VALUES ("7", "Nevada", "pro7@nevada.com");