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

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

<table>
  <base>CRM/Contribute</base>
  <class>ContributionProduct</class>
  <name>civicrm_contribution_product</name>
  <add>1.4</add>
  <log>true</log>
  <component>CiviContribute</component>
  <field>
    <name>id</name>
    <title>Contribution Product ID</title>
    <type>int unsigned</type>
    <required>true</required>
    <html>
      <type>Number</type>
    </html>
    <add>1.4</add>
  </field>
  <primaryKey>
    <name>id</name>
    <autoincrement>true</autoincrement>
  </primaryKey>
  <field>
    <name>product_id</name>
    <title>Product ID</title>
    <type>int unsigned</type>
    <required>true</required>
    <add>1.4</add>
  </field>
  <foreignKey>
    <name>product_id</name>
    <table>civicrm_product</table>
    <key>id</key>
    <add>5.39</add>
    <onDelete>CASCADE</onDelete>
  </foreignKey>
  <field>
    <name>contribution_id</name>
    <title>Contribution ID</title>
    <type>int unsigned</type>
    <required>true</required>
    <html>
      <label>Contribution</label>
    </html>
    <add>1.4</add>
  </field>
  <foreignKey>
    <name>contribution_id</name>
    <table>civicrm_contribution</table>
    <key>id</key>
    <add>1.4</add>
    <onDelete>CASCADE</onDelete>
  </foreignKey>
  <field>
    <name>product_option</name>
    <title>Product Option</title>
    <type>varchar</type>
    <length>255</length>
    <export>true</export>
    <comment>Option value selected if applicable - e.g. color, size etc.</comment>
    <add>1.4</add>
  </field>
  <field>
    <name>quantity</name>
    <title>Quantity</title>
    <type>int</type>
    <export>true</export>
    <comment></comment>
    <add>1.4</add>
  </field>
  <field>
    <name>fulfilled_date</name>
    <type>date</type>
    <title>Fulfilled Date</title>
    <export>true</export>
    <comment>Optional. Can be used to record the date this product was fulfilled or shipped.</comment>
    <add>1.4</add>
    <html>
      <type>Select Date</type>
      <formatType>activityDate</formatType>
    </html>
  </field>
  <field>
    <name>start_date</name>
    <uniqueName>contribution_start_date</uniqueName>
    <title>Start date for premium</title>
    <type>date</type>
    <export>true</export>
    <comment>Actual start date for a time-delimited premium (subscription, service or membership)</comment>
    <add>1.4</add>
  </field>
  <field>
    <name>end_date</name>
    <uniqueName>contribution_end_date</uniqueName>
    <type>date</type>
    <title>End date for premium</title>
    <export>true</export>
    <comment>Actual end date for a time-delimited premium (subscription, service or membership)</comment>
    <add>1.4</add>
  </field>
  <field>
    <name>comment</name>
    <title>Premium comment</title>
    <type>text</type>
    <add>1.4</add>
  </field>
  <field>
    <name>financial_type_id</name>
    <title>Financial Type ID</title>
    <type>int unsigned</type>
    <default>NULL</default>
    <pseudoconstant>
      <table>civicrm_financial_type</table>
      <keyColumn>id</keyColumn>
      <labelColumn>name</labelColumn>
    </pseudoconstant>
    <comment>FK to Financial Type(for membership price sets only).</comment>
    <html>
      <label>Financial Type</label>
    </html>
    <add>4.3</add>
  </field>
  <foreignKey>
    <name>financial_type_id</name>
    <table>civicrm_financial_type</table>
    <key>id</key>
    <onDelete>SET NULL</onDelete>
    <add>4.3</add>
  </foreignKey>
</table>
Commit	Line	Data
3c7d2158	1	<?xml version="1.0" encoding="iso-8859-1" ?>
6a488035	2
3c7d2158	3	<table>
	4	<base>CRM/Contribute</base>
	5	<class>ContributionProduct</class>
	6	<name>civicrm_contribution_product</name>
	7	<add>1.4</add>
6a488035	8	<log>true</log>
d31fb4e3	9	<component>CiviContribute</component>
3c7d2158	10	<field>
3c7d2158	11	<name>id</name>
eddae1b3	12	<title>Contribution Product ID</title>
6a488035	13	<type>int unsigned</type>
3c7d2158	14	<required>true</required>
0481e12c A	15	<html>
	16	<type>Number</type>
	17	</html>
3c7d2158	18	<add>1.4</add>
	19	</field>
	20	<primaryKey>
	21	<name>id</name>
	22	<autoincrement>true</autoincrement>
	23	</primaryKey>
	24	<field>
	25	<name>product_id</name>
eddae1b3	26	<title>Product ID</title>
3c7d2158	27	<type>int unsigned</type>
	28	<required>true</required>
	29	<add>1.4</add>
	30	</field>
8714d4b4 MD	31	<foreignKey>
	32	<name>product_id</name>
	33	<table>civicrm_product</table>
	34	<key>id</key>
	35	<add>5.39</add>
	36	<onDelete>CASCADE</onDelete>
	37	</foreignKey>
3c7d2158	38	<field>
3c7d2158	39	<name>contribution_id</name>
eddae1b3	40	<title>Contribution ID</title>
3c7d2158	41	<type>int unsigned</type>
3c7d2158	42	<required>true</required>
57e94608 A	43	<html>
	44	<label>Contribution</label>
	45	</html>
3c7d2158	46	<add>1.4</add>
	47	</field>
	48	<foreignKey>
	49	<name>contribution_id</name>
	50	<table>civicrm_contribution</table>
	51	<key>id</key>
	52	<add>1.4</add>
6a488035	53	<onDelete>CASCADE</onDelete>
3c7d2158	54	</foreignKey>
	55	<field>
	56	<name>product_option</name>
6a488035	57	<title>Product Option</title>
3c7d2158	58	<type>varchar</type>
6a488035 TO	59	<length>255</length>
6a488035 TO	60	<export>true</export>
3c7d2158	61	<comment>Option value selected if applicable - e.g. color, size etc.</comment>
	62	<add>1.4</add>
	63	</field>
	64	<field>
	65	<name>quantity</name>
6a488035 TO	66	<title>Quantity</title>
6a488035 TO	67	<type>int</type>
6a488035	68	<export>true</export>
3c7d2158	69	<comment></comment>
	70	<add>1.4</add>
	71	</field>
3c7d2158	72	<field>
3c7d2158	73	<name>fulfilled_date</name>
6a488035	74	<type>date</type>
eddae1b3	75	<title>Fulfilled Date</title>
6a488035	76	<export>true</export>
3c7d2158	77	<comment>Optional. Can be used to record the date this product was fulfilled or shipped.</comment>
3c7d2158	78	<add>1.4</add>
a69cf1d1 SL	79	<html>
	80	<type>Select Date</type>
	81	<formatType>activityDate</formatType>
	82	</html>
3c7d2158	83	</field>
	84	<field>
	85	<name>start_date</name>
6a488035	86	<uniqueName>contribution_start_date</uniqueName>
eddae1b3	87	<title>Start date for premium</title>
3c7d2158	88	<type>date</type>
6a488035	89	<export>true</export>
3c7d2158	90	<comment>Actual start date for a time-delimited premium (subscription, service or membership)</comment>
3c7d2158	91	<add>1.4</add>
6a488035	92	</field>
3c7d2158	93	<field>
3c7d2158	94	<name>end_date</name>
6a488035 TO	95	<uniqueName>contribution_end_date</uniqueName>
6a488035 TO	96	<type>date</type>
eddae1b3	97	<title>End date for premium</title>
6a488035	98	<export>true</export>
3c7d2158	99	<comment>Actual end date for a time-delimited premium (subscription, service or membership)</comment>
3c7d2158	100	<add>1.4</add>
6a488035	101	</field>
3c7d2158	102	<field>
3c7d2158	103	<name>comment</name>
eddae1b3	104	<title>Premium comment</title>
3c7d2158	105	<type>text</type>
3c7d2158	106	<add>1.4</add>
6a488035	107	</field>
3c7d2158	108	<field>
3c7d2158	109	<name>financial_type_id</name>
57e94608	110	<title>Financial Type ID</title>
3c7d2158	111	<type>int unsigned</type>
6a488035	112	<default>NULL</default>
6cc0b7bd EM	113	<pseudoconstant>
	114	<table>civicrm_financial_type</table>
	115	<keyColumn>id</keyColumn>
	116	<labelColumn>name</labelColumn>
	117	</pseudoconstant>
6a488035	118	<comment>FK to Financial Type(for membership price sets only).</comment>
57e94608 A	119	<html>
	120	<label>Financial Type</label>
	121	</html>
3c7d2158	122	<add>4.3</add>
	123	</field>
	124	<foreignKey>
	125	<name>financial_type_id</name>
	126	<table>civicrm_financial_type</table>
	127	<key>id</key>
6a488035 TO	128	<onDelete>SET NULL</onDelete>
6a488035 TO	129	<add>4.3</add>
3c7d2158	130	</foreignKey>
6a488035	131	</table>