insert into ims_md
(ims_md_id, schema, schemaversion)
values
(:ims_md_id, :schema, :schemaversion)
update ims_md
set schema = :schema,
schemaversion = :schemaversion
where ims_md_id = :ims_md_id
update ims_cp_manifests
set hasmetadata = 't'
where man_id = :ims_md_id
update ims_cp_items
set hasmetadata = 't'
where ims_item_id = :ims_md_id
update ims_cp_organizations
set hasmetadata = 't'
where org_id = :ims_md_id
update ims_cp_resources
set hasmetadata = 't'
where res_id = :ims_md_id
update ims_cp_files
set hasmetadata = 't'
where file_id = :ims_md_id
select schema, schemaversion
from ims_md
where ims_md_id = :ims_md_id