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