Merge pull request #2193 from monishdeb/CRM-13734
[civicrm-core.git] / xml / schema / Core / OptionValue.xml
index 75fb066f0eec0685d9b71e44b530fff6cc521f0f..217b5632f07683fd534412ac0d2d31f76b911e3b 100644 (file)
       <required>true</required>
       <comment>Group which this option belongs to.</comment>
        <add>1.5</add>
+      <pseudoconstant>
+        <table>civicrm_option_group</table>
+        <keyColumn>id</keyColumn>
+        <labelColumn>name</labelColumn>
+      </pseudoconstant>
+      <html>
+        <type>Select</type>
+      </html>
   </field>
   <foreignKey>
        <name>option_group_id</name>
@@ -49,7 +57,7 @@
       <required>true</required>
       <comment>The actual value stored (as a foreign key) in the data record. Functions which need lookup option_value.title should use civicrm_option_value.option_group_id plus civicrm_option_value.value as the key.</comment>
        <add>1.5</add>
-       <change>3.3</change>      
+       <change>3.3</change>
   </field>
   <field>
        <name>name</name>
   <field>
        <name>description</name>
        <type>text</type>
-       <htmlType>textarea</htmlType>
-       <rows>8</rows>
-       <cols>60</cols>
+       <html>
+         <type>TextArea</type>
+         <rows>8</rows>
+         <cols>60</cols>
+       </html>
        <localizable>true</localizable>
        <comment>Optional description.</comment>
        <add>1.5</add>
       <name>component_id</name>
       <type>int unsigned</type>
       <comment>Component that this option value belongs/caters to.</comment>
-       <add>2.0</add>
+      <add>2.0</add>
+      <pseudoconstant>
+        <table>civicrm_component</table>
+        <keyColumn>id</keyColumn>
+        <labelColumn>name</labelColumn>
+      </pseudoconstant>
+      <html>
+        <type>Select</type>
+      </html>
   </field>
   <foreignKey>
        <name>component_id</name>
        <table>civicrm_component</table>
        <key>id</key>
        <add>2.0</add>
-  </foreignKey>  
+  </foreignKey>
   <field>
       <name>domain_id</name>
       <type>int unsigned</type>
   </field>
   <index>
        <name>index_option_group_id_value</name>
-       <fieldName>value</fieldName>
+       <fieldName length="128">value</fieldName>
        <fieldName>option_group_id</fieldName>
        <add>1.5</add>
   </index>
   <index>
     <name>index_option_group_id_name</name>
+    <fieldName length="128">name</fieldName>
     <fieldName>option_group_id</fieldName>
-    <fieldName>name</fieldName>
     <add>2.2</add>
   </index>
 </table>