Merge remote-tracking branch 'upstream/4.4' into 4.4-master-2014-06-30-11-58-01
[civicrm-core.git] / xml / schema / Price / PriceField.xml
CommitLineData
6a488035
TO
1<?xml version="1.0" encoding="iso-8859-1" ?>
2
3<table>
4 <base>CRM/Price</base>
9da8dc8c 5 <class>PriceField</class>
6a488035
TO
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>
614d72ec 41 <html>
42 <type>Text</type>
43 </html>
6a488035
TO
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>
614d72ec 58 <html>
59 <type>Text</type>
60 </html>
6a488035
TO
61 <add>1.8</add>
62 </field>
63 <field>
64 <name>html_type</name>
be622aca 65 <type>varchar</type>
66 <length>12</length>
6a488035 67 <required>true</required>
71a707c3 68 <pseudoconstant>
93bfa565 69 <callback>CRM_Price_BAO_PriceField::htmlTypes</callback>
71a707c3 70 </pseudoconstant>
6a488035 71 <add>1.8</add>
614d72ec 72 <html>
73 <type>Select</type>
74 </html>
6a488035
TO
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>
614d72ec 82 <html>
83 <type>CheckBox</type>
84 </html>
6a488035
TO
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>
7deea513 91 <html>
92 <type>TextArea</type>
817807ab 93 <rows>4</rows>
94 <cols>80</cols>
7deea513 95 </html>
6a488035
TO
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>
7deea513 103 <html>
104 <type>TextArea</type>
817807ab 105 <rows>4</rows>
106 <cols>80</cols>
7deea513 107 </html>
6a488035
TO
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>
614d72ec 116 <html>
117 <type>Select</type>
118 </html>
6a488035
TO
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>
614d72ec 125 <html>
126 <type>CheckBox</type>
127 </html>
6a488035
TO
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>
614d72ec 135 <html>
136 <type>Text</type>
137 </html>
6a488035
TO
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>
614d72ec 145 <html>
146 <type>CheckBox</type>
147 </html>
6a488035
TO
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>
614d72ec 155 <html>
156 <type>CheckBox</type>
157 </html>
6a488035
TO
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>
614d72ec 165 <html>
166 <type>CheckBox</type>
167 </html>
6a488035
TO
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>
614d72ec 175 <html>
176 <type>Select Date</type>
177 </html>
6a488035
TO
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>
614d72ec 185 <html>
186 <type>Text</type>
187 </html>
6a488035
TO
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>
4080e473
AS
195 <pseudoconstant>
196 <optionGroupName>visibility</optionGroupName>
197 </pseudoconstant>
614d72ec 198 <html>
e0991796 199 <type>Select</type>
614d72ec 200 </html>
3c7d2158 201 </field>
6a488035
TO
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