src/InternalRelations.php

   1 <?php
   2 /**
   3  * Internal relations for information schema and mysql databases.
   4  */
   5
   6 declare(strict_types=1);
   7
   8 namespace PhpMyAdmin;
   9
  10 /**
  11  * Internal relations for information schema and mysql databases.
  12  */
  13 class InternalRelations
  14 {
  15     public const INFORMATION_SCHEMA = [
  16         'CHARACTER_SETS' => [
  17             'DEFAULT_COLLATE_NAME' => [
  18                 'foreign_db' => 'information_schema',
  19                 'foreign_table' => 'COLLATIONS',
  20                 'foreign_field' => 'COLLATION_NAME',
  21             ],
  22         ],
  23         'COLLATIONS' => [
  24             'CHARACTER_SET_NAME' => [
  25                 'foreign_db' => 'information_schema',
  26                 'foreign_table' => 'CHARACTER_SETS',
  27                 'foreign_field' => 'CHARACTER_SET_NAME',
  28             ],
  29         ],
  30         'COLLATION_CHARACTER_SET_APPLICABILITY' => [
  31             'CHARACTER_SET_NAME' => [
  32                 'foreign_db' => 'information_schema',
  33                 'foreign_table' => 'CHARACTER_SETS',
  34                 'foreign_field' => 'CHARACTER_SET_NAME',
  35             ],
  36             'COLLATION_NAME' => [
  37                 'foreign_db' => 'information_schema',
  38                 'foreign_table' => 'COLLATIONS',
  39                 'foreign_field' => 'COLLATION_NAME',
  40             ],
  41         ],
  42         'COLUMNS' => [
  43             'TABLE_SCHEMA' => [
  44                 'foreign_db' => 'information_schema',
  45                 'foreign_table' => 'SCHEMATA',
  46                 'foreign_field' => 'SCHEMA_NAME',
  47             ],
  48             'CHARACTER_SET_NAME' => [
  49                 'foreign_db' => 'information_schema',
  50                 'foreign_table' => 'CHARACTER_SETS',
  51                 'foreign_field' => 'CHARACTER_SET_NAME',
  52             ],
  53             'COLLATION_NAME' => [
  54                 'foreign_db' => 'information_schema',
  55                 'foreign_table' => 'COLLATIONS',
  56                 'foreign_field' => 'COLLATION_NAME',
  57             ],
  58         ],
  59         'COLUMN_PRIVILEGES' => [
  60             'TABLE_SCHEMA' => [
  61                 'foreign_db' => 'information_schema',
  62                 'foreign_table' => 'SCHEMATA',
  63                 'foreign_field' => 'SCHEMA_NAME',
  64             ],
  65         ],
  66         'EVENTS' => [
  67             'EVENT_SCHEMA' => [
  68                 'foreign_db' => 'information_schema',
  69                 'foreign_table' => 'SCHEMATA',
  70                 'foreign_field' => 'SCHEMA_NAME',
  71             ],
  72             'CHARACTER_SET_CLIENT' => [
  73                 'foreign_db' => 'information_schema',
  74                 'foreign_table' => 'CHARACTER_SETS',
  75                 'foreign_field' => 'CHARACTER_SET_NAME',
  76             ],
  77             'COLLATION_CONNECTION' => [
  78                 'foreign_db' => 'information_schema',
  79                 'foreign_table' => 'COLLATIONS',
  80                 'foreign_field' => 'COLLATION_NAME',
  81             ],
  82             'DATABASE_COLLATION' => [
  83                 'foreign_db' => 'information_schema',
  84                 'foreign_table' => 'COLLATIONS',
  85                 'foreign_field' => 'COLLATION_NAME',
  86             ],
  87         ],
  88         'FILES' => [
  89             'TABLESPACE_NAME' => [
  90                 'foreign_db' => 'information_schema',
  91                 'foreign_table' => 'TABLESPACES',
  92                 'foreign_field' => 'TABLESPACE_NAME',
  93             ],
  94             'TABLE_SCHEMA' => [
  95                 'foreign_db' => 'information_schema',
  96                 'foreign_table' => 'SCHEMATA',
  97                 'foreign_field' => 'SCHEMA_NAME',
  98             ],
  99             'COLLATION_CONNECTION' => [
 100                 'foreign_db' => 'information_schema',
 101                 'foreign_table' => 'COLLATIONS',
 102                 'foreign_field' => 'COLLATION_NAME',
 103             ],
 104             'ENGINE' => [
 105                 'foreign_db' => 'information_schema',
 106                 'foreign_table' => 'ENGINES',
 107                 'foreign_field' => 'ENGINE',
 108             ],
 109         ],
 110         'KEY_COLUMN_USAGE' => [
 111             'CONSTRAINT_SCHEMA' => [
 112                 'foreign_db' => 'information_schema',
 113                 'foreign_table' => 'SCHEMATA',
 114                 'foreign_field' => 'SCHEMA_NAME',
 115             ],
 116             'TABLE_SCHEMA' => [
 117                 'foreign_db' => 'information_schema',
 118                 'foreign_table' => 'SCHEMATA',
 119                 'foreign_field' => 'SCHEMA_NAME',
 120             ],
 121             'REFERENCED_TABLE_SCHEMA' => [
 122                 'foreign_db' => 'information_schema',
 123                 'foreign_table' => 'SCHEMATA',
 124                 'foreign_field' => 'SCHEMA_NAME',
 125             ],
 126         ],
 127         'PARAMETERS' => [
 128             'SPECIFIC_SCHEMA' => [
 129                 'foreign_db' => 'information_schema',
 130                 'foreign_table' => 'SCHEMATA',
 131                 'foreign_field' => 'SCHEMA_NAME',
 132             ],
 133             'CHARACTER_SET_NAME' => [
 134                 'foreign_db' => 'information_schema',
 135                 'foreign_table' => 'CHARACTER_SETS',
 136                 'foreign_field' => 'CHARACTER_SET_NAME',
 137             ],
 138             'COLLATION_NAME' => [
 139                 'foreign_db' => 'information_schema',
 140                 'foreign_table' => 'COLLATIONS',
 141                 'foreign_field' => 'COLLATION_NAME',
 142             ],
 143         ],
 144         'PARTITIONS' => [
 145             'TABLE_SCHEMA' => [
 146                 'foreign_db' => 'information_schema',
 147                 'foreign_table' => 'SCHEMATA',
 148                 'foreign_field' => 'SCHEMA_NAME',
 149             ],
 150             'TABLESPACE_NAME' => [
 151                 'foreign_db' => 'information_schema',
 152                 'foreign_table' => 'TABLESPACES',
 153                 'foreign_field' => 'TABLESPACE_NAME',
 154             ],
 155         ],
 156         'PROCESSLIST' => [
 157             'DB' => [
 158                 'foreign_db' => 'information_schema',
 159                 'foreign_table' => 'SCHEMATA',
 160                 'foreign_field' => 'SCHEMA_NAME',
 161             ],
 162         ],
 163         'REFERENTIAL_CONSTRAINTS' => [
 164             'CONSTRAINT_SCHEMA' => [
 165                 'foreign_db' => 'information_schema',
 166                 'foreign_table' => 'SCHEMATA',
 167                 'foreign_field' => 'SCHEMA_NAME',
 168             ],
 169             'UNIQUE_CONSTRAINT_SCHEMA' => [
 170                 'foreign_db' => 'information_schema',
 171                 'foreign_table' => 'SCHEMATA',
 172                 'foreign_field' => 'SCHEMA_NAME',
 173             ],
 174         ],
 175         'ROUTINES' => [
 176             'ROUTINE_SCHEMA' => [
 177                 'foreign_db' => 'information_schema',
 178                 'foreign_table' => 'SCHEMATA',
 179                 'foreign_field' => 'SCHEMA_NAME',
 180             ],
 181             'CHARACTER_SET_NAME' => [
 182                 'foreign_db' => 'information_schema',
 183                 'foreign_table' => 'CHARACTER_SETS',
 184                 'foreign_field' => 'CHARACTER_SET_NAME',
 185             ],
 186             'COLLATION_NAME' => [
 187                 'foreign_db' => 'information_schema',
 188                 'foreign_table' => 'COLLATIONS',
 189                 'foreign_field' => 'COLLATION_NAME',
 190             ],
 191             'CHARACTER_SET_CLIENT' => [
 192                 'foreign_db' => 'information_schema',
 193                 'foreign_table' => 'CHARACTER_SETS',
 194                 'foreign_field' => 'CHARACTER_SET_NAME',
 195             ],
 196             'COLLATION_CONNECTION' => [
 197                 'foreign_db' => 'information_schema',
 198                 'foreign_table' => 'COLLATIONS',
 199                 'foreign_field' => 'COLLATION_NAME',
 200             ],
 201             'DATABASE_COLLATION' => [
 202                 'foreign_db' => 'information_schema',
 203                 'foreign_table' => 'COLLATIONS',
 204                 'foreign_field' => 'COLLATION_NAME',
 205             ],
 206         ],
 207         'SCHEMATA' => [
 208             'DEFAULT_CHARACTER_SET_NAME' => [
 209                 'foreign_db' => 'information_schema',
 210                 'foreign_table' => 'CHARACTER_SETS',
 211                 'foreign_field' => 'CHARACTER_SET_NAME',
 212             ],
 213             'DEFAULT_COLLATION_NAME' => [
 214                 'foreign_db' => 'information_schema',
 215                 'foreign_table' => 'COLLATIONS',
 216                 'foreign_field' => 'COLLATION_NAME',
 217             ],
 218         ],
 219         'SCHEMA_PRIVILEGES' => [
 220             'TABLE_SCHEMA' => [
 221                 'foreign_db' => 'information_schema',
 222                 'foreign_table' => 'SCHEMATA',
 223                 'foreign_field' => 'SCHEMA_NAME',
 224             ],
 225         ],
 226         'STATISTICS' => [
 227             'TABLE_SCHEMA' => [
 228                 'foreign_db' => 'information_schema',
 229                 'foreign_table' => 'SCHEMATA',
 230                 'foreign_field' => 'SCHEMA_NAME',
 231             ],
 232             'INDEX_SCHEMA' => [
 233                 'foreign_db' => 'information_schema',
 234                 'foreign_table' => 'SCHEMATA',
 235                 'foreign_field' => 'SCHEMA_NAME',
 236             ],
 237         ],
 238         'TABLES' => [
 239             'TABLE_SCHEMA' => [
 240                 'foreign_db' => 'information_schema',
 241                 'foreign_table' => 'SCHEMATA',
 242                 'foreign_field' => 'SCHEMA_NAME',
 243             ],
 244             'TABLE_COLLATION' => [
 245                 'foreign_db' => 'information_schema',
 246                 'foreign_table' => 'COLLATIONS',
 247                 'foreign_field' => 'COLLATION_NAME',
 248             ],
 249             'ENGINE' => [
 250                 'foreign_db' => 'information_schema',
 251                 'foreign_table' => 'ENGINES',
 252                 'foreign_field' => 'ENGINE',
 253             ],
 254         ],
 255         'TABLESAPCES' => [
 256             'ENGINE' => [
 257                 'foreign_db' => 'information_schema',
 258                 'foreign_table' => 'ENGINES',
 259                 'foreign_field' => 'ENGINE',
 260             ],
 261         ],
 262         'TABLE_CONSTRAINTS' => [
 263             'CONSTRAINT_SCHEMA' => [
 264                 'foreign_db' => 'information_schema',
 265                 'foreign_table' => 'SCHEMATA',
 266                 'foreign_field' => 'SCHEMA_NAME',
 267             ],
 268             'TABLE_SCHEMA' => [
 269                 'foreign_db' => 'information_schema',
 270                 'foreign_table' => 'SCHEMATA',
 271                 'foreign_field' => 'SCHEMA_NAME',
 272             ],
 273         ],
 274         'TABLE_PRIVILEGES' => [
 275             'TABLE_SCHEMA' => [
 276                 'foreign_db' => 'information_schema',
 277                 'foreign_table' => 'SCHEMATA',
 278                 'foreign_field' => 'SCHEMA_NAME',
 279             ],
 280         ],
 281         'TRIGGERS' => [
 282             'TRIGGER_SCHEMA' => [
 283                 'foreign_db' => 'information_schema',
 284                 'foreign_table' => 'SCHEMATA',
 285                 'foreign_field' => 'SCHEMA_NAME',
 286             ],
 287             'EVENT_OBJECT_SCHEMA' => [
 288                 'foreign_db' => 'information_schema',
 289                 'foreign_table' => 'SCHEMATA',
 290                 'foreign_field' => 'SCHEMA_NAME',
 291             ],
 292             'CHARACTER_SET_CLIENT' => [
 293                 'foreign_db' => 'information_schema',
 294                 'foreign_table' => 'CHARACTER_SETS',
 295                 'foreign_field' => 'CHARACTER_SET_NAME',
 296             ],
 297             'COLLATION_CONNECTION' => [
 298                 'foreign_db' => 'information_schema',
 299                 'foreign_table' => 'COLLATIONS',
 300                 'foreign_field' => 'COLLATION_NAME',
 301             ],
 302             'DATABASE_COLLATION' => [
 303                 'foreign_db' => 'information_schema',
 304                 'foreign_table' => 'COLLATIONS',
 305                 'foreign_field' => 'COLLATION_NAME',
 306             ],
 307         ],
 308         'VIEWS' => [
 309             'TABLE_SCHEMA' => [
 310                 'foreign_db' => 'information_schema',
 311                 'foreign_table' => 'SCHEMATA',
 312                 'foreign_field' => 'SCHEMA_NAME',
 313             ],
 314             'CHARACTER_SET_CLIENT' => [
 315                 'foreign_db' => 'information_schema',
 316                 'foreign_table' => 'CHARACTER_SETS',
 317                 'foreign_field' => 'CHARACTER_SET_NAME',
 318             ],
 319             'COLLATION_CONNECTION' => [
 320                 'foreign_db' => 'information_schema',
 321                 'foreign_table' => 'COLLATIONS',
 322                 'foreign_field' => 'COLLATION_NAME',
 323             ],
 324         ],
 325     ];
 326
 327     public const MYSQL = [
 328         'columns_priv' => [
 329             'Db' => [
 330                 'foreign_db' => 'information_schema',
 331                 'foreign_table' => 'SCHEMATA',
 332                 'foreign_field' => 'SCHEMA_NAME',
 333             ],
 334         ],
 335         'db' => [
 336             'Db' => [
 337                 'foreign_db' => 'information_schema',
 338                 'foreign_table' => 'SCHEMATA',
 339                 'foreign_field' => 'SCHEMA_NAME',
 340             ],
 341         ],
 342         'event' => [
 343             'db' => [
 344                 'foreign_db' => 'information_schema',
 345                 'foreign_table' => 'SCHEMATA',
 346                 'foreign_field' => 'SCHEMA_NAME',
 347             ],
 348             'character_set_client' => [
 349                 'foreign_db' => 'information_schema',
 350                 'foreign_table' => 'CHARACTER_SETS',
 351                 'foreign_field' => 'CHARACTER_SET_NAME',
 352             ],
 353             'collation_connection' => [
 354                 'foreign_db' => 'information_schema',
 355                 'foreign_table' => 'COLLATIONS',
 356                 'foreign_field' => 'COLLATION_NAME',
 357             ],
 358             'db_collation' => [
 359                 'foreign_db' => 'information_schema',
 360                 'foreign_table' => 'COLLATIONS',
 361                 'foreign_field' => 'COLLATION_NAME',
 362             ],
 363         ],
 364         'help_category' => [
 365             'parent_category_id' => [
 366                 'foreign_db' => 'mysql',
 367                 'foreign_table' => 'help_category',
 368                 'foreign_field' => 'help_category_id',
 369             ],
 370         ],
 371         'help_relation' => [
 372             'help_topic_id' => [
 373                 'foreign_db' => 'mysql',
 374                 'foreign_table' => 'help_topic',
 375                 'foreign_field' => 'help_topic_id',
 376             ],
 377             'help_keyword_id' => [
 378                 'foreign_db' => 'mysql',
 379                 'foreign_table' => 'help_keyword',
 380                 'foreign_field' => 'help_keyword_id',
 381             ],
 382         ],
 383         'help_topic' => [
 384             'help_category_id' => [
 385                 'foreign_db' => 'mysql',
 386                 'foreign_table' => 'help_category',
 387                 'foreign_field' => 'help_category_id',
 388             ],
 389         ],
 390         'innodb_index_stats' => [
 391             'database_name' => [
 392                 'foreign_db' => 'information_schema',
 393                 'foreign_table' => 'SCHEMATA',
 394                 'foreign_field' => 'SCHEMA_NAME',
 395             ],
 396         ],
 397         'innodb_table_stats' => [
 398             'database_name' => [
 399                 'foreign_db' => 'information_schema',
 400                 'foreign_table' => 'SCHEMATA',
 401                 'foreign_field' => 'SCHEMA_NAME',
 402             ],
 403         ],
 404         'proc' => [
 405             'db' => [
 406                 'foreign_db' => 'information_schema',
 407                 'foreign_table' => 'SCHEMATA',
 408                 'foreign_field' => 'SCHEMA_NAME',
 409             ],
 410             'character_set_client' => [
 411                 'foreign_db' => 'information_schema',
 412                 'foreign_table' => 'CHARACTER_SETS',
 413                 'foreign_field' => 'CHARACTER_SET_NAME',
 414             ],
 415             'collation_connection' => [
 416                 'foreign_db' => 'information_schema',
 417                 'foreign_table' => 'COLLATIONS',
 418                 'foreign_field' => 'COLLATION_NAME',
 419             ],
 420             'db_collation' => [
 421                 'foreign_db' => 'information_schema',
 422                 'foreign_table' => 'COLLATIONS',
 423                 'foreign_field' => 'COLLATION_NAME',
 424             ],
 425         ],
 426         'proc_priv' => [
 427             'Db' => [
 428                 'foreign_db' => 'information_schema',
 429                 'foreign_table' => 'SCHEMATA',
 430                 'foreign_field' => 'SCHEMA_NAME',
 431             ],
 432         ],
 433         'servers' => [
 434             'Db' => [
 435                 'foreign_db' => 'information_schema',
 436                 'foreign_table' => 'SCHEMATA',
 437                 'foreign_field' => 'SCHEMA_NAME',
 438             ],
 439         ],
 440         'slow_log' => [
 441             'db' => [
 442                 'foreign_db' => 'information_schema',
 443                 'foreign_table' => 'SCHEMATA',
 444                 'foreign_field' => 'SCHEMA_NAME',
 445             ],
 446         ],
 447         'tables_priv' => [
 448             'Db' => [
 449                 'foreign_db' => 'information_schema',
 450                 'foreign_table' => 'SCHEMATA',
 451                 'foreign_field' => 'SCHEMA_NAME',
 452             ],
 453         ],
 454         'time_zone_name' => [
 455             'Time_zone_id' => [
 456                 'foreign_db' => 'mysql',
 457                 'foreign_table' => 'time_zone',
 458                 'foreign_field' => 'Time_zone_id',
 459             ],
 460         ],
 461         'time_zone_transition' => [
 462             'Time_zone_id' => [
 463                 'foreign_db' => 'mysql',
 464                 'foreign_table' => 'time_zone',
 465                 'foreign_field' => 'Time_zone_id',
 466             ],
 467             'Transition_time' => [
 468                 'foreign_db' => 'mysql',
 469                 'foreign_table' => 'time_zone_leap_second',
 470                 'foreign_field' => 'Transition_time',
 471             ],
 472         ],
 473         'time_zone_transition_type' => [
 474             'Time_zone_id' => [
 475                 'foreign_db' => 'mysql',
 476                 'foreign_table' => 'time_zone',
 477                 'foreign_field' => 'Time_zone_id',
 478             ],
 479         ],
 480     ];
 481 }