postgresql7.1 select ca__get_folder_id (:package_id) select content_item__get_content_type (:item_id) select content_folder__register_content_type (:folder_id, :content_type, :include_subtypes) select content_folder__new (:name, :label, :description, :root_folder_id) select ca__set_package_folder (:new_folder_id, :package_id) select content_item__new (:name::varchar, :parent_id::int4, :item_id::int4, null, now(), :creation_user, null, :creation_ip, :content_item, :content_type, null, null, 'text/plain', null, null, 'text'::varchar) select content_revision__new (:title, :description, now(), null, null, :data, :item_id, null, now(), :creation_user, :creation_ip) $plsql_query select content_keyword__item_assign (:cr_item_id, :category_id, null, null, null) select content_revision__new (:title, :description, now(), null, null, :data, :item_id, null, now(), :creation_user, :creation_ip) update cr_revisions set title = :title, description = :description, content = :data where revision_id = :object_id $plsql_query select content_item__is_subclass (:content_type, :parent_type) select ca_attributes__add_generic_value (:object_id, :attribute_id, :attr_value) select ca_attributes__edit_generic_value (:object_id, :attribute_id, :attr_value) select content_item__get_latest_revision (:item_id) select content_revision__get_content (:revision_id) select site_node__url(n2.node_id) as url, n2.object_id, acs_object__name(n2.object_id) as object_name, tree_level(n2.tree_sortkey) as level from (select tree_ancestor_keys(site_node_get_tree_sortkey(:node_id)) as tree_sortkey) parents, site_nodes n2 where n2.tree_sortkey = parents.tree_sortkey and tree_level(n2.tree_sortkey) > 1 order by level asc SELECT ca_attributes__create_attribute ( 'ca_ad', -- content_type :attribute_name, -- attribute_name :datatype, -- datatype :pretty_name, -- pretty_name :pretty_plural, -- pretty_plural null, -- sort_order :default_value, -- default_value 'type_specific', -- storage 'cr_ca_ads', -- table_name :column_spec, -- column_spec :main_keyword_id -- keyword_id ); SELECT ca_attributes__register_widget ( :attribute_id, -- attribute_name :widget , -- widget :pretty_name, -- label :html_options, -- html_options :extra_options, -- extra_options :select_options, -- select_options :validate, -- validate :optional_p, -- optional_p :enabled_p -- enabled_p );