Index: openacs-4/packages/notifications/notifications.info
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/notifications/notifications.info,v
diff -u -r1.11.2.6 -r1.11.2.7
--- openacs-4/packages/notifications/notifications.info	29 Dec 2002 02:45:23 -0000	1.11.2.6
+++ openacs-4/packages/notifications/notifications.info	1 Feb 2003 00:14:04 -0000	1.11.2.7
@@ -7,7 +7,7 @@
     <initial-install-p>f</initial-install-p>
     <singleton-p>t</singleton-p>
 
-    <version name="0.3d" url="http://openacs.org/repository/download/apm/notifications-0.3d.apm">
+    <version name="0.4d" url="http://openacs.org/repository/download/apm/notifications-0.4d.apm">
     <database-support>
         <database>oracle</database>
         <database>postgresql</database>
@@ -16,7 +16,7 @@
         <summary>Notification Management</summary>
         <release-date>2002-08-19</release-date>
 
-        <provides url="notifications" version="0.3d"/>
+        <provides url="notifications" version="0.4d"/>
         <requires url="acs-mail-lite" version="0.1d"/>
 
         <files>
@@ -33,6 +33,8 @@
             <file type="data_model" db_type="oracle" path="sql/oracle/notifications-replies-create.sql"/>
             <file type="data_model" db_type="oracle" path="sql/oracle/notifications-replies-package-create.sql"/>
             <file type="data_model_upgrade" db_type="oracle" path="sql/oracle/upgrade/upgrade-0.1d-0.2d.sql"/>
+            <file type="data_model_upgrade" db_type="oracle" path="sql/oracle/upgrade/upgrade-0.2d-0.3d.sql"/>
+            <file type="data_model_upgrade" db_type="oracle" path="sql/oracle/upgrade/upgrade-0.3d-0.4d.sql"/>
             <file type="data_model" db_type="postgresql" path="sql/postgresql/delivery-method-sc-create.sql"/>
             <file type="data_model" db_type="postgresql" path="sql/postgresql/email-sc-impl-create.sql"/>
             <file type="data_model" db_type="postgresql" path="sql/postgresql/notification-type-sc-create.sql"/>
@@ -46,6 +48,8 @@
             <file type="data_model" db_type="postgresql" path="sql/postgresql/notifications-replies-create.sql"/>
             <file type="data_model" db_type="postgresql" path="sql/postgresql/notifications-replies-package-create.sql"/>
             <file type="data_model_upgrade" db_type="postgresql" path="sql/postgresql/upgrade/upgrade-0.1d-0.2d.sql"/>
+            <file type="data_model_upgrade" db_type="postgresql" path="sql/postgresql/upgrade/upgrade-0.2d-0.3d.sql"/>
+            <file type="data_model_upgrade" db_type="postgresql" path="sql/postgresql/upgrade/upgrade-0.3d-0.4d.sql"/>
             <file type="tcl_procs" path="tcl/delivery-method-procs.tcl"/>
             <file type="query_file" path="tcl/delivery-method-procs.xql"/>
             <file type="tcl_procs" path="tcl/interval-procs.tcl"/>
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 -r1.8.2.1 -r1.8.2.2
--- openacs-4/packages/notifications/sql/oracle/notifications-core-create.sql	6 Dec 2002 21:03:57 -0000	1.8.2.1
+++ openacs-4/packages/notifications/sql/oracle/notifications-core-create.sql	1 Feb 2003 00:14:25 -0000	1.8.2.2
@@ -151,6 +151,12 @@
     notif_html                      clob
 );
 
+-- RI indexes 
+create index notifications_type_id_idx ON notifications(type_id);
+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
@@ -164,6 +170,9 @@
     sent_date                       date
 );
 
+-- RI Indexes 
+create index notification_user_map_user_idx ON notification_user_map(user_id);
+
 --
 -- Object Types
 --
Index: openacs-4/packages/notifications/sql/oracle/notifications-replies-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/notifications/sql/oracle/notifications-replies-create.sql,v
diff -u -r1.2 -r1.2.2.1
--- openacs-4/packages/notifications/sql/oracle/notifications-replies-create.sql	9 Aug 2002 20:51:49 -0000	1.2
+++ openacs-4/packages/notifications/sql/oracle/notifications-replies-create.sql	1 Feb 2003 00:14:26 -0000	1.2.2.1
@@ -27,6 +27,10 @@
        reply_date                 date
 );
 
+-- RI indexes
+create index notif_repl_from_user_idx ON notification_replies(from_user);
+create index notif_repl_type_id_idx ON notification_replies(type_id);
+create index notif_repl_object_id_idx ON notification_replies(object_id);
 
 declare
 begin
Fisheye: Tag 1.1 refers to a dead (removed) revision in file `openacs-4/packages/notifications/sql/oracle/upgrade/upgrade-0.2d-0.3d.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag 1.1 refers to a dead (removed) revision in file `openacs-4/packages/notifications/sql/oracle/upgrade/upgrade-0.3d-0.4d.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
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 -r1.7.2.1 -r1.7.2.2
--- openacs-4/packages/notifications/sql/postgresql/notifications-core-create.sql	6 Dec 2002 21:04:09 -0000	1.7.2.1
+++ openacs-4/packages/notifications/sql/postgresql/notifications-core-create.sql	1 Feb 2003 00:14:51 -0000	1.7.2.2
@@ -171,6 +171,11 @@
     notif_html                      text
 );
 
+-- RI indexes 
+create index notifications_type_id_idx ON notifications(type_id);
+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                 integer
@@ -186,6 +191,10 @@
     sent_date                       timestamp
 );
 
+-- RI Indexes 
+create index notification_user_map_user_idx ON notification_user_map(user_id);
+
+
 --
 -- Object Types
 --
Index: openacs-4/packages/notifications/sql/postgresql/notifications-replies-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/notifications/sql/postgresql/notifications-replies-create.sql,v
diff -u -r1.2 -r1.2.2.1
--- openacs-4/packages/notifications/sql/postgresql/notifications-replies-create.sql	9 Aug 2002 20:51:50 -0000	1.2
+++ openacs-4/packages/notifications/sql/postgresql/notifications-replies-create.sql	1 Feb 2003 00:14:51 -0000	1.2.2.1
@@ -27,7 +27,12 @@
        reply_date                 timestamp
 );
 
+-- RI indexes
+create index notif_repl_from_user_idx ON notification_replies(from_user);
+create index notif_repl_type_id_idx ON notification_replies(type_id);
+create index notif_repl_object_id_idx ON notification_replies(object_id);
 
+
 select acs_object_type__create_type (
             'notification_reply',
             'Notification Reply',
Fisheye: Tag 1.1 refers to a dead (removed) revision in file `openacs-4/packages/notifications/sql/postgresql/upgrade/upgrade-0.2d-0.3d.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag 1.1 refers to a dead (removed) revision in file `openacs-4/packages/notifications/sql/postgresql/upgrade/upgrade-0.3d-0.4d.sql'.
Fisheye: No comparison available.  Pass `N' to diff?