insert into workflow_roles (role_id, workflow_id, short_name, pretty_name) values (:role_id, :workflow_id, :short_name, :pretty_name) select role_id from workflow_roles where workflow_id = :workflow_id and short_name = :short_name