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.