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

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

<table>
  <base>CRM/Financial</base>
  <class>PaymentProcessorType</class>
  <name>civicrm_payment_processor_type</name>
  <add>1.8</add>
  <component>CiviContribute</component>
  <field>
    <name>id</name>
    <title>Payment Processor Type ID</title>
    <type>int unsigned</type>
    <required>true</required>
    <comment>Payment Processor Type ID</comment>
    <html>
      <type>Number</type>
    </html>
    <add>1.8</add>
  </field>
  <primaryKey>
    <name>id</name>
    <autoincrement>true</autoincrement>
  </primaryKey>
  <field>
    <name>name</name>
    <title>Payment Processor Type variable name to be used in code</title>
    <type>varchar</type>
    <length>64</length>
    <comment>Payment Processor Type Name.</comment>
    <add>1.8</add>
    <required>true</required>
  </field>
  <field>
    <name>title</name>
    <title>Payment Processor Type Title</title>
    <type>varchar</type>
    <length>127</length>
    <comment>Payment Processor Type Title.</comment>
    <add>1.8</add>
    <required>true</required>
  </field>
  <field>
    <name>description</name>
    <title>Processor Type Description</title>
    <type>varchar</type>
    <length>255</length>
    <comment>Payment Processor Description.</comment>
    <add>1.8</add>
  </field>
  <field>
    <name>is_active</name>
    <title>Processor Type 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 Type is Default?</title>
    <type>boolean</type>
    <comment>Is this processor the default?</comment>
    <add>1.8</add>
    <default>0</default>
  </field>
  <index>
    <name>UI_name</name>
    <fieldName>name</fieldName>
    <unique>true</unique>
    <add>2.1</add>
  </index>
  <field>
    <name>user_name_label</name>
    <title>Label for User Name if used</title>
    <type>varchar</type>
    <length>255</length>
    <add>1.8</add>
  </field>
  <field>
    <name>password_label</name>
    <title>Label for password</title>
    <type>varchar</type>
    <length>255</length>
    <add>1.8</add>
  </field>
  <field>
    <name>signature_label</name>
    <title>Label for Signature</title>
    <type>varchar</type>
    <length>255</length>
    <add>1.8</add>
  </field>
  <field>
    <name>subject_label</name>
    <title>Label for Subject</title>
    <type>varchar</type>
    <length>255</length>
    <add>1.8</add>
  </field>
  <field>
    <name>class_name</name>
    <title>Suffix for PHP class name implementation</title>
    <type>varchar</type>
    <length>255</length>
    <add>1.8</add>
    <required>true</required>
  </field>
  <field>
    <name>url_site_default</name>
    <title>Default Live Site URL</title>
    <type>varchar</type>
    <length>255</length>
    <add>1.8</add>
  </field>
  <field>
    <name>url_api_default</name>
    <title>Default API Site URL</title>
    <type>varchar</type>
    <length>255</length>
    <add>1.8</add>
  </field>
  <field>
    <name>url_recur_default</name>
    <title>Default Live Recurring Payments URL</title>
    <type>varchar</type>
    <length>255</length>
    <add>1.8</add>
  </field>
  <field>
    <name>url_button_default</name>
    <title>Default Live Button URL</title>
    <type>varchar</type>
    <length>255</length>
    <add>1.8</add>
  </field>
  <field>
    <name>url_site_test_default</name>
    <title>Default Test Site URL</title>
    <type>varchar</type>
    <length>255</length>
    <add>1.8</add>
  </field>
  <field>
    <name>url_api_test_default</name>
    <title>Default Test API URL</title>
    <type>varchar</type>
    <length>255</length>
    <add>1.8</add>
  </field>
  <field>
    <name>url_recur_test_default</name>
    <title>Default Test Recurring Payment URL</title>
    <type>varchar</type>
    <length>255</length>
    <add>1.8</add>
  </field>
  <field>
    <name>url_button_test_default</name>
    <title>Default Test Button URL</title>
    <type>varchar</type>
    <length>255</length>
    <add>1.8</add>
  </field>
  <field>
    <name>billing_mode</name>
    <type>int unsigned</type>
    <required>true</required>
    <comment>Billing Mode (deprecated)</comment>
    <pseudoconstant>
      <callback>CRM_Core_SelectValues::billingMode</callback>
    </pseudoconstant>
    <html>
      <type>Select</type>
      <label>Billing Mode</label>
    </html>
    <add>1.8</add>
  </field>
  <field>
    <name>is_recur</name>
    <title>Processor Type Supports Recurring?</title>
    <type>boolean</type>
    <comment>Can process recurring contributions</comment>
    <add>1.8</add>
  </field>
  <field>
    <name>payment_type</name>
    <title>Processor Type 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>
</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>PaymentProcessorType</class>
	6	<name>civicrm_payment_processor_type</name>
	7	<add>1.8</add>
d31fb4e3	8	<component>CiviContribute</component>
6a488035	9	<field>
8f069c03	10	<name>id</name>
0d94665e	11	<title>Payment Processor Type ID</title>
8f069c03 EM	12	<type>int unsigned</type>
	13	<required>true</required>
	14	<comment>Payment Processor Type ID</comment>
0481e12c A	15	<html>
	16	<type>Number</type>
	17	</html>
8f069c03	18	<add>1.8</add>
6a488035 TO	19	</field>
6a488035 TO	20	<primaryKey>
8f069c03 EM	21	<name>id</name>
8f069c03 EM	22	<autoincrement>true</autoincrement>
6a488035 TO	23	</primaryKey>
6a488035 TO	24	<field>
8f069c03	25	<name>name</name>
9c992885	26	<title>Payment Processor Type variable name to be used in code</title>
8f069c03 EM	27	<type>varchar</type>
8f069c03 EM	28	<length>64</length>
9c992885	29	<comment>Payment Processor Type Name.</comment>
8f069c03	30	<add>1.8</add>
2f859d0a	31	<required>true</required>
6a488035 TO	32	</field>
6a488035 TO	33	<field>
8f069c03	34	<name>title</name>
2f859d0a	35	<title>Payment Processor Type Title</title>
8f069c03 EM	36	<type>varchar</type>
8f069c03 EM	37	<length>127</length>
2f859d0a	38	<comment>Payment Processor Type Title.</comment>
8f069c03	39	<add>1.8</add>
2f859d0a	40	<required>true</required>
6a488035 TO	41	</field>
6a488035 TO	42	<field>
8f069c03	43	<name>description</name>
0b4d9dfc	44	<title>Processor Type Description</title>
8f069c03 EM	45	<type>varchar</type>
	46	<length>255</length>
	47	<comment>Payment Processor Description.</comment>
	48	<add>1.8</add>
6a488035 TO	49	</field>
6a488035 TO	50	<field>
8f069c03	51	<name>is_active</name>
0d94665e	52	<title>Processor Type Is Active?</title>
8f069c03 EM	53	<type>boolean</type>
	54	<comment>Is this processor active?</comment>
	55	<add>1.8</add>
2f859d0a	56	<default>1</default>
6a488035 TO	57	</field>
6a488035 TO	58	<field>
8f069c03	59	<name>is_default</name>
0d94665e	60	<title>Processor Type is Default?</title>
8f069c03 EM	61	<type>boolean</type>
	62	<comment>Is this processor the default?</comment>
	63	<add>1.8</add>
2f859d0a	64	<default>0</default>
6a488035 TO	65	</field>
	66	<index>
	67	<name>UI_name</name>
	68	<fieldName>name</fieldName>
	69	<unique>true</unique>
	70	<add>2.1</add>
	71	</index>
	72	<field>
8f069c03 EM	73	<name>user_name_label</name>
	74	<title>Label for User Name if used</title>
	75	<type>varchar</type>
	76	<length>255</length>
	77	<add>1.8</add>
6a488035 TO	78	</field>
6a488035 TO	79	<field>
8f069c03 EM	80	<name>password_label</name>
	81	<title>Label for password</title>
	82	<type>varchar</type>
	83	<length>255</length>
	84	<add>1.8</add>
6a488035 TO	85	</field>
6a488035 TO	86	<field>
8f069c03 EM	87	<name>signature_label</name>
	88	<title>Label for Signature</title>
	89	<type>varchar</type>
	90	<length>255</length>
	91	<add>1.8</add>
6a488035 TO	92	</field>
6a488035 TO	93	<field>
8f069c03 EM	94	<name>subject_label</name>
	95	<title>Label for Subject</title>
	96	<type>varchar</type>
	97	<length>255</length>
	98	<add>1.8</add>
6a488035 TO	99	</field>
6a488035 TO	100	<field>
8f069c03	101	<name>class_name</name>
e4f46be0	102	<title>Suffix for PHP class name implementation</title>
8f069c03 EM	103	<type>varchar</type>
	104	<length>255</length>
	105	<add>1.8</add>
2f859d0a	106	<required>true</required>
6a488035 TO	107	</field>
6a488035 TO	108	<field>
8f069c03 EM	109	<name>url_site_default</name>
	110	<title>Default Live Site URL</title>
	111	<type>varchar</type>
	112	<length>255</length>
	113	<add>1.8</add>
6a488035 TO	114	</field>
6a488035 TO	115	<field>
8f069c03 EM	116	<name>url_api_default</name>
	117	<title>Default API Site URL</title>
	118	<type>varchar</type>
	119	<length>255</length>
	120	<add>1.8</add>
6a488035 TO	121	</field>
6a488035 TO	122	<field>
8f069c03 EM	123	<name>url_recur_default</name>
	124	<title>Default Live Recurring Payments URL</title>
	125	<type>varchar</type>
	126	<length>255</length>
	127	<add>1.8</add>
6a488035 TO	128	</field>
6a488035 TO	129	<field>
8f069c03 EM	130	<name>url_button_default</name>
	131	<title>Default Live Button URL</title>
	132	<type>varchar</type>
	133	<length>255</length>
	134	<add>1.8</add>
6a488035 TO	135	</field>
6a488035 TO	136	<field>
8f069c03 EM	137	<name>url_site_test_default</name>
	138	<title>Default Test Site URL</title>
	139	<type>varchar</type>
	140	<length>255</length>
	141	<add>1.8</add>
6a488035 TO	142	</field>
6a488035 TO	143	<field>
8f069c03 EM	144	<name>url_api_test_default</name>
	145	<title>Default Test API URL</title>
	146	<type>varchar</type>
	147	<length>255</length>
	148	<add>1.8</add>
6a488035 TO	149	</field>
6a488035 TO	150	<field>
8f069c03 EM	151	<name>url_recur_test_default</name>
	152	<title>Default Test Recurring Payment URL</title>
	153	<type>varchar</type>
	154	<length>255</length>
	155	<add>1.8</add>
6a488035 TO	156	</field>
6a488035 TO	157	<field>
8f069c03 EM	158	<name>url_button_test_default</name>
	159	<title>Default Test Button URL</title>
	160	<type>varchar</type>
	161	<length>255</length>
	162	<add>1.8</add>
6a488035 TO	163	</field>
6a488035 TO	164	<field>
8f069c03 EM	165	<name>billing_mode</name>
	166	<type>int unsigned</type>
	167	<required>true</required>
a1936a29	168	<comment>Billing Mode (deprecated)</comment>
8f069c03 EM	169	<pseudoconstant>
	170	<callback>CRM_Core_SelectValues::billingMode</callback>
	171	</pseudoconstant>
	172	<html>
	173	<type>Select</type>
fd735f54	174	<label>Billing Mode</label>
8f069c03 EM	175	</html>
8f069c03 EM	176	<add>1.8</add>
6a488035 TO	177	</field>
6a488035 TO	178	<field>
8f069c03	179	<name>is_recur</name>
0d94665e	180	<title>Processor Type Supports Recurring?</title>
8f069c03 EM	181	<type>boolean</type>
	182	<comment>Can process recurring contributions</comment>
	183	<add>1.8</add>
6a488035 TO	184	</field>
6a488035 TO	185	<field>
8f069c03	186	<name>payment_type</name>
0d94665e	187	<title>Processor Type Payment Type</title>
8f069c03 EM	188	<type>int unsigned</type>
8f069c03 EM	189	<default>1</default>
a1936a29	190	<comment>Payment Type: Credit or Debit (deprecated)</comment>
8f069c03	191	<add>3.0</add>
6a488035	192	</field>
a1936a29 EM	193	<field>
a1936a29 EM	194	<name>payment_instrument_id</name>
536f0e02	195	<title>Payment Method</title>
a1936a29 EM	196	<type>int unsigned</type>
	197	<default>1</default>
	198	<comment>Payment Instrument ID</comment>
	199	<pseudoconstant>
	200	<optionGroupName>payment_instrument</optionGroupName>
	201	</pseudoconstant>
	202	<add>4.7</add>
	203	</field>
6a488035	204	</table>