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