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 -r1.7.2.1
--- openacs-4/packages/notifications/sql/postgresql/notifications-core-create.sql	20 Sep 2002 21:18:59 -0000	1.7
+++ openacs-4/packages/notifications/sql/postgresql/notifications-core-create.sql	6 Dec 2002 21:04:09 -0000	1.7.2.1
@@ -53,10 +53,10 @@
                                     references acs_objects (object_id)
                                     constraint notif_type_type_id_pk
                                     primary key,
-       sc_impl_id                   integer not null
+    sc_impl_id                      integer not null
                                     constraint notif_deliv_meth_impl_id_fk
                                     references acs_sc_impls(impl_id),
-       short_name                   varchar(100)
+    short_name                      varchar(100)
                                     constraint notif_type_short_name_nn
                                     not null
                                     constraint notif_type_short_name_un
@@ -136,6 +136,8 @@
                                     check (format in ('text', 'html'))
 );
 
+create index notification_requests_t_o_idx on notification_requests(type_id, object_id);
+
 -- preferences
 --
 -- for preferences that apply to each request, we're using the
