[civicrm-core.git] / xml / schema / Core / MappingField.xml

<?xml version="1.0" encoding="iso-8859-1" ?>

<table>
  <base>CRM/Core</base>
  <class>MappingField</class>
  <name>civicrm_mapping_field</name>
  <comment>Individual field mappings for Mapping</comment>
  <add>1.2</add>
  <field>
    <name>id</name>
    <type>int unsigned</type>
    <title>Mapping Field ID</title>
    <required>true</required>
    <comment>Mapping Field ID</comment>
    <add>1.2</add>
  </field>
  <primaryKey>
    <name>id</name>
    <autoincrement>true</autoincrement>
    <add>1.2</add>
  </primaryKey>
  <field>
    <name>mapping_id</name>
    <type>int unsigned</type>
    <title>Mapping ID</title>
    <required>true</required>
    <comment>Mapping to which this field belongs</comment>
    <add>1.2</add>
  </field>
  <foreignKey>
    <name>mapping_id</name>
    <table>civicrm_mapping</table>
    <key>id</key>
    <add>1.2</add>
  </foreignKey>
  <field>
    <name>name</name>
    <type>varchar</type>
    <length>255</length>
    <comment>Mapping field key</comment>
    <add>1.2</add>
  </field>
  <field>
    <name>contact_type</name>
    <type>varchar</type>
    <length>64</length>
    <comment>Contact Type in mapping</comment>
    <html>
      <type>Select</type>
    </html>
    <add>1.2</add>
  </field>
  <field>
    <name>column_number</name>
    <type>int unsigned</type>
    <required>true</required>
    <comment>Column number for mapping set</comment>
    <add>1.2</add>
  </field>
  <field>
    <name>location_type_id</name>
    <type>int unsigned</type>
    <title>Location type ID</title>
    <comment>Location type of this mapping, if required</comment>
    <add>1.2</add>
  </field>
  <foreignKey>
    <name>location_type_id</name>
    <table>civicrm_location_type</table>
    <key>id</key>
    <add>1.2</add>
  </foreignKey>
  <field>
    <name>phone_type</name>
    <type>varchar</type>
    <length>64</length>
    <comment>Phone type, if required</comment>
    <add>1.2</add>
    <drop>2.2</drop>
  </field>
  <field>
    <name>phone_type_id</name>
    <type>int unsigned</type>
    <title>Phone type ID</title>
    <comment>Which type of phone does this number belongs.</comment>
    <add>2.2</add>
  </field>
  <field>
    <name>im_provider_id</name>
    <type>int unsigned</type>
    <title>IM provider ID</title>
    <comment>Which type of IM Provider does this name belong.</comment>
    <add>3.0</add>
    <pseudoconstant>
      <optionGroupName>instant_messenger_service</optionGroupName>
    </pseudoconstant>
    <html>
      <type>Select</type>
    </html>
  </field>
  <field>
    <name>website_type_id</name>
    <type>int unsigned</type>
    <title>Website type ID</title>
    <comment>Which type of website does this site belong</comment>
    <add>3.2</add>
    <pseudoconstant>
      <optionGroupName>website_type</optionGroupName>
    </pseudoconstant>
    <html>
      <type>Select</type>
    </html>
  </field>
  <field>
    <name>relationship_type_id</name>
    <type>int unsigned</type>
    <title>Relationship type ID</title>
    <comment>Relationship type, if required</comment>
    <add>1.2</add>
  </field>
  <foreignKey>
    <name>relationship_type_id</name>
    <table>civicrm_relationship_type</table>
    <key>id</key>
    <add>1.2</add>
  </foreignKey>
  <field>
    <name>relationship_direction</name>
    <type>varchar</type>
    <length>6</length>
    <add>1.7</add>
  </field>
  <field>
    <name>grouping</name>
    <type>int unsigned</type>
    <default>1</default>
    <comment>Used to group mapping_field records into related sets (e.g. for criteria sets in search builder
      mappings).
    </comment>
    <add>1.5</add>
  </field>
  <field>
    <name>operator</name>
    <type>varchar</type>
    <length>16</length>
    <type>enum</type>
    <comment>SQL WHERE operator for search-builder mapping fields (search criteria).</comment>
    <pseudoconstant>
      <callback>CRM_Core_SelectValues::getSearchBuilderOperators</callback>
    </pseudoconstant>
    <add>1.5</add>
    <html>
      <type>Select</type>
    </html>
  </field>
  <field>
    <name>value</name>
    <type>varchar</type>
    <length>255</length>
    <comment>SQL WHERE value for search-builder mapping fields.</comment>
    <add>1.5</add>
  </field>
</table>
Commit	Line	Data
6a488035 TO	1	<?xml version="1.0" encoding="iso-8859-1" ?>
	2
	3	<table>
	4	<base>CRM/Core</base>
	5	<class>MappingField</class>
	6	<name>civicrm_mapping_field</name>
	7	<comment>Individual field mappings for Mapping</comment>
	8	<add>1.2</add>
	9	<field>
8f069c03 EM	10	<name>id</name>
8f069c03 EM	11	<type>int unsigned</type>
10d067c6	12	<title>Mapping Field ID</title>
8f069c03 EM	13	<required>true</required>
	14	<comment>Mapping Field ID</comment>
	15	<add>1.2</add>
6a488035 TO	16	</field>
6a488035 TO	17	<primaryKey>
8f069c03 EM	18	<name>id</name>
	19	<autoincrement>true</autoincrement>
	20	<add>1.2</add>
6a488035 TO	21	</primaryKey>
6a488035 TO	22	<field>
8f069c03 EM	23	<name>mapping_id</name>
8f069c03 EM	24	<type>int unsigned</type>
10d067c6	25	<title>Mapping ID</title>
8f069c03 EM	26	<required>true</required>
	27	<comment>Mapping to which this field belongs</comment>
	28	<add>1.2</add>
6a488035 TO	29	</field>
6a488035 TO	30	<foreignKey>
8f069c03 EM	31	<name>mapping_id</name>
	32	<table>civicrm_mapping</table>
	33	<key>id</key>
	34	<add>1.2</add>
6a488035 TO	35	</foreignKey>
6a488035 TO	36	<field>
8f069c03 EM	37	<name>name</name>
	38	<type>varchar</type>
	39	<length>255</length>
	40	<comment>Mapping field key</comment>
	41	<add>1.2</add>
6a488035 TO	42	</field>
6a488035 TO	43	<field>
8f069c03 EM	44	<name>contact_type</name>
	45	<type>varchar</type>
	46	<length>64</length>
	47	<comment>Contact Type in mapping</comment>
8f069c03 EM	48	<html>
	49	<type>Select</type>
	50	</html>
	51	<add>1.2</add>
6a488035 TO	52	</field>
6a488035 TO	53	<field>
8f069c03 EM	54	<name>column_number</name>
	55	<type>int unsigned</type>
	56	<required>true</required>
	57	<comment>Column number for mapping set</comment>
	58	<add>1.2</add>
6a488035 TO	59	</field>
6a488035 TO	60	<field>
8f069c03 EM	61	<name>location_type_id</name>
8f069c03 EM	62	<type>int unsigned</type>
10d067c6	63	<title>Location type ID</title>
8f069c03 EM	64	<comment>Location type of this mapping, if required</comment>
8f069c03 EM	65	<add>1.2</add>
6a488035 TO	66	</field>
6a488035 TO	67	<foreignKey>
8f069c03 EM	68	<name>location_type_id</name>
	69	<table>civicrm_location_type</table>
	70	<key>id</key>
	71	<add>1.2</add>
6a488035 TO	72	</foreignKey>
6a488035 TO	73	<field>
8f069c03 EM	74	<name>phone_type</name>
	75	<type>varchar</type>
	76	<length>64</length>
	77	<comment>Phone type, if required</comment>
	78	<add>1.2</add>
	79	<drop>2.2</drop>
6a488035 TO	80	</field>
6a488035 TO	81	<field>
8f069c03 EM	82	<name>phone_type_id</name>
8f069c03 EM	83	<type>int unsigned</type>
10d067c6	84	<title>Phone type ID</title>
8f069c03 EM	85	<comment>Which type of phone does this number belongs.</comment>
8f069c03 EM	86	<add>2.2</add>
3c7d2158	87	</field>
8f069c03 EM	88	<field>
	89	<name>im_provider_id</name>
	90	<type>int unsigned</type>
10d067c6	91	<title>IM provider ID</title>
8f069c03 EM	92	<comment>Which type of IM Provider does this name belong.</comment>
	93	<add>3.0</add>
	94	<pseudoconstant>
	95	<optionGroupName>instant_messenger_service</optionGroupName>
	96	</pseudoconstant>
	97	<html>
	98	<type>Select</type>
	99	</html>
6a488035 TO	100	</field>
6a488035 TO	101	<field>
8f069c03 EM	102	<name>website_type_id</name>
8f069c03 EM	103	<type>int unsigned</type>
a265eee1	104	<title>Website type ID</title>
8f069c03 EM	105	<comment>Which type of website does this site belong</comment>
	106	<add>3.2</add>
	107	<pseudoconstant>
	108	<optionGroupName>website_type</optionGroupName>
	109	</pseudoconstant>
	110	<html>
	111	<type>Select</type>
	112	</html>
3c7d2158	113	</field>
6a488035	114	<field>
8f069c03 EM	115	<name>relationship_type_id</name>
8f069c03 EM	116	<type>int unsigned</type>
a265eee1	117	<title>Relationship type ID</title>
8f069c03 EM	118	<comment>Relationship type, if required</comment>
8f069c03 EM	119	<add>1.2</add>
6a488035 TO	120	</field>
6a488035 TO	121	<foreignKey>
8f069c03 EM	122	<name>relationship_type_id</name>
	123	<table>civicrm_relationship_type</table>
	124	<key>id</key>
	125	<add>1.2</add>
6a488035	126	</foreignKey>
3c7d2158	127	<field>
8f069c03 EM	128	<name>relationship_direction</name>
	129	<type>varchar</type>
	130	<length>6</length>
	131	<add>1.7</add>
3c7d2158	132	</field>
6a488035	133	<field>
8f069c03 EM	134	<name>grouping</name>
	135	<type>int unsigned</type>
	136	<default>1</default>
	137	<comment>Used to group mapping_field records into related sets (e.g. for criteria sets in search builder
	138	mappings).
	139	</comment>
	140	<add>1.5</add>
6a488035 TO	141	</field>
6a488035 TO	142	<field>
8f069c03 EM	143	<name>operator</name>
	144	<type>varchar</type>
	145	<length>16</length>
	146	<type>enum</type>
	147	<comment>SQL WHERE operator for search-builder mapping fields (search criteria).</comment>
	148	<pseudoconstant>
	149	<callback>CRM_Core_SelectValues::getSearchBuilderOperators</callback>
	150	</pseudoconstant>
	151	<add>1.5</add>
	152	<html>
	153	<type>Select</type>
	154	</html>
6a488035 TO	155	</field>
6a488035 TO	156	<field>
8f069c03 EM	157	<name>value</name>
	158	<type>varchar</type>
	159	<length>255</length>
	160	<comment>SQL WHERE value for search-builder mapping fields.</comment>
	161	<add>1.5</add>
6a488035 TO	162	</field>
6a488035 TO	163	</table>