| Server IP : 85.214.239.14 / Your IP : 3.147.51.72 Web Server : Apache/2.4.62 (Debian) System : Linux h2886529.stratoserver.net 4.9.0 #1 SMP Tue Jan 9 19:45:01 MSK 2024 x86_64 User : www-data ( 33) PHP Version : 7.4.18 Disable Function : pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_get_handler,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,pcntl_async_signals,pcntl_unshare, MySQL : OFF | cURL : OFF | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : OFF Directory : /var/www/wordpress/phpMyAdmin/libraries/classes/ |
Upload File : |
<?php
/* vim: set expandtab sw=4 ts=4 sts=4: */
/**
* Internal relations for information schema and mysql databases.
* @package PhpMyAdmin
*/
declare(strict_types=1);
namespace PhpMyAdmin;
/**
* Internal relations for information schema and mysql databases.
* @package PhpMyAdmin
*/
class InternalRelations
{
/**
* @var array
*/
private static $informationSchema = [
'CHARACTER_SETS' => [
'DEFAULT_COLLATE_NAME' => [
'foreign_db' => 'information_schema',
'foreign_table' => 'COLLATIONS',
'foreign_field' => 'COLLATION_NAME',
],
],
'COLLATIONS' => [
'CHARACTER_SET_NAME' => [
'foreign_db' => 'information_schema',
'foreign_table' => 'CHARACTER_SETS',
'foreign_field' => 'CHARACTER_SET_NAME',
],
],
'COLLATION_CHARACTER_SET_APPLICABILITY' => [
'CHARACTER_SET_NAME' => [
'foreign_db' => 'information_schema',
'foreign_table' => 'CHARACTER_SETS',
'foreign_field' => 'CHARACTER_SET_NAME',
],
'COLLATION_NAME' => [
'foreign_db' => 'information_schema',
'foreign_table' => 'COLLATIONS',
'foreign_field' => 'COLLATION_NAME',
],
],
'COLUMNS' => [
'TABLE_SCHEMA' => [
'foreign_db' => 'information_schema',
'foreign_table' => 'SCHEMATA',
'foreign_field' => 'SCHEMA_NAME',
],
'CHARACTER_SET_NAME' => [
'foreign_db' => 'information_schema',
'foreign_table' => 'CHARACTER_SETS',
'foreign_field' => 'CHARACTER_SET_NAME',
],
'COLLATION_NAME' => [
'foreign_db' => 'information_schema',
'foreign_table' => 'COLLATIONS',
'foreign_field' => 'COLLATION_NAME',
],
],
'COLUMN_PRIVILEGES' => [
'TABLE_SCHEMA' => [
'foreign_db' => 'information_schema',
'foreign_table' => 'SCHEMATA',
'foreign_field' => 'SCHEMA_NAME',
],
],
'EVENTS' => [
'EVENT_SCHEMA' => [
'foreign_db' => 'information_schema',
'foreign_table' => 'SCHEMATA',
'foreign_field' => 'SCHEMA_NAME',
],
'CHARACTER_SET_CLIENT' => [
'foreign_db' => 'information_schema',
'foreign_table' => 'CHARACTER_SETS',
'foreign_field' => 'CHARACTER_SET_NAME',
],
'COLLATION_CONNECTION' => [
'foreign_db' => 'information_schema',
'foreign_table' => 'COLLATIONS',
'foreign_field' => 'COLLATION_NAME',
],
'DATABASE_COLLATION' => [
'foreign_db' => 'information_schema',
'foreign_table' => 'COLLATIONS',
'foreign_field' => 'COLLATION_NAME',
],
],
'FILES' => [
'TABLESPACE_NAME' => [
'foreign_db' => 'information_schema',
'foreign_table' => 'TABLESPACES',
'foreign_field' => 'TABLESPACE_NAME',
],
'TABLE_SCHEMA' => [
'foreign_db' => 'information_schema',
'foreign_table' => 'SCHEMATA',
'foreign_field' => 'SCHEMA_NAME',
],
'COLLATION_CONNECTION' => [
'foreign_db' => 'information_schema',
'foreign_table' => 'COLLATIONS',
'foreign_field' => 'COLLATION_NAME',
],
'ENGINE' => [
'foreign_db' => 'information_schema',
'foreign_table' => 'ENGINES',
'foreign_field' => 'ENGINE',
],
],
'KEY_COLUMN_USAGE' => [
'CONSTRAINT_SCHEMA' => [
'foreign_db' => 'information_schema',
'foreign_table' => 'SCHEMATA',
'foreign_field' => 'SCHEMA_NAME',
],
'TABLE_SCHEMA' => [
'foreign_db' => 'information_schema',
'foreign_table' => 'SCHEMATA',
'foreign_field' => 'SCHEMA_NAME',
],
'REFERENCED_TABLE_SCHEMA' => [
'foreign_db' => 'information_schema',
'foreign_table' => 'SCHEMATA',
'foreign_field' => 'SCHEMA_NAME',
],
],
'PARAMETERS' => [
'SPECIFIC_SCHEMA' => [
'foreign_db' => 'information_schema',
'foreign_table' => 'SCHEMATA',
'foreign_field' => 'SCHEMA_NAME',
],
'CHARACTER_SET_NAME' => [
'foreign_db' => 'information_schema',
'foreign_table' => 'CHARACTER_SETS',
'foreign_field' => 'CHARACTER_SET_NAME',
],
'COLLATION_NAME' => [
'foreign_db' => 'information_schema',
'foreign_table' => 'COLLATIONS',
'foreign_field' => 'COLLATION_NAME',
],
],
'PARTITIONS' => [
'TABLE_SCHEMA' => [
'foreign_db' => 'information_schema',
'foreign_table' => 'SCHEMATA',
'foreign_field' => 'SCHEMA_NAME',
],
'TABLESPACE_NAME' => [
'foreign_db' => 'information_schema',
'foreign_table' => 'TABLESPACES',
'foreign_field' => 'TABLESPACE_NAME',
],
],
'PROCESSLIST' => [
'DB' => [
'foreign_db' => 'information_schema',
'foreign_table' => 'SCHEMATA',
'foreign_field' => 'SCHEMA_NAME',
],
],
'REFERENTIAL_CONSTRAINTS' => [
'CONSTRAINT_SCHEMA' => [
'foreign_db' => 'information_schema',
'foreign_table' => 'SCHEMATA',
'foreign_field' => 'SCHEMA_NAME',
],
'UNIQUE_CONSTRAINT_SCHEMA' => [
'foreign_db' => 'information_schema',
'foreign_table' => 'SCHEMATA',
'foreign_field' => 'SCHEMA_NAME',
],
],
'ROUTINES' => [
'ROUTINE_SCHEMA' => [
'foreign_db' => 'information_schema',
'foreign_table' => 'SCHEMATA',
'foreign_field' => 'SCHEMA_NAME',
],
'CHARACTER_SET_NAME' => [
'foreign_db' => 'information_schema',
'foreign_table' => 'CHARACTER_SETS',
'foreign_field' => 'CHARACTER_SET_NAME',
],
'COLLATION_NAME' => [
'foreign_db' => 'information_schema',
'foreign_table' => 'COLLATIONS',
'foreign_field' => 'COLLATION_NAME',
],
'CHARACTER_SET_CLIENT' => [
'foreign_db' => 'information_schema',
'foreign_table' => 'CHARACTER_SETS',
'foreign_field' => 'CHARACTER_SET_NAME',
],
'COLLATION_CONNECTION' => [
'foreign_db' => 'information_schema',
'foreign_table' => 'COLLATIONS',
'foreign_field' => 'COLLATION_NAME',
],
'DATABASE_COLLATION' => [
'foreign_db' => 'information_schema',
'foreign_table' => 'COLLATIONS',
'foreign_field' => 'COLLATION_NAME',
],
],
'SCHEMATA' => [
'DEFAULT_CHARACTER_SET_NAME' => [
'foreign_db' => 'information_schema',
'foreign_table' => 'CHARACTER_SETS',
'foreign_field' => 'CHARACTER_SET_NAME',
],
'DEFAULT_COLLATION_NAME' => [
'foreign_db' => 'information_schema',
'foreign_table' => 'COLLATIONS',
'foreign_field' => 'COLLATION_NAME',
],
],
'SCHEMA_PRIVILEGES' => [
'TABLE_SCHEMA' => [
'foreign_db' => 'information_schema',
'foreign_table' => 'SCHEMATA',
'foreign_field' => 'SCHEMA_NAME',
],
],
'STATISTICS' => [
'TABLE_SCHEMA' => [
'foreign_db' => 'information_schema',
'foreign_table' => 'SCHEMATA',
'foreign_field' => 'SCHEMA_NAME',
],
'INDEX_SCHEMA' => [
'foreign_db' => 'information_schema',
'foreign_table' => 'SCHEMATA',
'foreign_field' => 'SCHEMA_NAME',
],
],
'TABLES' => [
'TABLE_SCHEMA' => [
'foreign_db' => 'information_schema',
'foreign_table' => 'SCHEMATA',
'foreign_field' => 'SCHEMA_NAME',
],
'TABLE_COLLATION' => [
'foreign_db' => 'information_schema',
'foreign_table' => 'COLLATIONS',
'foreign_field' => 'COLLATION_NAME',
],
'ENGINE' => [
'foreign_db' => 'information_schema',
'foreign_table' => 'ENGINES',
'foreign_field' => 'ENGINE',
],
],
'TABLESAPCES' => [
'ENGINE' => [
'foreign_db' => 'information_schema',
'foreign_table' => 'ENGINES',
'foreign_field' => 'ENGINE',
],
],
'TABLE_CONSTRAINTS' => [
'CONSTRAINT_SCHEMA' => [
'foreign_db' => 'information_schema',
'foreign_table' => 'SCHEMATA',
'foreign_field' => 'SCHEMA_NAME',
],
'TABLE_SCHEMA' => [
'foreign_db' => 'information_schema',
'foreign_table' => 'SCHEMATA',
'foreign_field' => 'SCHEMA_NAME',
],
],
'TABLE_PRIVILEGES' => [
'TABLE_SCHEMA' => [
'foreign_db' => 'information_schema',
'foreign_table' => 'SCHEMATA',
'foreign_field' => 'SCHEMA_NAME',
],
],
'TRIGGERS' => [
'TRIGGER_SCHEMA' => [
'foreign_db' => 'information_schema',
'foreign_table' => 'SCHEMATA',
'foreign_field' => 'SCHEMA_NAME',
],
'EVENT_OBJECT_SCHEMA' => [
'foreign_db' => 'information_schema',
'foreign_table' => 'SCHEMATA',
'foreign_field' => 'SCHEMA_NAME',
],
'CHARACTER_SET_CLIENT' => [
'foreign_db' => 'information_schema',
'foreign_table' => 'CHARACTER_SETS',
'foreign_field' => 'CHARACTER_SET_NAME',
],
'COLLATION_CONNECTION' => [
'foreign_db' => 'information_schema',
'foreign_table' => 'COLLATIONS',
'foreign_field' => 'COLLATION_NAME',
],
'DATABASE_COLLATION' => [
'foreign_db' => 'information_schema',
'foreign_table' => 'COLLATIONS',
'foreign_field' => 'COLLATION_NAME',
],
],
'VIEWS' => [
'TABLE_SCHEMA' => [
'foreign_db' => 'information_schema',
'foreign_table' => 'SCHEMATA',
'foreign_field' => 'SCHEMA_NAME',
],
'CHARACTER_SET_CLIENT' => [
'foreign_db' => 'information_schema',
'foreign_table' => 'CHARACTER_SETS',
'foreign_field' => 'CHARACTER_SET_NAME',
],
'COLLATION_CONNECTION' => [
'foreign_db' => 'information_schema',
'foreign_table' => 'COLLATIONS',
'foreign_field' => 'COLLATION_NAME',
],
],
];
/**
* @var array
*/
private static $mysql = [
'columns_priv' => [
'Db' => [
'foreign_db' => 'information_schema',
'foreign_table' => 'SCHEMATA',
'foreign_field' => 'SCHEMA_NAME',
],
],
'db' => [
'Db' => [
'foreign_db' => 'information_schema',
'foreign_table' => 'SCHEMATA',
'foreign_field' => 'SCHEMA_NAME',
],
],
'event' => [
'db' => [
'foreign_db' => 'information_schema',
'foreign_table' => 'SCHEMATA',
'foreign_field' => 'SCHEMA_NAME',
],
'character_set_client' => [
'foreign_db' => 'information_schema',
'foreign_table' => 'CHARACTER_SETS',
'foreign_field' => 'CHARACTER_SET_NAME',
],
'collation_connection' => [
'foreign_db' => 'information_schema',
'foreign_table' => 'COLLATIONS',
'foreign_field' => 'COLLATION_NAME',
],
'db_collation' => [
'foreign_db' => 'information_schema',
'foreign_table' => 'COLLATIONS',
'foreign_field' => 'COLLATION_NAME',
],
],
'help_category' => [
'parent_category_id' => [
'foreign_db' => 'mysql',
'foreign_table' => 'help_category',
'foreign_field' => 'help_category_id',
],
],
'help_relation' => [
'help_topic_id' => [
'foreign_db' => 'mysql',
'foreign_table' => 'help_topic',
'foreign_field' => 'help_topic_id',
],
'help_keyword_id' => [
'foreign_db' => 'mysql',
'foreign_table' => 'help_keyword',
'foreign_field' => 'help_keyword_id',
],
],
'help_topic' => [
'help_category_id' => [
'foreign_db' => 'mysql',
'foreign_table' => 'help_category',
'foreign_field' => 'help_category_id',
],
],
'innodb_index_stats' => [
'database_name' => [
'foreign_db' => 'information_schema',
'foreign_table' => 'SCHEMATA',
'foreign_field' => 'SCHEMA_NAME',
],
],
'innodb_table_stats' => [
'database_name' => [
'foreign_db' => 'information_schema',
'foreign_table' => 'SCHEMATA',
'foreign_field' => 'SCHEMA_NAME',
],
],
'proc' => [
'db' => [
'foreign_db' => 'information_schema',
'foreign_table' => 'SCHEMATA',
'foreign_field' => 'SCHEMA_NAME',
],
'character_set_client' => [
'foreign_db' => 'information_schema',
'foreign_table' => 'CHARACTER_SETS',
'foreign_field' => 'CHARACTER_SET_NAME',
],
'collation_connection' => [
'foreign_db' => 'information_schema',
'foreign_table' => 'COLLATIONS',
'foreign_field' => 'COLLATION_NAME',
],
'db_collation' => [
'foreign_db' => 'information_schema',
'foreign_table' => 'COLLATIONS',
'foreign_field' => 'COLLATION_NAME',
],
],
'proc_priv' => [
'Db' => [
'foreign_db' => 'information_schema',
'foreign_table' => 'SCHEMATA',
'foreign_field' => 'SCHEMA_NAME',
],
],
'servers' => [
'Db' => [
'foreign_db' => 'information_schema',
'foreign_table' => 'SCHEMATA',
'foreign_field' => 'SCHEMA_NAME',
],
],
'slow_log' => [
'db' => [
'foreign_db' => 'information_schema',
'foreign_table' => 'SCHEMATA',
'foreign_field' => 'SCHEMA_NAME',
],
],
'tables_priv' => [
'Db' => [
'foreign_db' => 'information_schema',
'foreign_table' => 'SCHEMATA',
'foreign_field' => 'SCHEMA_NAME',
],
],
'time_zone_name' => [
'Time_zone_id' => [
'foreign_db' => 'mysql',
'foreign_table' => 'time_zone',
'foreign_field' => 'Time_zone_id',
],
],
'time_zone_transition' => [
'Time_zone_id' => [
'foreign_db' => 'mysql',
'foreign_table' => 'time_zone',
'foreign_field' => 'Time_zone_id',
],
'Transition_time' => [
'foreign_db' => 'mysql',
'foreign_table' => 'time_zone_leap_second',
'foreign_field' => 'Transition_time',
],
],
'time_zone_transition_type' => [
'Time_zone_id' => [
'foreign_db' => 'mysql',
'foreign_table' => 'time_zone',
'foreign_field' => 'Time_zone_id',
],
],
];
/**
* @return array
*/
public static function getInformationSchema(): array
{
return self::$informationSchema;
}
/**
* @return array
*/
public static function getMySql(): array
{
return self::$mysql;
}
}