xml/schema/Dedupe/Rule.xml

   1 <?xml version="1.0" encoding="utf-8" ?>
   2 <table>
   3   <base>CRM/Dedupe</base>
   4   <class>Rule</class>
   5   <name>civicrm_dedupe_rule</name>
   6   <comment>Dedupe rules for use by rule groups</comment>
   7   <add>1.8</add>
   8   <field>
   9     <name>id</name>
  10     <type>int unsigned</type>
  11     <required>true</required>
  12     <comment>Unique dedupe rule id</comment>
  13     <add>1.8</add>
  14   </field>
  15   <primaryKey>
  16     <name>id</name>
  17     <autoincrement>true</autoincrement>
  18   </primaryKey>
  19   <field>
  20     <name>dedupe_rule_group_id</name>
  21     <type>int unsigned</type>
  22     <required>true</required>
  23     <comment>The id of the rule group this rule belongs to</comment>
  24     <add>1.8</add>
  25   </field>
  26   <foreignKey>
  27     <name>dedupe_rule_group_id</name>
  28     <table>civicrm_dedupe_rule_group</table>
  29     <key>id</key>
  30     <add>1.8</add>
  31   </foreignKey>
  32   <field>
  33     <name>rule_table</name>
  34     <type>varchar</type>
  35     <length>64</length>
  36     <required>true</required>
  37     <comment>The name of the table this rule is about</comment>
  38     <add>1.8</add>
  39   </field>
  40   <field>
  41     <name>rule_field</name>
  42     <type>varchar</type>
  43     <length>64</length>
  44     <required>true</required>
  45     <comment>The name of the field of the table referenced in rule_table</comment>
  46     <add>1.8</add>
  47   </field>
  48   <field>
  49     <name>rule_length</name>
  50     <type>int unsigned</type>
  51     <comment>The length of the matching substring</comment>
  52     <add>1.8</add>
  53     <html>
  54       <type>Text</type>
  55     </html>
  56   </field>
  57   <field>
  58     <name>rule_weight</name>
  59     <type>int</type>
  60     <required>true</required>
  61     <comment>The weight of the rule</comment>
  62     <add>1.8</add>
  63     <html>
  64       <type>Text</type>
  65     </html>
  66   </field>
  67 </table>