select creation_user as homework_user_id from acs_objects where object_id = :homework_file_id
update acs_objects
set context_id = null
where object_id = :file_id
update cr_revisions
set content = :tmp_filename,
content_length = :tmp_size
where revision_id = :revision_id
select f.name, folder.label as folder_name,
p.first_names || ' ' || p.last_name as student_name
from cr_items f, cr_folders folder, persons p, acs_objects o
where f.item_id = :file_id
and o.object_id = :file_id
and folder.folder_id = :folder_id
and p.person_id = o.creation_user
select f.name, folder.label as folder_name,
p.first_names || ' ' || p.last_name as admin_name
from cr_items f, cr_folders folder, persons p
where item_id = :homework_file_id
and folder.folder_id = :folder_id
and p.person_id = :user_id