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 6599ab1a7bb8ed49caa5a4f7ff4066297f0efbe8..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>
@@ -131,6 +131,11 @@
     </html>
     <add>2.0</add>
   </field>
+  <index>
+    <name>index_activity_date_time</name>
+    <fieldName>activity_date_time</fieldName>
+    <add>4.7</add>
+  </index>
   <field>
     <name>due_date_time</name>
     <type>datetime</type>
@@ -236,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>
@@ -248,6 +253,11 @@
       <type>Select</type>
     </html>
   </field>
+  <index>
+    <name>index_status_id</name>
+    <fieldName>status_id</fieldName>
+    <add>4.7</add>
+  </index>
   <field>
     <name>priority_id</name>
     <type>int unsigned</type>
@@ -453,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>