1 <?xml version=
"1.0" encoding=
"iso-8859-1" ?>
4 <base>CRM/Contact
</base>
5 <class>GroupContactCache
</class>
6 <name>civicrm_group_contact_cache
</name>
7 <comment>Join table cache for 'static' groups.
</comment>
11 <type>int unsigned
</type>
12 <required>true
</required>
13 <comment>primary key
</comment>
18 <autoincrement>true
</autoincrement>
22 <type>int unsigned
</type>
23 <required>true
</required>
24 <comment>FK to civicrm_group
</comment>
27 <table>civicrm_group
</table>
28 <keyColumn>id
</keyColumn>
29 <labelColumn>title
</labelColumn>
34 <table>civicrm_group
</table>
37 <onDelete>CASCADE
</onDelete>
40 <name>contact_id
</name>
41 <type>int unsigned
</type>
42 <required>true
</required>
43 <comment>FK to civicrm_contact
</comment>
47 <name>contact_id
</name>
48 <table>civicrm_contact
</table>
51 <onDelete>CASCADE
</onDelete>
54 <name>UI_contact_group
</name>
55 <fieldName>contact_id
</fieldName>
56 <fieldName>group_id
</fieldName>