projects / civicrm-core.git / blobdiff
? search:
summary | shortlog | log | commit | commitdiff | tree
raw | inline | side by side
CRM-14181 fixes - migrate enums to varchar in schema for all tables
[civicrm-core.git] / xml / schema / Core / MappingField.xml
diff --git a/xml/schema/Core/MappingField.xml b/xml/schema/Core/MappingField.xml
index fd6125ba012848b110d59f538f35041590ac883d..f679d844fde77bc00f809a11997d4f13b3eea38e 100644 (file)
--- a/xml/schema/Core/MappingField.xml
+++ b/xml/schema/Core/MappingField.xml
@@ -43,6 +43,14 @@
        <type>varchar</type>
        <length>64</length>
        <comment>Contact Type in mapping</comment>
+       <pseudoconstant>
+         <table>civicrm_contact_type</table>
+         <keyColumn>name</keyColumn>
+         <labelColumn>label</labelColumn>
+       </pseudoconstant>
+       <html>
+         <type>Select</type>
+       </html>
       <add>1.2</add>
   </field>
   <field>
@@ -77,19 +85,31 @@
        <type>int unsigned</type>
        <comment>Which type of phone does this number belongs.</comment>
        <add>2.2</add>
-  </field> 
+  </field>
    <field>
-       <name>im_provider_id</name>
-       <type>int unsigned</type>
-       <comment>Which type of IM Provider does this name belong.</comment>
-       <add>3.0</add>
+      <name>im_provider_id</name>
+      <type>int unsigned</type>
+      <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>
        <comment>Which type of website does this site belong</comment>
        <add>3.2</add>
-  </field> 
+       <pseudoconstant>
+         <optionGroupName>website_type</optionGroupName>
+       </pseudoconstant>
+       <html>
+         <type>Select</type>
+       </html>
+  </field>
   <field>
        <name>relationship_type_id</name>
        <type>int unsigned</type>
@@ -102,12 +122,12 @@
        <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>relationship_direction</name>
+      <type>varchar</type>
+      <length>6</length>
+      <add>1.7</add>
+  </field>
   <field>
         <name>grouping</name>
         <type>int unsigned</type>
@@ -117,11 +137,14 @@
   </field>
   <field>
        <name>operator</name>
+       <type>varchar</type>
+       <length>16</length>
        <type>enum</type>
-       <values>&#61;, !&#61;, &#62;, &#60;, &#62;&#61;, &#60;&#61;,
-       IN, NOT IN, LIKE, NOT LIKE, IS NULL, IS NOT NULL</values>
        <comment>SQL WHERE operator for search-builder mapping fields (search criteria).</comment>
       <add>1.5</add>
+      <html>
+        <type>Select</type>
+      </html>
   </field>
   <field>
        <name>value</name>