Email Log Rotation and New Fields

1. Make all DB fields in EmailLog table Camel formation.

2. Store complete Email message that has been sent out to the User. It can play the role of Web Copy when needed.

We should have new fields added which will store:

• Email Subject
• Email Body
• AdditionalRecepients (all recipients like CC, BCC users, groups and so on - it's okay to store)
• EmailKey VARCHAR 32 - md5(from+to+subject+time) to be able to reference to this log from the Front end - if needed (will use in URL)

3. Add a new Tag - we would need to have some sort of Tag which can be used within the Template and which during the mailing will be build correct URL with proper Key so users can click and view they web version if needed.

4. Create new setting "Keep Email Log for" (KeepEmailLog) in System Configuration -> Advanced: Mailing Settings, after "Default E-mail Recipients" which would allow to specify number days to keep Email logs and delete all older ones. It's kind of rotation.

[B]Keep Email Log for[/B]: Never (turned off), 1 day, 1 week, 2 weeks, 1 month, 3 months, 1 year, Forever (never deleted automatically)

[B]Hint[/B]: Email Log stores the exact copy of all emails that been sent out by your website. The following information is stored: Time, Sender, Recipient, Subject and Email Body. This setting allows you to control for how long these emails will be stored in the log and then automatically deleted. Use option Never to completely turn email logging off, and option Forever to disable automatic log cleanup.

a. New install - default to 1 month
b. Upgrade - default to Forever

5. Create new Scheduled Job which would do cleaning based on setting specified in 4)