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