xml/schema/ACL/ACL.xml

   1 <?xml version="1.0" encoding="iso-8859-1" ?>
   2
   3 <table>
   4     <base>CRM/ACL</base>
   5     <class>ACL</class>
   6     <name>civicrm_acl</name>
   7     <comment>Access Control List</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>name</name>
  22        <title>ACL Name</title>
  23        <type>varchar</type>
  24        <length>64</length>
  25        <comment>ACL Name.</comment>
  26        <add>1.6</add>
  27     </field>
  28     <field>
  29         <name>deny</name>
  30         <type>boolean</type>
  31         <default>0</default>
  32         <required>true</required>
  33         <comment>Is this ACL entry Allow  (0) or Deny (1) ?</comment>
  34         <add>1.6</add>
  35     </field>
  36     <field>
  37         <name>entity_table</name>
  38         <type>varchar</type>
  39         <length>64</length>
  40         <required>true</required>
  41         <comment>Table of the object possessing this ACL entry (Contact, Group, or ACL Group)</comment>
  42         <add>1.6</add>
  43     </field>
  44     <field>
  45         <name>entity_id</name>
  46         <type>int unsigned</type>
  47         <comment>ID of the object possessing this ACL</comment>
  48         <add>1.6</add>
  49     </field>
  50     <field>
  51         <name>operation</name>
  52         <type>enum</type>
  53         <values>All,View,Edit,Create,Delete,Grant,Revoke,Search</values>
  54         <required>true</required>
  55         <comment>What operation does this ACL entry control?</comment>
  56         <add>1.6</add>
  57     </field>
  58     <field>
  59         <name>object_table</name>
  60         <type>varchar</type>
  61         <length>64</length>
  62         <comment>The table of the object controlled by this ACL entry</comment>
  63         <add>1.6</add>
  64     </field>
  65     <field>
  66         <name>object_id</name>
  67         <type>int unsigned</type>
  68         <comment>The ID of the object controlled by this ACL entry</comment>
  69         <add>1.6</add>
  70     </field>
  71     <field>
  72         <name>acl_table</name>
  73         <type>varchar</type>
  74         <length>64</length>
  75         <comment>If this is a grant/revoke entry, what table are we granting?</comment>
  76         <add>1.6</add>
  77     </field>
  78     <field>
  79         <name>acl_id</name>
  80         <type>int unsigned</type>
  81         <comment>ID of the ACL or ACL group being granted/revoked</comment>
  82         <add>1.6</add>
  83     </field>
  84     <index>
  85        <name>index_acl_id</name>
  86        <fieldName>acl_id</fieldName>
  87        <add>1.6</add>
  88     </index>
  89     <field>
  90        <name>is_active</name>
  91        <type>boolean</type>
  92        <comment>Is this property active?</comment>
  93        <add>1.6</add>
  94     </field>
  95 </table>