insert into ${table_name}i (revision_id, object_type, creation_user, creation_date, creation_ip, title, description, item_id, text, mime_type $addtnl_properties) values (:revision_id, :content_type, :creation_user, current_timestamp, :creation_ip, :title, :description, :item_id, :content, :mime_type $addtnl_values) insert into ${table_name}i (object_type, creation_user, creation_date, creation_ip, title, description, item_id, revision_id, text, mime_type $addtnl_properties) values (:content_type, :creation_user, now(), :creation_ip, :title, :description, :item_id, :revision_id, :content, :mime_type $addtnl_values) select 1 from cr_mime_types where mime_type = :mime_type update cr_revisions set content_length = :tmp_filesize where revision_id = :revision_id select i.item_id, i.name, i.parent_id, r.title, r.description, r.content, i.content_type, i.publish_status, i.live_revision, i.latest_revision, i.storage_type, r.mime_type, r.publish_date $addtnl_select from cr_revisions r, cr_items i $addtnl_from where r.revision_id = :revision_id and i.item_id = r.item_id $addtnl_where update cr_revisions set $update_string where revision_id = :revision_id