Customizing the message archiving table

Located in $HCIROOT/archiving are two SQL files that you can customize for message archiving.

  • create_template.sql

    This is used to create the table.

    In this file, TABLENAME is replaced by the Message Archiving table configured for the thread.

  • insert_template.sql

    This is used to insert the data into the table.

    In this file, TABLENAME is replaced by the Message Archiving table configured for the thread.

    The other fields in angle brackets are replaced by the matching metadata field when the message is stored.

By modifying these files, you can control the table structure, data types, and what metadata fields are stored. It is suggested that you put any modifications into $HCISITEDIR/archiving.