xml/schema/Price/PriceField.xml

   1 <?xml version="1.0" encoding="iso-8859-1" ?>
   2
   3 <table>
   4   <base>CRM/Price</base>
   5   <class>PriceField</class>
   6   <name>civicrm_price_field</name>
   7   <add>1.8</add>
   8   <log>true</log>
   9   <field>
  10       <name>id</name>
  11       <type>int unsigned</type>
  12       <required>true</required>
  13       <comment>Price Field</comment>
  14       <add>1.8</add>
  15   </field>
  16   <primaryKey>
  17       <name>id</name>
  18       <autoincrement>true</autoincrement>
  19   </primaryKey>
  20   <field>
  21       <name>price_set_id</name>
  22       <type>int unsigned</type>
  23       <required>true</required>
  24       <comment>FK to civicrm_price_set</comment>
  25       <add>1.8</add>
  26   </field>
  27   <foreignKey>
  28       <name>price_set_id</name>
  29       <table>civicrm_price_set</table>
  30       <key>id</key>
  31       <add>1.8</add>
  32   </foreignKey>
  33   <field>
  34       <name>name</name>
  35       <type>varchar</type>
  36       <title>Name</title>
  37       <length>255</length>
  38       <required>true</required>
  39       <comment>Variable name/programmatic handle for this field.</comment>
  40       <add>1.8</add>
  41       <html>
  42         <type>Text</type>
  43       </html>
  44   </field>
  45   <index>
  46       <name>index_name</name>
  47       <fieldName>name</fieldName>
  48       <add>1.8</add>
  49   </index>
  50   <field>
  51       <name>label</name>
  52       <type>varchar</type>
  53       <title>Label</title>
  54       <length>255</length>
  55       <required>true</required>
  56       <localizable>true</localizable>
  57       <comment>Text for form field label (also friendly name for administering this field).</comment>
  58       <html>
  59         <type>Text</type>
  60       </html>
  61       <add>1.8</add>
  62   </field>
  63   <field>
  64       <name>html_type</name>
  65       <type>varchar</type>
  66       <length>12</length>
  67       <required>true</required>
  68       <add>1.8</add>
  69       <html>
  70         <type>Select</type>
  71       </html>
  72   </field>
  73   <field>
  74       <name>is_enter_qty</name>
  75       <type>boolean</type>
  76       <default>0</default>
  77       <comment>Enter a quantity for this field?</comment>
  78       <add>1.8</add>
  79       <html>
  80          <type>CheckBox</type>
  81        </html>
  82   </field>
  83   <field>
  84       <name>help_pre</name>
  85       <type>text</type>
  86       <localizable>true</localizable>
  87       <comment>Description and/or help text to display before this field.</comment>
  88       <html>
  89         <type>TextArea</type>
  90         <rows>4</rows>
  91         <cols>80</cols>
  92       </html>
  93       <add>1.8</add>
  94   </field>
  95   <field>
  96       <name>help_post</name>
  97       <type>text</type>
  98       <localizable>true</localizable>
  99       <comment>Description and/or help text to display after this field.</comment>
 100       <html>
 101         <type>TextArea</type>
 102         <rows>4</rows>
 103         <cols>80</cols>
 104       </html>
 105       <add>1.8</add>
 106   </field>
 107   <field>
 108       <name>weight</name>
 109       <type>int</type>
 110       <default>1</default>
 111       <comment>Order in which the fields should appear</comment>
 112       <add>1.8</add>
 113       <html>
 114         <type>Select</type>
 115       </html>
 116   </field>
 117   <field>
 118       <name>is_display_amounts</name>
 119       <type>boolean</type>
 120       <default>1</default>
 121       <comment>Should the price be displayed next to the label for each option?</comment>
 122       <html>
 123          <type>CheckBox</type>
 124        </html>
 125   </field>
 126   <field>
 127       <name>options_per_line</name>
 128       <type>int unsigned</type>
 129       <default>1</default>
 130       <comment>number of options per line for checkbox and radio</comment>
 131       <add>1.8</add>
 132       <html>
 133         <type>Text</type>
 134       </html>
 135   </field>
 136   <field>
 137       <name>is_active</name>
 138       <type>boolean</type>
 139       <comment>Is this price field active</comment>
 140       <default>1</default>
 141       <add>1.8</add>
 142       <html>
 143          <type>CheckBox</type>
 144        </html>
 145   </field>
 146   <field>
 147       <name>is_required</name>
 148       <type>boolean</type>
 149       <comment>Is this price field required (value must be > 1)</comment>
 150       <default>1</default>
 151       <add>1.8</add>
 152       <html>
 153          <type>CheckBox</type>
 154        </html>
 155   </field>
 156   <field>
 157       <name>active_on</name>
 158       <type>datetime</type>
 159       <default>NULL</default>
 160       <comment>If non-zero, do not show this field before the date specified</comment>
 161       <add>1.8</add>
 162       <html>
 163          <type>CheckBox</type>
 164        </html>
 165   </field>
 166   <field>
 167       <name>expire_on</name>
 168       <type>datetime</type>
 169       <default>NULL</default>
 170       <comment>If non-zero, do not show this field after the date specified</comment>
 171       <add>1.8</add>
 172       <html>
 173         <type>Select Date</type>
 174     </html>
 175   </field>
 176   <field>
 177       <name>javascript</name>
 178       <type>varchar</type>
 179       <length>255</length>
 180       <comment>Optional scripting attributes for field</comment>
 181       <add>1.8</add>
 182       <html>
 183         <type>Text</type>
 184       </html>
 185   </field>
 186   <field>
 187       <name>visibility_id</name>
 188       <type>int unsigned</type>
 189       <default>1</default>
 190       <comment>Implicit FK to civicrm_option_group with name = \'visibility\'</comment>
 191       <add>3.2</add>
 192       <pseudoconstant>
 193         <optionGroupName>visibility</optionGroupName>
 194       </pseudoconstant>
 195       <html>
 196         <type>Select</type>
 197       </html>
 198    </field>
 199    <field>
 200       <name>count</name>
 201       <type>int unsigned</type>
 202       <default>NULL</default>
 203       <comment>Number of Participants Per field</comment>
 204       <add>3.2</add>
 205       <drop>3.3</drop>
 206    </field>
 207 </table>
 208