select o.object_type from acs_objects o, as_item_rels r where r.item_rev_id = :as_item_id and r.rel_type = 'as_item_type_rel' and o.object_id = r.target_rev_id select display_type from as_item_types_map where item_type = :item_type select cr.title || ' (' || cr.content_length || ' bytes)' as content_name, cr.revision_id as content_rev_id, cr.title as content_filename from cr_revisions cr, as_item_rels r where r.item_rev_id = :as_item_id and r.target_rev_id = cr.revision_id and r.rel_type = 'as_item_content_rel' select r.title, r.description, i.subtext, i.field_name, i.field_code, i.required_p, i.feedback_right, i.feedback_wrong, i.max_time_to_complete, i.data_type, i.points, i.validate_block, r.content as question_text, r.mime_type from cr_revisions r, as_items i where r.revision_id = i.as_item_id and i.as_item_id = :as_item_id select o.object_type from acs_objects o, as_item_rels r where r.item_rev_id = :as_item_id and r.rel_type = 'as_item_display_rel' and o.object_id = r.target_rev_id insert into as_item_rels (target_rev_id, item_rev_id, rel_type) values (:content_rev_id, :new_item_id, 'as_item_content_rel') update as_item_rels set target_rev_id = :content_rev_id where item_rev_id = :new_item_id and rel_type = 'as_item_content_rel' delete from as_item_rels where item_rev_id = :new_item_id and rel_type = 'as_item_content_rel' update as_assessment_section_map set section_id = :new_section_id where assessment_id = :new_assessment_rev_id and section_id = :section_id update as_item_section_map set as_item_id = :new_item_id, points = :points, required_p = :required_p where section_id = :new_section_id and as_item_id = :as_item_id