Gecko [ www.maalgaadi.app ]

Name	Size	Permission
certs	[ DIR ]	drwxr-xr-x
classes	[ DIR ]	drwxr-xr-x
dbi	[ DIR ]	drwxr-xr-x
rte	[ DIR ]	drwxr-xr-x
advisory_rules_generic.txt	22.15 KB	-rw-r--r--
advisory_rules_mysql_before800...	3.89 KB	-rw-r--r--
check_user_privileges.inc.php	838 B	-rw-r--r--
common.inc.php	13.84 KB	-rw-r--r--
config.default.php	69.15 KB	-rw-r--r--
config.values.php	10.6 KB	-rw-r--r--
db_common.inc.php	4.67 KB	-rw-r--r--
db_table_exists.inc.php	3.34 KB	-rw-r--r--
error.inc.php	1.26 KB	-rw-r--r--
hash.lib.php	586 B	-rw-r--r--
information_schema_relations.i...	10.95 KB	-rw-r--r--
language_stats.inc.php	1.59 KB	-rw-r--r--
mult_submits.inc.php	10.71 KB	-rw-r--r--
mysql_relations.inc.php	5.12 KB	-rw-r--r--
replication.inc.php	4.34 KB	-rw-r--r--
server_common.inc.php	990 B	-rw-r--r--
special_schema_links.inc.php	17.47 KB	-rw-r--r--
tbl_columns_definition_form.in...	15.89 KB	-rw-r--r--
tbl_common.inc.php	1.22 KB	-rw-r--r--
tbl_partition_definition.inc.p...	5.38 KB	-rw-r--r--
user_preferences.inc.php	2.25 KB	-rw-r--r--
vendor_config.php	1.88 KB	-rw-r--r--

Code Editor : tbl_partition_definition.inc.php

<?php
/* vim: set expandtab sw=4 ts=4 sts=4: */
/**
 * Table partition definition
 *
 * @package PhpMyAdmin
 */

use PhpMyAdmin\Core;

if (!isset($partitionDetails)) {

$partitionDetails = array();

// Extract some partitioning and subpartitioning parameters from the request
    $partitionParams = array(
        'partition_by', 'partition_expr',
        'subpartition_by', 'subpartition_expr',
    );
    foreach ($partitionParams as $partitionParam) {
        $partitionDetails[$partitionParam] = isset($_POST[$partitionParam])
            ? $_POST[$partitionParam] : '';
    }

if (Core::isValid($_POST['partition_count'], 'numeric')) {
        // MySQL's limit is 8192, so do not allow more
        $partition_count = min(intval($_POST['partition_count']), 8192);
    } else {
        $partition_count = 0;
    }
    $partitionDetails['partition_count']
        = ($partition_count === 0) ? '' : $partition_count;
    if (Core::isValid($_POST['subpartition_count'], 'numeric')) {
        // MySQL's limit is 8192, so do not allow more
        $subpartition_count = min(intval($_POST['subpartition_count']), 8192);
    } else {
        $subpartition_count = 0;
    }
    $partitionDetails['subpartition_count']
        = ($subpartition_count === 0) ? '' : $subpartition_count;

// Only LIST and RANGE type parameters allow subpartitioning
    $partitionDetails['can_have_subpartitions'] = $partition_count > 1
        && isset($_POST['partition_by'])
        && ($_POST['partition_by'] == 'RANGE'
        || $_POST['partition_by'] == 'RANGE COLUMNS'
        || $_POST['partition_by'] == 'LIST'
        || $_POST['partition_by'] == 'LIST COLUMNS');

// Values are specified only for LIST and RANGE type partitions
    $partitionDetails['value_enabled'] = isset($_POST['partition_by'])
        && ($_POST['partition_by'] == 'RANGE'
        || $_POST['partition_by'] == 'RANGE COLUMNS'
        || $_POST['partition_by'] == 'LIST'
        || $_POST['partition_by'] == 'LIST COLUMNS');

// Has partitions
    if ($partition_count > 1) {
        $partitions = isset($_POST['partitions'])
            ? $_POST['partitions']
            : array();

// Remove details of the additional partitions
        // when number of partitions have been reduced
        array_splice($partitions, $partition_count);

for ($i = 0; $i < $partition_count; $i++) {
            if (! isset($partitions[$i])) { // Newly added partition
                $partitions[$i] = array(
                    'name' => 'p' . $i,
                    'value_type' => '',
                    'value' => '',
                    'engine' => '',
                    'comment' => '',
                    'data_directory' => '',
                    'index_directory' => '',
                    'max_rows' => '',
                    'min_rows' => '',
                    'tablespace' => '',
                    'node_group' => '',
                );
            }

$partition =& $partitions[$i];
            $partition['prefix'] = 'partitions[' . $i . ']';

// Changing from HASH/KEY to RANGE/LIST
            if (! isset($partition['value_type'])) {
                $partition['value_type'] = '';
                $partition['value'] = '';
            }
            if (! isset($partition['engine'])) { // When removing subpartitioning
                $partition['engine'] = '';
                $partition['comment'] = '';
                $partition['data_directory'] = '';
                $partition['index_directory'] = '';
                $partition['max_rows'] = '';
                $partition['min_rows'] = '';
                $partition['tablespace'] = '';
                $partition['node_group'] = '';
            }

if ($subpartition_count > 1
                && $partitionDetails['can_have_subpartitions'] == true
            ) { // Has subpartitions
                $partition['subpartition_count'] = $subpartition_count;

if (! isset($partition['subpartitions'])) {
                    $partition['subpartitions'] = array();
                }
                $subpartitions =& $partition['subpartitions'];

// Remove details of the additional subpartitions
                // when number of subpartitions have been reduced
                array_splice($subpartitions, $subpartition_count);

for ($j = 0; $j < $subpartition_count; $j++) {
                    if (! isset($subpartitions[$j])) { // Newly added subpartition
                        $subpartitions[$j] = array(
                            'name' => $partition['name'] . '_s' . $j,
                            'engine' => '',
                            'comment' => '',
                            'data_directory' => '',
                            'index_directory' => '',
                            'max_rows' => '',
                            'min_rows' => '',
                            'tablespace' => '',
                            'node_group' => '',
                        );
                    }

$subpartition =& $subpartitions[$j];
                    $subpartition['prefix'] = 'partitions[' . $i . ']'
                        . '[subpartitions][' . $j . ']';
                }
            } else { // No subpartitions
                unset($partition['subpartitions']);
                unset($partition['subpartition_count']);
            }
        }
        $partitionDetails['partitions'] = $partitions;
    }
}

${this.title}

Code Editor : tbl_partition_definition.inc.php