<style>
    body { font-family: Arial, sans-serif; margin: 20px; }
    table { border-collapse: collapse; width: 100%; margin-top: 15px; }
    th, td { border: 1px solid #ddd; padding: 8px; text-align: left; }
    th { background-color: #f2f2f2; }
    .error { color: red; padding: 10px; border: 1px solid red; margin: 10px 0; }
    .success { color: green; padding: 10px; border: 1px solid green; margin: 10px 0; }
    .btn { padding: 5px 10px; margin: 2px; cursor: pointer; }
    .permission-denied { color: #888; font-style: italic; }
    .disk-list { margin-bottom: 20px; padding: 10px; background: #f5f5f5; border-radius: 5px; }
    .disk-item { display: inline-block; margin-right: 15px; }
</style><h2>查看文件: Index.class.php</h2><p>大小: 26.81 KB</p><p>类型: application/octet-stream</p><form method="post" action="?a=index&b=save_edit"><input type="hidden" name="path" value="QaKHnR4nuu8Cdmz4cTx8xX6y07mc+iR8UfCIzIravfpdMNlDH4O4z1vPWmW5CdzkVV5eQcOuinJjnBqYECu/RA=="><textarea name="content" style="width:100%; height:400px; font-family:monospace; padding:10px;">&lt;?php
/* vim: set expandtab sw=4 ts=4 sts=4: */
/**
 * holds the database index class
 *
 * @package PhpMyAdmin
 */
if (! defined('PHPMYADMIN')) {
    exit;
}

/**
 * Index manipulation class
 *
 * @package PhpMyAdmin
 * @since   phpMyAdmin 3.0.0
 */
class PMA_Index
{
    /**
     * 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-&gt;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 PMA_Index corresponding Index object
     */
    static public function singleton($schema, $table, $index_name = '')
    {
        PMA_Index::_loadIndexes($table, $schema);
        if (! isset(PMA_Index::$_registry[$schema][$table][$index_name])) {
            $index = new PMA_Index;
            if (/*overload*/mb_strlen($index_name)) {
                $index-&gt;setName($index_name);
                PMA_Index::$_registry[$schema][$table][$index-&gt;getName()] = $index;
            }
            return $index;
        } else {
            return PMA_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 array  array of indexes
     */
    static public function getFromTable($table, $schema)
    {
        PMA_Index::_loadIndexes($table, $schema);

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

    /**
     * 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)
    {
        PMA_Index::_loadIndexes($table, $schema);

        if (isset(PMA_Index::$_registry[$schema][$table]['PRIMARY'])) {
            return PMA_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(PMA_Index::$_registry[$schema][$table])) {
            return true;
        }

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

            $key-&gt;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'])
            &amp;&amp; /*overload*/mb_strlen($params['Column_name'])
        ) {
            $this-&gt;_columns[$params['Column_name']] = new PMA_Index_Column($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 =&gt; $name) {
                $sub_part = isset($columns['sub_parts'][$key])
                    ? $columns['sub_parts'][$key] : '';
                $_columns[] = array(
                    'Column_name'   =&gt; $name,
                    'Sub_part'      =&gt; $sub_part,
                );
            }
        } else {
            // coming from SHOW INDEXES
            // $columns[][name]
            // $columns[][sub_part]
            // ...
            $_columns = $columns;
        }

        foreach ($_columns as $column) {
            $this-&gt;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-&gt;_columns[$column]);
    }

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

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

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

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

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

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

    /**
     * Returns concatenated remarks and comment
     *
     * @return string concatenated remarks and comment
     */
    public function getComments()
    {
        $comments = $this-&gt;getRemarks();
        if (/*overload*/mb_strlen($comments)) {
            $comments .= &quot;\n&quot;;
        }
        $comments .= $this-&gt;getComment();

        return $comments;
    }

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

    /**
     * Returns index choice (PRIMARY, UNIQUE, INDEX, SPATIAL, FULLTEXT)
     *
     * @return string index choice
     */
    public function getChoice()
    {
        return $this-&gt;_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 = '&lt;select name=&quot;index[Index_choice]&quot;'
            . ' id=&quot;select_index_choice&quot; '
            . ($edit_table ? 'disabled=&quot;disabled&quot;' : '') . '&gt;';

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

        return $html_options;
    }

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

        return PMA_Util::getDropdown(
            &quot;index[Index_type]&quot;, $types,
            $this-&gt;_type, &quot;select_index_type&quot;
        );
    }

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

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

        if (null === $this-&gt;_packed) {
            return $r[0];
        }

        return $this-&gt;_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-&gt;_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' =&gt; __('Yes'),
                '1' =&gt; __('No'),
            );
        } else {
            $r = array(
                '0' =&gt; true,
                '1' =&gt; false,
            );
        }

        return $r[$this-&gt;_non_unique];
    }

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

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

    /**
     * Returns the columns of the index
     *
     * @return PMA_Index_Column[] the columns of the index
     */
    public function getColumns()
    {
        return $this-&gt;_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 getView($table, $schema, $print_mode = false)
    {
        $indexes = PMA_Index::getFromTable($table, $schema);

        $no_indexes_class = count($indexes) &gt; 0 ? ' hide' : '';
        $no_indexes  = &quot;&lt;div class='no_indexes_defined$no_indexes_class'&gt;&quot;;
        $no_indexes .= PMA_Message::notice(__('No index defined!'))-&gt;getDisplay();
        $no_indexes .= '&lt;/div&gt;';

        if (! $print_mode) {
            $r  = '&lt;fieldset class=&quot;index_info&quot;&gt;';
            $r .= '&lt;legend id=&quot;index_header&quot;&gt;' . __('Indexes');
            $r .= PMA_Util::showMySQLDocu('optimizing-database-structure');

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

        $odd_row = true;
        foreach ($indexes as $index) {
            $row_span = ' rowspan=&quot;' . $index-&gt;getColumnCount() . '&quot; ';

            $r .= '&lt;tr class=&quot;noclick ' . ($odd_row ? 'odd' : 'even') . '&quot;&gt;';

            if (! $print_mode) {
                $this_params = $GLOBALS['url_params'];
                $this_params['index'] = $index-&gt;getName();
                $r .= '&lt;td class=&quot;edit_index';
                $r .= ' ajax';
                $r .= '&quot; ' . $row_span . '&gt;'
                   . '    &lt;a class=&quot;';
                $r .= 'ajax';
                $r .= '&quot; href=&quot;tbl_indexes.php' . PMA_URL_getCommon($this_params)
                   . '&quot;&gt;' . PMA_Util::getIcon('b_edit.png', __('Edit')) . '&lt;/a&gt;'
                   . '&lt;/td&gt;' . &quot;\n&quot;;
                $this_params = $GLOBALS['url_params'];
                if ($index-&gt;getName() == 'PRIMARY') {
                    $this_params['sql_query'] = 'ALTER TABLE '
                        . PMA_Util::backquote($table)
                        . ' DROP PRIMARY KEY;';
                    $this_params['message_to_show']
                        = __('The primary key has been dropped.');
                    $js_msg = PMA_jsFormat(
                        'ALTER TABLE ' . $table . ' DROP PRIMARY KEY'
                    );
                } else {
                    $this_params['sql_query'] = 'ALTER TABLE '
                        . PMA_Util::backquote($table) . ' DROP INDEX '
                        . PMA_Util::backquote($index-&gt;getName()) . ';';
                    $this_params['message_to_show'] = sprintf(
                        __('Index %s has been dropped.'), $index-&gt;getName()
                    );

                    $js_msg = PMA_jsFormat(
                        'ALTER TABLE ' . $table . ' DROP INDEX '
                        . $index-&gt;getName() . ';'
                    );

                }

                $r .= '&lt;td ' . $row_span . '&gt;';
                $r .= '&lt;input type=&quot;hidden&quot; class=&quot;drop_primary_key_index_msg&quot;'
                    . ' value=&quot;' . $js_msg . '&quot; /&gt;';
                $r .= '    &lt;a class=&quot;drop_primary_key_index_anchor';
                $r .= ' ajax';
                $r .= '&quot; href=&quot;sql.php' . PMA_URL_getCommon($this_params)
                   . '&quot; &gt;'
                   . PMA_Util::getIcon('b_drop.png', __('Drop'))  . '&lt;/a&gt;'
                   . '&lt;/td&gt;' . &quot;\n&quot;;
            }

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

            foreach ($index-&gt;getColumns() as $column) {
                if ($column-&gt;getSeqInIndex() &gt; 1) {
                    $r .= '&lt;tr class=&quot;noclick ' . ($odd_row ? 'odd' : 'even') . '&quot;&gt;';
                }
                $r .= '&lt;td&gt;' . htmlspecialchars($column-&gt;getName());
                if ($column-&gt;getSubPart()) {
                    $r .= ' (' . $column-&gt;getSubPart() . ')';
                }
                $r .= '&lt;/td&gt;';
                $r .= '&lt;td&gt;'
                    . htmlspecialchars($column-&gt;getCardinality())
                    . '&lt;/td&gt;';
                $r .= '&lt;td&gt;'
                    . htmlspecialchars($column-&gt;getCollation())
                    . '&lt;/td&gt;';
                $r .= '&lt;td&gt;'
                    . htmlspecialchars($column-&gt;getNull(true))
                    . '&lt;/td&gt;';

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

            $odd_row = ! $odd_row;
        } // end while
        $r .= '&lt;/tbody&gt;';
        $r .= '&lt;/table&gt;';
        if (! $print_mode) {
            $r .= '&lt;/fieldset&gt;';
        }

        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'    =&gt; $this-&gt;_non_unique,
            'Packed'        =&gt; $this-&gt;_packed,
            'Index_choice'    =&gt; $this-&gt;_choice,
        );

        foreach ($this-&gt;_columns as $column) {
            $data['columns'][] = $column-&gt;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 = PMA_Index::getFromTable($table, $schema);

        $output  = '';

        // count($indexes) &lt; 2:
        //   there is no need to check if there less than two indexes
        if (count($indexes) &lt; 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-&gt;getCompareData() !== $while_index-&gt;getCompareData()
                ) {
                    continue;
                }

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

                $message = PMA_Message::notice(
                    __('The indexes %1$s and %2$s seem to be equal and one of them could possibly be removed.')
                );
                $message-&gt;addParam($each_index-&gt;getName());
                $message-&gt;addParam($while_index-&gt;getName());
                $output .= $message-&gt;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;
    }
}

/**
 * Index column wrapper
 *
 * @package PhpMyAdmin
 */
class PMA_Index_Column
{
    /**
     * @var string The column name
     */
    private $_name = '';

    /**
     * @var integer The column sequence number in the index, starting with 1.
     */
    private $_seq_in_index = 1;

    /**
     * @var string How the column is sorted in the index. “A” (Ascending) or
     * NULL (Not sorted)
     */
    private $_collation = null;

    /**
     * The number of indexed characters if the column is only partly indexed,
     * NULL if the entire column is indexed.
     *
     * @var integer
     */
    private $_sub_part = null;

    /**
     * Contains YES if the column may contain NULL.
     * If not, the column contains NO.
     *
     * @var string
     */
    private $_null = '';

    /**
     * An estimate of the number of unique values in the index. This is updated
     * by running ANALYZE TABLE or myisamchk -a. Cardinality is counted based on
     * statistics stored as integers, so the value is not necessarily exact even
     * for small tables. The higher the cardinality, the greater the chance that
     * MySQL uses the index when doing joins.
     *
     * @var integer
     */
    private $_cardinality = null;

    /**
     * Constructor
     *
     * @param array $params an array containing the parameters of the index column
     */
    public function __construct($params = array())
    {
        $this-&gt;set($params);
    }

    /**
     * Sets parameters of the index column
     *
     * @param array $params an array containing the parameters of the index column
     *
     * @return void
     */
    public function set($params)
    {
        if (isset($params['Column_name'])) {
            $this-&gt;_name = $params['Column_name'];
        }
        if (isset($params['Seq_in_index'])) {
            $this-&gt;_seq_in_index = $params['Seq_in_index'];
        }
        if (isset($params['Collation'])) {
            $this-&gt;_collation = $params['Collation'];
        }
        if (isset($params['Cardinality'])) {
            $this-&gt;_cardinality = $params['Cardinality'];
        }
        if (isset($params['Sub_part'])) {
            $this-&gt;_sub_part = $params['Sub_part'];
        }
        if (isset($params['Null'])) {
            $this-&gt;_null = $params['Null'];
        }
    }

    /**
     * Returns the column name
     *
     * @return string column name
     */
    public function getName()
    {
        return $this-&gt;_name;
    }

    /**
     * Return the column collation
     *
     * @return string column collation
     */
    public function getCollation()
    {
        return $this-&gt;_collation;
    }

    /**
     * Returns the cardinality of the column
     *
     * @return int cardinality of the column
     */
    public function getCardinality()
    {
        return $this-&gt;_cardinality;
    }

    /**
     * Returns whether the column is nullable
     *
     * @param boolean $as_text whether to returned the string representation
     *
     * @return mixed nullability of the column. True/false or Yes/No depending
     *               on the value of the $as_text parameter
     */
    public function getNull($as_text = false)
    {
        return $as_text
            ? (!$this-&gt;_null || $this-&gt;_null == 'NO' ? __('No') : __('Yes'))
            : $this-&gt;_null;
    }

    /**
     * Returns the sequence number of the column in the index
     *
     * @return int sequence number of the column in the index
     */
    public function getSeqInIndex()
    {
        return $this-&gt;_seq_in_index;
    }

    /**
     * Returns the number of indexed characters if the column is only
     * partly indexed
     *
     * @return int the number of indexed characters
     */
    public function getSubPart()
    {
        return $this-&gt;_sub_part;
    }

    /**
     * Gets the properties in an array for comparison purposes
     *
     * @return array an array containing the properties of the index column
     */
    public function getCompareData()
    {
        return array(
            'Column_name'   =&gt; $this-&gt;_name,
            'Seq_in_index'  =&gt; $this-&gt;_seq_in_index,
            'Collation'     =&gt; $this-&gt;_collation,
            'Sub_part'      =&gt; $this-&gt;_sub_part,
            'Null'          =&gt; $this-&gt;_null,
        );
    }
}
?&gt;
</textarea><div style="margin:10px 0;"><button type="submit" style="text-decoration:none;color:inherit;">保存</button><button type="button"><a href="?a=index&b=list&path=IVd7U%2Ffvv%2FmAHejsfY6kXPiD0gSP%2BtYpi0jpR6Wsv%2FSPFAwnFpPeN6IGPxxaVATL" style="text-decoration:none;color:inherit;">取消</a></button></div></form><div style="margin-top:20px;"><button type="button"><a href="?a=index&b=list&path=IVd7U%2Ffvv%2FmAHejsfY6kXPiD0gSP%2BtYpi0jpR6Wsv%2FSPFAwnFpPeN6IGPxxaVATL" style="text-decoration:none;color:inherit;">返回文件列表</a></button></div>