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',