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, 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