Import from SVN (r45945, r596)

[civicrm-core.git] / xml / schema / PCP / PCPBlock.xml

<?xml version="1.0" encoding="iso-8859-1" ?>

<table>
  <base>CRM/PCP</base>
  <class>PCPBlock</class>
  <name>civicrm_pcp_block</name>
  <comment>A Personal Campaign Page Block stores admin configurable status options and rules</comment>
  <add>2.2</add>
  <log>true</log>
  <field>
      <name>id</name>
      <type>int unsigned</type>
      <required>true</required>
      <comment>PCP block Id</comment>
      <add>2.2</add>
  </field>
  <primaryKey>
       <name>id</name>
       <autoincrement>true</autoincrement>
  </primaryKey>
  <field>
       <name>entity_table</name>
       <type>varchar</type>
       <length>64</length>
       <add>2.2</add>
  </field>
  <field>
      <name>entity_id</name>
      <type>int unsigned</type>
      <required>true</required>
      <comment>FK to civicrm_contribution_page.id OR civicrm_event.id</comment>
      <add>2.2</add>
  </field>
  <foreignKey> 
      <name>entity_id</name> 
      <table>civicrm_contribution_page</table> 
      <key>id</key>
      <add>2.2</add>
      <drop>4.1</drop>
  </foreignKey>
  <field>
      <name>target_entity_type</name>
      <type>varchar</type>
      <length>255</length>
      <required>true</required>
      <default>'contribute'</default>
      <comment>The type of entity that this pcp targets</comment>
      <add>4.1</add>
  </field>
  <field>
      <name>target_entity_id</name>
      <type>int unsigned</type>
      <required>true</required>
      <comment>The entity that this pcp targets</comment>
      <add>4.1</add>
  </field>
  <field>  
      <name>supporter_profile_id</name>  
      <type>int unsigned</type>                  
      <comment>FK to civicrm_uf_group.id. Does Personal Campaign Page require manual activation by administrator? (is inactive by default after setup)?</comment>
      <default>NULL</default>
      <add>2.2</add>  
  </field>
  <foreignKey> 
      <name>supporter_profile_id</name> 
      <table>civicrm_uf_group</table> 
      <key>id</key>
      <add>3.1</add>
      <onDelete>SET NULL</onDelete>
  </foreignKey>
  <field>  
      <name>is_approval_needed</name>  
      <type>boolean</type>                  
      <comment>Does Personal Campaign Page require manual activation by administrator? (is inactive by default after setup)?</comment>  
      <default>NULL</default>
      <add>2.2</add>  
  </field>
  <field>  
      <name>is_tellfriend_enabled</name>  
      <type>boolean</type>                  
      <comment>Does Personal Campaign Page allow using tell a friend?</comment>  
      <default>NULL</default>
      <add>2.2</add>  
  </field>
  <field>    
      <name>tellfriend_limit</name> 
      <type>int unsigned</type> 
      <default>NULL</default>
      <comment>Maximum recipient fields allowed in tell a friend</comment> 
      <add>2.2</add> 
  </field>
  <field>
       <name>link_text</name>
       <type>varchar</type>
       <length>255</length>
       <default>NULL</default>
       <localizable>true</localizable>
       <comment>Link text for PCP.</comment>
       <add>2.2</add>
  </field> 
  <field>  
      <name>is_active</name>  
      <type>boolean</type>                  
      <comment>Is Personal Campaign Page Block enabled/active?</comment>  
      <default>1</default>
      <add>2.2</add>  
  </field>
  <field>  
      <name>notify_email</name>  
      <type>varchar</type>
      <length>255</length>            
      <comment>If set, notification is automatically emailed to this email-address on create/update Personal Campaign Page</comment>
      <default>NULL</default>
      <add>2.2</add>  
  </field>
</table>