libraries/mysql_relations.lib.php

   1 <?php
   2 /* vim: set expandtab sw=4 ts=4 sts=4: */
   3 /**
   4  * Internal relations for mysql database.
   5  *
   6  * @package PhpMyAdmin
   7  */
   8 if (! defined('PHPMYADMIN')) {
   9     exit;
  10 }
  11
  12 /**
  13  * Internal relations for mysql database.
  14  */
  15 $GLOBALS['mysql_relations'] = array(
  16     'columns_priv' => array(
  17         'Db' => array(
  18             'foreign_db'    => 'information_schema',
  19             'foreign_table' => 'SCHEMATA',
  20             'foreign_field' => 'SCHEMA_NAME'
  21         ),
  22     ),
  23     'db' => array(
  24         'Db' => array(
  25             'foreign_db'    => 'information_schema',
  26             'foreign_table' => 'SCHEMATA',
  27             'foreign_field' => 'SCHEMA_NAME'
  28         ),
  29     ),
  30     'event' => array(
  31         'db' => array(
  32             'foreign_db'    => 'information_schema',
  33             'foreign_table' => 'SCHEMATA',
  34             'foreign_field' => 'SCHEMA_NAME'
  35         ),
  36         'character_set_client' => array(
  37             'foreign_db'    => 'information_schema',
  38             'foreign_table' => 'CHARACTER_SETS',
  39             'foreign_field' => 'CHARACTER_SET_NAME'
  40         ),
  41         'collation_connection' => array(
  42             'foreign_db'    => 'information_schema',
  43             'foreign_table' => 'COLLATIONS',
  44             'foreign_field' => 'COLLATION_NAME'
  45         ),
  46         'db_collation' => array(
  47             'foreign_db'    => 'information_schema',
  48             'foreign_table' => 'COLLATIONS',
  49             'foreign_field' => 'COLLATION_NAME'
  50         ),
  51     ),
  52     'help_category' => array(
  53         'parent_category_id' => array(
  54             'foreign_db'    => 'mysql',
  55             'foreign_table' => 'help_category',
  56             'foreign_field' => 'help_category_id'
  57         ),
  58     ),
  59     'help_relation' => array(
  60         'help_topic_id' => array(
  61             'foreign_db'    => 'mysql',
  62             'foreign_table' => 'help_topic',
  63             'foreign_field' => 'help_topic_id'
  64         ),
  65         'help_keyword_id' => array(
  66             'foreign_db'    => 'mysql',
  67             'foreign_table' => 'help_keyword',
  68             'foreign_field' => 'help_keyword_id'
  69         ),
  70     ),
  71     'help_topic' => array(
  72         'help_category_id' => array(
  73             'foreign_db'    => 'mysql',
  74             'foreign_table' => 'help_category',
  75             'foreign_field' => 'help_category_id'
  76         ),
  77     ),
  78     'innodb_index_stats' => array(
  79         'database_name' => array(
  80             'foreign_db'    => 'information_schema',
  81             'foreign_table' => 'SCHEMATA',
  82             'foreign_field' => 'SCHEMA_NAME'
  83         ),
  84     ),
  85     'innodb_table_stats' => array(
  86         'database_name' => array(
  87             'foreign_db'    => 'information_schema',
  88             'foreign_table' => 'SCHEMATA',
  89             'foreign_field' => 'SCHEMA_NAME'
  90         ),
  91     ),
  92     'proc' => array(
  93         'db' => array(
  94             'foreign_db'    => 'information_schema',
  95             'foreign_table' => 'SCHEMATA',
  96             'foreign_field' => 'SCHEMA_NAME'
  97         ),
  98         'character_set_client' => array(
  99             'foreign_db'    => 'information_schema',
 100             'foreign_table' => 'CHARACTER_SETS',
 101             'foreign_field' => 'CHARACTER_SET_NAME'
 102         ),
 103         'collation_connection' => array(
 104             'foreign_db'    => 'information_schema',
 105             'foreign_table' => 'COLLATIONS',
 106             'foreign_field' => 'COLLATION_NAME'
 107         ),
 108         'db_collation' => array(
 109             'foreign_db'    => 'information_schema',
 110             'foreign_table' => 'COLLATIONS',
 111             'foreign_field' => 'COLLATION_NAME'
 112         ),
 113     ),
 114     'proc_priv' => array(
 115         'Db' => array(
 116             'foreign_db'    => 'information_schema',
 117             'foreign_table' => 'SCHEMATA',
 118             'foreign_field' => 'SCHEMA_NAME'
 119         ),
 120     ),
 121     'servers' => array(
 122         'Db' => array(
 123             'foreign_db'    => 'information_schema',
 124             'foreign_table' => 'SCHEMATA',
 125             'foreign_field' => 'SCHEMA_NAME'
 126         ),
 127     ),
 128     'slow_log' => array(
 129         'db' => array(
 130             'foreign_db'    => 'information_schema',
 131             'foreign_table' => 'SCHEMATA',
 132             'foreign_field' => 'SCHEMA_NAME'
 133         ),
 134     ),
 135     'tables_priv' => array(
 136         'Db' => array(
 137             'foreign_db'    => 'information_schema',
 138             'foreign_table' => 'SCHEMATA',
 139             'foreign_field' => 'SCHEMA_NAME'
 140         ),
 141     ),
 142     'time_zone_name' => array(
 143         'Time_zone_id' => array(
 144             'foreign_db'    => 'mysql',
 145             'foreign_table' => 'time_zone',
 146             'foreign_field' => 'Time_zone_id'
 147         ),
 148     ),
 149     'time_zone_transition' => array(
 150         'Time_zone_id' => array(
 151             'foreign_db'    => 'mysql',
 152             'foreign_table' => 'time_zone',
 153             'foreign_field' => 'Time_zone_id'
 154         ),
 155         'Transition_time' => array(
 156             'foreign_db'    => 'mysql',
 157             'foreign_table' => 'time_zone_leap_second',
 158             'foreign_field' => 'Transition_time'
 159         )
 160     ),
 161     'time_zone_transition_type' => array(
 162         'Time_zone_id' => array(
 163             'foreign_db'    => 'mysql',
 164             'foreign_table' => 'time_zone',
 165             'foreign_field' => 'Time_zone_id'
 166         ),
 167     ),
 168 );
 169 ?>