<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>
+ <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>
+ <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>
+ <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>
+ <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>
+ <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>
+ <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>
+ <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>
+ <field>
+ <name>is_notify</name>
+ <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>