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