insert into dav_site_node_folder_map
(folder_id, node_id, enabled_p)
values
(:folder_id, :node_id, :enabled_p)
delete from dav_site_node_folder_map
where folder_id=:folder_id
and node_id=:node_id
select folder_id from dav_site_node_folder_map
where node_id=:node_id and enabled_p = 't'
select content_type from cr_items where item_id=:item_id
update cr_items set live_revision=:revision_id
where item_id=(select item_id from cr_revisions
where revision_id=:revision_id)
select count(*) from dav_site_node_folder_map
where folder_id=:move_folder_id
update cr_items set live_revision=latest_revision
where item_id=:item_id