xml/schema/ACL/Cache.xml

   1 <?xml version="1.0" encoding="iso-8859-1" ?>
   2
   3 <table>
   4     <base>CRM/ACL</base>
   5     <class>Cache</class>
   6     <name>civicrm_acl_cache</name>
   7     <comment>Cache for acls and contacts</comment>
   8     <add>1.6</add>
   9     <field>
  10         <name>id</name>
  11         <type>int unsigned</type>
  12         <required>true</required>
  13         <comment>Unique table ID</comment>
  14         <add>1.6</add>
  15     </field>
  16     <primaryKey>
  17         <name>id</name>
  18         <autoincrement>true</autoincrement>
  19     </primaryKey>
  20     <field>
  21         <name>contact_id</name>
  22         <type>int unsigned</type>
  23         <comment>Foreign Key to Contact</comment>
  24         <add>1.6</add>
  25     </field>
  26     <foreignKey>
  27        <name>contact_id</name>
  28        <table>civicrm_contact</table>
  29        <key>id</key>
  30        <add>1.6</add>
  31        <onDelete>CASCADE</onDelete>
  32     </foreignKey>
  33     <field>
  34         <name>acl_id</name>
  35         <type>int unsigned</type>
  36         <required>true</required>
  37         <comment>Foreign Key to ACL</comment>
  38         <add>1.6</add>
  39     </field>
  40     <foreignKey>
  41        <name>acl_id</name>
  42        <table>civicrm_acl</table>
  43        <key>id</key>
  44        <add>1.6</add>
  45        <onDelete>CASCADE</onDelete>
  46     </foreignKey>
  47     <index>
  48        <name>index_acl_id</name>
  49        <fieldName>acl_id</fieldName>
  50        <add>1.6</add>
  51     </index>
  52     <field>
  53        <name>modified_date</name>
  54        <type>date</type>
  55        <comment>When was this cache entry last modified</comment>
  56        <add>1.6</add>
  57     </field>
  58 </table>