[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>
    <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>
    <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>
	105	<type>Text</type>
	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>
	114	<add>3.1</add>
614d72ec	115	<html>
	116	<type>Text</type>
	117	</html>
6a488035	118	</field>
6f3f0f22	119	<field>
	120	<name>contribution_type_id</name>
	121	<type>int unsigned</type>
6a488035 TO	122	<default>NULL</default>
6a488035 TO	123	<comment>FK to Contribution Type(for membership price sets only).</comment>
6f3f0f22	124	<add>3.4</add>
	125	<drop>4.3</drop>
	126	</field>
	127	<foreignKey>
	128	<name>contribution_type_id</name>
	129	<table>civicrm_contribution_type</table>
	130	<key>id</key>
	131	<add>3.4</add>
	132	<drop>4.3</drop>
6a488035 TO	133	<onDelete>SET NULL</onDelete>
6a488035 TO	134	</foreignKey>
6f3f0f22	135	<field>
6f3f0f22	136	<name>financial_type_id</name>
6a488035	137	<title>Financial Type</title>
6f3f0f22	138	<type>int unsigned</type>
6a488035 TO	139	<default>NULL</default>
6a488035 TO	140	<comment>FK to Financial Type(for membership price sets only).</comment>
6f3f0f22	141	<add>4.3</add>
614d72ec	142	<html>
	143	<type>Select</type>
	144	</html>
6f3f0f22	145	</field>
	146	<foreignKey>
	147	<name>financial_type_id</name>
	148	<table>civicrm_financial_type</table>
	149	<key>id</key>
	150	<add>4.3</add>
6a488035	151	<onDelete>SET NULL</onDelete>
6f3f0f22	152	</foreignKey>
6a488035 TO	153	<field>
6a488035 TO	154	<name>is_quick_config</name>
6f3f0f22	155	<type>boolean</type>
6a488035 TO	156	<default>0</default>
6a488035 TO	157	<comment>Is set if edited on Contribution or Event Page rather than through Manage Price Sets</comment>
614d72ec	158	<html>
	159	<type>CheckBox</type>
	160	</html>
6a488035 TO	161	<add>4.1</add>
	162	</field>
	163	<field>
	164	<name>is_reserved</name>
	165	<type>boolean</type>
	166	<default>0</default>
	167	<comment>Is this a predefined system price set (i.e. it can not be deleted, edited)?</comment>
	168	<add>4.2</add>
614d72ec	169	<html>
	170	<type>CheckBox</type>
	171	</html>
6a488035 TO	172	</field>
6a488035 TO	173	</table>