xml/schema/Core/Mapping.xml

   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>
  10       <name>id</name>
  11       <type>int unsigned</type>
  12       <required>true</required>
  13       <comment>Mapping ID</comment>
  14       <add>1.2</add>
  15   </field>
  16   <primaryKey>
  17        <name>id</name>
  18        <autoincrement>true</autoincrement>
  19       <add>1.2</add>
  20   </primaryKey>
  21   <field>
  22        <name>name</name>
  23        <type>varchar</type>
  24        <length>64</length>
  25        <comment>Name of Mapping</comment>
  26       <add>1.2</add>
  27   </field>
  28   <field>
  29        <name>description</name>
  30        <type>varchar</type>
  31        <length>255</length>
  32        <comment>Description of Mapping.</comment>
  33       <add>1.2</add>
  34   </field>
  35   <field>
  36        <name>mapping_type</name>
  37        <type>enum</type>
  38        <values>Export, Import, Export Contributions, Import Contributions, Import Activity, Search Builder, Import Memberships, Import Participants</values>
  39        <comment>Type of Mapping.</comment>
  40       <add>1.2</add>
  41       <drop>2.1</drop>
  42   </field>
  43   <field>
  44       <name>mapping_type_id</name>
  45       <type>int unsigned</type>
  46       <comment>Mapping Type</comment>
  47       <add>2.1</add>
  48       <pseudoconstant>
  49         <optionGroupName>mapping_type</optionGroupName>
  50       </pseudoconstant>
  51       <html>
  52         <type>Select</type>
  53       </html>
  54   </field>
  55   <index>
  56     <name>UI_name</name>
  57     <fieldName>name</fieldName>
  58       <add>1.2</add>
  59   </index>
  60 </table>