phpmyadmin/tbl_operations.php

   1 <?php
   2 /* vim: set expandtab sw=4 ts=4 sts=4: */
   3 /**
   4  * Various table operations
   5  *
   6  * @package PhpMyAdmin
   7  */
   8
   9 /**
  10  *
  11  */
  12 require_once 'libraries/common.inc.php';
  13
  14 /**
  15  * functions implementation for this script
  16  */
  17 require_once 'libraries/check_user_privileges.lib.php';
  18 require_once 'libraries/operations.lib.php';
  19
  20 $pma_table = new PMA_Table($GLOBALS['table'], $GLOBALS['db']);
  21
  22 /**
  23  * Load JavaScript files
  24  */
  25 $response = PMA_Response::getInstance();
  26 $header   = $response->getHeader();
  27 $scripts  = $header->getScripts();
  28 $scripts->addFile('functions.js');
  29 $scripts->addFile('tbl_operations.js');
  30
  31 /**
  32  * Runs common work
  33  */
  34 require 'libraries/tbl_common.inc.php';
  35 $url_query .= '&amp;goto=tbl_operations.php&amp;back=tbl_operations.php';
  36 $url_params['goto'] = $url_params['back'] = 'tbl_operations.php';
  37
  38 /**
  39  * Gets relation settings
  40  */
  41 $cfgRelation = PMA_getRelationsParam();
  42
  43 /**
  44  * Gets available MySQL charsets and storage engines
  45  */
  46 require_once 'libraries/mysql_charsets.inc.php';
  47 require_once 'libraries/StorageEngine.class.php';
  48
  49 /**
  50  * Class for partition management
  51  */
  52 require_once 'libraries/Partition.class.php';
  53
  54 // reselect current db (needed in some cases probably due to
  55 // the calling of relation.lib.php)
  56 $GLOBALS['dbi']->selectDb($GLOBALS['db']);
  57
  58 /**
  59  * Gets tables information
  60  */
  61 require 'libraries/tbl_info.inc.php';
  62
  63 // set initial value of these variables, based on the current table engine
  64 list($is_myisam_or_aria, $is_innodb, $is_isam,
  65     $is_berkeleydb, $is_aria, $is_pbxt
  66 ) = PMA_setGlobalVariablesForEngine($tbl_storage_engine);
  67
  68 if ($is_aria) {
  69     // the value for transactional can be implicit
  70     // (no create option found, in this case it means 1)
  71     // or explicit (option found with a value of 0 or 1)
  72     // ($transactional may have been set by libraries/tbl_info.inc.php,
  73     // from the $create_options)
  74     $transactional = (isset($transactional) && $transactional == '0')
  75         ? '0'
  76         : '1';
  77     $page_checksum = (isset($page_checksum)) ? $page_checksum : '';
  78 }
  79
  80 $reread_info = false;
  81 $table_alters = array();
  82
  83 /** @var PMA_String $pmaString */
  84 $pmaString = $GLOBALS['PMA_String'];
  85
  86 /**
  87  * If the table has to be moved to some other database
  88  */
  89 if (isset($_REQUEST['submit_move']) || isset($_REQUEST['submit_copy'])) {
  90     //$_message = '';
  91     PMA_moveOrCopyTable($db, $table);
  92     // This was ended in an Ajax call
  93     exit;
  94 }
  95 /**
  96  * If the table has to be maintained
  97  */
  98 if (isset($_REQUEST['table_maintenance'])) {
  99     include_once 'sql.php';
 100     unset($result);
 101 }
 102 /**
 103  * Updates table comment, type and options if required
 104  */
 105 if (isset($_REQUEST['submitoptions'])) {
 106     $_message = '';
 107     $warning_messages = array();
 108
 109     if (isset($_REQUEST['new_name'])) {
 110         // Get original names before rename operation
 111         $oldTable = $pma_table->getName();
 112         $oldDb = $pma_table->getDbName();
 113
 114         if ($pma_table->rename($_REQUEST['new_name'])) {
 115             if (isset($_REQUEST['adjust_privileges'])
 116                 && ! empty($_REQUEST['adjust_privileges'])
 117             ) {
 118                 PMA_AdjustPrivileges_renameOrMoveTable(
 119                     $oldDb, $oldTable, $_REQUEST['db'], $_REQUEST['new_name']
 120                 );
 121             }
 122
 123             // Reselect the original DB
 124             $GLOBALS['db'] = $oldDb;
 125             $GLOBALS['dbi']->selectDb($oldDb);
 126
 127             $_message .= $pma_table->getLastMessage();
 128             $result = true;
 129             $GLOBALS['table'] = $pma_table->getName();
 130             $reread_info = true;
 131             $reload = true;
 132         } else {
 133             $_message .= $pma_table->getLastError();
 134             $result = false;
 135         }
 136     }
 137
 138     if (! empty($_REQUEST['new_tbl_storage_engine'])
 139         && /*overload*/mb_strtolower($_REQUEST['new_tbl_storage_engine']) !== $tbl_storage_engine
 140     ) {
 141         $new_tbl_storage_engine = $_REQUEST['new_tbl_storage_engine'];
 142         // reset the globals for the new engine
 143         list($is_myisam_or_aria, $is_innodb, $is_isam,
 144             $is_berkeleydb, $is_aria, $is_pbxt
 145         ) = PMA_setGlobalVariablesForEngine($new_tbl_storage_engine);
 146
 147         if ($is_aria) {
 148             $transactional = (isset($transactional) && $transactional == '0')
 149                 ? '0'
 150                 : '1';
 151             $page_checksum = (isset($page_checksum)) ? $page_checksum : '';
 152         }
 153     } else {
 154         $new_tbl_storage_engine = '';
 155     }
 156
 157     $table_alters = PMA_getTableAltersArray(
 158         $is_myisam_or_aria, $is_isam, $pack_keys,
 159         (empty($checksum) ? '0' : '1'),
 160         $is_aria,
 161         ((isset($page_checksum)) ? $page_checksum : ''),
 162         (empty($delay_key_write) ? '0' : '1'),
 163         $is_innodb, $is_pbxt, $row_format,
 164         $new_tbl_storage_engine,
 165         ((isset($transactional) && $transactional == '0') ? '0' : '1'),
 166         $tbl_collation
 167     );
 168
 169     if (count($table_alters) > 0) {
 170         $sql_query      = 'ALTER TABLE '
 171             . PMA_Util::backquote($GLOBALS['table']);
 172         $sql_query     .= "\r\n" . implode("\r\n", $table_alters);
 173         $sql_query     .= ';';
 174         $result        .= $GLOBALS['dbi']->query($sql_query) ? true : false;
 175         $reread_info    = true;
 176         unset($table_alters);
 177         $warning_messages = PMA_getWarningMessagesArray();
 178     }
 179
 180     if (isset($_REQUEST['tbl_collation'])
 181         && ! empty($_REQUEST['tbl_collation'])
 182         && isset($_REQUEST['change_all_collations'])
 183         && ! empty($_REQUEST['change_all_collations'])
 184     ) {
 185         PMA_changeAllColumnsCollation(
 186             $GLOBALS['db'], $GLOBALS['table'], $_REQUEST['tbl_collation']
 187         );
 188     }
 189 }
 190 /**
 191  * Reordering the table has been requested by the user
 192  */
 193 if (isset($_REQUEST['submitorderby']) && ! empty($_REQUEST['order_field'])) {
 194     list($sql_query, $result) = PMA_getQueryAndResultForReorderingTable();
 195 } // end if
 196
 197 /**
 198  * A partition operation has been requested by the user
 199  */
 200 $sql_query = '';
 201
 202 if (isset($_REQUEST['submit_partition'])
 203     && ! empty($_REQUEST['partition_operation'])
 204 ) {
 205     list($sql_query, $result) = PMA_getQueryAndResultForPartition();
 206 } // end if
 207
 208 if ($reread_info) {
 209     // to avoid showing the old value (for example the AUTO_INCREMENT) after
 210     // a change, clear the cache
 211     $GLOBALS['dbi']->clearTableCache();
 212     $page_checksum = $checksum = $delay_key_write = 0;
 213     include 'libraries/tbl_info.inc.php';
 214 }
 215 unset($reread_info);
 216
 217 if (isset($result) && empty($message_to_show)) {
 218     // set to success by default, because result set could be empty
 219     // (for example, a table rename)
 220     $_type = 'success';
 221     if (empty($_message)) {
 222         $_message = $result
 223             ? PMA_Message::success(
 224                 __('Your SQL query has been executed successfully.')
 225             )
 226             : PMA_Message::error(__('Error'));
 227         // $result should exist, regardless of $_message
 228         $_type = $result ? 'success' : 'error';
 229
 230         if (isset($GLOBALS['ajax_request'])
 231             && $GLOBALS['ajax_request'] == true
 232         ) {
 233             $response = PMA_Response::getInstance();
 234             $response->isSuccess($_message->isSuccess());
 235             $response->addJSON('message', $_message);
 236             $response->addJSON(
 237                 'sql_query', PMA_Util::getMessage(null, $sql_query)
 238             );
 239             exit;
 240         }
 241     }
 242     if (! empty($warning_messages)) {
 243         $_message = new PMA_Message;
 244         $_message->addMessages($warning_messages);
 245         $_message->isError(true);
 246         if ($GLOBALS['ajax_request'] == true) {
 247             $response = PMA_Response::getInstance();
 248             $response->isSuccess(false);
 249             $response->addJSON('message', $_message);
 250             exit;
 251         }
 252         unset($warning_messages);
 253     }
 254
 255     $response->addHTML(
 256         PMA_Util::getMessage($_message, $sql_query, $_type)
 257     );
 258     unset($_message, $_type);
 259 }
 260
 261 $url_params['goto']
 262     = $url_params['back']
 263         = 'tbl_operations.php';
 264
 265 /**
 266  * Get columns names
 267  */
 268 $columns = $GLOBALS['dbi']->getColumns($GLOBALS['db'], $GLOBALS['table']);
 269
 270 /**
 271  * Displays the page
 272  */
 273 $response->addHTML('<div id="boxContainer" data-box-width="300">');
 274
 275 /**
 276  * Order the table
 277  */
 278 $hideOrderTable = false;
 279 // `ALTER TABLE ORDER BY` does not make sense for InnoDB tables that contain
 280 // a user-defined clustered index (PRIMARY KEY or NOT NULL UNIQUE index).
 281 // InnoDB always orders table rows according to such an index if one is present.
 282 if ($tbl_storage_engine == 'INNODB') {
 283     include_once 'libraries/Index.class.php';
 284     $indexes = PMA_Index::getFromTable($GLOBALS['table'], $GLOBALS['db']);
 285     foreach ($indexes as $name => $idx) {
 286         if ($name == 'PRIMARY') {
 287             $hideOrderTable = true;
 288             break;
 289         } elseif (! $idx->getNonUnique()) {
 290             $notNull = true;
 291             foreach ($idx->getColumns() as $column) {
 292                 if ($column->getNull()) {
 293                     $notNull = false;
 294                     break;
 295                 }
 296             }
 297             if ($notNull) {
 298                 $hideOrderTable = true;
 299                 break;
 300             }
 301         }
 302     }
 303 }
 304 if (! $hideOrderTable) {
 305     $response->addHTML(PMA_getHtmlForOrderTheTable($columns));
 306 }
 307
 308 /**
 309  * Move table
 310  */
 311 $response->addHTML(PMA_getHtmlForMoveTable());
 312
 313 if (/*overload*/mb_strstr($show_comment, '; InnoDB free') === false) {
 314     if (/*overload*/mb_strstr($show_comment, 'InnoDB free') === false) {
 315         // only user entered comment
 316         $comment = $show_comment;
 317     } else {
 318         // here we have just InnoDB generated part
 319         $comment = '';
 320     }
 321 } else {
 322     // remove InnoDB comment from end, just the minimal part (*? is non greedy)
 323     $comment = preg_replace('@; InnoDB free:.*?$@', '', $show_comment);
 324 }
 325
 326 // PACK_KEYS: MyISAM or ISAM
 327 // DELAY_KEY_WRITE, CHECKSUM, : MyISAM only
 328 // AUTO_INCREMENT: MyISAM and InnoDB since 5.0.3, PBXT
 329
 330 // Here should be version check for InnoDB, however it is supported
 331 // in >5.0.4, >4.1.12 and >4.0.11, so I decided not to
 332 // check for version
 333
 334 $response->addHTML(
 335     PMA_getTableOptionDiv(
 336         $comment, $tbl_collation, $tbl_storage_engine,
 337         $is_myisam_or_aria, $is_isam, $pack_keys,
 338         $auto_increment,
 339         (empty($delay_key_write) ? '0' : '1'),
 340         ((isset($transactional) && $transactional == '0') ? '0' : '1'),
 341         ((isset($page_checksum)) ? $page_checksum : ''),
 342         $is_innodb, $is_pbxt, $is_aria, (empty($checksum) ? '0' : '1')
 343     )
 344 );
 345
 346 /**
 347  * Copy table
 348  */
 349 $response->addHTML(PMA_getHtmlForCopytable());
 350
 351 /**
 352  * Table maintenance
 353  */
 354 $response->addHTML(
 355     PMA_getHtmlForTableMaintenance(
 356         $is_myisam_or_aria,
 357         $is_innodb,
 358         $is_berkeleydb,
 359         $url_params
 360     )
 361 );
 362
 363 if (! (isset($db_is_system_schema) && $db_is_system_schema)) {
 364     $truncate_table_url_params = array();
 365     $drop_table_url_params = array();
 366
 367     if (! $tbl_is_view
 368         && ! (isset($db_is_system_schema) && $db_is_system_schema)
 369     ) {
 370         $this_sql_query = 'TRUNCATE TABLE '
 371             . PMA_Util::backquote($GLOBALS['table']);
 372         $truncate_table_url_params = array_merge(
 373             $url_params,
 374             array(
 375                 'sql_query' => $this_sql_query,
 376                 'goto' => 'tbl_structure.php',
 377                 'reload' => '1',
 378                 'message_to_show' => sprintf(
 379                     __('Table %s has been emptied.'),
 380                     htmlspecialchars($table)
 381                 ),
 382             )
 383         );
 384     }
 385     if (! (isset($db_is_system_schema) && $db_is_system_schema)) {
 386         $this_sql_query = 'DROP TABLE '
 387             . PMA_Util::backquote($GLOBALS['table']);
 388         $drop_table_url_params = array_merge(
 389             $url_params,
 390             array(
 391                 'sql_query' => $this_sql_query,
 392                 'goto' => 'db_operations.php',
 393                 'reload' => '1',
 394                 'purge' => '1',
 395                 'message_to_show' => sprintf(
 396                     ($tbl_is_view
 397                         ? __('View %s has been dropped.')
 398                         : __('Table %s has been dropped.')
 399                     ),
 400                     htmlspecialchars($table)
 401                 ),
 402                 // table name is needed to avoid running
 403                 // PMA_relationsCleanupDatabase() on the whole db later
 404                 'table' => $GLOBALS['table'],
 405             )
 406         );
 407     }
 408     $response->addHTML(
 409         PMA_getHtmlForDeleteDataOrTable(
 410             $truncate_table_url_params,
 411             $drop_table_url_params
 412         )
 413     );
 414 }
 415
 416 if (PMA_Partition::havePartitioning()) {
 417     $partition_names = PMA_Partition::getPartitionNames($db, $table);
 418     // show the Partition maintenance section only if we detect a partition
 419     if (! is_null($partition_names[0])) {
 420         $response->addHTML(
 421             PMA_getHtmlForPartitionMaintenance($partition_names, $url_params)
 422         );
 423     } // end if
 424 } // end if
 425 unset($partition_names);
 426
 427 // Referential integrity check
 428 // The Referential integrity check was intended for the non-InnoDB
 429 // tables for which the relations are defined in pmadb
 430 // so I assume that if the current table is InnoDB, I don't display
 431 // this choice (InnoDB maintains integrity by itself)
 432
 433 if ($cfgRelation['relwork'] && ! $is_innodb) {
 434     $GLOBALS['dbi']->selectDb($GLOBALS['db']);
 435     $foreign = PMA_getForeigners($GLOBALS['db'], $GLOBALS['table'], '', 'internal');
 436
 437     if (! empty($foreign)) {
 438         $response->addHTML(
 439             PMA_getHtmlForReferentialIntegrityCheck($foreign, $url_params)
 440         );
 441     } // end if ($foreign)
 442
 443 } // end  if (!empty($cfg['Server']['relation']))
 444
 445 $response->addHTML('</div>');