Initial commit of intern.ccwn.org contentsHEADmaster

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 .= '&amp;goto=tbl_structure.php&amp;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>'
+);
+
+?>