CRM-15168 stdise whitespace across schema xml to make editing easier
[civicrm-core.git] / xml / schema / Contribute / ContributionSoft.xml
index 46590049957a7a98df2c592997dd24b4ea5149ad..6aecf0204801e2f15f17f70ea9f5809203c4b946 100644 (file)
   <add>2.2</add>
   <log>true</log>
   <field>
-      <name>id</name>
-      <uniqueName>contribution_soft_id</uniqueName>
-      <type>int unsigned</type>
-      <required>true</required>
-      <import>true</import>
-      <title>Soft Contribution ID</title>
-      <comment>Soft Contribution ID</comment>
-      <add>2.2</add>
+    <name>id</name>
+    <uniqueName>contribution_soft_id</uniqueName>
+    <type>int unsigned</type>
+    <required>true</required>
+    <import>true</import>
+    <title>Soft Contribution ID</title>
+    <comment>Soft Contribution ID</comment>
+    <add>2.2</add>
   </field>
   <primaryKey>
-       <name>id</name>
-       <autoincrement>true</autoincrement>
+    <name>id</name>
+    <autoincrement>true</autoincrement>
   </primaryKey>
   <field>
-      <name>contribution_id</name>
-      <type>int unsigned</type>
-      <required>true</required>
-      <comment>FK to contribution table.</comment>
-      <add>2.2</add>
+    <name>contribution_id</name>
+    <type>int unsigned</type>
+    <required>true</required>
+    <comment>FK to contribution table.</comment>
+    <add>2.2</add>
   </field>
   <foreignKey>
-       <name>contribution_id</name>
-       <table>civicrm_contribution</table>
-       <key>id</key>
-       <add>2.2</add>
-       <onDelete>CASCADE</onDelete>
+    <name>contribution_id</name>
+    <table>civicrm_contribution</table>
+    <key>id</key>
+    <add>2.2</add>
+    <onDelete>CASCADE</onDelete>
   </foreignKey>
   <field>
-      <name>contact_id</name>
-      <uniqueName>contribution_soft_contact_id</uniqueName>
-      <title>Contact ID</title>
-      <type>int unsigned</type>
-      <required>true</required>
-      <import>true</import>
-      <headerPattern>/contact(.?id)?/i</headerPattern>
-      <dataPattern>/^\d+$/</dataPattern>
-      <comment>FK to Contact ID</comment>
-      <add>2.2</add>
+    <name>contact_id</name>
+    <uniqueName>contribution_soft_contact_id</uniqueName>
+    <title>Contact ID</title>
+    <type>int unsigned</type>
+    <required>true</required>
+    <import>true</import>
+    <headerPattern>/contact(.?id)?/i</headerPattern>
+    <dataPattern>/^\d+$/</dataPattern>
+    <comment>FK to Contact ID</comment>
+    <add>2.2</add>
   </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>amount</name>
-      <type>decimal</type>
-      <required>true</required>
-      <import>true</import>
-      <headerPattern>/total(.?am(ou)?nt)?/i</headerPattern>
-      <dataPattern>/^\d+(\.\d{2})?$/</dataPattern>
-      <comment>Amount of this soft contribution.</comment>
-      <add>2.2</add>
+    <name>amount</name>
+    <type>decimal</type>
+    <required>true</required>
+    <import>true</import>
+    <headerPattern>/total(.?am(ou)?nt)?/i</headerPattern>
+    <dataPattern>/^\d+(\.\d{2})?$/</dataPattern>
+    <comment>Amount of this soft contribution.</comment>
+    <add>2.2</add>
   </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>
+    <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>pcp_id</name>
-      <type>int unsigned</type>
-      <default>NULL</default>
-      <comment>FK to civicrm_pcp.id</comment>
-      <add>2.2</add>
+    <name>pcp_id</name>
+    <type>int unsigned</type>
+    <default>NULL</default>
+    <comment>FK to civicrm_pcp.id</comment>
+    <add>2.2</add>
   </field>
   <foreignKey>
-      <name>pcp_id</name>
-      <table>civicrm_pcp</table>
-      <key>id</key>
-      <add>3.1</add>
-      <onDelete>SET NULL</onDelete>
+    <name>pcp_id</name>
+    <table>civicrm_pcp</table>
+    <key>id</key>
+    <add>3.1</add>
+    <onDelete>SET NULL</onDelete>
   </foreignKey>
   <index>
-      <name>index_id</name>
-      <fieldName>pcp_id</fieldName>
-      <add>2.2</add>
-   </index>
-   <field>
-      <name>pcp_display_in_roll</name>
-      <type>boolean</type>
-      <default>0</default>
-      <add>2.2</add>
+    <name>index_id</name>
+    <fieldName>pcp_id</fieldName>
+    <add>2.2</add>
+  </index>
+  <field>
+    <name>pcp_display_in_roll</name>
+    <type>boolean</type>
+    <default>0</default>
+    <add>2.2</add>
   </field>
   <field>
-       <name>pcp_roll_nickname</name>
-       <type>varchar</type>
-       <length>255</length>
-       <default>NULL</default>
-       <add>2.2</add>
+    <name>pcp_roll_nickname</name>
+    <type>varchar</type>
+    <length>255</length>
+    <default>NULL</default>
+    <add>2.2</add>
   </field>
   <field>
-       <name>pcp_personal_note</name>
-       <type>varchar</type>
-       <length>255</length>
-       <default>NULL</default>
-       <add>2.2</add>
+    <name>pcp_personal_note</name>
+    <type>varchar</type>
+    <length>255</length>
+    <default>NULL</default>
+    <add>2.2</add>
   </field>
   <field>
-       <name>soft_credit_type_id</name>
-       <type>int unsigned</type>
-       <default>NULL</default>
-       <title>Soft Credit Type</title>
-       <pseudoconstant>
-         <optionGroupName>soft_credit_type</optionGroupName>
-       </pseudoconstant>
-       <comment>Soft Credit Type ID.Implicit FK to civicrm_option_value where option_group = soft_credit_type.</comment>
-       <add>2.2</add>
+    <name>soft_credit_type_id</name>
+    <type>int unsigned</type>
+    <default>NULL</default>
+    <title>Soft Credit Type</title>
+    <pseudoconstant>
+      <optionGroupName>soft_credit_type</optionGroupName>
+    </pseudoconstant>
+    <comment>Soft Credit Type ID.Implicit FK to civicrm_option_value where option_group = soft_credit_type.</comment>
+    <add>2.2</add>
   </field>
 </table>