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       <pseudoconstant>
  69         <callback>CRM_Price_BAO_PriceField::htmlTypes</callback>
  70       </pseudoconstant>
  71       <add>1.8</add>
  72       <html>
  73         <type>Select</type>
  74       </html>
  75   </field>
  76   <field>
  77       <name>is_enter_qty</name>
  78       <type>boolean</type>
  79       <default>0</default>
  80       <comment>Enter a quantity for this field?</comment>
  81       <add>1.8</add>
  82       <html>
  83          <type>CheckBox</type>
  84        </html>
  85   </field>
  86   <field>
  87       <name>help_pre</name>
  88       <type>text</type>
  89       <localizable>true</localizable>
  90       <comment>Description and/or help text to display before this field.</comment>
  91       <html>
  92         <type>TextArea</type>
  93         <rows>4</rows>
  94         <cols>80</cols>
  95       </html>
  96       <add>1.8</add>
  97   </field>
  98   <field>
  99       <name>help_post</name>
 100       <type>text</type>
 101       <localizable>true</localizable>
 102       <comment>Description and/or help text to display after this field.</comment>
 103       <html>
 104         <type>TextArea</type>
 105         <rows>4</rows>
 106         <cols>80</cols>
 107       </html>
 108       <add>1.8</add>
 109   </field>
 110   <field>
 111       <name>weight</name>
 112       <type>int</type>
 113       <default>1</default>
 114       <comment>Order in which the fields should appear</comment>
 115       <add>1.8</add>
 116       <html>
 117         <type>Select</type>
 118       </html>
 119   </field>
 120   <field>
 121       <name>is_display_amounts</name>
 122       <type>boolean</type>
 123       <default>1</default>
 124       <comment>Should the price be displayed next to the label for each option?</comment>
 125       <html>
 126          <type>CheckBox</type>
 127        </html>
 128   </field>
 129   <field>
 130       <name>options_per_line</name>
 131       <type>int unsigned</type>
 132       <default>1</default>
 133       <comment>number of options per line for checkbox and radio</comment>
 134       <add>1.8</add>
 135       <html>
 136         <type>Text</type>
 137       </html>
 138   </field>
 139   <field>
 140       <name>is_active</name>
 141       <type>boolean</type>
 142       <comment>Is this price field active</comment>
 143       <default>1</default>
 144       <add>1.8</add>
 145       <html>
 146          <type>CheckBox</type>
 147        </html>
 148   </field>
 149   <field>
 150       <name>is_required</name>
 151       <type>boolean</type>
 152       <comment>Is this price field required (value must be > 1)</comment>
 153       <default>1</default>
 154       <add>1.8</add>
 155       <html>
 156          <type>CheckBox</type>
 157        </html>
 158   </field>
 159   <field>
 160       <name>active_on</name>
 161       <type>datetime</type>
 162       <default>NULL</default>
 163       <comment>If non-zero, do not show this field before the date specified</comment>
 164       <add>1.8</add>
 165       <html>
 166          <type>CheckBox</type>
 167        </html>
 168   </field>
 169   <field>
 170       <name>expire_on</name>
 171       <type>datetime</type>
 172       <default>NULL</default>
 173       <comment>If non-zero, do not show this field after the date specified</comment>
 174       <add>1.8</add>
 175       <html>
 176         <type>Select Date</type>
 177     </html>
 178   </field>
 179   <field>
 180       <name>javascript</name>
 181       <type>varchar</type>
 182       <length>255</length>
 183       <comment>Optional scripting attributes for field</comment>
 184       <add>1.8</add>
 185       <html>
 186         <type>Text</type>
 187       </html>
 188   </field>
 189   <field>
 190       <name>visibility_id</name>
 191       <type>int unsigned</type>
 192       <default>1</default>
 193       <comment>Implicit FK to civicrm_option_group with name = \'visibility\'</comment>
 194       <add>3.2</add>
 195       <pseudoconstant>
 196         <optionGroupName>visibility</optionGroupName>
 197       </pseudoconstant>
 198       <html>
 199         <type>Select</type>
 200       </html>
 201    </field>
 202    <field>
 203       <name>count</name>
 204       <type>int unsigned</type>
 205       <default>NULL</default>
 206       <comment>Number of Participants Per field</comment>
 207       <add>3.2</add>
 208       <drop>3.3</drop>
 209    </field>
 210 </table>
 211