home *** CD-ROM | disk | FTP | other *** search
/ Cricao de Sites - 650 Layouts Prontos / WebMasters.iso / Servidores / xampp-win32-1.6.7-installer.exe / phpMyAdmin / libraries / information_schema_relations.lib.php < prev    next >
Encoding:
PHP Script  |  2008-06-23  |  4.2 KB  |  136 lines
  1. <?php
  2. /* vim: set expandtab sw=4 ts=4 sts=4: */
  3. /**
  4.  *
  5.  * @version $Id: information_schema_relations.lib.php 10142 2007-03-20 10:32:13Z cybot_tm $
  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. ?>
  136.