postgresql7.1
select file_storage__new_version (
:filename, -- filename
:description, -- description
:mime_type, -- mime_type
:file_id, -- item_id
:user_id, -- creation_user
:creation_ip -- creation_ip
);
update cr_revisions
set lob = [set __lob_id [db_string get_lob_id "select empty_lob()"]]
where revision_id = :version_id
update cr_revisions
set content_length = lob_length(lob)
where revision_id = :version_id
update cr_revisions
set content = '$tmp_filename',
content_length = $tmp_size
where revision_id = :version_id