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