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,
"city" VARCHAR(50),
"state" VARCHAR(20),
"email_address" VARCHAR(50),
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", "Honolulu", "Hawaii", "owner1@hawaii.com");
INSERT INTO "Owners" VALUES ("2", "Madison", "Wisconsin", "owner2@wisconsin.com");
INSERT INTO "Owners" VALUES ("3", "Seattle", "Washington", "owner3@washington.com");
INSERT INTO "Owners" VALUES ("4", "Milwaukee", "Wisconsin", "owner4@wisconsin.com");
INSERT INTO "Owners" VALUES ("5", "Hilo", "Hawaii", "owner5@hawaii.com");
INSERT INTO "Owners" VALUES ("6", "Chicago", "Illinois", "owner6@illinois.com");
INSERT INTO "Professionals" VALUES ("1", "Hawaii", "pro1@hawaii.com");
INSERT INTO "Professionals" VALUES ("2", "Wisconsin", "pro2@wisconsin.com");
INSERT INTO "Professionals" VALUES ("3", "California", "pro3@california.com");
INSERT INTO "Professionals" VALUES ("4", "Hawaii", "pro4@hawaii.com");
INSERT INTO "Professionals" VALUES ("5", "Texas", "pro5@texas.com");
INSERT INTO "Professionals" VALUES ("6", "Wisconsin", "pro6@wisconsin.com");
INSERT INTO "Professionals" VALUES ("7", "Florida", "pro7@florida.com");