xml/schema/Core/UFMatch.xml

   1 <?xml version="1.0" encoding="iso-8859-1" ?>
   2
   3 <table>
   4   <base>CRM/Core</base>
   5   <class>UFMatch</class>
   6   <name>civicrm_uf_match</name>
   7   <comment>The mapping from an user framework (UF) object to a CRM object.</comment>
   8   <add>1.1</add>
   9   <log>true</log>
  10   <field>
  11       <name>id</name>
  12       <type>int unsigned</type>
  13       <required>true</required>
  14       <comment>System generated ID.</comment>
  15       <add>1.1</add>
  16   </field>
  17   <primaryKey>
  18        <name>id</name>
  19        <autoincrement>true</autoincrement>
  20   </primaryKey>
  21   <field>
  22       <name>domain_id</name>
  23       <type>int unsigned</type>
  24       <required>true</required>
  25       <comment>Which Domain is this match entry for</comment>
  26       <add>3.0</add>
  27   </field>
  28   <foreignKey>
  29        <name>domain_id</name>
  30        <table>civicrm_domain</table>
  31        <key>id</key>
  32        <add>3.0</add>
  33   </foreignKey>
  34   <field>
  35        <name>uf_id</name>
  36        <type>int unsigned</type>
  37        <required>true</required>
  38        <comment>UF ID</comment>
  39        <add>1.1</add>
  40   </field>
  41   <index>
  42      <name>I_civicrm_uf_match_uf_id</name>
  43      <fieldName>uf_id</fieldName>
  44      <add>3.3</add>
  45   </index>
  46   <field>
  47        <name>uf_name</name>
  48        <type>varchar</type>
  49        <length>128</length>
  50        <comment>UF Name</comment>
  51        <add>1.9.kabissa</add>
  52   </field>
  53   <field>
  54        <name>contact_id</name>
  55       <type>int unsigned</type>
  56       <comment>FK to Contact ID</comment>
  57       <add>1.1</add>
  58   </field>
  59   <foreignKey>
  60        <name>contact_id</name>
  61        <table>civicrm_contact</table>
  62        <key>id</key>
  63        <add>1.1</add>
  64        <onDelete>CASCADE</onDelete>
  65   </foreignKey>
  66   <field>
  67        <name>email</name>
  68        <type>varchar</type>
  69        <length>64</length>
  70        <rule>email</rule>
  71        <comment>Email address</comment>
  72        <add>1.1</add>
  73        <drop>2.0</drop>
  74   </field>
  75   <field>
  76     <name>language</name>
  77     <type>varchar</type>
  78     <length>5</length>
  79     <comment>UI language preferred by the given user/contact</comment>
  80     <add>2.1</add>
  81   </field>
  82   <index>
  83      <name>UI_uf_id_domain_id</name>
  84      <fieldName>uf_id</fieldName>
  85      <fieldName>domain_id</fieldName>
  86      <unique>true</unique>
  87      <add>1.5</add>
  88      <drop>1.7</drop>
  89   </index>
  90   <index>
  91      <name>UI_uf_name_domain_id</name>
  92      <fieldName>uf_name</fieldName>
  93      <fieldName>domain_id</fieldName>
  94      <unique>true</unique>
  95      <add>2.1</add>
  96   </index>
  97   <index>
  98     <name>UI_contact_domain_id</name>
  99     <fieldName>contact_id</fieldName>
 100      <fieldName>domain_id</fieldName>
 101     <unique>true</unique>
 102     <add>1.6</add>
 103   </index>
 104 </table>