update ec_addresses set address_type='deleted' where address_id=:address_id