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         <title>ACL ID</title>
  12         <type>int unsigned</type>
  13         <required>true</required>
  14         <comment>Unique table ID</comment>
  15         <add>1.6</add>
  16     </field>
  17     <primaryKey>
  18         <name>id</name>
  19         <autoincrement>true</autoincrement>
  20     </primaryKey>
  21     <field>
  22        <name>name</name>
  23        <title>ACL Name</title>
  24        <type>varchar</type>
  25        <length>64</length>
  26        <comment>ACL Name.</comment>
  27        <add>1.6</add>
  28     </field>
  29     <field>
  30         <name>deny</name>
  31         <type>boolean</type>
  32         <default>0</default>
  33         <required>true</required>
  34         <comment>Is this ACL entry Allow  (0) or Deny (1) ?</comment>
  35         <add>1.6</add>
  36     </field>
  37     <field>
  38         <name>entity_table</name>
  39         <type>varchar</type>
  40         <length>64</length>
  41         <required>true</required>
  42         <comment>Table of the object possessing this ACL entry (Contact, Group, or ACL Group)</comment>
  43         <add>1.6</add>
  44     </field>
  45     <field>
  46         <name>entity_id</name>
  47         <type>int unsigned</type>
  48         <comment>ID of the object possessing this ACL</comment>
  49         <add>1.6</add>
  50     </field>
  51     <dynamicForeignKey>
  52         <idColumn>entity_id</idColumn>
  53         <typeColumn>entity_table</typeColumn>
  54         <add>1.6</add>
  55     </dynamicForeignKey>
  56     <field>
  57         <name>operation</name>
  58         <type>enum</type>
  59         <values>All,View,Edit,Create,Delete,Grant,Revoke,Search</values>
  60         <required>true</required>
  61         <comment>What operation does this ACL entry control?</comment>
  62         <add>1.6</add>
  63     </field>
  64     <field>
  65         <name>object_table</name>
  66         <type>varchar</type>
  67         <length>64</length>
  68         <comment>The table of the object controlled by this ACL entry</comment>
  69         <add>1.6</add>
  70     </field>
  71     <field>
  72         <name>object_id</name>
  73         <type>int unsigned</type>
  74         <comment>The ID of the object controlled by this ACL entry</comment>
  75         <add>1.6</add>
  76     </field>
  77     <field>
  78         <name>acl_table</name>
  79         <type>varchar</type>
  80         <length>64</length>
  81         <comment>If this is a grant/revoke entry, what table are we granting?</comment>
  82         <add>1.6</add>
  83     </field>
  84     <field>
  85         <name>acl_id</name>
  86         <type>int unsigned</type>
  87         <comment>ID of the ACL or ACL group being granted/revoked</comment>
  88         <add>1.6</add>
  89     </field>
  90     <index>
  91        <name>index_acl_id</name>
  92        <fieldName>acl_id</fieldName>
  93        <add>1.6</add>
  94     </index>
  95     <field>
  96        <name>is_active</name>
  97        <type>boolean</type>
  98        <comment>Is this property active?</comment>
  99        <add>1.6</add>
 100     </field>
 101 </table>