'; } 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['Browse'] = $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['Browse'] .= $strBrowse . ''; } } 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['Browse'] = $strBrowse; } /** * Displays the table structure ('show table' works correct since 3.23.03) */ /* TABLE INFORMATION */ // table header $i = 0; ?>

= 40100 ? ' ' . "\n" : ''; ?> = 4.1) unset($field_charset); if (PMA_MYSQL_INT_VERSION >= 40100) { if ((substr($type, 0, 4) == 'char' || substr($type, 0, 7) == 'varchar' || substr($type, 0, 4) == 'text' || substr($type, 0, 8) == 'tinytext' || substr($type, 0, 10) == 'mediumtext' || substr($type, 0, 8) == 'longtext' || substr($type, 0, 3) == 'set' || substr($type, 0, 4) == 'enum' ) && !$binary) { if (strpos($type, ' character set ')) { $type = substr($type, 0, strpos($type, ' character set ')); } if (!empty($row['Collation'])) { $field_charset = $row['Collation']; } else { $field_charset = ''; } } else { $field_charset = ''; } } // garvin: Display basic mimetype [MIME] if ($cfgRelation['commwork'] && $cfgRelation['mimework'] && $cfg['BrowseMIME'] && isset($mime_map[$row['Field']]['mimetype'])) { $type_mime = '
MIME: ' . str_replace('_', '/', $mime_map[$row['Field']]['mimetype']); } else { $type_mime = ''; } $attribute = ' '; if ($binary) { $attribute = 'BINARY'; } if ($unsigned) { $attribute = 'UNSIGNED'; } if ($zerofill) { $attribute = 'UNSIGNED ZEROFILL'; } // MySQL 4.1.2+ TIMESTAMP options // (if on_update_current_timestamp is set, then it's TRUE) if (isset($analyzed_sql[0]['create_table_fields'][$row['Field']]['on_update_current_timestamp'])) { $attribute = 'ON UPDATE CURRENT_TIMESTAMP'; } // here, we have a TIMESTAMP that SHOW FULL FIELDS reports as having the // NULL attribute, but SHOW CREATE TABLE says the contrary. Believe // the latter. if (!empty($analyzed_sql[0]['create_table_fields'][$row['Field']]['type']) && $analyzed_sql[0]['create_table_fields'][$row['Field']]['type'] == 'TIMESTAMP' && $analyzed_sql[0]['create_table_fields'][$row['Field']]['timestamp_not_null']) { $row['Null'] = ''; } if (!isset($row['Default'])) { if ($row['Null'] == 'YES') { $row['Default'] = 'NULL'; } } else { $row['Default'] = htmlspecialchars($row['Default']); } $field_encoded = urlencode($row['Field']); $field_name = htmlspecialchars($row['Field']); // garvin: underline commented fields and display a hover-title (CSS only) $comment_style = ''; if (isset($comments_map[$row['Field']])) { $field_name = '' . $field_name . ''; } if (isset($pk_array[$row['Field']])) { $field_name = '' . $field_name . ''; } echo "\n"; ?> > = 40100 ? ' ' . "\n" : '' ?> ' . "\n" .'

			' . $strCollation . '
/>		' . (empty($field_charset) ? '' : '' . $field_charset . '') . '							1) { echo "\n"; ?>

' . "\n"; $checkall_url = 'tbl_properties_structure.php?' . PMA_generate_common_url($db,$table); ?>

/ ' . "\n"; } if ( ! $tbl_is_view && ! $db_is_information_schema ) { if ($cfg['PropertiesIconic']) { PMA_buttonOrImage('submit_mult', 'mult_submit', 'submit_mult_change', $strChange, 'b_edit.png'); // Drop button if there is at least two fields if ($fields_cnt > 1) { PMA_buttonOrImage('submit_mult', 'mult_submit', 'submit_mult_drop', $strDrop, 'b_drop.png'); } PMA_buttonOrImage('submit_mult', 'mult_submit', 'submit_mult_primary', $strPrimary, 'b_primary.png'); PMA_buttonOrImage('submit_mult', 'mult_submit', 'submit_mult_index', $strIndex, 'b_index.png'); PMA_buttonOrImage('submit_mult', 'mult_submit', 'submit_mult_unique', $strUnique, 'b_unique.png'); if ((!empty($tbl_type) && $tbl_type == 'MYISAM')) { PMA_buttonOrImage('submit_mult', 'mult_submit', 'submit_mult_fulltext', $strIdxFulltext, 'b_ftext.png'); } } else { // Drop button if there is at least two fields if ($fields_cnt > 1) { echo '' . $strOr . '' . "\n" . '' . "\n"; } echo '' . $strOr . '' . "\n" . '' . "\n"; echo '' . $strOr . '' . "\n" . '' . "\n"; echo '' . $strOr . '' . "\n" . '' . "\n"; if ((!empty($tbl_type) && $tbl_type == 'MYISAM')) { echo '' . $strOr . '' . "\n" . '' . "\n"; } } } ?>

'; } echo $strPrintView; ?> '; } echo $strRelationView; ?> '; } echo $strStructPropose; ?>

'; } echo sprintf($strAddFields, ''); ?> '; echo str_replace('', '', '' . sprintf($strAfter, $fieldOptions) . '') . "\n"; ?>

20) { require('./tbl_properties_links.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; ?>








'; } echo $strOptimizeTable; ?>

= 40100 && !empty($tbl_collation)) { ?> 0) { ?> 0 && $mergetable == FALSE) { ?>




	' . $tbl_collation . ''; ?>

ø
ø
Autoindex

' . "\n"; echo '' . "\n"; /** * Displays the footer */ require_once('./footer.inc.php'); ?>