tbl_operations.php

   1 <?php
   2 /* vim: set expandtab sw=4 ts=4 sts=4: */
   3 /**
   4  *
   5  * @version $Id$
   6  */
   7
   8 /**
   9  *
  10  */
  11 require_once './libraries/common.inc.php';
  12 require_once './libraries/Table.class.php';
  13
  14 $pma_table = new PMA_Table($GLOBALS['table'], $GLOBALS['db']);
  15
  16 /**
  17  * Runs common work
  18  */
  19 require './libraries/tbl_common.php';
  20 $url_query .= '&amp;goto=tbl_operations.php&amp;back=tbl_operations.php';
  21 $url_params['goto'] = $url_params['back'] = 'tbl_operations.php';
  22
  23 /**
  24  * Gets relation settings
  25  */
  26 require_once './libraries/relation.lib.php';
  27 $cfgRelation = PMA_getRelationsParam();
  28
  29 /**
  30  * Gets available MySQL charsets and storage engines
  31  */
  32 require_once './libraries/mysql_charsets.lib.php';
  33 require_once './libraries/StorageEngine.class.php';
  34
  35 /**
  36  * Class for partition management
  37  */
  38 require_once './libraries/Partition.class.php';
  39
  40 // reselect current db (needed in some cases probably due to
  41 // the calling of relation.lib.php)
  42 PMA_DBI_select_db($GLOBALS['db']);
  43
  44 /**
  45  * Gets tables informations
  46  */
  47
  48 require './libraries/tbl_info.inc.php';
  49
  50 $reread_info = false;
  51 $table_alters = array();
  52
  53 /**
  54  * Updates table comment, type and options if required
  55  */
  56 if (isset($_REQUEST['submitoptions'])) {
  57     $_message = '';
  58     if (isset($_REQUEST['new_name'])) {
  59         if ($pma_table->rename($_REQUEST['new_name'])) {
  60             $_message .= $pma_table->getLastMessage();
  61             $result = true;
  62             $GLOBALS['table'] = $pma_table->getName();
  63             $reread_info = true;
  64             $reload = true;
  65         } else {
  66             $_message .= $pma_table->getLastError();
  67             $result = false;
  68         }
  69     }
  70     if (isset($_REQUEST['comment'])
  71       && urldecode($_REQUEST['prev_comment']) !== $_REQUEST['comment']) {
  72         $table_alters[] = 'COMMENT = \'' . PMA_sqlAddslashes($_REQUEST['comment']) . '\'';
  73     }
  74     if (! empty($_REQUEST['new_tbl_type'])
  75       && strtolower($_REQUEST['new_tbl_type']) !== strtolower($tbl_type)) {
  76         $table_alters[] = 'ENGINE = ' . $_REQUEST['new_tbl_type'];
  77         $tbl_type = $_REQUEST['new_tbl_type'];
  78     }
  79
  80     if (! empty($_REQUEST['tbl_collation'])
  81       && $_REQUEST['tbl_collation'] !== $tbl_collation) {
  82         $table_alters[] = 'DEFAULT ' . PMA_generateCharsetQueryPart($_REQUEST['tbl_collation']);
  83     }
  84
  85     $l_tbl_type = strtolower($tbl_type);
  86
  87     if (($l_tbl_type === 'myisam' || $l_tbl_type === 'isam')
  88       && isset($_REQUEST['new_pack_keys'])
  89       && $_REQUEST['new_pack_keys'] != (string)$pack_keys) {
  90         $table_alters[] = 'pack_keys = ' . $_REQUEST['new_pack_keys'];
  91     }
  92
  93     $checksum = empty($checksum) ? '0' : '1';
  94     $_REQUEST['new_checksum'] = empty($_REQUEST['new_checksum']) ? '0' : '1';
  95     if (($l_tbl_type === 'myisam')
  96       && $_REQUEST['new_checksum'] !== $checksum) {
  97         $table_alters[] = 'checksum = ' . $_REQUEST['new_checksum'];
  98     }
  99
 100     $delay_key_write = empty($delay_key_write) ? '0' : '1';
 101     $_REQUEST['new_delay_key_write'] = empty($_REQUEST['new_delay_key_write']) ? '0' : '1';
 102     if (($l_tbl_type === 'myisam')
 103       && $_REQUEST['new_delay_key_write'] !== $delay_key_write) {
 104         $table_alters[] = 'delay_key_write = ' . $_REQUEST['new_delay_key_write'];
 105     }
 106
 107     if (($l_tbl_type === 'myisam' || $l_tbl_type === 'innodb')
 108       &&  ! empty($_REQUEST['new_auto_increment'])
 109       && (! isset($auto_increment) || $_REQUEST['new_auto_increment'] !== $auto_increment)) {
 110         $table_alters[] = 'auto_increment = ' . PMA_sqlAddslashes($_REQUEST['new_auto_increment']);
 111     }
 112
 113     if (count($table_alters) > 0) {
 114         $sql_query      = 'ALTER TABLE ' . PMA_backquote($GLOBALS['table']);
 115         $sql_query     .= "\r\n" . implode("\r\n", $table_alters);
 116         $result        .= PMA_DBI_query($sql_query) ? true : false;
 117         $reread_info    = true;
 118         unset($table_alters);
 119     }
 120 }
 121 /**
 122  * Reordering the table has been requested by the user
 123  */
 124 if (isset($_REQUEST['submitorderby']) && ! empty($_REQUEST['order_field'])) {
 125     $sql_query = '
 126         ALTER TABLE ' . PMA_backquote($GLOBALS['table']) . '
 127         ORDER BY ' . PMA_backquote(urldecode($_REQUEST['order_field']));
 128     if (isset($_REQUEST['order_order']) && $_REQUEST['order_order'] === 'desc') {
 129         $sql_query .= ' DESC';
 130     }
 131     $result = PMA_DBI_query($sql_query);
 132 } // end if
 133
 134 /**
 135  * A partition operation has been requested by the user
 136  */
 137 if (isset($_REQUEST['submit_partition']) && ! empty($_REQUEST['partition_operation'])) {
 138     $sql_query = 'ALTER TABLE ' . PMA_backquote($GLOBALS['table']) . ' ' . $_REQUEST['partition_operation'] . ' PARTITION ' . $_REQUEST['partition_name'];
 139     $result = PMA_DBI_query($sql_query);
 140 } // end if
 141
 142 if ($reread_info) {
 143     $checksum = $delay_key_write = 0;
 144     require './libraries/tbl_info.inc.php';
 145 }
 146 unset($reread_info);
 147
 148 /**
 149  * Displays top menu links
 150  */
 151 require_once './libraries/tbl_links.inc.php';
 152
 153 if (isset($result)) {
 154     if (empty($_message)) {
 155         $_message = $result ? $strSuccess : $strError;
 156     }
 157     // $result should exist, regardless of $_message
 158     $_type = $result ? 'success' : 'error';
 159     PMA_showMessage($_message, $sql_query, $_type);
 160 }
 161
 162 $url_params['goto'] = 'tbl_operations.php';
 163 $url_params['back'] = 'tbl_operations.php';
 164
 165 /**
 166  * Get columns names
 167  */
 168 $local_query = '
 169     SHOW COLUMNS
 170     FROM ' . PMA_backquote($GLOBALS['table']) . '
 171     FROM ' . PMA_backquote($GLOBALS['db']);
 172 $columns = PMA_DBI_fetch_result($local_query, null, 'Field');
 173 unset($local_query);
 174
 175 /**
 176  * Displays the page
 177  */
 178 ?>
 179 <!-- Order the table -->
 180 <div id="div_table_order">
 181 <form method="post" action="tbl_operations.php">
 182 <?php echo PMA_generate_common_hidden_inputs($GLOBALS['db'], $GLOBALS['table']); ?>
 183 <fieldset id="fieldset_table_order">
 184     <legend><?php echo $strAlterOrderBy; ?></legend>
 185     <select name="order_field">
 186 <?php
 187 foreach ($columns as $fieldname) {
 188     echo '            <option value="' . htmlspecialchars($fieldname) . '">'
 189         . htmlspecialchars($fieldname) . '</option>' . "\n";
 190 }
 191 unset($columns);
 192 ?>
 193     </select> <?php echo $strSingly; ?>
 194     <select name="order_order">
 195         <option value="asc"><?php echo $strAscending; ?></option>
 196         <option value="desc"><?php echo $strDescending; ?></option>
 197     </select>
 198     <input type="submit" name="submitorderby" value="<?php echo $strGo; ?>" />
 199 </fieldset>
 200 </form>
 201 </div>
 202
 203 <!-- Move table -->
 204 <div id="div_table_rename">
 205 <form method="post" action="tbl_move_copy.php"
 206     onsubmit="return emptyFormElements(this, 'new_name')">
 207 <?php echo PMA_generate_common_hidden_inputs($GLOBALS['db'], $GLOBALS['table']); ?>
 208 <input type="hidden" name="reload" value="1" />
 209 <input type="hidden" name="what" value="data" />
 210 <fieldset id="fieldset_table_rename">
 211     <legend><?php echo $strMoveTable; ?></legend>
 212 <?php if ($GLOBALS['PMA_List_Database']->count() > $GLOBALS['cfg']['MaxDbList']) {
 213 ?>
 214     <input type="text" maxlength="100" size="30" name="target_db" value="<?php echo htmlspecialchars($GLOBALS['db']); ?>"/>
 215 <?php
 216     } else {
 217 ?>
 218     <select name="target_db">
 219         <?php echo $GLOBALS['PMA_List_Database']->getHtmlOptions(true, false); ?>
 220     </select>
 221 <?php
 222     } // end if
 223 ?>
 224     &nbsp;<b>.</b>&nbsp;
 225     <input type="text" size="20" name="new_name" onfocus="this.select()"
 226 value="<?php echo htmlspecialchars($GLOBALS['table']); ?>" /><br />
 227     <?php
 228     // starting with MySQL 5.0.24, SHOW CREATE TABLE includes the AUTO_INCREMENT
 229     // next value but users can decide if they want it or not for the operation
 230     ?>
 231     <input type="checkbox" name="sql_auto_increment" value="1" id="checkbox_auto_increment_mv" checked="checked" />
 232     <label for="checkbox_auto_increment_mv"><?php echo $strAddAutoIncrement; ?></label><br />
 233 </fieldset>
 234 <fieldset class="tblFooters">
 235     <input type="submit" name="submit_move" value="<?php echo $strGo; ?>" />
 236 </fieldset>
 237 </form>
 238 </div>
 239
 240 <?php
 241 if (strstr($show_comment, '; InnoDB free') === false) {
 242     if (strstr($show_comment, 'InnoDB free') === false) {
 243         // only user entered comment
 244         $comment = $show_comment;
 245     } else {
 246         // here we have just InnoDB generated part
 247         $comment = '';
 248     }
 249 } else {
 250     // remove InnoDB comment from end, just the minimal part (*? is non greedy)
 251     $comment = preg_replace('@; InnoDB free:.*?$@', '', $show_comment);
 252 }
 253
 254 // PACK_KEYS: MyISAM or ISAM
 255 // DELAY_KEY_WRITE, CHECKSUM, : MyISAM only
 256 // AUTO_INCREMENT: MyISAM and InnoDB since 5.0.3
 257
 258 // nijel: Here should be version check for InnoDB, however it is supported
 259 // in >5.0.4, >4.1.12 and >4.0.11, so I decided not to
 260 // check for version
 261 ?>
 262
 263 <!-- Table options -->
 264 <div id="div_table_options">
 265 <form method="post" action="tbl_operations.php">
 266 <?php echo PMA_generate_common_hidden_inputs($GLOBALS['db'], $GLOBALS['table']); ?>
 267 <input type="hidden" name="reload" value="1" />
 268 <fieldset>
 269     <legend><?php echo $strTableOptions; ?></legend>
 270
 271     <table>
 272     <!-- Change table name -->
 273     <tr><td><?php echo $strRenameTable; ?></td>
 274         <td><input type="text" size="20" name="new_name" onfocus="this.select()"
 275                 value="<?php echo htmlspecialchars($GLOBALS['table']); ?>" />
 276         </td>
 277     </tr>
 278
 279     <!-- Table comments -->
 280     <tr><td><?php echo $strTableComments; ?></td>
 281         <td><input type="text" name="comment" maxlength="60" size="30"
 282                 value="<?php echo htmlspecialchars($comment); ?>" onfocus="this.select()" />
 283             <input type="hidden" name="prev_comment" value="<?php echo urlencode($comment); ?>" />
 284         </td>
 285     </tr>
 286
 287     <!-- Storage engine -->
 288     <tr><td><?php echo $strStorageEngine; ?>
 289             <?php echo PMA_showMySQLDocu('Storage_engines', 'Storage_engines'); ?>
 290         </td>
 291         <td><?php echo PMA_StorageEngine::getHtmlSelect('new_tbl_type', null, $tbl_type); ?>
 292         </td>
 293     </tr>
 294
 295     <!-- Table character set -->
 296     <tr><td><?php echo $strCollation; ?></td>
 297         <td><?php echo PMA_generateCharsetDropdownBox(PMA_CSDROPDOWN_COLLATION,
 298                 'tbl_collation', null, $tbl_collation, false, 3); ?>
 299         </td>
 300     </tr>
 301 <?php
 302 if ($tbl_type == 'MYISAM' || $tbl_type == 'ISAM') {
 303     ?>
 304     <tr>
 305         <td><label for="new_pack_keys">pack_keys</label></td>
 306         <td><select name="new_pack_keys" id="new_pack_keys">
 307                 <option value="DEFAULT"
 308                     <?php if ($pack_keys == 'DEFAULT') echo 'selected="selected"'; ?>
 309                     >DEFAULT</option>
 310                 <option value="0"
 311                     <?php if ($pack_keys == '0') echo 'selected="selected"'; ?>
 312                     >0</option>
 313                 <option value="1"
 314                     <?php if ($pack_keys == '1') echo 'selected="selected"'; ?>
 315                     >1</option>
 316             </select>
 317         </td>
 318     </tr>
 319     <?php
 320 } // end if (MYISAM|ISAM)
 321
 322 if ($tbl_type == 'MYISAM') {
 323     ?>
 324     <tr><td><label for="new_checksum">checksum</label></td>
 325         <td><input type="checkbox" name="new_checksum" id="new_checksum"
 326                 value="1"
 327     <?php echo (isset($checksum) && $checksum == 1)
 328         ? ' checked="checked"'
 329         : ''; ?> />
 330         </td>
 331     </tr>
 332
 333     <tr><td><label for="new_delay_key_write">delay_key_write</label></td>
 334         <td><input type="checkbox" name="new_delay_key_write" id="new_delay_key_write"
 335                 value="1"
 336     <?php echo (isset($delay_key_write) && $delay_key_write == 1)
 337         ? ' checked="checked"'
 338         : ''; ?> />
 339         </td>
 340     </tr>
 341
 342     <?php
 343 } // end if (MYISAM)
 344
 345 if (isset($auto_increment) && strlen($auto_increment) > 0
 346   && ($tbl_type == 'MYISAM' || $tbl_type == 'INNODB')) {
 347     ?>
 348     <tr><td><label for="auto_increment_opt">auto_increment</label></td>
 349         <td><input type="text" name="new_auto_increment" id="auto_increment_opt"
 350                 value="<?php echo $auto_increment; ?>" /></td>
 351     </tr>
 352     <?php
 353 } // end if (MYISAM|INNODB)
 354 ?>
 355     </table>
 356 </fieldset>
 357 <fieldset class="tblFooters">
 358         <input type="submit" name="submitoptions" value="<?php echo $strGo; ?>" />
 359 </fieldset>
 360 </form>
 361 </div>
 362
 363 <!-- Copy table -->
 364 <div id="div_table_copy">
 365 <form method="post" action="tbl_move_copy.php"
 366     onsubmit="return emptyFormElements(this, 'new_name')">
 367 <?php echo PMA_generate_common_hidden_inputs($GLOBALS['db'], $GLOBALS['table']); ?>
 368 <input type="hidden" name="reload" value="1" />
 369 <fieldset>
 370     <legend><?php echo $strCopyTable; ?></legend>
 371 <?php if ($GLOBALS['PMA_List_Database']->count() > $GLOBALS['cfg']['MaxDbList']) {
 372 ?>
 373     <input type="text" maxlength="100" size="30" name="target_db" value="<?php echo htmlspecialchars($GLOBALS['db']); ?>"/>
 374 <?php
 375     } else {
 376 ?>
 377     <select name="target_db">
 378         <?php echo $GLOBALS['PMA_List_Database']->getHtmlOptions(true, false); ?>
 379     </select>
 380 <?php
 381     } // end if
 382 ?>
 383     &nbsp;<b>.</b>&nbsp;
 384     <input type="text" size="20" name="new_name" onfocus="this.select()" /><br />
 385 <?php
 386         $choices = array(
 387             'structure' => $strStrucOnly,
 388             'data'      => $strStrucData,
 389             'dataonly'  => $strDataOnly);
 390         PMA_generate_html_radio('what', $choices, 'data', true);
 391         unset($choices);
 392 ?>
 393
 394     <input type="checkbox" name="drop_if_exists" value="true" id="checkbox_drop" />
 395     <label for="checkbox_drop"><?php echo sprintf($strAddClause, 'DROP TABLE'); ?></label><br />
 396     <input type="checkbox" name="sql_auto_increment" value="1" id="checkbox_auto_increment_cp" />
 397     <label for="checkbox_auto_increment_cp"><?php echo $strAddAutoIncrement; ?></label><br />
 398     <?php
 399         // display "Add constraints" choice only if there are
 400         // foreign keys
 401         if (PMA_getForeigners($GLOBALS['db'], $GLOBALS['table'], '', 'innodb')) {
 402         ?>
 403     <input type="checkbox" name="add_constraints" value="1" id="checkbox_constraints" />
 404     <label for="checkbox_constraints"><?php echo $strAddConstraints; ?></label><br />
 405         <?php
 406         } // endif
 407         if (isset($_COOKIE['pma_switch_to_new'])
 408           && $_COOKIE['pma_switch_to_new'] == 'true') {
 409             $pma_switch_to_new = 'true';
 410         }
 411     ?>
 412     <input type="checkbox" name="switch_to_new" value="true"
 413         id="checkbox_switch"<?php echo
 414             isset($pma_switch_to_new) && $pma_switch_to_new == 'true'
 415             ? ' checked="checked"'
 416             : ''; ?> />
 417     <label for="checkbox_switch"><?php echo $strSwitchToTable; ?></label>
 418 </fieldset>
 419 <fieldset class="tblFooters">
 420     <input type="submit" name="submit_copy" value="<?php echo $strGo; ?>" />
 421 </fieldset>
 422 </form>
 423 </div>
 424
 425 <br class="clearfloat"/>
 426
 427 <div id="div_table_maintenance">
 428 <fieldset>
 429  <legend><?php echo $strTableMaintenance; ?></legend>
 430
 431 <ul>
 432 <?php
 433 if ($tbl_type == 'MYISAM' || $tbl_type == 'BERKELEYDB' || $tbl_type == 'INNODB') {
 434     if ($tbl_type == 'MYISAM' || $tbl_type == 'INNODB') {
 435         $this_url_params = array_merge($url_params,
 436             array('sql_query' => 'CHECK TABLE ' . PMA_backquote($GLOBALS['table'])));
 437         ?>
 438     <li><a href="sql.php<?php echo PMA_generate_common_url($this_url_params); ?>">
 439             <?php echo $strCheckTable; ?></a>
 440         <?php echo PMA_showMySQLDocu('MySQL_Database_Administration', 'CHECK_TABLE'); ?>
 441     </li>
 442         <?php
 443     }
 444     if ($tbl_type == 'INNODB') {
 445         $this_url_params = array_merge($url_params,
 446             array('sql_query' => 'ALTER TABLE ' . PMA_backquote($GLOBALS['table']) . ' ENGINE = InnoDB'));
 447         ?>
 448     <li><a href="sql.php<?php echo PMA_generate_common_url($this_url_params); ?>">
 449             <?php echo $strDefragment; ?></a>
 450         <?php echo PMA_showMySQLDocu('Table_types', 'InnoDB_File_Defragmenting'); ?>
 451     </li>
 452         <?php
 453     }
 454     if ($tbl_type == 'MYISAM' || $tbl_type == 'BERKELEYDB') {
 455         $this_url_params = array_merge($url_params,
 456             array('sql_query' => 'ANALYZE TABLE ' . PMA_backquote($GLOBALS['table'])));
 457         ?>
 458     <li><a href="sql.php<?php echo PMA_generate_common_url($this_url_params); ?>">
 459             <?php echo $strAnalyzeTable; ?></a>
 460         <?php echo PMA_showMySQLDocu('MySQL_Database_Administration', 'ANALYZE_TABLE');?>
 461     </li>
 462         <?php
 463     }
 464     if ($tbl_type == 'MYISAM') {
 465         $this_url_params = array_merge($url_params,
 466             array('sql_query' => 'REPAIR TABLE ' . PMA_backquote($GLOBALS['table'])));
 467         ?>
 468     <li><a href="sql.php<?php echo PMA_generate_common_url($this_url_params); ?>">
 469             <?php echo $strRepairTable; ?></a>
 470         <?php echo PMA_showMySQLDocu('MySQL_Database_Administration', 'REPAIR_TABLE'); ?>
 471     </li>
 472         <?php
 473     }
 474     if ($tbl_type == 'MYISAM' || $tbl_type == 'BERKELEYDB' || $tbl_type == 'INNODB') {
 475         $this_url_params = array_merge($url_params,
 476             array('sql_query' => 'OPTIMIZE TABLE ' . PMA_backquote($GLOBALS['table'])));
 477         ?>
 478     <li><a href="sql.php<?php echo PMA_generate_common_url($this_url_params); ?>">
 479             <?php echo $strOptimizeTable; ?></a>
 480         <?php echo PMA_showMySQLDocu('MySQL_Database_Administration', 'OPTIMIZE_TABLE'); ?>
 481     </li>
 482         <?php
 483     }
 484 } // end MYISAM or BERKELEYDB case
 485 $this_url_params = array_merge($url_params,
 486     array(
 487         'sql_query' => 'FLUSH TABLE ' . PMA_backquote($GLOBALS['table']),
 488         'zero_rows' => sprintf($strTableHasBeenFlushed,
 489             htmlspecialchars($GLOBALS['table'])),
 490         'reload'    => 1,
 491         ));
 492 ?>
 493     <li><a href="sql.php<?php echo PMA_generate_common_url($this_url_params); ?>">
 494             <?php echo $strFlushTable; ?></a>
 495         <?php echo PMA_showMySQLDocu('MySQL_Database_Administration', 'FLUSH'); ?>
 496     </li>
 497 </ul>
 498 </fieldset>
 499 </div>
 500 <?php if (PMA_Partition::havePartitioning()) {
 501     $partition_names = PMA_Partition::getPartitionNames($db, $table);
 502     // show the Partition maintenance section only if we detect a partition
 503     if (! is_null($partition_names[0])) {
 504     ?>
 505 <div id="div_partition_maintenance">
 506 <form method="post" action="tbl_operations.php">
 507 <?php echo PMA_generate_common_hidden_inputs($GLOBALS['db'], $GLOBALS['table']); ?>
 508 <fieldset>
 509  <legend><?php echo $strPartitionMaintenance; ?></legend>
 510 <?php
 511         $html_select = '<select name="partition_name">' . "\n";
 512         foreach($partition_names as $one_partition) {
 513             $one_partition = htmlspecialchars($one_partition);
 514             $html_select .= '<option value="' . $one_partition . '">' . $one_partition . '</option>' . "\n";
 515         }
 516         $html_select .= '</select>' . "\n";
 517         printf($GLOBALS['strPartition'], $html_select);
 518         unset($partition_names, $one_partition, $html_select);
 519         $choices = array(
 520             'ANALYZE' => $strAnalyze,
 521             'CHECK' => $strCheck,
 522             'OPTIMIZE' => $strOptimize,
 523             'REBUILD' => $strRebuild,
 524             'REPAIR' => $strRepair);
 525         PMA_generate_html_radio('partition_operation', $choices, '', false);
 526         unset($choices);
 527         echo PMA_showMySQLDocu('partitioning_maintenance', 'partitioning_maintenance');
 528         // I'm not sure of the best way to display that; this link does
 529         // not depend on the Go button
 530     $this_url_params = array_merge($url_params,
 531         array(
 532             'sql_query' => 'ALTER TABLE ' . PMA_backquote($GLOBALS['table']) . ' REMOVE PARTITIONING'
 533             ));
 534 ?>
 535     <br /><a href="sql.php<?php echo PMA_generate_common_url($this_url_params); ?>">
 536             <?php echo $strRemovePartitioning; ?></a>
 537 </fieldset>
 538 <fieldset class="tblFooters">
 539     <input type="submit" name="submit_partition" value="<?php echo $strGo; ?>" />
 540 </fieldset>
 541 </form>
 542 </div>
 543 <?php
 544         } // end if
 545     } // end if
 546
 547 // Referential integrity check
 548 // The Referential integrity check was intended for the non-InnoDB
 549 // tables for which the relations are defined in pmadb
 550 // so I assume that if the current table is InnoDB, I don't display
 551 // this choice (InnoDB maintains integrity by itself)
 552
 553 if ($cfgRelation['relwork'] && $tbl_type != "INNODB") {
 554     PMA_DBI_select_db($GLOBALS['db']);
 555     $foreign = PMA_getForeigners($GLOBALS['db'], $GLOBALS['table']);
 556
 557     if ($foreign) {
 558         ?>
 559     <!-- Referential integrity check -->
 560 <div id="div_referential_integrity">
 561 <fieldset>
 562  <legend><?php echo $strReferentialIntegrity; ?></legend>
 563     <ul>
 564         <?php
 565         echo "\n";
 566         foreach ($foreign AS $master => $arr) {
 567             $join_query  = 'SELECT ' . PMA_backquote($GLOBALS['table']) . '.* FROM '
 568                          . PMA_backquote($GLOBALS['table']) . ' LEFT JOIN '
 569                          . PMA_backquote($arr['foreign_table']);
 570             if ($arr['foreign_table'] == $GLOBALS['table']) {
 571                 $foreign_table = $GLOBALS['table'] . '1';
 572                 $join_query .= ' AS ' . PMA_backquote($foreign_table);
 573             } else {
 574                 $foreign_table = $arr['foreign_table'];
 575             }
 576             $join_query .= ' ON '
 577                          . PMA_backquote($GLOBALS['table']) . '.' . PMA_backquote($master)
 578                          . ' = ' . PMA_backquote($foreign_table) . '.' . PMA_backquote($arr['foreign_field'])
 579                          . ' WHERE '
 580                          . PMA_backquote($foreign_table) . '.' . PMA_backquote($arr['foreign_field'])
 581                          . ' IS NULL AND '
 582                          . PMA_backquote($GLOBALS['table']) . '.' . PMA_backquote($master)
 583                          . ' IS NOT NULL';
 584             $this_url_params = array_merge($url_params,
 585                 array('sql_query' => $join_query));
 586             echo '        <li>'
 587                  . '<a href="sql.php'
 588                  . PMA_generate_common_url($this_url_params)
 589                  . '">' . $master . '&nbsp;->&nbsp;' . $arr['foreign_table'] . '.' . $arr['foreign_field']
 590                  . '</a></li>' . "\n";
 591         } //  foreach $foreign
 592         unset($foreign_table, $join_query);
 593         ?>
 594     </ul>
 595    </fieldset>
 596   </div>
 597         <?php
 598     } // end if ($foreign)
 599
 600 } // end  if (!empty($cfg['Server']['relation']))
 601
 602
 603 /**
 604  * Displays the footer
 605  */
 606 require_once './libraries/footer.inc.php';
 607 ?>