insert into cp_package (cp_package_id) values (:scorm_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
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, lft, cp_package_id, parent, rgt)
values
(:cp_node_id, :depth, :lft, :cp_package_id, :parent, '0')
insert into cp_[string tolower ${nodename}]
([join $attributes ", "])
values
(:[join $attributes ", :"])
update cp_tree set rgt = :lft where child = :cp_node_id