[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>
    </html>
  </field>
  <field>
    <name>page_text</name>
    <type>text</type>
    <default>NULL</default>
    <add>2.2</add>
    <html>
      <type>TextArea</type>
    </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>0</default>
    <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>
    <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>
e244747c EM	77	</html>
	78	</field>
	79	<field>
	80	<name>page_text</name>
	81	<type>text</type>
	82	<default>NULL</default>
	83	<add>2.2</add>
	84	<html>
d993a2ca	85	<type>TextArea</type>
e244747c EM	86	</html>
	87	</field>
	88	<field>
	89	<name>donate_link_text</name>
f3ea5182	90	<title>Donate Link Text</title>
e244747c EM	91	<type>varchar</type>
	92	<length>255</length>
	93	<default>NULL</default>
	94	<add>2.2</add>
	95	<html>
	96	<type>Text</type>
	97	</html>
	98	</field>
3c7d2158	99	<field>
e244747c	100	<name>page_id</name>
f3ea5182	101	<title>Contribution Page</title>
e244747c EM	102	<type>int unsigned</type>
	103	<required>true</required>
	104	<comment>The Contribution or Event Page which triggered this pcp</comment>
	105	<add>4.1</add>
	106	</field>
	107	<field>
	108	<name>page_type</name>
	109	<title>PCP Page Type</title>
	110	<comment>The type of PCP this is: contribute or event</comment>
	111	<type>varchar</type>
	112	<length>64</length>
	113	<default>'contribute'</default>
	114	<html>
	115	<type>Select</type>
	116	</html>
	117	<add>2.2</add>
	118	</field>
	119	<field>
	120	<name>pcp_block_id</name>
f3ea5182	121	<title>PCP Block</title>
e244747c EM	122	<comment>The pcp block that this pcp page was created from</comment>
	123	<type>int unsigned</type>
	124	<required>true</required>
	125	<add>4.1</add>
	126	</field>
	127	<field>
	128	<name>is_thermometer</name>
f3ea5182	129	<title>Use Thermometer?</title>
e244747c EM	130	<type>int unsigned</type>
	131	<default>0</default>
	132	<html>
	133	<type>CheckBox</type>
	134	</html>
	135	<add>2.2</add>
	136	</field>
	137	<field>
	138	<name>is_honor_roll</name>
f3ea5182	139	<title>Show Honor Roll?</title>
e244747c EM	140	<type>int unsigned</type>
	141	<default>0</default>
	142	<add>2.2</add>
	143	<html>
	144	<type>CheckBox</type>
	145	</html>
	146	</field>
	147	<field>
	148	<name>goal_amount</name>
f3ea5182	149	<title>Goal Amount</title>
e244747c EM	150	<type>decimal</type>
	151	<comment>Goal amount of this Personal Campaign Page.</comment>
	152	<add>2.2</add>
	153	<html>
	154	<type>Text</type>
	155	</html>
	156	</field>
	157	<field>
	158	<name>currency</name>
f3ea5182	159	<title>Currency</title>
e244747c EM	160	<type>varchar</type>
	161	<length>3</length>
	162	<default>NULL</default>
	163	<comment>3 character string, value from config setting or input via user.</comment>
	164	<add>3.2</add>
	165	<pseudoconstant>
	166	<table>civicrm_currency</table>
	167	<keyColumn>name</keyColumn>
	168	<labelColumn>full_name</labelColumn>
c3de5c5a	169	<nameColumn>name</nameColumn>
a8fdb24e	170	<abbrColumn>symbol</abbrColumn>
e244747c EM	171	</pseudoconstant>
	172	<html>
	173	<type>Select</type>
	174	</html>
	175	</field>
e244747c EM	176	<field>
e244747c EM	177	<name>is_active</name>
f3ea5182	178	<title>Enabled?</title>
e244747c EM	179	<type>boolean</type>
	180	<comment>Is Personal Campaign Page enabled/active?</comment>
	181	<default>0</default>
	182	<add>2.2</add>
	183	<html>
	184	<type>CheckBox</type>
	185	</html>
6a488035	186	</field>
12f92dbd N	187	<field>
12f92dbd N	188	<name>is_notify</name>
f3ea5182	189	<title>Notify Owner?</title>
12f92dbd N	190	<type>boolean</type>
	191	<comment>Notify owner via email when someone donates to page?</comment>
	192	<default>0</default>
	193	<add>4.6</add>
	194	<html>
	195	<type>CheckBox</type>
	196	</html>
	197	</field>
6a488035	198	</table>