</th>
<th><?php
echo $strCardinality;
?>
</th>
<th colspan="2"><?php
echo $strAction;
?>
</th>
<th colspan="2"><?php
echo $strField;
?>
</th>
</tr>
<?php
$idx_collection = PMA_show_indexes($table, $indexes, $indexes_info, $indexes_data, true);
echo PMA_check_indexes($idx_collection);
} else {
// none indexes
echo "\n" . ' <tr><td colspan=7" align="center">' . "\n";
if ($cfg['ErrorIconic']) {
echo '<img src="' . $pmaThemeImage . 's_warn.png" width="16" height="16" border="0" alt="Warning" hspace="2" align="middle" />';
}
echo ' <b>' . $strNoIndex . '</b></td></tr>' . "\n\n";
}
echo '<tr><td colspan="7" class="tblFooters" nowrap="nowrap" align="center"> ' . sprintf($strCreateIndex, '<input type="text" size="2" name="idx_num_fields" value="1" style="vertical-align: middle;" />') . "\n";
echo ' <input type="submit" name="create_index" value="' . $strGo . '" onclick="return checkFormElementInRange(this.form, \'idx_num_fields\', \'' . str_replace('\'', '\\\'', $GLOBALS['strInvalidColumnCount']) . '\', 1)" style="vertical-align: middle;" />' . "\n";
echo '</td></tr> ';
?>
</table></form>
<?php
if (!isset($dontlimitchars)) {
$dontlimitchars = 0;
}
// hide edit and delete links for information_schema
if (PMA_MYSQL_INT_VERSION >= 50002 && isset($db) && $db == 'information_schema') {
$disp_mode = 'nnnn110111';
}
PMA_displayTable($result, $disp_mode, $analyzed_sql);
PMA_DBI_free_result($result);
// BEGIN INDEX CHECK See if indexes should be checked.
if (isset($query_type) && $query_type == 'check_tbl' && isset($selected) && is_array($selected)) {
foreach ($selected as $idx => $tbl_name) {
$indexes = $indexes_info = $indexes_data = array();
$tbl_ret_keys = PMA_get_indexes(urldecode($tbl_name), $err_url_0);
PMA_extract_indexes($tbl_ret_keys, $indexes, $indexes_info, $indexes_data);
$idx_collection = PMA_show_indexes(urldecode($tbl_name), $indexes, $indexes_info, $indexes_data, false);
$check = PMA_check_indexes($idx_collection);
if (!empty($check)) {
?>
<table border="0" cellpadding="2" cellspacing="0">
<tr>
<td class="tblHeaders" colspan="7"><?php
printf($strIndexWarningTable, urldecode($tbl_name));
?>
</td>
</tr>
<?php
echo $check;
?>
</table>
<?php
<th><?php
echo $strType;
?>
</th>
<th><?php
echo $strCardinality;
?>
</th>
<th colspan="2"><?php
echo $strField;
?>
</th>
</tr>
<?php
echo "\n";
PMA_show_indexes($table, $indexes, $indexes_info, $indexes_data, true, true);
echo "\n";
?>
</table>
<?php
echo "\n";
}
// end display indexes
/**
* Displays Space usage and row statistics
*
* staybyte - 9 June 2001
*/
if ($cfg['ShowStats']) {
$nonisam = false;
if (isset($showtable['Type']) && !preg_match('@ISAM|HEAP@i', $showtable['Type'])) {
