[civicrm-core.git] / xml / schema / Price / PriceSet.xml

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

<table>
  <base>CRM/Price</base>
  <class>PriceSet</class>
  <name>civicrm_price_set</name>
  <add>1.8</add>
  <log>true</log>
  <field>
    <name>id</name>
    <title>Price Set</title>
    <type>int unsigned</type>
    <required>true</required>
    <comment>Price Set</comment>
    <add>1.8</add>
    <html>
      <type>Select</type>
    </html>
  </field>
  <primaryKey>
    <name>id</name>
    <autoincrement>true</autoincrement>
  </primaryKey>
  <field>
    <name>domain_id</name>
    <title>Price Set Domain</title>
    <type>int unsigned</type>
    <pseudoconstant>
      <table>civicrm_domain</table>
      <keyColumn>id</keyColumn>
      <labelColumn>name</labelColumn>
    </pseudoconstant>
    <comment>Which Domain is this price-set for</comment>
    <add>3.1</add>
    <html>
      <type>Text</type>
    </html>
  </field>
  <foreignKey>
    <name>domain_id</name>
    <table>civicrm_domain</table>
    <key>id</key>
    <add>3.1</add>
  </foreignKey>
  <field>
    <name>name</name>
    <type>varchar</type>
    <length>255</length>
    <required>true</required>
    <comment>Variable name/programmatic handle for this set of price fields.</comment>
    <add>1.8</add>
    <html>
      <type>Text</type>
    </html>
  </field>
  <index>
    <name>UI_name</name>
    <fieldName>name</fieldName>
    <unique>true</unique>
    <add>1.8</add>
  </index>
  <field>
    <name>title</name>
    <title>Price Set Title</title>
    <type>varchar</type>
    <length>255</length>
    <required>true</required>
    <localizable>true</localizable>
    <comment>Displayed title for the Price Set.</comment>
    <add>1.8</add>
    <html>
      <type>Text</type>
    </html>
  </field>
  <field>
    <name>is_active</name>
    <title>Price Set Is Active?</title>
    <type>boolean</type>
    <default>1</default>
    <comment>Is this price set active</comment>
    <add>1.8</add>
    <html>
      <type>CheckBox</type>
    </html>
  </field>
  <field>
    <name>help_pre</name>
    <title>Price Set Pre Help</title>
    <type>text</type>
    <localizable>true</localizable>
    <comment>Description and/or help text to display before fields in form.</comment>
    <html>
      <type>TextArea</type>
      <rows>4</rows>
      <cols>80</cols>
    </html>
    <add>1.8</add>
  </field>
  <field>
    <name>help_post</name>
    <title>Price Set Post Help</title>
    <type>text</type>
    <localizable>true</localizable>
    <comment>Description and/or help text to display after fields in form.</comment>
    <html>
      <type>TextArea</type>
      <rows>4</rows>
      <cols>80</cols>
    </html>
    <add>1.8</add>
  </field>
  <field>
    <name>javascript</name>
    <title>Price Set Javascript</title>
    <type>varchar</type>
    <length>64</length>
    <comment>Optional Javascript script function(s) included on the form with this price_set. Can be used for conditional</comment>
    <add>1.8</add>
    <html>
      <type>Text</type>
    </html>
  </field>
  <field>
    <name>extends</name>
    <title>Price Set Extends</title>
    <type>varchar</type>
    <length>255</length>
    <required>true</required>
    <comment>What components are using this price set?</comment>
    <pseudoconstant>
      <table>civicrm_component</table>
      <keyColumn>id</keyColumn>
      <labelColumn>name</labelColumn>
    </pseudoconstant>
    <add>3.1</add>
    <html>
      <type>Text</type>
    </html>
  </field>
  <field>
    <name>contribution_type_id</name>
    <title>Price Set Contribution Type</title>
    <type>int unsigned</type>
    <default>NULL</default>
    <comment>FK to Contribution Type(for membership price sets only).</comment>
    <add>3.4</add>
    <drop>4.3</drop>
  </field>
  <foreignKey>
    <name>contribution_type_id</name>
    <table>civicrm_contribution_type</table>
    <key>id</key>
    <add>3.4</add>
    <drop>4.3</drop>
    <onDelete>SET NULL</onDelete>
  </foreignKey>
  <field>
    <name>financial_type_id</name>
    <title>Financial Type</title>
    <type>int unsigned</type>
    <default>NULL</default>
    <comment>FK to Financial Type(for membership price sets only).</comment>
    <add>4.3</add>
    <pseudoconstant>
      <table>civicrm_financial_type</table>
      <keyColumn>id</keyColumn>
      <labelColumn>name</labelColumn>
    </pseudoconstant>
    <html>
      <type>Select</type>
    </html>
  </field>
  <foreignKey>
    <name>financial_type_id</name>
    <table>civicrm_financial_type</table>
    <key>id</key>
    <add>4.3</add>
    <onDelete>SET NULL</onDelete>
  </foreignKey>
  <field>
    <name>is_quick_config</name>
    <title>Is Price Set Quick Config?</title>
    <type>boolean</type>
    <default>0</default>
    <comment>Is set if edited on Contribution or Event Page rather than through Manage Price Sets</comment>
    <html>
      <type>CheckBox</type>
    </html>
    <add>4.1</add>
  </field>
  <field>
    <name>is_reserved</name>
    <title>Price Set Is Reserved</title>
    <type>boolean</type>
    <default>0</default>
    <comment>Is this a predefined system price set  (i.e. it can not be deleted, edited)?</comment>
    <add>4.2</add>
    <html>
      <type>CheckBox</type>
    </html>
  </field>
  <field>
    <name>min_amount</name>
    <title>Minimum Amount</title>
    <type>int unsigned</type>
    <default>0</default>
    <comment>Minimum Amount required for this set.</comment>
    <add>4.7</add>
    <html>
      <type>Text</type>
    </html>
  </field>
</table>
Commit	Line	Data
6a488035 TO	1	<?xml version="1.0" encoding="iso-8859-1" ?>
	2
	3	<table>
	4	<base>CRM/Price</base>
9da8dc8c	5	<class>PriceSet</class>
6a488035 TO	6	<name>civicrm_price_set</name>
	7	<add>1.8</add>
	8	<log>true</log>
	9	<field>
	10	<name>id</name>
a0a2c91d	11	<title>Price Set</title>
6a488035 TO	12	<type>int unsigned</type>
	13	<required>true</required>
	14	<comment>Price Set</comment>
	15	<add>1.8</add>
a0a2c91d MWMC	16	<html>
	17	<type>Select</type>
	18	</html>
6a488035 TO	19	</field>
	20	<primaryKey>
	21	<name>id</name>
	22	<autoincrement>true</autoincrement>
	23	</primaryKey>
	24	<field>
	25	<name>domain_id</name>
021ad66c	26	<title>Price Set Domain</title>
6a488035	27	<type>int unsigned</type>
c2b4755a EM	28	<pseudoconstant>
	29	<table>civicrm_domain</table>
	30	<keyColumn>id</keyColumn>
	31	<labelColumn>name</labelColumn>
	32	</pseudoconstant>
6a488035 TO	33	<comment>Which Domain is this price-set for</comment>
6a488035 TO	34	<add>3.1</add>
614d72ec	35	<html>
	36	<type>Text</type>
	37	</html>
6a488035 TO	38	</field>
	39	<foreignKey>
	40	<name>domain_id</name>
	41	<table>civicrm_domain</table>
	42	<key>id</key>
	43	<add>3.1</add>
	44	</foreignKey>
	45	<field>
	46	<name>name</name>
	47	<type>varchar</type>
	48	<length>255</length>
	49	<required>true</required>
	50	<comment>Variable name/programmatic handle for this set of price fields.</comment>
	51	<add>1.8</add>
614d72ec	52	<html>
	53	<type>Text</type>
	54	</html>
6a488035 TO	55	</field>
	56	<index>
	57	<name>UI_name</name>
	58	<fieldName>name</fieldName>
	59	<unique>true</unique>
	60	<add>1.8</add>
	61	</index>
	62	<field>
	63	<name>title</name>
021ad66c	64	<title>Price Set Title</title>
6a488035 TO	65	<type>varchar</type>
	66	<length>255</length>
	67	<required>true</required>
	68	<localizable>true</localizable>
	69	<comment>Displayed title for the Price Set.</comment>
	70	<add>1.8</add>
614d72ec	71	<html>
	72	<type>Text</type>
	73	</html>
6a488035 TO	74	</field>
	75	<field>
	76	<name>is_active</name>
021ad66c	77	<title>Price Set Is Active?</title>
6a488035 TO	78	<type>boolean</type>
	79	<default>1</default>
	80	<comment>Is this price set active</comment>
	81	<add>1.8</add>
614d72ec	82	<html>
	83	<type>CheckBox</type>
	84	</html>
6a488035 TO	85	</field>
	86	<field>
	87	<name>help_pre</name>
021ad66c	88	<title>Price Set Pre Help</title>
6a488035 TO	89	<type>text</type>
	90	<localizable>true</localizable>
	91	<comment>Description and/or help text to display before fields in form.</comment>
7deea513	92	<html>
7deea513	93	<type>TextArea</type>
817807ab	94	<rows>4</rows>
817807ab	95	<cols>80</cols>
7deea513	96	</html>
6a488035 TO	97	<add>1.8</add>
	98	</field>
	99	<field>
	100	<name>help_post</name>
021ad66c	101	<title>Price Set Post Help</title>
6a488035 TO	102	<type>text</type>
	103	<localizable>true</localizable>
	104	<comment>Description and/or help text to display after fields in form.</comment>
7deea513	105	<html>
7deea513	106	<type>TextArea</type>
817807ab	107	<rows>4</rows>
817807ab	108	<cols>80</cols>
7deea513	109	</html>
6a488035 TO	110	<add>1.8</add>
	111	</field>
	112	<field>
	113	<name>javascript</name>
021ad66c	114	<title>Price Set Javascript</title>
6a488035 TO	115	<type>varchar</type>
	116	<length>64</length>
	117	<comment>Optional Javascript script function(s) included on the form with this price_set. Can be used for conditional</comment>
	118	<add>1.8</add>
614d72ec	119	<html>
614d72ec	120	<type>Text</type>
6cc0b7bd	121	</html>
6a488035 TO	122	</field>
	123	<field>
	124	<name>extends</name>
021ad66c	125	<title>Price Set Extends</title>
6a488035 TO	126	<type>varchar</type>
	127	<length>255</length>
	128	<required>true</required>
	129	<comment>What components are using this price set?</comment>
6cc0b7bd EM	130	<pseudoconstant>
	131	<table>civicrm_component</table>
	132	<keyColumn>id</keyColumn>
	133	<labelColumn>name</labelColumn>
	134	</pseudoconstant>
6a488035	135	<add>3.1</add>
614d72ec	136	<html>
	137	<type>Text</type>
	138	</html>
6a488035	139	</field>
6f3f0f22	140	<field>
6f3f0f22	141	<name>contribution_type_id</name>
021ad66c	142	<title>Price Set Contribution Type</title>
6f3f0f22	143	<type>int unsigned</type>
6a488035 TO	144	<default>NULL</default>
6a488035 TO	145	<comment>FK to Contribution Type(for membership price sets only).</comment>
6f3f0f22	146	<add>3.4</add>
	147	<drop>4.3</drop>
	148	</field>
	149	<foreignKey>
	150	<name>contribution_type_id</name>
	151	<table>civicrm_contribution_type</table>
	152	<key>id</key>
	153	<add>3.4</add>
	154	<drop>4.3</drop>
6a488035 TO	155	<onDelete>SET NULL</onDelete>
6a488035 TO	156	</foreignKey>
6f3f0f22	157	<field>
6f3f0f22	158	<name>financial_type_id</name>
6a488035	159	<title>Financial Type</title>
6f3f0f22	160	<type>int unsigned</type>
6a488035 TO	161	<default>NULL</default>
6a488035 TO	162	<comment>FK to Financial Type(for membership price sets only).</comment>
6f3f0f22	163	<add>4.3</add>
6cc0b7bd EM	164	<pseudoconstant>
	165	<table>civicrm_financial_type</table>
	166	<keyColumn>id</keyColumn>
	167	<labelColumn>name</labelColumn>
	168	</pseudoconstant>
614d72ec	169	<html>
	170	<type>Select</type>
	171	</html>
6f3f0f22	172	</field>
	173	<foreignKey>
	174	<name>financial_type_id</name>
	175	<table>civicrm_financial_type</table>
	176	<key>id</key>
	177	<add>4.3</add>
6a488035	178	<onDelete>SET NULL</onDelete>
6f3f0f22	179	</foreignKey>
6a488035 TO	180	<field>
6a488035 TO	181	<name>is_quick_config</name>
021ad66c	182	<title>Is Price Set Quick Config?</title>
6f3f0f22	183	<type>boolean</type>
6a488035 TO	184	<default>0</default>
6a488035 TO	185	<comment>Is set if edited on Contribution or Event Page rather than through Manage Price Sets</comment>
614d72ec	186	<html>
	187	<type>CheckBox</type>
	188	</html>
6a488035 TO	189	<add>4.1</add>
	190	</field>
	191	<field>
	192	<name>is_reserved</name>
021ad66c	193	<title>Price Set Is Reserved</title>
6a488035 TO	194	<type>boolean</type>
	195	<default>0</default>
	196	<comment>Is this a predefined system price set (i.e. it can not be deleted, edited)?</comment>
	197	<add>4.2</add>
614d72ec	198	<html>
	199	<type>CheckBox</type>
	200	</html>
6a488035	201	</field>
601c7a24	202	<field>
	203	<name>min_amount</name>
	204	<title>Minimum Amount</title>
	205	<type>int unsigned</type>
	206	<default>0</default>
	207	<comment>Minimum Amount required for this set.</comment>
	208	<add>4.7</add>
	209	<html>
	210	<type>Text</type>
	211	</html>
	212	</field>
6a488035	213	</table>