Index: openacs-4/packages/acs-kernel/acs-kernel.info =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/acs-kernel.info,v diff -u -r1.88 -r1.89 --- openacs-4/packages/acs-kernel/acs-kernel.info 15 Dec 2006 00:01:23 -0000 1.88 +++ openacs-4/packages/acs-kernel/acs-kernel.info 13 Apr 2007 21:38:08 -0000 1.89 @@ -7,23 +7,24 @@ t t - + OpenACS Core Team Routines and data models providing the foundation for OpenACS-based Web services. - 2006-11-19 + 2007-04-13 OpenACS The OpenACS kernel contains the core datamodel create and drop scripts for such things as objects, groups, partiies and the supporting PL/SQL and PL/pgSQL procedures. + 0 + - @@ -32,6 +33,7 @@ + @@ -49,7 +51,6 @@ - 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 -r1.11 -r1.12 --- openacs-4/packages/acs-kernel/sql/oracle/acs-permissions-create.sql 26 Sep 2006 14:48:02 -0000 1.11 +++ openacs-4/packages/acs-kernel/sql/oracle/acs-permissions-create.sql 13 Apr 2007 21:38:08 -0000 1.12 @@ -162,6 +162,7 @@ create index acs_permissions_grantee_idx on acs_permissions (grantee_id); -- create bitmap index acs_permissions_privilege_idx on acs_permissions (privilege); create index acs_permissions_privilege_idx on acs_permissions (privilege); +create index acs_permissions_object_id_idx on acs_permissions(object_id); create or replace view acs_privilege_descendant_map as select p1.privilege, p2.privilege as descendant Index: openacs-4/packages/acs-kernel/sql/postgresql/acs-permissions-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/postgresql/acs-permissions-create.sql,v diff -u -r1.30 -r1.31 --- openacs-4/packages/acs-kernel/sql/postgresql/acs-permissions-create.sql 25 Sep 2006 17:59:16 -0000 1.30 +++ openacs-4/packages/acs-kernel/sql/postgresql/acs-permissions-create.sql 13 Apr 2007 21:38:08 -0000 1.31 @@ -352,6 +352,7 @@ create index acs_permissions_grantee_idx on acs_permissions (grantee_id); create index acs_permissions_privilege_idx on acs_permissions (privilege); +create index acs_permissions_object_id_idx on acs_permissions(object_id); -- Added table to materialize view that previously used -- acs_privilege_descendant_map name