xml/schema/PCP/PCP.xml

   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>
   8   <log>true</log>
   9   <field>
  10       <name>id</name>
  11       <uniqueName>pcp_id</uniqueName>
  12       <type>int unsigned</type>
  13       <required>true</required>
  14       <title>Personal Campaign Page ID</title>
  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>
  24       <uniqueName>pcp_contact_id</uniqueName>
  25       <title>Contact ID</title>
  26       <type>int unsigned</type>
  27       <required>true</required>
  28       <comment>FK to Contact ID</comment>
  29       <add>2.2</add>
  30   </field>
  31   <foreignKey>
  32        <name>contact_id</name>
  33        <table>civicrm_contact</table>
  34        <key>id</key>
  35        <add>2.2</add>
  36        <onDelete>CASCADE</onDelete>
  37   </foreignKey>
  38   <field>
  39       <name>status_id</name>
  40       <title>Personal Campaign Page Status</title>
  41       <required>true</required>
  42       <type>int unsigned</type>
  43       <add>2.2</add>
  44       <pseudoconstant>
  45         <optionGroupName>pcp_status</optionGroupName>
  46       </pseudoconstant>
  47   </field>
  48   <field>
  49       <name>title</name>
  50       <title>Personal Campaign Page Title</title>
  51       <type>varchar</type>
  52       <length>255</length>
  53       <default>NULL</default>
  54       <add>2.2</add>
  55   </field>
  56   <field>
  57       <name>intro_text</name>
  58       <type>text</type>
  59       <default>NULL</default>
  60       <add>2.2</add>
  61   </field>
  62   <field>
  63       <name>page_text</name>
  64       <type>text</type>
  65       <default>NULL</default>
  66       <add>2.2</add>
  67   </field>
  68   <field>
  69       <name>donate_link_text</name>
  70       <type>varchar</type>
  71       <length>255</length>
  72       <default>NULL</default>
  73       <add>2.2</add>
  74   </field>
  75   <field>
  76       <name>contribution_page_id</name>
  77       <type>int unsigned</type>
  78       <required>true</required>
  79       <comment>The Contribution Page which triggered this pcp</comment>
  80       <add>2.2</add>
  81       <drop>4.1</drop>
  82   </field>
  83   <foreignKey>
  84       <name>contribution_page_id</name>
  85       <table>civicrm_contribution_page</table>
  86       <key>id</key>
  87       <drop>4.1</drop>
  88   </foreignKey>
  89   <field>
  90       <name>page_id</name>
  91       <type>int unsigned</type>
  92       <required>true</required>
  93       <comment>The Contribution or Event Page which triggered this pcp</comment>
  94       <add>4.1</add>
  95   </field>
  96   <field>
  97       <name>page_type</name>
  98       <title>PCP Page Type</title>
  99       <comment>The type of PCP this is: contribute or event</comment>
 100       <type>varchar</type>
 101       <length>64</length>
 102       <default>'contribute'</default>
 103       <add>2.2</add>
 104   </field>
 105   <field>
 106       <name>pcp_block_id</name>
 107       <comment>The pcp block that this pcp page was created from</comment>
 108       <type>int unsigned</type>
 109       <required>true</required>
 110       <add>4.1</add>
 111   </field>
 112   <field>
 113       <name>is_thermometer</name>
 114       <type>int unsigned</type>
 115       <default>0</default>
 116       <add>2.2</add>
 117   </field>
 118   <field>
 119       <name>is_honor_roll</name>
 120       <type>int unsigned</type>
 121       <default>0</default>
 122       <add>2.2</add>
 123   </field>
 124   <field>
 125       <name>goal_amount</name>
 126       <type>decimal</type>
 127       <comment>Goal amount of this Personal Campaign Page.</comment>
 128       <add>2.2</add>
 129   </field>
 130   <field>
 131       <name>currency</name>
 132       <type>varchar</type>
 133       <length>3</length>
 134       <default>NULL</default>
 135       <comment>3 character string, value from config setting or input via user.</comment>
 136       <add>3.2</add>
 137       <pseudoconstant>
 138         <table>civicrm_currency</table>
 139         <keyColumn>name</keyColumn>
 140         <labelColumn>full_name</labelColumn>
 141         <nameColumn>numeric_code</nameColumn>
 142       </pseudoconstant>
 143   </field>
 144   <field>
 145       <name>referer</name>
 146       <type>varchar</type>
 147       <length>255</length>
 148       <default>NULL</default>
 149       <add>2.2</add>
 150       <drop>4.1</drop>
 151   </field>
 152   <field>
 153       <name>is_active</name>
 154       <type>boolean</type>
 155       <comment>Is Personal Campaign Page enabled/active?</comment>
 156       <default>0</default>
 157       <add>2.2</add>
 158   </field>
 159 </table>