postgresql7.1
select count(*)
from cr_revisions
where item_id = :file_id
and acs_permission__permission_p(revision_id,:user_id,'delete') = 'f'
select content_item__delete(:file_id);
select title as file_name
from cr_revisions
where revision_id = content_item__get_live_revision(:file_id)