<add>1.1</add>
<log>true</log>
<field>
- <name>id</name>
- <type>int unsigned</type>
- <required>true</required>
- <comment>Unique Organization ID</comment>
- <add>1.1</add>
+ <name>id</name>
+ <type>int unsigned</type>
+ <required>true</required>
+ <comment>Unique Organization ID</comment>
+ <add>1.1</add>
</field>
<primaryKey>
- <name>id</name>
- <autoincrement>true</autoincrement>
+ <name>id</name>
+ <autoincrement>true</autoincrement>
</primaryKey>
<field>
- <name>contact_id</name>
- <type>int unsigned</type>
- <required>true</required>
- <comment>FK to Contact ID</comment>
- <add>1.1</add>
+ <name>contact_id</name>
+ <type>int unsigned</type>
+ <required>true</required>
+ <comment>FK to Contact ID</comment>
+ <add>1.1</add>
</field>
<foreignKey>
- <name>contact_id</name>
- <table>civicrm_contact</table>
- <key>id</key>
- <add>1.1</add>
+ <name>contact_id</name>
+ <table>civicrm_contact</table>
+ <key>id</key>
+ <add>1.1</add>
</foreignKey>
<field>
- <name>organization_name</name>
- <type>varchar</type>
- <length>128</length>
- <import>true</import>
- <headerPattern>/^organization|(o(rganization\s)?name)$/i</headerPattern>
- <dataPattern>/^\w+$/</dataPattern>
- <comment>Organization Name.</comment>
- <fulltext/>
- <add>1.1</add>
+ <name>organization_name</name>
+ <type>varchar</type>
+ <length>128</length>
+ <import>true</import>
+ <headerPattern>/^organization|(o(rganization\s)?name)$/i</headerPattern>
+ <dataPattern>/^\w+$/</dataPattern>
+ <comment>Organization Name.</comment>
+ <fulltext/>
+ <add>1.1</add>
</field>
<index>
- <name>index_organization_name</name>
- <fieldName>organization_name</fieldName>
- <add>1.8</add>
+ <name>index_organization_name</name>
+ <fieldName>organization_name</fieldName>
+ <add>1.8</add>
</index>
<field>
- <name>legal_name</name>
- <type>varchar</type>
- <length>128</length>
- <import>true</import>
- <headerPattern>/^legal|(l(egal\s)?name)$/i</headerPattern>
- <comment>Legal Name.</comment>
- <fulltext/>
- <add>1.1</add>
+ <name>legal_name</name>
+ <type>varchar</type>
+ <length>128</length>
+ <import>true</import>
+ <headerPattern>/^legal|(l(egal\s)?name)$/i</headerPattern>
+ <comment>Legal Name.</comment>
+ <fulltext/>
+ <add>1.1</add>
</field>
<field>
- <name>sic_code</name>
- <type>varchar</type>
- <length>8</length>
- <import>true</import>
- <headerPattern>/^sic|(s(ic\s)?code)$/i</headerPattern>
- <comment>Standard Industry Classification Code.</comment>
- <add>1.1</add>
+ <name>sic_code</name>
+ <type>varchar</type>
+ <length>8</length>
+ <import>true</import>
+ <headerPattern>/^sic|(s(ic\s)?code)$/i</headerPattern>
+ <comment>Standard Industry Classification Code.</comment>
+ <add>1.1</add>
</field>
<field>
- <name>primary_contact_id</name>
- <type>int unsigned</type>
- <comment>Optional FK to Primary Contact for this organization.</comment>
- <add>1.1</add>
+ <name>primary_contact_id</name>
+ <type>int unsigned</type>
+ <comment>Optional FK to Primary Contact for this organization.</comment>
+ <add>1.1</add>
</field>
<foreignKey>
- <name>primary_contact_id</name>
- <table>civicrm_contact</table>
- <key>id</key>
- <add>1.1</add>
+ <name>primary_contact_id</name>
+ <table>civicrm_contact</table>
+ <key>id</key>
+ <add>1.1</add>
</foreignKey>
<index>
<name>UI_contact</name>