[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_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>
6a488035 TO	73	<field>
6a488035 TO	74	<name>payment_processor_type_id</name>
0d94665e	75	<title>Payment Processor Type ID</title>
6a488035	76	<type>int unsigned</type>
abae16ce EM	77	<pseudoconstant>
	78	<table>civicrm_payment_processor_type</table>
	79	<keyColumn>id</keyColumn>
420e262c	80	<labelColumn>title</labelColumn>
abae16ce	81	</pseudoconstant>
2f859d0a	82	<required>true</required>
6a488035 TO	83	<length>10</length>
	84	<add>4.3</add>
	85	</field>
	86	<foreignKey>
	87	<name>payment_processor_type_id</name>
	88	<table>civicrm_payment_processor_type</table>
	89	<key>id</key>
	90	<add>4.3</add>
3c7d2158	91	</foreignKey>
6a488035 TO	92	<field>
6a488035 TO	93	<name>is_active</name>
0d94665e	94	<title>Processor is Active?</title>
6a488035 TO	95	<type>boolean</type>
	96	<comment>Is this processor active?</comment>
	97	<add>1.8</add>
2f859d0a	98	<default>1</default>
6a488035 TO	99	</field>
	100	<field>
	101	<name>is_default</name>
0d94665e	102	<title>Processor Is Default?</title>
6a488035 TO	103	<type>boolean</type>
	104	<comment>Is this processor the default?</comment>
	105	<add>1.8</add>
2f859d0a	106	<default>0</default>
6a488035 TO	107	</field>
	108	<field>
	109	<name>is_test</name>
0d94665e	110	<title>Is Test Processor?</title>
6a488035 TO	111	<type>boolean</type>
	112	<comment>Is this processor for a test site?</comment>
	113	<add>1.8</add>
2f859d0a	114	<default>0</default>
6a488035 TO	115	</field>
	116	<index>
	117	<name>UI_name_test_domain_id</name>
	118	<fieldName>name</fieldName>
	119	<fieldName>is_test</fieldName>
	120	<fieldName>domain_id</fieldName>
	121	<unique>true</unique>
	122	<add>1.8</add>
	123	</index>
	124	<field>
	125	<name>user_name</name>
	126	<title>User Name</title>
	127	<type>varchar</type>
	128	<length>255</length>
	129	<add>1.8</add>
1d2a585a	130	<html>
	131	<type>Text</type>
	132	</html>
6a488035 TO	133	</field>
	134	<field>
	135	<name>password</name>
	136	<title>Password</title>
	137	<type>varchar</type>
	138	<length>255</length>
	139	<add>1.8</add>
1d2a585a	140	<html>
dbb62458	141	<type>Password</type>
1d2a585a	142	</html>
6a488035 TO	143	</field>
	144	<field>
	145	<name>signature</name>
	146	<title>Signature</title>
bfc328ef	147	<type>text</type>
6a488035	148	<add>1.8</add>
1d2a585a	149	<html>
	150	<type>TextArea</type>
	151	<rows>4</rows>
	152	<cols>40</cols>
	153	</html>
6a488035 TO	154	</field>
	155	<field>
	156	<name>url_site</name>
	157	<title>Site URL</title>
	158	<type>varchar</type>
	159	<length>255</length>
	160	<add>1.8</add>
1d2a585a	161	<html>
	162	<type>Text</type>
	163	</html>
6a488035 TO	164	</field>
	165	<field>
	166	<name>url_api</name>
	167	<title>API URL</title>
	168	<type>varchar</type>
	169	<length>255</length>
	170	<add>1.8</add>
1d2a585a	171	<html>
	172	<type>Text</type>
	173	</html>
6a488035 TO	174	</field>
	175	<field>
	176	<name>url_recur</name>
	177	<title>Recurring Payments URL</title>
	178	<type>varchar</type>
	179	<length>255</length>
	180	<add>1.8</add>
1d2a585a	181	<html>
	182	<type>Text</type>
	183	</html>
6a488035 TO	184	</field>
	185	<field>
	186	<name>url_button</name>
	187	<title>Button URL</title>
	188	<type>varchar</type>
	189	<length>255</length>
	190	<add>1.8</add>
1d2a585a	191	<html>
	192	<type>Text</type>
	193	</html>
6a488035 TO	194	</field>
	195	<field>
	196	<name>subject</name>
	197	<title>Subject</title>
	198	<type>varchar</type>
	199	<length>255</length>
	200	<add>1.8</add>
1d2a585a	201	<html>
	202	<type>Text</type>
	203	</html>
6a488035 TO	204	</field>
	205	<field>
	206	<name>class_name</name>
e4f46be0	207	<title>Suffix for PHP class name implementation</title>
6a488035 TO	208	<type>varchar</type>
	209	<length>255</length>
	210	<add>1.8</add>
	211	</field>
	212	<field>
	213	<name>billing_mode</name>
0d94665e	214	<title>Processor Billing Mode</title>
6a488035 TO	215	<type>int unsigned</type>
6a488035 TO	216	<required>true</required>
a1936a29	217	<comment>Billing Mode (deprecated)</comment>
6a488035 TO	218	<add>1.8</add>
	219	</field>
	220	<field>
	221	<name>is_recur</name>
0d94665e	222	<title>Processor Supports Recurring?</title>
6a488035 TO	223	<type>boolean</type>
	224	<comment>Can process recurring contributions</comment>
	225	<add>1.8</add>
	226	</field>
	227	<field>
	228	<name>payment_type</name>
0d94665e	229	<title>Payment Type</title>
6a488035	230	<type>int unsigned</type>
3c7d2158	231	<default>1</default>
a1936a29	232	<comment>Payment Type: Credit or Debit (deprecated)</comment>
6a488035 TO	233	<add>3.0</add>
6a488035 TO	234	</field>
a1936a29 EM	235	<field>
a1936a29 EM	236	<name>payment_instrument_id</name>
536f0e02	237	<title>Payment Method</title>
a1936a29 EM	238	<type>int unsigned</type>
	239	<default>1</default>
	240	<comment>Payment Instrument ID</comment>
	241	<pseudoconstant>
	242	<optionGroupName>payment_instrument</optionGroupName>
	243	</pseudoconstant>
	244	<add>4.7</add>
	245	</field>
cb5962bd SL	246	<field>
	247	<name>accepted_credit_cards</name>
	248	<title>Accepted Credit Cards</title>
	249	<type>text</type>
	250	<default>NULL</default>
	251	<comment>array of accepted credit card types</comment>
2a5c9b4d	252	<serialize>JSON</serialize>
cb5962bd SL	253	<add>4.7</add>
cb5962bd SL	254	</field>
6a488035	255	</table>