<type>int unsigned</type>
<required>true</required>
<comment>System generated ID.</comment>
+ <html>
+ <type>Number</type>
+ </html>
<add>1.1</add>
</field>
<primaryKey>
</primaryKey>
<field>
<name>domain_id</name>
- <title>UF Match Domain ID</title>
+ <title>Domain ID</title>
<type>int unsigned</type>
<required>true</required>
<comment>Which Domain is this match entry for</comment>
<keyColumn>id</keyColumn>
<labelColumn>name</labelColumn>
</pseudoconstant>
+ <html>
+ <label>Domain</label>
+ </html>
<add>3.0</add>
</field>
<foreignKey>
</field>
<field>
<name>contact_id</name>
- <title>CiviCRM Contact ID</title>
+ <title>Contact ID</title>
<type>int unsigned</type>
<comment>FK to Contact ID</comment>
+ <html>
+ <label>Contact</label>
+ </html>
<add>1.1</add>
</field>
<foreignKey>
<add>1.1</add>
<onDelete>CASCADE</onDelete>
</foreignKey>
- <field>
- <name>email</name>
- <type>varchar</type>
- <length>64</length>
- <rule>email</rule>
- <comment>Email address</comment>
- <add>1.1</add>
- <drop>2.0</drop>
- </field>
<field>
<name>language</name>
<title>Preferred Language</title>
<comment>UI language preferred by the given user/contact</comment>
<add>2.1</add>
</field>
- <index>
- <name>UI_uf_id_domain_id</name>
- <fieldName>uf_id</fieldName>
- <fieldName>domain_id</fieldName>
- <unique>true</unique>
- <add>1.5</add>
- <drop>1.7</drop>
- </index>
<index>
<name>UI_uf_name_domain_id</name>
<fieldName>uf_name</fieldName>