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", "HI", "owner1@example.com");
INSERT INTO "Owners" VALUES ("2", "Milwaukee", "WI", "owner2@example.com");
INSERT INTO "Owners" VALUES ("3", "Los Angeles", "CA", "owner3@example.com");
INSERT INTO "Owners" VALUES ("4", "Madison", "WI", "owner4@example.com");
INSERT INTO "Owners" VALUES ("5", "Kailua", "HI", "owner5@example.com");
INSERT INTO "Owners" VALUES ("6", "New York", "NY", "owner6@example.com");
INSERT INTO "Owners" VALUES ("7", "Green Bay", "WI", "owner7@example.com");
INSERT INTO "Owners" VALUES ("8", "San Francisco", "CA", "owner8@example.com");
INSERT INTO "Owners" VALUES ("9", "Hilo", "HI", "owner9@example.com");
INSERT INTO "Owners" VALUES ("10", "Chicago", "IL", "owner10@example.com");
INSERT INTO "Professionals" VALUES ("1", "HI", "prof1@example.com");
INSERT INTO "Professionals" VALUES ("2", "WI", "prof2@example.com");
INSERT INTO "Professionals" VALUES ("3", "CA", "prof3@example.com");
INSERT INTO "Professionals" VALUES ("4", "WI", "prof4@example.com");
INSERT INTO "Professionals" VALUES ("5", "HI", "prof5@example.com");
INSERT INTO "Professionals" VALUES ("6", "NY", "prof6@example.com");
INSERT INTO "Professionals" VALUES ("7", "WI", "prof7@example.com");
INSERT INTO "Professionals" VALUES ("8", "CA", "prof8@example.com");
INSERT INTO "Professionals" VALUES ("9", "HI", "prof9@example.com");
INSERT INTO "Professionals" VALUES ("10", "IL", "prof10@example.com");
INSERT INTO "Professionals" VALUES ("11", "FL", "prof11@example.com");
INSERT INTO "Professionals" VALUES ("12", "TX", "prof12@example.com");
INSERT INTO "Professionals" VALUES ("13", "WI", "prof13@example.com");
INSERT INTO "Professionals" VALUES ("14", "HI", "prof14@example.com");
INSERT INTO "Professionals" VALUES ("15", "OR", "prof15@example.com");