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
)