Index: openacs-4/packages/notifications/notifications.info
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/notifications/notifications.info,v
diff -u -N -r1.61 -r1.61.2.1
--- openacs-4/packages/notifications/notifications.info	16 Jan 2019 19:15:33 -0000	1.61
+++ openacs-4/packages/notifications/notifications.info	12 Apr 2020 08:57:27 -0000	1.61.2.1
@@ -8,7 +8,7 @@
     <singleton-p>t</singleton-p>
     <auto-mount>notifications</auto-mount>
 
-    <version name="5.10.0d4" url="http://openacs.org/repository/download/apm/notifications-5.10.0d4.apm">
+    <version name="5.10.0d5" url="http://openacs.org/repository/download/apm/notifications-5.10.0d5.apm">
         <owner url="http://openacs.org">OpenACS</owner>
         <summary>Email notifications management</summary>
         <release-date>2019-01-16</release-date>
@@ -17,7 +17,7 @@
         <maturity>3</maturity>
         <package_instance_name>#notifications.Notifications#</package_instance_name>
 
-        <provides url="notifications" version="5.10.0d4"/>
+        <provides url="notifications" version="5.10.0d5"/>
         <requires url="acs-kernel" version="5.9.1"/>
         <requires url="acs-tcl" version="5.10.0d8"/>
         <requires url="acs-mail-lite" version="5.9.1"/>
Index: openacs-4/packages/notifications/sql/oracle/notifications-core-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/notifications/sql/oracle/notifications-core-create.sql,v
diff -u -N -r1.17 -r1.17.2.1
--- openacs-4/packages/notifications/sql/oracle/notifications-core-create.sql	3 Oct 2018 09:11:50 -0000	1.17
+++ openacs-4/packages/notifications/sql/oracle/notifications-core-create.sql	12 Apr 2020 08:57:27 -0000	1.17.2.1
@@ -133,6 +133,8 @@
 );
 
 create index notification_requests_t_o_idx on notification_requests(type_id, object_id);
+create index notification_requests_u_id_idx on notification_requests(user_id);
+create index notification_requests_o_id_idx on notification_requests(object_id);
 
 -- preferences
 --
@@ -174,7 +176,6 @@
 create index notifications_response_id_idx ON notifications(response_id);
 create index notifications_object_id_idx ON notifications(object_id);
 
-
 -- who has received this notification?
 create table notification_user_map (
     notification_id                 constraint notif_user_map_notif_id_fk
Index: openacs-4/packages/notifications/sql/oracle/upgrade/upgrade-5.10.0d4-5.10.0d5.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/notifications/sql/oracle/upgrade/Attic/upgrade-5.10.0d4-5.10.0d5.sql,v
diff -u -N
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/notifications/sql/oracle/upgrade/upgrade-5.10.0d4-5.10.0d5.sql	12 Apr 2020 08:57:27 -0000	1.1.2.1
@@ -0,0 +1,5 @@
+--
+-- create index since column is used as foreign key
+--
+create index notification_requests_u_id_idx on notification_requests(user_id);
+create index notification_requests_o_id_idx on notification_requests(object_id);
Index: openacs-4/packages/notifications/sql/postgresql/notifications-core-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/notifications/sql/postgresql/notifications-core-create.sql,v
diff -u -N -r1.17 -r1.17.2.1
--- openacs-4/packages/notifications/sql/postgresql/notifications-core-create.sql	3 Oct 2018 09:11:50 -0000	1.17
+++ openacs-4/packages/notifications/sql/postgresql/notifications-core-create.sql	12 Apr 2020 08:57:27 -0000	1.17.2.1
@@ -141,6 +141,8 @@
 );
 
 create index notification_requests_t_o_idx on notification_requests(type_id, object_id);
+create index notification_requests_user_id_idx on notification_requests(user_id);
+create index notification_requests_object_id_idx on notification_requests(object_id);
 
 -- preferences
 --
Index: openacs-4/packages/notifications/sql/postgresql/upgrade/upgrade-5.10.0d4-5.10.0d5.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/notifications/sql/postgresql/upgrade/Attic/upgrade-5.10.0d4-5.10.0d5.sql,v
diff -u -N
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/notifications/sql/postgresql/upgrade/upgrade-5.10.0d4-5.10.0d5.sql	12 Apr 2020 08:57:27 -0000	1.1.2.1
@@ -0,0 +1,5 @@
+--
+-- create index since column is used as foreign key
+--
+create index if not exists notification_requests_user_id_idx on notification_requests(user_id);
+create index if not exists notification_requests_object_id_idx on notification_requests(object_id);