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 "Addresses" (
"address_id" INT,
"line_1" VARCHAR(255),
"city" VARCHAR(255),
"zip_postcode" VARCHAR(20),
"state_province_county" VARCHAR(255),
"country" VARCHAR(255),
PRIMARY KEY ("address_id")
);





INSERT INTO "Addresses" VALUES ("1", "123 Main St", "New York", "10001", "NY", "USA");
INSERT INTO "Addresses" VALUES ("2", "456 Oak Ave", "Los Angeles", "90001", "CA", "USA");
INSERT INTO "Addresses" VALUES ("3", "789 Pine Ln", "Chicago", "60601", "IL", "USA");
INSERT INTO "Addresses" VALUES ("4", "101 Elm Rd", "Houston", "77001", "TX", "USA");
INSERT INTO "Addresses" VALUES ("5", "202 Maple Dr", "Port Chelsea", "33333", "FL", "USA");
INSERT INTO "Addresses" VALUES ("6", "303 Birch Blvd", "London", "SW1A 0AA", "England", "UK");
INSERT INTO "Addresses" VALUES ("7", "404 Cedar Ct", "Paris", "75001", "Ile-de-France", "France");
INSERT INTO "Addresses" VALUES ("8", "505 Spruce St", "Berlin", "10115", "Berlin", "Germany");
INSERT INTO "Addresses" VALUES ("9", "606 Willow Way", "Tokyo", "100-0001", "Tokyo", "Japan");
INSERT INTO "Addresses" VALUES ("10", "707 Poplar Pl", "Sydney", "2000", "NSW", "Australia");
INSERT INTO "Addresses" VALUES ("11", "808 Aspen Apt", "Port Chelsea", "33334", "FL", "USA");
INSERT INTO "Addresses" VALUES ("12", "909 Redwood Row", "Port Chelsea", "33335", "FL", "USA");
INSERT INTO "Addresses" VALUES ("13", "111 Fir Fwy", "Port Chelsea", "33336", "FL", "USA");
INSERT INTO "Addresses" VALUES ("14", "222 Cypress Cir", "Port Chelsea", "33337", "FL", "USA");
INSERT INTO "Addresses" VALUES ("15", "333 Dogwood Dr", "Port Chelsea", "33338", "FL", "USA");