projects / civicrm-core.git / blobdiff
? search:
summary | shortlog | log | commit | commitdiff | tree
raw | inline | side by side
CRM-19821 set activity_status_id to 'export'
[civicrm-core.git] / xml / schema / Activity / Activity.xml
diff --git a/xml/schema/Activity/Activity.xml b/xml/schema/Activity/Activity.xml
index e2589d56faa673271639d98c44873d3df840db1c..5c5d013bcca78c1890b83fe5261e8f139831a4f6 100644 (file)
--- 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>
@@ -134,9 +127,15 @@
     <comment>Date and time this activity is scheduled to occur. Formerly named scheduled_date_time.</comment>
     <html>
       <type>Select Date</type>
+      <formatType>activityDateTime</formatType>
     </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>
@@ -151,7 +150,6 @@
     <add>1.1</add>
     <drop>2.0</drop>
   </field>
-
   <field>
     <name>duration_minutes</name>
     <type>int unsigned</type>
@@ -159,7 +157,6 @@
     <add>1.1</add>
     <drop>2.0</drop>
   </field>
-
   <field>
     <name>duration</name>
     <uniqueName>activity_duration</uniqueName>
@@ -173,7 +170,6 @@
       <type>Text</type>
     </html>
   </field>
-
   <field>
     <name>location</name>
     <uniqueName>activity_location</uniqueName>
@@ -188,7 +184,6 @@
     </html>
     <add>1.1</add>
   </field>
-
   <field>
     <name>phone_id</name>
     <type>int unsigned</type>
@@ -206,7 +201,6 @@
     <add>2.0</add>
     <onDelete>SET NULL</onDelete>
   </foreignKey>
-
   <field>
     <name>phone_number</name>
     <title>Phone (called) Number</title>
@@ -218,7 +212,6 @@
     </html>
     <add>2.0</add>
   </field>
-
   <field>
     <name>details</name>
     <uniqueName>activity_details</uniqueName>
@@ -234,7 +227,6 @@
     </html>
     <add>1.1</add>
   </field>
-
   <field>
     <name>status</name>
     <type>enum</type>
@@ -244,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>
@@ -262,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>
@@ -289,7 +285,6 @@
     <add>1.1</add>
     <onDelete>CASCADE</onDelete>
   </foreignKey>
-
   <field>
     <name>is_test</name>
     <title>Test</title>