[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>
  <component>CiviContribute</component>
  <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>
    <html>
      <type>Number</type>
    </html>
  </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>EntityRef</type>
      <label>Contact</label>
    </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>TextArea</type>
      <label>Intro Text</label>
    </html>
  </field>
  <field>
    <name>page_text</name>
    <type>text</type>
    <default>NULL</default>
    <add>2.2</add>
    <html>
      <type>TextArea</type>
      <label>Page Text</label>
    </html>
  </field>
  <field>
    <name>donate_link_text</name>
    <title>Donate Link Text</title>
    <type>varchar</type>
    <length>255</length>
    <default>NULL</default>
    <add>2.2</add>
    <html>
      <type>Text</type>
    </html>
  </field>
  <field>
    <name>page_id</name>
    <title>Contribution Page</title>
    <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>
    <title>PCP Block</title>
    <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>
    <title>Use Thermometer?</title>
    <type>int unsigned</type>
    <default>0</default>
    <html>
      <type>CheckBox</type>
    </html>
    <add>2.2</add>
  </field>
  <field>
    <name>is_honor_roll</name>
    <title>Show Honor Roll?</title>
    <type>int unsigned</type>
    <default>0</default>
    <add>2.2</add>
    <html>
      <type>CheckBox</type>
    </html>
  </field>
  <field>
    <name>goal_amount</name>
    <title>Goal Amount</title>
    <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>
    <title>Currency</title>
    <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>name</nameColumn>
      <abbrColumn>symbol</abbrColumn>
    </pseudoconstant>
    <html>
      <type>Select</type>
    </html>
  </field>
  <field>
    <name>is_active</name>
    <title>Enabled?</title>
    <type>boolean</type>
    <comment>Is Personal Campaign Page enabled/active?</comment>
    <default>1</default>
    <required>true</required>
    <add>2.2</add>
    <html>
      <type>CheckBox</type>
    </html>
  </field>
  <field>
    <name>is_notify</name>
    <title>Notify Owner?</title>
    <type>boolean</type>
    <comment>Notify owner via email when someone donates to page?</comment>
    <default>0</default>
    <required>true</required>
    <add>4.6</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>
d31fb4e3	9	<component>CiviContribute</component>
3c7d2158	10	<field>
e244747c EM	11	<name>id</name>
	12	<uniqueName>pcp_id</uniqueName>
	13	<type>int unsigned</type>
	14	<required>true</required>
	15	<title>Personal Campaign Page ID</title>
	16	<comment>Personal Campaign Page ID</comment>
	17	<add>2.2</add>
0481e12c A	18	<html>
	19	<type>Number</type>
	20	</html>
3c7d2158	21	</field>
3c7d2158	22	<primaryKey>
e244747c EM	23	<name>id</name>
e244747c EM	24	<autoincrement>true</autoincrement>
3c7d2158	25	</primaryKey>
3c7d2158	26	<field>
e244747c EM	27	<name>contact_id</name>
	28	<uniqueName>pcp_contact_id</uniqueName>
	29	<title>Contact ID</title>
	30	<type>int unsigned</type>
	31	<required>true</required>
	32	<comment>FK to Contact ID</comment>
	33	<add>2.2</add>
	34	<html>
916b6181	35	<type>EntityRef</type>
57e94608	36	<label>Contact</label>
e244747c	37	</html>
3c7d2158	38	</field>
3c7d2158	39	<foreignKey>
e244747c EM	40	<name>contact_id</name>
	41	<table>civicrm_contact</table>
	42	<key>id</key>
	43	<add>2.2</add>
	44	<onDelete>CASCADE</onDelete>
3c7d2158	45	</foreignKey>
6a488035	46	<field>
e244747c EM	47	<name>status_id</name>
	48	<title>Personal Campaign Page Status</title>
	49	<required>true</required>
	50	<type>int unsigned</type>
	51	<add>2.2</add>
	52	<pseudoconstant>
	53	<optionGroupName>pcp_status</optionGroupName>
	54	</pseudoconstant>
	55	<html>
	56	<type>Select</type>
	57	</html>
	58	</field>
	59	<field>
	60	<name>title</name>
	61	<title>Personal Campaign Page Title</title>
	62	<type>varchar</type>
	63	<length>255</length>
	64	<default>NULL</default>
	65	<add>2.2</add>
	66	<html>
	67	<type>Text</type>
	68	</html>
	69	</field>
	70	<field>
	71	<name>intro_text</name>
	72	<type>text</type>
	73	<default>NULL</default>
	74	<add>2.2</add>
	75	<html>
d993a2ca	76	<type>TextArea</type>
fd735f54	77	<label>Intro Text</label>
e244747c EM	78	</html>
	79	</field>
	80	<field>
	81	<name>page_text</name>
	82	<type>text</type>
	83	<default>NULL</default>
	84	<add>2.2</add>
	85	<html>
d993a2ca	86	<type>TextArea</type>
fd735f54	87	<label>Page Text</label>
e244747c EM	88	</html>
	89	</field>
	90	<field>
	91	<name>donate_link_text</name>
f3ea5182	92	<title>Donate Link Text</title>
e244747c EM	93	<type>varchar</type>
	94	<length>255</length>
	95	<default>NULL</default>
	96	<add>2.2</add>
	97	<html>
	98	<type>Text</type>
	99	</html>
	100	</field>
3c7d2158	101	<field>
e244747c	102	<name>page_id</name>
f3ea5182	103	<title>Contribution Page</title>
e244747c EM	104	<type>int unsigned</type>
	105	<required>true</required>
	106	<comment>The Contribution or Event Page which triggered this pcp</comment>
	107	<add>4.1</add>
	108	</field>
	109	<field>
	110	<name>page_type</name>
	111	<title>PCP Page Type</title>
	112	<comment>The type of PCP this is: contribute or event</comment>
	113	<type>varchar</type>
	114	<length>64</length>
	115	<default>'contribute'</default>
	116	<html>
	117	<type>Select</type>
	118	</html>
	119	<add>2.2</add>
	120	</field>
	121	<field>
	122	<name>pcp_block_id</name>
f3ea5182	123	<title>PCP Block</title>
e244747c EM	124	<comment>The pcp block that this pcp page was created from</comment>
	125	<type>int unsigned</type>
	126	<required>true</required>
	127	<add>4.1</add>
	128	</field>
	129	<field>
	130	<name>is_thermometer</name>
f3ea5182	131	<title>Use Thermometer?</title>
e244747c EM	132	<type>int unsigned</type>
	133	<default>0</default>
	134	<html>
	135	<type>CheckBox</type>
	136	</html>
	137	<add>2.2</add>
	138	</field>
	139	<field>
	140	<name>is_honor_roll</name>
f3ea5182	141	<title>Show Honor Roll?</title>
e244747c EM	142	<type>int unsigned</type>
	143	<default>0</default>
	144	<add>2.2</add>
	145	<html>
	146	<type>CheckBox</type>
	147	</html>
	148	</field>
	149	<field>
	150	<name>goal_amount</name>
f3ea5182	151	<title>Goal Amount</title>
e244747c EM	152	<type>decimal</type>
	153	<comment>Goal amount of this Personal Campaign Page.</comment>
	154	<add>2.2</add>
	155	<html>
	156	<type>Text</type>
	157	</html>
	158	</field>
	159	<field>
	160	<name>currency</name>
f3ea5182	161	<title>Currency</title>
e244747c EM	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>
	167	<pseudoconstant>
	168	<table>civicrm_currency</table>
	169	<keyColumn>name</keyColumn>
	170	<labelColumn>full_name</labelColumn>
c3de5c5a	171	<nameColumn>name</nameColumn>
a8fdb24e	172	<abbrColumn>symbol</abbrColumn>
e244747c EM	173	</pseudoconstant>
	174	<html>
	175	<type>Select</type>
	176	</html>
	177	</field>
e244747c EM	178	<field>
e244747c EM	179	<name>is_active</name>
f3ea5182	180	<title>Enabled?</title>
e244747c EM	181	<type>boolean</type>
e244747c EM	182	<comment>Is Personal Campaign Page enabled/active?</comment>
c1e814c7 MD	183	<default>1</default>
c1e814c7 MD	184	<required>true</required>
e244747c EM	185	<add>2.2</add>
	186	<html>
	187	<type>CheckBox</type>
	188	</html>
6a488035	189	</field>
12f92dbd N	190	<field>
12f92dbd N	191	<name>is_notify</name>
f3ea5182	192	<title>Notify Owner?</title>
12f92dbd N	193	<type>boolean</type>
	194	<comment>Notify owner via email when someone donates to page?</comment>
	195	<default>0</default>
c1e814c7	196	<required>true</required>
12f92dbd N	197	<add>4.6</add>
	198	<html>
	199	<type>CheckBox</type>
	200	</html>
	201	</field>
6a488035	202	</table>