postgresql7.1 select ims_manifest__new ( :course_name, :identifier, :version, :orgs_default, :hasmetadata, :parent_man_id, :isscorm, :content_folder_id, :fs_package_id, current_timestamp, :user_id, :creation_ip, :package_id, :community_id, :class_key, :revision_id, :isshared, :course_presentation_format ) select ims_organization__new ( :org_id, :man_id, :identifier, :structure, :title, :hasmetadata, current_timestamp, :user_id, :creation_ip, :package_id, :revision_id ) select ims_organization__delete ( :org_id ) select ims_item__new ( :item_id, :org_id, :identifier, :identifierref, :isvisible, :parameters, :title, :parent_item, :hasmetadata, :prerequisites_t, :prerequisites_s, :type, :maxtimeallowed, :timelimitaction, :datafromlms, :masteryscore, current_timestamp, :user_id, :creation_ip, :package_id, :revision_id ) select ims_item__delete ( :item_id ) select ims_resource__new ( :res_id, :man_id, :identifier, :type, :href, :scorm_type, :hasmetadata, current_timestamp, :user_id, :creation_ip, :package_id, :revision_id ) select ims_resource__delete ( :res_id ) select ims_cp_item_to_resource__new ( :item_id, :res_id ) select ims_dependency__new ( :dep_id, :res_id, :identifierref ) select ims_dependency__delete ( :dep_id ) select ims_file__new ( :file_id, :res_id, :pathtofile, :filename, :hasmetadata )