Index: openacs-4/packages/acs-messaging/sql/postgresql/acs-messaging-drop.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-messaging/sql/postgresql/acs-messaging-drop.sql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/acs-messaging/sql/postgresql/acs-messaging-drop.sql	23 May 2001 16:38:19 -0000	1.1
+++ openacs-4/packages/acs-messaging/sql/postgresql/acs-messaging-drop.sql	14 Jun 2001 05:03:39 -0000	1.2
@@ -6,10 +6,53 @@
 -- @cvs-id $Id$
 --
 
-begin
-  acs_object_type__drop_type('acs_message');
-end;
+-- drop functions
+drop function acs_message__edit (integer,varchar,varchar,varchar,
+                                 text,timestamp,integer,varchar,boolean);
+drop function acs_message__new (integer,integer,timestamp,integer,
+                                varchar,varchar,varchar,varchar,varchar,text,
+                                integer,integer,integer,varchar,integer,boolean);
+drop function acs_message__delete (integer);
+drop function acs_message__message_p (integer);
+drop function acs_message__send (integer,varchar,integer,timestamp);
+drop function acs_message__send (integer,integer,integer,timestamp);
+drop function acs_message__first_ancestor (integer);
+drop function acs_message__new_file (integer,integer,varchar,varchar,
+                                     text,varchar,text,timestamp,integer,
+                                     varchar,boolean);
+drop function acs_message__edit_file (integer,varchar,text,varchar,
+                                      text,timestamp,integer,varchar,boolean);
+drop function acs_message__delete_file (integer);
+drop function acs_message__new_image (integer,integer,varchar,varchar,
+                                      text,varchar,text,integer,integer,
+                                      timestamp,integer,varchar,boolean);
+drop function acs_message__edit_image (integer,varchar,text,varchar,
+                                       text,integer,integer,timestamp,integer,
+                                       varchar,boolean);
+drop function acs_message__delete_image (integer);
+drop function acs_message__new_extlink (varchar,integer,varchar,varchar,text,
+                                        integer,timestamp,integer,varchar);
+drop function acs_message__edit_extlink (integer,varchar,varchar,text);
+drop function acs_message__delete_extlink (integer);
+drop function acs_message__name (integer);
 
+-- drop views
+drop view acs_messages_all;
+drop view acs_messages_latest;
+
+-- drop indices
+drop index acs_messages_reply_to_idx;
+drop index acs_messages_sender_idx;
+
+-- drop tables
+drop table acs_messages_outgoing;
+drop table acs_messages;
+
+-- drop acs_object_types
+select acs_object_type__drop_type('acs_message_revision', 't');
+select acs_object_type__drop_type('acs_message', 't');
+
+
 --drop package acs_message;
 
 --drop table acs_messages_outgoing;