1 <?xml version=
"1.0" encoding=
"iso-8859-1" ?>
4 <base>CRM/Mailing/Event
</base>
5 <class>Unsubscribe
</class>
6 <name>civicrm_mailing_event_unsubscribe
</name>
7 <comment>Tracks when a recipient unsubscribes from a group/domain
</comment>
8 <archive>true
</archive>
9 <component>CiviMail
</component>
12 <title>Unsubscribe ID
</title>
13 <type>int unsigned
</type>
14 <required>true
</required>
18 <autoincrement>true
</autoincrement>
21 <name>event_queue_id
</name>
22 <title>Mailing Event Queue
</title>
23 <type>int unsigned
</type>
24 <required>true
</required>
25 <comment>FK to EventQueue
</comment>
28 <name>event_queue_id
</name>
29 <table>civicrm_mailing_event_queue
</table>
31 <onDelete>CASCADE
</onDelete>
34 <name>org_unsubscribe
</name>
35 <title>Unsubscribe is for Organization?
</title>
37 <required>true
</required>
38 <comment>Unsubscribe at org- or group-level
</comment>
41 <name>time_stamp
</name>
42 <title>Unsubscribe Timestamp
</title>
43 <type>timestamp
</type>
44 <default>CURRENT_TIMESTAMP
</default>
45 <required>true
</required>
46 <comment>When this delivery event occurred.
</comment>