postgresql7.2
select content_template__new(:template_name, :parent_id,
null, now(), :creation_user_id, :creation_ip)
select content_revision__new(:title, :description, now(), 'text/html', null, :content, :template_id, null, now(), :creation_user_id, :creation_ip)
select content_template__delete(:template_id)
select content_template__get_root_folder()
select content_item__register_template(:item_id, :template_id, :context)
select content_type__register_template(
:content_type,
:template_id,
:context,
:is_default_p)
select content_item__unregister_template(:item_id, :template_id, :context)
select name, item_id from cr_items where item_id = content_item__get_template(:item_id, :context)
select i.item_id as template_id, i.name, i.live_revision, i.latest_revision, i.publish_status, i.content_type, i.storage_type, i.tree_sortkey,
r.title, r.description
from cr_items i, cr_revisions r
where
i.parent_id = :parent_id
and i.item_id = r.item_id
and r.revision_id = $revision