diff options
Diffstat (limited to 'hugo/tbl_structure.php')
| -rw-r--r-- | hugo/tbl_structure.php | 469 |
1 files changed, 469 insertions, 0 deletions
diff --git a/hugo/tbl_structure.php b/hugo/tbl_structure.php new file mode 100644 index 0000000..5e8e7ce --- /dev/null +++ b/hugo/tbl_structure.php @@ -0,0 +1,469 @@ +<?php +/* vim: set expandtab sw=4 ts=4 sts=4: */ +/** + * Displays table structure infos like fields/columns, indexes, size, rows + * and allows manipulation of indexes and columns/fields + * + * @package PhpMyAdmin + */ + +/** + * + */ +require_once 'libraries/common.inc.php'; +require_once 'libraries/mysql_charsets.lib.php'; + +/** + * Function implementations for this script + */ +require_once 'libraries/structure.lib.php'; +require_once 'libraries/index.lib.php'; + +$response = PMA_Response::getInstance(); +$header = $response->getHeader(); +$scripts = $header->getScripts(); +$scripts->addFile('tbl_structure.js'); +$scripts->addFile('indexes.js'); + +/** + * Handle column moving + */ +if (isset($_REQUEST['move_columns']) + && is_array($_REQUEST['move_columns']) + && $response->isAjax() +) { + PMA_moveColumns($db, $table); + exit; +} + +/** + * A click on Change has been made for one column + */ +if (isset($_REQUEST['change_column'])) { + PMA_displayHtmlForColumnChange($db, $table, null, 'tbl_structure.php'); + exit; +} +/** + * Modifications have been submitted -> updates the table + */ +if (isset($_REQUEST['do_save_data'])) { + $regenerate = PMA_updateColumns($db, $table); + if ($regenerate) { + // This happens when updating failed + // @todo: do something appropriate + } else { + // continue to show the table's structure + unset($_REQUEST['selected']); + unset($_REQUEST['true_selected']); + } +} + +/** + * handle multiple field commands if required + * + * submit_mult_*_x comes from IE if <input type="img" ...> is used + */ +if (isset($_REQUEST['submit_mult_change_x'])) { + $submit_mult = 'change'; +} elseif (isset($_REQUEST['submit_mult_drop_x'])) { + $submit_mult = 'drop'; +} elseif (isset($_REQUEST['submit_mult_primary_x'])) { + $submit_mult = 'primary'; +} elseif (isset($_REQUEST['submit_mult_index_x'])) { + $submit_mult = 'index'; +} elseif (isset($_REQUEST['submit_mult_unique_x'])) { + $submit_mult = 'unique'; +} elseif (isset($_REQUEST['submit_mult_spatial_x'])) { + $submit_mult = 'spatial'; +} elseif (isset($_REQUEST['submit_mult_fulltext_x'])) { + $submit_mult = 'ftext'; +} elseif (isset($_REQUEST['submit_mult_browse_x'])) { + $submit_mult = 'browse'; +} elseif (isset($_REQUEST['submit_mult'])) { + $submit_mult = $_REQUEST['submit_mult']; +} elseif (isset($_REQUEST['mult_btn']) && $_REQUEST['mult_btn'] == __('Yes')) { + $submit_mult = 'row_delete'; + if (isset($_REQUEST['selected'])) { + $_REQUEST['selected_fld'] = $_REQUEST['selected']; + } +} +if (! empty($submit_mult)) { + if (isset($_REQUEST['selected_fld'])) { + $err_url = 'tbl_structure.php?' . PMA_generate_common_url($db, $table); + if ($submit_mult == 'browse') { + // browsing the table displaying only selected fields/columns + $GLOBALS['active_page'] = 'sql.php'; + $sql_query = ''; + foreach ($_REQUEST['selected_fld'] as $idx => $sval) { + if ($sql_query == '') { + $sql_query .= 'SELECT ' . PMA_Util::backquote($sval); + } else { + $sql_query .= ', ' . PMA_Util::backquote($sval); + } + } + $sql_query .= ' FROM ' . PMA_Util::backquote($db) + . '.' . PMA_Util::backquote($table); + include 'sql.php'; + exit; + } else { + // handle multiple field commands + // handle confirmation of deleting multiple fields/columns + $action = 'tbl_structure.php'; + include 'libraries/mult_submits.inc.php'; + /** + * if $submit_mult == 'change', execution will have stopped + * at this point + */ + + if (empty($message)) { + $message = PMA_Message::success(); + } + } + } else { + $response = PMA_Response::getInstance(); + $response->isSuccess(false); + $response->addJSON('message', __('No column selected.')); + } +} + +/** + * Gets the relation settings + */ +$cfgRelation = PMA_getRelationsParam(); + +/** + * Runs common work + */ +require_once 'libraries/tbl_common.inc.php'; +$url_query .= '&goto=tbl_structure.php&back=tbl_structure.php'; +$url_params['goto'] = 'tbl_structure.php'; +$url_params['back'] = 'tbl_structure.php'; + +// Check column names for MySQL reserved words +if ($cfg['ReservedWordDisableWarning'] === false) { + $pma_table = new PMA_Table($table, $db); + $columns = $pma_table->getReservedColumnNames(); + if (! empty($columns)) { + foreach ($columns as $column) { + $msg = PMA_message::notice( + __('The column name \'%s\' is a MySQL reserved keyword.') + ); + $msg->addParam($column); + $response->addHTML($msg); + } + } +} + +/** + * Prepares the table structure display + */ + + +/** + * Gets tables informations + */ +require_once 'libraries/tbl_info.inc.php'; + +require_once 'libraries/Index.class.php'; + +// 2. Gets table keys and retains them +// @todo should be: $server->db($db)->table($table)->primary() +$primary = PMA_Index::getPrimary($table, $db); + +$columns_with_unique_index = array(); +foreach (PMA_Index::getFromTable($table, $db) as $index) { + if ($index->isUnique() && $index->getChoice() == 'UNIQUE') { + $columns = $index->getColumns(); + foreach ($columns as $column_name => $dummy) { + $columns_with_unique_index[$column_name] = 1; + } + } +} +unset($index, $columns, $column_name, $dummy); + +// 3. Get fields +$fields = (array) PMA_DBI_get_columns($db, $table, null, true); + +// Get more complete field information +// For now, this is done just for MySQL 4.1.2+ new TIMESTAMP options +// but later, if the analyser returns more information, it +// could be executed for any MySQL version and replace +// the info given by SHOW FULL COLUMNS FROM. +// +// We also need this to correctly learn if a TIMESTAMP is NOT NULL, since +// SHOW FULL COLUMNS or INFORMATION_SCHEMA incorrectly says NULL +// and SHOW CREATE TABLE says NOT NULL (tested +// in MySQL 4.0.25 and 5.0.21, http://bugs.mysql.com/20910). + +$show_create_table = PMA_DBI_fetch_value( + 'SHOW CREATE TABLE ' . PMA_Util::backquote($db) . '.' + . PMA_Util::backquote($table), + 0, 1 +); +$analyzed_sql = PMA_SQP_analyze(PMA_SQP_parse($show_create_table)); + +/** + * prepare table infos + */ +// action titles (image or string) +$titles = PMA_getActionTitlesArray(); + +// hidden action titles (image and string) +$hidden_titles = PMA_getHiddenTitlesArray(); + +/** + * Displays the table structure ('show table' works correct since 3.23.03) + */ +/* TABLE INFORMATION */ +// table header + + +$HideStructureActions = ''; +if (in_array( + $GLOBALS['cfg']['ActionLinksMode'], + array('text', 'both') + ) + && $GLOBALS['cfg']['HideStructureActions'] === true +) { + $HideStructureActions .= ' HideStructureActions'; +} + +$html_form = '<form method="post" action="tbl_structure.php" name="fieldsForm" ' +. 'id="fieldsForm" class="ajax' . $HideStructureActions . '">'; + +$response->addHTML($html_form); +$response->addHTML(PMA_generate_common_hidden_inputs($db, $table)); + +$tabletype = '<input type="hidden" name="table_type" value='; +if ($db_is_information_schema) { + $tabletype .= '"information_schema" />'; +} else if ($tbl_is_view) { + $tabletype .= '"view" />'; +} else { + $tabletype .= '"table" />'; +} +$response->addHTML($tabletype); + +$tablestructure = '<table id="tablestructure" class="data">'; +$response->addHTML($tablestructure); + + +$response->addHTML( + PMA_getHtmlForTableStructureHeader( + $db_is_information_schema, + $tbl_is_view + ) +); + +$response->addHTML('<tbody>'); + +// table body + +// prepare comments +$comments_map = array(); +$mime_map = array(); + +if ($GLOBALS['cfg']['ShowPropertyComments']) { + include_once 'libraries/transformations.lib.php'; + $comments_map = PMA_getComments($db, $table); + if ($cfgRelation['mimework'] && $cfg['BrowseMIME']) { + $mime_map = PMA_getMIME($db, $table, true); + } +} + +$rownum = 0; +$columns_list = array(); +$save_row = array(); +$odd_row = true; +foreach ($fields as $row) { + $save_row[] = $row; + $rownum++; + $columns_list[] = $row['Field']; + + $type = $row['Type']; + $extracted_columnspec = PMA_Util::extractColumnSpec($row['Type']); + + if ('set' == $extracted_columnspec['type'] + || 'enum' == $extracted_columnspec['type'] + ) { + $type_nowrap = ''; + } else { + $type_nowrap = ' class="nowrap"'; + } + $type = $extracted_columnspec['print_type']; + if (empty($type)) { + $type = ' '; + } + + $field_charset = ''; + if ($extracted_columnspec['can_contain_collation'] + && ! empty($row['Collation']) + ) { + $field_charset = $row['Collation']; + } + + // Display basic mimetype [MIME] + if ($cfgRelation['commwork'] + && $cfgRelation['mimework'] + && $cfg['BrowseMIME'] + && isset($mime_map[$row['Field']]['mimetype']) + ) { + $type_mime = '<br />MIME: ' + . str_replace('_', '/', $mime_map[$row['Field']]['mimetype']); + } else { + $type_mime = ''; + } + + $attribute = $extracted_columnspec['attribute']; + + // prepare a common variable to reuse below; however, + // in case of a VIEW, $analyzed_sql[0]['create_table_fields'] is empty + if (isset($analyzed_sql[0]['create_table_fields'][$row['Field']])) { + $tempField = $analyzed_sql[0]['create_table_fields'][$row['Field']]; + } else { + $tempField = array(); + } + + // MySQL 4.1.2+ TIMESTAMP options + // (if on_update_current_timestamp is set, then it's TRUE) + if (isset($tempField['on_update_current_timestamp'])) { + $attribute = 'on update CURRENT_TIMESTAMP'; + } + + // here, we have a TIMESTAMP that SHOW FULL COLUMNS reports as having the + // NULL attribute, but SHOW CREATE TABLE says the contrary. Believe + // the latter. + if (! empty($tempField['type']) + && $tempField['type'] == 'TIMESTAMP' + && $tempField['timestamp_not_null'] + ) { + $row['Null'] = ''; + } + + + if (! isset($row['Default'])) { + if ($row['Null'] == 'YES') { + $row['Default'] = '<i>NULL</i>'; + } + } else { + $row['Default'] = htmlspecialchars($row['Default']); + } + + $field_encoded = urlencode($row['Field']); + $field_name = htmlspecialchars($row['Field']); + $displayed_field_name = $field_name; + + // underline commented fields and display a hover-title (CSS only) + + if (isset($comments_map[$row['Field']])) { + $displayed_field_name = '<span class="commented_column" title="' + . htmlspecialchars($comments_map[$row['Field']]) . '">' + . $field_name . '</span>'; + } + + if ($primary && $primary->hasColumn($field_name)) { + $displayed_field_name = '<u>' . $field_name . '</u>'; + } + $response->addHTML( + '<tr class="' . ($odd_row ? 'odd': 'even') . '">' + ); + $odd_row = !$odd_row; + + $response->addHTML( + PMA_getHtmlTableStructureRow( + $row, $rownum, $displayed_field_name, + $type_nowrap, $extracted_columnspec, $type_mime, + $field_charset, $attribute, $tbl_is_view, + $db_is_information_schema, $url_query, $field_encoded, $titles, $table + ) + ); + + if (! $tbl_is_view && ! $db_is_information_schema) { + $response->addHTML( + PMA_getHtmlForActionsInTableStructure( + $type, $tbl_storage_engine, $primary, + $field_name, $url_query, $titles, $row, $rownum, + $hidden_titles, $columns_with_unique_index + ) + ); + } // end if (! $tbl_is_view && ! $db_is_information_schema) + + $response->addHTML('</tr>'); + + unset($field_charset); +} // end foreach + +$response->addHTML('</tbody></table>'); + +$response->addHTML( + PMA_getHtmlForCheckAllTableColumn( + $pmaThemeImage, $text_dir, $tbl_is_view, + $db_is_information_schema, $tbl_storage_engine + ) +); + +$response->addHTML( + '</form><hr />' +); +$response->addHTML( + PMA_getHtmlDivForMoveColumnsDialog() +); + +/** + * Work on the table + */ + +if ($tbl_is_view) { + $response->addHTML(PMA_getHtmlForEditView($url_params)); +} +$response->addHTML( + PMA_getHtmlForOptionalActionLinks( + $url_query, $tbl_is_view, $db_is_information_schema, + $tbl_storage_engine, $cfgRelation + ) +); + +if (! $tbl_is_view && ! $db_is_information_schema) { + $response->addHTML('<br />'); + $response->addHTML(PMA_getHtmlForAddColumn($columns_list)); + $response->addHTML( + '<div id="index_div" class="ajax" >' + ); +} + +/** + * Displays indexes + */ + +if (! $tbl_is_view + && ! $db_is_information_schema + && 'ARCHIVE' != $tbl_storage_engine +) { + //return the list of index + $response->addJSON('indexes_list', PMA_Index::getView($GLOBALS['table'], $GLOBALS['db'])); + $response->addHTML(PMA_getHtmlForDisplayIndexes()); +} + +/** + * Displays Space usage and row statistics + */ +// BEGIN - Calc Table Space +// Get valid statistics whatever is the table type +if ($cfg['ShowStats']) { + //get table stats in HTML format + $tablestats = PMA_getHtmlForDisplayTableStats( + $showtable, $table_info_num_rows, $tbl_is_view, + $db_is_information_schema, $tbl_storage_engine, + $url_query, $tbl_collation + ); + //returning the response in JSON format to be used by Ajax + $response->addJSON('tableStat', $tablestats); + $response->addHTML($tablestats); +} +// END - Calc Table Space + +$response->addHTML( + '<div class="clearfloat"></div>' +); + +?> |