xml/schema/Core/OptionGroup.xml

   1 <?xml version="1.0" encoding="iso-8859-1" ?>
   2
   3 <table>
   4   <base>CRM/Core</base>
   5   <class>OptionGroup</class>
   6   <name>civicrm_option_group</name>
   7   <add>1.5</add>
   8   <log>true</log>
   9   <field>
  10       <name>id</name>
  11       <type>int unsigned</type>
  12       <required>true</required>
  13       <comment>Option Group ID</comment>
  14        <add>1.5</add>
  15   </field>
  16   <primaryKey>
  17        <name>id</name>
  18        <autoincrement>true</autoincrement>
  19   </primaryKey>
  20   <field>
  21        <name>name</name>
  22        <title>Option Group Name</title>
  23        <type>varchar</type>
  24        <length>64</length>
  25        <required>true</required>
  26        <comment>Option group name. Used as selection key by class properties which lookup options in civicrm_option_value.</comment>
  27        <add>1.5</add>
  28   </field>
  29   <field>
  30        <name>title</name>
  31        <type>varchar</type>
  32        <length>255</length>
  33        <localizable>true</localizable>
  34        <comment>Option Group title.</comment>
  35        <add>1.5</add>
  36   </field>
  37   <field>
  38        <name>description</name>
  39        <type>varchar</type>
  40        <length>255</length>
  41        <localizable>true</localizable>
  42        <comment>Option group description.</comment>
  43        <add>1.5</add>
  44   </field>
  45   <field>
  46        <name>is_reserved</name>
  47        <type>boolean</type>
  48        <default>1</default>
  49        <comment>Is this a predefined system option group (i.e. it can not be deleted)?</comment>
  50        <add>1.5</add>
  51   </field>
  52   <field>
  53        <name>is_active</name>
  54        <type>boolean</type>
  55        <comment>Is this option group active?</comment>
  56        <add>1.5</add>
  57   </field>
  58   <index>
  59     <name>UI_name</name>
  60     <fieldName>name</fieldName>
  61     <unique>true</unique>
  62     <add>2.1</add>
  63   </index>
  64 </table>