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     <dynamicForeignKey>
  51         <idColumn>entity_id</idColumn>
  52         <typeColumn>entity_table</typeColumn>
  53         <add>1.6</add>
  54     </dynamicForeignKey>
  55     <field>
  56         <name>operation</name>
  57         <type>enum</type>
  58         <values>All,View,Edit,Create,Delete,Grant,Revoke,Search</values>
  59         <required>true</required>
  60         <comment>What operation does this ACL entry control?</comment>
  61         <add>1.6</add>
  62     </field>
  63     <field>
  64         <name>object_table</name>
  65         <type>varchar</type>
  66         <length>64</length>
  67         <comment>The table of the object controlled by this ACL entry</comment>
  68         <add>1.6</add>
  69     </field>
  70     <field>
  71         <name>object_id</name>
  72         <type>int unsigned</type>
  73         <comment>The ID of the object controlled by this ACL entry</comment>
  74         <add>1.6</add>
  75     </field>
  76     <field>
  77         <name>acl_table</name>
  78         <type>varchar</type>
  79         <length>64</length>
  80         <comment>If this is a grant/revoke entry, what table are we granting?</comment>
  81         <add>1.6</add>
  82     </field>
  83     <field>
  84         <name>acl_id</name>
  85         <type>int unsigned</type>
  86         <comment>ID of the ACL or ACL group being granted/revoked</comment>
  87         <add>1.6</add>
  88     </field>
  89     <index>
  90        <name>index_acl_id</name>
  91        <fieldName>acl_id</fieldName>
  92        <add>1.6</add>
  93     </index>
  94     <field>
  95        <name>is_active</name>
  96        <type>boolean</type>
  97        <comment>Is this property active?</comment>
  98        <add>1.6</add>
  99     </field>
 100 </table>