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),
"zip_code" VARCHAR(20),
PRIMARY KEY ("professional_id")
);





INSERT INTO "Owners" VALUES ("1", "Los Angeles", "CA");
INSERT INTO "Owners" VALUES ("2", "New York", "NY");
INSERT INTO "Owners" VALUES ("3", "Chicago", "IL");
INSERT INTO "Owners" VALUES ("4", "Houston", "TX");
INSERT INTO "Owners" VALUES ("5", "Phoenix", "AZ");
INSERT INTO "Owners" VALUES ("6", "Philadelphia", "PA");
INSERT INTO "Owners" VALUES ("7", "San Antonio", "TX");
INSERT INTO "Owners" VALUES ("8", "San Diego", "CA");
INSERT INTO "Owners" VALUES ("9", "Dallas", "TX");
INSERT INTO "Owners" VALUES ("10", "San Jose", "CA");
INSERT INTO "Professionals" VALUES ("1", "Los Angeles", "CA", "90001");
INSERT INTO "Professionals" VALUES ("2", "New York", "NY", "10001");
INSERT INTO "Professionals" VALUES ("3", "Chicago", "IL", "60601");
INSERT INTO "Professionals" VALUES ("4", "Miami", "FL", "33101");
INSERT INTO "Professionals" VALUES ("5", "Seattle", "WA", "98101");
INSERT INTO "Professionals" VALUES ("6", "Philadelphia", "PA", "19101");
INSERT INTO "Professionals" VALUES ("7", "Boston", "MA", "02101");
INSERT INTO "Professionals" VALUES ("8", "San Diego", "CA", "92101");
INSERT INTO "Professionals" VALUES ("9", "Denver", "CO", "80201");
INSERT INTO "Professionals" VALUES ("10", "Austin", "TX", "73301");