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,
"street" 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", "123 Main St", "CA");
INSERT INTO "Owners" VALUES ("2", "456 Oak Ave", "NY");
INSERT INTO "Owners" VALUES ("3", "789 Pine Ln", "CA");
INSERT INTO "Owners" VALUES ("4", "101 Elm Rd", "TX");
INSERT INTO "Owners" VALUES ("5", "202 Birch Blvd", "FL");
INSERT INTO "Owners" VALUES ("6", "303 Cedar Dr", "NY");
INSERT INTO "Owners" VALUES ("7", "404 Maple Ct", "WA");
INSERT INTO "Owners" VALUES ("8", "505 Spruce Pkwy", "OR");
INSERT INTO "Owners" VALUES ("9", "606 Willow Way", "CA");
INSERT INTO "Owners" VALUES ("10", "707 Poplar Pl", "TX");
INSERT INTO "Professionals" VALUES ("1", "Los Angeles", "CA", "90001");
INSERT INTO "Professionals" VALUES ("2", "New York", "NY", "10001");
INSERT INTO "Professionals" VALUES ("3", "San Francisco", "CA", "94101");
INSERT INTO "Professionals" VALUES ("4", "Houston", "TX", "77001");
INSERT INTO "Professionals" VALUES ("5", "Miami", "FL", "33101");
INSERT INTO "Professionals" VALUES ("6", "Albany", "NY", "12201");
INSERT INTO "Professionals" VALUES ("7", "Seattle", "WA", "98101");
INSERT INTO "Professionals" VALUES ("8", "Portland", "OR", "97201");
INSERT INTO "Professionals" VALUES ("9", "Austin", "TX", "78701");
INSERT INTO "Professionals" VALUES ("10", "Sacramento", "CA", "95814");
INSERT INTO "Professionals" VALUES ("11", "Chicago", "IL", "60601");
INSERT INTO "Professionals" VALUES ("12", "Boston", "MA", "02108");