Merge pull request #15566 from civicrm/5.19
[civicrm-core.git] / xml / schema / Contact / Household.xml
index 51834a7db4a0845358968642d5d3fc39f6fb9b6b..89f4216792a40e20baffc749c07e9231aa0957e8 100644 (file)
@@ -8,56 +8,56 @@
   <add>1.1</add>
   <log>true</log>
   <field>
-      <name>id</name>
-      <type>int unsigned</type>
-      <required>true</required>
-      <comment>Unique Household ID</comment>
-       <add>1.1</add>
+    <name>id</name>
+    <type>int unsigned</type>
+    <required>true</required>
+    <comment>Unique Household ID</comment>
+    <add>1.1</add>
   </field>
   <primaryKey>
-       <name>id</name>
-       <autoincrement>true</autoincrement>
+    <name>id</name>
+    <autoincrement>true</autoincrement>
   </primaryKey>
   <field>
-      <name>contact_id</name>
-      <type>int unsigned</type>
-      <required>true</required>
-      <comment>FK to Contact ID</comment>
-       <add>1.1</add>
+    <name>contact_id</name>
+    <type>int unsigned</type>
+    <required>true</required>
+    <comment>FK to Contact ID</comment>
+    <add>1.1</add>
   </field>
   <foreignKey>
-       <name>contact_id</name>
-       <table>civicrm_contact</table>
-       <key>id</key>
-       <add>1.1</add>
+    <name>contact_id</name>
+    <table>civicrm_contact</table>
+    <key>id</key>
+    <add>1.1</add>
   </foreignKey>
   <field>
-       <name>household_name</name>
-       <type>varchar</type>
-       <length>128</length>
-       <import>true</import>
-       <headerPattern>/^household|(h(ousehold\s)?name)$/i</headerPattern>
-       <dataPattern>/^\w+$/</dataPattern>
-       <comment>Household Name.</comment>
-       <fulltext/>
-       <add>1.1</add>
+    <name>household_name</name>
+    <type>varchar</type>
+    <length>128</length>
+    <import>true</import>
+    <headerPattern>/^household|(h(ousehold\s)?name)$/i</headerPattern>
+    <dataPattern>/^\w+$/</dataPattern>
+    <comment>Household Name.</comment>
+    <fulltext/>
+    <add>1.1</add>
   </field>
   <index>
-      <name>index_household_name</name>
-      <fieldName>household_name</fieldName>      
-      <add>1.8</add>
+    <name>index_household_name</name>
+    <fieldName>household_name</fieldName>
+    <add>1.8</add>
   </index>
   <field>
-      <name>primary_contact_id</name>
-      <type>int unsigned</type>
-      <comment>Optional FK to Primary Contact for this household.</comment>
-       <add>1.1</add>
+    <name>primary_contact_id</name>
+    <type>int unsigned</type>
+    <comment>Optional FK to Primary Contact for this household.</comment>
+    <add>1.1</add>
   </field>
   <foreignKey>
-       <name>primary_contact_id</name>
-       <table>civicrm_contact</table>
-       <key>id</key>
-       <add>1.1</add>
+    <name>primary_contact_id</name>
+    <table>civicrm_contact</table>
+    <key>id</key>
+    <add>1.1</add>
   </foreignKey>
   <index>
     <name>UI_contact</name>