phpmyadmin/libraries/data_dictionary_relations.lib.php

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