Merge pull request #9648 from MegaphoneJon/CRM-19608

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

diff --git a/xml/schema/Activity/Activity.xml b/xml/schema/Activity/Activity.xml
index bc55fe656b5924b70ed4a23aaf9b966bd257ca99..6b6da122492cd095a3346467dbef37733ace6dd8 100644 (file)
--- a/xml/schema/Activity/Activity.xml
+++ b/xml/schema/Activity/Activity.xml
@@ -109,7 +109,7 @@
       <type>Text</type>
     </html>
     <add>1.1</add>
-    <modify>2.0</modify>
+    <change>2.0</change>
   </field>
   <field>
     <name>scheduled_date</name>
@@ -241,7 +241,7 @@
     <uniqueName>activity_status_id</uniqueName>
     <title>Activity Status</title>
     <import>true</import>
-    <export>false</export>
+    <export>true</export>
     <headerPattern>/(activity.)?status(.label$)?/i</headerPattern>
     <type>int unsigned</type>
     <comment>ID of the status this activity is currently in. Foreign key to civicrm_option_value.</comment>
@@ -463,4 +463,24 @@
     <headerPattern>/(activity.)?(star|favorite)/i</headerPattern>
     <add>4.7</add>
   </field>
+  <field>
+    <name>created_date</name>
+    <uniqueName>activity_created_date</uniqueName>
+    <type>timestamp</type>
+    <comment>When was the activity was created.</comment>
+    <required>false</required>
+    <export>true</export>
+    <default>NULL</default>
+    <add>4.7</add>
+  </field>
+  <field>
+    <name>modified_date</name>
+    <uniqueName>activity_modified_date</uniqueName>
+    <type>timestamp</type>
+    <comment>When was the activity (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>
 </table>