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),
"line_2" VARCHAR(255),
"line_3" VARCHAR(255),
"city" VARCHAR(255),
"zip_postcode" VARCHAR(20),
PRIMARY KEY ("address_id")
);





INSERT INTO "Addresses" VALUES ("1", "123 Main St", "Apt 4B", "NULL", "Anytown", "12345");
INSERT INTO "Addresses" VALUES ("2", "456 Oak Ave", "Suite 100", "NULL", "Someville", "67890");
INSERT INTO "Addresses" VALUES ("3", "789 Pine Ln", "NULL", "NULL", "Othercity", "11223");
INSERT INTO "Addresses" VALUES ("4", "101 Elm Rd", "Building C", "Floor 2", "Metropolis", "98765");
INSERT INTO "Addresses" VALUES ("5", "222 Birch Blvd", "NULL", "Rear Unit", "Smallville", "54321");
INSERT INTO "Addresses" VALUES ("6", "333 Cedar Ct", "Unit 7", "NULL", "Big City", "00000");
INSERT INTO "Addresses" VALUES ("7", "444 Maple Dr", "Basement Apt", "NULL", "Suburbia", "99999");
INSERT INTO "Addresses" VALUES ("8", "555 Willow Way", "NULL", "NULL", "Rural Town", "10101");
INSERT INTO "Addresses" VALUES ("9", "666 Poplar Pk", "Office 200", "North Wing", "Industrial Zone", "20202");
INSERT INTO "Addresses" VALUES ("10", "777 Spruce Sq", "NULL", "NULL", "Coastal City", "30303");