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.9 -r1.10
--- openacs-4/packages/notifications/sql/postgresql/notifications-core-create.sql	25 Feb 2003 10:09:12 -0000	1.9
+++ openacs-4/packages/notifications/sql/postgresql/notifications-core-create.sql	17 May 2003 10:53:27 -0000	1.10
@@ -160,7 +160,7 @@
                                     constraint notif_object_id_fk
                                     references acs_objects(object_id)
                                     on delete cascade,
-    notif_date                      timestamp
+    notif_date                      timestamptz
                                     constraint notif_notif_date_nn
                                     not null,
     -- this is to allow responses to notifications
@@ -172,6 +172,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
@@ -184,9 +189,13 @@
                                     on delete cascade,
     constraint notif_user_map_pk
     primary key (notification_id, user_id),
-    sent_date                       timestamp
+    sent_date                       timestamptz
 );
 
+-- RI Indexes 
+create index notification_user_map_user_idx ON notification_user_map(user_id);
+
+
 --
 -- Object Types
 --
