Index: openacs-4/packages/acs-messaging/sql/upgrade-4.0.1a-4.0.1.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-messaging/sql/Attic/upgrade-4.0.1a-4.0.1.sql,v
diff -u -N
--- openacs-4/packages/acs-messaging/sql/upgrade-4.0.1a-4.0.1.sql	13 Mar 2001 22:59:26 -0000	1.1
+++ /dev/null	1 Jan 1970 00:00:00 -0000
@@ -1,49 +0,0 @@
---
--- acs-messaging sql/upgrade-4.0.1a-4.0.1.sql
---
--- @author jmp@arsdigita.com
--- @creation-date 2000-11-15
--- @cvs-id $Id: upgrade-4.0.1a-4.0.1.sql,v 1.1 2001/03/13 22:59:26 ben Exp $
---
-
-begin
-    acs_object_type.create_type (
-        supertype => 'content_revision',
-        object_type => 'acs_message_revision',
-        pretty_name => 'Message Revision',
-        pretty_plural => 'Message Revisions',
-        table_name => 'CR_REVISIONS',
-        id_column => 'REVISION_ID',
-        name_method => 'ACS_OBJECT.DEFAULT_NAME'
-    );
-end;
-/
-show errors
-
-alter table acs_messages_outgoing add (
-    to_address varchar2(1000)
-        constraint amo_to_address_nn
-            not null
-                disable
-);
-
-update acs_messages_outgoing
-    set to_address = (select email from parties where party_id = recipient_id);
-
-alter table acs_messages_outgoing
-    drop constraint acs_messages_outgoing_pk;
-
-alter table acs_messages_outgoing
-    add constraint acs_messages_outgoing_pk
-        primary key (message_id, to_address);
-
-alter table acs_messages_outgoing
-    modify constraint amo_to_address_nn enable;
-
-alter table acs_messages_outgoing
-    drop column recipient_id;
-
-@@ acs-messaging-views
-@@ acs-messaging-packages
-
-set feedback on