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

[Christopher Kurtis Koeber]

Thanks so much! This works great.

Regards,

Christopher Kurtis Koeber

-----Original Message-----
From: Kent Oyer [mailto:kent at micro-source.net] 
Sent: Saturday, July 27, 2013 9:41 AM
To: Christopher Koeber; amavis-users at amavis.org
Subject: RE: Storing the Recipient Address in the "msgs" table in SQL

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