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.4 -r1.5
--- openacs-4/packages/notifications/sql/oracle/notifications-core-create.sql	4 Jun 2002 22:53:50 -0000	1.4
+++ openacs-4/packages/notifications/sql/oracle/notifications-core-create.sql	25 Jun 2002 18:58:06 -0000	1.5
@@ -33,6 +33,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
@@ -43,10 +46,13 @@
 );
 
 create table notification_types (
-        type_id                     constraint notif_type_type_id_fk
+       type_id                      constraint notif_type_type_id_fk
                                     references acs_objects (object_id)
                                     constraint notif_type_type_id_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_type_short_name_nn
                                     not null
