ALTER TABLE `tblcustomer_properties` ADD `gate_code` VARCHAR(200) NULL DEFAULT NULL AFTER `zip`, ADD `lockbox_code` VARCHAR(200) NULL DEFAULT NULL AFTER `gate_code`;

CREATE TABLE tblestimate_request_changes (
    id BIGINT UNSIGNED PRIMARY KEY NOT NULL AUTO_INCREMENT,
    tenant_id BIGINT UNSIGNED NOT NULL,
    estimate_id BIGINT UNSIGNED NOT NULL,
    request_comment TEXT NOT NULL,
    addedon DATETIME NOT NULL
);