libraries/data_dictionary_relations.lib.php

   1 <?php
   2 /* vim: set expandtab sw=4 ts=4 sts=4: */
   3 /**
   4  *
   5  * @package PhpMyAdmin
   6  */
   7
   8 /**
   9  *
  10  */
  11 $GLOBALS['data_dictionary_relations'] = array(
  12     'CHARACTER_SETS' => array(
  13         'DEFAULT_COLLATE_NAME' => array(
  14             'foreign_db'    => 'data_dictionary',
  15             'foreign_table' => 'COLLATIONS',
  16             'foreign_field' => 'COLLATION_NAME'
  17         )
  18     ),
  19     'COLLATIONS' => array(
  20         'CHARACTER_SET_NAME' => array(
  21             'foreign_db'    => 'data_dictionary',
  22             'foreign_table' => 'CHARACTER_SETS',
  23             'foreign_field' => 'CHARACTER_SET_NAME'
  24         )
  25     ),
  26     'COLUMNS' => array(
  27         'TABLE_SCHEMA' => array(
  28             'foreign_db'    => 'data_dictionary',
  29             'foreign_table' => 'SCHEMAS',
  30             'foreign_field' => 'SCHEMA_NAME'
  31         ),
  32         'COLLATION_NAME' => array(
  33             'foreign_db'    => 'data_dictionary',
  34             'foreign_table' => 'COLLATIONS',
  35             'foreign_field' => 'COLLATION_NAME'
  36         )
  37     ),
  38     'INDEXES' => array(
  39         'TABLE_SCHEMA' => array(
  40             'foreign_db'    => 'data_dictionary',
  41             'foreign_table' => 'SCHEMAS',
  42             'foreign_field' => 'SCHEMA_NAME'
  43         )
  44     ),
  45     'INDEX_PARTS' => array(
  46         'TABLE_SCHEMA' => array(
  47             'foreign_db'    => 'data_dictionary',
  48             'foreign_table' => 'SCHEMAS',
  49             'foreign_field' => 'SCHEMA_NAME'
  50         )
  51     ),
  52     'INNODB_LOCKS' => array(
  53         'LOCK_TRX_ID' => array(
  54             'foreign_db'    => 'data_dictionary',
  55             'foreign_table' => 'INNODB_TRX',
  56             'foreign_field' => 'TRX_ID'
  57         )
  58     ),
  59     'INNODB_LOCK_WAITS' => array(
  60         'REQUESTING_TRX_ID' => array(
  61             'foreign_db'    => 'data_dictionary',
  62             'foreign_table' => 'INNODB_TRX',
  63             'foreign_field' => 'TRX_ID'
  64         ),
  65         'REQUESTED_LOCK_ID' => array(
  66             'foreign_db'    => 'data_dictionary',
  67             'foreign_table' => 'INNODB_LOCKS',
  68             'foreign_field' => 'LOCK_ID'
  69         ),
  70         'BLOCKING_TRX_ID' => array(
  71             'foreign_db'    => 'data_dictionary',
  72             'foreign_table' => 'INNODB_TRX',
  73             'foreign_field' => 'TRX_ID'
  74         ),
  75         'BLOCKING_LOCK_ID' => array(
  76             'foreign_db'    => 'data_dictionary',
  77             'foreign_table' => 'INNODB_LOCKS',
  78             'foreign_field' => 'LOCK_ID'
  79         )
  80     ),
  81     'INNODB_SYS_COLUMNS' => array(
  82         'TABLE_ID' => array(
  83             'foreign_db'    => 'data_dictionary',
  84             'foreign_table' => 'INNODB_SYS_TABLES',
  85             'foreign_field' => 'TABLE_ID'
  86         )
  87     ),
  88     'INNODB_SYS_FIELDS' => array(
  89         'INDEX_ID' => array(
  90             'foreign_db'    => 'data_dictionary',
  91             'foreign_table' => 'INNODB_SYS_INDEXES',
  92             'foreign_field' => 'INDEX_ID'
  93         )
  94     ),
  95     'INNODB_SYS_INDEXES' => array(
  96         'TABLE_ID' => array(
  97             'foreign_db'    => 'data_dictionary',
  98             'foreign_table' => 'INNODB_SYS_TABLES',
  99             'foreign_field' => 'TABLE_ID'
 100         )
 101     ),
 102     'INNODB_SYS_TABLESTATS' => array(
 103         'TABLE_ID' => array(
 104             'foreign_db'    => 'data_dictionary',
 105             'foreign_table' => 'INNODB_SYS_TABLES',
 106             'foreign_field' => 'TABLE_ID'
 107         )
 108     ),
 109     'PLUGINS' => array(
 110         'MODULE_NAME' => array(
 111             'foreign_db'    => 'data_dictionary',
 112             'foreign_table' => 'MODULES',
 113             'foreign_field' => 'MODULE_NAME'
 114         )
 115     ),
 116     'SCHEMAS' => array(
 117         'DEFAULT_COLLATION_NAME' => array(
 118             'foreign_db'    => 'data_dictionary',
 119             'foreign_table' => 'COLLATIONS',
 120             'foreign_field' => 'COLLATION_NAME'
 121         )
 122     ),
 123     'TABLES' => array(
 124         'TABLE_SCHEMA' => array(
 125             'foreign_db'    => 'data_dictionary',
 126             'foreign_table' => 'SCHEMAS',
 127             'foreign_field' => 'SCHEMA_NAME'
 128         ),
 129         'TABLE_COLLATION' => array(
 130             'foreign_db'    => 'data_dictionary',
 131             'foreign_table' => 'COLLATIONS',
 132             'foreign_field' => 'COLLATION_NAME'
 133         )
 134     ),
 135     'TABLE_CACHE' => array(
 136         'TABLE_SCHEMA' => array(
 137             'foreign_db'    => 'data_dictionary',
 138             'foreign_table' => 'SCHEMAS',
 139             'foreign_field' => 'SCHEMA_NAME'
 140         )
 141     ),
 142     'TABLE_CONSTRAINTS' => array(
 143         'CONSTRAINT_SCHEMA' => array(
 144             'foreign_db'    => 'data_dictionary',
 145             'foreign_table' => 'SCHEMAS',
 146             'foreign_field' => 'SCHEMA_NAME'
 147         ),
 148         'TABLE_SCHEMA' => array(
 149             'foreign_db'    => 'data_dictionary',
 150             'foreign_table' => 'SCHEMAS',
 151             'foreign_field' => 'SCHEMA_NAME'
 152         )
 153     ),
 154     'TABLE_DEFINITION_CACHE' => array(
 155         'TABLE_SCHEMA' => array(
 156             'foreign_db'    => 'data_dictionary',
 157             'foreign_table' => 'SCHEMAS',
 158             'foreign_field' => 'SCHEMA_NAME'
 159         )
 160     )
 161 );
 162
 163 ?>