<import>true</import>
<headerPattern>/legal\s?id/i</headerPattern>
<dataPattern>/\w+?\d{5,}/</dataPattern>
- <comment>May be used for SSN, EIN/TIN, Household ID (census) or other applicable unique legal/government ID.
- </comment>
+ <comment>May be used for SSN, EIN/TIN, Household ID (census) or other applicable unique legal/government ID.</comment>
<add>1.1</add>
<html>
<type>Text</type>
<length>32</length>
<comment>API Key for validating requests related to this contact.</comment>
<add>2.2</add>
+ <permission>
+ <or>administer CiviCRM, edit api keys</or>
+ </permission>
</field>
<index>
<name>index_api_key</name>
<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>
<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>
<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>