libraries/information_schema_relations.lib.php

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