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),
"zip_code" 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", "73301");
INSERT INTO "Owners" VALUES ("2", "Dallas", "Texas", "75201");
INSERT INTO "Owners" VALUES ("3", "Miami", "Florida", "33101");
INSERT INTO "Owners" VALUES ("4", "Orlando", "Florida", "32801");
INSERT INTO "Owners" VALUES ("5", "Seattle", "Washington", "98101");
INSERT INTO "Owners" VALUES ("6", "Spokane", "Washington", "99201");
INSERT INTO "Owners" VALUES ("7", "Denver", "Colorado", "80201");
INSERT INTO "Owners" VALUES ("8", "Boulder", "Colorado", "80301");
INSERT INTO "Owners" VALUES ("9", "Phoenix", "Arizona", "85001");
INSERT INTO "Owners" VALUES ("10", "Tucson", "Arizona", "85701");
INSERT INTO "Owners" VALUES ("11", "Albany", "New York", "12201");
INSERT INTO "Owners" VALUES ("12", "Buffalo", "New York", "14201");
INSERT INTO "Owners" VALUES ("13", "Portland", "Oregon", "97201");
INSERT INTO "Owners" VALUES ("14", "Salem", "Oregon", "97301");
INSERT INTO "Owners" VALUES ("15", "Las Vegas", "Nevada", "88901");
INSERT INTO "Professionals" VALUES ("1", "Houston", "Texas");
INSERT INTO "Professionals" VALUES ("2", "San Antonio", "Texas");
INSERT INTO "Professionals" VALUES ("3", "Tampa", "Florida");
INSERT INTO "Professionals" VALUES ("4", "Jacksonville", "Florida");
INSERT INTO "Professionals" VALUES ("5", "Tacoma", "Washington");
INSERT INTO "Professionals" VALUES ("6", "Olympia", "Washington");
INSERT INTO "Professionals" VALUES ("7", "Colorado Springs", "Colorado");
INSERT INTO "Professionals" VALUES ("8", "Fort Collins", "Colorado");
INSERT INTO "Professionals" VALUES ("9", "Mesa", "Arizona");
INSERT INTO "Professionals" VALUES ("10", "Scottsdale", "Arizona");
INSERT INTO "Professionals" VALUES ("11", "Syracuse", "New York");
INSERT INTO "Professionals" VALUES ("12", "Rochester", "New York");
INSERT INTO "Professionals" VALUES ("13", "Eugene", "Oregon");
INSERT INTO "Professionals" VALUES ("14", "Medford", "Oregon");
INSERT INTO "Professionals" VALUES ("15", "Reno", "Nevada");
INSERT INTO "Professionals" VALUES ("16", "Carson City", "Nevada");
INSERT INTO "Professionals" VALUES ("17", "Anchorage", "Alaska");