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

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





INSERT INTO "Owners" VALUES ("1", "Austin", "Texas");
INSERT INTO "Owners" VALUES ("2", "Dallas", "Texas");
INSERT INTO "Owners" VALUES ("3", "Miami", "Florida");
INSERT INTO "Owners" VALUES ("4", "Orlando", "Florida");
INSERT INTO "Owners" VALUES ("5", "Seattle", "Washington");
INSERT INTO "Owners" VALUES ("6", "Spokane", "Washington");
INSERT INTO "Owners" VALUES ("7", "Denver", "Colorado");
INSERT INTO "Owners" VALUES ("8", "Boulder", "Colorado");
INSERT INTO "Owners" VALUES ("9", "Phoenix", "Arizona");
INSERT INTO "Owners" VALUES ("10", "Tucson", "Arizona");
INSERT INTO "Professionals" VALUES ("101", "Houston", "Texas");
INSERT INTO "Professionals" VALUES ("102", "Jacksonville", "Florida");
INSERT INTO "Professionals" VALUES ("103", "Tacoma", "Washington");
INSERT INTO "Professionals" VALUES ("104", "Aurora", "Colorado");
INSERT INTO "Professionals" VALUES ("105", "Mesa", "Arizona");
INSERT INTO "Professionals" VALUES ("106", "Albany", "New York");
INSERT INTO "Professionals" VALUES ("107", "Raleigh", "North Carolina");
INSERT INTO "Professionals" VALUES ("108", "Madison", "Wisconsin");
INSERT INTO "Professionals" VALUES ("109", "Boise", "Idaho");
INSERT INTO "Professionals" VALUES ("110", "Salt Lake City", "Utah");