insert into ${table_name}i
(revision_id, object_type, creation_user, creation_date, creation_ip, title, description, item_id, text, mime_type)
values (:revision_id, :content_type, :creation_user_id, now(), :creation_ip, :title, :description, :item_id, :content, :mime_type)
insert into ${table_name}i
(object_type, creation_user, creation_date, creation_ip, title, description, item_id, revision_id, text, mime_type)
values (:content_type, :creation_user_id, now(), :creation_ip, :title, :description, :item_id, :revision_id, :content, :mime_type)
select mime_type
from cr_mime_types
where file_extension = :file_extension
insert into cr_mime_types
(mime_type, file_extension)
values
(:mime_type, :file_extension)
update cr_revisions
set content_length = :tmp_filesize
where revision_id = :revision_id
select i.item_id, i.name, r.title, r.description, r.content,
i.content_type, i.publish_status, i.live_revision, i.storage_type
from cr_revisions r, cr_items i
where r.revision_id = :revision_id
and i.item_id = r.item_id
update cr_revisions set $update_string
where revision_id = :revision_id