| Server IP : 127.0.0.2 / Your IP : 18.116.28.60 Web Server : Apache/2.4.18 (Ubuntu) System : User : www-data ( ) PHP Version : 7.0.33-0ubuntu0.16.04.16 Disable Function : disk_free_space,disk_total_space,diskfreespace,dl,exec,fpaththru,getmyuid,getmypid,highlight_file,ignore_user_abord,leak,listen,link,opcache_get_configuration,opcache_get_status,passthru,pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,php_uname,phpinfo,posix_ctermid,posix_getcwd,posix_getegid,posix_geteuid,posix_getgid,posix_getgrgid,posix_getgrnam,posix_getgroups,posix_getlogin,posix_getpgid,posix_getpgrp,posix_getpid,posix,_getppid,posix_getpwnam,posix_getpwuid,posix_getrlimit,posix_getsid,posix_getuid,posix_isatty,posix_kill,posix_mkfifo,posix_setegid,posix_seteuid,posix_setgid,posix_setpgid,posix_setsid,posix_setuid,posix_times,posix_ttyname,posix_uname,pclose,popen,proc_open,proc_close,proc_get_status,proc_nice,proc_terminate,shell_exec,source,show_source,system,virtual MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /usr/share/phpmyadmin/templates/table/ |
Upload File : |
<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 echo PMA_URL_getHiddenInputs($form_params); ?>
<fieldset id="index_edit_fields">
<div class="index_info">
<div>
<div class="label">
<strong>
<label for="input_index_name">
<?php echo __('Index name:') . 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"
maxlength="64"
value="<?php echo htmlspecialchars($index->getName()); ?>"
onfocus="this.select()" />
</div>
<div>
<div class="label">
<strong>
<label for="select_index_choice">
<?php echo __('Index choice:') . PMA_Util::showMySQLDocu('ALTER_TABLE'); ?>
</label>
</strong>
</div>
<?php echo $index->generateIndexChoiceSelector(isset($_REQUEST['create_edit_table'])); ?>
</div>
<?php echo PMA_Util::getDivForSliderEffect(
'indexoptions', __('Options')
); ?>
<div>
<div class="label">
<strong>
<label for="input_key_block_size">
<?php echo __('Key block size:'); ?>
</label>
</strong>
</div>
<input type="text"
name="index[Key_block_size]"
id="input_key_block_size"
size="30"
value="<?php echo htmlspecialchars($index->getKeyBlockSize()) ?>" />
</div>
<div>
<div class="label">
<strong>
<label for="select_index_type">
<?php echo __('Index type:') . PMA_Util::showMySQLDocu('ALTER_TABLE'); ?>
</label>
</strong>
</div>
<?php echo $index->generateIndexTypeSelector(); ?>
</div>
<div>
<div class="label">
<strong>
<label for="input_parser">
<?php echo __('Parser:'); ?>
</label>
</strong>
</div>
<input type="text"
name="index[Parser]"
id="input_parse"
size="30"
value="<?php echo htmlspecialchars($index->getParser()) ?>" />
</div>
<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"
maxlength="1024"
value="<?php echo htmlspecialchars($index->getComment()) ?>" />
</div>
</div>
<!-- end of indexoptions div -->
<div class="clearfloat"></div>
<table id="index_columns">
<thead>
<tr>
<th></th>
<th>
<?php echo __('Column') ?>
</th>
<th>
<?php echo __('Size') ?>
</th>
</tr>
</thead>
<?php $odd_row = true;
$spatial_types = array(
'geometry',
'point',
'linestring',
'polygon',
'multipoint',
'multilinestring',
'multipolygon',
'geomtrycollection'
); ?>
<tbody>
<?php /* @var $column PMA_Index_Column */
foreach ($index->getColumns() as $column): ?>
<tr class="<?php echo $odd_row ? 'odd' : 'even'; ?>noclick">
<td>
<span class="drag_icon" title="<?php echo __('Drag to reorder') ?>"></span>
</td>
<td>
<select name="index[columns][names][]">
<option value="">
-- <?php echo __('Ignore'); ?> --
</option>
<?php
foreach ($fields as $field_name => $field_type):
if (($index->getChoice() != 'FULLTEXT'
|| preg_match('/(char|text)/i', $field_type))
&& ($index->getChoice() != 'SPATIAL'
|| in_array($field_type, $spatial_types))): ?>
<option value="<?php echo htmlspecialchars($field_name) ?>"
<?php if ($field_name == $column->getName()) echo 'selected="selected"'; ?>>
<?php echo htmlspecialchars($field_name); ?> [<?php echo htmlspecialchars($field_type); ?>]
</option>
<?php endif;
endforeach; ?>
</select>
</td>
<td>
<input type="text"
size="5"
onfocus="this.select()"name="index[columns][sub_parts][]"
value="<?php if ($index->getChoice() != 'SPATIAL') echo $column->getSubPart(); ?>"/>
</td>
</tr>
<?php
$odd_row = !$odd_row;
endforeach;
for ($i = 0; $i < $add_fields; $i++): ?>
<tr class="<?php echo $odd_row ? 'odd' : 'even'; ?>noclick">
<td>
<span class="drag_icon" title="<?php echo __('Drag to reorder') ?>"></span>
</td>
<td>
<select name="index[columns][names][]">
<option value="">-- <?php echo __('Ignore') ?> --</option>
<?php
$j = 0;
foreach ($fields as $field_name => $field_type):
if (isset($_REQUEST['create_edit_table'])) {
$col_index = $field_type[1];
$field_type = $field_type[0];
} ?>
<option value="<?php echo htmlspecialchars((isset($col_index)) ? $col_index : $field_name); ?>"
<?php echo ($j++ == $i ? 'selected="selected"' : ''); ?>>
<?php echo htmlspecialchars($field_name) ?> [<?php echo htmlspecialchars($field_type); ?>]
</option>
<?php echo "\n";
endforeach; ?>
</select>
</td>
<td>
<input type="text"
size="5"
onfocus="this.select()"
name="index[columns][sub_parts][]"
value="" />
</td>
</tr>
<?php
$odd_row = !$odd_row;
endfor; ?>
</tbody>
</table>
<div class="add_more">
<div class="slider"></div>
<div class="add_fields hide">
<input type="submit"
id="add_fields"
value="<?php echo sprintf(__('Add %s column(s) to index'), 1); ?>" />
</div>
</div>
</fieldset>
<fieldset class="tblFooters">
<button type="submit" id="preview_index_frm"><?php echo __('Preview SQL'); ?></button>
<input type="submit" id="save_index_frm" value="<?php echo __('Go'); ?>" />
</fieldset>
</form>