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