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         'columns_priv' => array(
  50             'user' => array(
  51                 'link_param' => 'username',
  52                 'link_dependancy_params' => array(
  53                     0 => array(
  54                         'param_info' => 'hostname',
  55                         'column_name' => 'host'
  56                     )
  57                 ),
  58                 'default_page' => 'server_privileges.php'
  59             ),
  60             'table_name' => array(
  61                 'link_param' => 'table',
  62                 'link_dependancy_params' => array(
  63                     0 => array(
  64                         'param_info' => 'db',
  65                         'column_name' => 'Db'
  66                     ),
  67                 ),
  68                 'default_page' => PMA_Util::getScriptNameForOption(
  69                     $GLOBALS['cfg']['DefaultTabTable'], 'table'
  70                 )
  71             ),
  72             'column_name' => array(
  73                 'link_param' => 'field',
  74                 'link_dependancy_params' => array(
  75                     0 => array(
  76                         'param_info' => 'db',
  77                         'column_name' => 'Db'
  78                     ),
  79                     1 => array(
  80                         'param_info' => 'table',
  81                         'column_name' => 'Table_name'
  82                     )
  83                 ),
  84                 'default_page' => 'tbl_structure.php?change_column=1'
  85             ),
  86         ),
  87         'db' => array(
  88             'user' => array(
  89                 'link_param' => 'username',
  90                 'link_dependancy_params' => array(
  91                     0 => array(
  92                         'param_info' => 'hostname',
  93                         'column_name' => 'host'
  94                     )
  95                 ),
  96                 'default_page' => 'server_privileges.php'
  97             )
  98         ),
  99         'event' => array(
 100             'name' => array(
 101                 'link_param' => 'item_name',
 102                 'link_dependancy_params' => array(
 103                     0 => array(
 104                         'param_info' => 'db',
 105                         'column_name' => 'db'
 106                     )
 107                 ),
 108                 'default_page' => 'db_events.php?edit_item=1'
 109             ),
 110
 111         ),
 112         'innodb_index_stats' => array(
 113             'table_name' => array(
 114                 'link_param' => 'table',
 115                 'link_dependancy_params' => array(
 116                     0 => array(
 117                         'param_info' => 'db',
 118                         'column_name' => 'database_name'
 119                     ),
 120                 ),
 121                 'default_page' => PMA_Util::getScriptNameForOption(
 122                     $GLOBALS['cfg']['DefaultTabTable'], 'table'
 123                 )
 124             ),
 125             'index_name' => array(
 126                 'link_param' => 'index',
 127                 'link_dependancy_params' => array(
 128                     0 => array(
 129                         'param_info' => 'db',
 130                         'column_name' => 'database_name'
 131                     ),
 132                     1 => array(
 133                         'param_info' => 'table',
 134                         'column_name' => 'table_name'
 135                     )
 136                 ),
 137                 'default_page' => 'tbl_structure.php'
 138             ),
 139         ),
 140         'innodb_table_stats' => array(
 141             'table_name' => array(
 142                 'link_param' => 'table',
 143                 'link_dependancy_params' => array(
 144                     0 => array(
 145                         'param_info' => 'db',
 146                         'column_name' => 'database_name'
 147                     ),
 148                 ),
 149                 'default_page' => PMA_Util::getScriptNameForOption(
 150                     $GLOBALS['cfg']['DefaultTabTable'], 'table'
 151                 )
 152             ),
 153         ),
 154         'proc' => array(
 155             'name' => array(
 156                 'link_param' => 'item_name',
 157                 'link_dependancy_params' => array(
 158                     0 => array(
 159                         'param_info' => 'db',
 160                         'column_name' => 'db'
 161                     ),
 162                     1 => array(
 163                         'param_info' => 'item_type',
 164                         'column_name' => 'type'
 165                     )
 166                 ),
 167                 'default_page' => 'db_routines.php?edit_item=1'
 168             ),
 169             'specific_name' => array(
 170                 'link_param' => 'item_name',
 171                 'link_dependancy_params' => array(
 172                     0 => array(
 173                         'param_info' => 'db',
 174                         'column_name' => 'db'
 175                     ),
 176                     1 => array(
 177                         'param_info' => 'item_type',
 178                         'column_name' => 'type'
 179                     )
 180                 ),
 181                 'default_page' => 'db_routines.php?edit_item=1'
 182             ),
 183         ),
 184         'proc_priv' => array(
 185             'user' => array(
 186                 'link_param' => 'username',
 187                 'link_dependancy_params' => array(
 188                     0 => array(
 189                         'param_info' => 'hostname',
 190                         'column_name' => 'Host'
 191                     )
 192                 ),
 193                 'default_page' => 'server_privileges.php'
 194             ),
 195             'routine_name' => array(
 196                 'link_param' => 'item_name',
 197                 'link_dependancy_params' => array(
 198                     0 => array(
 199                         'param_info' => 'db',
 200                         'column_name' => 'Db'
 201                     ),
 202                     1 => array(
 203                         'param_info' => 'item_type',
 204                         'column_name' => 'Routine_type'
 205                     )
 206                 ),
 207                 'default_page' => 'db_routines.php?edit_item=1'
 208             ),
 209         ),
 210         'proxies_priv' => array(
 211             'user' => array(
 212                 'link_param' => 'username',
 213                 'link_dependancy_params' => array(
 214                     0 => array(
 215                         'param_info' => 'hostname',
 216                         'column_name' => 'Host'
 217                     )
 218                 ),
 219                 'default_page' => 'server_privileges.php'
 220             ),
 221         ),
 222         'tables_priv' => array(
 223             'user' => array(
 224                 'link_param' => 'username',
 225                 'link_dependancy_params' => array(
 226                     0 => array(
 227                         'param_info' => 'hostname',
 228                         'column_name' => 'Host'
 229                     )
 230                 ),
 231                 'default_page' => 'server_privileges.php'
 232             ),
 233             'table_name' => array(
 234                 'link_param' => 'table',
 235                 'link_dependancy_params' => array(
 236                     0 => array(
 237                         'param_info' => 'db',
 238                         'column_name' => 'Db'
 239                     ),
 240                 ),
 241                 'default_page' => PMA_Util::getScriptNameForOption(
 242                     $GLOBALS['cfg']['DefaultTabTable'], 'table'
 243                 )
 244             ),
 245         ),
 246         'user' => array(
 247             'user' => array(
 248                 'link_param' => 'username',
 249                 'link_dependancy_params' => array(
 250                     0 => array(
 251                         'param_info' => 'hostname',
 252                         'column_name' => 'host'
 253                     )
 254                 ),
 255                 'default_page' => 'server_privileges.php'
 256             )
 257         )
 258     ),
 259     'information_schema' => array(
 260         'columns' => array(
 261             'table_name' => array(
 262                 'link_param' => 'table',
 263                 'link_dependancy_params' => array(
 264                     0 => array(
 265                         'param_info' => 'db',
 266                         'column_name' => 'table_schema'
 267                     )
 268                 ),
 269                 'default_page' => PMA_Util::getScriptNameForOption(
 270                     $GLOBALS['cfg']['DefaultTabTable'], 'table'
 271                 )
 272             ),
 273             'column_name' => array(
 274                 'link_param' => 'field',
 275                 'link_dependancy_params' => array(
 276                     0 => array(
 277                         'param_info' => 'db',
 278                         'column_name' => 'table_schema'
 279                     ),
 280                     1 => array(
 281                         'param_info' => 'table',
 282                         'column_name' => 'table_name'
 283                     )
 284                 ),
 285                 'default_page' => 'tbl_structure.php?change_column=1'
 286             )
 287         ),
 288         'key_column_usage' => array(
 289             'table_name' => array(
 290                 'link_param' => 'table',
 291                 'link_dependancy_params' => array(
 292                     0 => array(
 293                         'param_info' => 'db',
 294                         'column_name' => 'constraint_schema'
 295                     )
 296                 ),
 297                 'default_page' => PMA_Util::getScriptNameForOption(
 298                     $GLOBALS['cfg']['DefaultTabTable'], 'table'
 299                 )
 300             ),
 301             'column_name' => array(
 302                 'link_param' => 'field',
 303                 'link_dependancy_params' => array(
 304                     0 => array(
 305                         'param_info' => 'db',
 306                         'column_name' => 'table_schema'
 307                     ),
 308                     1 => array(
 309                         'param_info' => 'table',
 310                         'column_name' => 'table_name'
 311                     )
 312                 ),
 313                 'default_page' => 'tbl_structure.php?change_column=1'
 314             ),
 315             'referenced_table_name' => array(
 316                 'link_param' => 'table',
 317                 'link_dependancy_params' => array(
 318                     0 => array(
 319                         'param_info' => 'db',
 320                         'column_name' => 'referenced_table_schema'
 321                     )
 322                 ),
 323                 'default_page' => PMA_Util::getScriptNameForOption(
 324                     $GLOBALS['cfg']['DefaultTabTable'], 'table'
 325                 )
 326             ),
 327             'referenced_column_name' => array(
 328                 'link_param' => 'field',
 329                 'link_dependancy_params' => array(
 330                     0 => array(
 331                         'param_info' => 'db',
 332                         'column_name' => 'referenced_table_schema'
 333                     ),
 334                     1 => array(
 335                         'param_info' => 'table',
 336                         'column_name' => 'referenced_table_name'
 337                     )
 338                 ),
 339                 'default_page' => 'tbl_structure.php?change_column=1'
 340             )
 341         ),
 342         'partitions' => array(
 343             'table_name' => array(
 344                 'link_param' => 'table',
 345                 'link_dependancy_params' => array(
 346                     0 => array(
 347                         'param_info' => 'db',
 348                         'column_name' => 'table_schema'
 349                     )
 350                 ),
 351                 'default_page' => PMA_Util::getScriptNameForOption(
 352                     $GLOBALS['cfg']['DefaultTabTable'], 'table'
 353                 )
 354             )
 355         ),
 356         'processlist' => array(
 357             'user' => array(
 358                 'link_param' => 'username',
 359                 'link_dependancy_params' => array(
 360                     0 => array(
 361                         'param_info' => 'hostname',
 362                         'column_name' => 'host'
 363                     )
 364                 ),
 365                 'default_page' => 'server_privileges.php'
 366             )
 367         ),
 368         'referential_constraints' => array(
 369             'table_name' => array(
 370                 'link_param' => 'table',
 371                 'link_dependancy_params' => array(
 372                     0 => array(
 373                         'param_info' => 'db',
 374                         'column_name' => 'constraint_schema'
 375                     )
 376                 ),
 377                 'default_page' => PMA_Util::getScriptNameForOption(
 378                     $GLOBALS['cfg']['DefaultTabTable'], 'table'
 379                 )
 380             ),
 381             'referenced_table_name' => array(
 382                 'link_param' => 'table',
 383                 'link_dependancy_params' => array(
 384                     0 => array(
 385                         'param_info' => 'db',
 386                         'column_name' => 'constraint_schema'
 387                     )
 388                 ),
 389                 'default_page' => PMA_Util::getScriptNameForOption(
 390                     $GLOBALS['cfg']['DefaultTabTable'], 'table'
 391                 )
 392             )
 393         ),
 394         'routines' => array(
 395             'routine_name' => array(
 396                 'link_param' => 'item_name',
 397                 'link_dependancy_params' => array(
 398                     0 => array(
 399                         'param_info' => 'db',
 400                         'column_name' => 'routine_schema'
 401                     ),
 402                     1 => array(
 403                         'param_info' => 'item_type',
 404                         'column_name' => 'routine_type'
 405                     )
 406                 ),
 407                 'default_page' => 'db_routines.php'
 408             ),
 409         ),
 410         'schemata' => array(
 411             'schema_name' => array(
 412                 'link_param' => 'db',
 413                 'default_page' => PMA_Util::getScriptNameForOption(
 414                     $GLOBALS['cfg']['DefaultTabTable'], 'table'
 415                 )
 416             )
 417         ),
 418         'statistics' => array(
 419             'table_name' => array(
 420                 'link_param' => 'table',
 421                 'link_dependancy_params' => array(
 422                     0 => array(
 423                         'param_info' => 'db',
 424                         'column_name' => 'table_schema'
 425                     )
 426                 ),
 427                 'default_page' => PMA_Util::getScriptNameForOption(
 428                     $GLOBALS['cfg']['DefaultTabTable'], 'table'
 429                 )
 430             ),
 431             'column_name' => array(
 432                 'link_param' => 'field',
 433                 'link_dependancy_params' => array(
 434                     0 => array(
 435                         'param_info' => 'db',
 436                         'column_name' => 'table_schema'
 437                     ),
 438                     1 => array(
 439                         'param_info' => 'table',
 440                         'column_name' => 'table_name'
 441                     )
 442                 ),
 443                 'default_page' => 'tbl_structure.php?change_column=1'
 444             )
 445         ),
 446         'tables' => array(
 447             'table_name' => array(
 448                 'link_param' => 'table',
 449                 'link_dependancy_params' => array(
 450                     0 => array(
 451                         'param_info' => 'db',
 452                         'column_name' => 'table_schema'
 453                     )
 454                 ),
 455                 'default_page' => PMA_Util::getScriptNameForOption(
 456                     $GLOBALS['cfg']['DefaultTabTable'], 'table'
 457                 )
 458             ),
 459         ),
 460         'table_constraints' => array(
 461             'table_name' => array(
 462                 'link_param' => 'table',
 463                 'link_dependancy_params' => array(
 464                     0 => array(
 465                         'param_info' => 'db',
 466                         'column_name' => 'table_schema'
 467                     )
 468                 ),
 469                 'default_page' => PMA_Util::getScriptNameForOption(
 470                     $GLOBALS['cfg']['DefaultTabTable'], 'table'
 471                 )
 472             ),
 473         ),
 474         'views' => array(
 475             'table_name' => array(
 476                 'link_param' => 'table',
 477                 'link_dependancy_params' => array(
 478                     0 => array(
 479                         'param_info' => 'db',
 480                         'column_name' => 'table_schema'
 481                     )
 482                 ),
 483                 'default_page' => PMA_Util::getScriptNameForOption(
 484                     $GLOBALS['cfg']['DefaultTabTable'], 'table'
 485                 )
 486             ),
 487         ),
 488     )
 489 );
 490