libraries/information_schema_relations.lib.php

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