Merge pull request #8993 from frederickgzmn/patch-1
[civicrm-core.git] / xml / schema / Core / Mapping.xml
CommitLineData
6a488035
TO
1<?xml version="1.0" encoding="iso-8859-1" ?>
2
3<table>
4 <base>CRM/Core</base>
5 <class>Mapping</class>
6 <name>civicrm_mapping</name>
7 <comment>Store field mappings in import or export for reuse</comment>
8 <add>1.2</add>
9 <field>
8f069c03
EM
10 <name>id</name>
11 <type>int unsigned</type>
10d067c6 12 <title>Mapping ID</title>
8f069c03
EM
13 <required>true</required>
14 <comment>Mapping ID</comment>
15 <add>1.2</add>
6a488035
TO
16 </field>
17 <primaryKey>
8f069c03
EM
18 <name>id</name>
19 <autoincrement>true</autoincrement>
20 <add>1.2</add>
6a488035
TO
21 </primaryKey>
22 <field>
8f069c03
EM
23 <name>name</name>
24 <type>varchar</type>
25 <length>64</length>
26 <comment>Name of Mapping</comment>
27 <add>1.2</add>
6a488035
TO
28 </field>
29 <field>
8f069c03
EM
30 <name>description</name>
31 <type>varchar</type>
32 <length>255</length>
33 <comment>Description of Mapping.</comment>
34 <add>1.2</add>
6a488035
TO
35 </field>
36 <field>
8f069c03
EM
37 <name>mapping_type</name>
38 <type>enum</type>
39 <values>Export, Import, Export Contributions, Import Contributions, Import Activity, Search Builder, Import
40 Memberships, Import Participants
41 </values>
42 <comment>Type of Mapping.</comment>
43 <add>1.2</add>
44 <drop>2.1</drop>
6a488035
TO
45 </field>
46 <field>
8f069c03
EM
47 <name>mapping_type_id</name>
48 <type>int unsigned</type>
10d067c6 49 <title>Mapping Type</title>
8f069c03
EM
50 <comment>Mapping Type</comment>
51 <add>2.1</add>
52 <pseudoconstant>
53 <optionGroupName>mapping_type</optionGroupName>
54 </pseudoconstant>
55 <html>
56 <type>Select</type>
57 </html>
6a488035
TO
58 </field>
59 <index>
60 <name>UI_name</name>
61 <fieldName>name</fieldName>
8f069c03 62 <add>1.2</add>
6a488035
TO
63 </index>
64</table>