Modify madrill table to add json data and open flag

[eberhardtm]

Mandrill only stores data about emails for 30 days. We need to capture and store email data indefinitely.

1. Add needed columns to the table in hms. opened flag to tell us if the email has been opened. A column for the email data returned from madrill API(assuming this is a json return so just stuff it in the db and that should work with existing UI). Might want to check how the UI works right now to see how the data is coming back from mandrill
2. Create a functional php script that will be setup on a cron job. Script will select all unopened emails less then 30 days old from the hms_prod db and query mandrill API. If email has been opened set the correct flag and store the associated email data returned from madrill for later use.
3. Update UI to pull from db instead of mandrill API

[eberhardtm]

Done