projects / civicrm-core.git / blobdiff
? search:
summary | shortlog | log | commit | commitdiff | tree
raw | inline | side by side
Add index to civicrm_contact.created_date & modified_date
[civicrm-core.git] / xml / schema / Contact / Contact.xml
diff --git a/xml/schema/Contact/Contact.xml b/xml/schema/Contact/Contact.xml
index 1539d0c6e8b3289e7d950b61c57a87bf3d9f312d..14965f9ffcb4f6960bac163b6b6b2f2d8d5a0315 100644 (file)
--- a/xml/schema/Contact/Contact.xml
+++ b/xml/schema/Contact/Contact.xml
@@ -496,6 +496,8 @@
       <optionGroupName>communication_style</optionGroupName>
     </pseudoconstant>
     <export>true</export>
+    <import>true</import>
+    <headerPattern>/style/i</headerPattern>
     <comment>Communication style (e.g. formal vs. familiar) to use with this contact. FK to communication styles in civicrm_option_value.</comment>
     <add>4.4</add>
     <html>
@@ -874,6 +876,11 @@
     <default>NULL</default>
     <add>4.3</add>
   </field>
+  <index>
+    <name>index_created_date</name>
+    <fieldName>created_date</fieldName>
+    <add>5.18</add>
+  </index>
   <field>
     <name>modified_date</name>
     <type>timestamp</type>
@@ -883,4 +890,9 @@
     <default>CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP</default>
     <add>4.3</add>
   </field>
+  <index>
+    <name>index_modified_date</name>
+    <fieldName>modified_date</fieldName>
+    <add>5.18</add>
+  </index>
 </table>