[civicrm-core.git] / xml / schema / PCP / PCP.xml

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

<table>
  <base>CRM/PCP</base>
  <class>PCP</class>
  <name>civicrm_pcp</name>
  <add>2.2</add>
  <log>true</log>
  <field>
      <name>id</name>
      <uniqueName>pcp_id</uniqueName>
      <type>int unsigned</type>
      <required>true</required>
      <title>Personal Campaign Page ID</title>
      <comment>Personal Campaign Page ID</comment>
      <add>2.2</add>
  </field>
  <primaryKey>
       <name>id</name>
       <autoincrement>true</autoincrement>
  </primaryKey>
  <field>
      <name>contact_id</name>
      <uniqueName>pcp_contact_id</uniqueName>
      <title>Contact ID</title>
      <type>int unsigned</type>
      <required>true</required>
      <comment>FK to Contact ID</comment>
      <add>2.2</add>
      <html>
       <type>Autocomplete-Select</type>
     </html>
  </field>
  <foreignKey>
       <name>contact_id</name>
       <table>civicrm_contact</table>
       <key>id</key>
       <add>2.2</add>
       <onDelete>CASCADE</onDelete>
  </foreignKey>
  <field>
      <name>status_id</name>
      <title>Personal Campaign Page Status</title>
      <required>true</required>
      <type>int unsigned</type>
      <add>2.2</add>
      <pseudoconstant>
        <optionGroupName>pcp_status</optionGroupName>
      </pseudoconstant>
      <html>
        <type>Select</type>
      </html>
  </field>
  <field>
      <name>title</name>
      <title>Personal Campaign Page Title</title>
      <type>varchar</type>
      <length>255</length>
      <default>NULL</default>
      <add>2.2</add>
      <html>
         <type>Text</type>
       </html>
  </field>
  <field>
      <name>intro_text</name>
      <type>text</type>
      <default>NULL</default>
      <add>2.2</add>
      <html>
        <type>TexArea</type>
      </html>
  </field>
  <field>
      <name>page_text</name>
      <type>text</type>
      <default>NULL</default>
      <add>2.2</add>
      <html>
        <type>TexArea</type>
      </html>
  </field>
  <field>
      <name>donate_link_text</name>
      <type>varchar</type>
      <length>255</length>
      <default>NULL</default>
      <add>2.2</add>
      <html>
        <type>Text</type>
      </html>
  </field>
  <field>
      <name>contribution_page_id</name>
      <type>int unsigned</type>
      <required>true</required>
      <comment>The Contribution Page which triggered this pcp</comment>
      <add>2.2</add>
      <drop>4.1</drop>
  </field>
  <foreignKey>
      <name>contribution_page_id</name>
      <table>civicrm_contribution_page</table>
      <key>id</key>
      <drop>4.1</drop>
  </foreignKey>
  <field>
      <name>page_id</name>
      <type>int unsigned</type>
      <required>true</required>
      <comment>The Contribution or Event Page which triggered this pcp</comment>
      <add>4.1</add>
  </field>
  <field>
      <name>page_type</name>
      <title>PCP Page Type</title>
      <comment>The type of PCP this is: contribute or event</comment>
      <type>varchar</type>
      <length>64</length>
      <default>'contribute'</default>
      <html>
          <type>Select</type>
       </html>
      <add>2.2</add>
  </field>
  <field>
      <name>pcp_block_id</name>
      <comment>The pcp block that this pcp page was created from</comment>
      <type>int unsigned</type>
      <required>true</required>
      <add>4.1</add>
  </field>
  <field>
      <name>is_thermometer</name>
      <type>int unsigned</type>
      <default>0</default>
      <html>
         <type>CheckBox</type>
       </html>
      <add>2.2</add>
  </field>
  <field>
      <name>is_honor_roll</name>
      <type>int unsigned</type>
      <default>0</default>
      <add>2.2</add>
      <html>
         <type>CheckBox</type>
       </html>
  </field>
  <field>
      <name>goal_amount</name>
      <type>decimal</type>
      <comment>Goal amount of this Personal Campaign Page.</comment>
      <add>2.2</add>
      <html>
         <type>Text</type>
       </html>
  </field>
  <field>
      <name>currency</name>
      <type>varchar</type>
      <length>3</length>
      <default>NULL</default>
      <comment>3 character string, value from config setting or input via user.</comment>
      <add>3.2</add>
      <pseudoconstant>
        <table>civicrm_currency</table>
        <keyColumn>name</keyColumn>
        <labelColumn>full_name</labelColumn>
        <nameColumn>numeric_code</nameColumn>
      </pseudoconstant>
      <html>
        <type>Select</type>
      </html>
  </field>
  <field>
      <name>referer</name>
      <type>varchar</type>
      <length>255</length>
      <default>NULL</default>
      <add>2.2</add>
      <drop>4.1</drop>
  </field>
  <field>
      <name>is_active</name>
      <type>boolean</type>
      <comment>Is Personal Campaign Page enabled/active?</comment>
      <default>0</default>
      <add>2.2</add>
      <html>
         <type>CheckBox</type>
       </html>
  </field>
</table>
Commit	Line	Data
3c7d2158	1	<?xml version="1.0" encoding="iso-8859-1" ?>
	2
	3	<table>
	4	<base>CRM/PCP</base>
	5	<class>PCP</class>
	6	<name>civicrm_pcp</name>
	7	<add>2.2</add>
6a488035	8	<log>true</log>
3c7d2158	9	<field>
3c7d2158	10	<name>id</name>
6a488035	11	<uniqueName>pcp_id</uniqueName>
3c7d2158	12	<type>int unsigned</type>
6a488035 TO	13	<required>true</required>
6a488035 TO	14	<title>Personal Campaign Page ID</title>
3c7d2158	15	<comment>Personal Campaign Page ID</comment>
	16	<add>2.2</add>
	17	</field>
	18	<primaryKey>
	19	<name>id</name>
	20	<autoincrement>true</autoincrement>
	21	</primaryKey>
	22	<field>
	23	<name>contact_id</name>
6a488035 TO	24	<uniqueName>pcp_contact_id</uniqueName>
6a488035 TO	25	<title>Contact ID</title>
3c7d2158	26	<type>int unsigned</type>
	27	<required>true</required>
	28	<comment>FK to Contact ID</comment>
	29	<add>2.2</add>
614d72ec	30	<html>
	31	<type>Autocomplete-Select</type>
	32	</html>
3c7d2158	33	</field>
	34	<foreignKey>
	35	<name>contact_id</name>
	36	<table>civicrm_contact</table>
	37	<key>id</key>
	38	<add>2.2</add>
6a488035	39	<onDelete>CASCADE</onDelete>
3c7d2158	40	</foreignKey>
6a488035 TO	41	<field>
	42	<name>status_id</name>
	43	<title>Personal Campaign Page Status</title>
	44	<required>true</required>
	45	<type>int unsigned</type>
	46	<add>2.2</add>
2158332a CW	47	<pseudoconstant>
	48	<optionGroupName>pcp_status</optionGroupName>
	49	</pseudoconstant>
614d72ec	50	<html>
e0991796	51	<type>Select</type>
614d72ec	52	</html>
6a488035	53	</field>
3c7d2158	54	<field>
6a488035 TO	55	<name>title</name>
6a488035 TO	56	<title>Personal Campaign Page Title</title>
3c7d2158	57	<type>varchar</type>
6a488035 TO	58	<length>255</length>
6a488035 TO	59	<default>NULL</default>
3c7d2158	60	<add>2.2</add>
614d72ec	61	<html>
	62	<type>Text</type>
	63	</html>
3c7d2158	64	</field>
	65	<field>
	66	<name>intro_text</name>
	67	<type>text</type>
6a488035	68	<default>NULL</default>
3c7d2158	69	<add>2.2</add>
614d72ec	70	<html>
	71	<type>TexArea</type>
	72	</html>
3c7d2158	73	</field>
	74	<field>
	75	<name>page_text</name>
	76	<type>text</type>
6a488035	77	<default>NULL</default>
3c7d2158	78	<add>2.2</add>
614d72ec	79	<html>
	80	<type>TexArea</type>
	81	</html>
3c7d2158	82	</field>
3c7d2158	83	<field>
6a488035	84	<name>donate_link_text</name>
3c7d2158	85	<type>varchar</type>
6a488035 TO	86	<length>255</length>
6a488035 TO	87	<default>NULL</default>
3c7d2158	88	<add>2.2</add>
614d72ec	89	<html>
	90	<type>Text</type>
	91	</html>
6a488035	92	</field>
3c7d2158	93	<field>
3c7d2158	94	<name>contribution_page_id</name>
6a488035 TO	95	<type>int unsigned</type>
6a488035 TO	96	<required>true</required>
3c7d2158	97	<comment>The Contribution Page which triggered this pcp</comment>
3c7d2158	98	<add>2.2</add>
6a488035	99	<drop>4.1</drop>
3c7d2158	100	</field>
	101	<foreignKey>
	102	<name>contribution_page_id</name>
	103	<table>civicrm_contribution_page</table>
	104	<key>id</key>
6a488035 TO	105	<drop>4.1</drop>
6a488035 TO	106	</foreignKey>
3c7d2158	107	<field>
3c7d2158	108	<name>page_id</name>
6a488035 TO	109	<type>int unsigned</type>
6a488035 TO	110	<required>true</required>
3c7d2158	111	<comment>The Contribution or Event Page which triggered this pcp</comment>
6a488035	112	<add>4.1</add>
3c7d2158	113	</field>
3c7d2158	114	<field>
6a488035 TO	115	<name>page_type</name>
	116	<title>PCP Page Type</title>
	117	<comment>The type of PCP this is: contribute or event</comment>
3c7d2158	118	<type>varchar</type>
6a488035 TO	119	<length>64</length>
6a488035 TO	120	<default>'contribute'</default>
614d72ec	121	<html>
	122	<type>Select</type>
	123	</html>
2158332a	124	<add>2.2</add>
3c7d2158	125	</field>
3c7d2158	126	<field>
6a488035 TO	127	<name>pcp_block_id</name>
6a488035 TO	128	<comment>The pcp block that this pcp page was created from</comment>
3c7d2158	129	<type>int unsigned</type>
6a488035	130	<required>true</required>
3c7d2158	131	<add>4.1</add>
	132	</field>
	133	<field>
	134	<name>is_thermometer</name>
	135	<type>int unsigned</type>
6a488035	136	<default>0</default>
614d72ec	137	<html>
	138	<type>CheckBox</type>
	139	</html>
3c7d2158	140	<add>2.2</add>
	141	</field>
	142	<field>
	143	<name>is_honor_roll</name>
	144	<type>int unsigned</type>
6a488035	145	<default>0</default>
3c7d2158	146	<add>2.2</add>
614d72ec	147	<html>
	148	<type>CheckBox</type>
	149	</html>
3c7d2158	150	</field>
	151	<field>
	152	<name>goal_amount</name>
	153	<type>decimal</type>
	154	<comment>Goal amount of this Personal Campaign Page.</comment>
	155	<add>2.2</add>
614d72ec	156	<html>
	157	<type>Text</type>
	158	</html>
3c7d2158	159	</field>
6a488035 TO	160	<field>
	161	<name>currency</name>
	162	<type>varchar</type>
	163	<length>3</length>
	164	<default>NULL</default>
	165	<comment>3 character string, value from config setting or input via user.</comment>
	166	<add>3.2</add>
bd44e0df AS	167	<pseudoconstant>
	168	<table>civicrm_currency</table>
	169	<keyColumn>name</keyColumn>
a38a89fc CW	170	<labelColumn>full_name</labelColumn>
a38a89fc CW	171	<nameColumn>numeric_code</nameColumn>
bd44e0df	172	</pseudoconstant>
614d72ec	173	<html>
e0991796	174	<type>Select</type>
614d72ec	175	</html>
6a488035	176	</field>
3c7d2158	177	<field>
6a488035	178	<name>referer</name>
3c7d2158	179	<type>varchar</type>
6a488035 TO	180	<length>255</length>
6a488035 TO	181	<default>NULL</default>
3c7d2158	182	<add>2.2</add>
6a488035 TO	183	<drop>4.1</drop>
6a488035 TO	184	</field>
3c7d2158	185	<field>
	186	<name>is_active</name>
	187	<type>boolean</type>
	188	<comment>Is Personal Campaign Page enabled/active?</comment>
6a488035	189	<default>0</default>
3c7d2158	190	<add>2.2</add>
614d72ec	191	<html>
	192	<type>CheckBox</type>
	193	</html>
6a488035 TO	194	</field>
6a488035 TO	195	</table>