Server : Apache/2.4.18 (Ubuntu) System : Linux canvaswebdesign 3.13.0-71-generic #114-Ubuntu SMP Tue Dec 1 02:34:22 UTC 2015 x86_64 User : oppastar ( 1041) PHP Version : 7.0.33-0ubuntu0.16.04.15 Disable Function : pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,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, Directory : /proc/self/root/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>