Merge pull request #19525 from eileenmcnaughton/member_soft
[civicrm-core.git] / xml / schema / Mailing / Event / Unsubscribe.xml
index 3504bf8c8142d8c99dce1844c4908c33bc7123b4..a4f10f01055e0938326e992f6a84b2fc518fd95c 100644 (file)
@@ -6,11 +6,15 @@
   <name>civicrm_mailing_event_unsubscribe</name>
   <comment>Tracks when a recipient unsubscribes from a group/domain</comment>
   <archive>true</archive>
+  <component>CiviMail</component>
   <field>
     <name>id</name>
     <title>Unsubscribe ID</title>
     <type>int unsigned</type>
     <required>true</required>
+    <html>
+      <type>Number</type>
+    </html>
   </field>
   <primaryKey>
     <name>id</name>
   </primaryKey>
   <field>
     <name>event_queue_id</name>
-    <title>Mailing Event Queue</title>
+    <title>Event Queue ID</title>
     <type>int unsigned</type>
     <required>true</required>
     <comment>FK to EventQueue</comment>
+    <html>
+      <label>Event Queue</label>
+    </html>
   </field>
   <foreignKey>
     <name>event_queue_id</name>
@@ -39,7 +46,8 @@
   <field>
     <name>time_stamp</name>
     <title>Unsubscribe Timestamp</title>
-    <type>datetime</type>
+    <type>timestamp</type>
+    <default>CURRENT_TIMESTAMP</default>
     <required>true</required>
     <comment>When this delivery event occurred.</comment>
   </field>