Index: openacs-4/packages/new-portal/new-portal.info =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/new-portal/new-portal.info,v diff -u -r1.40.2.1 -r1.40.2.2 --- openacs-4/packages/new-portal/new-portal.info 26 Sep 2015 12:57:10 -0000 1.40.2.1 +++ openacs-4/packages/new-portal/new-portal.info 2 Oct 2015 12:53:44 -0000 1.40.2.2 @@ -8,15 +8,15 @@ t portal - + OpenACS Portals. 2015-09-25 DotLRN Consortium 2 New Portal Package aka NPP. Portals are used to aggregate content from different sources within a single page. Props to Ian Baker for "Portal". - + Index: openacs-4/packages/new-portal/sql/oracle/portal-core-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/new-portal/sql/oracle/portal-core-create.sql,v diff -u -r1.47 -r1.47.8.1 --- openacs-4/packages/new-portal/sql/oracle/portal-core-create.sql 15 May 2007 20:14:47 -0000 1.47 +++ openacs-4/packages/new-portal/sql/oracle/portal-core-create.sql 2 Oct 2015 12:53:44 -0000 1.47.8.1 @@ -158,7 +158,9 @@ template_id constraint template_id_fk references portals (portal_id) ); +create index portals_template_id_idx on portals(template_id); + -- Support for multi-page portals (think my.yahoo.com) create table portal_pages ( page_id constraint portal_pages_page_id_fk Index: openacs-4/packages/new-portal/sql/postgresql/portal-core-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/new-portal/sql/postgresql/portal-core-create.sql,v diff -u -r1.6 -r1.6.8.1 --- openacs-4/packages/new-portal/sql/postgresql/portal-core-create.sql 15 May 2007 20:14:47 -0000 1.6 +++ openacs-4/packages/new-portal/sql/postgresql/portal-core-create.sql 2 Oct 2015 12:53:45 -0000 1.6.8.1 @@ -161,6 +161,7 @@ constraint portal_template_id_fk references portals (portal_id) ); +create index portals_template_id_idx on portals(template_id); -- Support for multi-page portals (think my.yahoo.com) create table portal_pages ( @@ -199,6 +200,7 @@ create index portal_pages_prtl_page_idx on portal_pages (portal_id, page_id); + -- PE are fully owned by one and only one portal. They are not -- "objects" that live on after their portal is gone. One way to think -- of them is a map b/w a portal and a DS, with satellite data of a