CRM-14181 fixes - migrate enums to varchar in schema for all tables
[civicrm-core.git] / xml / schema / Core / MappingField.xml
index fbae7d3d50e1eb8a95b156a7949a783fe62b1062..f679d844fde77bc00f809a11997d4f13b3eea38e 100644 (file)
@@ -48,6 +48,9 @@
          <keyColumn>name</keyColumn>
          <labelColumn>label</labelColumn>
        </pseudoconstant>
+       <html>
+         <type>Select</type>
+       </html>
       <add>1.2</add>
   </field>
   <field>
@@ -82,7 +85,7 @@
        <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>
@@ -91,6 +94,9 @@
       <pseudoconstant>
         <optionGroupName>instant_messenger_service</optionGroupName>
       </pseudoconstant>
+      <html>
+        <type>Select</type>
+      </html>
   </field>
   <field>
        <name>website_type_id</name>
        <pseudoconstant>
          <optionGroupName>website_type</optionGroupName>
        </pseudoconstant>
-  </field> 
+       <html>
+         <type>Select</type>
+       </html>
+  </field>
   <field>
        <name>relationship_type_id</name>
        <type>int unsigned</type>
        <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>
   </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>