update cu_curriculums
set name = :name,
description = :description,
desc_format = :desc_format
where curriculum_id = :curriculum_id
select *
from cu_curriculums
where curriculum_id = :curriculum_id
select default_editor
from cu_default_assignees
where package_id = :package_id
select default_publisher
from cu_default_assignees
where package_id = :package_id
select first_names || ' ' || last_name || ' (' || email || ')' as name,
user_id
from cc_users
where user_id in (
select default_editor
from cu_default_assignees
where package_id = :package_id
union
select default_publisher
from cu_default_assignees
where package_id = :package_id
)
or user_id = :user_id
order by name