diff --git a/htdocs/sql/libraries/tbl_indexes.lib.php b/htdocs/sql/libraries/tbl_indexes.lib.php deleted file mode 100755 --- a/htdocs/sql/libraries/tbl_indexes.lib.php +++ /dev/null @@ -1,295 +0,0 @@ - $each_index) { - if (count($while_index) !== count($each_index)) { - // number of fields are not equal - continue; - } - - // compare some key elements of every column in this two indexes - foreach ($each_index as $col_name => $each_index_column) { - if (! isset($while_index[$col_name]) - // the position - || $while_index[$col_name]['Seq_in_index'] !== $each_index_column['Seq_in_index'] - // the order, ASC or DESC - || $while_index[$col_name]['Collation'] !== $each_index_column['Collation'] - // the length - || $while_index[$col_name]['Sub_part'] !== $each_index_column['Sub_part'] - // BTREE or HASH - || $while_index[$col_name]['Index_type'] !== $each_index_column['Index_type']) { - continue 2; - } - } - - // did not find any difference - // so it makes no sense to have this two equal indexes - - // use first column from index to fetch index name - reset($while_index); - $first_column = current($while_index); - - $output .= '
'; - $output .= $GLOBALS['strIndexesSeemEqual'] . ' '; - $output .= $each_index_name . ', ' . $first_column['Key_name']; - $output .= '
'; - - // there is no need to check any further indexes if we have already - // found that this one has a duplicate - continue 2; - } - } - - if ($output) { - $output = '' . $output . ''; - } - - return $output; -} - -/** - * Loop array of returned index keys and extract key information to - * seperate arrays. Those arrays are passed by reference. - * - * @param array Referenced Array of indexes - * @param array Referenced return array - * @param array Referenced return array - * @param array Referenced return array - * - * @access public - * @return boolean void - * @author Garvin Hicking (pma@supergarv.de) - */ -function PMA_extract_indexes(&$ret_keys, &$indexes, &$indexes_info, &$indexes_data) -{ - if (! is_array($ret_keys)) { - return false; - } - - $prev_index = ''; - foreach ($ret_keys as $row) { - if ($row['Key_name'] != $prev_index){ - $indexes[] = $row['Key_name']; - $prev_index = $row['Key_name']; - } - - $indexes_info[$row['Key_name']]['Sequences'][] = $row['Seq_in_index']; - $indexes_info[$row['Key_name']]['Non_unique'] = $row['Non_unique']; - - if (isset($row['Cardinality'])) { - $indexes_info[$row['Key_name']]['Cardinality'] = $row['Cardinality']; - } - - // I don't know what does following column mean.... - // $indexes_info[$row['Key_name']]['Packed'] = $row['Packed']; - $indexes_info[$row['Key_name']]['Comment'] = (isset($row['Comment'])) - ? $row['Comment'] - : ''; - $indexes_info[$row['Key_name']]['Index_type'] = (isset($row['Index_type'])) - ? $row['Index_type'] - : ''; - - $indexes_data[$row['Key_name']][$row['Seq_in_index']]['Column_name'] = $row['Column_name']; - if (isset($row['Sub_part'])) { - $indexes_data[$row['Key_name']][$row['Seq_in_index']]['Sub_part'] = $row['Sub_part']; - } - } // end while - - return true; -} - -/** - * Show index data and prepare returned collection array for index - * key checks. - * - * @param string $table The tablename - * @param array $indexes Referenced Array of indexes - * @param array $indexes_info Referenced info array - * @param array $indexes_data Referenced data array - * @param boolean $display_html Output HTML code, or just return collection array? - * @param boolean $print_mode - * @access public - * @return array Index collection array - * @author Garvin Hicking (pma@supergarv.de) - */ -function PMA_show_indexes($table, &$indexes, &$indexes_info, &$indexes_data, - $display_html = true, $print_mode = false) -{ - $idx_collection = array(); - $odd_row = true; - foreach ($indexes as $index_name) { - if ($display_html) { - $row_span = ' rowspan="' . count($indexes_info[$index_name]['Sequences']) . '" '; - - echo ' ' . "\n"; - echo ' ' . "\n" - . ' ' . htmlspecialchars($index_name) . "\n" - . ' ' . "\n"; - } - - if ((PMA_MYSQL_INT_VERSION < 40002 && $indexes_info[$index_name]['Comment'] == 'FULLTEXT') - || (PMA_MYSQL_INT_VERSION >= 40002 && $indexes_info[$index_name]['Index_type'] == 'FULLTEXT')) { - $index_type = 'FULLTEXT'; - } elseif ($index_name == 'PRIMARY') { - $index_type = 'PRIMARY'; - } elseif ($indexes_info[$index_name]['Non_unique'] == '0') { - $index_type = 'UNIQUE'; - } else { - $index_type = 'INDEX'; - } - - if ($display_html) { - echo ' ' . "\n" - . ' ' . $index_type . '' . "\n"; - - echo ' ' . "\n" - . ' ' . (isset($indexes_info[$index_name]['Cardinality']) ? $indexes_info[$index_name]['Cardinality'] : $GLOBALS['strNone']) . ' ' . "\n" - . ' ' . "\n"; - - if (!$print_mode) { - echo ' ' . "\n" - . ' ' . $GLOBALS['edit_link_text'] . '' . "\n" - . ' ' . "\n"; - - if ($index_name == 'PRIMARY') { - $local_query = urlencode('ALTER TABLE ' . PMA_backquote($table) . ' DROP PRIMARY KEY'); - $js_msg = 'ALTER TABLE ' . PMA_jsFormat($table) . ' DROP PRIMARY KEY'; - $zero_rows = urlencode($GLOBALS['strPrimaryKeyHasBeenDropped']); - } else { - $local_query = urlencode('ALTER TABLE ' . PMA_backquote($table) . ' DROP INDEX ' . PMA_backquote($index_name)); - $js_msg = 'ALTER TABLE ' . PMA_jsFormat($table) . ' DROP INDEX ' . PMA_jsFormat($index_name); - $zero_rows = urlencode(sprintf($GLOBALS['strIndexHasBeenDropped'], htmlspecialchars($index_name))); - } - - echo ' ' . "\n" - . ' ' . $GLOBALS['drop_link_text'] . '' . "\n" - . ' ' . "\n"; - } - } - - foreach ($indexes_info[$index_name]['Sequences'] AS $row_no => $seq_index) { - $col_name = $indexes_data[$index_name][$seq_index]['Column_name']; - if ($row_no == 0) { - if (isset($idx_collection[$index_type][$col_name])) { - $idx_collection[$index_type][$col_name]++; - } else { - $idx_collection[$index_type][$col_name] = 1; - } - - if (isset($idx_collection['ALL'][$col_name])) { - $idx_collection['ALL'][$col_name]++; - } else { - $idx_collection['ALL'][$col_name] = 1; - } - } - - if ($display_html) { - if ($row_no > 0) { - echo ' ' . "\n"; - } - - if (isset($indexes_data[$index_name][$seq_index]['Sub_part']) - && strlen($indexes_data[$index_name][$seq_index]['Sub_part'])) { - echo ' ' . $col_name . '' . "\n"; - echo ' ' . "\n" - . ' ' . $indexes_data[$index_name][$seq_index]['Sub_part'] . "\n" - . ' ' . "\n"; - echo ' ' . "\n"; - } else { - echo ' ' . "\n" - . ' ' . htmlspecialchars($col_name) . "\n" - . ' ' . "\n"; - echo ' ' . "\n"; - } - } - } // end foreach $indexes_info[$index_name]['Sequences'] - - $odd_row = ! $odd_row; - } // end while - - return $idx_collection; -} - -?>