';
} else {
$iconic_spacer = '';
}
// images replaced 2004-05-08 by mkkeck
$titles['Change'] = $iconic_spacer
. '
';
$titles['Drop'] = $iconic_spacer
. '
';
$titles['NoDrop'] = $iconic_spacer
. '
';
$titles['Primary'] = $iconic_spacer
. '
';
$titles['Index'] = $iconic_spacer
. '
';
$titles['Unique'] = $iconic_spacer
. '
';
$titles['IdxFulltext'] = $iconic_spacer
. '
';
$titles['NoPrimary'] = $iconic_spacer
. '
';
$titles['NoIndex'] = $iconic_spacer
. '
';
$titles['NoUnique'] = $iconic_spacer
. '
';
$titles['NoIdxFulltext'] = $iconic_spacer
. '
';
$titles['BrowseDistinctValues'] = $iconic_spacer
. '
';
if ($cfg['PropertiesIconic'] === 'both') {
$titles['Change'] .= $strChange . '';
$titles['Drop'] .= $strDrop . '';
$titles['NoDrop'] .= $strDrop . '';
$titles['Primary'] .= $strPrimary . '';
$titles['Index'] .= $strIndex . '';
$titles['Unique'] .= $strUnique . '';
$titles['IdxFulltext' ] .= $strIdxFulltext . '';
$titles['NoPrimary'] .= $strPrimary . '';
$titles['NoIndex'] .= $strIndex . '';
$titles['NoUnique'] .= $strUnique . '';
$titles['NoIdxFulltext'] .= $strIdxFulltext . '';
$titles['BrowseDistinctValues'] .= $strBrowseDistinctValues . '';
}
} else {
$titles['Change'] = $strChange;
$titles['Drop'] = $strDrop;
$titles['NoDrop'] = $strDrop;
$titles['Primary'] = $strPrimary;
$titles['Index'] = $strIndex;
$titles['Unique'] = $strUnique;
$titles['IdxFulltext'] = $strIdxFulltext;
$titles['NoPrimary'] = $strPrimary;
$titles['NoIndex'] = $strIndex;
$titles['NoUnique'] = $strUnique;
$titles['NoIdxFulltext'] = $strIdxFulltext;
$titles['BrowseDistinctValues'] = $strBrowseDistinctValues;
}
/**
* Displays the table structure ('show table' works correct since 3.23.03)
*/
/* TABLE INFORMATION */
// table header
$i = 0;
?>
';
}
echo $strPrintView;
?>
';
}
echo $strRelationView;
?>
';
}
echo $strStructPropose;
?>
20) {
require './libraries/tbl_links.inc.php';
} // end if ($fields_cnt > 20)
echo "\n\n";
/**
* Displays indexes
*/
echo '' . "\n";
if (! $tbl_is_view && ! $db_is_information_schema) {
define('PMA_IDX_INCLUDED', 1);
require './tbl_indexes.php';
}
/**
* Displays Space usage and row statistics
*/
// BEGIN - Calc Table Space - staybyte - 9 June 2001
// loic1, 22 feb. 2002: updated with patch from
// Joshua Nye
to get valid
// statistics whatever is the table type
if ($cfg['ShowStats']) {
$nonisam = false;
$is_innodb = (isset($showtable['Type']) && $showtable['Type'] == 'InnoDB');
if (isset($showtable['Type']) && !preg_match('@ISAM|HEAP@i', $showtable['Type'])) {
$nonisam = true;
}
// Gets some sizes
$mergetable = false;
if (isset($showtable['Type']) && $showtable['Type'] == 'MRG_MyISAM') {
$mergetable = true;
}
list($data_size, $data_unit) = PMA_formatByteDown($showtable['Data_length']);
if ($mergetable == false) {
list($index_size, $index_unit) = PMA_formatByteDown($showtable['Index_length']);
}
if (isset($showtable['Data_free']) && $showtable['Data_free'] > 0) {
list($free_size, $free_unit) = PMA_formatByteDown($showtable['Data_free']);
list($effect_size, $effect_unit) = PMA_formatByteDown($showtable['Data_length'] + $showtable['Index_length'] - $showtable['Data_free']);
} else {
list($effect_size, $effect_unit) = PMA_formatByteDown($showtable['Data_length'] + $showtable['Index_length']);
}
list($tot_size, $tot_unit) = PMA_formatByteDown($showtable['Data_length'] + $showtable['Index_length']);
if ($table_info_num_rows > 0) {
list($avg_size, $avg_unit) = PMA_formatByteDown(($showtable['Data_length'] + $showtable['Index_length']) / $showtable['Rows'], 6, 1);
}
// Displays them
$odd_row = false;
?>
|
|
|
|
= 40100 && !empty($tbl_collation)) {
?>
|
' . $tbl_collation . '';
?> |
|
|
0) {
?>
ø |
|
0 && $mergetable == false) {
?>
ø |
|
Autoindex |
|
|
|
|
|
|
|
' . "\n";
echo '' . "\n";
/**
* Displays the footer
*/
require_once './libraries/footer.inc.php';
?>