X-Git-Url: https://vcs.fsf.org/?a=blobdiff_plain;f=xml%2Fschema%2FActivity%2FActivity.xml;h=5c5d013bcca78c1890b83fe5261e8f139831a4f6;hb=a0655ae97eddb05d3842de31fb33a9adba468aa3;hp=b47eb8900b427005f635748bf25d110493496f41;hpb=639cf3412445892eb6b6fe96d8e09776d3a38eeb;p=civicrm-core.git

diff --git a/xml/schema/Activity/Activity.xml b/xml/schema/Activity/Activity.xml
index b47eb8900b..5c5d013bcc 100644
--- a/xml/schema/Activity/Activity.xml
+++ b/xml/schema/Activity/Activity.xml
@@ -3,7 +3,7 @@
   <base>CRM/Activity</base>
   <class>Activity</class>
   <name>civicrm_activity</name>
-  <comment>Other Activity  details stored here include contact, location, details.</comment>
+  <comment>Other Activity details stored here include contact, location, details.</comment>
   <add>1.1</add>
   <log>true</log>
   <field>
@@ -15,7 +15,6 @@
     <required>true</required>
     <comment>Unique  Other Activity ID</comment>
     <add>1.1</add>
-
   </field>
   <primaryKey>
     <name>id</name>
@@ -45,7 +44,6 @@
     <add>2.0</add>
     <drop>3.2</drop>
   </index>
-
   <field>
     <name>source_record_id</name>
     <type>int unsigned</type>
@@ -81,7 +79,6 @@
     <fieldName>activity_type_id</fieldName>
     <add>1.6</add>
   </index>
-
   <field>
     <name>target_entity_table</name>
     <type>varchar</type>
@@ -91,7 +88,6 @@
     <add>1.1</add>
     <drop>2.0</drop>
   </field>
-
   <field>
     <name>target_entity_id</name>
     <type>int unsigned</type>
@@ -100,7 +96,6 @@
     <add>1.1</add>
     <drop>2.0</drop>
   </field>
-
   <field>
     <name>subject</name>
     <uniqueName>activity_subject</uniqueName>
@@ -114,9 +109,8 @@
       <type>Text</type>
     </html>
     <add>1.1</add>
-    <modify>2.0</modify>
+    <change>2.0</change>
   </field>
-
   <field>
     <name>scheduled_date</name>
     <type>datetime</type>
@@ -124,7 +118,6 @@
     <add>1.1</add>
     <drop>2.0</drop>
   </field>
-
   <field>
     <name>activity_date_time</name>
     <import>true</import>
@@ -138,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>
@@ -152,7 +150,6 @@
     <add>1.1</add>
     <drop>2.0</drop>
   </field>
-
   <field>
     <name>duration_minutes</name>
     <type>int unsigned</type>
@@ -160,7 +157,6 @@
     <add>1.1</add>
     <drop>2.0</drop>
   </field>
-
   <field>
     <name>duration</name>
     <uniqueName>activity_duration</uniqueName>
@@ -174,7 +170,6 @@
       <type>Text</type>
     </html>
   </field>
-
   <field>
     <name>location</name>
     <uniqueName>activity_location</uniqueName>
@@ -189,7 +184,6 @@
     </html>
     <add>1.1</add>
   </field>
-
   <field>
     <name>phone_id</name>
     <type>int unsigned</type>
@@ -207,7 +201,6 @@
     <add>2.0</add>
     <onDelete>SET NULL</onDelete>
   </foreignKey>
-
   <field>
     <name>phone_number</name>
     <title>Phone (called) Number</title>
@@ -219,7 +212,6 @@
     </html>
     <add>2.0</add>
   </field>
-
   <field>
     <name>details</name>
     <uniqueName>activity_details</uniqueName>
@@ -235,7 +227,6 @@
     </html>
     <add>1.1</add>
   </field>
-
   <field>
     <name>status</name>
     <type>enum</type>
@@ -245,13 +236,12 @@
     <add>1.1</add>
     <drop>2.0</drop>
   </field>
-
   <field>
     <name>status_id</name>
     <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>
@@ -263,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>
@@ -290,7 +285,6 @@
     <add>1.1</add>
     <onDelete>CASCADE</onDelete>
   </foreignKey>
-
   <field>
     <name>is_test</name>
     <title>Test</title>