Details
-
Type:
New Feature
-
Status: Won't Do
-
Priority:
Major
-
Resolution: Won't Do
-
Affects Version/s: 4.3.0
-
Fix Version/s: Unscheduled
-
Component/s: CiviMail
-
Labels:None
-
Versioning Impact:Patch (backwards-compatible bug fixes)
Description
civicrm_mailing_event_unsubscribe
civicrm_mailing_event_trackable_url_open
civicrm_mailing_event_reply
civicrm_mailing_event_opened
civicrm_mailing_event_forward
civicrm_mailing_event_delivered
civicrm_mailing_event_bounce
civicrm_mailing_event_queue
civicrm_mailing_spool
civicrm_mailing_recipients
civicrm_mailing_job
civicrm_mailing_trackable_url
civicrm_mailing_group
civicrm_mailing
civicrm_activity
civicrm_activity_assignment
civicrm_activity_target
- if archiving is enabled, create
- archive_tables which are exactly the same as mailing_* and activity_*
- The archival DB can be a separate DB, similar to the logging DB
- when a mailing is archived - copy all things related to:
- mailing_id FROM mailing_* to archive_mailing_*
- all activities related to bulk mailing to archive_activity_*
- delete the rows copied from mailing_, activity
- to restore a mailing do the reverse
- on upgrade, upgrade both mailing and archive tables