Index: openacs-4/packages/dotlrn/sql/postgresql/security-drop.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/sql/postgresql/security-drop.sql,v
diff -u -r1.2 -r1.2.2.1
--- openacs-4/packages/dotlrn/sql/postgresql/security-drop.sql	9 Aug 2002 18:39:25 -0000	1.2
+++ openacs-4/packages/dotlrn/sql/postgresql/security-drop.sql	17 Oct 2002 12:19:55 -0000	1.2.2.1
@@ -39,7 +39,9 @@
 
     perform acs_privilege__remove_child(''dotlrn_edit_community'', ''dotlrn_view_community'');
     perform acs_privilege__remove_child(''dotlrn_admin_community'', ''dotlrn_edit_community'');
+    perform acs_privilege__remove_child(''dotlrn_admin_community'', ''dotlrn_spam_community'');
 
+
     delete
     from acs_permissions
     where privilege in (''dotlrn_admin_community'',
@@ -59,7 +61,7 @@
     perform acs_privilege__drop_privilege(''dotlrn_edit_community'');
     perform acs_privilege__drop_privilege(''dotlrn_view_community'');
     perform acs_privilege__drop_privilege(''dotlrn_view_community_type'');
-
+    perform acs_privilege__drop_privilege(''dotlrn_spam_community'');
     return 0;
 
 end;' language 'plpgsql';
