diff options
Diffstat (limited to '')
| -rw-r--r-- | hugo/tbl_indexes.php | 365 |
1 files changed, 365 insertions, 0 deletions
diff --git a/hugo/tbl_indexes.php b/hugo/tbl_indexes.php new file mode 100644 index 0000000..a778814 --- /dev/null +++ b/hugo/tbl_indexes.php @@ -0,0 +1,365 @@ +<?php +/* vim: set expandtab sw=4 ts=4 sts=4: */ +/** + * Displays index edit/creation form and handles it + * + * @package PhpMyAdmin + */ + +/** + * Gets some core libraries + */ +require_once 'libraries/common.inc.php'; +require_once 'libraries/Index.class.php'; +require_once 'libraries/tbl_common.inc.php'; + +// Get fields and stores their name/type +$fields = array(); +foreach (PMA_DBI_get_columns_full($db, $table) as $row) { + if (preg_match('@^(set|enum)\((.+)\)$@i', $row['Type'], $tmp)) { + $tmp[2] = substr( + preg_replace('@([^,])\'\'@', '\\1\\\'', ',' . $tmp[2]), 1 + ); + $fields[$row['Field']] = $tmp[1] . '(' + . str_replace(',', ', ', $tmp[2]) . ')'; + } else { + $fields[$row['Field']] = $row['Type']; + } +} // end while + +// Prepares the form values +if (isset($_REQUEST['index'])) { + if (is_array($_REQUEST['index'])) { + // coming already from form + $index = new PMA_Index($_REQUEST['index']); + } else { + $index = PMA_Index::singleton($db, $table, $_REQUEST['index']); + } +} else { + $index = new PMA_Index; +} + +/** + * Process the data from the edit/create index form, + * run the query to build the new index + * and moves back to "tbl_sql.php" + */ +if (isset($_REQUEST['do_save_data'])) { + $error = false; + + // $sql_query is the one displayed in the query box + $sql_query = 'ALTER TABLE ' . PMA_Util::backquote($db) + . '.' . PMA_Util::backquote($table); + + // Drops the old index + if (! empty($_REQUEST['old_index'])) { + if ($_REQUEST['old_index'] == 'PRIMARY') { + $sql_query .= ' DROP PRIMARY KEY,'; + } else { + $sql_query .= ' DROP INDEX ' + . PMA_Util::backquote($_REQUEST['old_index']) . ','; + } + } // end if + + // Builds the new one + switch ($index->getType()) { + case 'PRIMARY': + if ($index->getName() == '') { + $index->setName('PRIMARY'); + } elseif ($index->getName() != 'PRIMARY') { + $error = PMA_Message::error( + __('The name of the primary key must be "PRIMARY"!') + ); + } + $sql_query .= ' ADD PRIMARY KEY'; + break; + case 'FULLTEXT': + case 'UNIQUE': + case 'INDEX': + case 'SPATIAL': + if ($index->getName() == 'PRIMARY') { + $error = PMA_Message::error(__('Can\'t rename index to PRIMARY!')); + } + $sql_query .= ' ADD ' . $index->getType() . ' ' + . ($index->getName() ? PMA_Util::backquote($index->getName()) : ''); + break; + } // end switch + + $index_fields = array(); + foreach ($index->getColumns() as $key => $column) { + $index_fields[$key] = PMA_Util::backquote($column->getName()); + if ($column->getSubPart()) { + $index_fields[$key] .= '(' . $column->getSubPart() . ')'; + } + } // end while + + if (empty($index_fields)) { + $error = PMA_Message::error(__('No index parts defined!')); + } else { + $sql_query .= ' (' . implode(', ', $index_fields) . ')'; + } + + if (PMA_MYSQL_INT_VERSION > 50500) { + $sql_query .= "COMMENT '" + . PMA_Util::sqlAddSlashes($index->getComment()) + . "'"; + } + $sql_query .= ';'; + + if (! $error) { + PMA_DBI_query($sql_query); + $message = PMA_Message::success( + __('Table %1$s has been altered successfully') + ); + $message->addParam($table); + + if ($GLOBALS['is_ajax_request'] == true) { + $response = PMA_Response::getInstance(); + $response->addJSON('message', $message); + $response->addJSON('index_table', PMA_Index::getView($table, $db)); + $response->addJSON( + 'sql_query', + PMA_Util::getMessage(null, $sql_query) + ); + } else { + $active_page = 'tbl_structure.php'; + include 'tbl_structure.php'; + } + exit; + } else { + if ($GLOBALS['is_ajax_request'] == true) { + $response = PMA_Response::getInstance(); + $response->isSuccess(false); + $response->addJSON('message', $error); + exit; + } else { + $error->display(); + } + } +} // end builds the new index + + +/** + * Display the form to edit/create an index + */ + +// Displays headers (if needed) +$response = PMA_Response::getInstance(); +$header = $response->getHeader(); +$scripts = $header->getScripts(); +$scripts->addFile('indexes.js'); +require_once 'libraries/tbl_info.inc.php'; + +if (isset($_REQUEST['index']) && is_array($_REQUEST['index'])) { + // coming already from form + $add_fields + = count($_REQUEST['index']['columns']['names']) - $index->getColumnCount(); + if (isset($_REQUEST['add_fields'])) { + $add_fields += $_REQUEST['added_fields']; + } +} elseif (isset($_REQUEST['create_index'])) { + $add_fields = $_REQUEST['added_fields']; +} else { + $add_fields = 1; +} + +// end preparing form values +?> + +<form action="tbl_indexes.php" method="post" name="index_frm" id="index_frm" class="ajax" + onsubmit="if (typeof(this.elements['index[Key_name]'].disabled) != 'undefined') { + this.elements['index[Key_name]'].disabled = false}"> +<?php +$form_params = array( + 'db' => $db, + 'table' => $table, +); + +if (isset($_REQUEST['create_index'])) { + $form_params['create_index'] = 1; +} elseif (isset($_REQUEST['old_index'])) { + $form_params['old_index'] = $_REQUEST['old_index']; +} elseif (isset($_REQUEST['index'])) { + $form_params['old_index'] = $_REQUEST['index']; +} + +echo PMA_generate_common_hidden_inputs($form_params); +?> +<fieldset id="index_edit_fields"> +<?php +if ($GLOBALS['is_ajax_request'] != true) { + ?> + <legend> + <?php + if (isset($_REQUEST['create_index'])) { + echo __('Add index'); + } else { + echo __('Edit index'); + } + ?> + </legend> + <?php +} +?> +<div class='index_info'> + <div> + <div class="label"> + <strong> + <label for="input_index_name"> + <?php echo __('Index name:'); ?> + <?php +echo PMA_Util::showHint( + PMA_Message::notice( + __( + '("PRIMARY" <b>must</b> be the name of' + . ' and <b>only of</b> a primary key!)' + ) + ) +); + ?> + </label> + </strong> + </div> + <input type="text" name="index[Key_name]" id="input_index_name" size="25" + value="<?php echo htmlspecialchars($index->getName()); ?>" + onfocus="this.select()" /> + </div> +<?php +if (PMA_MYSQL_INT_VERSION > 50500) { +?> + <div> + <div class="label"> + <strong> + <label for="input_index_comment"> + <?php echo __('Comment:'); ?> + </label> + </strong> + </div> + <input type="text" name="index[Index_comment]" id="input_index_comment" size="30" + value="<?php echo htmlspecialchars($index->getComment()); ?>" + onfocus="this.select()" /> + </div> +<?php +} +?> + <div> + <div class="label"> + <strong> + <label for="select_index_type"> + <?php echo __('Index type:'); ?> + <?php echo PMA_Util::showMySQLDocu('SQL-Syntax', 'ALTER_TABLE'); ?> + </label> + </strong> + </div> + <select name="index[Index_type]" id="select_index_type" > + <?php echo $index->generateIndexSelector(); ?> + </select> + </div> + <div class="clearfloat"></div> +</div> + +<table id="index_columns"> +<thead> +<tr><th><?php echo __('Column'); ?></th> + <th><?php echo __('Size'); ?></th> +</tr> +</thead> +<tbody> +<?php +$odd_row = true; +$spatial_types = array( + 'geometry', 'point', 'linestring', 'polygon', 'multipoint', + 'multilinestring', 'multipolygon', 'geomtrycollection' +); +foreach ($index->getColumns() as $column) { + ?> + <tr class="<?php echo $odd_row ? 'odd' : 'even'; ?> noclick"> + <td> + <select name="index[columns][names][]"> + <option value="">-- <?php echo __('Ignore'); ?> --</option> + <?php + foreach ($fields as $field_name => $field_type) { + if (($index->getType() != 'FULLTEXT' + || preg_match('/(char|text)/i', $field_type)) + && ($index->getType() != 'SPATIAL' + || in_array($field_type, $spatial_types)) + ) { + echo '<option value="' . htmlspecialchars($field_name) . '"' + . (($field_name == $column->getName()) + ? ' selected="selected"' + : '') . '>' + . htmlspecialchars($field_name) . ' [' + . htmlspecialchars($field_type) . ']' + . '</option>' . "\n"; + } + } // end foreach $fields + ?> + </select> + </td> + <td> + <input type="text" size="5" onfocus="this.select()" + name="index[columns][sub_parts][]" + value="<?php + if ($index->getType() != 'SPATIAL') { + echo $column->getSubPart(); + } + ?>"/> + </td> + </tr> + <?php + $odd_row = !$odd_row; +} // end foreach $edited_index_info['Sequences'] +for ($i = 0; $i < $add_fields; $i++) { + ?> + <tr class="<?php echo $odd_row ? 'odd' : 'even'; ?> noclick"> + <td> + <select name="index[columns][names][]"> + <option value="">-- <?php echo __('Ignore'); ?> --</option> + <?php + foreach ($fields as $field_name => $field_type) { + echo '<option value="' . htmlspecialchars($field_name) . '">' + . htmlspecialchars($field_name) . ' [' + . htmlspecialchars($field_type) . ']' + . '</option>' . "\n"; + } // end foreach $fields + ?> + </select> + </td> + <td> + <input type="text" size="5" onfocus="this.select()" + name="index[columns][sub_parts][]" value="" /> + </td> + </tr> + <?php + $odd_row = !$odd_row; +} // end foreach $edited_index_info['Sequences'] +?> +</tbody> +</table> +</fieldset> +<fieldset class="tblFooters"> +<?php +if ($GLOBALS['is_ajax_request'] != true || ! empty($_REQUEST['ajax_page_request'])) { + ?> + <input type="submit" name="do_save_data" value="<?php echo __('Save'); ?>" /> + <span id="addMoreColumns"> + <?php + echo __('Or') . ' '; + printf( + __('Add %s column(s) to index') . "\n", + '<input type="text" name="added_fields" size="2" value="1" />' + ); + echo '<input type="submit" name="add_fields" value="' . __('Go') . '" />' . "\n"; + ?> + </span> + <?php +} else { + $btn_value = sprintf(__('Add %s column(s) to index'), 1); + echo '<div class="slider"></div>'; + echo '<div class="add_fields">'; + echo '<input type="submit" value="' . $btn_value . '" />'; + echo '</div>'; +} +?> +</fieldset> +</form> |