select folder_id
from cr_folders, cr_items
where parent_id = :package_id
and package_id = :package_id
and folder_id = item_id
select 1
from scorm_courses sc, acs_objects ao
where sc.scorm_course_id = ao.object_id
and ao.package_id = :package_id
and ao.title = :title
insert into cp_package
(cp_package_id)
values
(:course_id)
delete from cp_node
where cp_package_id = :course_id
select folder_id
from scorm_courses
where scorm_course_id = :course_id
update cp_package
set jsdata = :jsdata,
xmldata = :xmldata,
activitytree = :activity_tree,
global_to_system = :global_to_system
where cp_package_id = :scorm_course_id
select xmldata
from cp_package
where cp_package_id = :course_id
select folder_id
from scorm_courses
where scorm_course_id = :course_id
insert into cp_node
(cp_node_id, nodename, cp_package_id)
values
(:cp_node_id, :nodename, :cp_package_id)
insert into cp_tree
(child, depth, cp_package_id, parent, rgt)
values
(:cp_node_id, :depth, :cp_package_id, :parent, '0')
insert into cp_[string tolower ${nodename}]
([join $attributes ", "])
values
(:[join $attributes ", :"])
update cp_tree
set rgt = :rgt
where child = :cp_node_id