2 /* vim: set expandtab sw=4 ts=4 sts=4: */
4 * Displays table structure infos like fields/columns, indexes, size, rows
5 * and allows manipulation of indexes and columns/fields
12 require_once 'libraries/common.inc.php';
13 require_once 'libraries/mysql_charsets.lib.php';
15 $GLOBALS['js_include'][] = 'tbl_structure.js';
16 $GLOBALS['js_include'][] = 'indexes.js';
19 * handle multiple field commands if required
21 * submit_mult_*_x comes from IE if <input type="img" ...> is used
23 if (isset($_REQUEST['submit_mult_change_x'])) {
24 $submit_mult = 'change';
25 } elseif (isset($_REQUEST['submit_mult_drop_x'])) {
26 $submit_mult = 'drop';
27 } elseif (isset($_REQUEST['submit_mult_primary_x'])) {
28 $submit_mult = 'primary';
29 } elseif (isset($_REQUEST['submit_mult_index_x'])) {
30 $submit_mult = 'index';
31 } elseif (isset($_REQUEST['submit_mult_unique_x'])) {
32 $submit_mult = 'unique';
33 } elseif (isset($_REQUEST['submit_mult_spatial_x'])) {
34 $submit_mult = 'spatial';
35 } elseif (isset($_REQUEST['submit_mult_fulltext_x'])) {
36 $submit_mult = 'ftext';
37 } elseif (isset($_REQUEST['submit_mult_browse_x'])) {
38 $submit_mult = 'browse';
39 } elseif (isset($_REQUEST['submit_mult'])) {
40 $submit_mult = $_REQUEST['submit_mult'];
41 } elseif (isset($_REQUEST['mult_btn']) && $_REQUEST['mult_btn'] == __('Yes')) {
42 $submit_mult = 'row_delete';
43 if (isset($_REQUEST['selected'])) {
44 $_REQUEST['selected_fld'] = $_REQUEST['selected'];
48 if (! empty($submit_mult) && isset($_REQUEST['selected_fld'])) {
49 $err_url = 'tbl_structure.php?' . PMA_generate_common_url($db, $table);
50 if ($submit_mult == 'browse') {
51 // browsing the table displaying only selected fields/columns
52 $GLOBALS['active_page'] = 'sql.php';
54 foreach ($_REQUEST['selected_fld'] as $idx => $sval) {
55 if ($sql_query == '') {
56 $sql_query .= 'SELECT ' . PMA_backquote($sval);
58 $sql_query .= ', ' . PMA_backquote($sval);
62 // what is this htmlspecialchars() for??
63 //$sql_query .= ' FROM ' . PMA_backquote(htmlspecialchars($table));
64 $sql_query .= ' FROM ' . PMA_backquote($db) . '.' . PMA_backquote($table);
68 // handle multiple field commands
69 // handle confirmation of deleting multiple fields/columns
70 $action = 'tbl_structure.php';
71 include 'libraries/mult_submits.inc.php';
72 //require_once 'libraries/header.inc.php';
73 //require_once 'libraries/tbl_links.inc.php';
75 if (empty($message)) {
76 $message = PMA_Message
::success();
82 * Gets the relation settings
84 $cfgRelation = PMA_getRelationsParam();
89 require_once 'libraries/tbl_common.php';
90 $url_query .= '&goto=tbl_structure.php&back=tbl_structure.php';
91 $url_params['goto'] = 'tbl_structure.php';
92 $url_params['back'] = 'tbl_structure.php';
95 * Prepares the table structure display
100 * Gets tables informations
102 require_once 'libraries/tbl_info.inc.php';
105 * Displays top menu links
107 require_once 'libraries/tbl_links.inc.php';
108 require_once 'libraries/Index.class.php';
110 // 2. Gets table keys and retains them
111 // @todo should be: $server->db($db)->table($table)->primary()
112 $primary = PMA_Index
::getPrimary($table, $db);
114 $columns_with_unique_index = array();
115 foreach (PMA_Index
::getFromTable($table, $db) as $index) {
116 if ($index->isUnique() && $index->getChoice() == 'UNIQUE') {
117 $columns = $index->getColumns();
118 foreach ($columns as $column_name => $dummy) {
119 $columns_with_unique_index[$column_name] = 1;
123 unset($index, $columns, $column_name, $dummy);
126 $fields = (array) PMA_DBI_get_columns($db, $table, null, true);
128 // Get more complete field information
129 // For now, this is done just for MySQL 4.1.2+ new TIMESTAMP options
130 // but later, if the analyser returns more information, it
131 // could be executed for any MySQL version and replace
132 // the info given by SHOW FULL COLUMNS FROM.
134 // We also need this to correctly learn if a TIMESTAMP is NOT NULL, since
135 // SHOW FULL COLUMNS or INFORMATION_SCHEMA incorrectly says NULL
136 // and SHOW CREATE TABLE says NOT NULL (tested
137 // in MySQL 4.0.25 and 5.0.21, http://bugs.mysql.com/20910).
139 $show_create_table = PMA_DBI_fetch_value(
140 'SHOW CREATE TABLE ' . PMA_backquote($db) . '.' . PMA_backquote($table),
143 $analyzed_sql = PMA_SQP_analyze(PMA_SQP_parse($show_create_table));
146 * prepare table infos
148 // action titles (image or string)
150 $titles['Change'] = PMA_getIcon('b_edit.png', __('Change'));
151 $titles['Drop'] = PMA_getIcon('b_drop.png', __('Drop'));
152 $titles['NoDrop'] = PMA_getIcon('b_drop.png', __('Drop'));
153 $titles['Primary'] = PMA_getIcon('b_primary.png', __('Primary'));
154 $titles['Index'] = PMA_getIcon('b_index.png', __('Index'));
155 $titles['Unique'] = PMA_getIcon('b_unique.png', __('Unique'));
156 $titles['Spatial'] = PMA_getIcon('b_spatial.png', __('Spatial'));
157 $titles['IdxFulltext'] = PMA_getIcon('b_ftext.png', __('Fulltext'));
158 $titles['NoPrimary'] = PMA_getIcon('bd_primary.png', __('Primary'));
159 $titles['NoIndex'] = PMA_getIcon('bd_index.png', __('Index'));
160 $titles['NoUnique'] = PMA_getIcon('bd_unique.png', __('Unique'));
161 $titles['NoSpatial'] = PMA_getIcon('bd_spatial.png', __('Spatial'));
162 $titles['NoIdxFulltext'] = PMA_getIcon('bd_ftext.png', __('Fulltext'));
163 $titles['DistinctValues'] = PMA_getIcon('b_browse.png', __('Distinct values'));
165 // hidden action titles (image and string)
166 $hidden_titles = array();
167 $hidden_titles['DistinctValues'] = PMA_getIcon('b_browse.png', __('Distinct values'), true);
168 $hidden_titles['Primary'] = PMA_getIcon('b_primary.png', __('Add primary key'), true);
169 $hidden_titles['NoPrimary'] = PMA_getIcon('bd_primary.png', __('Add primary key'), true);
170 $hidden_titles['Index'] = PMA_getIcon('b_index.png', __('Add index'), true);
171 $hidden_titles['NoIndex'] = PMA_getIcon('bd_index.png', __('Add index'), true);
172 $hidden_titles['Unique'] = PMA_getIcon('b_unique.png', __('Add unique index'), true);
173 $hidden_titles['NoUnique'] = PMA_getIcon('bd_unique.png', __('Add unique index'), true);
174 $hidden_titles['Spatial'] = PMA_getIcon('b_spatial.png', __('Add SPATIAL index'), true);
175 $hidden_titles['NoSpatial'] = PMA_getIcon('bd_spatial.png', __('Add SPATIAL index'), true);
176 $hidden_titles['IdxFulltext'] = PMA_getIcon('b_ftext.png', __('Add FULLTEXT index'), true);
177 $hidden_titles['NoIdxFulltext'] = PMA_getIcon('bd_ftext.png', __('Add FULLTEXT index'), true);
180 * Displays the table structure ('show table' works correct since 3.23.03)
182 /* TABLE INFORMATION */
186 <form method
="post" action
="tbl_structure.php" name
="fieldsForm" id
="fieldsForm" <?php
echo ($GLOBALS['cfg']['AjaxEnable'] ?
' class="ajax"' : '');?
>>
187 <?php
echo PMA_generate_common_hidden_inputs($db, $table);
188 echo '<input type="hidden" name="table_type" value=';
189 if ($db_is_information_schema) {
190 echo '"information_schema" />';
191 } else if ($tbl_is_view) {
197 <table id
="tablestructure" class="data<?php
198 if ($GLOBALS['cfg']['PropertiesIconic'] === true) echo ' PropertiesIconic'; ?>">
203 <th
><?php
echo __('Name'); ?
></th
>
204 <th
><?php
echo __('Type'); ?
></th
>
205 <th
><?php
echo __('Collation'); ?
></th
>
206 <th
><?php
echo __('Attributes'); ?
></th
>
207 <th
><?php
echo __('Null'); ?
></th
>
208 <th
><?php
echo __('Default'); ?
></th
>
209 <th
><?php
echo __('Extra'); ?
></th
>
210 <?php
if ($db_is_information_schema ||
$tbl_is_view) { ?
>
211 <th
><?php
echo __('View'); ?
></th
>
212 <?php
} else { /* see tbl_structure.js, function moreOptsMenuResize() */ ?
>
218 if ($GLOBALS['cfg']['PropertiesIconic']) {
221 echo $colspan; ?>" class="action"><?php
echo __('Action'); ?
></th
>
233 $comments_map = array();
236 if ($GLOBALS['cfg']['ShowPropertyComments']) {
237 include_once 'libraries/transformations.lib.php';
239 //$cfgRelation = PMA_getRelationsParam();
241 $comments_map = PMA_getComments($db, $table);
243 if ($cfgRelation['mimework'] && $cfg['BrowseMIME']) {
244 $mime_map = PMA_getMIME($db, $table, true);
249 $aryFields = array();
250 $checked = (!empty($checkall) ?
' checked="checked"' : '');
253 foreach ($fields as $row) {
256 $aryFields[] = $row['Field'];
258 $type = $row['Type'];
259 $extracted_fieldspec = PMA_extractFieldSpec($row['Type']);
261 if ('set' == $extracted_fieldspec['type'] ||
'enum' == $extracted_fieldspec['type']) {
264 $type_nowrap = ' class="nowrap"';
266 $type = $extracted_fieldspec['print_type'];
272 if ($extracted_fieldspec['can_contain_collation'] && ! empty($row['Collation'])) {
273 $field_charset = $row['Collation'];
276 // Display basic mimetype [MIME]
277 if ($cfgRelation['commwork'] && $cfgRelation['mimework'] && $cfg['BrowseMIME'] && isset($mime_map[$row['Field']]['mimetype'])) {
278 $type_mime = '<br />MIME: ' . str_replace('_', '/', $mime_map[$row['Field']]['mimetype']);
283 $attribute = $extracted_fieldspec['attribute'];
285 // MySQL 4.1.2+ TIMESTAMP options
286 // (if on_update_current_timestamp is set, then it's TRUE)
287 if (isset($analyzed_sql[0]['create_table_fields'][$row['Field']]['on_update_current_timestamp'])) {
288 $attribute = 'on update CURRENT_TIMESTAMP';
291 // here, we have a TIMESTAMP that SHOW FULL COLUMNS reports as having the
292 // NULL attribute, but SHOW CREATE TABLE says the contrary. Believe
294 if (!empty($analyzed_sql[0]['create_table_fields'][$row['Field']]['type']) && $analyzed_sql[0]['create_table_fields'][$row['Field']]['type'] == 'TIMESTAMP' && $analyzed_sql[0]['create_table_fields'][$row['Field']]['timestamp_not_null']) {
299 if (! isset($row['Default'])) {
300 if ($row['Null'] == 'YES') {
301 $row['Default'] = '<i>NULL</i>';
304 $row['Default'] = htmlspecialchars($row['Default']);
307 $field_encoded = urlencode($row['Field']);
308 $field_name = htmlspecialchars($row['Field']);
309 $displayed_field_name = $field_name;
311 // underline commented fields and display a hover-title (CSS only)
313 if (isset($comments_map[$row['Field']])) {
314 $displayed_field_name = '<span class="commented_column" title="' . htmlspecialchars($comments_map[$row['Field']]) . '">' . $field_name . '</span>';
317 if ($primary && $primary->hasColumn($field_name)) {
318 $displayed_field_name = '<u>' . $field_name . '</u>';
322 <tr
class="<?php echo $odd_row ? 'odd': 'even'; $odd_row = !$odd_row; ?>">
324 <input type
="checkbox" name
="selected_fld[]" value
="<?php echo htmlspecialchars($row['Field']); ?>" id
="checkbox_row_<?php echo $rownum; ?>" <?php
echo $checked; ?
> />
327 <?php
echo $rownum; ?
>
329 <th
class="nowrap"><label
for="checkbox_row_<?php echo $rownum; ?>"><?php
echo $displayed_field_name; ?
></label
></th
>
330 <td
<?php
echo $type_nowrap; ?
>><bdo dir
="ltr" lang
="en"><?php
echo $extracted_fieldspec['displayed_type']; echo $type_mime; ?
></bdo
></td
>
331 <td
><?php
echo (empty($field_charset) ?
'' : '<dfn title="' . PMA_getCollationDescr($field_charset) . '">' . $field_charset . '</dfn>'); ?
></td
>
332 <td
class="column_attribute nowrap"><?php
echo $attribute; ?
></td
>
333 <td
><?php
echo (($row['Null'] == 'YES') ?
__('Yes') : __('No')); ?
></td
>
334 <td
class="nowrap"><?php
335 if (isset($row['Default'])) {
336 if ($extracted_fieldspec['type'] == 'bit') {
337 // here, $row['Default'] contains something like b'010'
338 echo PMA_convert_bit_default_value($row['Default']);
340 echo $row['Default'];
343 echo '<i>' . _pgettext('None for default', 'None') . '</i>';
345 <td
class="nowrap"><?php
echo strtoupper($row['Extra']); ?
></td
>
346 <?php
if (! $tbl_is_view && ! $db_is_information_schema) { ?
>
347 <td
class="edit center">
348 <a href
="tbl_alter.php?<?php echo $url_query; ?>&field=<?php echo $field_encoded; ?>">
349 <?php
echo $titles['Change']; ?
></a
>
351 <td
class="drop center">
352 <a
<?php
echo ($GLOBALS['cfg']['AjaxEnable'] ?
' class="drop_column_anchor"' : ''); ?
> href
="sql.php?<?php echo $url_query; ?>&sql_query=<?php echo urlencode('ALTER TABLE ' . PMA_backquote($table) . ' DROP ' . PMA_backquote($row['Field'])); ?>&dropped_column=<?php echo urlencode($row['Field']); ?>&message_to_show=<?php echo urlencode(sprintf(__('Column %s has been dropped'), htmlspecialchars($row['Field']))); ?>" >
353 <?php
echo $titles['Drop']; ?
></a
>
356 if (! $tbl_is_view && ! $db_is_information_schema) { ?
>
357 <td
class="primary replaced_by_more center">
359 if ($type == 'text' ||
$type == 'blob' ||
'ARCHIVE' == $tbl_storage_engine ||
($primary && $primary->hasColumn($field_name))) {
360 echo $titles['NoPrimary'] . "\n";
361 $primary_enabled = false;
365 <a
class="add_primary_key_anchor" href
="sql.php?<?php echo $url_query; ?>&sql_query=<?php echo urlencode('ALTER TABLE ' . PMA_backquote($table) . ($primary ? ' DROP PRIMARY KEY,' : '') . ' ADD PRIMARY KEY(' . PMA_backquote($row['Field']) . ')'); ?>&message_to_show=<?php echo urlencode(sprintf(__('A primary key has been added on %s'), htmlspecialchars($row['Field']))); ?>" >
366 <?php
echo $titles['Primary']; ?
></a
>
367 <?php
$primary_enabled = true;
372 <td
class="unique replaced_by_more center">
374 if ($type == 'text' ||
$type == 'blob' ||
'ARCHIVE' == $tbl_storage_engine ||
isset($columns_with_unique_index[$field_name])) {
375 echo $titles['NoUnique'] . "\n";
376 $unique_enabled = false;
380 <a href
="sql.php?<?php echo $url_query; ?>&sql_query=<?php echo urlencode('ALTER TABLE ' . PMA_backquote($table) . ' ADD UNIQUE(' . PMA_backquote($row['Field']) . ')'); ?>&message_to_show=<?php echo urlencode(sprintf(__('An index has been added on %s'), htmlspecialchars($row['Field']))); ?>">
381 <?php
echo $titles['Unique']; ?
></a
>
382 <?php
$unique_enabled = true;
387 <td
class="index replaced_by_more center">
389 if ($type == 'text' ||
$type == 'blob' ||
'ARCHIVE' == $tbl_storage_engine) {
390 echo $titles['NoIndex'] . "\n";
391 $index_enabled = false;
395 <a href
="sql.php?<?php echo $url_query; ?>&sql_query=<?php echo urlencode('ALTER TABLE ' . PMA_backquote($table) . ' ADD INDEX(' . PMA_backquote($row['Field']) . ')'); ?>&message_to_show=<?php echo urlencode(sprintf(__('An index has been added on %s'), htmlspecialchars($row['Field']))); ?>">
396 <?php
echo $titles['Index']; ?
></a
>
398 $index_enabled = true;
404 if (!PMA_DRIZZLE
) { ?
>
405 <td
class="spatial replaced_by_more center">
408 $spatial_types = array(
409 'geometry', 'point', 'linestring', 'polygon', 'multipoint',
410 'multilinestring', 'multipolygon', 'geomtrycollection'
412 if (! in_array($type, $spatial_types) ||
'MYISAM' != $tbl_storage_engine) {
413 echo $titles['NoSpatial'] . "\n";
414 $spatial_enabled = false;
418 <a href
="sql.php?<?php echo $url_query; ?>&sql_query=<?php echo urlencode('ALTER TABLE ' . PMA_backquote($table) . ' ADD SPATIAL(' . PMA_backquote($row['Field']) . ')'); ?>&message_to_show=<?php echo urlencode(sprintf(__('An index has been added on %s'), htmlspecialchars($row['Field']))); ?>">
419 <?php
echo $titles['Spatial']; ?
></a
>
421 $spatial_enabled = true;
427 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))
428 // FULLTEXT is possible on TEXT, CHAR and VARCHAR
429 && (strpos(' ' . $type, 'text') ||
strpos(' ' . $type, 'char'))) {
432 <td
class="fulltext replaced_by_more center nowrap">
433 <a href
="sql.php?<?php echo $url_query; ?>&sql_query=<?php echo urlencode('ALTER TABLE ' . PMA_backquote($table) . ' ADD FULLTEXT(' . PMA_backquote($row['Field']) . ')'); ?>&message_to_show=<?php echo urlencode(sprintf(__('An index has been added on %s'), htmlspecialchars($row['Field']))); ?>">
434 <?php
echo $titles['IdxFulltext']; ?
></a
>
435 <?php
$fulltext_enabled = true; ?
>
441 <td
class="fulltext replaced_by_more center nowrap">
442 <?php
echo $titles['NoIdxFulltext'] . "\n"; ?
>
443 <?php
$fulltext_enabled = false; ?
>
447 } // end if... else...
449 <td
class="browse replaced_by_more center">
450 <a href
="sql.php?<?php echo $url_query; ?>&sql_query=<?php echo urlencode('SELECT COUNT(*) AS ' . PMA_backquote(__('Rows')) . ', ' . PMA_backquote($row['Field']) . ' FROM ' . PMA_backquote($table) . ' GROUP BY ' . PMA_backquote($row['Field']) . ' ORDER BY ' . PMA_backquote($row['Field'])); ?>"> <?php
echo $titles['DistinctValues']; ?
></a
>
453 if ($GLOBALS['cfg']['PropertiesIconic'] !== true && $GLOBALS['cfg']['HideStructureActions'] === true) { ?
>
454 <td
class="more_opts" id
="more_opts<?php echo $rownum; ?>">
455 <?php
echo PMA_getImage('more.png', __('Show more actions')); ?
> <?php
echo __('More'); ?
>
456 <div
class="structure_actions_dropdown" id
="row_<?php echo $rownum; ?>">
457 <div
class="<?php echo ($GLOBALS['cfg']['AjaxEnable'] ? 'action_primary ' : ''); ?>replace_in_more">
459 if (isset($primary_enabled)) {
460 if ($primary_enabled) { ?
>
461 <a href
="sql.php?<?php echo $url_query; ?>&sql_query=<?php echo urlencode('ALTER TABLE ' . PMA_backquote($table) . ($primary ? ' DROP PRIMARY KEY,' : '') . ' ADD PRIMARY KEY(' . PMA_backquote($row['Field']) . ')'); ?>&message_to_show=<?php echo urlencode(sprintf(__('A primary key has been added on %s'), htmlspecialchars($row['Field']))); ?>">
462 <?php
echo $hidden_titles['Primary']; ?
>
466 echo $hidden_titles['NoPrimary'];
470 <div
class="action_unique replace_in_more">
472 if (isset($unique_enabled)) {
473 if ($unique_enabled) { ?
>
474 <a href
="sql.php?<?php echo $url_query; ?>&sql_query=<?php echo urlencode('ALTER TABLE ' . PMA_backquote($table) . ' ADD UNIQUE(' . PMA_backquote($row['Field']) . ')'); ?>&message_to_show=<?php echo urlencode(sprintf(__('An index has been added on %s'), htmlspecialchars($row['Field']))); ?>">
475 <?php
echo $hidden_titles['Unique']; ?
>
479 echo $hidden_titles['NoUnique'];
483 <div
class="action_index replace_in_more">
485 if (isset($index_enabled)) {
486 if ($index_enabled) { ?
>
487 <a href
="sql.php?<?php echo $url_query; ?>&sql_query=<?php echo urlencode('ALTER TABLE ' . PMA_backquote($table) . ' ADD INDEX(' . PMA_backquote($row['Field']) . ')'); ?>&message_to_show=<?php echo urlencode(sprintf(__('An index has been added on %s'), htmlspecialchars($row['Field']))); ?>">
488 <?php
echo $hidden_titles['Index']; ?
>
492 echo $hidden_titles['NoIndex'];
496 <?php
if (!PMA_DRIZZLE
) { ?
>
497 <div
class="action_spatial replace_in_more">
499 if (isset($spatial_enabled)) {
500 if ($spatial_enabled) { ?
>
501 <a href
="sql.php?<?php echo $url_query; ?>&sql_query=<?php echo urlencode('ALTER TABLE ' . PMA_backquote($table) . ' ADD SPATIAL(' . PMA_backquote($row['Field']) . ')'); ?>&message_to_show=<?php echo urlencode(sprintf(__('An index has been added on %s'), htmlspecialchars($row['Field']))); ?>">
502 <?php
echo $hidden_titles['Spatial']; ?
>
506 echo $hidden_titles['NoSpatial'];
510 <div
class="action_fulltext replace_in_more">
512 if (isset($fulltext_enabled)) {
513 if ($fulltext_enabled) { ?
>
514 <a href
="sql.php?<?php echo $url_query; ?>&sql_query=<?php echo urlencode('ALTER TABLE ' . PMA_backquote($table) . ' ADD FULLTEXT(' . PMA_backquote($row['Field']) . ')'); ?>&message_to_show=<?php echo urlencode(sprintf(__('An index has been added on %s'), htmlspecialchars($row['Field']))); ?>">
515 <?php
echo $hidden_titles['IdxFulltext']; ?
>
519 echo $hidden_titles['NoIdxFulltext'];
523 <div
class="action_browse replace_in_more">
524 <a href
="sql.php?<?php echo $url_query; ?>&sql_query=<?php echo urlencode('SELECT COUNT(*) AS ' . PMA_backquote(__('Rows')) . ', ' . PMA_backquote($row['Field']) . ' FROM ' . PMA_backquote($table) . ' GROUP BY ' . PMA_backquote($row['Field']) . ' ORDER BY ' . PMA_backquote($row['Field'])); ?>&browse_distinct=1">
525 <?php
echo $hidden_titles['DistinctValues']; ?
>
532 } // end if (GLOBALS['cfg']['PropertiesIconic'] !== true)
533 } // end if (! $tbl_is_view && ! $db_is_information_schema)
537 unset($field_charset);
540 echo '</tbody>' . "\n"
543 $checkall_url = 'tbl_structure.php?' . PMA_generate_common_url($db, $table);
546 <img
class="selectallarrow" src
="<?php echo $pmaThemeImage . 'arrow_' . $text_dir . '.png'; ?>"
547 width
="38" height
="22" alt
="<?php echo __('With selected:'); ?>" />
548 <a href
="<?php echo $checkall_url; ?>&checkall=1"
549 onclick
="if (markAllRows('fieldsForm')) return false;">
550 <?php
echo __('Check All'); ?
></a
>
552 <a href
="<?php echo $checkall_url; ?>"
553 onclick
="if (unMarkAllRows('fieldsForm')) return false;">
554 <?php
echo __('Uncheck All'); ?
></a
>
556 <i
><?php
echo __('With selected:'); ?
></i
>
559 PMA_buttonOrImage('submit_mult', 'mult_submit', 'submit_mult_browse', __('Browse'), 'b_browse.png', 'browse');
561 if (! $tbl_is_view && ! $db_is_information_schema) {
562 PMA_buttonOrImage('submit_mult', 'mult_submit', 'submit_mult_change', __('Change'), 'b_edit.png', 'change');
563 PMA_buttonOrImage('submit_mult', 'mult_submit', 'submit_mult_drop', __('Drop'), 'b_drop.png', 'drop');
564 if ('ARCHIVE' != $tbl_storage_engine) {
565 PMA_buttonOrImage('submit_mult', 'mult_submit', 'submit_mult_primary', __('Primary'), 'b_primary.png', 'primary');
566 PMA_buttonOrImage('submit_mult', 'mult_submit', 'submit_mult_unique', __('Unique'), 'b_unique.png', 'unique');
567 PMA_buttonOrImage('submit_mult', 'mult_submit', 'submit_mult_index', __('Index'), 'b_index.png', 'index');
570 if (! empty($tbl_storage_engine) && $tbl_storage_engine == 'MYISAM') {
571 PMA_buttonOrImage('submit_mult', 'mult_submit', 'submit_mult_spatial', __('Spatial'), 'b_spatial.png', 'spatial');
573 if (! empty($tbl_storage_engine) && ($tbl_storage_engine == 'MYISAM' ||
$tbl_storage_engine == 'ARIA' ||
$tbl_storage_engine == 'MARIA')) {
574 PMA_buttonOrImage('submit_mult', 'mult_submit', 'submit_mult_fulltext', __('Fulltext'), 'b_ftext.png', 'ftext');
587 $create_view = PMA_DBI_get_definition($db, 'VIEW', $table);
588 $create_view = preg_replace('@^CREATE@', 'ALTER', $create_view);
589 echo PMA_linkOrButton(
590 'tbl_sql.php' . PMA_generate_common_url(
593 'sql_query' => $create_view,
597 PMA_getIcon('b_edit.png', __('Edit view'), true)
602 <a href
="tbl_printview.php?<?php echo $url_query; ?>"><?php
603 echo PMA_getIcon('b_print.png', __('Print view'), true);
607 if (! $tbl_is_view && ! $db_is_information_schema) {
609 // if internal relations are available, or foreign keys are supported
610 // ($tbl_storage_engine comes from libraries/tbl_info.inc.php)
611 if ($cfgRelation['relwork'] ||
PMA_foreignkey_supported($tbl_storage_engine)) {
613 <a href
="tbl_relation.php?<?php echo $url_query; ?>"><?php
614 echo PMA_getIcon('b_relations.png', __('Relation view'), true);
621 <a href
="sql.php?<?php echo $url_query; ?>&session_max_rows=all&sql_query=<?php echo urlencode('SELECT * FROM ' . PMA_backquote($table) . ' PROCEDURE ANALYSE()'); ?>"><?php
622 echo PMA_getIcon('b_tblanalyse.png', __('Propose table structure'), true);
624 echo PMA_showMySQLDocu('Extending_MySQL', 'procedure_analyse') . "\n";
627 if (PMA_Tracker
::isActive()) {
628 echo '<a href="tbl_tracking.php?' . $url_query . '">';
629 echo PMA_getIcon('eye.png', __('Track table'), true);
635 <form method
="post" action
="tbl_addfield.php" id
="addColumns" name
="addColumns" <?php
echo ($GLOBALS['cfg']['AjaxEnable'] ?
' class="ajax"' : '');?
>
636 onsubmit
="return checkFormElementInRange(this, 'num_fields', '<?php echo str_replace('\'', '\\\'', __('You have to add at least one column.')); ?>', 1)">
638 echo PMA_generate_common_hidden_inputs($db, $table);
639 if ($cfg['PropertiesIconic']) {
640 echo PMA_getImage('b_insrow.png', __('Add column'));
642 echo sprintf(__('Add %s column(s)'), '<input type="text" name="num_fields" size="2" maxlength="2" value="1" onfocus="this.select()" />');
644 // I tried displaying the drop-down inside the label but with Firefox
645 // the drop-down was blinking
646 $fieldOptions = '<select name="after_field" onclick="this.form.field_where[2].checked=true" onchange="this.form.field_where[2].checked=true">';
647 foreach ($aryFields as $fieldname) {
648 $fieldOptions .= '<option value="' . htmlspecialchars($fieldname) . '">' . htmlspecialchars($fieldname) . '</option>' . "\n";
651 $fieldOptions .= '</select>';
654 'last' => __('At End of Table'),
655 'first' => __('At Beginning of Table'),
656 'after' => sprintf(__('After %s'), '')
658 PMA_display_html_radio('field_where', $choices, 'last', false);
660 unset($fieldOptions, $choices);
662 <input type
="submit" value
="<?php echo __('Go'); ?>" />
664 <iframe
class="IE_hack"></iframe
>
666 <div id
="index_div" <?php
echo ($GLOBALS['cfg']['AjaxEnable'] ?
' class="ajax"' : ''); ?
> >
671 * If there are more than 20 rows, displays browse/select/insert/empty/drop
674 if (count($fields) > 20) {
675 include 'libraries/tbl_links.inc.php';
676 } // end if (count($fields) > 20)
682 if (! $tbl_is_view && ! $db_is_information_schema && 'ARCHIVE' != $tbl_storage_engine) {
683 PMA_generate_slider_effect('indexes', __('Indexes'));
687 echo PMA_Index
::getView($table, $db);
689 <fieldset
class="tblFooters" style
="text-align: left;">
690 <form action
="tbl_indexes.php" method
="post">
692 echo PMA_generate_common_hidden_inputs($db, $table);
694 __('Create an index on %s columns'),
695 '<input type="text" size="2" name="added_fields" value="1" />'
698 <input type
="hidden" name
="create_index" value
="1" />
699 <input
class="add_index<?php echo ($GLOBALS['cfg']['AjaxEnable'] ? ' ajax' : '');?>" type
="submit" value
="<?php echo __('Go'); ?>" />
708 * Displays Space usage and row statistics
710 // BEGIN - Calc Table Space
711 // Get valid statistics whatever is the table type
712 if ($cfg['ShowStats']) {
713 echo '<div id="tablestatistics">';
714 if (empty($showtable)) {
715 $showtable = PMA_Table
::sGetStatusInfo($GLOBALS['db'], $GLOBALS['table'], null, true);
719 $is_innodb = (isset($showtable['Type']) && $showtable['Type'] == 'InnoDB');
720 if (isset($showtable['Type']) && !preg_match('@ISAM|HEAP@i', $showtable['Type'])) {
726 $mergetable = PMA_Table
::isMerge($GLOBALS['db'], $GLOBALS['table']);
728 // this is to display for example 261.2 MiB instead of 268k KiB
731 list($data_size, $data_unit) = PMA_formatByteDown($showtable['Data_length'], $max_digits, $decimals);
732 if ($mergetable == false) {
733 list($index_size, $index_unit) = PMA_formatByteDown($showtable['Index_length'], $max_digits, $decimals);
735 // InnoDB returns a huge value in Data_free, do not use it
736 if (! $is_innodb && isset($showtable['Data_free']) && $showtable['Data_free'] > 0) {
737 list($free_size, $free_unit) = PMA_formatByteDown($showtable['Data_free'], $max_digits, $decimals);
738 list($effect_size, $effect_unit) = PMA_formatByteDown($showtable['Data_length'] +
$showtable['Index_length'] - $showtable['Data_free'], $max_digits, $decimals);
740 list($effect_size, $effect_unit) = PMA_formatByteDown($showtable['Data_length'] +
$showtable['Index_length'], $max_digits, $decimals);
742 list($tot_size, $tot_unit) = PMA_formatByteDown($showtable['Data_length'] +
$showtable['Index_length'], $max_digits, $decimals);
743 if ($table_info_num_rows > 0) {
744 list($avg_size, $avg_unit) = PMA_formatByteDown(($showtable['Data_length'] +
$showtable['Index_length']) / $showtable['Rows'], 6, 1);
752 <legend
><?php
echo __('Information'); ?
></legend
>
753 <a id
="showusage"></a
>
754 <?php
if (! $tbl_is_view && ! $db_is_information_schema) { ?
>
755 <table id
="tablespaceusage" class="data">
756 <caption
class="tblHeaders"><?php
echo __('Space usage'); ?
></caption
>
759 <th
><?php
echo __('Type'); ?
></th
>
760 <th colspan
="2"><?php
echo __('Usage'); ?
></th
>
764 <tr
class="<?php echo ($odd_row = !$odd_row) ? 'odd' : 'even'; ?>">
765 <th
class="name"><?php
echo __('Data'); ?
></th
>
766 <td
class="value"><?php
echo $data_size; ?
></td
>
767 <td
class="unit"><?php
echo $data_unit; ?
></td
>
770 if (isset($index_size)) {
772 <tr
class="<?php echo ($odd_row = !$odd_row) ? 'odd' : 'even'; ?>">
773 <th
class="name"><?php
echo __('Index'); ?
></th
>
774 <td
class="value"><?php
echo $index_size; ?
></td
>
775 <td
class="unit"><?php
echo $index_unit; ?
></td
>
779 if (isset($free_size)) {
781 <tr
class="<?php echo ($odd_row = !$odd_row) ? 'odd' : 'even'; ?> error">
782 <th
class="name"><?php
echo __('Overhead'); ?
></th
>
783 <td
class="value"><?php
echo $free_size; ?
></td
>
784 <td
class="unit"><?php
echo $free_unit; ?
></td
>
786 <tr
class="<?php echo ($odd_row = !$odd_row) ? 'odd' : 'even'; ?>">
787 <th
class="name"><?php
echo __('Effective'); ?
></th
>
788 <td
class="value"><?php
echo $effect_size; ?
></td
>
789 <td
class="unit"><?php
echo $effect_unit; ?
></td
>
793 if (isset($tot_size) && $mergetable == false) {
795 <tr
class="<?php echo ($odd_row = !$odd_row) ? 'odd' : 'even'; ?>">
796 <th
class="name"><?php
echo __('Total'); ?
></th
>
797 <td
class="value"><?php
echo $tot_size; ?
></td
>
798 <td
class="unit"><?php
echo $tot_unit; ?
></td
>
802 // Optimize link if overhead
803 if (isset($free_size) && !PMA_DRIZZLE
&& ($tbl_storage_engine == 'MYISAM' ||
$tbl_storage_engine == 'ARIA' ||
$tbl_storage_engine == 'MARIA' ||
$tbl_storage_engine == 'BDB')) {
805 <tr
class="tblFooters">
806 <td colspan
="3" class="center">
807 <a href
="sql.php?<?php echo $url_query; ?>&pos=0&sql_query=<?php echo urlencode('OPTIMIZE TABLE ' . PMA_backquote($table)); ?>"><?php
808 echo PMA_getIcon('b_tbloptimize.png', __('Optimize table'));
821 <table id
="tablerowstats" class="data">
822 <caption
class="tblHeaders"><?php
echo __('Row Statistics'); ?
></caption
>
825 <th
><?php
echo __('Statements'); ?
></th
>
826 <th
><?php
echo __('Value'); ?
></th
>
831 if (isset($showtable['Row_format'])) {
833 <tr
class="<?php echo ($odd_row = !$odd_row) ? 'odd' : 'even'; ?>">
834 <th
class="name"><?php
echo __('Format'); ?
></th
>
835 <td
class="value"><?php
836 if ($showtable['Row_format'] == 'Fixed') {
838 } elseif ($showtable['Row_format'] == 'Dynamic') {
841 echo $showtable['Row_format'];
847 if (! empty($showtable['Create_options'])) {
849 <tr
class="<?php echo ($odd_row = !$odd_row) ? 'odd' : 'even'; ?>">
850 <th
class="name"><?php
echo __('Options'); ?
></th
>
851 <td
class="value"><?php
852 if ($showtable['Create_options'] == 'partitioned') {
853 echo __('partitioned');
855 echo $showtable['Create_options'];
861 if (!empty($tbl_collation)) {
863 <tr
class="<?php echo ($odd_row = !$odd_row) ? 'odd' : 'even'; ?>">
864 <th
class="name"><?php
echo __('Collation'); ?
></th
>
865 <td
class="value"><?php
866 echo '<dfn title="' . PMA_getCollationDescr($tbl_collation) . '">' . $tbl_collation . '</dfn>';
871 if (!$is_innodb && isset($showtable['Rows'])) {
873 <tr
class="<?php echo ($odd_row = !$odd_row) ? 'odd' : 'even'; ?>">
874 <th
class="name"><?php
echo __('Rows'); ?
></th
>
875 <td
class="value"><?php
echo PMA_formatNumber($showtable['Rows'], 0); ?
></td
>
879 if (!$is_innodb && isset($showtable['Avg_row_length']) && $showtable['Avg_row_length'] > 0) {
881 <tr
class="<?php echo ($odd_row = !$odd_row) ? 'odd' : 'even'; ?>">
882 <th
class="name"><?php
echo __('Row length'); ?
> ø
;</th
>
883 <td
class="value"><?php
echo PMA_formatNumber($showtable['Avg_row_length'], 0); ?
></td
>
887 if (!$is_innodb && isset($showtable['Data_length']) && $showtable['Rows'] > 0 && $mergetable == false) {
889 <tr
class="<?php echo ($odd_row = !$odd_row) ? 'odd' : 'even'; ?>">
890 <th
class="name"><?php
echo __('Row size'); ?
> ø
;</th
>
891 <td
class="value"><?php
echo $avg_size . ' ' . $avg_unit; ?
></td
>
895 if (isset($showtable['Auto_increment'])) {
897 <tr
class="<?php echo ($odd_row = !$odd_row) ? 'odd' : 'even'; ?>">
898 <th
class="name"><?php
echo __('Next autoindex'); ?
></th
>
899 <td
class="value"><?php
echo PMA_formatNumber($showtable['Auto_increment'], 0); ?
></td
>
903 if (isset($showtable['Create_time'])) {
905 <tr
class="<?php echo ($odd_row = !$odd_row) ? 'odd' : 'even'; ?>">
906 <th
class="name"><?php
echo __('Creation'); ?
></th
>
907 <td
class="value"><?php
echo PMA_localisedDate(strtotime($showtable['Create_time'])); ?
></td
>
911 if (isset($showtable['Update_time'])) {
913 <tr
class="<?php echo ($odd_row = !$odd_row) ? 'odd' : 'even'; ?>">
914 <th
class="name"><?php
echo __('Last update'); ?
></th
>
915 <td
class="value"><?php
echo PMA_localisedDate(strtotime($showtable['Update_time'])); ?
></td
>
919 if (isset($showtable['Check_time'])) {
921 <tr
class="<?php echo ($odd_row = !$odd_row) ? 'odd' : 'even'; ?>">
922 <th
class="name"><?php
echo __('Last check'); ?
></th
>
923 <td
class="value"><?php
echo PMA_localisedDate(strtotime($showtable['Check_time'])); ?
></td
>
931 <!-- close tablestatistics div
-->
936 // END - Calc Table Space
938 echo '<div class="clearfloat"></div>' . "\n";
941 * Displays the footer
943 require 'libraries/footer.inc.php';