Viewing file: tbl_properties_operations.php (19.09 KB) -rw-r--r-- Select action/file-type: (+) | (+) | (+) | Code (+) | Session (+) | (+) | SDB (+) | (+) | (+) | (+) | (+) | (+) |
<?php /* $Id: tbl_properties_operations.php,v 2.48.2.2 2006/03/08 17:54:29 lem9 Exp $ */ // vim: expandtab sw=4 ts=4 sts=4:
require_once('./libraries/common.lib.php');
/** * Runs common work */ require('./libraries/tbl_properties_common.php'); $url_query .= '&goto=tbl_properties_operations.php&back=tbl_properties_operations.php';
/** * Gets relation settings */ require_once('./libraries/relation.lib.php'); $cfgRelation = PMA_getRelationsParam();
/** * Gets available MySQL charsets and storage engines */ require_once('./libraries/mysql_charsets.lib.php'); require_once('./libraries/storage_engines.lib.php');
// reselect current db (needed in some cases probably due to // the calling of relation.lib.php) PMA_DBI_select_db($GLOBALS['db']);
/** * Gets tables informations */
require_once('./libraries/tbl_move_copy.php'); require('./libraries/tbl_properties_table_info.inc.php');
$reread_info = false; $errors = array(); $table_alters = array();
/** * Updates table comment, type and options if required */ if ( isset( $_REQUEST['submitoptions'] ) ) { if ( isset( $_REQUEST['new_name'] ) && $_REQUEST['new_name'] !== $GLOBALS['table'] ) { if ( trim($_REQUEST['new_name']) === '' ) { $errors[] = $strTableEmpty; } elseif ( strpos($_REQUEST['new_name'], '.') !== false ) { $errors[] = $strError . ': ' . $_REQUEST['new_name']; } else { if ( PMA_table_rename( $GLOBALS['table'], $_REQUEST['new_name'] ) ) { $message = sprintf($GLOBALS['strRenameTableOK'], htmlspecialchars($GLOBALS['table']), htmlspecialchars($_REQUEST['new_name'])); $GLOBALS['table'] = $_REQUEST['new_name']; $reread_info = true; $reload = true; } else { $errors[] = $strError . ': ' . $_REQUEST['new_name']; } } } if ( isset( $_REQUEST['comment'] ) && urldecode($_REQUEST['prev_comment']) !== $_REQUEST['comment'] ) { $table_alters[] = 'COMMENT = \'' . PMA_sqlAddslashes($_REQUEST['comment']) . '\''; } if ( ! empty( $_REQUEST['new_tbl_type'] ) && strtolower($_REQUEST['new_tbl_type']) !== strtolower($tbl_type) ) { $table_alters[] = PMA_ENGINE_KEYWORD . ' = ' . $_REQUEST['new_tbl_type']; $tbl_type = $_REQUEST['new_tbl_type']; }
if ( ! empty( $_REQUEST['tbl_collation'] ) && $_REQUEST['tbl_collation'] !== $tbl_collation ) { $table_alters[] = 'DEFAULT ' . PMA_generateCharsetQueryPart($_REQUEST['tbl_collation']); }
$l_tbl_type = strtolower( $tbl_type );
$pack_keys = empty( $pack_keys ) ? '0' : '1'; $_REQUEST['new_pack_keys'] = empty( $_REQUEST['new_pack_keys'] ) ? '0' : '1'; if ( ( $l_tbl_type === 'myisam' || $l_tbl_type === 'isam' ) && $_REQUEST['new_pack_keys'] !== $pack_keys ) { $table_alters[] = 'pack_keys = ' . $_REQUEST['new_pack_keys']; }
$checksum = empty( $checksum ) ? '0' : '1'; $_REQUEST['new_checksum'] = empty( $_REQUEST['new_checksum'] ) ? '0' : '1'; if ( ( $l_tbl_type === 'myisam' ) && $_REQUEST['new_checksum'] !== $checksum ) { $table_alters[] = 'checksum = ' . $_REQUEST['new_checksum']; }
$delay_key_write = empty( $delay_key_write ) ? '0' : '1'; $_REQUEST['new_delay_key_write'] = empty( $_REQUEST['new_delay_key_write'] ) ? '0' : '1'; if ( ( $l_tbl_type === 'myisam' ) && $_REQUEST['new_delay_key_write'] !== $delay_key_write ) { $table_alters[] = 'delay_key_write = ' . $_REQUEST['new_delay_key_write']; }
if ( ( $l_tbl_type === 'myisam' || $l_tbl_type === 'innodb' ) && ! empty( $_REQUEST['new_auto_increment'] ) && ( ! isset( $auto_increment ) || $_REQUEST['new_auto_increment'] !== $auto_increment ) ) { $table_alters[] = 'auto_increment = ' . PMA_sqlAddslashes($_REQUEST['new_auto_increment']); }
if ( count($table_alters) > 0 ) { $sql_query = 'ALTER TABLE ' . PMA_backquote($GLOBALS['table']); $sql_query .= "\r\n" . implode("\r\n", $table_alters); $message = PMA_DBI_query($sql_query) ? $strSuccess : $strError; $reread_info = true; unset( $table_alters ); } } /** * Reordering the table has been requested by the user */ if ( isset( $_REQUEST['submitorderby'] ) && ! empty( $_REQUEST['order_field'] ) ) { $sql_query = ' ALTER TABLE ' . PMA_backquote($GLOBALS['table']) . ' ORDER BY ' . PMA_backquote(urldecode($_REQUEST['order_field'])); if ( isset( $_REQUEST['order_order'] ) && $_REQUEST['order_order'] === 'desc' ) { $sql_query .= ' DESC'; } $message = PMA_DBI_query($sql_query) ? $strSuccess : $strError; } // end if
if ( $reread_info ) { $pack_keys = $checksum = $delay_key_write = 0; require('./libraries/tbl_properties_table_info.inc.php'); } unset( $reread_info );
/** * Displays top menu links */ require_once('./libraries/tbl_properties_links.inc.php');
$url_params['goto'] = 'tbl_properties_operations.php'; $url_params['back'] = 'tbl_properties_operations.php';
/** * Get columns names */ $local_query = ' SHOW COLUMNS FROM ' . PMA_backquote($GLOBALS['table']) . ' FROM ' . PMA_backquote($GLOBALS['db']); $columns = PMA_DBI_fetch_result($local_query, null, 'Field'); unset( $local_query );
/** * Displays the page */ ?> <!-- Order the table --> <div id="div_table_order"> <form method="post" action="tbl_properties_operations.php"> <?php echo PMA_generate_common_hidden_inputs($GLOBALS['db'], $GLOBALS['table']); ?> <fieldset id="fieldset_table_order"> <legend><?php echo $strAlterOrderBy; ?></legend> <select name="order_field"> <?php foreach ( $columns as $fieldname ) { echo ' <option value="' . htmlspecialchars($fieldname) . '">' . htmlspecialchars($fieldname) . '</option>' . "\n"; } unset($columns); ?> </select> <?php echo $strSingly; ?> <select name="order_order"> <option value="asc"><?php echo $strAscending; ?></option> <option value="desc"><?php echo $strDescending; ?></option> </select> <input type="submit" name="submitorderby" value="<?php echo $strGo; ?>" /> </fieldset> </form> </div>
<!-- Move table --> <div id="div_table_rename"> <form method="post" action="tbl_move_copy.php" onsubmit="return emptyFormElements(this, 'new_name')"> <?php echo PMA_generate_common_hidden_inputs($GLOBALS['db'], $GLOBALS['table']); ?> <input type="hidden" name="reload" value="1" /> <input type="hidden" name="what" value="data" /> <fieldset id="fieldset_table_rename"> <legend><?php echo $strMoveTable; ?></legend> <select name="target_db"> <?php // The function used below is defined in "common.lib.php" PMA_availableDatabases('main.php?' . PMA_generate_common_url()); foreach ( $dblist as $each_db ) { echo ' '; echo '<option value="' . htmlspecialchars($each_db) . '">' . htmlspecialchars($each_db) . '</option>'; echo "\n"; } // end foreach $dblist ?> </select> <b>.</b> <input type="text" size="20" name="new_name" onfocus="this.select()" value="<?php echo htmlspecialchars($GLOBALS['table']); ?>" /> <input type="submit" name="submit_move" value="<?php echo $strGo; ?>" /> </fieldset> </form> </div>
<?php if (strstr($show_comment, '; InnoDB free') === false) { if (strstr($show_comment, 'InnoDB free') === false) { // only user entered comment $comment = $show_comment; } else { // here we have just InnoDB generated part $comment = ''; } } else { // remove InnoDB comment from end, just the minimal part (*? is non greedy) $comment = preg_replace('@; InnoDB free:.*?$@', '', $show_comment); }
// PACK_KEYS: MyISAM or ISAM // DELAY_KEY_WRITE, CHECKSUM, : MyISAM only // AUTO_INCREMENT: MyISAM and InnoDB since 5.0.3
// nijel: Here should be version check for InnoDB, however it is supported // in >5.0.4, >4.1.12 and >4.0.11, so I decided not to // check for version ?>
<!-- Table options --> <div id="div_table_options"> <form method="post" action="tbl_properties_operations.php"> <?php echo PMA_generate_common_hidden_inputs($GLOBALS['db'], $GLOBALS['table']); ?> <input type="hidden" name="reload" value="1" /> <fieldset> <legend><?php echo $strTableOptions; ?></legend>
<table> <!-- Change table name --> <tr><td><?php echo $strRenameTable; ?></td> <td><input type="text" size="20" name="new_name" onfocus="this.select()" value="<?php echo htmlspecialchars($GLOBALS['table']); ?>" /> </td> </tr>
<!-- Table comments --> <tr><td><?php echo $strTableComments; ?></td> <td><input type="text" name="comment" maxlength="60" size="30" value="<?php echo htmlspecialchars($comment); ?>" onfocus="this.select()" /> <input type="hidden" name="prev_comment" value="<?php echo urlencode($comment); ?>" /> </td> </tr>
<!-- Storage engine --> <tr><td><?php echo $strStorageEngine; ?> <?php echo PMA_showMySQLDocu('Storage_engines', 'Storage_engines'); ?> </td> <td><?php echo PMA_generateEnginesDropdown('new_tbl_type', null, false, $tbl_type, 4); ?> </td> </tr>
<?php if (PMA_MYSQL_INT_VERSION >= 40100) { ?> <!-- Table character set --> <tr><td><?php echo $strCollation; ?></td> <td><?php echo PMA_generateCharsetDropdownBox(PMA_CSDROPDOWN_COLLATION, 'tbl_collation', null, $tbl_collation, false, 3); ?> </td> </tr> <?php } if ($tbl_type == 'MYISAM' || $tbl_type == 'ISAM') { ?> <tr> <td><label for="new_pack_keys">pack_keys</label></td> <td><input type="checkbox" name="new_pack_keys" id="new_pack_keys" value="1" <?php echo (isset($pack_keys) && $pack_keys == 1) ? ' checked="checked"' : ''; ?> /> </td> </tr> <?php } // end if (MYISAM|ISAM)
if ($tbl_type == 'MYISAM') { ?> <tr><td><label for="new_checksum">checksum</label></td> <td><input type="checkbox" name="new_checksum" id="new_checksum" value="1" <?php echo (isset($checksum) && $checksum == 1) ? ' checked="checked"' : ''; ?> /> </td> </tr>
<tr><td><label for="new_delay_key_write">delay_key_write</label></td> <td><input type="checkbox" name="new_delay_key_write" id="new_delay_key_write" value="1" <?php echo (isset($delay_key_write) && $delay_key_write == 1) ? ' checked="checked"' : ''; ?> /> </td> </tr>
<?php } // end if (MYISAM)
if ( isset( $auto_increment ) && strlen($auto_increment) > 0 && ( $tbl_type == 'MYISAM' || $tbl_type == 'INNODB' ) ) { ?> <tr><td><label for="auto_increment_opt">auto_increment</label></td> <td><input type="text" name="new_auto_increment" id="auto_increment_opt" value="<?php echo $auto_increment; ?>" /></td> </tr> <?php } // end if (MYISAM|INNODB) ?> </table> </fieldset> <fieldset class="tblFooters"> <input type="submit" name="submitoptions" value="<?php echo $strGo; ?>" /> </fieldset> </form> </div>
<!-- Copy table --> <div id="div_table_copy"> <form method="post" action="tbl_move_copy.php" onsubmit="return emptyFormElements(this, 'new_name')"> <?php echo PMA_generate_common_hidden_inputs($GLOBALS['db'], $GLOBALS['table']); ?> <input type="hidden" name="reload" value="1" /> <fieldset> <legend><?php echo $strCopyTable; ?></legend> <select name="target_db"> <?php foreach ( $dblist as $each_db ) { echo ' '; echo '<option value="' . htmlspecialchars($each_db) . '"'; if ( $each_db === $GLOBALS['db'] ) { echo ' selected="selected"'; } echo '>' . htmlspecialchars($each_db) . '</option>'; echo "\n"; } // end foreach $dblist ?> </select> <b>.</b> <input type="text" size="20" name="new_name" onfocus="this.select()" /><br />
<input type="radio" name="what" value="structure" id="radio_copy_structure" /> <label for="radio_copy_structure"><?php echo $strStrucOnly; ?></label><br /> <input type="radio" name="what" value="data" id="radio_copy_data" checked="checked" /> <label for="radio_copy_data"><?php echo $strStrucData; ?></label><br /> <input type="radio" name="what" value="dataonly" id="radio_copy_dataonly" /> <label for="radio_copy_dataonly"><?php echo $strDataOnly; ?></label><br />
<input type="checkbox" name="drop_if_exists" value="true" id="checkbox_drop" /> <label for="checkbox_drop"><?php echo $strStrucDrop; ?></label><br /> <input type="checkbox" name="sql_auto_increment" value="1" id="checkbox_auto_increment" /> <label for="checkbox_auto_increment"><?php echo $strAddAutoIncrement; ?></label><br /> <?php // display "Add constraints" choice only if there are // foreign keys if (PMA_getForeigners($GLOBALS['db'], $GLOBALS['table'], '', 'innodb')) { ?> <input type="checkbox" name="constraints" value="1" id="checkbox_constraints" /> <label for="checkbox_constraints"><?php echo $strAddConstraints; ?></label><br /> <?php } // endif if ( isset( $_COOKIE['pma_switch_to_new'] ) && $_COOKIE['pma_switch_to_new'] == 'true' ) { $pma_switch_to_new = 'true'; } ?> <input type="checkbox" name="switch_to_new" value="true" id="checkbox_switch"<?php echo isset( $pma_switch_to_new ) && $pma_switch_to_new == 'true' ? ' checked="checked"' : ''; ?> /> <label for="checkbox_switch"><?php echo $strSwitchToTable; ?></label> </fieldset> <fieldset class="tblFooters"> <input type="submit" name="submit_copy" value="<?php echo $strGo; ?>" /> </fieldset> </form> </div>
<br class="clearfloat"/>
<h1><?php echo $strTableMaintenance; ?></h1>
<ul> <?php if ( $tbl_type == 'MYISAM' || $tbl_type == 'BERKELEYDB' || $tbl_type == 'INNODB' ) { if ( $tbl_type == 'MYISAM' || $tbl_type == 'INNODB' ) { $this_url_params = array_merge($url_params, array( 'sql_query' => 'CHECK TABLE ' . PMA_backquote($GLOBALS['table']) )); ?> <li><a href="sql.php<?php echo PMA_generate_common_url( $this_url_params ); ?>"> <?php echo $strCheckTable; ?></a> <?php echo PMA_showMySQLDocu('MySQL_Database_Administration', 'CHECK_TABLE'); ?> </li> <?php } if ($tbl_type == 'INNODB') { $this_url_params = array_merge($url_params, array( 'sql_query' => 'ALTER TABLE ' . PMA_backquote($GLOBALS['table']) . ' ' . PMA_ENGINE_KEYWORD . '=InnoDB' )); ?> <li><a href="sql.php<?php echo PMA_generate_common_url( $this_url_params ); ?>"> <?php echo $strDefragment; ?></a> <?php echo PMA_showMySQLDocu('Table_types', 'InnoDB_File_Defragmenting'); ?> </li> <?php } if ($tbl_type == 'MYISAM' || $tbl_type == 'BERKELEYDB') { $this_url_params = array_merge($url_params, array( 'sql_query' => 'ANALYZE TABLE ' . PMA_backquote($GLOBALS['table']) )); ?> <li><a href="sql.php<?php echo PMA_generate_common_url( $this_url_params ); ?>"> <?php echo $strAnalyzeTable; ?></a> <?php echo PMA_showMySQLDocu('MySQL_Database_Administration', 'ANALYZE_TABLE');?> </li> <?php } if ($tbl_type == 'MYISAM') { $this_url_params = array_merge($url_params, array( 'sql_query' => 'REPAIR TABLE ' . PMA_backquote($GLOBALS['table']) )); ?> <li><a href="sql.php<?php echo PMA_generate_common_url( $this_url_params ); ?>"> <?php echo $strRepairTable; ?></a> <?php echo PMA_showMySQLDocu('MySQL_Database_Administration', 'REPAIR_TABLE'); ?> </li> <?php } if ($tbl_type == 'MYISAM' || $tbl_type == 'BERKELEYDB') { $this_url_params = array_merge($url_params, array( 'sql_query' => 'OPTIMIZE TABLE ' . PMA_backquote($GLOBALS['table']) )); ?> <li><a href="sql.php<?php echo PMA_generate_common_url( $this_url_params ); ?>"> <?php echo $strOptimizeTable; ?></a> <?php echo PMA_showMySQLDocu('MySQL_Database_Administration', 'OPTIMIZE_TABLE'); ?> </li> <?php } } // end MYISAM or BERKELEYDB case $this_url_params = array_merge($url_params, array( 'sql_query' => 'FLUSH TABLE ' . PMA_backquote($GLOBALS['table']), 'zero_rows' => sprintf($strTableHasBeenFlushed, htmlspecialchars($GLOBALS['table'])), 'reload' => 1, )); ?> <li><a href="sql.php<?php echo PMA_generate_common_url( $this_url_params ); ?>"> <?php echo $strFlushTable; ?></a> <?php echo PMA_showMySQLDocu('MySQL_Database_Administration', 'FLUSH'); ?> </li> </ul> <?php // Referential integrity check // The Referential integrity check was intended for the non-InnoDB // tables for which the relations are defined in pmadb // so I assume that if the current table is InnoDB, I don't display // this choice (InnoDB maintains integrity by itself)
if ( $cfgRelation['relwork'] && $tbl_type != "INNODB" ) {
// we need this PMA_DBI_select_db if the user has access to more than one db // and $GLOBALS['db'] is not the last of the list, because PMA_availableDatabases() // has made a PMA_DBI_select_db() on the last one PMA_DBI_select_db($GLOBALS['db']); $foreign = PMA_getForeigners($GLOBALS['db'], $GLOBALS['table']);
if ($foreign) { ?> <!-- Referential integrity check --> <ul> <?php echo $strReferentialIntegrity; ?><br /> <?php echo "\n"; foreach ($foreign AS $master => $arr) { $join_query = 'SELECT ' . PMA_backquote($GLOBALS['table']) . '.* FROM ' . PMA_backquote($GLOBALS['table']) . ' LEFT JOIN ' . PMA_backquote($arr['foreign_table']); if ($arr['foreign_table'] == $GLOBALS['table']) { $foreign_table = $GLOBALS['table'] . '1'; $join_query .= ' AS ' . PMA_backquote($foreign_table); } else { $foreign_table = $arr['foreign_table']; } $join_query .= ' ON ' . PMA_backquote($GLOBALS['table']) . '.' . PMA_backquote($master) . ' = ' . PMA_backquote($foreign_table) . '.' . PMA_backquote($arr['foreign_field']) . ' WHERE ' . PMA_backquote($foreign_table) . '.' . PMA_backquote($arr['foreign_field']) . ' IS NULL AND ' . PMA_backquote($GLOBALS['table']) . '.' . PMA_backquote($master) . ' IS NOT NULL'; $this_url_params = array_merge($url_params, array( 'sql_query' => $join_query )); echo ' <li>' . '<a href="sql.php' . PMA_generate_common_url( $this_url_params ) . '">' . $master . ' -> ' . $arr['foreign_table'] . '.' . $arr['foreign_field'] . '</a></li>' . "\n"; } // foreach $foreign unset($foreign_table, $join_query); ?> </ul> <?php } // end if ($result)
} // end if (!empty($cfg['Server']['relation']))
/** * Displays the footer */ require_once('./libraries/footer.inc.php'); ?>
|