phpmyadmin/libraries/special_schema_links.lib.php

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