[civicrm-core.git] / xml / schema / Contribute / ContributionSoft.xml

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

<table>
  <base>CRM/Contribute</base>
  <class>ContributionSoft</class>
  <name>civicrm_contribution_soft</name>
  <add>2.2</add>
  <log>true</log>
  <field>
    <name>id</name>
    <uniqueName>contribution_soft_id</uniqueName>
    <title>Soft Contribution ID</title>
    <type>int unsigned</type>
    <required>true</required>
    <import>true</import>
    <title>Soft Contribution ID</title>
    <comment>Soft Contribution ID</comment>
    <add>2.2</add>
  </field>
  <primaryKey>
    <name>id</name>
    <autoincrement>true</autoincrement>
  </primaryKey>
  <field>
    <name>contribution_id</name>
    <title>Soft Contribution - Contribution</title>
    <type>int unsigned</type>
    <required>true</required>
    <comment>FK to contribution table.</comment>
    <add>2.2</add>
  </field>
  <foreignKey>
    <name>contribution_id</name>
    <table>civicrm_contribution</table>
    <key>id</key>
    <add>2.2</add>
    <onDelete>CASCADE</onDelete>
  </foreignKey>
  <field>
    <name>contact_id</name>
    <uniqueName>contribution_soft_contact_id</uniqueName>
    <title>Contact ID</title>
    <type>int unsigned</type>
    <required>true</required>
    <import>true</import>
    <headerPattern>/contact(.?id)?/i</headerPattern>
    <dataPattern>/^\d+$/</dataPattern>
    <comment>FK to Contact ID</comment>
    <add>2.2</add>
  </field>
  <foreignKey>
    <name>contact_id</name>
    <table>civicrm_contact</table>
    <key>id</key>
    <add>2.2</add>
    <onDelete>CASCADE</onDelete>
  </foreignKey>
  <field>
    <name>amount</name>
    <title>Soft Contribution Amount</title>
    <type>decimal</type>
    <required>true</required>
    <import>true</import>
    <headerPattern>/total(.?am(ou)?nt)?/i</headerPattern>
    <dataPattern>/^\d+(\.\d{2})?$/</dataPattern>
    <comment>Amount of this soft contribution.</comment>
    <add>2.2</add>
  </field>
  <field>
    <name>currency</name>
    <type>varchar</type>
    <title>Soft Contribution Currency</title>
    <length>3</length>
    <default>NULL</default>
    <comment>3 character string, value from config setting or input via user.</comment>
    <add>3.2</add>
    <pseudoconstant>
      <table>civicrm_currency</table>
      <keyColumn>name</keyColumn>
      <labelColumn>full_name</labelColumn>
      <nameColumn>numeric_code</nameColumn>
    </pseudoconstant>
    <html>
      <type>Select</type>
    </html>
  </field>
  <field>
    <name>pcp_id</name>
    <type>int unsigned</type>
    <title>Soft Contribution PCP</title>
    <default>NULL</default>
    <comment>FK to civicrm_pcp.id</comment>
    <add>2.2</add>
  </field>
  <foreignKey>
    <name>pcp_id</name>
    <table>civicrm_pcp</table>
    <key>id</key>
    <add>3.1</add>
    <onDelete>SET NULL</onDelete>
  </foreignKey>
  <index>
    <name>index_id</name>
    <fieldName>pcp_id</fieldName>
    <add>2.2</add>
  </index>
  <field>
    <name>pcp_display_in_roll</name>
    <type>boolean</type>
    <title>Soft Contribution Display on PCP</title>
    <default>0</default>
    <add>2.2</add>
  </field>
  <field>
    <name>pcp_roll_nickname</name>
    <type>varchar</type>
    <title>Soft Contribution PCP Nickname</title>
    <length>255</length>
    <default>NULL</default>
    <add>2.2</add>
  </field>
  <field>
    <name>pcp_personal_note</name>
    <type>varchar</type>
    <title>Soft Contribution PCP Note</title>
    <length>255</length>
    <default>NULL</default>
    <add>2.2</add>
  </field>
  <field>
    <name>soft_credit_type_id</name>
    <type>int unsigned</type>
    <default>NULL</default>
    <title>Soft Credit Type</title>
    <pseudoconstant>
      <optionGroupName>soft_credit_type</optionGroupName>
    </pseudoconstant>
    <comment>Soft Credit Type ID.Implicit FK to civicrm_option_value where option_group = soft_credit_type.</comment>
    <add>2.2</add>
  </field>
</table>
Commit	Line	Data
3c7d2158	1	<?xml version="1.0" encoding="iso-8859-1" ?>
	2
	3	<table>
	4	<base>CRM/Contribute</base>
	5	<class>ContributionSoft</class>
	6	<name>civicrm_contribution_soft</name>
	7	<add>2.2</add>
6a488035	8	<log>true</log>
3c7d2158	9	<field>
8f069c03 EM	10	<name>id</name>
8f069c03 EM	11	<uniqueName>contribution_soft_id</uniqueName>
83396bf9	12	<title>Soft Contribution ID</title>
8f069c03 EM	13	<type>int unsigned</type>
	14	<required>true</required>
	15	<import>true</import>
	16	<title>Soft Contribution ID</title>
	17	<comment>Soft Contribution ID</comment>
	18	<add>2.2</add>
3c7d2158	19	</field>
3c7d2158	20	<primaryKey>
8f069c03 EM	21	<name>id</name>
8f069c03 EM	22	<autoincrement>true</autoincrement>
3c7d2158	23	</primaryKey>
3c7d2158	24	<field>
8f069c03	25	<name>contribution_id</name>
83396bf9	26	<title>Soft Contribution - Contribution</title>
8f069c03 EM	27	<type>int unsigned</type>
	28	<required>true</required>
	29	<comment>FK to contribution table.</comment>
	30	<add>2.2</add>
3c7d2158	31	</field>
3c7d2158	32	<foreignKey>
8f069c03 EM	33	<name>contribution_id</name>
	34	<table>civicrm_contribution</table>
	35	<key>id</key>
	36	<add>2.2</add>
	37	<onDelete>CASCADE</onDelete>
6a488035	38	</foreignKey>
3c7d2158	39	<field>
8f069c03 EM	40	<name>contact_id</name>
	41	<uniqueName>contribution_soft_contact_id</uniqueName>
	42	<title>Contact ID</title>
	43	<type>int unsigned</type>
	44	<required>true</required>
	45	<import>true</import>
	46	<headerPattern>/contact(.?id)?/i</headerPattern>
	47	<dataPattern>/^\d+$/</dataPattern>
	48	<comment>FK to Contact ID</comment>
	49	<add>2.2</add>
3c7d2158	50	</field>
3c7d2158	51	<foreignKey>
8f069c03 EM	52	<name>contact_id</name>
	53	<table>civicrm_contact</table>
	54	<key>id</key>
	55	<add>2.2</add>
	56	<onDelete>CASCADE</onDelete>
3c7d2158	57	</foreignKey>
3c7d2158	58	<field>
8f069c03	59	<name>amount</name>
83396bf9	60	<title>Soft Contribution Amount</title>
8f069c03 EM	61	<type>decimal</type>
	62	<required>true</required>
	63	<import>true</import>
	64	<headerPattern>/total(.?am(ou)?nt)?/i</headerPattern>
	65	<dataPattern>/^\d+(\.\d{2})?$/</dataPattern>
	66	<comment>Amount of this soft contribution.</comment>
	67	<add>2.2</add>
6a488035 TO	68	</field>
6a488035 TO	69	<field>
8f069c03 EM	70	<name>currency</name>
8f069c03 EM	71	<type>varchar</type>
83396bf9	72	<title>Soft Contribution Currency</title>
8f069c03 EM	73	<length>3</length>
	74	<default>NULL</default>
	75	<comment>3 character string, value from config setting or input via user.</comment>
	76	<add>3.2</add>
	77	<pseudoconstant>
	78	<table>civicrm_currency</table>
	79	<keyColumn>name</keyColumn>
	80	<labelColumn>full_name</labelColumn>
	81	<nameColumn>numeric_code</nameColumn>
	82	</pseudoconstant>
	83	<html>
	84	<type>Select</type>
	85	</html>
6a488035	86	</field>
3c7d2158	87	<field>
8f069c03 EM	88	<name>pcp_id</name>
8f069c03 EM	89	<type>int unsigned</type>
83396bf9	90	<title>Soft Contribution PCP</title>
8f069c03 EM	91	<default>NULL</default>
	92	<comment>FK to civicrm_pcp.id</comment>
	93	<add>2.2</add>
3c7d2158	94	</field>
6a488035	95	<foreignKey>
8f069c03 EM	96	<name>pcp_id</name>
	97	<table>civicrm_pcp</table>
	98	<key>id</key>
	99	<add>3.1</add>
	100	<onDelete>SET NULL</onDelete>
6a488035 TO	101	</foreignKey>
6a488035 TO	102	<index>
8f069c03 EM	103	<name>index_id</name>
	104	<fieldName>pcp_id</fieldName>
	105	<add>2.2</add>
	106	</index>
	107	<field>
	108	<name>pcp_display_in_roll</name>
	109	<type>boolean</type>
83396bf9	110	<title>Soft Contribution Display on PCP</title>
8f069c03 EM	111	<default>0</default>
8f069c03 EM	112	<add>2.2</add>
3c7d2158	113	</field>
6a488035	114	<field>
8f069c03 EM	115	<name>pcp_roll_nickname</name>
8f069c03 EM	116	<type>varchar</type>
83396bf9	117	<title>Soft Contribution PCP Nickname</title>
8f069c03 EM	118	<length>255</length>
	119	<default>NULL</default>
	120	<add>2.2</add>
6a488035 TO	121	</field>
6a488035 TO	122	<field>
8f069c03 EM	123	<name>pcp_personal_note</name>
8f069c03 EM	124	<type>varchar</type>
83396bf9	125	<title>Soft Contribution PCP Note</title>
8f069c03 EM	126	<length>255</length>
	127	<default>NULL</default>
	128	<add>2.2</add>
6a488035	129	</field>
51fa20cb	130	<field>
8f069c03 EM	131	<name>soft_credit_type_id</name>
	132	<type>int unsigned</type>
	133	<default>NULL</default>
	134	<title>Soft Credit Type</title>
	135	<pseudoconstant>
	136	<optionGroupName>soft_credit_type</optionGroupName>
	137	</pseudoconstant>
	138	<comment>Soft Credit Type ID.Implicit FK to civicrm_option_value where option_group = soft_credit_type.</comment>
	139	<add>2.2</add>
51fa20cb	140	</field>
6a488035	141	</table>