ALTER TABLE
    `tblcustomer_properties` ADD `property_tenant_name` VARCHAR(200) NULL DEFAULT NULL AFTER `zip`,
    ADD `property_tenant_email` VARCHAR(150) NULL DEFAULT NULL AFTER `property_tenant_name`,
    ADD `property_tenant_phone_code` VARCHAR(6) NULL DEFAULT NULL AFTER `property_tenant_email`,
    ADD `property_tenant_phone` VARCHAR(100) NULL DEFAULT NULL AFTER `property_tenant_phone_code`;