'; } 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; ?>

= 40100 ? ' ' . "\n" : ''; ?> = 40100) { $comments_map = PMA_getComments($db, $table); if ($cfgRelation['mimework'] && $cfg['BrowseMIME']) { $mime_map = PMA_getMIME($db, $table, true); } } } $rownum = 0; $aryFields = array(); $checked = (!empty($checkall) ? ' checked="checked"' : ''); $save_row = array(); $odd_row = true; while ($row = PMA_DBI_fetch_assoc($fields_rs)) { $save_row[] = $row; $rownum++; $aryFields[] = $row['Field']; $type = $row['Type']; // reformat mysql query output - staybyte - 9. June 2001 // loic1: set or enum types: slashes single quotes inside options if (preg_match('@^(set|enum)\((.+)\)$@i', $type, $tmp)) { $tmp[2] = substr(preg_replace('@([^,])\'\'@', '\\1\\\'', ',' . $tmp[2]), 1); $type = $tmp[1] . '(' . str_replace(',', ', ', $tmp[2]) . ')'; // for the case ENUM('–','“') $type = htmlspecialchars($type); $type_nowrap = ''; $binary = 0; $unsigned = 0; $zerofill = 0; } else { $type_nowrap = ' nowrap="nowrap"'; // strip the "BINARY" attribute, except if we find "BINARY(" because // this would be a BINARY or VARBINARY field type if (!preg_match('@BINARY[\(]@i', $type)) { $type = preg_replace('@BINARY@i', '', $type); } $type = preg_replace('@ZEROFILL@i', '', $type); $type = preg_replace('@UNSIGNED@i', '', $type); if (empty($type)) { $type = ' '; } if (!preg_match('@BINARY[\(]@i', $row['Type'])) { $binary = stristr($row['Type'], 'blob') || stristr($row['Type'], 'binary'); } else { $binary = false; } $unsigned = stristr($row['Type'], 'unsigned'); $zerofill = stristr($row['Type'], 'zerofill'); } // rabus: Divide charset from the rest of the type definition (MySQL >= 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_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_unique', $strUnique, 'b_unique.png'); PMA_buttonOrImage('submit_mult', 'mult_submit', 'submit_mult_index', $strIndex, 'b_index.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 './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; ?>








'; } echo $strOptimizeTable; ?>

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




	' . $tbl_collation . ''; ?>

ø
ø
Autoindex

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