Merge pull request #18435 from eileenmcnaughton/ms
[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 23 <name>name</name>
110684e4 24 <title>Mapping Name</title>
8f069c03
EM
25 <type>varchar</type>
26 <length>64</length>
27 <comment>Name of Mapping</comment>
28 <add>1.2</add>
6a488035
TO
29 </field>
30 <field>
8f069c03 31 <name>description</name>
110684e4 32 <title>Description</title>
8f069c03
EM
33 <type>varchar</type>
34 <length>255</length>
35 <comment>Description of Mapping.</comment>
36 <add>1.2</add>
6a488035 37 </field>
6a488035 38 <field>
8f069c03
EM
39 <name>mapping_type_id</name>
40 <type>int unsigned</type>
10d067c6 41 <title>Mapping Type</title>
8f069c03
EM
42 <comment>Mapping Type</comment>
43 <add>2.1</add>
44 <pseudoconstant>
45 <optionGroupName>mapping_type</optionGroupName>
46 </pseudoconstant>
47 <html>
48 <type>Select</type>
49 </html>
6a488035
TO
50 </field>
51 <index>
52 <name>UI_name</name>
53 <fieldName>name</fieldName>
8f069c03 54 <add>1.2</add>
6a488035
TO
55 </index>
56</table>