Merge pull request #16632 from colemanw/dash
[civicrm-core.git] / xml / schema / Contact / GroupContact.xml
index 014b2b028c7ea06f2af53f5bd2f5d2aeba7c424e..304be14a0a513e128c7c85903ba5859bfe856a50 100644 (file)
@@ -4,20 +4,20 @@
   <base>CRM/Contact</base>
   <class>GroupContact</class>
   <name>civicrm_group_contact</name>
-  <comment>Join table sets membership for 'static' groups. Also used to store 'opt-out' entries for 'query' type groups (status = 'OUT')</comment>
+  <comment>Join table sets membership for 'static' groups. Also used to store 'opt-out' entries for 'query' type groups (status = 'OUT') </comment>
   <add>1.1</add>
   <log>true</log>
   <field>
-      <name>id</name>
-      <type>int unsigned</type>
-      <title>Group Contact ID</title>
-      <required>true</required>
-      <comment>primary key</comment>
-       <add>1.1</add>
+    <name>id</name>
+    <type>int unsigned</type>
+    <title>Group Contact ID</title>
+    <required>true</required>
+    <comment>primary key</comment>
+    <add>1.1</add>
   </field>
   <primaryKey>
-       <name>id</name>
-       <autoincrement>true</autoincrement>
+    <name>id</name>
+    <autoincrement>true</autoincrement>
   </primaryKey>
   <field>
     <name>group_id</name>
     </html>
   </field>
   <foreignKey>
-       <name>group_id</name>
-       <table>civicrm_group</table>
-       <key>id</key>
-       <add>1.1</add>
-       <onDelete>CASCADE</onDelete>
+    <name>group_id</name>
+    <table>civicrm_group</table>
+    <key>id</key>
+    <add>1.1</add>
+    <onDelete>CASCADE</onDelete>
   </foreignKey>
   <field>
-      <name>contact_id</name>
-      <type>int unsigned</type>
-      <title>Contact ID</title>
-      <required>true</required>
-      <comment>FK to civicrm_contact</comment>
-       <add>1.1</add>
+    <name>contact_id</name>
+    <type>int unsigned</type>
+    <title>Contact ID</title>
+    <required>true</required>
+    <comment>FK to civicrm_contact</comment>
+    <add>1.1</add>
   </field>
   <foreignKey>
-       <name>contact_id</name>
-       <table>civicrm_contact</table>
-       <key>id</key>
-       <add>1.1</add>
-       <onDelete>CASCADE</onDelete>
+    <name>contact_id</name>
+    <table>civicrm_contact</table>
+    <key>id</key>
+    <add>1.1</add>
+    <onDelete>CASCADE</onDelete>
   </foreignKey>
   <field>
-       <name>status</name>
-       <type>varchar</type>
-       <length>8</length>
-       <title>Group Contact Status</title>
-       <comment>status of contact relative to membership in group</comment>
-       <pseudoconstant>
-         <callback>CRM_Core_SelectValues::groupContactStatus</callback>
-       </pseudoconstant>
-       <add>1.1</add>
-       <html>
-         <type>Select</type>
-       </html>
+    <name>status</name>
+    <type>varchar</type>
+    <length>8</length>
+    <title>Group Contact Status</title>
+    <comment>status of contact relative to membership in group</comment>
+    <pseudoconstant>
+      <callback>CRM_Core_SelectValues::groupContactStatus</callback>
+    </pseudoconstant>
+    <add>1.1</add>
+    <html>
+      <type>Select</type>
+    </html>
   </field>
   <field>
-       <name>location_id</name>
-       <type>int unsigned</type>
-       <title>Group Contact Location</title>
-       <comment>Optional location to associate with this membership</comment>
-       <add>1.1</add>
+    <name>location_id</name>
+    <type>int unsigned</type>
+    <title>Group Contact Location</title>
+    <comment>Optional location to associate with this membership</comment>
+    <add>1.1</add>
   </field>
   <foreignKey>
     <name>location_id</name>
     <onDelete>SET NULL</onDelete>
   </foreignKey>
   <field>
-      <name>email_id</name>
-      <type>int unsigned</type>
-      <title>Group Contact Email</title>
-      <comment>Optional email to associate with this membership</comment>
-      <add>1.1</add>
+    <name>email_id</name>
+    <type>int unsigned</type>
+    <title>Group Contact Email</title>
+    <comment>Optional email to associate with this membership</comment>
+    <add>1.1</add>
   </field>
   <foreignKey>
     <name>email_id</name>