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