updated acknowledgments
[openemr.git] / phpmyadmin / libraries / special_schema_links.lib.php
blobd012f4b225a498c27df225d0d1225badc9faab6d
1 <?php
2 /* vim: set expandtab sw=4 ts=4 sts=4: */
3 /**
5 * @package PhpMyAdmin
6 */
7 if (! defined('PHPMYADMIN')) {
8 exit;
11 /**
12 * This global variable represent the details for generating links inside
13 * special schemas like mysql, information_schema etc.
14 * Major element represent a schema.
15 * All the strings in this array represented in lower case
16 * This global variable has not modified anywhere
18 * Variable structure ex:
19 * $GLOBALS['special_schema_links'] = array(
20 * // Database name is the major element
21 * 'mysql' => array(
22 * // Table name
23 * 'db' => array(
24 * // Column name
25 * 'user' => array(
26 * // Main url param (can be an array where represent sql)
27 * 'link_param' => 'username',
28 * // Other url params
29 * 'link_dependancy_params' => array(
30 * 0 => array(
31 * // URL parameter name
32 * // (can be array where url param has static value)
33 * 'param_info' => 'hostname',
34 * // Column name related to url param
35 * 'column_name' => 'host'
36 * )
37 * ),
38 * // Page to link
39 * 'default_page' => 'server_privileges.php'
40 * )
41 * )
42 * )
43 * );
46 $GLOBALS['special_schema_links'] = array(
47 'mysql' => array(
48 'db' => array(
49 'db' => array(
50 'link_param' => 'db',
51 'default_page' => 'index.php'
53 'user' => array(
54 'link_param' => 'username',
55 'link_dependancy_params' => array(
56 0 => array(
57 'param_info' => 'hostname',
58 'column_name' => 'host'
61 'default_page' => 'server_privileges.php'
64 'proc' => array(
65 'db' => array(
66 'link_param' => 'db',
67 'default_page' => 'index.php'
71 'user' => array(
72 'user' => array(
73 'link_param' => 'username',
74 'link_dependancy_params' => array(
75 0 => array(
76 'param_info' => 'hostname',
77 'column_name' => 'host'
80 'default_page' => 'server_privileges.php'
85 'information_schema' => array(
86 'columns' => array(
87 'table_name' => array(
88 'link_param' => 'table',
89 'link_dependancy_params' => array(
90 0 => array(
91 'param_info' => 'db',
92 'column_name' => 'table_schema'
95 'default_page' => 'index.php'
97 'column_name' => array(
98 'link_param' => array(
99 'sql_query',
100 'table_schema',
101 'table_name'
103 'link_dependancy_params' => array(
104 0 => array(
105 'param_info' => 'db',
106 'column_name' => 'table_schema'
108 1 => array(
109 'param_info' => 'table',
110 'column_name' => 'table_name'
113 'default_page' => 'index.php'
116 'key_column_usage' => array(
117 'table_name' => array(
118 'link_param' => 'table',
119 'link_dependancy_params' => array(
120 0 => array(
121 'param_info' => 'db',
122 'column_name' => 'constraint_schema'
125 'default_page' => 'index.php'
127 'column_name' => array(
128 'link_param' => array(
129 'sql_query',
130 'table_schema',
131 'table_name'
133 'link_dependancy_params' => array(
134 0 => array(
135 'param_info' => 'db',
136 'column_name' => 'table_schema'
138 1 => array(
139 'param_info' => 'table',
140 'column_name' => 'table_name'
143 'default_page' => 'index.php'
145 'referenced_table_schema' => array(
146 'link_param' => 'db',
147 'default_page' => 'index.php'
149 'referenced_table_name' => array(
150 'link_param' => 'table',
151 'link_dependancy_params' => array(
152 0 => array(
153 'param_info' => 'db',
154 'column_name' => 'referenced_table_schema'
157 'default_page' => 'index.php'
159 'referenced_column_name' => array(
160 'link_param' => array(
161 'sql_query',
162 'referenced_table_schema',
163 'referenced_table_name'
165 'link_dependancy_params' => array(
166 0 => array(
167 'param_info' => 'db',
168 'column_name' => 'referenced_table_schema'
170 1 => array(
171 'param_info' => 'table',
172 'column_name' => 'referenced_table_name'
175 'default_page' => 'index.php'
178 'partitions' => array(
179 'table_schema' => array(
180 'link_param' => 'db',
181 'default_page' => 'index.php'
183 'table_name' => array(
184 'link_param' => 'table',
185 'link_dependancy_params' => array(
186 0 => array(
187 'param_info' => 'db',
188 'column_name' => 'table_schema'
191 'default_page' => 'index.php'
194 'processlist' => array(
195 'db' => array(
196 'link_param' => 'db',
197 'default_page' => 'index.php'
199 'user' => array(
200 'link_param' => 'username',
201 'link_dependancy_params' => array(
202 0 => array(
203 'param_info' => 'hostname',
204 'column_name' => 'host'
207 'default_page' => 'server_privileges.php'
210 'referential_constraints' => array(
211 'constraint_schema' => array(
212 'link_param' => 'db',
213 'default_page' => 'index.php'
215 'unique_constraint_schema' => array(
216 'link_param' => 'db',
217 'default_page' => 'index.php'
219 'table_name' => array(
220 'link_param' => 'table',
221 'link_dependancy_params' => array(
222 0 => array(
223 'param_info' => 'db',
224 'column_name' => 'constraint_schema'
227 'default_page' => 'index.php'
229 'referenced_table_name' => array(
230 'link_param' => 'table',
231 'link_dependancy_params' => array(
232 0 => array(
233 'param_info' => 'db',
234 'column_name' => 'constraint_schema'
237 'default_page' => 'index.php'
240 'routines' => array(
241 'routine_name' => array(
242 'link_param' => 'item_name',
243 'link_dependancy_params' => array(
244 0 => array(
245 'param_info' => 'db',
246 'column_name' => 'routine_schema'
248 1 => array(
249 'param_info' => 'item_type',
250 'column_name' => 'routine_type'
253 'default_page' => 'db_routines.php'
256 'schemata' => array(
257 'schema_name' => array(
258 'link_param' => 'db',
259 'default_page' => 'index.php'
262 'statistics' => array(
263 'table_schema' => array(
264 'link_param' => 'db',
265 'default_page' => 'index.php'
267 'table_name' => array(
268 'link_param' => 'table',
269 'link_dependancy_params' => array(
270 0 => array(
271 'param_info' => 'db',
272 'column_name' => 'table_schema'
275 'default_page' => 'index.php'
277 'column_name' => array(
278 'link_param' => array(
279 'sql_query',
280 'table_schema',
281 'table_name'
283 'link_dependancy_params' => array(
284 0 => array(
285 'param_info' => 'db',
286 'column_name' => 'table_schema'
288 1 => array(
289 'param_info' => 'table',
290 'column_name' => 'table_name'
293 'default_page' => 'index.php'
296 'tables' => array(
297 'table_name' => array(
298 'link_param' => 'table',
299 'link_dependancy_params' => array(
300 0 => array(
301 'param_info' => 'db',
302 'column_name' => 'table_schema'
305 'default_page' => 'index.php'
308 'table_constraints' => array(
309 'table_name' => array(
310 'link_param' => 'table',
311 'link_dependancy_params' => array(
312 0 => array(
313 'param_info' => 'db',
314 'column_name' => 'table_schema'
317 'default_page' => 'index.php'