insert into glossariesi ( item_id, revision_id, title, description, context_id, creation_user, creation_ip, package_id, workflow_key ) values ( :item_id, :revision_id, :title, :description, :context_id, :user_id, :peeraddr, :package_id, :workflow_key ) update cr_items set live_revision = :revision_id, name = :package_id || '_' || :item_id, publish_status = 'live' where item_id = :item_id