Управление сайтом

Файловый менеджер

Имя файла	tbl_operations.php
Содержимое	<?php /* vim: set expandtab sw=4 ts=4 sts=4: / /* * * @package PhpMyAdmin / /* * / require_once './libraries/common.inc.php'; $pma_table = new PMA_Table($GLOBALS['table'], $GLOBALS['db']); /* * Runs common work / require './libraries/tbl_common.php'; $url_query .= '&goto=tbl_operations.php&back=tbl_operations.php'; $url_params['goto'] = $url_params['back'] = 'tbl_operations.php'; /* * Gets relation settings / $cfgRelation = PMA_getRelationsParam(); /* * Gets available MySQL charsets and storage engines / require_once './libraries/mysql_charsets.lib.php'; require_once './libraries/StorageEngine.class.php'; // add a javascript file for jQuery functions to handle Ajax actions // also add jQueryUI $GLOBALS['js_include'][] = 'jquery/jquery-ui-1.8.16.custom.js'; /* * Class for partition management / require_once './libraries/Partition.class.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 './libraries/tbl_info.inc.php'; // define some globals here, for improved syntax in the conditionals $is_myisam_or_aria = $is_isam = $is_innodb = $is_berkeleydb = $is_aria = $is_pbxt = false; // set initial value of these globals, based on the current table engine PMA_set_global_variables_for_engine($tbl_type); if ($is_aria) { // the value for transactional can be implicit // (no create option found, in this case it means 1) // or explicit (option found with a value of 0 or 1) // ($transactional may have been set by libraries/tbl_info.inc.php, // from the $create_options) $transactional = (isset($transactional) && $transactional == '0') ? '0' : '1'; $page_checksum = (isset($page_checksum)) ? $page_checksum : ''; } $reread_info = false; $table_alters = array(); /* * If the table has to be moved to some other database / if (isset($_REQUEST['submit_move']) \|\| isset($_REQUEST['submit_copy'])) { $_message = ''; include_once './tbl_move_copy.php'; } /* * If the table has to be maintained / if (isset($_REQUEST['table_maintenance'])) { include_once './sql.php'; unset($result); } /* * Updates table comment, type and options if required / if (isset($_REQUEST['submitoptions'])) { $_message = ''; $warning_messages = array(); if (isset($_REQUEST['new_name'])) { if ($pma_table->rename($_REQUEST['new_name'])) { $_message .= $pma_table->getLastMessage(); $result = true; $GLOBALS['table'] = $pma_table->getName(); $reread_info = true; $reload = true; } else { $_message .= $pma_table->getLastError(); $result = false; } } 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[] = 'ENGINE = ' . $_REQUEST['new_tbl_type']; $tbl_type = $_REQUEST['new_tbl_type']; // reset the globals for the new engine PMA_set_global_variables_for_engine($tbl_type); if ($is_aria) { $transactional = (isset($transactional) && $transactional == '0') ? '0' : '1'; $page_checksum = (isset($page_checksum)) ? $page_checksum : ''; } } if (! empty($_REQUEST['tbl_collation']) && $_REQUEST['tbl_collation'] !== $tbl_collation) { $table_alters[] = 'DEFAULT ' . PMA_generateCharsetQueryPart($_REQUEST['tbl_collation']); } if (($is_myisam_or_aria \|\| $is_isam) && isset($_REQUEST['new_pack_keys']) && $_REQUEST['new_pack_keys'] != (string)$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 ($is_myisam_or_aria && $_REQUEST['new_checksum'] !== $checksum) { $table_alters[] = 'checksum = ' . $_REQUEST['new_checksum']; } $_REQUEST['new_transactional'] = empty($_REQUEST['new_transactional']) ? '0' : '1'; if ($is_aria && $_REQUEST['new_transactional'] !== $transactional) { $table_alters[] = 'TRANSACTIONAL = ' . $_REQUEST['new_transactional']; } $_REQUEST['new_page_checksum'] = empty($_REQUEST['new_page_checksum']) ? '0' : '1'; if ($is_aria && $_REQUEST['new_page_checksum'] !== $page_checksum) { $table_alters[] = 'PAGE_CHECKSUM = ' . $_REQUEST['new_page_checksum']; } $delay_key_write = empty($delay_key_write) ? '0' : '1'; $_REQUEST['new_delay_key_write'] = empty($_REQUEST['new_delay_key_write']) ? '0' : '1'; if ($is_myisam_or_aria && $_REQUEST['new_delay_key_write'] !== $delay_key_write) { $table_alters[] = 'delay_key_write = ' . $_REQUEST['new_delay_key_write']; } if (($is_myisam_or_aria \|\| $is_innodb \|\| $is_pbxt) && ! 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 (($is_myisam_or_aria \|\| $is_innodb \|\| $is_pbxt) && ! empty($_REQUEST['new_row_format']) && (! isset($row_format) \|\| strtolower($_REQUEST['new_row_format']) !== strtolower($row_format))) { $table_alters[] = 'ROW_FORMAT = ' . PMA_sqlAddSlashes($_REQUEST['new_row_format']); } if (count($table_alters) > 0) { $sql_query = 'ALTER TABLE ' . PMA_backquote($GLOBALS['table']); $sql_query .= "\r\n" . implode("\r\n", $table_alters); $result .= PMA_DBI_query($sql_query) ? true : false; $reread_info = true; unset($table_alters); foreach (PMA_DBI_get_warnings() as $warning) { // In MariaDB 5.1.44, when altering a table from Maria to MyISAM // and if TRANSACTIONAL was set, the system reports an error; // I discussed with a Maria developer and he agrees that this // should not be reported with a Level of Error, so here // I just ignore it. But there are other 1478 messages // that it's better to show. if (! ($_REQUEST['new_tbl_type'] == 'MyISAM' && $warning['Code'] == '1478' && $warning['Level'] == 'Error')) { $warning_messages[] = $warning['Level'] . ': #' . $warning['Code'] . ' ' . $warning['Message']; } } } } /* * 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'; } $result = PMA_DBI_query($sql_query); } // end if /* * A partition operation has been requested by the user / if (isset($_REQUEST['submit_partition']) && ! empty($_REQUEST['partition_operation'])) { $sql_query = 'ALTER TABLE ' . PMA_backquote($GLOBALS['table']) . ' ' . $_REQUEST['partition_operation'] . ' PARTITION ' . $_REQUEST['partition_name']; $result = PMA_DBI_query($sql_query); } // end if if ($reread_info) { // to avoid showing the old value (for example the AUTO_INCREMENT) after // a change, clear the cache PMA_Table::$cache = array(); $page_checksum = $checksum = $delay_key_write = 0; include './libraries/tbl_info.inc.php'; } unset($reread_info); /* * Displays top menu links in non ajax requests / if (!isset($_REQUEST['ajax_request'])) { include_once './libraries/tbl_links.inc.php'; } if (isset($result) && empty($message_to_show)) { // set to success by default, because result set could be empty // (for example, a table rename) $_type = 'success'; if (empty($_message)) { $_message = $result ? $message = PMA_Message::success(__('Your SQL query has been executed successfully')) : PMA_Message::error(__('Error')); // $result should exist, regardless of $_message $_type = $result ? 'success' : 'error'; if ( $_REQUEST['ajax_request'] == true) { $extra_data['sql_query'] = PMA_showMessage(null, $sql_query); PMA_ajaxResponse($_message, $_message->isSuccess(), $extra_data); } } if (! empty($warning_messages)) { $_message = new PMA_Message; $_message->addMessages($warning_messages); $_message->isError(true); if ( $_REQUEST['ajax_request'] == true) { PMA_ajaxResponse($_message, false); } unset($warning_messages); } PMA_showMessage($_message, $sql_query, $_type); unset($_message, $_type); } $url_params['goto'] = 'tbl_operations.php'; $url_params['back'] = 'tbl_operations.php'; /* * Get columns names / $columns = PMA_DBI_get_columns($GLOBALS['db'], $GLOBALS['table']); /* * Displays the page / ?> <!-- Order the table --> <div class="operations_half_width"> <form method="post" id="alterTableOrderby" action="tbl_operations.php" <?php echo ($GLOBALS['cfg']['AjaxEnable'] ? ' class="ajax"' : '');?>> <?php echo PMA_generate_common_hidden_inputs($GLOBALS['db'], $GLOBALS['table']); ?> <fieldset id="fieldset_table_order"> <legend><?php echo __('Alter table order by'); ?></legend> <select name="order_field"> <?php foreach ($columns as $fieldname) { echo ' <option value="' . htmlspecialchars($fieldname['Field']) . '">' . htmlspecialchars($fieldname['Field']) . '</option>' . "\n"; } unset($columns); ?> </select> <?php echo __('(singly)'); ?> <select name="order_order"> <option value="asc"><?php echo __('Ascending'); ?></option> <option value="desc"><?php echo __('Descending'); ?></option> </select> </fieldset> <fieldset class="tblFooters"> <input type="submit" name="submitorderby" value="<?php echo __('Go'); ?>" /> </fieldset> </form> </div> <!-- Move table --> <div class="operations_half_width"> <form method="post" action="tbl_operations.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 __('Move table to (database<b>.</b>table):'); ?></legend> <?php if (count($GLOBALS['pma']->databases) > $GLOBALS['cfg']['MaxDbList']) { ?> <input type="text" maxlength="100" size="30" name="target_db" value="<?php echo htmlspecialchars($GLOBALS['db']); ?>"/> <?php } else { ?> <select name="target_db"> <?php echo $GLOBALS['pma']->databases->getHtmlOptions(true, false); ?> </select> <?php } // end if ?>  <strong>.</strong>  <input type="text" size="20" name="new_name" onfocus="this.select()" value="<?php echo htmlspecialchars($GLOBALS['table']); ?>" /><br /> <?php // starting with MySQL 5.0.24, SHOW CREATE TABLE includes the AUTO_INCREMENT // next value but users can decide if they want it or not for the operation ?> <input type="checkbox" name="sql_auto_increment" value="1" id="checkbox_auto_increment_mv" checked="checked" /> <label for="checkbox_auto_increment_mv"><?php echo __('Add AUTO_INCREMENT value'); ?></label><br /> </fieldset> <fieldset class="tblFooters"> <input type="submit" name="submit_move" value="<?php echo __('Go'); ?>" /> </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, PBXT // 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 class="operations_half_width clearfloat"> <form method="post" action="tbl_operations.php"> <?php echo PMA_generate_common_hidden_inputs($GLOBALS['db'], $GLOBALS['table']); ?> <input type="hidden" name="reload" value="1" /> <fieldset> <legend><?php echo __('Table options'); ?></legend> <table> <!-- Change table name --> <tr><td><?php echo __('Rename table to'); ?></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 __('Table comments'); ?></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 htmlspecialchars($comment); ?>" /> </td> </tr> <!-- Storage engine --> <tr><td><?php echo __('Storage Engine'); ?> <?php echo PMA_showMySQLDocu('Storage_engines', 'Storage_engines'); ?> </td> <td><?php echo PMA_StorageEngine::getHtmlSelect('new_tbl_type', null, $tbl_type); ?> </td> </tr> <!-- Table character set --> <tr><td><?php echo __('Collation'); ?></td> <td><?php echo PMA_generateCharsetDropdownBox( PMA_CSDROPDOWN_COLLATION, 'tbl_collation', null, $tbl_collation, false, 3 ); ?> </td> </tr> <?php if ($is_myisam_or_aria \|\| $is_isam) { ?> <tr> <td><label for="new_pack_keys">PACK_KEYS</label></td> <td><select name="new_pack_keys" id="new_pack_keys"> <option value="DEFAULT" <?php if ($pack_keys == 'DEFAULT') echo 'selected="selected"'; ?> >DEFAULT</option> <option value="0" <?php if ($pack_keys == '0') echo 'selected="selected"'; ?> >0</option> <option value="1" <?php if ($pack_keys == '1') echo 'selected="selected"'; ?> >1</option> </select> </td> </tr> <?php } // end if (MYISAM\|ISAM) if ($is_myisam_or_aria) { ?> <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 ($is_aria) { ?> <tr><td><label for="new_transactional">TRANSACTIONAL</label></td> <td><input type="checkbox" name="new_transactional" id="new_transactional" value="1" <?php echo (isset($transactional) && $transactional == 1) ? ' checked="checked"' : ''; ?> /> </td> </tr> <tr><td><label for="new_page_checksum">PAGE_CHECKSUM</label></td> <td><input type="checkbox" name="new_page_checksum" id="new_page_checksum" value="1" <?php echo (isset($page_checksum) && $page_checksum == 1) ? ' checked="checked"' : ''; ?> /> </td> </tr> <?php } // end if (ARIA) if (isset($auto_increment) && strlen($auto_increment) > 0 && ($is_myisam_or_aria \|\| $is_innodb \|\| $is_pbxt)) { ?> <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) // the outer array is for engines, the inner array contains the dropdown // option values as keys then the dropdown option labels $possible_row_formats = array( 'ARIA' => array( 'FIXED' => 'FIXED', 'DYNAMIC' => 'DYNAMIC', 'PAGE' => 'PAGE' ), 'MARIA' => array( 'FIXED' => 'FIXED', 'DYNAMIC' => 'DYNAMIC', 'PAGE' => 'PAGE' ), 'MYISAM' => array( 'FIXED' => 'FIXED', 'DYNAMIC' => 'DYNAMIC' ), 'PBXT' => array( 'FIXED' => 'FIXED', 'DYNAMIC' => 'DYNAMIC' ), 'INNODB' => array( 'COMPACT' => 'COMPACT', 'REDUNDANT' => 'REDUNDANT') ); $innodb_engine_plugin = PMA_StorageEngine::getEngine('innodb'); $innodb_plugin_version = $innodb_engine_plugin->getInnodbPluginVersion(); if (!empty($innodb_plugin_version)) { $innodb_file_format = $innodb_engine_plugin->getInnodbFileFormat(); } else { $innodb_file_format = ''; } if ('Barracuda' == $innodb_file_format && $innodb_engine_plugin->supportsFilePerTable()) { $possible_row_formats['INNODB']['DYNAMIC'] = 'DYNAMIC'; $possible_row_formats['INNODB']['COMPRESSED'] = 'COMPRESSED'; } unset($innodb_engine_plugin, $innodb_plugin_version, $innodb_file_format); // for MYISAM there is also COMPRESSED but it can be set only by the // myisampack utility, so don't offer here the choice because if we // try it inside an ALTER TABLE, MySQL (at least in 5.1.23-maria) // does not return a warning // (if the table was compressed, it can be seen on the Structure page) if (isset($possible_row_formats[$tbl_type])) { $current_row_format = strtoupper($showtable['Row_format']); echo '<tr><td><label for="new_row_format">ROW_FORMAT</label></td>'; echo '<td>'; echo PMA_generate_html_dropdown('new_row_format', $possible_row_formats[$tbl_type], $current_row_format, 'new_row_format'); unset($possible_row_formats, $current_row_format); echo '</td>'; echo '</tr>'; } ?> </table> </fieldset> <fieldset class="tblFooters"> <input type="submit" name="submitoptions" value="<?php echo __('Go'); ?>" /> </fieldset> </form> </div> <!-- Copy table --> <div class="operations_half_width"> <form method="post" action="tbl_operations.php" name="copyTable" id="copyTable" <?php echo ($GLOBALS['cfg']['AjaxEnable'] ? ' class="ajax"' : '');?> 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 __('Copy table to (database<b>.</b>table):'); ?></legend> <?php if (count($GLOBALS['pma']->databases) > $GLOBALS['cfg']['MaxDbList']) { ?> <input type="text" maxlength="100" size="30" name="target_db" value="<?php echo htmlspecialchars($GLOBALS['db']); ?>"/> <?php } else { ?> <select name="target_db"> <?php echo $GLOBALS['pma']->databases->getHtmlOptions(true, false); ?> </select> <?php } // end if ?>  <strong>.</strong>  <input type="text" size="20" name="new_name" onfocus="this.select()" value="<?php echo htmlspecialchars($GLOBALS['table']); ?>"/><br /> <?php $choices = array( 'structure' => __('Structure only'), 'data' => __('Structure and data'), 'dataonly' => __('Data only')); PMA_display_html_radio('what', $choices, 'data', true); unset($choices); ?> <input type="checkbox" name="drop_if_exists" value="true" id="checkbox_drop" /> <label for="checkbox_drop"><?php echo sprintf(__('Add %s'), 'DROP TABLE'); ?></label><br /> <input type="checkbox" name="sql_auto_increment" value="1" id="checkbox_auto_increment_cp" /> <label for="checkbox_auto_increment_cp"><?php echo __('Add AUTO_INCREMENT value'); ?></label><br /> <?php // display "Add constraints" choice only if there are // foreign keys if (PMA_getForeigners($GLOBALS['db'], $GLOBALS['table'], '', 'foreign')) { ?> <input type="checkbox" name="add_constraints" value="1" id="checkbox_constraints" /> <label for="checkbox_constraints"><?php echo __('Add constraints'); ?></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 __('Switch to copied table'); ?></label> </fieldset> <fieldset class="tblFooters"> <input type="submit" name="submit_copy" value="<?php echo __('Go'); ?>" /> </fieldset> </form> </div> <br class="clearfloat"/> <div class="operations_half_width"> <fieldset> <legend><?php echo __('Table maintenance'); ?></legend> <ul id="tbl_maintenance" <?php echo ($GLOBALS['cfg']['AjaxEnable'] ? ' class="ajax"' : '');?>> <?php // Note: BERKELEY (BDB) is no longer supported, starting with MySQL 5.1 if ($is_myisam_or_aria \|\| $is_innodb \|\| $is_berkeleydb) { if ($is_myisam_or_aria \|\| $is_innodb) { $this_url_params = array_merge( $url_params, array( 'sql_query' => 'CHECK TABLE ' . PMA_backquote($GLOBALS['table']), 'table_maintenance' => 'Go', ) ); ?> <li><a class='maintain_action' href="tbl_operations.php<?php echo PMA_generate_common_url($this_url_params); ?>"> <?php echo __('Check table'); ?></a> <?php echo PMA_showMySQLDocu('MySQL_Database_Administration', 'CHECK_TABLE'); ?> </li> <?php } if ($is_innodb) { $this_url_params = array_merge( $url_params, array('sql_query' => 'ALTER TABLE ' . PMA_backquote($GLOBALS['table']) . ' ENGINE = InnoDB') ); ?> <li><a class='maintain_action' href="sql.php<?php echo PMA_generate_common_url($this_url_params); ?>"> <?php echo __('Defragment table'); ?></a> <?php echo PMA_showMySQLDocu('Table_types', 'InnoDB_File_Defragmenting'); ?> </li> <?php } if ($is_myisam_or_aria \|\| $is_berkeleydb) { $this_url_params = array_merge( $url_params, array( 'sql_query' => 'ANALYZE TABLE ' . PMA_backquote($GLOBALS['table']), 'table_maintenance' => 'Go', ) ); ?> <li><a class='maintain_action' href="tbl_operations.php<?php echo PMA_generate_common_url($this_url_params); ?>"> <?php echo __('Analyze table'); ?></a> <?php echo PMA_showMySQLDocu('MySQL_Database_Administration', 'ANALYZE_TABLE');?> </li> <?php } if ($is_myisam_or_aria && !PMA_DRIZZLE) { $this_url_params = array_merge( $url_params, array( 'sql_query' => 'REPAIR TABLE ' . PMA_backquote($GLOBALS['table']), 'table_maintenance' => 'Go', ) ); ?> <li><a class='maintain_action' href="tbl_operations.php<?php echo PMA_generate_common_url($this_url_params); ?>"> <?php echo __('Repair table'); ?></a> <?php echo PMA_showMySQLDocu('MySQL_Database_Administration', 'REPAIR_TABLE'); ?> </li> <?php } if (($is_myisam_or_aria \|\| $is_innodb \|\| $is_berkeleydb) && !PMA_DRIZZLE) { $this_url_params = array_merge( $url_params, array( 'sql_query' => 'OPTIMIZE TABLE ' . PMA_backquote($GLOBALS['table']), 'table_maintenance' => 'Go', ) ); ?> <li><a class='maintain_action' href="tbl_operations.php<?php echo PMA_generate_common_url($this_url_params); ?>"> <?php echo __('Optimize table'); ?></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']), 'message_to_show' => sprintf( __('Table %s has been flushed'), htmlspecialchars($GLOBALS['table']) ), 'reload' => 1, ) ); ?> <li><a class='maintain_action' href="sql.php<?php echo PMA_generate_common_url($this_url_params); ?>"> <?php echo __('Flush the table (FLUSH)'); ?></a> <?php echo PMA_showMySQLDocu('MySQL_Database_Administration', 'FLUSH'); ?> </li> </ul> </fieldset> </div> <?php if (! (isset($db_is_information_schema) && $db_is_information_schema)) { ?> <div class="operations_half_width"> <fieldset class="caution"> <legend><?php echo __('Delete data or table'); ?></legend> <ul> <?php if (! $tbl_is_view && ! (isset($db_is_information_schema) && $db_is_information_schema)) { $this_sql_query = 'TRUNCATE TABLE ' . PMA_backquote($GLOBALS['table']); $this_url_params = array_merge( $url_params, array( 'sql_query' => $this_sql_query, 'goto' => 'tbl_structure.php', 'reload' => '1', 'message_to_show' => sprintf(__('Table %s has been emptied'), htmlspecialchars($table)), ) ); ?> <li><a href="sql.php<?php echo PMA_generate_common_url($this_url_params); ?>" <?php echo ($GLOBALS['cfg']['AjaxEnable'] ? 'id="truncate_tbl_anchor" class="ajax"' : ''); ?>> <?php echo __('Empty the table (TRUNCATE)'); ?></a> <?php echo PMA_showMySQLDocu('SQL-Syntax', 'TRUNCATE_TABLE'); ?> </li> <?php } if (! (isset($db_is_information_schema) && $db_is_information_schema)) { $this_sql_query = 'DROP TABLE ' . PMA_backquote($GLOBALS['table']); $this_url_params = array_merge( $url_params, array( 'sql_query' => $this_sql_query, 'goto' => 'db_operations.php', 'reload' => '1', 'purge' => '1', 'message_to_show' => sprintf(($tbl_is_view ? __('View %s has been dropped') : __('Table %s has been dropped')), htmlspecialchars($table)), // table name is needed to avoid running // PMA_relationsCleanupDatabase() on the whole db later 'table' => $GLOBALS['table'], ) ); ?> <li><a href="sql.php<?php echo PMA_generate_common_url($this_url_params); ?>" <?php echo ($GLOBALS['cfg']['AjaxEnable'] ? 'id="drop_tbl_anchor"' : ''); ?>> <?php echo __('Delete the table (DROP)'); ?></a> <?php echo PMA_showMySQLDocu('SQL-Syntax', 'DROP_TABLE'); ?> </li> <?php } ?> </ul> </fieldset> </div> <?php } ?> <br class="clearfloat"> <?php if (PMA_Partition::havePartitioning()) { $partition_names = PMA_Partition::getPartitionNames($db, $table); // show the Partition maintenance section only if we detect a partition if (! is_null($partition_names[0])) { ?> <div class="operations_half_width"> <form method="post" action="tbl_operations.php"> <?php echo PMA_generate_common_hidden_inputs($GLOBALS['db'], $GLOBALS['table']); ?> <fieldset> <legend><?php echo __('Partition maintenance'); ?></legend> <?php $html_select = '<select name="partition_name">' . "\n"; foreach ($partition_names as $one_partition) { $one_partition = htmlspecialchars($one_partition); $html_select .= '<option value="' . $one_partition . '">' . $one_partition . '</option>' . "\n"; } $html_select .= '</select>' . "\n"; printf(__('Partition %s'), $html_select); unset($partition_names, $one_partition, $html_select); $choices = array( 'ANALYZE' => __('Analyze'), 'CHECK' => __('Check'), 'OPTIMIZE' => __('Optimize'), 'REBUILD' => __('Rebuild'), 'REPAIR' => __('Repair')); PMA_display_html_radio('partition_operation', $choices, '', false); unset($choices); echo PMA_showMySQLDocu('partitioning_maintenance', 'partitioning_maintenance'); // I'm not sure of the best way to display that; this link does // not depend on the Go button $this_url_params = array_merge( $url_params, array( 'sql_query' => 'ALTER TABLE ' . PMA_backquote($GLOBALS['table']) . ' REMOVE PARTITIONING' ) ); ?> <br /><a href="sql.php<?php echo PMA_generate_common_url($this_url_params); ?>"> <?php echo __('Remove partitioning'); ?></a> </fieldset> <fieldset class="tblFooters"> <input type="submit" name="submit_partition" value="<?php echo __('Go'); ?>" /> </fieldset> </form> </div> <?php } // end if } // end if // 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'] && ! $is_innodb) { PMA_DBI_select_db($GLOBALS['db']); $foreign = PMA_getForeigners($GLOBALS['db'], $GLOBALS['table']); if ($foreign) { ?> <!-- Referential integrity check --> <div class="operations_half_width"> <fieldset> <legend><?php echo __('Check referential integrity:'); ?></legend> <ul> <?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> </fieldset> </div> <?php } // end if ($foreign) } // end if (!empty($cfg['Server']['relation'])) /** * Displays the footer */ require './libraries/footer.inc.php'; function PMA_set_global_variables_for_engine($tbl_type) { global $is_myisam_or_aria, $is_innodb, $is_isam, $is_berkeleydb, $is_aria, $is_pbxt; $is_myisam_or_aria = $is_isam = $is_innodb = $is_berkeleydb = $is_aria = $is_pbxt = false; $upper_tbl_type = strtoupper($tbl_type); //Options that apply to MYISAM usually apply to ARIA $is_myisam_or_aria = ($upper_tbl_type == 'MYISAM' \|\| $upper_tbl_type == 'ARIA' \|\| $upper_tbl_type == 'MARIA'); $is_aria = ($upper_tbl_type == 'ARIA'); $is_isam = ($upper_tbl_type == 'ISAM'); $is_innodb = ($upper_tbl_type == 'INNODB'); $is_berkeleydb = ($upper_tbl_type == 'BERKELEYDB'); $is_pbxt = ($upper_tbl_type == 'PBXT'); } ?>

/admin/phpmyadmin/

Имя	Дата	Размер
..	2026-10-02
examples	2013-04-27
js	2013-04-27
libraries	2015-04-04
locale	2013-04-27
setup	2013-04-27
themes	2013-04-27
ChangeLog	2012-10-10	27 кб.
Documentation.html	2012-10-10	252 кб.
Documentation.txt	2012-10-10	176 кб.
LICENSE	2012-10-10	18 кб.
README	2012-10-10	2 кб.
README.VENDOR	2012-10-10	1 кб.
RELEASE-DATE-3.5.2.2	2012-10-10	29 байт
browse_foreigners.php	2012-10-10	11 кб.
bs_disp_as_mime_type.php	2012-10-10	1 кб.
bs_play_media.php	2012-10-10	2 кб.
changelog.php	2012-10-10	4 кб.
chk_rel.php	2012-10-10	363 байт
config.inc.php	2012-10-10	374 байт
config.inc.php.sample	2012-10-10	374 байт
config.sample.inc.php	2012-10-10	4 кб.
db_create.php	2012-10-10	4 кб.
db_datadict.php	2012-10-10	8 кб.
db_events.php	2012-10-10	773 байт
db_export.php	2012-10-10	3 кб.
db_import.php	2012-10-10	466 байт
db_operations.php	2012-10-10	22 кб.
db_printview.php	2012-10-10	7 кб.
db_qbe.php	2012-10-10	30 кб.
db_routines.php	2012-10-10	964 байт
db_search.php	2012-10-10	13 кб.
db_sql.php	2012-10-10	1 кб.
db_structure.php	2012-10-10	24 кб.
db_tracking.php	2012-10-10	8 кб.
db_triggers.php	2012-10-10	728 байт
docs.css	2012-10-10	3 кб.
enum_editor.php	2012-10-10	5 кб.
export.php	2012-10-10	28 кб.
favicon.ico	2012-10-10	18 кб.
file_echo.php	2012-10-10	2 кб.
gis_data_editor.php	2012-10-10	17 кб.
import.php	2012-10-10	17 кб.
import_status.php	2012-10-10	953 байт
index.php	2012-10-10	6 кб.
license.php	2012-10-10	730 байт
main.php	2012-10-10	17 кб.
navigation.php	2012-10-10	25 кб.
phpinfo.php	2012-10-10	349 байт
phpmyadmin.css.php	2012-10-10	1 кб.
pmd_display_field.php	2012-10-10	2 кб.
pmd_general.php	2012-10-10	35 кб.
pmd_pdf.php	2012-10-10	4 кб.
pmd_relation_new.php	2012-10-10	4 кб.
pmd_relation_upd.php	2012-10-10	2 кб.
pmd_save_pos.php	2012-10-10	2 кб.
prefs_forms.php	2012-10-10	3 кб.
prefs_manage.php	2012-10-10	14 кб.
print.css	2012-10-10	1 кб.
querywindow.php	2012-10-10	6 кб.
robots.txt	2012-10-10	26 байт
schema_edit.php	2012-10-10	4 кб.
schema_export.php	2012-10-10	1 кб.
server_binlog.php	2012-10-10	6 кб.
server_collations.php	2012-10-10	3 кб.
server_databases.php	2012-10-10	10 кб.
server_engines.php	2012-10-10	5 кб.
server_export.php	2012-10-10	2 кб.
server_import.php	2012-10-10	477 байт
server_plugins.php	2012-10-10	7 кб.
server_privileges.php	2012-10-10	107 кб.
server_replication.php	2012-10-10	17 кб.
server_sql.php	2012-10-10	743 байт
server_status.php	2012-10-10	76 кб.
server_synchronize.php	2012-10-10	56 кб.
server_variables.php	2012-10-10	6 кб.
show_config_errors.php	2012-10-10	574 байт
sql.php	2012-10-10	37 кб.
tbl_addfield.php	2012-10-10	8 кб.
tbl_alter.php	2012-10-10	7 кб.
tbl_change.php	2012-10-10	49 кб.
tbl_chart.php	2012-10-10	6 кб.
tbl_create.php	2012-10-10	14 кб.
tbl_export.php	2012-10-10	3 кб.
tbl_get_field.php	2012-10-10	1 кб.
tbl_gis_visualization.php	2012-10-10	7 кб.
tbl_import.php	2012-10-10	624 байт
tbl_indexes.php	2012-10-10	9 кб.
tbl_move_copy.php	2012-10-10	3 кб.
tbl_operations.php	2012-10-10	32 кб.
tbl_printview.php	2012-10-10	14 кб.
tbl_relation.php	2012-10-10	23 кб.
tbl_replace.php	2012-10-10	23 кб.
tbl_row_action.php	2012-10-10	5 кб.
tbl_select.php	2012-10-10	10 кб.
tbl_sql.php	2012-10-10	1 кб.
tbl_structure.php	2012-10-10	39 кб.
tbl_tracking.php	2012-10-10	28 кб.
tbl_triggers.php	2012-10-10	144 байт
tbl_zoom_select.php	2012-10-10	17 кб.
themes.php	2012-10-10	822 байт
transformation_overview.php	2012-10-10	2 кб.
transformation_wrapper.php	2012-10-10	3 кб.
url.php	2012-10-10	391 байт
user_password.php	2012-10-10	4 кб.
view_create.php	2012-10-10	5 кб.
view_operations.php	2012-10-10	3 кб.
webapp.php	2012-10-10	1 кб.

/admin/phpmyadmin