phpmyadmin/libraries/information_schema_relations.lib.php

   1 <?php
   2 /* vim: set expandtab sw=4 ts=4 sts=4: */
   3 /**
   4  *
   5  * @version $Id$
   6  */
   7
   8 /**
   9  *
  10  */
  11 $GLOBALS['information_schema_relations'] = array(
  12     'CHARACTER_SETS' => array(
  13         'DEFAULT_COLLATE_NAME' => array(
  14             'foreign_db'    => 'information_schema',
  15             'foreign_table' => 'COLLATIONS',
  16             'foreign_field' => 'COLLATION_NAME'
  17         )
  18     ),
  19     'COLLATIONS' => array(
  20         'CHARACTER_SET_NAME' => array(
  21             'foreign_db'    => 'information_schema',
  22             'foreign_table' => 'CHARACTER_SETS',
  23             'foreign_field' => 'CHARACTER_SET_NAME'
  24         )
  25     ),
  26     'COLLATION_CHARACTER_SET_APPLICABILITY' => array(
  27         'CHARACTER_SET_NAME' => array(
  28             'foreign_db'    => 'information_schema',
  29             'foreign_table' => 'CHARACTER_SETS',
  30             'foreign_field' => 'CHARACTER_SET_NAME'
  31         ),
  32         'COLLATION_NAME' => array(
  33             'foreign_db'    => 'information_schema',
  34             'foreign_table' => 'COLLATIONS',
  35             'foreign_field' => 'COLLATION_NAME'
  36         )
  37     ),
  38     'COLUMNS' => array(
  39         'TABLE_SCHEMA' => array(
  40             'foreign_db'    => 'information_schema',
  41             'foreign_table' => 'SCHEMATA',
  42             'foreign_field' => 'SCHEMA_NAME'
  43         ),
  44         'CHARACTER_SET_NAME' => array(
  45             'foreign_db'    => 'information_schema',
  46             'foreign_table' => 'CHARACTER_SETS',
  47             'foreign_field' => 'CHARACTER_SET_NAME'
  48         ),
  49         'COLLATION_NAME' => array(
  50             'foreign_db'    => 'information_schema',
  51             'foreign_table' => 'COLLATIONS',
  52             'foreign_field' => 'COLLATION_NAME'
  53         )
  54     ),
  55     'COLUMN_PRIVILEGES' => array(
  56         'TABLE_SCHEMA' => array(
  57             'foreign_db'    => 'information_schema',
  58             'foreign_table' => 'SCHEMATA',
  59             'foreign_field' => 'SCHEMA_NAME'
  60         )
  61     ),
  62     'KEY_COLUMN_USAGE' => array(
  63         'CONSTRAINT_SCHEMA' => array(
  64             'foreign_db'    => 'information_schema',
  65             'foreign_table' => 'SCHEMATA',
  66             'foreign_field' => 'SCHEMA_NAME'
  67         ),
  68         'TABLE_SCHEMA' => array(
  69             'foreign_db'    => 'information_schema',
  70             'foreign_table' => 'SCHEMATA',
  71             'foreign_field' => 'SCHEMA_NAME'
  72         )
  73     ),
  74     'ROUTINES' => array(
  75         'ROUTINE_SCHEMA' => array(
  76             'foreign_db'    => 'information_schema',
  77             'foreign_table' => 'SCHEMATA',
  78             'foreign_field' => 'SCHEMA_NAME'
  79         )
  80     ),
  81     'SCHEMATA' => array(
  82         'DEFAULT_CHARACTER_SET_NAME' => array(
  83             'foreign_db'    => 'information_schema',
  84             'foreign_table' => 'CHARACTER_SETS',
  85             'foreign_field' => 'CHARACTER_SET_NAME'
  86         )
  87     ),
  88     'SCHEMA_PRIVILEGES' => array(
  89         'TABLE_SCHEMA' => array(
  90             'foreign_db'    => 'information_schema',
  91             'foreign_table' => 'SCHEMATA',
  92             'foreign_field' => 'SCHEMA_NAME'
  93         )
  94     ),
  95     'TABLES' => array(
  96         'TABLE_SCHEMA' => array(
  97             'foreign_db'    => 'information_schema',
  98             'foreign_table' => 'SCHEMATA',
  99             'foreign_field' => 'SCHEMA_NAME'
 100         ),
 101         'TABLE_COLLATION' => array(
 102             'foreign_db'    => 'information_schema',
 103             'foreign_table' => 'COLLATIONS',
 104             'foreign_field' => 'COLLATION_NAME'
 105         )
 106     ),
 107     'TABLE_CONSTRAINTS' => array(
 108         'CONSTRAINT_SCHEMA' => array(
 109             'foreign_db'    => 'information_schema',
 110             'foreign_table' => 'SCHEMATA',
 111             'foreign_field' => 'SCHEMA_NAME'
 112         ),
 113         'TABLE_SCHEMA' => array(
 114             'foreign_db'    => 'information_schema',
 115             'foreign_table' => 'SCHEMATA',
 116             'foreign_field' => 'SCHEMA_NAME'
 117         )
 118     ),
 119     'TABLE_PRIVILEGES' => array(
 120         'TABLE_SCHEMA' => array(
 121             'foreign_db'    => 'information_schema',
 122             'foreign_table' => 'SCHEMATA',
 123             'foreign_field' => 'SCHEMA_NAME'
 124         )
 125     ),
 126     'VIEWS' => array(
 127         'TABLE_SCHEMA' => array(
 128             'foreign_db'    => 'information_schema',
 129             'foreign_table' => 'SCHEMATA',
 130             'foreign_field' => 'SCHEMA_NAME'
 131         )
 132     )
 133 );
 134
 135 ?>