phpmyadmin/libraries/information_schema_relations.lib.php

   1 <?php
   2 /* vim: set expandtab sw=4 ts=4 sts=4: */
   3 /**
   4  * Internal relations for information schema.
   5  *
   6  * @package PhpMyAdmin
   7  */
   8 if (! defined('PHPMYADMIN')) {
   9     exit;
  10 }
  11
  12 /**
  13  *
  14  */
  15 $GLOBALS['information_schema_relations'] = array(
  16     'CHARACTER_SETS' => array(
  17         'DEFAULT_COLLATE_NAME' => array(
  18             'foreign_db'    => 'information_schema',
  19             'foreign_table' => 'COLLATIONS',
  20             'foreign_field' => 'COLLATION_NAME'
  21         )
  22     ),
  23     'COLLATIONS' => array(
  24         'CHARACTER_SET_NAME' => array(
  25             'foreign_db'    => 'information_schema',
  26             'foreign_table' => 'CHARACTER_SETS',
  27             'foreign_field' => 'CHARACTER_SET_NAME'
  28         )
  29     ),
  30     'COLLATION_CHARACTER_SET_APPLICABILITY' => array(
  31         'CHARACTER_SET_NAME' => array(
  32             'foreign_db'    => 'information_schema',
  33             'foreign_table' => 'CHARACTER_SETS',
  34             'foreign_field' => 'CHARACTER_SET_NAME'
  35         ),
  36         'COLLATION_NAME' => array(
  37             'foreign_db'    => 'information_schema',
  38             'foreign_table' => 'COLLATIONS',
  39             'foreign_field' => 'COLLATION_NAME'
  40         )
  41     ),
  42     'COLUMNS' => array(
  43         'TABLE_SCHEMA' => array(
  44             'foreign_db'    => 'information_schema',
  45             'foreign_table' => 'SCHEMATA',
  46             'foreign_field' => 'SCHEMA_NAME'
  47         ),
  48         'CHARACTER_SET_NAME' => array(
  49             'foreign_db'    => 'information_schema',
  50             'foreign_table' => 'CHARACTER_SETS',
  51             'foreign_field' => 'CHARACTER_SET_NAME'
  52         ),
  53         'COLLATION_NAME' => array(
  54             'foreign_db'    => 'information_schema',
  55             'foreign_table' => 'COLLATIONS',
  56             'foreign_field' => 'COLLATION_NAME'
  57         )
  58     ),
  59     'COLUMN_PRIVILEGES' => array(
  60         'TABLE_SCHEMA' => array(
  61             'foreign_db'    => 'information_schema',
  62             'foreign_table' => 'SCHEMATA',
  63             'foreign_field' => 'SCHEMA_NAME'
  64         )
  65     ),
  66     'EVENTS' => array(
  67         'EVENT_SCHEMA' => array(
  68             'foreign_db'    => 'information_schema',
  69             'foreign_table' => 'SCHEMATA',
  70             'foreign_field' => 'SCHEMA_NAME'
  71         ),
  72         'CHARACTER_SET_CLIENT' => array(
  73             'foreign_db'    => 'information_schema',
  74             'foreign_table' => 'CHARACTER_SETS',
  75             'foreign_field' => 'CHARACTER_SET_NAME'
  76         ),
  77         'COLLATION_CONNECTION' => array(
  78             'foreign_db'    => 'information_schema',
  79             'foreign_table' => 'COLLATIONS',
  80             'foreign_field' => 'COLLATION_NAME'
  81         ),
  82         'DATABASE_COLLATION' => array(
  83             'foreign_db'    => 'information_schema',
  84             'foreign_table' => 'COLLATIONS',
  85             'foreign_field' => 'COLLATION_NAME'
  86         )
  87     ),
  88     'FILES' => array(
  89         'TABLESPACE_NAME' => array(
  90             'foreign_db'    => 'information_schema',
  91             'foreign_table' => 'TABLESPACES',
  92             'foreign_field' => 'TABLESPACE_NAME'
  93         ),
  94         'TABLE_SCHEMA' => array(
  95             'foreign_db'    => 'information_schema',
  96             'foreign_table' => 'SCHEMATA',
  97             'foreign_field' => 'SCHEMA_NAME'
  98         ),
  99         'COLLATION_CONNECTION' => array(
 100             'foreign_db'    => 'information_schema',
 101             'foreign_table' => 'COLLATIONS',
 102             'foreign_field' => 'COLLATION_NAME'
 103         ),
 104         'ENGINE' => array(
 105             'foreign_db'    => 'information_schema',
 106             'foreign_table' => 'ENGINES',
 107             'foreign_field' => 'ENGINE'
 108         )
 109     ),
 110     'KEY_COLUMN_USAGE' => 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         'REFERENCED_TABLE_SCHEMA' => array(
 122             'foreign_db'    => 'information_schema',
 123             'foreign_table' => 'SCHEMATA',
 124             'foreign_field' => 'SCHEMA_NAME'
 125         )
 126     ),
 127     'PARAMETERS' => array(
 128         'SPECIFIC_SCHEMA' => array(
 129             'foreign_db'    => 'information_schema',
 130             'foreign_table' => 'SCHEMATA',
 131             'foreign_field' => 'SCHEMA_NAME'
 132         ),
 133         'CHARACTER_SET_NAME' => array(
 134             'foreign_db'    => 'information_schema',
 135             'foreign_table' => 'CHARACTER_SETS',
 136             'foreign_field' => 'CHARACTER_SET_NAME'
 137         ),
 138         'COLLATION_NAME' => array(
 139             'foreign_db'    => 'information_schema',
 140             'foreign_table' => 'COLLATIONS',
 141             'foreign_field' => 'COLLATION_NAME'
 142         )
 143     ),
 144     'PARTITIONS' => array(
 145         'TABLE_SCHEMA' => array(
 146             'foreign_db'    => 'information_schema',
 147             'foreign_table' => 'SCHEMATA',
 148             'foreign_field' => 'SCHEMA_NAME'
 149         ),
 150         'TABLESPACE_NAME' => array(
 151             'foreign_db'    => 'information_schema',
 152             'foreign_table' => 'TABLESPACES',
 153             'foreign_field' => 'TABLESPACE_NAME'
 154         )
 155     ),
 156     'PROCESSLIST' => array(
 157         'DB' => array(
 158             'foreign_db'    => 'information_schema',
 159             'foreign_table' => 'SCHEMATA',
 160             'foreign_field' => 'SCHEMA_NAME'
 161         )
 162     ),
 163     'REFERENTIAL_CONSTRAINTS' => array(
 164         'CONSTRAINT_SCHEMA' => array(
 165             'foreign_db'    => 'information_schema',
 166             'foreign_table' => 'SCHEMATA',
 167             'foreign_field' => 'SCHEMA_NAME'
 168         ),
 169         'UNIQUE_CONSTRAINT_SCHEMA' => array(
 170             'foreign_db'    => 'information_schema',
 171             'foreign_table' => 'SCHEMATA',
 172             'foreign_field' => 'SCHEMA_NAME'
 173         )
 174     ),
 175     'ROUTINES' => array(
 176         'ROUTINE_SCHEMA' => array(
 177             'foreign_db'    => 'information_schema',
 178             'foreign_table' => 'SCHEMATA',
 179             'foreign_field' => 'SCHEMA_NAME'
 180         ),
 181         'CHARACTER_SET_NAME' => array(
 182             'foreign_db'    => 'information_schema',
 183             'foreign_table' => 'CHARACTER_SETS',
 184             'foreign_field' => 'CHARACTER_SET_NAME'
 185         ),
 186         'COLLATION_NAME' => array(
 187             'foreign_db'    => 'information_schema',
 188             'foreign_table' => 'COLLATIONS',
 189             'foreign_field' => 'COLLATION_NAME'
 190         ),
 191         'CHARACTER_SET_CLIENT' => array(
 192             'foreign_db'    => 'information_schema',
 193             'foreign_table' => 'CHARACTER_SETS',
 194             'foreign_field' => 'CHARACTER_SET_NAME'
 195         ),
 196         'COLLATION_CONNECTION' => array(
 197             'foreign_db'    => 'information_schema',
 198             'foreign_table' => 'COLLATIONS',
 199             'foreign_field' => 'COLLATION_NAME'
 200         ),
 201         'DATABASE_COLLATION' => array(
 202             'foreign_db'    => 'information_schema',
 203             'foreign_table' => 'COLLATIONS',
 204             'foreign_field' => 'COLLATION_NAME'
 205         )
 206     ),
 207     'SCHEMATA' => array(
 208         'DEFAULT_CHARACTER_SET_NAME' => array(
 209             'foreign_db'    => 'information_schema',
 210             'foreign_table' => 'CHARACTER_SETS',
 211             'foreign_field' => 'CHARACTER_SET_NAME'
 212         ),
 213         'DEFAULT_COLLATION_NAME' => array(
 214             'foreign_db'    => 'information_schema',
 215             'foreign_table' => 'COLLATIONS',
 216             'foreign_field' => 'COLLATION_NAME'
 217         )
 218     ),
 219     'SCHEMA_PRIVILEGES' => array(
 220         'TABLE_SCHEMA' => array(
 221             'foreign_db'    => 'information_schema',
 222             'foreign_table' => 'SCHEMATA',
 223             'foreign_field' => 'SCHEMA_NAME'
 224         )
 225     ),
 226     'STATISTICS' => array(
 227         'TABLE_SCHEMA' => array(
 228             'foreign_db'    => 'information_schema',
 229             'foreign_table' => 'SCHEMATA',
 230             'foreign_field' => 'SCHEMA_NAME'
 231         ),
 232         'INDEX_SCHEMA' => array(
 233             'foreign_db'    => 'information_schema',
 234             'foreign_table' => 'SCHEMATA',
 235             'foreign_field' => 'SCHEMA_NAME'
 236         )
 237     ),
 238     'TABLES' => array(
 239         'TABLE_SCHEMA' => array(
 240             'foreign_db'    => 'information_schema',
 241             'foreign_table' => 'SCHEMATA',
 242             'foreign_field' => 'SCHEMA_NAME'
 243         ),
 244         'TABLE_COLLATION' => array(
 245             'foreign_db'    => 'information_schema',
 246             'foreign_table' => 'COLLATIONS',
 247             'foreign_field' => 'COLLATION_NAME'
 248         ),
 249         'ENGINE' => array(
 250             'foreign_db'    => 'information_schema',
 251             'foreign_table' => 'ENGINES',
 252             'foreign_field' => 'ENGINE'
 253         ),
 254     ),
 255     'TABLESAPCES' => array(
 256         'ENGINE' => array(
 257             'foreign_db'    => 'information_schema',
 258             'foreign_table' => 'ENGINES',
 259             'foreign_field' => 'ENGINE'
 260         )
 261     ),
 262     'TABLE_CONSTRAINTS' => array(
 263         'CONSTRAINT_SCHEMA' => array(
 264             'foreign_db'    => 'information_schema',
 265             'foreign_table' => 'SCHEMATA',
 266             'foreign_field' => 'SCHEMA_NAME'
 267         ),
 268         'TABLE_SCHEMA' => array(
 269             'foreign_db'    => 'information_schema',
 270             'foreign_table' => 'SCHEMATA',
 271             'foreign_field' => 'SCHEMA_NAME'
 272         )
 273     ),
 274     'TABLE_PRIVILEGES' => array(
 275         'TABLE_SCHEMA' => array(
 276             'foreign_db'    => 'information_schema',
 277             'foreign_table' => 'SCHEMATA',
 278             'foreign_field' => 'SCHEMA_NAME'
 279         )
 280     ),
 281     'TRIGGERS' => array(
 282         'TRIGGER_SCHEMA' => array(
 283             'foreign_db'    => 'information_schema',
 284             'foreign_table' => 'SCHEMATA',
 285             'foreign_field' => 'SCHEMA_NAME'
 286         ),
 287         'EVENT_OBJECT_SCHEMA' => array(
 288             'foreign_db'    => 'information_schema',
 289             'foreign_table' => 'SCHEMATA',
 290             'foreign_field' => 'SCHEMA_NAME'
 291         ),
 292         'CHARACTER_SET_CLIENT' => array(
 293             'foreign_db'    => 'information_schema',
 294             'foreign_table' => 'CHARACTER_SETS',
 295             'foreign_field' => 'CHARACTER_SET_NAME'
 296         ),
 297         'COLLATION_CONNECTION' => array(
 298             'foreign_db'    => 'information_schema',
 299             'foreign_table' => 'COLLATIONS',
 300             'foreign_field' => 'COLLATION_NAME'
 301         ),
 302         'DATABASE_COLLATION' => array(
 303             'foreign_db'    => 'information_schema',
 304             'foreign_table' => 'COLLATIONS',
 305             'foreign_field' => 'COLLATION_NAME'
 306         )
 307     ),
 308     'VIEWS' => array(
 309         'TABLE_SCHEMA' => array(
 310             'foreign_db'    => 'information_schema',
 311             'foreign_table' => 'SCHEMATA',
 312             'foreign_field' => 'SCHEMA_NAME'
 313         ),
 314         'CHARACTER_SET_CLIENT' => array(
 315             'foreign_db'    => 'information_schema',
 316             'foreign_table' => 'CHARACTER_SETS',
 317             'foreign_field' => 'CHARACTER_SET_NAME'
 318         ),
 319         'COLLATION_CONNECTION' => array(
 320             'foreign_db'    => 'information_schema',
 321             'foreign_table' => 'COLLATIONS',
 322             'foreign_field' => 'COLLATION_NAME'
 323         )
 324     )
 325 );
 326