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.8 -r1.9 --- openacs-4/packages/news/sql/postgresql/news-drop.sql 3 Feb 2005 00:15:27 -0000 1.8 +++ openacs-4/packages/news/sql/postgresql/news-drop.sql 24 Feb 2005 18:03:04 -0000 1.9 @@ -4,7 +4,6 @@ -- @created 2000-12-20 -- $Id$ - -- unregister content_types from folder create function inline_0 () returns integer as ' @@ -66,22 +65,11 @@ -- delete pertinent info from cr_news --drop table cr_news; +\i news-views-drop.sql +\i news-package-drop.sql --- drop package news -select drop_package('news'); - --- delete news views -drop view news_items_approved; -drop view news_items_live_or_submitted; -drop view news_items_unapproved; -drop view news_item_revisions; -drop view news_item_unapproved; -drop view news_item_full_active; - -drop function news__status (timestamptz, timestamptz); - -- drop CR content_type select content_type__drop_type( 'news', -- content_type @@ -145,3 +133,4 @@ 'FtsContentProvider', -- impl_contract_name 'news' -- impl_name ); +