2 /* vim: set expandtab sw=4 ts=4 sts=4: */
4 * Links configuration for MySQL system tables
8 if (! defined('PHPMYADMIN')) {
13 * This global variable represent the details for generating links inside
14 * special schemas like mysql, information_schema etc.
15 * Major element represent a schema.
16 * All the strings in this array represented in lower case
17 * This global variable has not modified anywhere
19 * Variable structure ex:
20 * $GLOBALS['special_schema_links'] = array(
21 * // Database name is the major element
27 * // Main url param (can be an array where represent sql)
28 * 'link_param' => 'username',
30 * 'link_dependancy_params' => array(
32 * // URL parameter name
33 * // (can be array where url param has static value)
34 * 'param_info' => 'hostname',
35 * // Column name related to url param
36 * 'column_name' => 'host'
40 * 'default_page' => './server_privileges.php'
47 $GLOBALS['special_schema_links'] = array(
49 'columns_priv' => array(
51 'link_param' => 'username',
52 'link_dependancy_params' => array(
54 'param_info' => 'hostname',
55 'column_name' => 'host'
58 'default_page' => './server_privileges.php'
60 'table_name' => array(
61 'link_param' => 'table',
62 'link_dependancy_params' => array(
68 'default_page' => './' . PhpMyAdmin\Util
::getScriptNameForOption(
69 $GLOBALS['cfg']['DefaultTabTable'], 'table'
72 'column_name' => array(
73 'link_param' => 'field',
74 'link_dependancy_params' => array(
80 'param_info' => 'table',
81 'column_name' => 'Table_name'
84 'default_page' => './tbl_structure.php?change_column=1'
89 'link_param' => 'username',
90 'link_dependancy_params' => array(
92 'param_info' => 'hostname',
93 'column_name' => 'host'
96 'default_page' => './server_privileges.php'
101 'link_param' => 'item_name',
102 'link_dependancy_params' => array(
104 'param_info' => 'db',
105 'column_name' => 'db'
108 'default_page' => './db_events.php?edit_item=1'
112 'innodb_index_stats' => array(
113 'table_name' => array(
114 'link_param' => 'table',
115 'link_dependancy_params' => array(
117 'param_info' => 'db',
118 'column_name' => 'database_name'
121 'default_page' => './' . PhpMyAdmin\Util
::getScriptNameForOption(
122 $GLOBALS['cfg']['DefaultTabTable'], 'table'
125 'index_name' => array(
126 'link_param' => 'index',
127 'link_dependancy_params' => array(
129 'param_info' => 'db',
130 'column_name' => 'database_name'
133 'param_info' => 'table',
134 'column_name' => 'table_name'
137 'default_page' => './tbl_structure.php'
140 'innodb_table_stats' => array(
141 'table_name' => array(
142 'link_param' => 'table',
143 'link_dependancy_params' => array(
145 'param_info' => 'db',
146 'column_name' => 'database_name'
149 'default_page' => './' . PhpMyAdmin\Util
::getScriptNameForOption(
150 $GLOBALS['cfg']['DefaultTabTable'], 'table'
156 'link_param' => 'item_name',
157 'link_dependancy_params' => array(
159 'param_info' => 'db',
160 'column_name' => 'db'
163 'param_info' => 'item_type',
164 'column_name' => 'type'
167 'default_page' => './db_routines.php?edit_item=1'
169 'specific_name' => array(
170 'link_param' => 'item_name',
171 'link_dependancy_params' => array(
173 'param_info' => 'db',
174 'column_name' => 'db'
177 'param_info' => 'item_type',
178 'column_name' => 'type'
181 'default_page' => './db_routines.php?edit_item=1'
184 'proc_priv' => array(
186 'link_param' => 'username',
187 'link_dependancy_params' => array(
189 'param_info' => 'hostname',
190 'column_name' => 'Host'
193 'default_page' => './server_privileges.php'
195 'routine_name' => array(
196 'link_param' => 'item_name',
197 'link_dependancy_params' => array(
199 'param_info' => 'db',
200 'column_name' => 'Db'
203 'param_info' => 'item_type',
204 'column_name' => 'Routine_type'
207 'default_page' => './db_routines.php?edit_item=1'
210 'proxies_priv' => array(
212 'link_param' => 'username',
213 'link_dependancy_params' => array(
215 'param_info' => 'hostname',
216 'column_name' => 'Host'
219 'default_page' => './server_privileges.php'
222 'tables_priv' => array(
224 'link_param' => 'username',
225 'link_dependancy_params' => array(
227 'param_info' => 'hostname',
228 'column_name' => 'Host'
231 'default_page' => './server_privileges.php'
233 'table_name' => array(
234 'link_param' => 'table',
235 'link_dependancy_params' => array(
237 'param_info' => 'db',
238 'column_name' => 'Db'
241 'default_page' => './' . PhpMyAdmin\Util
::getScriptNameForOption(
242 $GLOBALS['cfg']['DefaultTabTable'], 'table'
248 'link_param' => 'username',
249 'link_dependancy_params' => array(
251 'param_info' => 'hostname',
252 'column_name' => 'host'
255 'default_page' => './server_privileges.php'
259 'information_schema' => array(
261 'table_name' => array(
262 'link_param' => 'table',
263 'link_dependancy_params' => array(
265 'param_info' => 'db',
266 'column_name' => 'table_schema'
269 'default_page' => './' . PhpMyAdmin\Util
::getScriptNameForOption(
270 $GLOBALS['cfg']['DefaultTabTable'], 'table'
273 'column_name' => array(
274 'link_param' => 'field',
275 'link_dependancy_params' => array(
277 'param_info' => 'db',
278 'column_name' => 'table_schema'
281 'param_info' => 'table',
282 'column_name' => 'table_name'
285 'default_page' => './tbl_structure.php?change_column=1'
288 'key_column_usage' => array(
289 'table_name' => array(
290 'link_param' => 'table',
291 'link_dependancy_params' => array(
293 'param_info' => 'db',
294 'column_name' => 'constraint_schema'
297 'default_page' => './' . PhpMyAdmin\Util
::getScriptNameForOption(
298 $GLOBALS['cfg']['DefaultTabTable'], 'table'
301 'column_name' => array(
302 'link_param' => 'field',
303 'link_dependancy_params' => array(
305 'param_info' => 'db',
306 'column_name' => 'table_schema'
309 'param_info' => 'table',
310 'column_name' => 'table_name'
313 'default_page' => './tbl_structure.php?change_column=1'
315 'referenced_table_name' => array(
316 'link_param' => 'table',
317 'link_dependancy_params' => array(
319 'param_info' => 'db',
320 'column_name' => 'referenced_table_schema'
323 'default_page' => './' . PhpMyAdmin\Util
::getScriptNameForOption(
324 $GLOBALS['cfg']['DefaultTabTable'], 'table'
327 'referenced_column_name' => array(
328 'link_param' => 'field',
329 'link_dependancy_params' => array(
331 'param_info' => 'db',
332 'column_name' => 'referenced_table_schema'
335 'param_info' => 'table',
336 'column_name' => 'referenced_table_name'
339 'default_page' => './tbl_structure.php?change_column=1'
342 'partitions' => array(
343 'table_name' => array(
344 'link_param' => 'table',
345 'link_dependancy_params' => array(
347 'param_info' => 'db',
348 'column_name' => 'table_schema'
351 'default_page' => './' . PhpMyAdmin\Util
::getScriptNameForOption(
352 $GLOBALS['cfg']['DefaultTabTable'], 'table'
356 'processlist' => array(
358 'link_param' => 'username',
359 'link_dependancy_params' => array(
361 'param_info' => 'hostname',
362 'column_name' => 'host'
365 'default_page' => './server_privileges.php'
368 'referential_constraints' => array(
369 'table_name' => array(
370 'link_param' => 'table',
371 'link_dependancy_params' => array(
373 'param_info' => 'db',
374 'column_name' => 'constraint_schema'
377 'default_page' => './' . PhpMyAdmin\Util
::getScriptNameForOption(
378 $GLOBALS['cfg']['DefaultTabTable'], 'table'
381 'referenced_table_name' => array(
382 'link_param' => 'table',
383 'link_dependancy_params' => array(
385 'param_info' => 'db',
386 'column_name' => 'constraint_schema'
389 'default_page' => './' . PhpMyAdmin\Util
::getScriptNameForOption(
390 $GLOBALS['cfg']['DefaultTabTable'], 'table'
395 'routine_name' => array(
396 'link_param' => 'item_name',
397 'link_dependancy_params' => array(
399 'param_info' => 'db',
400 'column_name' => 'routine_schema'
403 'param_info' => 'item_type',
404 'column_name' => 'routine_type'
407 'default_page' => './db_routines.php'
411 'schema_name' => array(
412 'link_param' => 'db',
413 'default_page' => './' . PhpMyAdmin\Util
::getScriptNameForOption(
414 $GLOBALS['cfg']['DefaultTabTable'], 'table'
418 'statistics' => array(
419 'table_name' => array(
420 'link_param' => 'table',
421 'link_dependancy_params' => array(
423 'param_info' => 'db',
424 'column_name' => 'table_schema'
427 'default_page' => './' . PhpMyAdmin\Util
::getScriptNameForOption(
428 $GLOBALS['cfg']['DefaultTabTable'], 'table'
431 'column_name' => array(
432 'link_param' => 'field',
433 'link_dependancy_params' => array(
435 'param_info' => 'db',
436 'column_name' => 'table_schema'
439 'param_info' => 'table',
440 'column_name' => 'table_name'
443 'default_page' => './tbl_structure.php?change_column=1'
447 'table_name' => array(
448 'link_param' => 'table',
449 'link_dependancy_params' => array(
451 'param_info' => 'db',
452 'column_name' => 'table_schema'
455 'default_page' => './' . PhpMyAdmin\Util
::getScriptNameForOption(
456 $GLOBALS['cfg']['DefaultTabTable'], 'table'
460 'table_constraints' => array(
461 'table_name' => array(
462 'link_param' => 'table',
463 'link_dependancy_params' => array(
465 'param_info' => 'db',
466 'column_name' => 'table_schema'
469 'default_page' => './' . PhpMyAdmin\Util
::getScriptNameForOption(
470 $GLOBALS['cfg']['DefaultTabTable'], 'table'
475 'table_name' => array(
476 'link_param' => 'table',
477 'link_dependancy_params' => array(
479 'param_info' => 'db',
480 'column_name' => 'table_schema'
483 'default_page' => './' . PhpMyAdmin\Util
::getScriptNameForOption(
484 $GLOBALS['cfg']['DefaultTabTable'], 'table'