6 * Gets some core libraries
8 if (!defined('PMA_GRAB_GLOBALS_INCLUDED')) {
9 include('./libraries/grab_globals.lib.php3');
11 if (!defined('PMA_COMMON_LIB_INCLUDED')) {
12 include('./libraries/common.lib.php3');
17 * Defines the index types ("FULLTEXT" is available since MySQL 3.23.23)
25 if (PMA_MYSQL_INT_VERSION
>= 32323) {
26 $index_types[] = 'FULLTEXT';
32 * Ensures the db & table are valid, then loads headers and gets indexes
34 * Skipped if this script is called by "tbl_properties.php3"
36 if (!defined('PMA_IDX_INCLUDED')) {
37 // Not a valid db name -> back to the welcome page
39 $is_db = @PMA_mysql_select_db
($db);
41 if (empty($db) ||
!$is_db) {
42 header('Location: ' . $cfg['PmaAbsoluteUri'] . 'main.php3?lang=' . $lang . '&convcharset=' . $convcharset . '&server=' . $server . (isset($message) ?
'&message=' . urlencode($message) : '') . '&reload=1');
45 // Not a valid table name -> back to the default db_details sub-page
47 $is_table = @PMA_mysql_query
('SHOW TABLES LIKE \'' . PMA_sqlAddslashes($table, TRUE) . '\'');
50 ||
!($is_table && @mysql_numrows
($is_table))) {
51 header('Location: ' . $cfg['PmaAbsoluteUri'] . $cfg['DefaultTabDatabase'] . '?lang=' . $lang . '&convcharset=' . $convcharset . '&server=' . $server .'&db=' . urlencode($db) . (isset($message) ?
'&message=' . urlencode($message) : '') . '&reload=1');
53 } else if (isset($is_table)) {
54 mysql_free_result($is_table);
57 // Displays headers (if needed)
58 $js_to_run = ((isset($index) && isset($do_save_data)) ?
'functions.js' : 'indexes.js');
59 include('./header.inc.php3');
64 * Gets fields and indexes informations
66 if (defined('PMA_IDX_INCLUDED')) {
67 $err_url_0 = 'db_details.php3'
69 . '&convcharset=' . $convcharset
70 . '&server=' . $server
71 . '&db=' . urlencode($db);
74 // Gets table keys and store them in arrays
77 $indexes_info = array();
78 $indexes_data = array();
79 // keys had already been grabbed in "tbl_properties.php3"
80 if (defined('PMA_IDX_INCLUDED')) {
81 $idx_cnt = count($ret_keys);
83 $local_query = 'SHOW KEYS FROM ' . PMA_backquote($table);
84 $result = PMA_mysql_query($local_query) or PMA_mysqlDie('', $local_query, '', $err_url_0);
85 $idx_cnt = mysql_num_rows($result);
88 for ($i = 0; $i < $idx_cnt; $i++
) {
89 $row = (defined('PMA_IDX_INCLUDED') ?
$ret_keys[$i] : PMA_mysql_fetch_array($result));
91 if ($row['Key_name'] != $prev_index ){
92 $indexes[] = $row['Key_name'];
93 $prev_index = $row['Key_name'];
95 $indexes_info[$row['Key_name']]['Sequences'][] = $row['Seq_in_index'];
96 $indexes_info[$row['Key_name']]['Non_unique'] = $row['Non_unique'];
97 if (isset($row['Cardinality'])) {
98 $indexes_info[$row['Key_name']]['Cardinality'] = $row['Cardinality'];
100 // I don't know what does following column mean....
101 // $indexes_info[$row['Key_name']]['Packed'] = $row['Packed'];
102 $indexes_info[$row['Key_name']]['Comment'] = (isset($row['Comment']))
106 $indexes_data[$row['Key_name']][$row['Seq_in_index']]['Column_name'] = $row['Column_name'];
107 if (isset($row['Sub_part'])) {
108 $indexes_data[$row['Key_name']][$row['Seq_in_index']]['Sub_part'] = $row['Sub_part'];
112 if (defined('PMA_IDX_INCLUDED')) {
114 } else if ($result) {
115 mysql_free_result($result);
118 // Get fields and stores their name/type
119 // fields had already been grabbed in "tbl_properties.php3"
120 if (defined('PMA_IDX_INCLUDED')) {
121 mysql_data_seek($fields_rs, 0);
123 $local_query = 'SHOW FIELDS FROM ' . PMA_backquote($table);
124 $fields_rs = PMA_mysql_query($local_query) or PMA_mysqlDie('', $local_query, '', $err_url_0);
125 $fields_cnt = mysql_num_rows($fields_rs);
128 $fields_names = array();
129 $fields_types = array();
130 while ($row = PMA_mysql_fetch_array($fields_rs)) {
131 $fields_names[] = $row['Field'];
132 // loic1: set or enum types: slashes single quotes inside options
133 if (eregi('^(set|enum)\((.+)\)$', $row['Type'], $tmp)) {
134 $tmp[2] = substr(ereg_replace('([^,])\'\'', '\\1\\\'', ',' . $tmp[2]), 1);
135 $fields_types[] = $tmp[1] . '(' . str_replace(',', ', ', $tmp[2]) . ')';
137 $fields_types[] = $row['Type'];
142 mysql_free_result($fields_rs);
147 * Stipslashes some variables if required
149 if (get_magic_quotes_gpc()) {
151 $index = stripslashes($index);
153 if (isset($old_index)) {
154 $old_index = stripslashes($old_index);
160 * Do run the query to build the new index and moves back to
161 * "tbl_properties.php3"
163 if (!defined('PMA_IDX_INCLUDED')
164 && (isset($index) && isset($do_save_data))) {
166 $err_url = 'tbl_indexes.php3'
168 . '&convcharset=' . $convcharset
169 . '&server=' . $server
170 . '&db=' . urlencode($db)
171 . '&table=' . urlencode($table);
172 if (empty($old_index)) {
173 $err_url .= '&create_index=1&idx_num_fields=' . $idx_num_fields;
175 $err_url .= '&index=' . urlencode($old_index);
178 if ($index_type == 'PRIMARY') {
181 } else if ($index != 'PRIMARY') {
182 PMA_mysqlDie($strPrimaryKeyName, '', FALSE, $err_url);
184 } else if ($index == 'PRIMARY') {
185 PMA_mysqlDie($strCantRenameIdxToPrimary, '', FALSE, $err_url);
189 // $sql_query is the one displayed in the query box, don't use it when you
190 // need to generate a query in this script
191 $local_query = 'ALTER TABLE ' . PMA_backquote($table);
193 // Drops the old index
194 if (!empty($old_index)) {
195 if ($old_index == 'PRIMARY') {
196 $local_query .= ' DROP PRIMARY KEY,';
198 $local_query .= ' DROP INDEX ' . PMA_backquote($old_index) .',';
202 // Builds the new one
203 switch ($index_type) {
205 $local_query .= ' ADD PRIMARY KEY (';
208 $local_query .= ' ADD FULLTEXT ' . (empty($index) ?
'' : PMA_backquote($index)) . ' (';
211 $local_query .= ' ADD UNIQUE ' . (empty($index) ?
'' : PMA_backquote($index)) . ' (';
214 $local_query .= ' ADD INDEX ' . (empty($index) ?
'' : PMA_backquote($index)) . ' (';
218 while (list($i, $name) = each($column)) {
219 if ($name != '--ignore--') {
220 $index_fields .= (empty($index_fields) ?
'' : ',')
221 . PMA_backquote(get_magic_quotes_gpc() ?
stripslashes($name) : $name)
222 . (empty($sub_part[$i]) ?
'' : '(' . $sub_part[$i] . ')');
225 if (empty($index_fields)){
226 PMA_mysqlDie($strNoIndexPartsDefined, '', FALSE, $err_url);
228 $local_query .= $index_fields . ')';
231 $result = PMA_mysql_query($local_query) or PMA_mysqlDie('', $local_query, FALSE, $err_url);
232 $message = $strTable . ' ' . htmlspecialchars($table) . ' ' . $strHasBeenAltered;
234 include('./tbl_properties.php3');
236 } // end builds the new index
240 * Edits an index or defines a new one
242 else if (!defined('PMA_IDX_INCLUDED')
243 && (isset($index) ||
isset($create_index))) {
245 // Prepares the form values
246 if (!isset($index)) {
249 if (!isset($old_index)){
252 if (!isset($index_type)) {
255 if ($old_index == '' ||
!isset($indexes_info[$old_index])) {
256 $edited_index_info['Sequences'] = array();
257 $edited_index_data = array();
258 for ($i = 1; $i <= $idx_num_fields; $i++
) {
259 $edited_index_info['Sequences'][] = $i;
260 $edited_index_data[$i] = array('Column_name' => '', 'Sub_part' => '');
263 && !isset($indexes_info['PRIMARY'])
264 && ($index_type == '' ||
$index_type == 'PRIMARY')) {
265 $old_index = 'PRIMARY';
268 $edited_index_info = $indexes_info[$old_index];
269 $edited_index_data = $indexes_data[$old_index];
270 if ($edited_index_info['Comment'] == 'FULLTEXT') {
271 $index_type = 'FULLTEXT';
272 } else if ($index == 'PRIMARY') {
273 $index_type = 'PRIMARY';
274 } else if ($edited_index_info['Non_unique'] == '0') {
275 $index_type = 'UNIQUE';
277 $index_type = 'INDEX';
279 } // end if... else...
281 if (isset($add_fields)) {
282 if (isset($prev_add_fields)) {
283 $added_fields +
= $prev_add_fields;
285 $field_cnt = count($edited_index_info['Sequences']) +
1;
286 for ($i = $field_cnt; $i < ($added_fields +
$field_cnt); $i++
) {
287 $edited_index_info['Sequences'][] = $i;
288 $edited_index_data[$i] = array('Column_name' => '', 'Sub_part' => '');
291 // Restore entered values
292 while (list($i, $name) = each($column)) {
293 if ($name != '--ignore--'){
294 $edited_index_data[$i+
1]['Column_name'] = $name;
295 $edited_index_data[$i+
1]['Sub_part'] = $sub_part[$i];
299 // end preparing form values
302 <!-- Build index form
-->
303 <form action
="tbl_indexes.php3" method
="post" name
="index_frm"
304 onsubmit
="if (typeof(this.elements['index'].disabled) != 'undefined') {this.elements['index'].disabled = false}">
305 <input type
="hidden" name
="lang" value
="<?php echo $lang; ?>" />
306 <input type
="hidden" name
="convcharset" value
="<?php echo $convcharset; ?>" />
307 <input type
="hidden" name
="server" value
="<?php echo $server; ?>" />
308 <input type
="hidden" name
="db" value
="<?php echo $db; ?>" />
309 <input type
="hidden" name
="table" value
="<?php echo $table; ?>" />
311 if (isset($create_index)) {
312 echo '<input type="hidden" name="create_index" value="1" />';
316 <input type
="hidden" name
="old_index" value
="<?php echo (isset($create_index) ? '' : $old_index); ?>" />
317 <b
><?php
echo '------ ' . (isset($create_index) ?
$strCreateIndexTopic : $strModifyIndexTopic) . ' ------'; ?
></b
>
322 <td
><?php
echo $strIndexName; ?
> 
;</td
>
324 <input type
="text" name
="index" value
="<?php echo htmlspecialchars($index); ?>" class="textfield" onfocus
="this.select()" />
325  
;<?php
echo $strPrimaryKeyWarning . "\n"; ?
>
329 <td
><?php
echo $strIndexType; ?
> 
;</td
>
331 <select name
="index_type" onchange
="return checkIndexName()">
334 for ($i = 0; $i < $index_types_cnt; $i++
) {
335 if ($index_types[$i] == 'PRIMARY') {
336 if ($index == 'PRIMARY' ||
!isset($indexes_info['PRIMARY'])) {
338 . '<option value="PRIMARY"' . (($index_type == 'PRIMARY') ?
' selected="selected"' : '') . '>PRIMARY</option>'
343 . '<option value="' . $index_types[$i] . '"' . (($index_type == $index_types[$i]) ?
' selected="selected"' : '') . '>'. $index_types[$i] . '</option>'
346 } // end if... else...
350 <?php
echo PMA_showMySQLDocu('Reference', 'ALTER_TABLE.html') . "\n"; ?
>
355 <table border
="<?php echo $cfg['Border']; ?>" cellpadding
="5">
357 <th
><?php
echo $strField; ?
></th
>
358 <th
><?php
echo $strSize; ?
></th
>
361 while (list($row_no, $seq_index) = each($edited_index_info['Sequences'])) {
362 $add_type = (is_array($fields_types) && count($fields_types) == count($fields_names));
363 $selected = $edited_index_data[$seq_index]['Column_name'];
364 if (!empty($edited_index_data[$seq_index]['Sub_part'])) {
365 $sub_part = ' value="' . $edited_index_data[$seq_index]['Sub_part'] . '"';
369 $bgcolor = (($row_no %
2) ?
$cfg['BgcolorOne'] : $cfg['BgcolorTwo']);
373 <td bgcolor
="<?php echo $bgcolor; ?>">
374 <select name
="column[]">
375 <option value
="--ignore--"<?php
if ('--ignore--' == $selected) echo ' selected="selected"'; ?
>>
376 -- <?php
echo $strIgnore; ?
> --</option
>
378 reset($fields_names);
379 while (list($key, $val) = each($fields_names)) {
380 if ($index_type != 'FULLTEXT'
381 ||
eregi('^(varchar|text|tinytext|mediumtext|longtext)', $fields_types[$key])) {
383 . '<option value="' . htmlspecialchars($val) . '"' . (($val == $selected) ?
' selected="selected"' : '') . '>'
384 . htmlspecialchars($val) . (($add_type) ?
' [' . $fields_types[$key] . ']' : '' ) . '</option>' . "\n";
391 <td bgcolor
="<?php echo $bgcolor; ?>">
392 <input type
="text" size
="5" name
="sub_part[]"<?php
echo $sub_part; ?
> onfocus
="this.select()" />
402 <input type
="submit" name
="do_save_data" value
="<?php echo $strSave; ?>" /><br
/>
406 if (isset($added_fields)) {
407 echo ' <input type="hidden" name="prev_add_fields" value="' . $added_fields . '" />';
409 if (isset($idx_num_fields)) {
410 echo ' <input type="hidden" name="idx_num_fields" value="' . $idx_num_fields . '" />' . "\n";
412 echo ' <hr /><br />' . "\n";
413 echo ' ' . sprintf($strAddToIndex, '<input type="text" name="added_fields" size="4" value="1" class="textfield" onfocus="this.select()" />') . "\n";
414 echo ' <input type="submit" name="add_fields" value="' . $strGo . '" onclick="return checkFormElementInRange(this.form, \'added_fields\', 1)" />' . "\n";
421 <!-- Indexes form
-->
422 <form action
="tbl_indexes.php3" method
="post">
423 <input type
="hidden" name
="lang" value
="<?php echo $lang; ?>" />
424 <input type
="hidden" name
="convcharset" value
="<?php echo $convcharset; ?>" />
425 <input type
="hidden" name
="server" value
="<?php echo $server; ?>" />
426 <input type
="hidden" name
="db" value
="<?php echo $db; ?>" />
427 <input type
="hidden" name
="table" value
="<?php echo $table; ?>" />
430 echo ' ' . $strIndexes . ' :' . "\n";
431 echo ' ' . PMA_showMySQLDocu('MySQL_Optimisation', 'Optimising_Database_Structure') . '<br />' ."\n";
435 <table border
="<?php echo $cfg['Border']; ?>">
437 <th
><?php
echo $strKeyname; ?
></th
>
438 <th
><?php
echo $strType; ?
></th
>
439 <th
><?php
echo $strCardinality; ?
></th
>
440 <th colspan
="2"><?php
echo $strAction; ?
></th
>
441 <th colspan
="2"><?php
echo $strField; ?
></th
>
445 while (list($index_no, $index_name) = each($indexes)) {
446 $cell_bgd = (($index_no %
2) ?
$cfg['BgcolorOne'] : $cfg['BgcolorTwo']);
447 $index_td = ' <td bgcolor="' . $cell_bgd . '" rowspan="' . count($indexes_info[$index_name]['Sequences']) . '">' . "\n";
450 . ' ' . htmlspecialchars($index_name) . "\n"
453 if ($indexes_info[$index_name]['Comment'] == 'FULLTEXT') {
454 $index_type = 'FULLTEXT';
455 } else if ($index_name == 'PRIMARY') {
456 $index_type = 'PRIMARY';
457 } else if ($indexes_info[$index_name]['Non_unique'] == '0') {
458 $index_type = 'UNIQUE';
460 $index_type = 'INDEX';
463 . ' ' . $index_type . "\n"
466 echo str_replace('">' . "\n", '" align="right">' . "\n", $index_td)
467 . ' ' . (isset($indexes_info[$index_name]['Cardinality']) ?
$indexes_info[$index_name]['Cardinality'] : $strNone) . ' ' . "\n"
470 if ($index_name == 'PRIMARY') {
471 $local_query = urlencode('ALTER TABLE ' . PMA_backquote($table) . ' DROP PRIMARY KEY');
472 $js_msg = 'ALTER TABLE ' . PMA_jsFormat($table) . ' DROP PRIMARY KEY';
473 $zero_rows = urlencode($strPrimaryKeyHasBeenDropped);
475 $local_query = urlencode('ALTER TABLE ' . PMA_backquote($table) . ' DROP INDEX ' . PMA_backquote($index_name));
476 $js_msg = 'ALTER TABLE ' . PMA_jsFormat($table) . ' DROP INDEX ' . PMA_jsFormat($index_name);
477 $zero_rows = urlencode(sprintf($strIndexHasBeenDropped, htmlspecialchars($index_name)));
480 . ' <a href="sql.php3?' . $url_query . '&sql_query=' . $local_query . '&zero_rows=' . $zero_rows . '" onclick="return confirmLink(this, \'' . $js_msg . '\')">' . $strDrop . '</a>' . "\n"
484 . ' <a href="tbl_indexes.php3?' . $url_query . '&index=' . urlencode($index_name) . '">' . $strEdit . '</a>' . "\n"
487 while (list($row_no, $seq_index) = each($indexes_info[$index_name]['Sequences'])) {
491 if (!empty($indexes_data[$index_name][$seq_index]['Sub_part'])) {
492 echo ' <td bgcolor="' . $cell_bgd . '">' . "\n"
493 . ' ' . $indexes_data[$index_name][$seq_index]['Column_name'] . "\n"
495 echo ' <td align="right" bgcolor="' . $cell_bgd . '">' . "\n"
496 . ' ' . $indexes_data[$index_name][$seq_index]['Sub_part'] . "\n"
498 echo ' </tr>' . "\n";
500 echo ' <td bgcolor="' . $cell_bgd . '" colspan="2">' . "\n"
501 . ' ' . $indexes_data[$index_name][$seq_index]['Column_name'] . "\n"
503 echo ' </tr>' . "\n";
511 } // end display indexes
514 echo "\n" . ' <br />' . "\n";
515 echo ' <i>' . $strNoIndex . '</i><br /><br />' . "\n\n";
518 echo ' ' . sprintf($strCreateIndex, '<input type="text" size="4" name="idx_num_fields" value="1" class="textfield" />') . "\n";
519 echo ' <input type="submit" name="create_index" value="' . $strGo . '" onclick="return checkFormElementInRange(this.form, \'idx_num_fields\', 1)" />' . "\n";
521 } // end display indexes
529 * Displays the footer
533 if (!defined('PMA_IDX_INCLUDED')){
534 include('./footer.inc.php3');