| Server IP : 127.0.0.2 / Your IP : 18.217.108.153 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/structure/ |
Upload File : |
<td class="print_ignore"><ul class="table-structure-actions resizable-menu">
<!-- Add primary -->
<?php
echo PMA\Template::get('table/structure/action_row_in_structure_table')->render(
array(
'type' => $type,
'tbl_storage_engine' => $tbl_storage_engine,
'class' => 'primary nowrap',
'hasField' => ($primary && $primary->hasColumn($field_name)),
'hasLinkClass' => true,
'url_query' => $url_query,
'primary' => $primary,
'syntax' => 'ADD PRIMARY KEY',
'message' => __('A primary key has been added on %s.'),
'action' => 'Primary',
'titles' => $titles,
'row' => $row,
'isPrimary' => true
)
);
?>
<!-- Add unique -->
<?php
echo PMA\Template::get('table/structure/action_row_in_structure_table')->render(
array(
'type' => $type,
'tbl_storage_engine' => $tbl_storage_engine,
'class' => 'add_unique unique nowrap',
'hasField' => in_array($field_name, $columns_with_unique_index),
'hasLinkClass' => false,
'url_query' => $url_query,
'primary' => $primary,
'syntax' => 'ADD UNIQUE',
'message' => __('An index has been added on %s.'),
'action' => 'Unique',
'titles' => $titles,
'row' => $row,
'isPrimary' => false
)
);
?>
<!-- Add index -->
<?php
echo PMA\Template::get('table/structure/action_row_in_structure_table')->render(
array(
'type' => $type,
'tbl_storage_engine' => $tbl_storage_engine,
'class' => 'add_index nowrap',
'hasField' => false,
'hasLinkClass' => false,
'url_query' => $url_query,
'primary' => $primary,
'syntax' => 'ADD INDEX',
'message' => __('An index has been added on %s.'),
'action' => 'Index',
'titles' => $titles,
'row' => $row,
'isPrimary' => false
)
);
?>
<?php if (!PMA_DRIZZLE): ?>
<!-- Add spatial -->
<?php
$spatial_types = array(
'geometry', 'point', 'linestring', 'polygon', 'multipoint',
'multilinestring', 'multipolygon', 'geomtrycollection'
);
echo PMA\Template::get('table/structure/action_row_in_structure_table')->render(
array(
'type' => $type,
'tbl_storage_engine' => $tbl_storage_engine,
'class' => 'spatial nowrap',
'hasField' => ! (in_array($type, $spatial_types) && ('MYISAM' == $tbl_storage_engine || PMA_MYSQL_INT_VERSION >= 50705)),
'hasLinkClass' => false,
'url_query' => $url_query,
'primary' => $primary,
'syntax' => 'ADD SPATIAL',
'message' => __('An index has been added on %s.'),
'action' => 'Spatial',
'titles' => $titles,
'row' => $row,
'isPrimary' => false
)
);
?>
<!-- FULLTEXT is possible on TEXT, CHAR and VARCHAR -->
<li class="fulltext nowrap">
<?php if (! empty($tbl_storage_engine)
&& ($tbl_storage_engine == 'MYISAM'
|| $tbl_storage_engine == 'ARIA'
|| $tbl_storage_engine == 'MARIA'
|| ($tbl_storage_engine == 'INNODB' && PMA_MYSQL_INT_VERSION >= 50604))
&& (/*overload*/mb_strpos($type, 'text') !== false
|| /*overload*/mb_strpos($type, 'char') !== false)
): ?>
<a rel="samepage" class="ajax add_key add_fulltext_anchor" href="tbl_structure.php<?php echo $url_query; ?>&add_key=1&sql_query=<?php echo urlencode(
'ALTER TABLE ' . PMA_Util::backquote($GLOBALS['table'])
. ' ADD FULLTEXT(' . PMA_Util::backquote($row['Field'])
. ');'); ?>&message_to_show=<?php echo urlencode(sprintf(
__('An index has been added on %s.'),
htmlspecialchars($row['Field']))); ?>">
<?php echo $titles['IdxFulltext']; ?>
</a>
<?php else: ?>
<?php echo $titles['NoIdxFulltext']; ?>
<?php endif; ?>
</li>
<?php endif; ?>
<!-- Distinct value action -->
<li class="browse nowrap">
<a href="sql.php<?php echo $url_query; ?>&sql_query=<?php echo urlencode(
'SELECT COUNT(*) AS ' . PMA_Util::backquote(__('Rows'))
. ', ' . PMA_Util::backquote($row['Field'])
. ' FROM ' . PMA_Util::backquote($GLOBALS['table'])
. ' GROUP BY ' . PMA_Util::backquote($row['Field'])
. ' ORDER BY ' . PMA_Util::backquote($row['Field'])
); ?>&is_browse_distinct=1">
<?php echo $titles['DistinctValues']; ?>
</a>
</li>
<?php if ($GLOBALS['cfgRelation']['centralcolumnswork']): ?>
<li class="browse nowrap">
<?php if ($isInCentralColumns): ?>
<a href="#" onclick="$('input:checkbox').prop('checked', false);
$('#checkbox_row_<?php echo $rownum; ?>').prop('checked', true);
$('button[value=remove_from_central_columns]').click();">
<?php echo PMA_Util::getIcon(
'centralColumns_delete.png',
__('Remove from central columns')
); ?></a>
<?php else: ?>
<a href="#" onclick="$('input:checkbox').prop('checked', false);
$('#checkbox_row_<?php echo $rownum ?>').prop('checked', true);
$('button[value=add_to_central_columns]').click();">
<?php echo PMA_Util::getIcon(
'centralColumns_add.png',
__('Add to central columns')
); ?></a>
<?php endif; ?>
</li>
<?php endif; ?>
</ul></td>