Merge pull request #23052 from konadave/r25088
[civicrm-core.git] / xml / schema / Core / UFMatch.xml
index fb3a05425dfb6af68856c6c1ecf9bd288bd5a8ef..289f6bf92586b2b58f9206ef9af122963b12c6c7 100644 (file)
@@ -13,6 +13,9 @@
     <type>int unsigned</type>
     <required>true</required>
     <comment>System generated ID.</comment>
+    <html>
+      <type>Number</type>
+    </html>
     <add>1.1</add>
   </field>
   <primaryKey>
@@ -21,7 +24,7 @@
   </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>
@@ -30,6 +33,9 @@
       <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>