Storing the Recipient Address in the "msgs" table in SQL

[Kent Oyer]

Recipients are stored in the "msgrcpt" table. If a message has more than one recipient, you will find just one record in the 'msgs' table but there will be multiple records in 'msgrcpt', one for each recipient. The column you are looking for is the 'rid' column. This contains the recipient id which you need to join with the 'maddr' table to find the actual email address.

SELECT msgrcpt.*,maddr.email FROM msgrcpt INNER JOIN maddr ON msgrcpt.rid = maddr.id;

Kent

________________________________________
From: Christopher Koeber [ckoeber at gmail.com]
Sent: Friday, July 26, 2013 6:15 PM
To: amavis-users at amavis.org
Subject: Storing the Recipient Address in the "msgs" table in SQL

Hello,

I have a rather simple question that I couldn't find in the documentation.

Is there a way (setting, etc.) to store the recipient address in the "msgs" table for the received messages? I am hoping I can simply add an additional column to store this information.

I got the SQL database working 100% (rather easy so thanks to all for good documentation) but I found that it is father hard to track who has received the messages in the "msgs" table.

Thank you for your time.

Regards,
Christopher Koeber