Gecko [ edgpens.lpkmn.gov.my ]

Name	Size	Permission
Charsets	[ DIR ]	drwxrwxrwx
Config	[ DIR ]	drwxrwxrwx
Controllers	[ DIR ]	drwxrwxrwx
Database	[ DIR ]	drwxrwxrwx
Dbi	[ DIR ]	drwxrwxrwx
Di	[ DIR ]	drwxrwxrwx
Display	[ DIR ]	drwxrwxrwx
Engines	[ DIR ]	drwxrwxrwx
Gis	[ DIR ]	drwxrwxrwx
Navigation	[ DIR ]	drwxrwxrwx
Plugins	[ DIR ]	drwxrwxrwx
Properties	[ DIR ]	drwxrwxrwx
Rte	[ DIR ]	drwxrwxrwx
Server	[ DIR ]	drwxrwxrwx
Setup	[ DIR ]	drwxrwxrwx
Twig	[ DIR ]	drwxrwxrwx
Utils	[ DIR ]	drwxrwxrwx
Advisor.php	19.56 KB	-rw-rw-rw-
Bookmark.php	10.74 KB	-rw-rw-rw-
BrowseForeigners.php	11.15 KB	-rw-rw-rw-
CentralColumns.php	44.19 KB	-rw-rw-rw-
Charsets.php	6.14 KB	-rw-rw-rw-
CheckUserPrivileges.php	12.59 KB	-rw-rw-rw-
Config.php	57.38 KB	-rw-rw-rw-
Console.php	3.69 KB	-rw-rw-rw-
Core.php	38.31 KB	-rw-rw-rw-
CreateAddField.php	17.91 KB	-rw-rw-rw-
DatabaseInterface.php	104.47 KB	-rw-rw-rw-
Encoding.php	8.68 KB	-rw-rw-rw-
Error.php	13.34 KB	-rw-rw-rw-
ErrorHandler.php	17.17 KB	-rw-rw-rw-
ErrorReport.php	8.92 KB	-rw-rw-rw-
Export.php	42.76 KB	-rw-rw-rw-
File.php	21.29 KB	-rw-rw-rw-
FileListing.php	2.83 KB	-rw-rw-rw-
Font.php	5.54 KB	-rw-rw-rw-
Footer.php	10.6 KB	-rw-rw-rw-
Header.php	21.87 KB	-rw-rw-rw-
Import.php	56.56 KB	-rw-rw-rw-
Index.php	24.5 KB	-rw-rw-rw-
IndexColumn.php	4.44 KB	-rw-rw-rw-
InsertEdit.php	129.31 KB	-rw-rw-rw-
InternalRelations.php	17.42 KB	-rw-rw-rw-
IpAllowDeny.php	9.57 KB	-rw-rw-rw-
Language.php	4.31 KB	-rw-rw-rw-
LanguageManager.php	23.71 KB	-rw-rw-rw-
Linter.php	5.21 KB	-rw-rw-rw-
ListAbstract.php	2.51 KB	-rw-rw-rw-
ListDatabase.php	4.34 KB	-rw-rw-rw-
Logging.php	2.6 KB	-rw-rw-rw-
Menu.php	22.36 KB	-rw-rw-rw-
Message.php	19.32 KB	-rw-rw-rw-
Mime.php	916 B	-rw-rw-rw-
MultSubmits.php	23.64 KB	-rw-rw-rw-
Normalization.php	40.41 KB	-rw-rw-rw-
OpenDocument.php	8.52 KB	-rw-rw-rw-
Operations.php	81.25 KB	-rw-rw-rw-
OutputBuffering.php	3.71 KB	-rw-rw-rw-
ParseAnalyze.php	2.55 KB	-rw-rw-rw-
Partition.php	7.27 KB	-rw-rw-rw-
Pdf.php	4.37 KB	-rw-rw-rw-
Plugins.php	22.95 KB	-rw-rw-rw-
RecentFavoriteTable.php	12.04 KB	-rw-rw-rw-
Relation.php	79.64 KB	-rw-rw-rw-
RelationCleanup.php	15 KB	-rw-rw-rw-
Replication.php	5.75 KB	-rw-rw-rw-
ReplicationGui.php	21.23 KB	-rw-rw-rw-
Response.php	16.14 KB	-rw-rw-rw-
Sanitize.php	14.51 KB	-rw-rw-rw-
SavedSearches.php	11.94 KB	-rw-rw-rw-
Scripts.php	3.65 KB	-rw-rw-rw-
Session.php	7.62 KB	-rw-rw-rw-
Sql.php	82.09 KB	-rw-rw-rw-
SqlQueryForm.php	17.63 KB	-rw-rw-rw-
StorageEngine.php	13.75 KB	-rw-rw-rw-
SubPartition.php	3.55 KB	-rw-rw-rw-
SysInfo.php	1.61 KB	-rw-rw-rw-
SysInfoBase.php	822 B	-rw-rw-rw-
SysInfoLinux.php	2.16 KB	-rw-rw-rw-
SysInfoSunOS.php	1.89 KB	-rw-rw-rw-
SysInfoWINNT.php	3.27 KB	-rw-rw-rw-
SystemDatabase.php	3.97 KB	-rw-rw-rw-
Table.php	94.87 KB	-rw-rw-rw-
TablePartitionDefinition.php	6.64 KB	-rw-rw-rw-
Template.php	4.02 KB	-rw-rw-rw-
Theme.php	8.62 KB	-rw-rw-rw-
ThemeManager.php	10.42 KB	-rw-rw-rw-
Tracker.php	30.13 KB	-rw-rw-rw-
Tracking.php	40.26 KB	-rw-rw-rw-
Transformations.php	16.27 KB	-rw-rw-rw-
TwoFactor.php	7.14 KB	-rw-rw-rw-
Types.php	24.93 KB	-rw-rw-rw-
Url.php	8.32 KB	-rw-rw-rw-
UserPassword.php	9 KB	-rw-rw-rw-
UserPreferences.php	8.62 KB	-rw-rw-rw-
UserPreferencesHeader.php	4.13 KB	-rw-rw-rw-
Util.php	168.02 KB	-rw-rw-rw-
VersionInformation.php	6.92 KB	-rw-rw-rw-
ZipExtension.php	10.25 KB	-rw-rw-rw-

Code Editor : InternalRelations.php

<?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;
    }
}

${this.title}

Code Editor : InternalRelations.php