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