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 -r1.5 -r1.6
--- openacs-4/packages/news/sql/postgresql/news-drop.sql	23 Aug 2003 20:23:17 -0000	1.5
+++ openacs-4/packages/news/sql/postgresql/news-drop.sql	5 Jul 2004 15:05:42 -0000	1.6
@@ -16,7 +16,6 @@
     -- v_gc_id       general_comments.comment_id%TYPE;
     -- v_gc_msg_id   acs_messages.message_id%TYPE;
     v_item_cursor RECORD;
-        
 begin
     select content_item__get_id(''news'', null, ''f'') into v_folder_id from dual;
 
@@ -70,22 +69,7 @@
 
 
 -- drop package news
-drop function news__new (integer,varchar,timestamptz,text,varchar,varchar,
-       varchar,integer,timestamptz,integer,timestamptz,varchar,varchar,
-       varchar,integer,boolean);
-drop function news__delete (integer);
-drop function news__make_permanent (integer);
-drop function news__archive (integer,timestamptz);
-drop function news__archive (integer);
-drop function news__set_approve(integer,varchar,timestamptz,
-       timestamptz,integer,timestamptz,varchar,boolean);
-drop function news__name (integer);
-drop function news__revision_new (integer,timestamptz,text,varchar,text,
-       varchar,integer,timestamptz,integer,timestamptz,varchar,timestamptz,varchar,
-       integer,boolean);
-drop function news__revision_set_active (integer);
-drop function news__revision_delete (integer);
-drop function news__clone (integer,integer);
+select drop_package('news');
 
 
 -- delete news views
@@ -96,47 +80,15 @@
 drop view news_item_unapproved;
 drop view news_item_full_active;
 
-drop function news__status (integer);
 
-
--- drop attributes
-begin;
-
--- website archive date of news release
-select content_type__drop_attribute (
-    'news',         -- content_type
-    'archive_date', -- attribute_name
-    'f'             -- drop_column
-);
--- assignement to an authorized user for approval
-select content_type__drop_attribute (
-    'news',          -- content_type
-    'approval_user', -- attribute_name
-    'f'              -- drop_column
-);
--- approval date
-select content_type__drop_attribute (
-    'news',          -- content_type
-    'approval_date', -- attribute_name
-    'f'              -- drop_column
-);
--- approval IP address
-select content_type__drop_attribute (
-    'news',        -- content_type
-    'approval_ip', -- attribute_name
-    'f'            -- drop_column
-);
-
 -- drop CR content_type
 select content_type__drop_type(
         'news',    -- content_type
         't',       -- drop_children_p
         't'        -- drop_table_p
 );
 
-end;
 
-
 -- delete privileges;
 create function inline_0 ()
 returns integer as '