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.86.2.7 -r1.86.2.8 --- openacs-4/packages/acs-kernel/acs-kernel.info 15 Apr 2007 15:06:55 -0000 1.86.2.7 +++ openacs-4/packages/acs-kernel/acs-kernel.info 19 Apr 2007 10:15:58 -0000 1.86.2.8 @@ -7,23 +7,24 @@ t t - + OpenACS Core Team Routines and data models providing the foundation for OpenACS-based Web services. - 2007-04-15 + 2007-04-19 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.11.2.1 --- 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 19 Apr 2007 10:15:59 -0000 1.11.2.1 @@ -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 Fisheye: Tag 1.1 refers to a dead (removed) revision in file `openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-5.3.1b1-5.3.1b2.sql'. Fisheye: No comparison available. Pass `N' to diff? 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.30.2.1 --- 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 19 Apr 2007 10:15:59 -0000 1.30.2.1 @@ -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 Fisheye: Tag 1.1 refers to a dead (removed) revision in file `openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.3.1b1-5.3.1b2.sql'. Fisheye: No comparison available. Pass `N' to diff?