Merge pull request #23159 from eileenmcnaughton/event
[civicrm-core.git] / xml / schema / Core / Navigation.xml
CommitLineData
6a488035
TO
1<?xml version="1.0" encoding="iso-8859-1" ?>
2
3<table>
4 <base>CRM/Core</base>
5 <class>Navigation</class>
6 <name>civicrm_navigation</name>
7 <comment>Table to store navigation.</comment>
8 <add>3.0</add>
8ab43c93 9 <labelField>label</labelField>
6a488035 10 <field>
8f069c03 11 <name>id</name>
1c4f4ae6 12 <title>Navigation ID</title>
8f069c03
EM
13 <type>int unsigned</type>
14 <required>true</required>
0481e12c
A
15 <html>
16 <type>Number</type>
17 </html>
8f069c03 18 <add>3.0</add>
6a488035
TO
19 </field>
20 <primaryKey>
8f069c03
EM
21 <name>id</name>
22 <autoincrement>true</autoincrement>
6a488035
TO
23 </primaryKey>
24 <field>
8f069c03 25 <name>domain_id</name>
047c5009 26 <title>Domain ID</title>
8f069c03
EM
27 <type>int unsigned</type>
28 <required>true</required>
29 <pseudoconstant>
30 <table>civicrm_domain</table>
31 <keyColumn>id</keyColumn>
32 <labelColumn>name</labelColumn>
33 </pseudoconstant>
34 <comment>Which Domain is this navigation item for</comment>
57e94608 35 <html>
047c5009 36 <label>Domain</label>
57e94608 37 </html>
8f069c03 38 <add>3.0</add>
6a488035
TO
39 </field>
40 <foreignKey>
8f069c03
EM
41 <name>domain_id</name>
42 <table>civicrm_domain</table>
43 <key>id</key>
44 <add>3.0</add>
6a488035
TO
45 </foreignKey>
46 <field>
8f069c03 47 <name>label</name>
1c4f4ae6 48 <title>Navigation Item Label</title>
8f069c03
EM
49 <type>varchar</type>
50 <length>255</length>
51 <comment>Navigation Title</comment>
52 <add>3.0</add>
6a488035
TO
53 </field>
54 <field>
8f069c03 55 <name>name</name>
1c4f4ae6 56 <title>Navigation Item Machine Name</title>
8f069c03
EM
57 <type>varchar</type>
58 <length>255</length>
59 <comment>Internal Name</comment>
60 <add>3.0</add>
6a488035
TO
61 </field>
62 <field>
63 <name>url</name>
1c4f4ae6 64 <title>Url</title>
6a488035
TO
65 <type>varchar</type>
66 <length>255</length>
67 <comment>url in case of custom navigation link</comment>
68 <add>3.0</add>
69 </field>
4926ede8
O
70 <field>
71 <name>icon</name>
72 <title>Icon</title>
73 <type>varchar</type>
74 <length>255</length>
75 <comment>CSS class name for an icon</comment>
76 <default>NULL</default>
77 <required>false</required>
78 <add>4.7</add>
79 </field>
6a488035 80 <field>
8f069c03 81 <name>permission</name>
1c4f4ae6 82 <title>Required Permission</title>
8f069c03
EM
83 <type>varchar</type>
84 <length>255</length>
6e9fbc8b
CW
85 <comment>Permission(s) needed to access menu item</comment>
86 <serialize>COMMA</serialize>
8f069c03 87 <add>3.0</add>
6a488035
TO
88 </field>
89 <field>
8f069c03 90 <name>permission_operator</name>
1c4f4ae6 91 <title>Permission Operator</title>
8f069c03
EM
92 <type>varchar</type>
93 <length>3</length>
6e9fbc8b
CW
94 <pseudoconstant>
95 <callback>CRM_Core_SelectValues::andOr</callback>
96 </pseudoconstant>
97 <comment>Operator to use if item has more than one permission</comment>
8f069c03 98 <add>3.0</add>
6a488035
TO
99 </field>
100 <field>
8f069c03 101 <name>parent_id</name>
047c5009 102 <title>parent ID</title>
8f069c03
EM
103 <type>int unsigned</type>
104 <comment>Parent navigation item, used for grouping</comment>
dfbeefd8 105 <pseudoconstant>
106 <table>civicrm_navigation</table>
e2c44ec0
AH
107 <keyColumn>id</keyColumn>
108 <nameColumn>name</nameColumn>
dfbeefd8 109 <labelColumn>label</labelColumn>
110 </pseudoconstant>
57e94608 111 <html>
047c5009 112 <label>parent</label>
57e94608 113 </html>
8f069c03 114 <add>3.0</add>
6a488035
TO
115 </field>
116 <foreignKey>
8f069c03
EM
117 <name>parent_id</name>
118 <table>civicrm_navigation</table>
119 <key>id</key>
120 <onDelete>CASCADE</onDelete>
121 <add>3.0</add>
6a488035
TO
122 </foreignKey>
123 <field>
8f069c03 124 <name>is_active</name>
1c4f4ae6 125 <title>Is Active</title>
8f069c03
EM
126 <type>boolean</type>
127 <comment>Is this navigation item active?</comment>
27010e05
CW
128 <default>1</default>
129 <required>true</required>
8f069c03 130 <add>3.0</add>
6a488035
TO
131 </field>
132 <field>
8f069c03 133 <name>has_separator</name>
e0674c37
CW
134 <title>Separator</title>
135 <type>tinyint</type>
136 <comment>Place a separator either before or after this menu item.</comment>
137 <default>0</default>
8f069c03 138 <add>3.0</add>
e0674c37
CW
139 <pseudoconstant>
140 <callback>CRM_Core_SelectValues::navigationMenuSeparator</callback>
141 </pseudoconstant>
6a488035
TO
142 </field>
143 <field>
144 <name>weight</name>
7ecddde4 145 <title>Order</title>
6a488035
TO
146 <type>int</type>
147 <comment>Ordering of the navigation items in various blocks.</comment>
27010e05
CW
148 <default>0</default>
149 <required>true</required>
6a488035
TO
150 <add>3.0</add>
151 </field>
152</table>