Merge remote-tracking branch 'origin/master'
[phpmyadmin/madhuracj.git] / tbl_structure.php
blob0385b26745d87271864b0248b4c0d4656b2447e1
1 <?php
2 /* vim: set expandtab sw=4 ts=4 sts=4: */
3 /**
4 * Displays table structure infos like fields/columns, indexes, size, rows
5 * and allows manipulation of indexes and columns/fields
6 * @package phpMyAdmin
7 */
9 /**
12 require_once './libraries/common.inc.php';
13 require_once './libraries/mysql_charsets.lib.php';
15 $GLOBALS['js_include'][] = 'jquery/jquery-ui-1.8.16.custom.js';
16 $GLOBALS['js_include'][] = 'tbl_structure.js';
17 $GLOBALS['js_include'][] = 'indexes.js';
18 /**
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';
53 $sql_query = '';
54 foreach ($_REQUEST['selected_fld'] as $idx => $sval) {
55 if ($sql_query == '') {
56 $sql_query .= 'SELECT ' . PMA_backquote($sval);
57 } else {
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);
65 include './sql.php';
66 exit;
67 } else {
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();
81 /**
82 * Gets the relation settings
84 $cfgRelation = PMA_getRelationsParam();
86 /**
87 * Runs common work
89 require_once './libraries/tbl_common.php';
90 $url_query .= '&amp;goto=tbl_structure.php&amp;back=tbl_structure.php';
91 $url_params['goto'] = 'tbl_structure.php';
92 $url_params['back'] = 'tbl_structure.php';
94 /**
95 * Prepares the table structure display
99 /**
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);
125 // 3. Get fields
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),
141 0, 1);
142 $analyzed_sql = PMA_SQP_analyze(PMA_SQP_parse($show_create_table));
145 * prepare table infos
147 // action titles (image or string)
148 $titles = array();
149 $titles['Change'] = PMA_getIcon('b_edit.png', __('Change'));
150 $titles['Drop'] = PMA_getIcon('b_drop.png', __('Drop'));
151 $titles['NoDrop'] = PMA_getIcon('b_drop.png', __('Drop'));
152 $titles['Primary'] = PMA_getIcon('b_primary.png', __('Primary'));
153 $titles['Index'] = PMA_getIcon('b_index.png', __('Index'));
154 $titles['Unique'] = PMA_getIcon('b_unique.png', __('Unique'));
155 $titles['Spatial'] = PMA_getIcon('b_spatial.png', __('Spatial'));
156 $titles['IdxFulltext'] = PMA_getIcon('b_ftext.png', __('Fulltext'));
157 $titles['NoPrimary'] = PMA_getIcon('bd_primary.png', __('Primary'));
158 $titles['NoIndex'] = PMA_getIcon('bd_index.png', __('Index'));
159 $titles['NoUnique'] = PMA_getIcon('bd_unique.png', __('Unique'));
160 $titles['NoSpatial'] = PMA_getIcon('bd_spatial.png', __('Spatial'));
161 $titles['NoIdxFulltext'] = PMA_getIcon('bd_ftext.png', __('Fulltext'));
162 $titles['BrowseDistinctValues'] = PMA_getIcon('b_browse.png', __('Browse distinct values'));
164 // hidden action titles (image and string)
165 $hidden_titles = array();
166 $hidden_titles['BrowseDistinctValues'] = PMA_getIcon('b_browse.png', __('Browse distinct values'), true);
167 $hidden_titles['Primary'] = PMA_getIcon('b_primary.png', __('Add primary key'), true);
168 $hidden_titles['NoPrimary'] = PMA_getIcon('bd_primary.png', __('Add primary key'), true);
169 $hidden_titles['Index'] = PMA_getIcon('b_index.png', __('Add index'), true);
170 $hidden_titles['NoIndex'] = PMA_getIcon('bd_index.png', __('Add index'), true);
171 $hidden_titles['Unique'] = PMA_getIcon('b_unique.png', __('Add unique index'), true);
172 $hidden_titles['NoUnique'] = PMA_getIcon('bd_unique.png', __('Add unique index'), true);
173 $hidden_titles['Spatial'] = PMA_getIcon('b_spatial.png', __('Add SPATIAL index'), true);
174 $hidden_titles['NoSpatial'] = PMA_getIcon('bd_spatial.png', __('Add SPATIAL index'), true);
175 $hidden_titles['IdxFulltext'] = PMA_getIcon('b_ftext.png', __('Add FULLTEXT index'), true);
176 $hidden_titles['NoIdxFulltext'] = PMA_getIcon('bd_ftext.png', __('Add FULLTEXT index'), true);
179 * Displays the table structure ('show table' works correct since 3.23.03)
181 /* TABLE INFORMATION */
182 // table header
183 $i = 0;
185 <form method="post" action="tbl_structure.php" name="fieldsForm" id="fieldsForm" <?php echo ($GLOBALS['cfg']['AjaxEnable'] ? ' class="ajax"' : '');?>>
186 <?php echo PMA_generate_common_hidden_inputs($db, $table);
187 echo '<input type="hidden" name="table_type" value=';
188 if ($db_is_information_schema) {
189 echo '"information_schema" />';
190 } else if ($tbl_is_view) {
191 echo '"view" />';
192 } else {
193 echo '"table" />';
194 } ?>
196 <table id="tablestructure" class="data">
197 <thead>
198 <tr>
199 <th id="th<?php echo ++$i; ?>"></th>
200 <th id="th<?php echo ++$i; ?>">#</th>
201 <th id="th<?php echo ++$i; ?>" class="column"><?php echo __('Name'); ?></th>
202 <th id="th<?php echo ++$i; ?>" class="type"><?php echo __('Type'); ?></th>
203 <th id="th<?php echo ++$i; ?>" class="collation"><?php echo __('Collation'); ?></th>
204 <th id="th<?php echo ++$i; ?>" class="attributes"><?php echo __('Attributes'); ?></th>
205 <th id="th<?php echo ++$i; ?>" class="null"><?php echo __('Null'); ?></th>
206 <th id="th<?php echo ++$i; ?>" class="default"><?php echo __('Default'); ?></th>
207 <th id="th<?php echo ++$i; ?>" class="extra"><?php echo __('Extra'); ?></th>
208 <?php if ($db_is_information_schema || $tbl_is_view) { ?>
209 <th id="th<?php echo ++$i; ?>" class="view"><?php echo __('View'); ?></th>
210 <?php } else { ?>
211 <th colspan="7" id="th<?php echo ++$i; ?>" class="action"><?php echo __('Action'); ?></th>
212 <?php } ?>
213 </tr>
214 </thead>
215 <tbody>
217 <?php
218 unset($i);
220 // table body
222 // prepare comments
223 $comments_map = array();
224 $mime_map = array();
226 if ($GLOBALS['cfg']['ShowPropertyComments']) {
227 include_once './libraries/transformations.lib.php';
229 //$cfgRelation = PMA_getRelationsParam();
231 $comments_map = PMA_getComments($db, $table);
233 if ($cfgRelation['mimework'] && $cfg['BrowseMIME']) {
234 $mime_map = PMA_getMIME($db, $table, true);
238 $rownum = 0;
239 $aryFields = array();
240 $checked = (!empty($checkall) ? ' checked="checked"' : '');
241 $save_row = array();
242 $odd_row = true;
243 foreach ($fields as $row) {
244 $save_row[] = $row;
245 $rownum++;
246 $aryFields[] = $row['Field'];
248 $type = $row['Type'];
249 $extracted_fieldspec = PMA_extractFieldSpec($row['Type']);
251 if ('set' == $extracted_fieldspec['type'] || 'enum' == $extracted_fieldspec['type']) {
252 $type_nowrap = '';
253 } else {
254 $type_nowrap = ' nowrap="nowrap"';
256 $type = $extracted_fieldspec['print_type'];
257 if (empty($type)) {
258 $type = ' ';
260 // for the case ENUM('&#8211;','&ldquo;')
261 $type = htmlspecialchars($type);
262 // in case it is too long
263 $start = 0;
264 if (strlen($type) > $GLOBALS['cfg']['LimitChars']) {
265 $start = 13;
266 $type = '<abbr title="' . $type . '">' . substr($type, 0, $GLOBALS['cfg']['LimitChars']) . '</abbr>';
269 unset($field_charset);
270 if ((substr($type, $start, 4) == 'char'
271 || substr($type, $start, 7) == 'varchar'
272 || substr($type, $start, 4) == 'text'
273 || substr($type, $start, 8) == 'tinytext'
274 || substr($type, $start, 10) == 'mediumtext'
275 || substr($type, $start, 8) == 'longtext'
276 || substr($type, $start, 3) == 'set'
277 || substr($type, $start, 4) == 'enum')
278 && !$extracted_fieldspec['binary']
280 if (strpos($type, ' character set ')) {
281 $type = substr($type, 0, strpos($type, ' character set '));
283 if (!empty($row['Collation'])) {
284 $field_charset = $row['Collation'];
285 } else {
286 $field_charset = '';
288 } else {
289 $field_charset = '';
292 // Display basic mimetype [MIME]
293 if ($cfgRelation['commwork'] && $cfgRelation['mimework'] && $cfg['BrowseMIME'] && isset($mime_map[$row['Field']]['mimetype'])) {
294 $type_mime = '<br />MIME: ' . str_replace('_', '/', $mime_map[$row['Field']]['mimetype']);
295 } else {
296 $type_mime = '';
299 $attribute = $extracted_fieldspec['attribute'];
301 // MySQL 4.1.2+ TIMESTAMP options
302 // (if on_update_current_timestamp is set, then it's TRUE)
303 if (isset($analyzed_sql[0]['create_table_fields'][$row['Field']]['on_update_current_timestamp'])) {
304 $attribute = 'on update CURRENT_TIMESTAMP';
307 // here, we have a TIMESTAMP that SHOW FULL COLUMNS reports as having the
308 // NULL attribute, but SHOW CREATE TABLE says the contrary. Believe
309 // the latter.
310 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']) {
311 $row['Null'] = '';
315 if (! isset($row['Default'])) {
316 if ($row['Null'] == 'YES') {
317 $row['Default'] = '<i>NULL</i>';
319 } else {
320 $row['Default'] = htmlspecialchars($row['Default']);
323 $field_encoded = urlencode($row['Field']);
324 $field_name = htmlspecialchars($row['Field']);
325 $displayed_field_name = $field_name;
327 // underline commented fields and display a hover-title (CSS only)
329 if (isset($comments_map[$row['Field']])) {
330 $displayed_field_name = '<span class="commented_column" title="' . htmlspecialchars($comments_map[$row['Field']]) . '">' . $field_name . '</span>';
333 if ($primary && $primary->hasColumn($field_name)) {
334 $displayed_field_name = '<u>' . $field_name . '</u>';
336 echo "\n";
338 <tr class="<?php echo $odd_row ? 'odd': 'even'; $odd_row = !$odd_row; ?>">
339 <td align="center">
340 <input type="checkbox" name="selected_fld[]" value="<?php echo htmlspecialchars($row['Field']); ?>" id="checkbox_row_<?php echo $rownum; ?>" <?php echo $checked; ?> />
341 </td>
342 <td align="right">
343 <?php echo $rownum; ?>
344 </td>
345 <th nowrap="nowrap"><label for="checkbox_row_<?php echo $rownum; ?>"><?php echo $displayed_field_name; ?></label></th>
346 <td<?php echo $type_nowrap; ?>><bdo dir="ltr" xml:lang="en"><?php echo $type; echo $type_mime; ?></bdo></td>
347 <td><?php echo (empty($field_charset) ? '' : '<dfn title="' . PMA_getCollationDescr($field_charset) . '">' . $field_charset . '</dfn>'); ?></td>
348 <td nowrap="nowrap" class="column_attribute"><?php echo $attribute; ?></td>
349 <td><?php echo (($row['Null'] == 'YES') ? __('Yes') : __('No')); ?></td>
350 <td nowrap="nowrap"><?php
351 if (isset($row['Default'])) {
352 if ($extracted_fieldspec['type'] == 'bit') {
353 // here, $row['Default'] contains something like b'010'
354 echo PMA_convert_bit_default_value($row['Default']);
355 } else {
356 echo $row['Default'];
358 } else {
359 echo '<i>' . _pgettext('None for default', 'None') . '</i>';
360 } ?></td>
361 <td nowrap="nowrap"><?php echo strtoupper($row['Extra']); ?></td>
362 <td align="center" class="browse">
363 <a href="sql.php?<?php echo $url_query; ?>&amp;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'])); ?>">
364 <?php echo $titles['BrowseDistinctValues']; ?></a>
365 </td>
366 <?php if (! $tbl_is_view && ! $db_is_information_schema) { ?>
367 <td align="center" class="edit">
368 <a href="tbl_alter.php?<?php echo $url_query; ?>&amp;field=<?php echo $field_encoded; ?>">
369 <?php echo $titles['Change']; ?></a>
370 </td>
371 <td align="center" class="drop">
372 <a <?php echo ($GLOBALS['cfg']['AjaxEnable'] ? ' class="drop_column_anchor"' : ''); ?> href="sql.php?<?php echo $url_query; ?>&amp;sql_query=<?php echo urlencode('ALTER TABLE ' . PMA_backquote($table) . ' DROP ' . PMA_backquote($row['Field'])); ?>&amp;dropped_column=<?php echo urlencode($row['Field']); ?>&amp;message_to_show=<?php echo urlencode(sprintf(__('Column %s has been dropped'), htmlspecialchars($row['Field']))); ?>" >
373 <?php echo $titles['Drop']; ?></a>
374 </td>
375 <td align="center" class="primary">
376 <?php
377 if ($type == 'text' || $type == 'blob' || 'ARCHIVE' == $tbl_type || ($primary && $primary->hasColumn($field_name))) {
378 echo $titles['NoPrimary'] . "\n";
379 $primary_enabled = false;
380 } else {
381 echo "\n";
383 <a class="add_primary_key_anchor" href="sql.php?<?php echo $url_query; ?>&amp;sql_query=<?php echo urlencode('ALTER TABLE ' . PMA_backquote($table) . ($primary ? ' DROP PRIMARY KEY,' : '') . ' ADD PRIMARY KEY(' . PMA_backquote($row['Field']) . ')'); ?>&amp;message_to_show=<?php echo urlencode(sprintf(__('A primary key has been added on %s'), htmlspecialchars($row['Field']))); ?>" >
384 <?php echo $titles['Primary']; ?></a>
385 <?php $primary_enabled = true;
387 echo "\n";
389 </td>
390 <td align="center" class="unique">
391 <?php
392 if ($type == 'text' || $type == 'blob' || 'ARCHIVE' == $tbl_type || isset($columns_with_unique_index[$field_name])) {
393 echo $titles['NoUnique'] . "\n";
394 $unique_enabled = false;
395 } else {
396 echo "\n";
398 <a href="sql.php?<?php echo $url_query; ?>&amp;sql_query=<?php echo urlencode('ALTER TABLE ' . PMA_backquote($table) . ' ADD UNIQUE(' . PMA_backquote($row['Field']) . ')'); ?>&amp;message_to_show=<?php echo urlencode(sprintf(__('An index has been added on %s'), htmlspecialchars($row['Field']))); ?>">
399 <?php echo $titles['Unique']; ?></a>
400 <?php $unique_enabled = true;
402 echo "\n";
404 </td>
405 <td align="center" class="index">
406 <?php
407 if ($type == 'text' || $type == 'blob' || 'ARCHIVE' == $tbl_type) {
408 echo $titles['NoIndex'] . "\n";
409 $index_enabled = false;
410 } else {
411 echo "\n";
413 <a href="sql.php?<?php echo $url_query; ?>&amp;sql_query=<?php echo urlencode('ALTER TABLE ' . PMA_backquote($table) . ' ADD INDEX(' . PMA_backquote($row['Field']) . ')'); ?>&amp;message_to_show=<?php echo urlencode(sprintf(__('An index has been added on %s'), htmlspecialchars($row['Field']))); ?>">
414 <?php echo $titles['Index']; ?></a>
415 <?php
416 $index_enabled = true;
418 echo "\n";
420 </td>
421 <td align="center" class="spatial">
422 <?php
423 $spatial_types = array(
424 'geometry', 'point', 'linestring', 'polygon', 'multipoint',
425 'multilinestring', 'multipolygon', 'geomtrycollection'
427 if (! in_array($type, $spatial_types) || 'MYISAM' != $tbl_type) {
428 echo $titles['NoSpatial'] . "\n";
429 $spatial_enabled = false;
430 } else {
431 echo "\n";
433 <a href="sql.php?<?php echo $url_query; ?>&amp;sql_query=<?php echo urlencode('ALTER TABLE ' . PMA_backquote($table) . ' ADD SPATIAL(' . PMA_backquote($row['Field']) . ')'); ?>&amp;message_to_show=<?php echo urlencode(sprintf(__('An index has been added on %s'), htmlspecialchars($row['Field']))); ?>">
434 <?php echo $titles['Spatial']; ?></a>
435 <?php
436 $spatial_enabled = true;
438 echo "\n";
440 </td>
441 <?php
442 if (! empty($tbl_type) && ($tbl_type == 'MYISAM' || $tbl_type == 'ARIA' || $tbl_type == 'MARIA')
443 // FULLTEXT is possible on TEXT, CHAR and VARCHAR
444 && (strpos(' ' . $type, 'text') || strpos(' ' . $type, 'char'))) {
445 echo "\n";
447 <td align="center" nowrap="nowrap" class="fulltext">
448 <a href="sql.php?<?php echo $url_query; ?>&amp;sql_query=<?php echo urlencode('ALTER TABLE ' . PMA_backquote($table) . ' ADD FULLTEXT(' . PMA_backquote($row['Field']) . ')'); ?>&amp;message_to_show=<?php echo urlencode(sprintf(__('An index has been added on %s'), htmlspecialchars($row['Field']))); ?>">
449 <?php echo $titles['IdxFulltext']; ?></a>
450 <?php $fulltext_enabled = true; ?>
451 </td>
452 <?php
453 } else {
454 echo "\n";
456 <td align="center" nowrap="nowrap" class="fulltext">
457 <?php echo $titles['NoIdxFulltext'] . "\n"; ?>
458 <?php $fulltext_enabled = false; ?>
459 </td>
460 <?php
461 } // end if... else...
462 echo "\n";
464 <td class="more_opts" id="more_opts<?php echo $rownum; ?>">
465 <?php echo PMA_getImage('more.png', __('Show more actions')); ?> <?php echo __('More'); ?>
466 <div class="structure_actions_dropdown" id="row_<?php echo $rownum; ?>">
468 <div class="action_browse">
469 <a href="sql.php?<?php echo $url_query; ?>&amp;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'])); ?>">
470 <?php echo $hidden_titles['BrowseDistinctValues']; ?>
471 </a>
472 </div>
473 <div <?php echo ($GLOBALS['cfg']['AjaxEnable'] ? ' class="action_primary"' : ''); ?>>
474 <?php
475 if (isset($primary_enabled)) {
476 if ($primary_enabled) { ?>
477 <a href="sql.php?<?php echo $url_query; ?>&amp;sql_query=<?php echo urlencode('ALTER TABLE ' . PMA_backquote($table) . ($primary ? ' DROP PRIMARY KEY,' : '') . ' ADD PRIMARY KEY(' . PMA_backquote($row['Field']) . ')'); ?>&amp;message_to_show=<?php echo urlencode(sprintf(__('A primary key has been added on %s'), htmlspecialchars($row['Field']))); ?>">
478 <?php echo $hidden_titles['Primary']; ?>
479 </a>
480 <?php
481 } else {
482 echo $hidden_titles['NoPrimary'];
484 } ?>
485 </div>
486 <div class="action_unique">
487 <?php
488 if (isset($unique_enabled)) {
489 if ($unique_enabled) { ?>
490 <a href="sql.php?<?php echo $url_query; ?>&amp;sql_query=<?php echo urlencode('ALTER TABLE ' . PMA_backquote($table) . ' ADD UNIQUE(' . PMA_backquote($row['Field']) . ')'); ?>&amp;message_to_show=<?php echo urlencode(sprintf(__('An index has been added on %s'), htmlspecialchars($row['Field']))); ?>">
491 <?php echo $hidden_titles['Unique']; ?>
492 </a>
493 <?php
494 } else {
495 echo $hidden_titles['NoUnique'];
497 } ?>
498 </div>
499 <div class="action_index">
500 <?php
501 if (isset($index_enabled)) {
502 if ($index_enabled) { ?>
503 <a href="sql.php?<?php echo $url_query; ?>&amp;sql_query=<?php echo urlencode('ALTER TABLE ' . PMA_backquote($table) . ' ADD INDEX(' . PMA_backquote($row['Field']) . ')'); ?>&amp;message_to_show=<?php echo urlencode(sprintf(__('An index has been added on %s'), htmlspecialchars($row['Field']))); ?>">
504 <?php echo $hidden_titles['Index']; ?>
505 </a>
506 <?php
507 } else {
508 echo $hidden_titles['NoIndex'];
510 } ?>
511 </div>
512 <?php if (!PMA_DRIZZLE) { ?>
513 <div class="action_spatial">
514 <?php
515 if (isset($spatial_enabled)) {
516 if ($spatial_enabled) { ?>
517 <a href="sql.php?<?php echo $url_query; ?>&amp;sql_query=<?php echo urlencode('ALTER TABLE ' . PMA_backquote($table) . ' ADD SPATIAL(' . PMA_backquote($row['Field']) . ')'); ?>&amp;message_to_show=<?php echo urlencode(sprintf(__('An index has been added on %s'), htmlspecialchars($row['Field']))); ?>">
518 <?php echo $hidden_titles['Spatial']; ?>
519 </a>
520 <?php
521 } else {
522 echo $hidden_titles['NoSpatial'];
524 } ?>
525 </div>
526 <div class="action_fulltext">
527 <?php
528 if (isset($fulltext_enabled)) {
529 if ($fulltext_enabled) { ?>
530 <a href="sql.php?<?php echo $url_query; ?>&amp;sql_query=<?php echo urlencode('ALTER TABLE ' . PMA_backquote($table) . ' ADD FULLTEXT(' . PMA_backquote($row['Field']) . ')'); ?>&amp;message_to_show=<?php echo urlencode(sprintf(__('An index has been added on %s'), htmlspecialchars($row['Field']))); ?>">
531 <?php echo $hidden_titles['IdxFulltext']; ?>
532 </a>
533 <?php
534 } else {
535 echo $hidden_titles['NoIdxFulltext'];
537 } ?>
538 </div>
539 <?php } ?>
540 </div>
541 </td>
542 <?php
543 } // end if (! $tbl_is_view && ! $db_is_information_schema)
545 </tr>
546 <?php
547 unset($field_charset);
548 } // end foreach
550 echo '</tbody>' . "\n"
551 .'</table>' . "\n";
553 $checkall_url = 'tbl_structure.php?' . PMA_generate_common_url($db, $table);
556 <img class="selectallarrow" src="<?php echo $pmaThemeImage . 'arrow_' . $text_dir . '.png'; ?>"
557 width="38" height="22" alt="<?php echo __('With selected:'); ?>" />
558 <a href="<?php echo $checkall_url; ?>&amp;checkall=1"
559 onclick="if (markAllRows('fieldsForm')) return false;">
560 <?php echo __('Check All'); ?></a>
562 <a href="<?php echo $checkall_url; ?>"
563 onclick="if (unMarkAllRows('fieldsForm')) return false;">
564 <?php echo __('Uncheck All'); ?></a>
566 <i><?php echo __('With selected:'); ?></i>
568 <?php
569 PMA_buttonOrImage('submit_mult', 'mult_submit', 'submit_mult_browse', __('Browse'), 'b_browse.png', 'browse');
571 if (! $tbl_is_view && ! $db_is_information_schema) {
572 PMA_buttonOrImage('submit_mult', 'mult_submit', 'submit_mult_change', __('Change'), 'b_edit.png', 'change');
573 PMA_buttonOrImage('submit_mult', 'mult_submit', 'submit_mult_drop', __('Drop'), 'b_drop.png', 'drop');
574 if ('ARCHIVE' != $tbl_type) {
575 PMA_buttonOrImage('submit_mult', 'mult_submit', 'submit_mult_primary', __('Primary'), 'b_primary.png', 'primary');
576 PMA_buttonOrImage('submit_mult', 'mult_submit', 'submit_mult_unique', __('Unique'), 'b_unique.png', 'unique');
577 PMA_buttonOrImage('submit_mult', 'mult_submit', 'submit_mult_index', __('Index'), 'b_index.png', 'index');
580 if (! empty($tbl_type) && $tbl_type == 'MYISAM') {
581 PMA_buttonOrImage('submit_mult', 'mult_submit', 'submit_mult_spatial', __('Spatial'), 'b_spatial.png', 'spatial');
583 if (! empty($tbl_type) && ($tbl_type == 'MYISAM' || $tbl_type == 'ARIA' || $tbl_type == 'MARIA')) {
584 PMA_buttonOrImage('submit_mult', 'mult_submit', 'submit_mult_fulltext', __('Fulltext'), 'b_ftext.png', 'ftext');
588 </form>
589 <hr />
591 <?php
593 * Work on the table
596 if ($tbl_is_view) {
597 $create_view = PMA_DBI_get_definition($db, 'VIEW', $table);
598 echo PMA_linkOrButton(
599 'tbl_sql.php' . PMA_generate_common_url(
600 $url_params +
601 array(
602 'sql_query' => $create_view,
603 'show_query' => '1',
606 PMA_getIcon('b_edit.png', __('Edit view'), true)
611 <a href="tbl_printview.php?<?php echo $url_query; ?>"><?php
612 echo PMA_getIcon('b_print.png', __('Print view'), true);
613 ?></a>
615 <?php
616 if (! $tbl_is_view && ! $db_is_information_schema) {
618 // if internal relations are available, or foreign keys are supported
619 // ($tbl_type comes from libraries/tbl_info.inc.php)
620 if ($cfgRelation['relwork'] || PMA_foreignkey_supported($tbl_type)) {
622 <a href="tbl_relation.php?<?php echo $url_query; ?>"><?php
623 echo PMA_getIcon('b_relations.png', __('Relation view'), true);
624 ?></a>
625 <?php
628 if (!PMA_DRIZZLE) {
630 <a href="sql.php?<?php echo $url_query; ?>&amp;session_max_rows=all&amp;sql_query=<?php echo urlencode('SELECT * FROM ' . PMA_backquote($table) . ' PROCEDURE ANALYSE()'); ?>"><?php
631 echo PMA_getIcon('b_tblanalyse.png', __('Propose table structure'), true);
632 ?></a><?php
633 echo PMA_showMySQLDocu('Extending_MySQL', 'procedure_analyse') . "\n";
636 if (PMA_Tracker::isActive()) {
637 echo '<a href="tbl_tracking.php?' . $url_query . '">';
638 echo PMA_getIcon('eye.png', __('Track table'), true);
639 echo '</a>';
643 <br />
644 <form method="post" action="tbl_addfield.php" id="addColumns" name="addColumns" <?php echo ($GLOBALS['cfg']['AjaxEnable'] ? ' class="ajax"' : '');?>
645 onsubmit="return checkFormElementInRange(this, 'num_fields', '<?php echo str_replace('\'', '\\\'', __('You have to add at least one column.')); ?>', 1)">
646 <?php
647 echo PMA_generate_common_hidden_inputs($db, $table);
648 if ($cfg['PropertiesIconic']) {
649 echo PMA_getImage('b_insrow.png', __('Add column'));
651 echo sprintf(__('Add %s column(s)'), '<input type="text" name="num_fields" size="2" maxlength="2" value="1" onfocus="this.select()" />');
653 // I tried displaying the drop-down inside the label but with Firefox
654 // the drop-down was blinking
655 $fieldOptions = '<select name="after_field" onclick="this.form.field_where[2].checked=true" onchange="this.form.field_where[2].checked=true">';
656 foreach ($aryFields as $fieldname) {
657 $fieldOptions .= '<option value="' . htmlspecialchars($fieldname) . '">' . htmlspecialchars($fieldname) . '</option>' . "\n";
659 unset($aryFields);
660 $fieldOptions .= '</select>';
662 $choices = array(
663 'last' => __('At End of Table'),
664 'first' => __('At Beginning of Table'),
665 'after' => sprintf(__('After %s'), '')
667 PMA_display_html_radio('field_where', $choices, 'last', false);
668 echo $fieldOptions;
669 unset($fieldOptions, $choices);
671 <input type="submit" value="<?php echo __('Go'); ?>" />
672 </form>
673 <iframe class="IE_hack" scrolling="no"></iframe>
674 <hr />
675 <div id="index_div" <?php echo ($GLOBALS['cfg']['AjaxEnable'] ? ' class="ajax"' : ''); ?> >
676 <?php
680 * If there are more than 20 rows, displays browse/select/insert/empty/drop
681 * links again
683 if (count($fields) > 20) {
684 include './libraries/tbl_links.inc.php';
685 } // end if (count($fields) > 20)
688 * Displays indexes
691 if (! $tbl_is_view && ! $db_is_information_schema && 'ARCHIVE' != $tbl_type) {
693 * Display indexes
695 echo PMA_Index::getView($table, $db);
697 </div>
698 <form action="./tbl_indexes.php" method="post"
699 onsubmit="return checkFormElementInRange(this, 'added_fields',
700 '<?php echo str_replace('\'', '\\\'', __('Column count has to be larger than zero.')); ?>',
701 1)">
702 <fieldset>
703 <?php
704 echo PMA_generate_common_hidden_inputs($db, $table);
705 echo sprintf(__('Create an index on &nbsp;%s&nbsp;columns'),
706 '<input type="text" size="2" name="added_fields" value="1" />');
708 <input type="submit" name="create_index" value="<?php echo __('Go'); ?>" />
709 </fieldset>
710 </form>
711 <br />
712 <?php
716 * Displays Space usage and row statistics
718 // BEGIN - Calc Table Space
719 // Get valid statistics whatever is the table type
720 if ($cfg['ShowStats']) {
721 echo '<div id="tablestatistics">';
722 if (empty($showtable)) {
723 $showtable = PMA_Table::sGetStatusInfo($GLOBALS['db'], $GLOBALS['table'], null, true);
726 $nonisam = false;
727 $is_innodb = (isset($showtable['Type']) && $showtable['Type'] == 'InnoDB');
728 if (isset($showtable['Type']) && !preg_match('@ISAM|HEAP@i', $showtable['Type'])) {
729 $nonisam = true;
732 // Gets some sizes
734 $mergetable = PMA_Table::isMerge($GLOBALS['db'], $GLOBALS['table']);
736 // this is to display for example 261.2 MiB instead of 268k KiB
737 $max_digits = 5;
738 $decimals = 1;
739 list($data_size, $data_unit) = PMA_formatByteDown($showtable['Data_length'], $max_digits, $decimals);
740 if ($mergetable == false) {
741 list($index_size, $index_unit) = PMA_formatByteDown($showtable['Index_length'], $max_digits, $decimals);
743 // InnoDB returns a huge value in Data_free, do not use it
744 if (! $is_innodb && isset($showtable['Data_free']) && $showtable['Data_free'] > 0) {
745 list($free_size, $free_unit) = PMA_formatByteDown($showtable['Data_free'], $max_digits, $decimals);
746 list($effect_size, $effect_unit) = PMA_formatByteDown($showtable['Data_length'] + $showtable['Index_length'] - $showtable['Data_free'], $max_digits, $decimals);
747 } else {
748 list($effect_size, $effect_unit) = PMA_formatByteDown($showtable['Data_length'] + $showtable['Index_length'], $max_digits, $decimals);
750 list($tot_size, $tot_unit) = PMA_formatByteDown($showtable['Data_length'] + $showtable['Index_length'], $max_digits, $decimals);
751 if ($table_info_num_rows > 0) {
752 list($avg_size, $avg_unit) = PMA_formatByteDown(($showtable['Data_length'] + $showtable['Index_length']) / $showtable['Rows'], 6, 1);
755 // Displays them
756 $odd_row = false;
759 <a name="showusage"></a>
760 <?php if (! $tbl_is_view && ! $db_is_information_schema) { ?>
761 <table id="tablespaceusage" class="data">
762 <caption class="tblHeaders"><?php echo __('Space usage'); ?></caption>
763 <thead>
764 <tr>
765 <th><?php echo __('Type'); ?></th>
766 <th colspan="2"><?php echo __('Usage'); ?></th>
767 </tr>
768 </thead>
769 <tbody>
770 <tr class="<?php echo ($odd_row = !$odd_row) ? 'odd' : 'even'; ?>">
771 <th class="name"><?php echo __('Data'); ?></th>
772 <td class="value"><?php echo $data_size; ?></td>
773 <td class="unit"><?php echo $data_unit; ?></td>
774 </tr>
775 <?php
776 if (isset($index_size)) {
778 <tr class="<?php echo ($odd_row = !$odd_row) ? 'odd' : 'even'; ?>">
779 <th class="name"><?php echo __('Index'); ?></th>
780 <td class="value"><?php echo $index_size; ?></td>
781 <td class="unit"><?php echo $index_unit; ?></td>
782 </tr>
783 <?php
785 if (isset($free_size)) {
787 <tr class="<?php echo ($odd_row = !$odd_row) ? 'odd' : 'even'; ?> error">
788 <th class="name"><?php echo __('Overhead'); ?></th>
789 <td class="value"><?php echo $free_size; ?></td>
790 <td class="unit"><?php echo $free_unit; ?></td>
791 </tr>
792 <tr class="<?php echo ($odd_row = !$odd_row) ? 'odd' : 'even'; ?>">
793 <th class="name"><?php echo __('Effective'); ?></th>
794 <td class="value"><?php echo $effect_size; ?></td>
795 <td class="unit"><?php echo $effect_unit; ?></td>
796 </tr>
797 <?php
799 if (isset($tot_size) && $mergetable == false) {
801 <tr class="<?php echo ($odd_row = !$odd_row) ? 'odd' : 'even'; ?>">
802 <th class="name"><?php echo __('Total'); ?></th>
803 <td class="value"><?php echo $tot_size; ?></td>
804 <td class="unit"><?php echo $tot_unit; ?></td>
805 </tr>
806 <?php
808 // Optimize link if overhead
809 if (isset($free_size) && !PMA_DRIZZLE && ($tbl_type == 'MYISAM' || $tbl_type == 'ARIA' || $tbl_type == 'MARIA' || $tbl_type == 'BDB')) {
811 <tr class="tblFooters">
812 <td colspan="3" align="center">
813 <a href="sql.php?<?php echo $url_query; ?>&pos=0&amp;sql_query=<?php echo urlencode('OPTIMIZE TABLE ' . PMA_backquote($table)); ?>"><?php
814 echo PMA_getIcon('b_tbloptimize.png', __('Optimize table'));
815 ?></a>
816 </td>
817 </tr>
818 <?php
821 </tbody>
822 </table>
823 <?php
825 $odd_row = false;
827 <table id="tablerowstats" class="data">
828 <caption class="tblHeaders"><?php echo __('Row Statistics'); ?></caption>
829 <thead>
830 <tr>
831 <th><?php echo __('Statements'); ?></th>
832 <th><?php echo __('Value'); ?></th>
833 </tr>
834 </thead>
835 <tbody>
836 <?php
837 if (isset($showtable['Row_format'])) {
839 <tr class="<?php echo ($odd_row = !$odd_row) ? 'odd' : 'even'; ?>">
840 <th class="name"><?php echo __('Format'); ?></th>
841 <td class="value"><?php
842 if ($showtable['Row_format'] == 'Fixed') {
843 echo __('static');
844 } elseif ($showtable['Row_format'] == 'Dynamic') {
845 echo __('dynamic');
846 } else {
847 echo $showtable['Row_format'];
849 ?></td>
850 </tr>
851 <?php
853 if (! empty($showtable['Create_options'])) {
855 <tr class="<?php echo ($odd_row = !$odd_row) ? 'odd' : 'even'; ?>">
856 <th class="name"><?php echo __('Options'); ?></th>
857 <td class="value"><?php
858 if ($showtable['Create_options'] == 'partitioned') {
859 echo __('partitioned');
860 } else {
861 echo $showtable['Create_options'];
863 ?></td>
864 </tr>
865 <?php
867 if (!empty($tbl_collation)) {
869 <tr class="<?php echo ($odd_row = !$odd_row) ? 'odd' : 'even'; ?>">
870 <th class="name"><?php echo __('Collation'); ?></th>
871 <td class="value"><?php
872 echo '<dfn title="' . PMA_getCollationDescr($tbl_collation) . '">' . $tbl_collation . '</dfn>';
873 ?></td>
874 </tr>
875 <?php
877 if (!$is_innodb && isset($showtable['Rows'])) {
879 <tr class="<?php echo ($odd_row = !$odd_row) ? 'odd' : 'even'; ?>">
880 <th class="name"><?php echo __('Rows'); ?></th>
881 <td class="value"><?php echo PMA_formatNumber($showtable['Rows'], 0); ?></td>
882 </tr>
883 <?php
885 if (!$is_innodb && isset($showtable['Avg_row_length']) && $showtable['Avg_row_length'] > 0) {
887 <tr class="<?php echo ($odd_row = !$odd_row) ? 'odd' : 'even'; ?>">
888 <th class="name"><?php echo __('Row length'); ?> &oslash;</th>
889 <td class="value"><?php echo PMA_formatNumber($showtable['Avg_row_length'], 0); ?></td>
890 </tr>
891 <?php
893 if (!$is_innodb && isset($showtable['Data_length']) && $showtable['Rows'] > 0 && $mergetable == false) {
895 <tr class="<?php echo ($odd_row = !$odd_row) ? 'odd' : 'even'; ?>">
896 <th class="name"><?php echo __('Row size'); ?> &oslash;</th>
897 <td class="value"><?php echo $avg_size . ' ' . $avg_unit; ?></td>
898 </tr>
899 <?php
901 if (isset($showtable['Auto_increment'])) {
903 <tr class="<?php echo ($odd_row = !$odd_row) ? 'odd' : 'even'; ?>">
904 <th class="name"><?php echo __('Next autoindex'); ?></th>
905 <td class="value"><?php echo PMA_formatNumber($showtable['Auto_increment'], 0); ?></td>
906 </tr>
907 <?php
909 if (isset($showtable['Create_time'])) {
911 <tr class="<?php echo ($odd_row = !$odd_row) ? 'odd' : 'even'; ?>">
912 <th class="name"><?php echo __('Creation'); ?></th>
913 <td class="value"><?php echo PMA_localisedDate(strtotime($showtable['Create_time'])); ?></td>
914 </tr>
915 <?php
917 if (isset($showtable['Update_time'])) {
919 <tr class="<?php echo ($odd_row = !$odd_row) ? 'odd' : 'even'; ?>">
920 <th class="name"><?php echo __('Last update'); ?></th>
921 <td class="value"><?php echo PMA_localisedDate(strtotime($showtable['Update_time'])); ?></td>
922 </tr>
923 <?php
925 if (isset($showtable['Check_time'])) {
927 <tr class="<?php echo ($odd_row = !$odd_row) ? 'odd' : 'even'; ?>">
928 <th class="name"><?php echo __('Last check'); ?></th>
929 <td class="value"><?php echo PMA_localisedDate(strtotime($showtable['Check_time'])); ?></td>
930 </tr>
931 <?php
934 </tbody>
935 </table>
937 <!-- close tablestatistics div -->
938 </div>
940 <?php
942 // END - Calc Table Space
944 echo '<div class="clearfloat"></div>' . "\n";
947 * Displays the footer
949 require './libraries/footer.inc.php';