Gecko [ www.utparral.edu.mx ]

Name	Size	Permission
certs	[ DIR ]	drwxrwxr-x
config	[ DIR ]	drwxrwxr-x
controllers	[ DIR ]	drwxrwxr-x
dbi	[ DIR ]	drwxrwxr-x
di	[ DIR ]	drwxrwxr-x
engines	[ DIR ]	drwxrwxr-x
gis	[ DIR ]	drwxrwxr-x
navigation	[ DIR ]	drwxrwxr-x
plugins	[ DIR ]	drwxrwxr-x
properties	[ DIR ]	drwxrwxr-x
rte	[ DIR ]	drwxrwxr-x
.1724597954	0 B	-rwxrwxr-x
.1724621370	0 B	-rwxrwxr-x
.1724621595	0 B	-rwxrwxr-x
.1724693108	0 B	-rwxrwxr-x
.1724693161	0 B	-rwxrwxr-x
.1724693163	0 B	-rwxrwxr-x
.1724716554	0 B	-rwxrwxr-x
.1724716619	0 B	-rwxrwxr-x
.1724995546	0 B	-rwxrwxr-x
.1725018452	0 B	-rwxrwxr-x
.1725018571	0 B	-rwxrwxr-x
.1725018746	0 B	-rwxrwxr-x
.1725030833	0 B	-rwxrwxr-x
.1725030838	0 B	-rwxrwxr-x
.1725030897	0 B	-rwxrwxr-x
.1725030901	0 B	-rwxrwxr-x
advisor.lib.php	1.58 KB	-rwxrwxr-x
Advisor.php	16.32 KB	-rwxrwxr-x
advisory_rules.txt	25.94 KB	-rwxrwxr-x
Bookmark.php	9.76 KB	-rwxrwxr-x
browse_foreigners.lib.php	9.63 KB	-rwxrwxr-x
central_columns.lib.php	49.24 KB	-rwxrwxr-x
Charsets.php	22.67 KB	-rwxrwxr-x
check_user_privileges.lib.php	11 KB	-rwxrwxr-x
common.inc.php	29.21 KB	-rwxrwxr-x
config.default.php	65.5 KB	-rwxrwxr-x
Config.php	55.12 KB	-rwxrwxr-x
config.values.php	10.24 KB	-rwxrwxr-x
Console.php	3.38 KB	-rwxrwxr-x
core.lib.php	29.45 KB	-rwxrwxr-x
create_addfield.lib.php	15.7 KB	-rwxrwxr-x
database_interface.inc.php	2.63 KB	-rwxrwxr-x
DatabaseInterface.php	95.6 KB	-rwxrwxr-x
db_common.inc.php	3.04 KB	-rwxrwxr-x
db_designer.lib.php	10.77 KB	-rwxrwxr-x
DbList.php	1.91 KB	-rwxrwxr-x
DbQbe.php	68.78 KB	-rwxrwxr-x
DbSearch.php	17.06 KB	-rwxrwxr-x
display_change_password.lib.php	6.15 KB	-rwxrwxr-x
display_create_table.lib.php	1.53 KB	-rwxrwxr-x
display_export.lib.php	35.53 KB	-rwxrwxr-x
display_git_revision.lib.php	2.88 KB	-rwxrwxr-x
display_import_ajax.lib.php	3.13 KB	-rwxrwxr-x
display_import.lib.php	24.38 KB	-rwxrwxr-x
DisplayResults.php	206.87 KB	-rwxrwxr-x
Encoding.php	8.93 KB	-rwxrwxr-x
ErrorHandler.php	16.41 KB	-rwxrwxr-x
error.inc.php	1.27 KB	-rwxrwxr-x
Error.php	12.87 KB	-rwxrwxr-x
error_report.lib.php	9.25 KB	-rwxrwxr-x
file_listing.lib.php	2.37 KB	-rwxrwxr-x
File.php	20.62 KB	-rwxrwxr-x
Font.php	4.24 KB	-rwxrwxr-x
Footer.php	10.29 KB	-rwxrwxr-x
Header.php	25.21 KB	-rwxrwxr-x
import.lib.php	49.9 KB	-rwxrwxr-x
inc.php	30.99 KB	-rwxrwxr-x
IndexColumn.php	4.46 KB	-rwxrwxr-x
index.lib.php	1.13 KB	-rwxrwxr-x
Index.php	23.38 KB	-rwxrwxr-x
information_schema_relations.lib.php	10.95 KB	-rwxrwxr-x
insert_edit.lib.php	112.42 KB	-rwxrwxr-x
ip_allow_deny.lib.php	8.09 KB	-rwxrwxr-x
LanguageManager.php	22.63 KB	-rwxrwxr-x
Language.php	4.21 KB	-rwxrwxr-x
language_stats.inc.php	1.5 KB	-rwxrwxr-x
Linter.php	5.09 KB	-rwxrwxr-x
ListAbstract.php	3.15 KB	-rwxrwxr-x
ListDatabase.php	4.63 KB	-rwxrwxr-x
Logging.php	1023 B	-rwxrwxr-x
Menu.php	21.36 KB	-rwxrwxr-x
Message.php	19.14 KB	-rwxrwxr-x
mime.lib.php	704 B	-rwxrwxr-x
mult_submits.inc.php	10.46 KB	-rwxrwxr-x
mult_submits.lib.php	20.45 KB	-rwxrwxr-x
normalization.lib.php	33.97 KB	-rwxrwxr-x
OpenDocument.php	8.52 KB	-rwxrwxr-x
operations.lib.php	71.3 KB	-rwxrwxr-x
OutputBuffering.php	3.59 KB	-rwxrwxr-x
parse_analyze.lib.php	2.18 KB	-rwxrwxr-x
Partition.php	9 KB	-rwxrwxr-x
PDF.php	3.92 KB	-rwxrwxr-x
plugin_interface.lib.php	19.69 KB	-rwxrwxr-x
pmd_common.php	24.1 KB	-rwxrwxr-x
RecentFavoriteTable.php	11.79 KB	-rwxrwxr-x
relation_cleanup.lib.php	13.84 KB	-rwxrwxr-x
relation.lib.php	68.74 KB	-rwxrwxr-x
replication_gui.lib.php	37.24 KB	-rwxrwxr-x
replication.inc.php	9.33 KB	-rwxrwxr-x
Response.php	12.05 KB	-rwxrwxr-x
Sanitize.php	14.1 KB	-rwxrwxr-x
SavedSearches.php	11.67 KB	-rwxrwxr-x
Scripts.php	6.59 KB	-rwxrwxr-x
select_server.lib.php	3.52 KB	-rwxrwxr-x
server_common.inc.php	1.24 KB	-rwxrwxr-x
server_common.lib.php	1.92 KB	-rwxrwxr-x
server_privileges.lib.php	171.6 KB	-rwxrwxr-x
server_status_advisor.lib.php	1.89 KB	-rwxrwxr-x
ServerStatusData.php	15.7 KB	-rwxrwxr-x
server_status.lib.php	9.84 KB	-rwxrwxr-x
server_status_monitor.lib.php	26.31 KB	-rwxrwxr-x
server_status_processes.lib.php	9.4 KB	-rwxrwxr-x
server_status_queries.lib.php	4.9 KB	-rwxrwxr-x
server_status_variables.lib.php	28.85 KB	-rwxrwxr-x
server_user_groups.lib.php	12.71 KB	-rwxrwxr-x
server_users.lib.php	1.32 KB	-rwxrwxr-x
session.lib.php	1.11 KB	-rwxrwxr-x
special_schema_links.lib.php	17.51 KB	-rwxrwxr-x
sql.lib.php	77.55 KB	-rwxrwxr-x
sql_query_form.lib.php	15.78 KB	-rwxrwxr-x
StorageEngine.php	13.51 KB	-rwxrwxr-x
string.lib.php	800 B	-rwxrwxr-x
stringMb.lib.php	1.85 KB	-rwxrwxr-x
stringNative.lib.php	6.82 KB	-rwxrwxr-x
SubPartition.php	3.52 KB	-rwxrwxr-x
sysinfo.lib.php	1.35 KB	-rwxrwxr-x
SysInfoLinux.php	1.92 KB	-rwxrwxr-x
SysInfo.php	800 B	-rwxrwxr-x
SysInfoSunOS.php	1.86 KB	-rwxrwxr-x
SysInfoWINNT.php	3.08 KB	-rwxrwxr-x
SystemDatabase.php	3.66 KB	-rwxrwxr-x
Table.php	86.78 KB	-rwxrwxr-x
tbl_columns_definition_form.inc.php	13.84 KB	-rwxrwxr-x
tbl_common.inc.php	1.71 KB	-rwxrwxr-x
tbl_info.inc.php	3.54 KB	-rwxrwxr-x
Template.php	4.42 KB	-rwxrwxr-x
ThemeManager.php	12.25 KB	-rwxrwxr-x
Theme.php	12.68 KB	-rwxrwxr-x
Tracker.php	28.76 KB	-rwxrwxr-x
tracking.lib.php	54.52 KB	-rwxrwxr-x
tracking.php	393 B	-rwxrwxr-x
transformations.lib.php	14.62 KB	-rwxrwxr-x
TypesMySQL.php	17.26 KB	-rwxrwxr-x
Types.php	6.08 KB	-rwxrwxr-x
URL.php	8.42 KB	-rwxrwxr-x
user_preferences.inc.php	2.41 KB	-rwxrwxr-x
user_preferences.lib.php	8.28 KB	-rwxrwxr-x
util.lib.php	749 B	-rwxrwxr-x
Util.php	169.69 KB	-rwxrwxr-x
vendor_config.php	2.07 KB	-rwxrwxr-x
VersionInformation.php	6.34 KB	-rwxrwxr-x
zip_extension.lib.php	5.81 KB	-rwxrwxr-x
ZipFile.php	6.63 KB	-rwxrwxr-x

Code Editor : Index.php

<?php
/* vim: set expandtab sw=4 ts=4 sts=4: */
/**
 * holds the database index class
 *
 * @package PhpMyAdmin
 */
namespace PMA\libraries;

use PMA\libraries\URL;
use PMA\libraries\Sanitize;

/**
 * Index manipulation class
 *
 * @package PhpMyAdmin
 * @since   phpMyAdmin 3.0.0
 */
class Index
{
    const PRIMARY  = 1;
    const UNIQUE   = 2;
    const INDEX    = 4;
    const SPATIAL  = 8;
    const FULLTEXT = 16;

/**
     * Class-wide storage container for indexes (caching, singleton)
     *
     * @var array
     */
    private static $_registry = array();

/**
     * @var string The name of the schema
     */
    private $_schema = '';

/**
     * @var string The name of the table
     */
    private $_table = '';

/**
     * @var string The name of the index
     */
    private $_name = '';

/**
     * Columns in index
     *
     * @var array
     */
    private $_columns = array();

/**
     * The index method used (BTREE, HASH, RTREE).
     *
     * @var string
     */
    private $_type = '';

/**
     * The index choice (PRIMARY, UNIQUE, INDEX, SPATIAL, FULLTEXT)
     *
     * @var string
     */
    private $_choice = '';

/**
     * Various remarks.
     *
     * @var string
     */
    private $_remarks = '';

/**
     * Any comment provided for the index with a COMMENT attribute when the
     * index was created.
     *
     * @var string
     */
    private $_comment = '';

/**
     * @var integer 0 if the index cannot contain duplicates, 1 if it can.
     */
    private $_non_unique = 0;

/**
     * Indicates how the key is packed. NULL if it is not.
     *
     * @var string
     */
    private $_packed = null;

/**
     * Block size for the index
     *
     * @var int
     */
    private $_key_block_size = null;

/**
     * Parser option for the index
     *
     * @var string
     */
    private $_parser = null;

/**
     * Constructor
     *
     * @param array $params parameters
     */
    public function __construct($params = array())
    {
        $this->set($params);
    }

/**
     * Creates(if not already created) and returns the corresponding Index object
     *
     * @param string $schema     database name
     * @param string $table      table name
     * @param string $index_name index name
     *
     * @return Index corresponding Index object
     */
    static public function singleton($schema, $table, $index_name = '')
    {
        Index::_loadIndexes($table, $schema);
        if (! isset(Index::$_registry[$schema][$table][$index_name])) {
            $index = new Index;
            if (strlen($index_name) > 0) {
                $index->setName($index_name);
                Index::$_registry[$schema][$table][$index->getName()] = $index;
            }
            return $index;
        } else {
            return Index::$_registry[$schema][$table][$index_name];
        }
    }

/**
     * returns an array with all indexes from the given table
     *
     * @param string $table  table
     * @param string $schema schema
     *
     * @return Index[]  array of indexes
     */
    static public function getFromTable($table, $schema)
    {
        Index::_loadIndexes($table, $schema);

if (isset(Index::$_registry[$schema][$table])) {
            return Index::$_registry[$schema][$table];
        } else {
            return array();
        }
    }

/**
     * Returns an array with all indexes from the given table of the requested types
     *
     * @param string $table   table
     * @param string $schema  schema
     * @param int    $choices choices
     *
     * @return Index[] array of indexes
     */
    static public function getFromTableByChoice($table, $schema, $choices = 31)
    {
        $indexes = array();
        foreach (self::getFromTable($table, $schema) as $index) {
            if (($choices & Index::PRIMARY)
                && $index->getChoice() == 'PRIMARY'
            ) {
                $indexes[] = $index;
            }
            if (($choices & Index::UNIQUE)
                && $index->getChoice() == 'UNIQUE'
            ) {
                $indexes[] = $index;
            }
            if (($choices & Index::INDEX)
                && $index->getChoice() == 'INDEX'
            ) {
                $indexes[] = $index;
            }
            if (($choices & Index::SPATIAL)
                && $index->getChoice() == 'SPATIAL'
            ) {
                $indexes[] = $index;
            }
            if (($choices & Index::FULLTEXT)
                && $index->getChoice() == 'FULLTEXT'
            ) {
                $indexes[] = $index;
            }
        }
        return $indexes;
    }

/**
     * return primary if set, false otherwise
     *
     * @param string $table  table
     * @param string $schema schema
     *
     * @return mixed primary index or false if no one exists
     */
    static public function getPrimary($table, $schema)
    {
        Index::_loadIndexes($table, $schema);

if (isset(Index::$_registry[$schema][$table]['PRIMARY'])) {
            return Index::$_registry[$schema][$table]['PRIMARY'];
        } else {
            return false;
        }
    }

/**
     * Load index data for table
     *
     * @param string $table  table
     * @param string $schema schema
     *
     * @return boolean whether loading was successful
     */
    static private function _loadIndexes($table, $schema)
    {
        if (isset(Index::$_registry[$schema][$table])) {
            return true;
        }

$_raw_indexes = $GLOBALS['dbi']->getTableIndexes($schema, $table);
        foreach ($_raw_indexes as $_each_index) {
            $_each_index['Schema'] = $schema;
            $keyName = $_each_index['Key_name'];
            if (! isset(Index::$_registry[$schema][$table][$keyName])) {
                $key = new Index($_each_index);
                Index::$_registry[$schema][$table][$keyName] = $key;
            } else {
                $key = Index::$_registry[$schema][$table][$keyName];
            }

$key->addColumn($_each_index);
        }

return true;
    }

/**
     * Add column to index
     *
     * @param array $params column params
     *
     * @return void
     */
    public function addColumn($params)
    {
        if (isset($params['Column_name'])
            && strlen($params['Column_name']) > 0
        ) {
            $this->_columns[$params['Column_name']] = new IndexColumn($params);
        }
    }

/**
     * Adds a list of columns to the index
     *
     * @param array $columns array containing details about the columns
     *
     * @return void
     */
    public function addColumns($columns)
    {
        $_columns = array();

if (isset($columns['names'])) {
            // coming from form
            // $columns[names][]
            // $columns[sub_parts][]
            foreach ($columns['names'] as $key => $name) {
                $sub_part = isset($columns['sub_parts'][$key])
                    ? $columns['sub_parts'][$key] : '';
                $_columns[] = array(
                    'Column_name'   => $name,
                    'Sub_part'      => $sub_part,
                );
            }
        } else {
            // coming from SHOW INDEXES
            // $columns[][name]
            // $columns[][sub_part]
            // ...
            $_columns = $columns;
        }

foreach ($_columns as $column) {
            $this->addColumn($column);
        }
    }

/**
     * Returns true if $column indexed in this index
     *
     * @param string $column the column
     *
     * @return boolean  true if $column indexed in this index
     */
    public function hasColumn($column)
    {
        return isset($this->_columns[$column]);
    }

/**
     * Sets index details
     *
     * @param array $params index details
     *
     * @return void
     */
    public function set($params)
    {
        if (isset($params['columns'])) {
            $this->addColumns($params['columns']);
        }
        if (isset($params['Schema'])) {
            $this->_schema = $params['Schema'];
        }
        if (isset($params['Table'])) {
            $this->_table = $params['Table'];
        }
        if (isset($params['Key_name'])) {
            $this->_name = $params['Key_name'];
        }
        if (isset($params['Index_type'])) {
            $this->_type = $params['Index_type'];
        }
        if (isset($params['Comment'])) {
            $this->_remarks = $params['Comment'];
        }
        if (isset($params['Index_comment'])) {
            $this->_comment = $params['Index_comment'];
        }
        if (isset($params['Non_unique'])) {
            $this->_non_unique = $params['Non_unique'];
        }
        if (isset($params['Packed'])) {
            $this->_packed = $params['Packed'];
        }
        if (isset($params['Index_choice'])) {
            $this->_choice = $params['Index_choice'];
        } else {
            if ('PRIMARY' == $this->_name) {
                $this->_choice = 'PRIMARY';
            } elseif ('FULLTEXT' == $this->_type) {
                $this->_choice = 'FULLTEXT';
                $this->_type = '';
            } elseif ('SPATIAL' == $this->_type) {
                $this->_choice = 'SPATIAL';
                $this->_type = '';
            } elseif ('0' == $this->_non_unique) {
                $this->_choice = 'UNIQUE';
            } else {
                $this->_choice = 'INDEX';
            }
        }
        if (isset($params['Key_block_size'])) {
            $this->_key_block_size = $params['Key_block_size'];
        }
        if (isset($params['Parser'])) {
            $this->_parser = $params['Parser'];
        }
    }

/**
     * Returns the number of columns of the index
     *
     * @return integer the number of the columns
     */
    public function getColumnCount()
    {
        return count($this->_columns);
    }

/**
     * Returns the index comment
     *
     * @return string index comment
     */
    public function getComment()
    {
        return $this->_comment;
    }

/**
     * Returns index remarks
     *
     * @return string index remarks
     */
    public function getRemarks()
    {
        return $this->_remarks;
    }

/**
     * Return the key block size
     *
     * @return number
     */
    public function getKeyBlockSize()
    {
        return $this->_key_block_size;
    }

/**
     * Return the parser
     *
     * @return string
     */
    public function getParser()
    {
        return $this->_parser;
    }

/**
     * Returns concatenated remarks and comment
     *
     * @return string concatenated remarks and comment
     */
    public function getComments()
    {
        $comments = $this->getRemarks();
        if (strlen($comments) > 0) {
            $comments .= "\n";
        }
        $comments .= $this->getComment();

return $comments;
    }

/**
     * Returns index type (BTREE, HASH, RTREE)
     *
     * @return string index type
     */
    public function getType()
    {
        return $this->_type;
    }

/**
     * Returns index choice (PRIMARY, UNIQUE, INDEX, SPATIAL, FULLTEXT)
     *
     * @return string index choice
     */
    public function getChoice()
    {
        return $this->_choice;
    }

/**
     * Return a list of all index choices
     *
     * @return string[] index choices
     */
    static public function getIndexChoices()
    {
        return array(
            'PRIMARY',
            'INDEX',
            'UNIQUE',
            'SPATIAL',
            'FULLTEXT',
        );
    }

/**
     * Returns a lit of all index types
     *
     * @return string[] index types
     */
    static public function getIndexTypes()
    {
        return array(
            'BTREE',
            'HASH'
        );
    }

/**
     * Returns HTML for the index choice selector
     *
     * @param boolean $edit_table whether this is table editing
     *
     * @return string HTML for the index choice selector
     */
    public function generateIndexChoiceSelector($edit_table)
    {
        $html_options = '<select name="index[Index_choice]"'
            . ' id="select_index_choice" '
            . ($edit_table ? 'disabled="disabled"' : '') . '>';

foreach (Index::getIndexChoices() as $each_index_choice) {
            if ($each_index_choice === 'PRIMARY'
                && $this->_choice !== 'PRIMARY'
                && Index::getPrimary($this->_table, $this->_schema)
            ) {
                // skip PRIMARY if there is already one in the table
                continue;
            }
            $html_options .= '<option value="' . $each_index_choice . '"'
                 . (($this->_choice == $each_index_choice)
                 ? ' selected="selected"'
                 : '')
                 . '>' . $each_index_choice . '</option>' . "\n";
        }
        $html_options .= '</select>';

return $html_options;
    }

/**
     * Returns HTML for the index type selector
     *
     * @return string HTML for the index type selector
     */
    public function generateIndexTypeSelector()
    {
        $types = array("" => "--");
        foreach (Index::getIndexTypes() as $type) {
            $types[$type] = $type;
        }

return Util::getDropdown(
            "index[Index_type]", $types,
            $this->_type, "select_index_type"
        );
    }

/**
     * Returns how the index is packed
     *
     * @return string how the index is packed
     */
    public function getPacked()
    {
        return $this->_packed;
    }

/**
     * Returns 'No' if the index is not packed,
     * how the index is packed if packed
     *
     * @return string
     */
    public function isPacked()
    {
        if (null === $this->_packed) {
            return __('No');
        }

return htmlspecialchars($this->_packed);
    }

/**
     * Returns integer 0 if the index cannot contain duplicates, 1 if it can
     *
     * @return integer 0 if the index cannot contain duplicates, 1 if it can
     */
    public function getNonUnique()
    {
        return $this->_non_unique;
    }

/**
     * Returns whether the index is a 'Unique' index
     *
     * @param boolean $as_text whether to output should be in text
     *
     * @return mixed whether the index is a 'Unique' index
     */
    public function isUnique($as_text = false)
    {
        if ($as_text) {
            $r = array(
                '0' => __('Yes'),
                '1' => __('No'),
            );
        } else {
            $r = array(
                '0' => true,
                '1' => false,
            );
        }

return $r[$this->_non_unique];
    }

/**
     * Returns the name of the index
     *
     * @return string the name of the index
     */
    public function getName()
    {
        return $this->_name;
    }

/**
     * Sets the name of the index
     *
     * @param string $name index name
     *
     * @return void
     */
    public function setName($name)
    {
        $this->_name = (string) $name;
    }

/**
     * Returns the columns of the index
     *
     * @return IndexColumn[] the columns of the index
     */
    public function getColumns()
    {
        return $this->_columns;
    }

/**
     * Show index data
     *
     * @param string  $table      The table name
     * @param string  $schema     The schema name
     * @param boolean $print_mode Whether the output is for the print mode
     *
     * @return string HTML for showing index
     *
     * @access  public
     */
    static public function getHtmlForIndexes($table, $schema, $print_mode = false)
    {
        $indexes = Index::getFromTable($table, $schema);

$no_indexes_class = count($indexes) > 0 ? ' hide' : '';
        $no_indexes  = "<div class='no_indexes_defined$no_indexes_class'>";
        $no_indexes .= Message::notice(__('No index defined!'))->getDisplay();
        $no_indexes .= '</div>';

if (! $print_mode) {
            $r  = '<fieldset class="index_info">';
            $r .= '<legend id="index_header">' . __('Indexes');
            $r .= Util::showMySQLDocu('optimizing-database-structure');

$r .= '</legend>';
            $r .= $no_indexes;
            if (count($indexes) < 1) {
                $r .= '</fieldset>';
                return $r;
            }
            $r .= Index::findDuplicates($table, $schema);
        } else {
            $r  = '<h3>' . __('Indexes') . '</h3>';
            $r .= $no_indexes;
            if (count($indexes) < 1) {
                return $r;
            }
        }
        $r .= '<table id="table_index">';
        $r .= '<thead>';
        $r .= '<tr>';
        if (! $print_mode) {
            $r .= '<th colspan="2" class="print_ignore">' . __('Action') . '</th>';
        }
        $r .= '<th>' . __('Keyname') . '</th>';
        $r .= '<th>' . __('Type') . '</th>';
        $r .= '<th>' . __('Unique') . '</th>';
        $r .= '<th>' . __('Packed') . '</th>';
        $r .= '<th>' . __('Column') . '</th>';
        $r .= '<th>' . __('Cardinality') . '</th>';
        $r .= '<th>' . __('Collation') . '</th>';
        $r .= '<th>' . __('Null') . '</th>';
        $r .= '<th>' . __('Comment') . '</th>';
        $r .= '</tr>';
        $r .= '</thead>';
        $r .= '<tbody>';

foreach ($indexes as $index) {
            $row_span = ' rowspan="' . $index->getColumnCount() . '" ';

$r .= '<tr class="noclick" >';

if (! $print_mode) {
                $this_params = $GLOBALS['url_params'];
                $this_params['index'] = $index->getName();
                $r .= '<td class="edit_index print_ignore';
                $r .= ' ajax';
                $r .= '" ' . $row_span . '>'
                   . '    <a class="';
                $r .= 'ajax';
                $r .= '" href="tbl_indexes.php' . URL::getCommon($this_params)
                   . '">' . Util::getIcon('b_edit.png', __('Edit')) . '</a>'
                   . '</td>' . "\n";
                $this_params = $GLOBALS['url_params'];
                if ($index->getName() == 'PRIMARY') {
                    $this_params['sql_query'] = 'ALTER TABLE '
                        . Util::backquote($table)
                        . ' DROP PRIMARY KEY;';
                    $this_params['message_to_show']
                        = __('The primary key has been dropped.');
                    $js_msg = Sanitize::jsFormat($this_params['sql_query']);
                } else {
                    $this_params['sql_query'] = 'ALTER TABLE '
                        . Util::backquote($table) . ' DROP INDEX '
                        . Util::backquote($index->getName()) . ';';
                    $this_params['message_to_show'] = sprintf(
                        __('Index %s has been dropped.'), htmlspecialchars($index->getName())
                    );
                    $js_msg = Sanitize::jsFormat($this_params['sql_query']);
                }

$r .= '<td ' . $row_span . ' class="print_ignore">';
                $r .= '<input type="hidden" class="drop_primary_key_index_msg"'
                    . ' value="' . $js_msg . '" />';
                $r .= '    <a class="drop_primary_key_index_anchor';
                $r .= ' ajax';
                $r .= '" href="sql.php' . URL::getCommon($this_params)
                   . '" >'
                   . Util::getIcon('b_drop.png', __('Drop'))  . '</a>'
                   . '</td>' . "\n";
            }

if (! $print_mode) {
                $r .= '<th ' . $row_span . '>'
                    . htmlspecialchars($index->getName())
                    . '</th>';
            } else {
                $r .= '<td ' . $row_span . '>'
                    . htmlspecialchars($index->getName())
                    . '</td>';
            }
            $r .= '<td ' . $row_span . '>';
            $type = $index->getType();
            if (! empty($type)) {
                $r .= htmlspecialchars($type);
            } else {
                $r .= htmlspecialchars($index->getChoice());
            }
            $r .= '</td>';
            $r .= '<td ' . $row_span . '>' . $index->isUnique(true) . '</td>';
            $r .= '<td ' . $row_span . '>' . $index->isPacked() . '</td>';

foreach ($index->getColumns() as $column) {
                if ($column->getSeqInIndex() > 1) {
                    $r .= '<tr class="noclick" >';
                }
                $r .= '<td>' . htmlspecialchars($column->getName());
                if ($column->getSubPart()) {
                    $r .= ' (' . htmlspecialchars($column->getSubPart()) . ')';
                }
                $r .= '</td>';
                $r .= '<td>'
                    . htmlspecialchars($column->getCardinality())
                    . '</td>';
                $r .= '<td>'
                    . htmlspecialchars($column->getCollation())
                    . '</td>';
                $r .= '<td>'
                    . htmlspecialchars($column->getNull(true))
                    . '</td>';

if ($column->getSeqInIndex() == 1
                ) {
                    $r .= '<td ' . $row_span . '>'
                        . htmlspecialchars($index->getComments()) . '</td>';
                }
                $r .= '</tr>';
            } // end foreach $index['Sequences']

} // end while
        $r .= '</tbody>';
        $r .= '</table>';
        if (! $print_mode) {
            $r .= '</fieldset>';
        }

return $r;
    }

/**
     * Gets the properties in an array for comparison purposes
     *
     * @return array an array containing the properties of the index
     */
    public function getCompareData()
    {
        $data = array(
            // 'Non_unique'    => $this->_non_unique,
            'Packed'        => $this->_packed,
            'Index_choice'    => $this->_choice,
        );

foreach ($this->_columns as $column) {
            $data['columns'][] = $column->getCompareData();
        }

return $data;
    }

/**
     * Function to check over array of indexes and look for common problems
     *
     * @param string $table  table name
     * @param string $schema schema name
     *
     * @return string  Output HTML
     * @access  public
     */
    static public function findDuplicates($table, $schema)
    {
        $indexes = Index::getFromTable($table, $schema);

$output  = '';

// count($indexes) < 2:
        //   there is no need to check if there less than two indexes
        if (count($indexes) < 2) {
            return $output;
        }

// remove last index from stack and ...
        while ($while_index = array_pop($indexes)) {
            // ... compare with every remaining index in stack
            foreach ($indexes as $each_index) {
                if ($each_index->getCompareData() !== $while_index->getCompareData()
                ) {
                    continue;
                }

// did not find any difference
                // so it makes no sense to have this two equal indexes

$message = Message::notice(
                    __(
                        'The indexes %1$s and %2$s seem to be equal and one of them '
                        . 'could possibly be removed.'
                    )
                );
                $message->addParam($each_index->getName());
                $message->addParam($while_index->getName());
                $output .= $message->getDisplay();

// there is no need to check any further indexes if we have already
                // found that this one has a duplicate
                continue 2;
            }
        }
        return $output;
    }
}

${this.title}

Code Editor : Index.php