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", "Springfield", "12345", "IL", "USA");
INSERT INTO "Addresses" VALUES ("2", "456 Oak Ave", "Port Chelsea", "67890", "NY", "USA");
INSERT INTO "Addresses" VALUES ("3", "789 Pine Ln", "Rivertown", "11223", "CA", "USA");
INSERT INTO "Addresses" VALUES ("4", "101 Elm Rd", "Port Chelsea", "98765", "FL", "USA");
INSERT INTO "Addresses" VALUES ("5", "222 Birch Blvd", "Metropolis", "54321", "TX", "USA");
INSERT INTO "Addresses" VALUES ("6", "333 Cedar Ct", "Port Chelsea", "00000", "WA", "USA");
INSERT INTO "Addresses" VALUES ("7", "444 Maple Dr", "Gotham", "99999", "NY", "USA");
INSERT INTO "Addresses" VALUES ("8", "555 Willow Way", "Port Chelsea", "13579", "GA", "USA");
INSERT INTO "Addresses" VALUES ("9", "666 Spruce Sq", "Smallville", "24680", "KS", "USA");
INSERT INTO "Addresses" VALUES ("10", "777 Poplar Pk", "Port Chelsea", "86420", "OR", "USA");