Merge pull request #23056 from yashodha/dev-3141
[civicrm-core.git] / xml / schema / Financial / PaymentProcessor.xml
1 <?xml version="1.0" encoding="iso-8859-1" ?>
2
3 <table>
4 <base>CRM/Financial</base>
5 <class>PaymentProcessor</class>
6 <name>civicrm_payment_processor</name>
7 <add>1.8</add>
8 <component>CiviContribute</component>
9 <field>
10 <name>id</name>
11 <title>Payment Processor ID</title>
12 <type>int unsigned</type>
13 <required>true</required>
14 <comment>Payment Processor ID</comment>
15 <html>
16 <type>Number</type>
17 </html>
18 <add>1.8</add>
19 </field>
20 <primaryKey>
21 <name>id</name>
22 <autoincrement>true</autoincrement>
23 </primaryKey>
24 <field>
25 <name>domain_id</name>
26 <title>Domain ID</title>
27 <type>int unsigned</type>
28 <required>true</required>
29 <pseudoconstant>
30 <table>civicrm_domain</table>
31 <keyColumn>id</keyColumn>
32 <labelColumn>name</labelColumn>
33 </pseudoconstant>
34 <comment>Which Domain is this match entry for</comment>
35 <html>
36 <label>Domain</label>
37 </html>
38 <add>3.0</add>
39 </field>
40 <foreignKey>
41 <name>domain_id</name>
42 <table>civicrm_domain</table>
43 <key>id</key>
44 <add>3.0</add>
45 </foreignKey>
46 <field>
47 <name>name</name>
48 <title>Payment Processor</title>
49 <type>varchar</type>
50 <length>64</length>
51 <comment>Payment Processor Name.</comment>
52 <add>1.8</add>
53 <html>
54 <type>Text</type>
55 </html>
56 </field>
57 <field>
58 <name>title</name>
59 <title>Payment Processor Title</title>
60 <type>varchar</type>
61 <length>127</length>
62 <localizable>true</localizable>
63 <html>
64 <type>Text</type>
65 </html>
66 <comment>Payment Processor Descriptive Name.</comment>
67 <add>5.13</add>
68 </field>
69 <field>
70 <name>description</name>
71 <title>Processor Description</title>
72 <type>varchar</type>
73 <length>255</length>
74 <html>
75 <type>Text</type>
76 </html>
77 <comment>Payment Processor Description.</comment>
78 <add>1.8</add>
79 </field>
80 <field>
81 <name>payment_processor_type_id</name>
82 <title>Type ID</title>
83 <type>int unsigned</type>
84 <pseudoconstant>
85 <table>civicrm_payment_processor_type</table>
86 <keyColumn>id</keyColumn>
87 <labelColumn>title</labelColumn>
88 </pseudoconstant>
89 <required>true</required>
90 <length>10</length>
91 <html>
92 <label>Type</label>
93 </html>
94 <add>4.3</add>
95 </field>
96 <foreignKey>
97 <name>payment_processor_type_id</name>
98 <table>civicrm_payment_processor_type</table>
99 <key>id</key>
100 <add>4.3</add>
101 </foreignKey>
102 <field>
103 <name>is_active</name>
104 <title>Processor is Active?</title>
105 <type>boolean</type>
106 <comment>Is this processor active?</comment>
107 <add>1.8</add>
108 <default>1</default>
109 <required>true</required>
110 </field>
111 <field>
112 <name>is_default</name>
113 <title>Processor Is Default?</title>
114 <type>boolean</type>
115 <comment>Is this processor the default?</comment>
116 <add>1.8</add>
117 <default>0</default>
118 <required>true</required>
119 </field>
120 <field>
121 <name>is_test</name>
122 <title>Is Test Processor?</title>
123 <type>boolean</type>
124 <comment>Is this processor for a test site?</comment>
125 <add>1.8</add>
126 <default>0</default>
127 <required>true</required>
128 </field>
129 <index>
130 <name>UI_name_test_domain_id</name>
131 <fieldName>name</fieldName>
132 <fieldName>is_test</fieldName>
133 <fieldName>domain_id</fieldName>
134 <unique>true</unique>
135 <add>1.8</add>
136 </index>
137 <field>
138 <name>user_name</name>
139 <title>User Name</title>
140 <type>varchar</type>
141 <length>255</length>
142 <add>1.8</add>
143 <html>
144 <type>Text</type>
145 </html>
146 </field>
147 <field>
148 <name>password</name>
149 <title>Password</title>
150 <type>varchar</type>
151 <length>255</length>
152 <add>1.8</add>
153 <html>
154 <type>Password</type>
155 </html>
156 </field>
157 <field>
158 <name>signature</name>
159 <title>Signature</title>
160 <type>text</type>
161 <add>1.8</add>
162 <html>
163 <type>TextArea</type>
164 <rows>4</rows>
165 <cols>40</cols>
166 </html>
167 </field>
168 <field>
169 <name>url_site</name>
170 <title>Site URL</title>
171 <type>varchar</type>
172 <length>255</length>
173 <add>1.8</add>
174 <html>
175 <type>Text</type>
176 </html>
177 </field>
178 <field>
179 <name>url_api</name>
180 <title>API URL</title>
181 <type>varchar</type>
182 <length>255</length>
183 <add>1.8</add>
184 <html>
185 <type>Text</type>
186 </html>
187 </field>
188 <field>
189 <name>url_recur</name>
190 <title>Recurring Payments URL</title>
191 <type>varchar</type>
192 <length>255</length>
193 <add>1.8</add>
194 <html>
195 <type>Text</type>
196 </html>
197 </field>
198 <field>
199 <name>url_button</name>
200 <title>Button URL</title>
201 <type>varchar</type>
202 <length>255</length>
203 <add>1.8</add>
204 <html>
205 <type>Text</type>
206 </html>
207 </field>
208 <field>
209 <name>subject</name>
210 <title>Subject</title>
211 <type>varchar</type>
212 <length>255</length>
213 <add>1.8</add>
214 <html>
215 <type>Text</type>
216 </html>
217 </field>
218 <field>
219 <name>class_name</name>
220 <title>Suffix for PHP class name implementation</title>
221 <type>varchar</type>
222 <length>255</length>
223 <add>1.8</add>
224 </field>
225 <field>
226 <name>billing_mode</name>
227 <title>Processor Billing Mode</title>
228 <type>int unsigned</type>
229 <required>true</required>
230 <comment>Billing Mode (deprecated)</comment>
231 <add>1.8</add>
232 </field>
233 <field>
234 <name>is_recur</name>
235 <title>Processor Supports Recurring?</title>
236 <type>boolean</type>
237 <default>0</default>
238 <required>true</required>
239 <comment>Can process recurring contributions</comment>
240 <add>1.8</add>
241 </field>
242 <field>
243 <name>payment_type</name>
244 <title>Payment Type</title>
245 <type>int unsigned</type>
246 <default>1</default>
247 <comment>Payment Type: Credit or Debit (deprecated)</comment>
248 <add>3.0</add>
249 </field>
250 <field>
251 <name>payment_instrument_id</name>
252 <title>Payment Method</title>
253 <type>int unsigned</type>
254 <default>1</default>
255 <comment>Payment Instrument ID</comment>
256 <pseudoconstant>
257 <optionGroupName>payment_instrument</optionGroupName>
258 </pseudoconstant>
259 <add>4.7</add>
260 </field>
261 <field>
262 <name>accepted_credit_cards</name>
263 <title>Accepted Credit Cards</title>
264 <type>text</type>
265 <default>NULL</default>
266 <comment>array of accepted credit card types</comment>
267 <serialize>JSON</serialize>
268 <add>4.7</add>
269 </field>
270 </table>