Merge remote-tracking branch 'upstream/4.5' into 4.5-4.6-2015-03-23-18-42-19
[civicrm-core.git] / xml / schema / PCP / PCPBlock.xml
index 116a0b0574cb76a1e013ea65bd06446b09a9d4be..5d4a1af4f75f8a3f2ef20cb1c3616933d9250848 100644 (file)
   <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>
+    <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>
+    <name>id</name>
+    <autoincrement>true</autoincrement>
   </primaryKey>
   <field>
-       <name>entity_table</name>
-       <type>varchar</type>
-       <length>64</length>
-       <add>2.2</add>
+    <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>
+    <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>
   <dynamicForeignKey>
-      <idColumn>entity_id</idColumn>
-      <typeColumn>entity_table</typeColumn>
-      <add>2.2</add>
+    <idColumn>entity_id</idColumn>
+    <typeColumn>entity_table</typeColumn>
+    <add>2.2</add>
   </dynamicForeignKey>
   <foreignKey>
-      <name>entity_id</name>
-      <table>civicrm_contribution_page</table>
-      <key>id</key>
-      <add>2.2</add>
-      <drop>4.1</drop>
+    <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>
+    <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>
+    <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>
   <dynamicForeignKey>
-      <idColumn>target_entity_id</idColumn>
-      <!-- FIXME: typename and not tablename? -->
-      <typeColumn>target_entity_type</typeColumn>
-      <add>4.1</add>
+    <idColumn>target_entity_id</idColumn>
+    <!-- FIXME: typename and not tablename? -->
+    <typeColumn>target_entity_type</typeColumn>
+    <add>4.1</add>
   </dynamicForeignKey>
   <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>
+    <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>
+    <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>
+    <name>owner_notify_id</name>
+    <title>Owner Notification</title>
+    <type>int unsigned</type>
+    <default>0</default>
+    <comment>FK to civicrm_option_group with name = PCP owner notifications</comment>
+    <add>4.6</add>
+    <pseudoconstant>
+      <optionGroupName>pcp_owner_notify</optionGroupName>
+    </pseudoconstant>
+    <html>
+      <type>Radio</type>
+    </html>
   </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>
+    <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>tellfriend_limit</name>
-      <type>int unsigned</type>
-      <default>NULL</default>
-      <comment>Maximum recipient fields allowed in tell a friend</comment>
-      <add>2.2</add>
+    <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>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>
+    <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>is_active</name>
-      <type>boolean</type>
-      <comment>Is Personal Campaign Page Block enabled/active?</comment>
-      <default>1</default>
-      <add>2.2</add>
+    <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>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>
+    <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>