Index: openacs-4/packages/news/sql/postgresql/news-drop.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/news/sql/postgresql/news-drop.sql,v
diff -u -N -r1.11.2.1 -r1.11.2.2
--- openacs-4/packages/news/sql/postgresql/news-drop.sql	15 Mar 2019 17:14:34 -0000	1.11.2.1
+++ openacs-4/packages/news/sql/postgresql/news-drop.sql	29 Nov 2019 15:14:38 -0000	1.11.2.2
@@ -140,11 +140,26 @@
 select inline_0 ();
 drop function inline_0 ();
 
+-- *** Drop News Notification Type ***
+--
+select notification_type__delete((
+       select type_id from notification_types
+        where short_name = 'one_news_item_notif'));
 
--- *** Search contract de-registration ***
+-- *** Service contract de-registration ***
 --
 select acs_sc_impl__delete(
 	   'FtsContentProvider',		-- impl_contract_name
            'news'				-- impl_name
 );
 
+select acs_sc_impl__delete(
+	   'RssGenerationSubscriber',		-- impl_contract_name
+           'news'				-- impl_name
+);
+
+select acs_sc_impl__delete(
+	   'NotificationType',          -- impl_contract_name
+           'news_item_notif_type'	-- impl_name
+);
+