Index: openacs-4/packages/static-portlet/static-portlet.info
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/static-portlet/static-portlet.info,v
diff -u -N -r1.27.2.1 -r1.27.2.2
--- openacs-4/packages/static-portlet/static-portlet.info	26 Sep 2015 12:57:12 -0000	1.27.2.1
+++ openacs-4/packages/static-portlet/static-portlet.info	29 Sep 2015 12:21:31 -0000	1.27.2.2
@@ -9,14 +9,14 @@
     <implements-subsite-p>f</implements-subsite-p>
     <inherit-templates-p>t</inherit-templates-p>
     
-    <version name="2.9.0b1" url="http://openacs.org/repository/download/apm/static-portlet-2.9.0b1.apm">
+    <version name="2.9.0b2" url="http://openacs.org/repository/download/apm/static-portlet-2.9.0b2.apm">
         <owner url="http://openacs.org">OpenACS</owner>
         <summary>Portlet for the &quot;new-portal&quot; system for static pages</summary>
         <release-date>2015-09-25</release-date>
         <vendor url="http://dotlrn.org">DotLRN Consortium</vendor>
         <maturity>2</maturity>
 
-        <provides url="static-portlet" version="2.9.0b1"/>
+        <provides url="static-portlet" version="2.9.0b2"/>
         <requires url="dotlrn" version="2.9.0b1"/>
         <requires url="new-portal" version="2.9.0b1"/>
 
Index: openacs-4/packages/static-portlet/sql/oracle/static-core.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/static-portlet/sql/oracle/static-core.sql,v
diff -u -N -r1.9 -r1.9.10.1
--- openacs-4/packages/static-portlet/sql/oracle/static-core.sql	8 Aug 2006 21:27:11 -0000	1.9
+++ openacs-4/packages/static-portlet/sql/oracle/static-core.sql	29 Sep 2015 12:21:31 -0000	1.9.10.1
@@ -42,8 +42,8 @@
                                 default 'text/html'
                                 constraint static_p_c_format_ck check (format in ('text/enhanced', 'text/plain', 'text/fixed-width', 'text/html'))
 );
+create index static_portal_content_package_id_idx on static_portal_content(package_id);
 
-
 --
 -- Objects
 --
Index: openacs-4/packages/static-portlet/sql/oracle/upgrade/upgrade-2.9.0b1-2.9.0b2.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/static-portlet/sql/oracle/upgrade/upgrade-2.9.0b1-2.9.0b2.sql,v
diff -u -N
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/static-portlet/sql/oracle/upgrade/upgrade-2.9.0b1-2.9.0b2.sql	29 Sep 2015 12:21:31 -0000	1.1.2.1
@@ -0,0 +1 @@
+create index static_portal_content_package_id_idx on static_portal_content(package_id);
Index: openacs-4/packages/static-portlet/sql/postgresql/static-core.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/static-portlet/sql/postgresql/static-core.sql,v
diff -u -N -r1.7 -r1.7.2.1
--- openacs-4/packages/static-portlet/sql/postgresql/static-core.sql	27 Oct 2014 16:41:55 -0000	1.7
+++ openacs-4/packages/static-portlet/sql/postgresql/static-core.sql	29 Sep 2015 12:21:31 -0000	1.7.2.1
@@ -61,11 +61,12 @@
 --
 create table static_portal_content (
     content_id                  integer
-                                                                constraint static_p_c_fk
+                                constraint static_p_c_fk
                                 references acs_objects(object_id)
                                 constraint static_p_c_pk
                                 primary key,
     package_id                  integer
+                                references apm_packages(package_id) on delete cascade
                                 not null,
     pretty_name                 varchar(100)
                                 constraint static_p_c_pretty_name_nn
@@ -76,6 +77,7 @@
 				check (format in ('text/enhanced', 'text/plain', 'text/fixed-width', 'text/html'))
 );
 
+create index static_portal_content_package_id_idx on static_portal_content(package_id);
 
 
 --
Index: openacs-4/packages/static-portlet/sql/postgresql/upgrade/upgrade-2.9.0b1-2.9.0b2.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/static-portlet/sql/postgresql/upgrade/upgrade-2.9.0b1-2.9.0b2.sql,v
diff -u -N
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/static-portlet/sql/postgresql/upgrade/upgrade-2.9.0b1-2.9.0b2.sql	29 Sep 2015 12:21:32 -0000	1.1.2.1
@@ -0,0 +1,2 @@
+drop index if exists static_portal_content_package_id_idx;
+create index static_portal_content_package_id_idx on static_portal_content(package_id);