Merge pull request #9739 from nditech/CRM-19915

[civicrm-core.git] / xml / schema / Mailing / Event / Unsubscribe.xml

diff --git a/xml/schema/Mailing/Event/Unsubscribe.xml b/xml/schema/Mailing/Event/Unsubscribe.xml
index 9309bc6b48f4f31fcb8eb19f66e011a15b394041..1dde5f09861201b6742d51487b9e47680acc7a7e 100644 (file)
--- a/xml/schema/Mailing/Event/Unsubscribe.xml
+++ b/xml/schema/Mailing/Event/Unsubscribe.xml
@@ -8,6 +8,7 @@
   <archive>true</archive>
   <field>
     <name>id</name>
+    <title>Unsubscribe ID</title>
     <type>int unsigned</type>
     <required>true</required>
   </field>
@@ -17,6 +18,7 @@
   </primaryKey>
   <field>
     <name>event_queue_id</name>
+    <title>Mailing Event Queue</title>
     <type>int unsigned</type>
     <required>true</required>
     <comment>FK to EventQueue</comment>
@@ -29,13 +31,16 @@
   </foreignKey>
   <field>
     <name>org_unsubscribe</name>
+    <title>Unsubscribe is for Organization?</title>
     <type>boolean</type>
     <required>true</required>
     <comment>Unsubscribe at org- or group-level</comment>
   </field>
   <field>
     <name>time_stamp</name>
-    <type>datetime</type>
+    <title>Unsubscribe Timestamp</title>
+    <type>timestamp</type>
+    <default>CURRENT_TIMESTAMP</default>
     <required>true</required>
     <comment>When this delivery event occurred.</comment>
   </field>