Merge pull request #16714 from christianwach/lab-1638
[civicrm-core.git] / xml / schema / Contact / GroupContactCache.xml
index 7be337fca37854634b76ec7509764a3d33b69de5..22e92fd4bd811bb6cb60afef3bab8667b6488b82 100644 (file)
@@ -7,18 +7,20 @@
   <comment>Join table cache for 'static' groups.</comment>
   <add>2.1</add>
   <field>
-      <name>id</name>
-      <type>int unsigned</type>
-      <required>true</required>
-      <comment>primary key</comment>
-       <add>2.1</add>
+    <name>id</name>
+    <title>Group Contact Cache ID</title>
+    <type>int unsigned</type>
+    <required>true</required>
+    <comment>primary key</comment>
+    <add>2.1</add>
   </field>
   <primaryKey>
-       <name>id</name>
-       <autoincrement>true</autoincrement>
+    <name>id</name>
+    <autoincrement>true</autoincrement>
   </primaryKey>
   <field>
     <name>group_id</name>
+    <title>Group</title>
     <type>int unsigned</type>
     <required>true</required>
     <comment>FK to civicrm_group</comment>
     </html>
   </field>
   <foreignKey>
-       <name>group_id</name>
-       <table>civicrm_group</table>
-       <key>id</key>
-       <add>2.1</add>
-       <onDelete>CASCADE</onDelete>
+    <name>group_id</name>
+    <table>civicrm_group</table>
+    <key>id</key>
+    <add>2.1</add>
+    <onDelete>CASCADE</onDelete>
   </foreignKey>
   <field>
-      <name>contact_id</name>
-      <type>int unsigned</type>
-      <required>true</required>
-      <comment>FK to civicrm_contact</comment>
-       <add>2.1</add>
+    <name>contact_id</name>
+    <title>Contact ID</title>
+    <type>int unsigned</type>
+    <required>true</required>
+    <comment>FK to civicrm_contact</comment>
+    <add>2.1</add>
   </field>
   <foreignKey>
-       <name>contact_id</name>
-       <table>civicrm_contact</table>
-       <key>id</key>
-       <add>2.1</add>
-       <onDelete>CASCADE</onDelete>
+    <name>contact_id</name>
+    <table>civicrm_contact</table>
+    <key>id</key>
+    <add>2.1</add>
+    <onDelete>CASCADE</onDelete>
   </foreignKey>
   <index>
     <name>UI_contact_group</name>