CRM-14181 fixes - migrate enums to varchar in schema for all tables
[civicrm-core.git] / 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 <html>
28 <type>Text</type>
29 </html>
30 <add>1.6</add>
31 </field>
32 <field>
33 <name>deny</name>
34 <type>boolean</type>
35 <default>0</default>
36 <required>true</required>
37 <comment>Is this ACL entry Allow (0) or Deny (1) ?</comment>
38 <html>
39 <type>Radio</type>
40 </html>
41 <add>1.6</add>
42 </field>
43 <field>
44 <name>entity_table</name>
45 <type>varchar</type>
46 <length>64</length>
47 <required>true</required>
48 <comment>Table of the object possessing this ACL entry (Contact, Group, or ACL Group)</comment>
49 <add>1.6</add>
50 </field>
51 <field>
52 <name>entity_id</name>
53 <type>int unsigned</type>
54 <comment>ID of the object possessing this ACL</comment>
55 <add>1.6</add>
56 </field>
57 <dynamicForeignKey>
58 <idColumn>entity_id</idColumn>
59 <typeColumn>entity_table</typeColumn>
60 <add>1.6</add>
61 </dynamicForeignKey>
62 <field>
63 <name>operation</name>
64 <type>varchar</type>
65 <length>8</length>
66 <required>true</required>
67 <comment>What operation does this ACL entry control?</comment>
68 <html>
69 <type>Select</type>
70 </html>
71 <add>1.6</add>
72 </field>
73 <field>
74 <name>object_table</name>
75 <type>varchar</type>
76 <length>64</length>
77 <comment>The table of the object controlled by this ACL entry</comment>
78 <add>1.6</add>
79 </field>
80 <field>
81 <name>object_id</name>
82 <type>int unsigned</type>
83 <comment>The ID of the object controlled by this ACL entry</comment>
84 <add>1.6</add>
85 </field>
86 <field>
87 <name>acl_table</name>
88 <type>varchar</type>
89 <length>64</length>
90 <comment>If this is a grant/revoke entry, what table are we granting?</comment>
91 <add>1.6</add>
92 </field>
93 <field>
94 <name>acl_id</name>
95 <type>int unsigned</type>
96 <comment>ID of the ACL or ACL group being granted/revoked</comment>
97 <add>1.6</add>
98 </field>
99 <index>
100 <name>index_acl_id</name>
101 <fieldName>acl_id</fieldName>
102 <add>1.6</add>
103 </index>
104 <field>
105 <name>is_active</name>
106 <type>boolean</type>
107 <comment>Is this property active?</comment>
108 <add>1.6</add>
109 <html>
110 <type>Checkbox</type>
111 </html>
112 </field>
113 </table>