Merge pull request #12669 from eileenmcnaughton/dedupe_zero

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

diff --git a/xml/schema/Mailing/Mailing.xml b/xml/schema/Mailing/Mailing.xml
index 25d2488079bc1e647ee186b44e8a2d464b96ca76..0ef0930f0a87702b6b5907387abfa703fafba538 100644 (file)
--- a/xml/schema/Mailing/Mailing.xml
+++ b/xml/schema/Mailing/Mailing.xml
@@ -272,7 +272,7 @@
   <field>
     <name>created_date</name>
     <type>timestamp</type>
-    <default>CURRENT_TIMESTAMP</default>
+    <default>NULL</default>
     <required>false</required>
     <title>Mailing Created Date</title>
     <comment>Date and time this mailing was created.</comment>
@@ -282,6 +282,16 @@
       <formatType>activityDateTime</formatType>
     </html>
   </field>
+  <field>
+   <name>modified_date</name>
+   <uniqueName>mailing_modified_date</uniqueName>
+   <type>timestamp</type>
+   <comment>When the mailing (or closely related entity) was created or modified or deleted.</comment>
+   <required>false</required>
+   <export>true</export>
+   <default>CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP</default>
+   <add>4.7</add>
+  </field>
   <field>
     <name>scheduled_id</name>
     <title>Scheduled By</title>