3 // vim: expandtab sw=4 ts=4 sts=4:
5 require_once './libraries/common.lib.php';
6 require_once './libraries/Table.class.php';
8 $pma_table = new PMA_Table($GLOBALS['table'], $GLOBALS['db']);
13 require './libraries/tbl_properties_common.php';
14 $url_query .= '&goto=tbl_properties_operations.php&back=tbl_properties_operations.php';
15 $url_params['goto'] = $url_params['back'] = 'tbl_properties_operations.php';
18 * Gets relation settings
20 require_once './libraries/relation.lib.php';
21 $cfgRelation = PMA_getRelationsParam();
24 * Gets available MySQL charsets and storage engines
26 require_once './libraries/mysql_charsets.lib.php';
27 require_once './libraries/storage_engines.lib.php';
29 // reselect current db (needed in some cases probably due to
30 // the calling of relation.lib.php)
31 PMA_DBI_select_db($GLOBALS['db']);
34 * Gets tables informations
37 require './libraries/tbl_properties_table_info.inc.php';
41 $table_alters = array();
44 * Updates table comment, type and options if required
46 if (isset($_REQUEST['submitoptions'])) {
48 if (isset($_REQUEST['new_name'])) {
49 if ($pma_table->rename($_REQUEST['new_name'])) {
50 $message .= $pma_table->getLastMessage();
51 $GLOBALS['table'] = $pma_table->getName();;
55 $errors[] = $pma_table->getLastError();
56 $message .= $pma_table->getLastError();
59 if (isset($_REQUEST['comment'])
60 && urldecode($_REQUEST['prev_comment']) !== $_REQUEST['comment']) {
61 $table_alters[] = 'COMMENT = \'' . PMA_sqlAddslashes($_REQUEST['comment']) . '\'';
63 if (! empty($_REQUEST['new_tbl_type'])
64 && strtolower($_REQUEST['new_tbl_type']) !== strtolower($tbl_type)) {
65 $table_alters[] = PMA_ENGINE_KEYWORD
. ' = ' . $_REQUEST['new_tbl_type'];
66 $tbl_type = $_REQUEST['new_tbl_type'];
69 if (! empty($_REQUEST['tbl_collation'])
70 && $_REQUEST['tbl_collation'] !== $tbl_collation) {
71 $table_alters[] = 'DEFAULT ' . PMA_generateCharsetQueryPart($_REQUEST['tbl_collation']);
74 $l_tbl_type = strtolower($tbl_type);
76 if (($l_tbl_type === 'myisam' ||
$l_tbl_type === 'isam')
77 && $_REQUEST['new_pack_keys'] != (string)$pack_keys) {
78 $table_alters[] = 'pack_keys = ' . $_REQUEST['new_pack_keys'];
81 $checksum = empty($checksum) ?
'0' : '1';
82 $_REQUEST['new_checksum'] = empty($_REQUEST['new_checksum']) ?
'0' : '1';
83 if (($l_tbl_type === 'myisam')
84 && $_REQUEST['new_checksum'] !== $checksum) {
85 $table_alters[] = 'checksum = ' . $_REQUEST['new_checksum'];
88 $delay_key_write = empty($delay_key_write) ?
'0' : '1';
89 $_REQUEST['new_delay_key_write'] = empty($_REQUEST['new_delay_key_write']) ?
'0' : '1';
90 if (($l_tbl_type === 'myisam')
91 && $_REQUEST['new_delay_key_write'] !== $delay_key_write) {
92 $table_alters[] = 'delay_key_write = ' . $_REQUEST['new_delay_key_write'];
95 if (($l_tbl_type === 'myisam' ||
$l_tbl_type === 'innodb')
96 && ! empty($_REQUEST['new_auto_increment'])
97 && (! isset($auto_increment) ||
$_REQUEST['new_auto_increment'] !== $auto_increment)) {
98 $table_alters[] = 'auto_increment = ' . PMA_sqlAddslashes($_REQUEST['new_auto_increment']);
101 if (count($table_alters) > 0) {
102 $sql_query = 'ALTER TABLE ' . PMA_backquote($GLOBALS['table']);
103 $sql_query .= "\r\n" . implode("\r\n", $table_alters);
104 $message .= PMA_DBI_query($sql_query) ?
$strSuccess : $strError;
106 unset($table_alters);
110 * Reordering the table has been requested by the user
112 if (isset($_REQUEST['submitorderby']) && ! empty($_REQUEST['order_field'])) {
114 ALTER TABLE ' . PMA_backquote($GLOBALS['table']) . '
115 ORDER BY ' . PMA_backquote(urldecode($_REQUEST['order_field']));
116 if (isset($_REQUEST['order_order']) && $_REQUEST['order_order'] === 'desc') {
117 $sql_query .= ' DESC';
119 $message = PMA_DBI_query($sql_query) ?
$strSuccess : $strError;
124 $checksum = $delay_key_write = 0;
125 require './libraries/tbl_properties_table_info.inc.php';
130 * Displays top menu links
132 require_once './libraries/tbl_properties_links.inc.php';
134 $url_params['goto'] = 'tbl_properties_operations.php';
135 $url_params['back'] = 'tbl_properties_operations.php';
142 FROM ' . PMA_backquote($GLOBALS['table']) . '
143 FROM ' . PMA_backquote($GLOBALS['db']);
144 $columns = PMA_DBI_fetch_result($local_query, null, 'Field');
151 <!-- Order the table
-->
152 <div id
="div_table_order">
153 <form method
="post" action
="tbl_properties_operations.php">
154 <?php
echo PMA_generate_common_hidden_inputs($GLOBALS['db'], $GLOBALS['table']); ?
>
155 <fieldset id
="fieldset_table_order">
156 <legend
><?php
echo $strAlterOrderBy; ?
></legend
>
157 <select name
="order_field">
159 foreach ($columns as $fieldname) {
160 echo ' <option value="' . htmlspecialchars($fieldname) . '">'
161 . htmlspecialchars($fieldname) . '</option>' . "\n";
165 </select
> <?php
echo $strSingly; ?
>
166 <select name
="order_order">
167 <option value
="asc"><?php
echo $strAscending; ?
></option
>
168 <option value
="desc"><?php
echo $strDescending; ?
></option
>
170 <input type
="submit" name
="submitorderby" value
="<?php echo $strGo; ?>" />
176 <div id
="div_table_rename">
177 <form method
="post" action
="tbl_move_copy.php"
178 onsubmit
="return emptyFormElements(this, 'new_name')">
179 <?php
echo PMA_generate_common_hidden_inputs($GLOBALS['db'], $GLOBALS['table']); ?
>
180 <input type
="hidden" name
="reload" value
="1" />
181 <input type
="hidden" name
="what" value
="data" />
182 <fieldset id
="fieldset_table_rename">
183 <legend
><?php
echo $strMoveTable; ?
></legend
>
184 <select name
="target_db">
186 // The function used below is defined in "common.lib.php"
187 PMA_availableDatabases('main.php?' . PMA_generate_common_url());
188 foreach ($dblist as $each_db) {
190 echo '<option value="' . htmlspecialchars($each_db) . '">'
191 . htmlspecialchars($each_db) . '</option>';
193 } // end foreach $dblist
197 <input type
="text" size
="20" name
="new_name" onfocus
="this.select()"
198 value
="<?php echo htmlspecialchars($GLOBALS['table']); ?>" />
199 <input type
="submit" name
="submit_move" value
="<?php echo $strGo; ?>" />
205 if (strstr($show_comment, '; InnoDB free') === false) {
206 if (strstr($show_comment, 'InnoDB free') === false) {
207 // only user entered comment
208 $comment = $show_comment;
210 // here we have just InnoDB generated part
214 // remove InnoDB comment from end, just the minimal part (*? is non greedy)
215 $comment = preg_replace('@; InnoDB free:.*?$@', '', $show_comment);
218 // PACK_KEYS: MyISAM or ISAM
219 // DELAY_KEY_WRITE, CHECKSUM, : MyISAM only
220 // AUTO_INCREMENT: MyISAM and InnoDB since 5.0.3
222 // nijel: Here should be version check for InnoDB, however it is supported
223 // in >5.0.4, >4.1.12 and >4.0.11, so I decided not to
227 <!-- Table options
-->
228 <div id
="div_table_options">
229 <form method
="post" action
="tbl_properties_operations.php">
230 <?php
echo PMA_generate_common_hidden_inputs($GLOBALS['db'], $GLOBALS['table']); ?
>
231 <input type
="hidden" name
="reload" value
="1" />
233 <legend
><?php
echo $strTableOptions; ?
></legend
>
236 <!-- Change table name
-->
237 <tr
><td
><?php
echo $strRenameTable; ?
></td
>
238 <td
><input type
="text" size
="20" name
="new_name" onfocus
="this.select()"
239 value
="<?php echo htmlspecialchars($GLOBALS['table']); ?>" />
243 <!-- Table comments
-->
244 <tr
><td
><?php
echo $strTableComments; ?
></td
>
245 <td
><input type
="text" name
="comment" maxlength
="60" size
="30"
246 value
="<?php echo htmlspecialchars($comment); ?>" onfocus
="this.select()" />
247 <input type
="hidden" name
="prev_comment" value
="<?php echo urlencode($comment); ?>" />
251 <!-- Storage engine
-->
252 <tr
><td
><?php
echo $strStorageEngine; ?
>
253 <?php
echo PMA_showMySQLDocu('Storage_engines', 'Storage_engines'); ?
>
255 <td
><?php
echo PMA_generateEnginesDropdown('new_tbl_type', null, false, $tbl_type, 4); ?
>
260 if (PMA_MYSQL_INT_VERSION
>= 40100) {
262 <!-- Table character set
-->
263 <tr
><td
><?php
echo $strCollation; ?
></td
>
264 <td
><?php
echo PMA_generateCharsetDropdownBox(PMA_CSDROPDOWN_COLLATION
,
265 'tbl_collation', null, $tbl_collation, false, 3); ?
>
270 if ($tbl_type == 'MYISAM' ||
$tbl_type == 'ISAM') {
273 <td
><label
for="new_pack_keys">pack_keys
</label
></td
>
274 <td
><select name
="new_pack_keys" id
="new_pack_keys">
275 <option value
="DEFAULT"
276 <?php
if ($pack_keys == 'DEFAULT') echo 'selected="selected"'; ?
>
279 <?php
if ($pack_keys == '0') echo 'selected="selected"'; ?
>
282 <?php
if ($pack_keys == '1') echo 'selected="selected"'; ?
>
288 } // end if (MYISAM|ISAM)
290 if ($tbl_type == 'MYISAM') {
292 <tr
><td
><label
for="new_checksum">checksum
</label
></td
>
293 <td
><input type
="checkbox" name
="new_checksum" id
="new_checksum"
295 <?php
echo (isset($checksum) && $checksum == 1)
296 ?
' checked="checked"'
301 <tr
><td
><label
for="new_delay_key_write">delay_key_write
</label
></td
>
302 <td
><input type
="checkbox" name
="new_delay_key_write" id
="new_delay_key_write"
304 <?php
echo (isset($delay_key_write) && $delay_key_write == 1)
305 ?
' checked="checked"'
313 if (isset($auto_increment) && strlen($auto_increment) > 0
314 && ($tbl_type == 'MYISAM' ||
$tbl_type == 'INNODB')) {
316 <tr
><td
><label
for="auto_increment_opt">auto_increment
</label
></td
>
317 <td
><input type
="text" name
="new_auto_increment" id
="auto_increment_opt"
318 value
="<?php echo $auto_increment; ?>" /></td
>
321 } // end if (MYISAM|INNODB)
325 <fieldset
class="tblFooters">
326 <input type
="submit" name
="submitoptions" value
="<?php echo $strGo; ?>" />
332 <div id
="div_table_copy">
333 <form method
="post" action
="tbl_move_copy.php"
334 onsubmit
="return emptyFormElements(this, 'new_name')">
335 <?php
echo PMA_generate_common_hidden_inputs($GLOBALS['db'], $GLOBALS['table']); ?
>
336 <input type
="hidden" name
="reload" value
="1" />
338 <legend
><?php
echo $strCopyTable; ?
></legend
>
339 <select name
="target_db">
341 foreach ($dblist as $each_db) {
343 echo '<option value="' . htmlspecialchars($each_db) . '"';
344 if ($each_db === $GLOBALS['db']) {
345 echo ' selected="selected"';
347 echo '>' . htmlspecialchars($each_db) . '</option>';
349 } // end foreach $dblist
353 <input type
="text" size
="20" name
="new_name" onfocus
="this.select()" /><br
/>
355 <input type
="radio" name
="what" value
="structure" id
="radio_copy_structure" />
356 <label
for="radio_copy_structure"><?php
echo $strStrucOnly; ?
></label
><br
/>
357 <input type
="radio" name
="what" value
="data" id
="radio_copy_data" checked
="checked" />
358 <label
for="radio_copy_data"><?php
echo $strStrucData; ?
></label
><br
/>
359 <input type
="radio" name
="what" value
="dataonly" id
="radio_copy_dataonly" />
360 <label
for="radio_copy_dataonly"><?php
echo $strDataOnly; ?
></label
><br
/>
362 <input type
="checkbox" name
="drop_if_exists" value
="true" id
="checkbox_drop" />
363 <label
for="checkbox_drop"><?php
echo sprintf($strAddClause, 'DROP TABLE'); ?
></label
><br
/>
364 <input type
="checkbox" name
="sql_auto_increment" value
="1" id
="checkbox_auto_increment" />
365 <label
for="checkbox_auto_increment"><?php
echo $strAddAutoIncrement; ?
></label
><br
/>
367 // display "Add constraints" choice only if there are
369 if (PMA_getForeigners($GLOBALS['db'], $GLOBALS['table'], '', 'innodb')) {
371 <input type
="checkbox" name
="sql_constraints" value
="1" id
="checkbox_constraints" />
372 <label
for="checkbox_constraints"><?php
echo $strAddConstraints; ?
></label
><br
/>
375 if (isset($_COOKIE['pma_switch_to_new'])
376 && $_COOKIE['pma_switch_to_new'] == 'true') {
377 $pma_switch_to_new = 'true';
380 <input type
="checkbox" name
="switch_to_new" value
="true"
381 id
="checkbox_switch"<?php
echo
382 isset($pma_switch_to_new) && $pma_switch_to_new == 'true'
383 ?
' checked="checked"'
385 <label
for="checkbox_switch"><?php
echo $strSwitchToTable; ?
></label
>
387 <fieldset
class="tblFooters">
388 <input type
="submit" name
="submit_copy" value
="<?php echo $strGo; ?>" />
393 <br
class="clearfloat"/>
395 <h1
><?php
echo $strTableMaintenance; ?
></h1
>
399 if ($tbl_type == 'MYISAM' ||
$tbl_type == 'BERKELEYDB' ||
$tbl_type == 'INNODB') {
400 if ($tbl_type == 'MYISAM' ||
$tbl_type == 'INNODB') {
401 $this_url_params = array_merge($url_params,
402 array('sql_query' => 'CHECK TABLE ' . PMA_backquote($GLOBALS['table'])));
404 <li
><a href
="sql.php<?php echo PMA_generate_common_url($this_url_params); ?>">
405 <?php
echo $strCheckTable; ?
></a
>
406 <?php
echo PMA_showMySQLDocu('MySQL_Database_Administration', 'CHECK_TABLE'); ?
>
410 if ($tbl_type == 'INNODB') {
411 $this_url_params = array_merge($url_params,
412 array('sql_query' => 'ALTER TABLE ' . PMA_backquote($GLOBALS['table']) . ' ' . PMA_ENGINE_KEYWORD
. '=InnoDB'));
414 <li
><a href
="sql.php<?php echo PMA_generate_common_url($this_url_params); ?>">
415 <?php
echo $strDefragment; ?
></a
>
416 <?php
echo PMA_showMySQLDocu('Table_types', 'InnoDB_File_Defragmenting'); ?
>
420 if ($tbl_type == 'MYISAM' ||
$tbl_type == 'BERKELEYDB') {
421 $this_url_params = array_merge($url_params,
422 array('sql_query' => 'ANALYZE TABLE ' . PMA_backquote($GLOBALS['table'])));
424 <li
><a href
="sql.php<?php echo PMA_generate_common_url($this_url_params); ?>">
425 <?php
echo $strAnalyzeTable; ?
></a
>
426 <?php
echo PMA_showMySQLDocu('MySQL_Database_Administration', 'ANALYZE_TABLE');?
>
430 if ($tbl_type == 'MYISAM') {
431 $this_url_params = array_merge($url_params,
432 array('sql_query' => 'REPAIR TABLE ' . PMA_backquote($GLOBALS['table'])));
434 <li
><a href
="sql.php<?php echo PMA_generate_common_url($this_url_params); ?>">
435 <?php
echo $strRepairTable; ?
></a
>
436 <?php
echo PMA_showMySQLDocu('MySQL_Database_Administration', 'REPAIR_TABLE'); ?
>
440 if ($tbl_type == 'MYISAM' ||
$tbl_type == 'BERKELEYDB' ||
$tbl_type == 'INNODB') {
441 $this_url_params = array_merge($url_params,
442 array('sql_query' => 'OPTIMIZE TABLE ' . PMA_backquote($GLOBALS['table'])));
444 <li
><a href
="sql.php<?php echo PMA_generate_common_url($this_url_params); ?>">
445 <?php
echo $strOptimizeTable; ?
></a
>
446 <?php
echo PMA_showMySQLDocu('MySQL_Database_Administration', 'OPTIMIZE_TABLE'); ?
>
450 } // end MYISAM or BERKELEYDB case
451 $this_url_params = array_merge($url_params,
453 'sql_query' => 'FLUSH TABLE ' . PMA_backquote($GLOBALS['table']),
454 'zero_rows' => sprintf($strTableHasBeenFlushed,
455 htmlspecialchars($GLOBALS['table'])),
459 <li
><a href
="sql.php<?php echo PMA_generate_common_url($this_url_params); ?>">
460 <?php
echo $strFlushTable; ?
></a
>
461 <?php
echo PMA_showMySQLDocu('MySQL_Database_Administration', 'FLUSH'); ?
>
465 // Referential integrity check
466 // The Referential integrity check was intended for the non-InnoDB
467 // tables for which the relations are defined in pmadb
468 // so I assume that if the current table is InnoDB, I don't display
469 // this choice (InnoDB maintains integrity by itself)
471 if ($cfgRelation['relwork'] && $tbl_type != "INNODB") {
473 // we need this PMA_DBI_select_db if the user has access to more than one db
474 // and $GLOBALS['db'] is not the last of the list, because PMA_availableDatabases()
475 // has made a PMA_DBI_select_db() on the last one
476 PMA_DBI_select_db($GLOBALS['db']);
477 $foreign = PMA_getForeigners($GLOBALS['db'], $GLOBALS['table']);
481 <!-- Referential integrity check
-->
483 <?php
echo $strReferentialIntegrity; ?
><br
/>
486 foreach ($foreign AS $master => $arr) {
487 $join_query = 'SELECT ' . PMA_backquote($GLOBALS['table']) . '.* FROM '
488 . PMA_backquote($GLOBALS['table']) . ' LEFT JOIN '
489 . PMA_backquote($arr['foreign_table']);
490 if ($arr['foreign_table'] == $GLOBALS['table']) {
491 $foreign_table = $GLOBALS['table'] . '1';
492 $join_query .= ' AS ' . PMA_backquote($foreign_table);
494 $foreign_table = $arr['foreign_table'];
496 $join_query .= ' ON '
497 . PMA_backquote($GLOBALS['table']) . '.' . PMA_backquote($master)
498 . ' = ' . PMA_backquote($foreign_table) . '.' . PMA_backquote($arr['foreign_field'])
500 . PMA_backquote($foreign_table) . '.' . PMA_backquote($arr['foreign_field'])
502 . PMA_backquote($GLOBALS['table']) . '.' . PMA_backquote($master)
504 $this_url_params = array_merge($url_params,
505 array('sql_query' => $join_query));
508 . PMA_generate_common_url($this_url_params)
509 . '">' . $master . ' -> ' . $arr['foreign_table'] . '.' . $arr['foreign_field']
510 . '</a></li>' . "\n";
511 } // foreach $foreign
512 unset($foreign_table, $join_query);
516 } // end if ($result)
518 } // end if (!empty($cfg['Server']['relation']))
522 * Displays the footer
524 require_once './libraries/footer.inc.php';