1 <?xml version=
"1.0" encoding=
"iso-8859-1" ?>
4 <base>CRM/Mailing/Event
</base>
5 <class>TrackableURLOpen
</class>
6 <name>civicrm_mailing_event_trackable_url_open
</name>
7 <comment>Tracks when a TrackableURL is clicked by a recipient.
</comment>
8 <archive>true
</archive>
11 <title>Trackable URL Open ID
</title>
12 <type>int unsigned
</type>
13 <required>true
</required>
17 <autoincrement>true
</autoincrement>
20 <name>event_queue_id
</name>
21 <title>Event Queue
</title>
22 <type>int unsigned
</type>
23 <required>true
</required>
24 <comment>FK to EventQueue
</comment>
27 <name>event_queue_id
</name>
28 <table>civicrm_mailing_event_queue
</table>
30 <onDelete>CASCADE
</onDelete>
33 <name>trackable_url_id
</name>
34 <title>Trackable Url
</title>
35 <type>int unsigned
</type>
36 <required>true
</required>
37 <comment>FK to TrackableURL
</comment>
40 <name>trackable_url_id
</name>
41 <table>civicrm_mailing_trackable_url
</table>
43 <onDelete>CASCADE
</onDelete>
46 <name>time_stamp
</name>
47 <title>Timestamp
</title>
48 <type>timestamp
</type>
49 <default>CURRENT_TIMESTAMP
</default>
50 <required>true
</required>
51 <comment>When this trackable URL open occurred.
</comment>