[civicrm-core.git] / xml / schema / Financial / PaymentProcessor.xml

<?xml version="1.0" encoding="iso-8859-1" ?>

<table>
  <base>CRM/Financial</base>
  <class>PaymentProcessor</class>
  <name>civicrm_payment_processor</name>
  <add>1.8</add>
  <field>
    <name>id</name>
    <title>Payment Processor ID</title>
    <type>int unsigned</type>
    <required>true</required>
    <comment>Payment Processor ID</comment>
    <add>1.8</add>
  </field>
  <primaryKey>
    <name>id</name>
    <autoincrement>true</autoincrement>
  </primaryKey>
  <field>
    <name>domain_id</name>
    <title>Payment Processor Domain</title>
    <type>int unsigned</type>
    <required>true</required>
    <pseudoconstant>
      <table>civicrm_domain</table>
      <keyColumn>id</keyColumn>
      <labelColumn>name</labelColumn>
    </pseudoconstant>
    <comment>Which Domain is this match entry for</comment>
    <add>3.0</add>
  </field>
  <foreignKey>
    <name>domain_id</name>
    <table>civicrm_domain</table>
    <key>id</key>
    <add>3.0</add>
  </foreignKey>
  <field>
    <name>name</name>
    <title>Payment Processor</title>
    <type>varchar</type>
    <length>64</length>
    <comment>Payment Processor Name.</comment>
    <add>1.8</add>
    <html>
      <type>Text</type>
    </html>
  </field>
  <field>
    <name>title</name>
    <title>Payment Processor Title</title>
    <type>varchar</type>
    <length>127</length>
    <localizable>true</localizable>
    <html>
      <type>Text</type>
    </html>
    <comment>Payment Processor Descriptive Name.</comment>
    <add>5.13</add>
  </field>
  <field>
    <name>description</name>
    <title>Processor Description</title>
    <type>varchar</type>
    <length>255</length>
    <html>
      <type>Text</type>
    </html>
    <comment>Payment Processor Description.</comment>
    <add>1.8</add>
  </field>
  <field>
    <name>payment_processor_type</name>
    <type>varchar</type>
    <length>255</length>
    <comment>Payment Processor Type.</comment>
    <add>1.8</add>
    <drop>4.3</drop>
  </field>
  <field>
    <name>payment_processor_type_id</name>
    <title>Payment Processor Type ID</title>
    <type>int unsigned</type>
    <pseudoconstant>
      <table>civicrm_payment_processor_type</table>
      <keyColumn>id</keyColumn>
      <labelColumn>title</labelColumn>
    </pseudoconstant>
    <required>true</required>
    <length>10</length>
    <add>4.3</add>
  </field>
  <foreignKey>
    <name>payment_processor_type_id</name>
    <table>civicrm_payment_processor_type</table>
    <key>id</key>
    <add>4.3</add>
  </foreignKey>
  <field>
    <name>is_active</name>
    <title>Processor is Active?</title>
    <type>boolean</type>
    <comment>Is this processor active?</comment>
    <add>1.8</add>
    <default>1</default>
  </field>
  <field>
    <name>is_default</name>
    <title>Processor Is Default?</title>
    <type>boolean</type>
    <comment>Is this processor the default?</comment>
    <add>1.8</add>
    <default>0</default>
  </field>
  <field>
    <name>is_test</name>
    <title>Is Test Processor?</title>
    <type>boolean</type>
    <comment>Is this processor for a test site?</comment>
    <add>1.8</add>
    <default>0</default>
  </field>
  <index>
    <name>UI_name_test_domain_id</name>
    <fieldName>name</fieldName>
    <fieldName>is_test</fieldName>
    <fieldName>domain_id</fieldName>
    <unique>true</unique>
    <add>1.8</add>
  </index>
  <field>
    <name>user_name</name>
    <title>User Name</title>
    <type>varchar</type>
    <length>255</length>
    <add>1.8</add>
    <html>
      <type>Text</type>
    </html>
  </field>
  <field>
    <name>password</name>
    <title>Password</title>
    <type>varchar</type>
    <length>255</length>
    <add>1.8</add>
    <html>
      <type>Password</type>
    </html>
  </field>
  <field>
    <name>signature</name>
    <title>Signature</title>
    <type>text</type>
    <add>1.8</add>
    <html>
      <type>TextArea</type>
      <rows>4</rows>
      <cols>40</cols>
    </html>
  </field>
  <field>
    <name>url_site</name>
    <title>Site URL</title>
    <type>varchar</type>
    <length>255</length>
    <add>1.8</add>
    <html>
      <type>Text</type>
    </html>
  </field>
  <field>
    <name>url_api</name>
    <title>API URL</title>
    <type>varchar</type>
    <length>255</length>
    <add>1.8</add>
    <html>
      <type>Text</type>
    </html>
  </field>
  <field>
    <name>url_recur</name>
    <title>Recurring Payments URL</title>
    <type>varchar</type>
    <length>255</length>
    <add>1.8</add>
    <html>
      <type>Text</type>
    </html>
  </field>
  <field>
    <name>url_button</name>
    <title>Button URL</title>
    <type>varchar</type>
    <length>255</length>
    <add>1.8</add>
    <html>
      <type>Text</type>
    </html>
  </field>
  <field>
    <name>subject</name>
    <title>Subject</title>
    <type>varchar</type>
    <length>255</length>
    <add>1.8</add>
    <html>
      <type>Text</type>
    </html>
  </field>
  <field>
    <name>class_name</name>
    <title>Suffix for PHP class name implementation</title>
    <type>varchar</type>
    <length>255</length>
    <add>1.8</add>
  </field>
  <field>
    <name>billing_mode</name>
    <title>Processor Billing Mode</title>
    <type>int unsigned</type>
    <required>true</required>
    <comment>Billing Mode (deprecated)</comment>
    <add>1.8</add>
  </field>
  <field>
    <name>is_recur</name>
    <title>Processor Supports Recurring?</title>
    <type>boolean</type>
    <comment>Can process recurring contributions</comment>
    <add>1.8</add>
  </field>
  <field>
    <name>payment_type</name>
    <title>Payment Type</title>
    <type>int unsigned</type>
    <default>1</default>
    <comment>Payment Type: Credit or Debit (deprecated)</comment>
    <add>3.0</add>
  </field>
  <field>
    <name>payment_instrument_id</name>
    <title>Payment Method</title>
    <type>int unsigned</type>
    <default>1</default>
    <comment>Payment Instrument ID</comment>
    <pseudoconstant>
      <optionGroupName>payment_instrument</optionGroupName>
    </pseudoconstant>
    <add>4.7</add>
  </field>
<field>
    <name>accepted_credit_cards</name>
    <title>Accepted Credit Cards</title>
    <type>text</type>
    <default>NULL</default>
    <comment>array of accepted credit card types</comment>
    <serialize>JSON</serialize>
    <add>4.7</add>
  </field>
</table>
Commit	Line	Data
6a488035 TO	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>
0d94665e	10	<title>Payment Processor ID</title>
6a488035 TO	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>
0d94665e	22	<title>Payment Processor Domain</title>
6a488035 TO	23	<type>int unsigned</type>
6a488035 TO	24	<required>true</required>
c2b4755a EM	25	<pseudoconstant>
	26	<table>civicrm_domain</table>
	27	<keyColumn>id</keyColumn>
	28	<labelColumn>name</labelColumn>
	29	</pseudoconstant>
6a488035 TO	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>
3c7d2158	38	</foreignKey>
6a488035 TO	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>
1d2a585a	46	<html>
	47	<type>Text</type>
	48	</html>
6a488035	49	</field>
63b162c6	50	<field>
	51	<name>title</name>
	52	<title>Payment Processor Title</title>
	53	<type>varchar</type>
	54	<length>127</length>
4c257e17	55	<localizable>true</localizable>
63b162c6	56	<html>
	57	<type>Text</type>
	58	</html>
	59	<comment>Payment Processor Descriptive Name.</comment>
	60	<add>5.13</add>
	61	</field>
6a488035 TO	62	<field>
6a488035 TO	63	<name>description</name>
0d94665e	64	<title>Processor Description</title>
6a488035 TO	65	<type>varchar</type>
6a488035 TO	66	<length>255</length>
83376469	67	<html>
	68	<type>Text</type>
	69	</html>
6a488035 TO	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>
0d94665e	83	<title>Payment Processor Type ID</title>
6a488035	84	<type>int unsigned</type>
abae16ce EM	85	<pseudoconstant>
	86	<table>civicrm_payment_processor_type</table>
	87	<keyColumn>id</keyColumn>
420e262c	88	<labelColumn>title</labelColumn>
abae16ce	89	</pseudoconstant>
2f859d0a	90	<required>true</required>
6a488035 TO	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>
3c7d2158	99	</foreignKey>
6a488035 TO	100	<field>
6a488035 TO	101	<name>is_active</name>
0d94665e	102	<title>Processor is Active?</title>
6a488035 TO	103	<type>boolean</type>
	104	<comment>Is this processor active?</comment>
	105	<add>1.8</add>
2f859d0a	106	<default>1</default>
6a488035 TO	107	</field>
	108	<field>
	109	<name>is_default</name>
0d94665e	110	<title>Processor Is Default?</title>
6a488035 TO	111	<type>boolean</type>
	112	<comment>Is this processor the default?</comment>
	113	<add>1.8</add>
2f859d0a	114	<default>0</default>
6a488035 TO	115	</field>
	116	<field>
	117	<name>is_test</name>
0d94665e	118	<title>Is Test Processor?</title>
6a488035 TO	119	<type>boolean</type>
	120	<comment>Is this processor for a test site?</comment>
	121	<add>1.8</add>
2f859d0a	122	<default>0</default>
6a488035 TO	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>
1d2a585a	138	<html>
	139	<type>Text</type>
	140	</html>
6a488035 TO	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>
1d2a585a	148	<html>
dbb62458	149	<type>Password</type>
1d2a585a	150	</html>
6a488035 TO	151	</field>
	152	<field>
	153	<name>signature</name>
	154	<title>Signature</title>
bfc328ef	155	<type>text</type>
6a488035	156	<add>1.8</add>
1d2a585a	157	<html>
	158	<type>TextArea</type>
	159	<rows>4</rows>
	160	<cols>40</cols>
	161	</html>
6a488035 TO	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>
1d2a585a	169	<html>
	170	<type>Text</type>
	171	</html>
6a488035 TO	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>
1d2a585a	179	<html>
	180	<type>Text</type>
	181	</html>
6a488035 TO	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>
1d2a585a	189	<html>
	190	<type>Text</type>
	191	</html>
6a488035 TO	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>
1d2a585a	199	<html>
	200	<type>Text</type>
	201	</html>
6a488035 TO	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>
1d2a585a	209	<html>
	210	<type>Text</type>
	211	</html>
6a488035 TO	212	</field>
	213	<field>
	214	<name>class_name</name>
e4f46be0	215	<title>Suffix for PHP class name implementation</title>
6a488035 TO	216	<type>varchar</type>
	217	<length>255</length>
	218	<add>1.8</add>
	219	</field>
	220	<field>
	221	<name>billing_mode</name>
0d94665e	222	<title>Processor Billing Mode</title>
6a488035 TO	223	<type>int unsigned</type>
6a488035 TO	224	<required>true</required>
a1936a29	225	<comment>Billing Mode (deprecated)</comment>
6a488035 TO	226	<add>1.8</add>
	227	</field>
	228	<field>
	229	<name>is_recur</name>
0d94665e	230	<title>Processor Supports Recurring?</title>
6a488035 TO	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>
0d94665e	237	<title>Payment Type</title>
6a488035	238	<type>int unsigned</type>
3c7d2158	239	<default>1</default>
a1936a29	240	<comment>Payment Type: Credit or Debit (deprecated)</comment>
6a488035 TO	241	<add>3.0</add>
6a488035 TO	242	</field>
a1936a29 EM	243	<field>
a1936a29 EM	244	<name>payment_instrument_id</name>
536f0e02	245	<title>Payment Method</title>
a1936a29 EM	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>
cb5962bd SL	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>
2a5c9b4d	260	<serialize>JSON</serialize>
cb5962bd SL	261	<add>4.7</add>
cb5962bd SL	262	</field>
6a488035	263	</table>