Index: openacs-4/packages/forums/forums.info
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/forums/forums.info,v
diff -u -r1.7 -r1.8
--- openacs-4/packages/forums/forums.info	25 Jun 2002 15:38:17 -0000	1.7
+++ openacs-4/packages/forums/forums.info	25 Jun 2002 19:32:59 -0000	1.8
@@ -22,6 +22,7 @@
             <file type="package_spec" path="forums.info"/>
             <file type="data_model" db_type="oracle" path="sql/oracle/forums-alerts-create.sql"/>
             <file type="data_model_create" db_type="oracle" path="sql/oracle/forums-create.sql"/>
+            <file type="data_model_drop" db_type="oracle" path="sql/oracle/forums-drop.sql"/>
             <file type="data_model" db_type="oracle" path="sql/oracle/forums-forums-create.sql"/>
             <file type="data_model" db_type="oracle" path="sql/oracle/forums-forums-drop.sql"/>
             <file type="data_model" db_type="oracle" path="sql/oracle/forums-forums-package-create.sql"/>
@@ -31,11 +32,12 @@
             <file type="data_model" db_type="oracle" path="sql/oracle/forums-messages-package-create.sql"/>
             <file type="data_model" db_type="oracle" path="sql/oracle/forums-messages-package-drop.sql"/>
             <file type="data_model" db_type="oracle" path="sql/oracle/forums-notifications-init.sql"/>
+            <file type="data_model" db_type="oracle" path="sql/oracle/forums-notifications-sanitize.sql"/>
             <file type="data_model" db_type="oracle" path="sql/oracle/forums-tree-create.sql"/>
             <file type="data_model_create" db_type="postgresql" path="sql/postgresql/forums-create.sql"/>
             <file type="data_model_drop" db_type="postgresql" path="sql/postgresql/forums-drop.sql"/>
-            <file type="data_model_create" db_type="postgresql" path="sql/postgresql/forums-forums-create.sql"/>
-            <file type="data_model_drop" db_type="postgresql" path="sql/postgresql/forums-forums-drop.sql"/>
+            <file type="data_model" db_type="postgresql" path="sql/postgresql/forums-forums-create.sql"/>
+            <file type="data_model" db_type="postgresql" path="sql/postgresql/forums-forums-drop.sql"/>
             <file type="data_model" db_type="postgresql" path="sql/postgresql/forums-forums-package-create.sql"/>
             <file type="data_model" db_type="postgresql" path="sql/postgresql/forums-forums-package-drop.sql"/>
             <file type="data_model" db_type="postgresql" path="sql/postgresql/forums-messages-create.sql"/>
Index: openacs-4/packages/forums/sql/oracle/forums-drop.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/forums/sql/oracle/forums-drop.sql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/forums/sql/oracle/forums-drop.sql	25 Jun 2002 19:32:59 -0000	1.1
@@ -0,0 +1,24 @@
+
+--
+-- The Forums Package
+--
+-- @author gwong@orchardlabs.com,ben@openforce.biz
+-- @creation-date 2002-05-16
+--
+-- This code is newly concocted by Ben, but with significant concepts and code
+-- lifted from Gilbert's UBB forums. Thanks Orchard Labs.
+--
+
+-- notifications
+@ forums-notifications-sanitize.sql
+
+-- tree stuff
+@ forums-tree-drop.sql
+
+-- The messages
+@ forums-messages-drop.sql
+@ forums-messages-package-drop.sql
+
+-- The basic forum constructs
+@ forums-forums-drop.sql
+@ forums-forums-package-drop.sql
Index: openacs-4/packages/forums/sql/oracle/forums-notifications-sanitize.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/forums/sql/oracle/Attic/forums-notifications-sanitize.sql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/forums/sql/oracle/forums-notifications-sanitize.sql	25 Jun 2002 19:32:59 -0000	1.1
@@ -0,0 +1,19 @@
+--
+-- The Forums Package
+--
+-- @author gwong@orchardlabs.com,ben@openforce.biz
+-- @creation-date 2002-05-16
+--
+-- This code is newly concocted by Ben, but with significant concepts and code
+-- lifted from Gilbert's UBB forums. Thanks Orchard Labs.
+--
+
+declare
+begin
+    for row in (select type_id
+                from notification_types
+                where short_name in (''forums_forum_notif'',''forums_message_notif''))
+    loop
+        notification_type.delete(row.type_id);
+    end loop;
+end;