Documentation Center

Specifying the unique index

Outbound E-mail comes with a default set of extended detail fields, of which IDENTIFICATION_KEY and IDENTIFICATION_SOURCE are used to uniquely identify Contacts. This task describes how to change the unique index (from IDENTIFICATION_KEY and IDENTIFICATION_SOURCE to MAIL).

Before you begin

The procedure described in this task must only be executed by a Database Administrator (DBA).

Procedure

  1. Access the database server on which you installed the Outbound E-mail database (the database for Outbound E-mail on the Content Manager Server).
  2. Open the tridion_cm_email database.
  3. Navigate to the CONTACTS_EXTENDED_DETAILS table.
  4. Change the unique index as follows:
    1. Delete the ux_identification index that uniquely identify rows in the CONTACTS_EXTENDED_DETAILS table.
    2. Make the MAIL field mandatory (NOT NULL).
    3. Recreate the ux_identification index, for example by running the following command:
      create unique index ux_identification on contacts_extended_details (mail)
    4. Save the changes.
  5. Navigate to the IMPORT_CONTACTS table and repeat the steps to change the unique index.
  6. Navigate to the IMPORT_KEYWORDS table and repeat the steps to change the unique index.
  7. Access the database server on which you installed the Subscription Management database on the Presentation Server.
  8. Open the tridion_submgmt database and navigate to the CONTACTS_EXTENDED_DETAILS table.
  9. Repeat the steps to change the unique index in the Subscription Management database.

Results

You have changed the unique index defining the extended details used to uniquely identify contacts for Outbound E-mail Contacts.

What to do next

After you have changed the unique index, you need to configure the Content Manager server to indicate which Contact Details uniquely identify Contacts. You do this by setting the isIdentificationKey="true" attribute in the OutboundEmail.xml configuration file.