Index: openacs-4/packages/notifications/notifications.info
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/notifications/notifications.info,v
diff -u -r1.9 -r1.10
--- openacs-4/packages/notifications/notifications.info	9 Jul 2002 16:29:39 -0000	1.9
+++ openacs-4/packages/notifications/notifications.info	19 Aug 2002 20:37:15 -0000	1.10
@@ -7,15 +7,16 @@
     <initial-install-p>f</initial-install-p>
     <singleton-p>t</singleton-p>
 
-    <version name="0.1d" url="http://openacs.org/repository/download/apm/notifications-0.1d.apm">
+    <version name="0.2d" url="http://openacs.org/repository/download/apm/notifications-0.2d.apm">
     <database-support>
         <database>oracle</database>
         <database>postgresql</database>
     </database-support>
         <owner url="mailto:ben@openforce.net">Ben Adida</owner>
         <summary>Notification Management</summary>
+        <release-date>2002-08-19</release-date>
 
-        <provides url="notifications" version="0.1"/>
+        <provides url="notifications" version="0.2d"/>
         <requires url="acs-mail-lite" version="0.1d"/>
 
         <files>
@@ -31,13 +32,19 @@
             <file type="data_model" db_type="oracle" path="sql/oracle/notifications-package-drop.sql"/>
             <file type="data_model" db_type="oracle" path="sql/oracle/notifications-replies-create.sql"/>
             <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" 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"/>
             <file type="data_model" db_type="postgresql" path="sql/postgresql/notifications-core-create.sql"/>
             <file type="data_model" db_type="postgresql" path="sql/postgresql/notifications-core-drop.sql"/>
             <file type="data_model_create" db_type="postgresql" path="sql/postgresql/notifications-create.sql"/>
             <file type="data_model_drop" db_type="postgresql" path="sql/postgresql/notifications-drop.sql"/>
             <file type="data_model" db_type="postgresql" path="sql/postgresql/notifications-init.sql"/>
             <file type="data_model" db_type="postgresql" path="sql/postgresql/notifications-package-create.sql"/>
             <file type="data_model" db_type="postgresql" path="sql/postgresql/notifications-package-drop.sql"/>
+            <file type="data_model" db_type="postgresql" path="sql/postgresql/notifications-replies-create.sql"/>
+            <file type="data_model" db_type="postgresql" path="sql/postgresql/notifications-replies-package-create.sql"/>
             <file type="tcl_procs" path="tcl/delivery-method-procs.tcl"/>
             <file type="query_file" path="tcl/delivery-method-procs.xql"/>
             <file type="tcl_procs" path="tcl/interval-procs.tcl"/>
Index: openacs-4/packages/notifications/sql/oracle/notifications-package-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/notifications/sql/oracle/notifications-package-create.sql,v
diff -u -r1.5 -r1.6
--- openacs-4/packages/notifications/sql/oracle/notifications-package-create.sql	9 Aug 2002 20:51:49 -0000	1.5
+++ openacs-4/packages/notifications/sql/oracle/notifications-package-create.sql	19 Aug 2002 20:37:15 -0000	1.6
@@ -381,6 +381,8 @@
    )
    is
    begin
+      delete from notifications where notification_id = notification.delete.notification_id;
+
       acs_object.delete (notification_id);
    end delete;
 
Index: openacs-4/packages/notifications/sql/oracle/upgrade/upgrade-0.1d-0.2d.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/notifications/sql/oracle/upgrade/upgrade-0.1d-0.2d.sql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/notifications/sql/oracle/upgrade/upgrade-0.1d-0.2d.sql	19 Aug 2002 20:37:15 -0000	1.1
@@ -0,0 +1 @@
+@@ ../notifications-package-create.sql
Index: openacs-4/packages/notifications/sql/postgresql/notifications-package-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/notifications/sql/postgresql/notifications-package-create.sql,v
diff -u -r1.7 -r1.8
--- openacs-4/packages/notifications/sql/postgresql/notifications-package-create.sql	12 Aug 2002 19:56:32 -0000	1.7
+++ openacs-4/packages/notifications/sql/postgresql/notifications-package-create.sql	19 Aug 2002 20:37:15 -0000	1.8
@@ -267,6 +267,7 @@
 declare
     p_notification_id               alias for $1;
 begin
+    delete from notifications where notification_id = p_notification_id;
     perform acs_object__delete(p_notification_id);
     return 0;
 end;
Index: openacs-4/packages/notifications/sql/postgresql/upgrade/upgrade-0.1d-0.2d.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/notifications/sql/postgresql/upgrade/upgrade-0.1d-0.2d.sql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/notifications/sql/postgresql/upgrade/upgrade-0.1d-0.2d.sql	19 Aug 2002 20:37:15 -0000	1.1
@@ -0,0 +1 @@
+\i ../notifications-package-create.sql