[civicrm-core.git] / xml / schema / Dedupe / RuleGroup.xml

<?xml version="1.0" encoding="utf-8" ?>
<table>
  <base>CRM/Dedupe</base>
  <class>RuleGroup</class>
  <name>civicrm_dedupe_rule_group</name>
  <comment>Dedupe rule groups</comment>
  <add>1.8</add>
  <field>
    <name>id</name>
    <title>Rule Group ID</title>
    <type>int unsigned</type>
    <required>true</required>
    <comment>Unique dedupe rule group id</comment>
    <add>1.8</add>
  </field>
  <primaryKey>
    <name>id</name>
    <autoincrement>true</autoincrement>
  </primaryKey>
  <field>
    <name>contact_type</name>
    <title>Contact Type</title>
    <type>varchar</type>
    <length>12</length>
    <comment>The type of contacts this group applies to</comment>
    <pseudoconstant>
      <table>civicrm_contact_type</table>
      <keyColumn>name</keyColumn>
      <labelColumn>label</labelColumn>
      <condition>parent_id IS NULL</condition>
    </pseudoconstant>
    <add>1.8</add>
    <html>
      <type>Select</type>
    </html>
  </field>
  <field>
    <name>threshold</name>
    <title>Threshold</title>
    <type>int</type>
    <required>true</required>
    <comment>The weight threshold the sum of the rule weights has to cross to consider two contacts the same</comment>
    <add>1.8</add>
    <html>
      <type>Text</type>
    </html>
  </field>
  <field>
    <name>level</name>
    <title>Level</title>
    <type>enum</type>
    <values>Strict, Fuzzy</values>
    <comment>Whether the rule should be used for cases where strict matching of the given contact type is required or a fuzzy one</comment>
    <add>2.1</add>
    <drop>4.3</drop>
  </field>
  <field>
    <name>used</name>
    <type>varchar</type>
    <title>Length</title>
    <length>12</length>
    <required>true</required>
    <comment>Whether the rule should be used for cases where usage is Unsupervised, Supervised OR General(programatically)</comment>
    <pseudoconstant>
      <callback>CRM_Core_SelectValues::getDedupeRuleTypes</callback>
    </pseudoconstant>
    <add>4.3</add>
    <html>
      <type>Radio</type>
    </html>
  </field>
  <field>
    <name>is_default</name>
    <title>Default></title>
    <type>boolean</type>
    <comment>Is this a default rule (one rule for every contact type + level combination should be default)</comment>
    <add>2.1</add>
    <drop>4.3</drop>
  </field>
  <field>
    <name>name</name>
    <title>Name</title>
    <type>varchar</type>
    <length>64</length>
    <comment>Name of the rule group</comment>
    <add>2.1</add>
  </field>
  <field>
    <name>title</name>
    <title>Title</title>
    <type>varchar</type>
    <length>255</length>
    <comment>Label of the rule group</comment>
    <add>4.1</add>
    <html>
      <type>Text</type>
    </html>
  </field>
  <field>
    <name>is_reserved</name>
    <title>Reserved?</title>
    <type>boolean</type>
    <comment>Is this a reserved rule - a rule group that has been optimized and cannot be changed by the admin</comment>
    <add>4.1</add>
    <html>
      <type>CheckBox</type>
    </html>
  </field>
</table>
Commit	Line	Data
6a488035 TO	1	<?xml version="1.0" encoding="utf-8" ?>
	2	<table>
	3	<base>CRM/Dedupe</base>
	4	<class>RuleGroup</class>
	5	<name>civicrm_dedupe_rule_group</name>
	6	<comment>Dedupe rule groups</comment>
	7	<add>1.8</add>
	8	<field>
	9	<name>id</name>
f3ea5182	10	<title>Rule Group ID</title>
6a488035 TO	11	<type>int unsigned</type>
	12	<required>true</required>
	13	<comment>Unique dedupe rule group id</comment>
	14	<add>1.8</add>
	15	</field>
	16	<primaryKey>
	17	<name>id</name>
	18	<autoincrement>true</autoincrement>
	19	</primaryKey>
	20	<field>
	21	<name>contact_type</name>
f3ea5182	22	<title>Contact Type</title>
909ca5f6	23	<type>varchar</type>
909ca5f6	24	<length>12</length>
6a488035	25	<comment>The type of contacts this group applies to</comment>
71a707c3	26	<pseudoconstant>
	27	<table>civicrm_contact_type</table>
	28	<keyColumn>name</keyColumn>
	29	<labelColumn>label</labelColumn>
	30	<condition>parent_id IS NULL</condition>
	31	</pseudoconstant>
6a488035	32	<add>1.8</add>
614d72ec	33	<html>
	34	<type>Select</type>
	35	</html>
6a488035 TO	36	</field>
	37	<field>
	38	<name>threshold</name>
f3ea5182	39	<title>Threshold</title>
6a488035 TO	40	<type>int</type>
	41	<required>true</required>
	42	<comment>The weight threshold the sum of the rule weights has to cross to consider two contacts the same</comment>
	43	<add>1.8</add>
a4969aee TM	44	<html>
	45	<type>Text</type>
	46	</html>
6a488035 TO	47	</field>
	48	<field>
	49	<name>level</name>
f3ea5182	50	<title>Level</title>
6a488035 TO	51	<type>enum</type>
6a488035 TO	52	<values>Strict, Fuzzy</values>
e4f46be0	53	<comment>Whether the rule should be used for cases where strict matching of the given contact type is required or a fuzzy one</comment>
6a488035 TO	54	<add>2.1</add>
	55	<drop>4.3</drop>
	56	</field>
	57	<field>
	58	<name>used</name>
909ca5f6	59	<type>varchar</type>
f3ea5182	60	<title>Length</title>
909ca5f6	61	<length>12</length>
6a488035 TO	62	<required>true</required>
6a488035 TO	63	<comment>Whether the rule should be used for cases where usage is Unsupervised, Supervised OR General(programatically)</comment>
71a707c3	64	<pseudoconstant>
93bfa565	65	<callback>CRM_Core_SelectValues::getDedupeRuleTypes</callback>
71a707c3	66	</pseudoconstant>
6a488035	67	<add>4.3</add>
614d72ec	68	<html>
72c010fd	69	<type>Radio</type>
614d72ec	70	</html>
6a488035 TO	71	</field>
	72	<field>
	73	<name>is_default</name>
f3ea5182	74	<title>Default></title>
6a488035 TO	75	<type>boolean</type>
	76	<comment>Is this a default rule (one rule for every contact type + level combination should be default)</comment>
	77	<add>2.1</add>
	78	<drop>4.3</drop>
	79	</field>
	80	<field>
	81	<name>name</name>
f3ea5182	82	<title>Name</title>
6a488035 TO	83	<type>varchar</type>
	84	<length>64</length>
	85	<comment>Name of the rule group</comment>
	86	<add>2.1</add>
	87	</field>
	88	<field>
	89	<name>title</name>
f3ea5182	90	<title>Title</title>
6a488035 TO	91	<type>varchar</type>
	92	<length>255</length>
	93	<comment>Label of the rule group</comment>
	94	<add>4.1</add>
a4969aee TM	95	<html>
	96	<type>Text</type>
	97	</html>
6a488035 TO	98	</field>
	99	<field>
	100	<name>is_reserved</name>
f3ea5182	101	<title>Reserved?</title>
6a488035 TO	102	<type>boolean</type>
	103	<comment>Is this a reserved rule - a rule group that has been optimized and cannot be changed by the admin</comment>
	104	<add>4.1</add>
a4969aee TM	105	<html>
	106	<type>CheckBox</type>
	107	</html>
6a488035 TO	108	</field>
6a488035 TO	109	</table>