Index: openacs-4/packages/acs-subsite/www/admin/site-map/unmounted-oracle.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/www/admin/site-map/unmounted-oracle.xql,v diff -u -N --- openacs-4/packages/acs-subsite/www/admin/site-map/unmounted-oracle.xql 27 Oct 2014 16:39:57 -0000 1.3 +++ /dev/null 1 Jan 1970 00:00:00 -0000 @@ -1,34 +0,0 @@ - - - - oracle8.1.6 - - - - select package_id, acs_object.name(package_id) as name, package_key - from apm_packages - where (acs_permission.permission_p(package_id, :user_id, 'read') = 't' or - acs_permission.permission_p(package_id, acs.magic_object_id('the_public'), 'read') = 't') - and apm_package.singleton_p(package_key) = 0 - and not exists (select 1 - from site_nodes - where object_id = package_id) - order by name - - - - - - select package_id, acs_object.name(package_id) as name, package_key - from apm_packages - where (acs_permission.permission_p(package_id, :user_id, 'read') = 't' or - acs_permission.permission_p(package_id, acs.magic_object_id('the_public'), 'read') = 't') - and apm_package.singleton_p(package_key) = 1 - and not exists (select 1 - from site_nodes - where object_id = package_id) - order by name - - - -