Index: openacs-4/packages/notifications/notifications.info
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/notifications/notifications.info,v
diff -u -r1.15 -r1.16
--- openacs-4/packages/notifications/notifications.info	25 Feb 2003 10:05:18 -0000	1.15
+++ openacs-4/packages/notifications/notifications.info	25 Feb 2003 10:16:42 -0000	1.16
@@ -35,6 +35,7 @@
             <file type="data_model" db_type="oracle" path="sql/oracle/notifications-replies-package-create.sql"/>
             <file type="data_model_upgrade" db_type="oracle" path="sql/oracle/upgrade/upgrade-0.1d-0.2d.sql"/>
             <file type="data_model_upgrade" db_type="oracle" path="sql/oracle/upgrade/upgrade-0.3d-0.4d.sql"/>
+            <file type="data_model_upgrade" db_type="oracle" path="sql/oracle/upgrade/upgrade-0.4d-0.5d.sql"/>
             <file type="data_model" db_type="postgresql" path="sql/postgresql/delivery-method-sc-create.sql"/>
             <file type="data_model" db_type="postgresql" path="sql/postgresql/email-sc-impl-create.sql"/>
             <file type="data_model" db_type="postgresql" path="sql/postgresql/notification-type-sc-create.sql"/>
Index: openacs-4/packages/notifications/sql/oracle/upgrade/upgrade-0.4d-0.5d.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/notifications/sql/oracle/upgrade/upgrade-0.4d-0.5d.sql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/notifications/sql/oracle/upgrade/upgrade-0.4d-0.5d.sql	25 Feb 2003 10:17:26 -0000	1.1
@@ -0,0 +1,43 @@
+-- START Make oracle version cascade in all the places where the pg version does
+
+-- Table notification_types_intervals
+alter table notification_types_intervals drop constraint NOTIF_TYPE_INT_TYPE_ID_FK;
+alter table notification_types_intervals 
+        add constraint notif_type_int_type_id_fk 
+        foreign key (type_id)
+        references notification_types (type_id) 
+        on delete cascade;
+
+alter table notification_types_intervals drop constraint NOTIF_TYPE_INT_INT_ID_FK;
+alter table notification_types_intervals 
+        add constraint notif_type_int_int_id_fk 
+        foreign key (interval_id)
+        references notification_intervals (interval_id) 
+        on delete cascade;
+
+-- Table notification_types_del_methods
+alter table notification_types_del_methods drop constraint NOTIF_TYPE_DEL_TYPE_ID_FK;
+alter table notification_types_del_methods 
+        add constraint notif_type_del_type_id_fk 
+        foreign key (type_id)
+        references notification_types (type_id) 
+        on delete cascade;
+
+alter table notification_types_del_methods drop constraint NOTIF_TYPE_DEL_METH_ID_FK;
+alter table notification_types_del_methods 
+        add constraint notif_type_del_meth_id_fk 
+        foreign key (delivery_method_id)
+        references notification_delivery_methods (delivery_method_id) 
+        on delete cascade;
+
+-- Table notification_requests
+alter table notification_requests drop constraint NOTIF_REQUEST_TYPE_ID_FK;
+alter table notification_requests
+        add constraint notif_request_type_id_fk
+        foreign key (type_id)
+        references notification_types (type_id)
+        on delete cascade;
+
+-- END on delete cascade changes
+
+-- TODO: other changes here