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