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.4 -r1.5
--- openacs-4/packages/notifications/sql/postgresql/notifications-core-create.sql	24 Jun 2002 22:12:54 -0000	1.4
+++ openacs-4/packages/notifications/sql/postgresql/notifications-core-create.sql	25 Jun 2002 18:58:06 -0000	1.5
@@ -35,6 +35,9 @@
                                     references acs_objects (object_id)
                                     constraint notif_deliv_meth_pk
                                     primary key,
+    sc_impl_id                      integer not null
+                                    constraint notif_deliv_meth_impl_id_fk
+                                    references acs_sc_impls(impl_id),
     short_name                      varchar(100)
                                     constraint notif_deliv_short_name_nn
                                     not null
@@ -50,7 +53,10 @@
                                     references acs_objects (object_id)
                                     constraint notif_type_type_id_pk
                                     primary key,
-    short_name                      varchar(100)
+       sc_impl_id                   integer not null
+                                    constraint notif_deliv_meth_impl_id_fk
+                                    references acs_sc_impls(impl_id),
+       short_name                   varchar(100)
                                     constraint notif_type_short_name_nn
                                     not null
                                     constraint notif_type_short_name_un