Index: openacs-4/packages/acs-developer-support/acs-developer-support.info
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-developer-support/acs-developer-support.info,v
diff -u -N -r1.3 -r1.4
--- openacs-4/packages/acs-developer-support/acs-developer-support.info	28 Apr 2001 17:35:30 -0000	1.3
+++ openacs-4/packages/acs-developer-support/acs-developer-support.info	11 May 2001 00:14:48 -0000	1.4
@@ -14,7 +14,7 @@
         <owner url="mailto:lars@pinds.com">Lars Pind</owner>
         <owner url="mailt: jbank@arsdigita.com">Joseph Bank</owner>
         <summary>Routines used to aggregate request/response information for debugging.</summary>
-        <release-date>2001-01-24 00:00:00-08</release-date>
+        <release-date>2001-01-24</release-date>
         <vendor url="http://www.arsdigita.com/">ArsDigita Corporation</vendor>
 
         <requires url="acs-kernel" version="4.0"/>
Index: openacs-4/packages/acs-kernel/sql/oracle/acs-metadata-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/oracle/acs-metadata-create.sql,v
diff -u -N -r1.1 -r1.2
--- openacs-4/packages/acs-kernel/sql/oracle/acs-metadata-create.sql	20 Mar 2001 22:51:55 -0000	1.1
+++ openacs-4/packages/acs-kernel/sql/oracle/acs-metadata-create.sql	11 May 2001 00:14:48 -0000	1.2
@@ -49,7 +49,8 @@
                         check (dynamic_p in ('t', 'f'))
 );
 
-create bitmap index acs_obj_types_supertype_idx on acs_object_types (supertype);
+-- create bitmap index acs_obj_types_supertype_idx on acs_object_types (supertype);
+create index acs_obj_types_supertype_idx on acs_object_types (supertype);
 
 comment on table acs_object_types is '
  Each row in the acs_object_types table represents a distinct class
@@ -155,7 +156,8 @@
 	primary key (object_type, table_name)
 );
 
-create bitmap index acs_objtype_tbls_objtype_idx on acs_object_type_tables (object_type);
+-- create bitmap index acs_objtype_tbls_objtype_idx on acs_object_type_tables (object_type);
+create index acs_objtype_tbls_objtype_idx on acs_object_type_tables (object_type);
 
 comment on table acs_object_type_tables is '
  This table is used for objects that want to vertically partition
@@ -297,9 +299,11 @@
 -- constraint acs_attrs_pretty_plural_un
 -- unique (pretty_plural, object_type),
 
-create bitmap index acs_attrs_obj_type_idx on acs_attributes (object_type);
+-- create bitmap index acs_attrs_obj_type_idx on acs_attributes (object_type);
+create index acs_attrs_obj_type_idx on acs_attributes (object_type);
 create index acs_attrs_tbl_name_idx on acs_attributes (table_name);
-create bitmap index acs_attrs_datatype_idx on acs_attributes (datatype);
+-- create bitmap index acs_attrs_datatype_idx on acs_attributes (datatype);
+create index acs_attrs_datatype_idx on acs_attributes (datatype);
 
 comment on table acs_attributes is '
  Each row in the <code>acs_attributes</code> table defines an
@@ -368,7 +372,8 @@
 	description	clob not null
 );
 
-create bitmap index acs_attr_desc_obj_type_idx on acs_attribute_descriptions (object_type);
+-- create bitmap index acs_attr_desc_obj_type_idx on acs_attribute_descriptions (object_type);
+create index acs_attr_desc_obj_type_idx on acs_attribute_descriptions (object_type);
 create index acs_attr_desc_attr_name_idx on acs_attribute_descriptions (attribute_name);
 
 
Index: openacs-4/packages/acs-kernel/sql/oracle/acs-objects-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/oracle/acs-objects-create.sql,v
diff -u -N -r1.1 -r1.2
--- openacs-4/packages/acs-kernel/sql/oracle/acs-objects-create.sql	20 Mar 2001 22:51:55 -0000	1.1
+++ openacs-4/packages/acs-kernel/sql/oracle/acs-objects-create.sql	11 May 2001 00:14:48 -0000	1.2
@@ -134,7 +134,8 @@
 create index acs_objects_creation_user_idx on acs_objects (creation_user);
 create index acs_objects_modify_user_idx on acs_objects (modifying_user);
 
-create bitmap index acs_objects_object_type_idx on acs_objects (object_type);
+-- create bitmap index acs_objects_object_type_idx on acs_objects (object_type);
+create index acs_objects_object_type_idx on acs_objects (object_type);
 
 create or replace trigger acs_objects_mod_ip_insert_tr
 before insert on acs_objects
Index: openacs-4/packages/acs-kernel/sql/oracle/acs-permissions-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/oracle/acs-permissions-create.sql,v
diff -u -N -r1.2 -r1.3
--- openacs-4/packages/acs-kernel/sql/oracle/acs-permissions-create.sql	7 May 2001 05:18:15 -0000	1.2
+++ openacs-4/packages/acs-kernel/sql/oracle/acs-permissions-create.sql	11 May 2001 00:14:48 -0000	1.3
@@ -52,7 +52,8 @@
 	primary key (privilege, child_privilege)
 );
 
-create bitmap index acs_priv_hier_child_priv_idx on acs_privilege_hierarchy (child_privilege);
+-- create bitmap index acs_priv_hier_child_priv_idx on acs_privilege_hierarchy (child_privilege);
+create index acs_priv_hier_child_priv_idx on acs_privilege_hierarchy (child_privilege);
 
 --create table acs_privilege_method_rules (
 --	privilege	not null constraint acs_priv_method_rules_priv_fk
@@ -205,7 +206,8 @@
 );
 
 create index acs_permissions_grantee_idx on acs_permissions (grantee_id);
-create bitmap index acs_permissions_privilege_idx on acs_permissions (privilege);
+-- create bitmap index acs_permissions_privilege_idx on acs_permissions (privilege);
+create index acs_permissions_privilege_idx on acs_permissions (privilege);
 
 create or replace view acs_privilege_descendant_map
 as select p1.privilege, p2.privilege as descendant
Index: openacs-4/packages/acs-kernel/sql/oracle/acs-relationships-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/oracle/acs-relationships-create.sql,v
diff -u -N -r1.1 -r1.2
--- openacs-4/packages/acs-kernel/sql/oracle/acs-relationships-create.sql	20 Mar 2001 22:51:55 -0000	1.1
+++ openacs-4/packages/acs-kernel/sql/oracle/acs-relationships-create.sql	11 May 2001 00:14:48 -0000	1.2
@@ -54,10 +54,14 @@
 	check (min_n_rels_two <= max_n_rels_two)
 );
 
-create bitmap index acs_rel_types_objtypeone_idx on acs_rel_types (object_type_one);
-create bitmap index acs_rel_types_role_one_idx on acs_rel_types (role_one);
-create bitmap index acs_rel_types_objtypetwo_idx on acs_rel_types (object_type_two);
-create bitmap index acs_rel_types_role_two_idx on acs_rel_types (role_two);
+-- create bitmap index acs_rel_types_objtypeone_idx on acs_rel_types (object_type_one);
+create index acs_rel_types_objtypeone_idx on acs_rel_types (object_type_one);
+-- create bitmap index acs_rel_types_role_one_idx on acs_rel_types (role_one);
+create index acs_rel_types_role_one_idx on acs_rel_types (role_one);
+-- create bitmap index acs_rel_types_objtypetwo_idx on acs_rel_types (object_type_two);
+create index acs_rel_types_objtypetwo_idx on acs_rel_types (object_type_two);
+-- create bitmap index acs_rel_types_role_two_idx on acs_rel_types (role_two);
+create index acs_rel_types_role_two_idx on acs_rel_types (role_two);
 
 comment on table acs_rel_types is '
  Each row in <code>acs_rel_types</code> represents a type of
Index: openacs-4/packages/acs-kernel/sql/oracle/apm-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/oracle/apm-create.sql,v
diff -u -N -r1.5 -r1.6
--- openacs-4/packages/acs-kernel/sql/oracle/apm-create.sql	10 May 2001 05:10:19 -0000	1.5
+++ openacs-4/packages/acs-kernel/sql/oracle/apm-create.sql	11 May 2001 00:14:48 -0000	1.6
@@ -163,7 +163,8 @@
 				check (enabled_p in ('t', 'f'))
 );
 
-create bitmap index apm_packages_package_key_idx on apm_packages (package_key);
+-- create bitmap index apm_packages_package_key_idx on apm_packages (package_key);
+create index apm_packages_package_key_idx on apm_packages (package_key);
 
 comment on table apm_packages is '
    This table maintains the list of all package instances in the sytem. 
@@ -578,8 +579,8 @@
     constraint apm_package_files_un unique(version_id, path)
 );
 
-create bitmap index apm_pkg_files_file_type_idx on apm_package_files (file_type);
-create bitmap index apm_pkg_files_db_type_idx on apm_package_files (db_type);
+-- create bitmap index apm_pkg_files_file_type_idx on apm_package_files (file_type);
+create index apm_pkg_files_db_type_idx on apm_package_files (db_type);
 
 comment on table apm_package_files is '
   The files that belong to an APM package.  We store this information in the database
Index: openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-4.0-4.0.1.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-4.0-4.0.1.sql,v
diff -u -N -r1.1 -r1.2
--- openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-4.0-4.0.1.sql	20 Mar 2001 22:51:56 -0000	1.1
+++ openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-4.0-4.0.1.sql	11 May 2001 00:14:48 -0000	1.2
@@ -80,7 +80,8 @@
 
 -- performance improvements
 
-create bitmap index acs_obj_types_supertype_idx on acs_object_types (supertype);
+-- create bitmap index acs_obj_types_supertype_idx on acs_object_types (supertype);
+create index acs_obj_types_supertype_idx on acs_object_types (supertype);
 
 -- update apm procedures
 -- bquinn@arsdigita.com 11/18/2000
Index: openacs-4/www/index-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/www/Attic/index-oracle.xql,v
diff -u -N
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/www/index-oracle.xql	11 May 2001 00:14:48 -0000	1.1
@@ -0,0 +1,21 @@
+<?xml version="1.0"?>
+<queryset>
+    <rdbms>
+      <type>oracle</type>
+      <version>8.1.6</version>
+    </rdbms>
+
+  <fullquery name="dbqd.www.index.site_nodes">
+    <querytext>
+  select site_node.url(node_id) as url, acs_object.name(object_id) as name
+      from site_nodes
+      where parent_id = site_node.node_id('/')
+      and object_id is not null
+      and acs_permission.permission_p(
+          object_id, 
+          nvl(:user_id, acs.magic_object_id('the_public')), 
+          'read') = 't'
+    </querytext>
+  </fullquery>
+
+</queryset>
Index: openacs-4/www/index.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/www/Attic/index.xql,v
diff -u -N
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/www/index.xql	11 May 2001 00:14:48 -0000	1.1
@@ -0,0 +1,14 @@
+<?xml version="1.0"?>
+<queryset>
+  <fullquery name="dbqd.www.index.user_name_select">
+    <querytext>
+
+	select first_names || ' ' || last_name as name, email
+	from persons, parties
+	where person_id = :user_id
+	and person_id = party_id
+
+    </querytext>
+  </fullquery>
+
+</queryset>