Set client_id and type columns