[Sommaire] [Imprimer]

   1  <?php
   2  /* $Id: information_schema_relations.lib.php 6836 2005-03-27 23:26:00Z rabus $ */
   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  ?>