-- Executed on: DEV

CREATE TABLE tblcustomer_properties (
	id BIGINT PRIMARY KEY AUTO_INCREMENT NOT NULL,
    tenant_id BIGINT NOT NULL,
    client_id BIGINT NOT NULL,
    street_1 VARCHAR(255),
    street_2 VARCHAR(255),
    city VARCHAR(255),
    state VARCHAR(255),
    zip VARCHAR(15),
    country BIGINT,
    created_at datetime DEFAULT CURRENT_TIMESTAMP(),
    updated_at datetime DEFAULT CURRENT_TIMESTAMP()
);
ALTER TABLE `tblclients` ADD `billing_street2` VARCHAR(200) NULL DEFAULT NULL AFTER `billing_street`;