-- -- 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.1.1 2002/07/09 17:34:58 rmello 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