libraries/special_schema_links.lib.php

   1 <?php
   2 /* vim: set expandtab sw=4 ts=4 sts=4: */
   3 /**
   4  *
   5  * @package PhpMyAdmin
   6  */
   7 if (! defined('PHPMYADMIN')) {
   8     exit;
   9 }
  10
  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
  17  *
  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  * );
  44  *
  45  */
  46 $GLOBALS['special_schema_links'] = array(
  47     'mysql' => array(
  48         'db' => array(
  49             'db' => array(
  50                 'link_param' => 'db',
  51                 'default_page' => $GLOBALS['cfg']['DefaultTabDatabase']
  52             ),
  53             'user' => array(
  54                 'link_param' => 'username',
  55                 'link_dependancy_params' => array(
  56                     0 => array(
  57                         'param_info' => 'hostname',
  58                         'column_name' => 'host'
  59                     )
  60                 ),
  61                 'default_page' => 'server_privileges.php'
  62             )
  63         ),
  64         'proc' => array(
  65             'db' => array(
  66                 'link_param' => 'db',
  67                 'default_page' => $GLOBALS['cfg']['DefaultTabDatabase']
  68             )
  69         ),
  70         'user' => array(
  71             'user' => array(
  72                 'link_param' => 'username',
  73                 'link_dependancy_params' => array(
  74                     0 => array(
  75                         'param_info' => 'hostname',
  76                         'column_name' => 'host'
  77                     )
  78                 ),
  79                 'default_page' => 'server_privileges.php'
  80             )
  81         )
  82     ),
  83     'information_schema' => array(
  84         'columns' => array(
  85             'table_schema' => array(
  86                 'link_param' => 'db',
  87                 'default_page' => $GLOBALS['cfg']['DefaultTabDatabase']
  88             ),
  89             'table_name' => array(
  90                 'link_param' => 'table',
  91                 'link_dependancy_params' => array(
  92                     0 => array(
  93                         'param_info' => 'db',
  94                         'column_name' => 'table_schema'
  95                     )
  96                 ),
  97                 'default_page' => $GLOBALS['cfg']['DefaultTabTable']
  98             ),
  99             'column_name' => array(
 100                 'link_param' => array(
 101                     'sql_query',
 102                     'table_schema',
 103                     'table_name'
 104                 ),
 105                 'link_dependancy_params' => array(
 106                     0 => array(
 107                         'param_info' => 'db',
 108                         'column_name' => 'table_schema'
 109                     ),
 110                     1 => array(
 111                         'param_info' => 'table',
 112                         'column_name' => 'table_name'
 113                     )
 114                 ),
 115                 'default_page' => 'sql.php'
 116             )
 117         ),
 118         'column_privileges' => array(
 119             'table_schema' => array(
 120                 'link_param' => 'db',
 121                 'default_page' => $GLOBALS['cfg']['DefaultTabDatabase']
 122             )
 123         ),
 124         'events' => array(
 125             'event_schema' => array(
 126                 'link_param' => 'db',
 127                 'default_page' => $GLOBALS['cfg']['DefaultTabDatabase']
 128             )
 129         ),
 130         'files' => array(
 131             'table_schema' => array(
 132                 'link_param' => 'db',
 133                 'default_page' => $GLOBALS['cfg']['DefaultTabDatabase']
 134             )
 135         ),
 136         'key_column_usage' => array(
 137             'table_name' => array(
 138                 'link_param' => 'table',
 139                 'link_dependancy_params' => array(
 140                     0 => array(
 141                         'param_info' => 'db',
 142                         'column_name' => 'constraint_schema'
 143                     )
 144                 ),
 145                 'default_page' => $GLOBALS['cfg']['DefaultTabTable']
 146             ),
 147             'column_name' => array(
 148                 'link_param' => array(
 149                     'sql_query',
 150                     'table_schema',
 151                     'table_name'
 152                 ),
 153                 'link_dependancy_params' => array(
 154                     0 => array(
 155                         'param_info' => 'db',
 156                         'column_name' => 'table_schema'
 157                     ),
 158                     1 => array(
 159                         'param_info' => 'table',
 160                         'column_name' => 'table_name'
 161                     )
 162                 ),
 163                 'default_page' => 'sql.php'
 164             ),
 165             'constraint_schema' => array(
 166                 'link_param' => 'db',
 167                 'default_page' => $GLOBALS['cfg']['DefaultTabDatabase']
 168             ),
 169             'table_schema' => array(
 170                 'link_param' => 'db',
 171                 'default_page' => $GLOBALS['cfg']['DefaultTabDatabase']
 172             ),
 173             'referenced_table_schema' => array(
 174                 'link_param' => 'db',
 175                 'default_page' => $GLOBALS['cfg']['DefaultTabDatabase']
 176             ),
 177             'referenced_table_name' => array(
 178                 'link_param' => 'table',
 179                 'link_dependancy_params' => array(
 180                     0 => array(
 181                         'param_info' => 'db',
 182                         'column_name' => 'referenced_table_schema'
 183                     )
 184                 ),
 185                 'default_page' => $GLOBALS['cfg']['DefaultTabTable']
 186             ),
 187             'referenced_column_name' => array(
 188                 'link_param' => array(
 189                     'sql_query',
 190                     'referenced_table_schema',
 191                     'referenced_table_name'
 192                 ),
 193                 'link_dependancy_params' => array(
 194                     0 => array(
 195                         'param_info' => 'db',
 196                         'column_name' => 'referenced_table_schema'
 197                     ),
 198                     1 => array(
 199                         'param_info' => 'table',
 200                         'column_name' => 'referenced_table_name'
 201                     )
 202                 ),
 203                 'default_page' => 'sql.php'
 204             )
 205         ),
 206         'parameters' => array(
 207             'specific_schema' => array(
 208                 'link_param' => 'db',
 209                 'default_page' => $GLOBALS['cfg']['DefaultTabDatabase']
 210             )
 211         ),
 212         'partitions' => array(
 213             'table_schema' => array(
 214                 'link_param' => 'db',
 215                 'default_page' => $GLOBALS['cfg']['DefaultTabDatabase']
 216             ),
 217             'table_name' => array(
 218                 'link_param' => 'table',
 219                 'link_dependancy_params' => array(
 220                     0 => array(
 221                         'param_info' => 'db',
 222                         'column_name' => 'table_schema'
 223                     )
 224                 ),
 225                 'default_page' => $GLOBALS['cfg']['DefaultTabTable']
 226             )
 227         ),
 228         'processlist' => array(
 229             'db' => array(
 230                 'link_param' => 'db',
 231                 'default_page' => $GLOBALS['cfg']['DefaultTabDatabase']
 232             ),
 233             'user' => array(
 234                 'link_param' => 'username',
 235                 'link_dependancy_params' => array(
 236                     0 => array(
 237                         'param_info' => 'hostname',
 238                         'column_name' => 'host'
 239                     )
 240                 ),
 241                 'default_page' => 'server_privileges.php'
 242             )
 243         ),
 244         'referential_constraints' => array(
 245             'constraint_schema' => array(
 246                 'link_param' => 'db',
 247                 'default_page' => $GLOBALS['cfg']['DefaultTabDatabase']
 248             ),
 249             'unique_constraint_schema' => array(
 250                 'link_param' => 'db',
 251                 'default_page' => $GLOBALS['cfg']['DefaultTabDatabase']
 252             ),
 253             'table_name' => array(
 254                 'link_param' => 'table',
 255                 'link_dependancy_params' => array(
 256                     0 => array(
 257                         'param_info' => 'db',
 258                         'column_name' => 'constraint_schema'
 259                     )
 260                 ),
 261                 'default_page' => $GLOBALS['cfg']['DefaultTabTable']
 262             ),
 263             'referenced_table_name' => array(
 264                 'link_param' => 'table',
 265                 'link_dependancy_params' => array(
 266                     0 => array(
 267                         'param_info' => 'db',
 268                         'column_name' => 'constraint_schema'
 269                     )
 270                 ),
 271                 'default_page' => $GLOBALS['cfg']['DefaultTabTable']
 272             )
 273         ),
 274         'routines' => array(
 275             'routine_name' => array(
 276                 'link_param' => 'item_name',
 277                 'link_dependancy_params' => array(
 278                     0 => array(
 279                         'param_info' => 'db',
 280                         'column_name' => 'routine_schema'
 281                     ),
 282                     1 => array(
 283                         'param_info' => 'item_type',
 284                         'column_name' => 'routine_type'
 285                     )
 286                 ),
 287                 'default_page' => 'db_routines.php'
 288             ),
 289             'routine_schema' => array(
 290                 'link_param' => 'db',
 291                 'default_page' => $GLOBALS['cfg']['DefaultTabDatabase']
 292             ),
 293         ),
 294         'schemata' => array(
 295             'schema_name' => array(
 296                 'link_param' => 'db',
 297                 'default_page' => $GLOBALS['cfg']['DefaultTabDatabase']
 298             )
 299         ),
 300         'schema_privileges' => array(
 301             'table_schema' => array(
 302                 'link_param' => 'db',
 303                 'default_page' => $GLOBALS['cfg']['DefaultTabDatabase']
 304             )
 305         ),
 306         'statistics' => array(
 307             'table_schema' => array(
 308                 'link_param' => 'db',
 309                 'default_page' => $GLOBALS['cfg']['DefaultTabDatabase']
 310             ),
 311             'index_schema' => array(
 312                 'link_param' => 'db',
 313                 'default_page' => $GLOBALS['cfg']['DefaultTabDatabase']
 314             ),
 315             'table_name' => array(
 316                 'link_param' => 'table',
 317                 'link_dependancy_params' => array(
 318                     0 => array(
 319                         'param_info' => 'db',
 320                         'column_name' => 'table_schema'
 321                     )
 322                 ),
 323                 'default_page' => $GLOBALS['cfg']['DefaultTabTable']
 324             ),
 325             'column_name' => array(
 326                 'link_param' => array(
 327                     'sql_query',
 328                     'table_schema',
 329                     'table_name'
 330                 ),
 331                 'link_dependancy_params' => array(
 332                     0 => array(
 333                         'param_info' => 'db',
 334                         'column_name' => 'table_schema'
 335                     ),
 336                     1 => array(
 337                         'param_info' => 'table',
 338                         'column_name' => 'table_name'
 339                     )
 340                 ),
 341                 'default_page' => 'sql.php'
 342             )
 343         ),
 344         'tables' => array(
 345             'table_name' => array(
 346                 'link_param' => 'table',
 347                 'link_dependancy_params' => array(
 348                     0 => array(
 349                         'param_info' => 'db',
 350                         'column_name' => 'table_schema'
 351                     )
 352                 ),
 353                 'default_page' => $GLOBALS['cfg']['DefaultTabTable']
 354             ),
 355             'table_schema' => array(
 356                 'link_param' => 'db',
 357                 'default_page' => $GLOBALS['cfg']['DefaultTabDatabase']
 358             )
 359         ),
 360         'table_constraints' => array(
 361             'table_name' => array(
 362                 'link_param' => 'table',
 363                 'link_dependancy_params' => array(
 364                     0 => array(
 365                         'param_info' => 'db',
 366                         'column_name' => 'table_schema'
 367                     )
 368                 ),
 369                 'default_page' => $GLOBALS['cfg']['DefaultTabTable']
 370             ),
 371             'constraint_schema' => array(
 372                 'link_param' => 'db',
 373                 'default_page' => $GLOBALS['cfg']['DefaultTabDatabase']
 374             ),
 375             'table_schema' => array(
 376                 'link_param' => 'db',
 377                 'default_page' => $GLOBALS['cfg']['DefaultTabDatabase']
 378             )
 379         ),
 380         'table_privileges' => array(
 381             'table_schema' => array(
 382                 'link_param' => 'db',
 383                 'default_page' => $GLOBALS['cfg']['DefaultTabDatabase']
 384             )
 385         ),
 386         'triggers' => array(
 387             'trigger_schema' => array(
 388                 'link_param' => 'db',
 389                 'default_page' => $GLOBALS['cfg']['DefaultTabDatabase']
 390             ),
 391             'event_object_schema' => array(
 392                 'link_param' => 'db',
 393                 'default_page' => $GLOBALS['cfg']['DefaultTabDatabase']
 394             )
 395         ),
 396         'views' => array(
 397             'table_schema' => array(
 398                 'link_param' => 'db',
 399                 'default_page' => $GLOBALS['cfg']['DefaultTabDatabase']
 400             )
 401         )
 402     )
 403 );
 404
 405 ?>