postgresql7.1
select category_tree__map(
:object_id,
:tree_id,
:subtree_category_id,
:assign_single_p,
:require_category_p,
:widget
)
select category_tree__unmap(:object_id,:tree_id)
select category_tree__copy(:source_tree, :dest_tree, :creation_user, :creation_ip)
select category_tree__new (
:tree_id,
:locale,
:name,
:description,
:site_wide_p,
current_timestamp,
:user_id,
:creation_ip,
:context_id
)
select category_tree__new_translation (
:tree_id,
:default_locale,
:name,
:description,
current_timestamp,
:user_id,
:creation_ip
)
select category_tree__new_translation (
:tree_id,
:locale,
:name,
:description,
current_timestamp,
:user_id,
:modifying_ip
)
select category_tree__edit (
:tree_id,
:locale,
:name,
:description,
:site_wide_p,
current_timestamp,
:user_id,
:modifying_ip
)
select category_tree__del ( :tree_id )
select t.pretty_plural, n.object_id, n.title, p.package_id,
p.instance_name,
acs_permission__permission_p(n.object_id, :user_id, 'read') as read_p
from category_tree_map m, acs_objects n,
apm_packages p, apm_package_types t
where m.tree_id = :tree_id
and n.object_id = m.object_id
and p.package_id = n.package_id
and t.package_key = p.package_key