postgresql7.1 select content_revision__new(:title, null, now(), 'text/plain', ' ', :item_id ) update cr_revisions set content = '[cr_create_content_file $item_id $revision_id $path]' where revision_id = :revision_id select i.storage_type, i.storage_area_key, r.mime_type, r.revision_id from cr_items i, cr_revisions r where r.revision_id = content_item__get_live_revision(:item_id) and i.item_id = r.item_id select :path || content from cr_revisions where revision_id = :revision_id select lob as content from cr_revisions where revision_id = :revision_id