tbl_properties_structure.php3

   1 <?php
   2 /* $Id$ */
   3 // vim: expandtab sw=4 ts=4 sts=4:
   4
   5
   6 /**
   7  * Runs common work
   8  */
   9 require('./tbl_properties_common.php3');
  10 $url_query .= '&amp;goto=tbl_properties_structure.php3&amp;back=tbl_properties_structure.php3';
  11
  12
  13 /**
  14  * Drop multiple fields if required
  15  */
  16 if ((!empty($submit_mult) && isset($selected_fld))
  17     || isset($mult_btn)) {
  18     $action = 'tbl_properties_structure.php3';
  19     include('./mult_submits.inc.php3');
  20 }
  21
  22
  23 /**
  24  * Prepares the table structure display
  25  */
  26 // 1. Get table information
  27 require('./tbl_properties_table_info.php3');
  28
  29 // 2. Gets table keys and retains them
  30 $local_query = 'SHOW KEYS FROM ' . PMA_backquote($table);
  31 $result      = PMA_mysql_query($local_query) or PMA_mysqlDie('', $local_query, '', $err_url_0);
  32 $primary     = '';
  33 $ret_keys    = array();
  34 $pk_array    = array(); // will be use to emphasis prim. keys in the table view
  35 while ($row = PMA_mysql_fetch_array($result)) {
  36     $ret_keys[]  = $row;
  37     // Backups the list of primary keys
  38     if ($row['Key_name'] == 'PRIMARY') {
  39         $primary .= $row['Column_name'] . ', ';
  40         $pk_array[$row['Column_name']] = 1;
  41     }
  42 } // end while
  43 mysql_free_result($result);
  44
  45 // 3. Get fields
  46 $local_query = 'SHOW FIELDS FROM ' . PMA_backquote($table);
  47 $fields_rs   = PMA_mysql_query($local_query) or PMA_mysqlDie('', $local_query, '', $err_url_0);
  48 $fields_cnt  = mysql_num_rows($fields_rs);
  49
  50
  51
  52 /**
  53  * Displays the table structure ('show table' works correct since 3.23.03)
  54  */
  55 ?>
  56
  57 <!-- TABLE INFORMATIONS -->
  58
  59 <form action="tbl_properties_structure.php3" name="fieldsForm">
  60     <?php echo PMA_generate_common_hidden_inputs($db, $table); ?>
  61
  62 <table border="<?php echo $cfg['Border']; ?>">
  63 <tr>
  64     <td></td>
  65     <th>&nbsp;<?php echo $strField; ?>&nbsp;</th>
  66     <th><?php echo $strType; ?></th>
  67     <th><?php echo $strAttr; ?></th>
  68     <th><?php echo $strNull; ?></th>
  69     <th><?php echo $strDefault; ?></th>
  70     <th><?php echo $strExtra; ?></th>
  71     <th colspan="<?php echo((PMA_MYSQL_INT_VERSION >= 32323) ? '6' : '5'); ?>"><?php echo $strAction; ?></th>
  72 </tr>
  73
  74 <?php
  75 $i         = 0;
  76 $aryFields = array();
  77 $checked   = (!empty($checkall) ? ' checked="checked"' : '');
  78
  79 while ($row = PMA_mysql_fetch_array($fields_rs)) {
  80     $i++;
  81     $bgcolor          = ($i % 2) ? $cfg['BgcolorOne'] : $cfg['BgcolorTwo'];
  82     $aryFields[]      = $row['Field'];
  83
  84     $type             = $row['Type'];
  85     // reformat mysql query output - staybyte - 9. June 2001
  86     // loic1: set or enum types: slashes single quotes inside options
  87     if (eregi('^(set|enum)\((.+)\)$', $type, $tmp)) {
  88         $tmp[2]       = substr(ereg_replace('([^,])\'\'', '\\1\\\'', ',' . $tmp[2]), 1);
  89         $type         = $tmp[1] . '(' . str_replace(',', ', ', $tmp[2]) . ')';
  90         $type_nowrap  = '';
  91
  92         $binary       = 0;
  93         $unsigned     = 0;
  94         $zerofill     = 0;
  95     } else {
  96         $type_nowrap  = ' nowrap="nowrap"';
  97         $type         = eregi_replace('BINARY', '', $type);
  98         $type         = eregi_replace('ZEROFILL', '', $type);
  99         $type         = eregi_replace('UNSIGNED', '', $type);
 100         if (empty($type)) {
 101             $type     = '&nbsp;';
 102         }
 103
 104         $binary       = eregi('BINARY', $row['Type'], $test);
 105         $unsigned     = eregi('UNSIGNED', $row['Type'], $test);
 106         $zerofill     = eregi('ZEROFILL', $row['Type'], $test);
 107     }
 108     $strAttribute     = '&nbsp;';
 109     if ($binary) {
 110         $strAttribute = 'BINARY';
 111     }
 112     if ($unsigned) {
 113         $strAttribute = 'UNSIGNED';
 114     }
 115     if ($zerofill) {
 116         $strAttribute = 'UNSIGNED ZEROFILL';
 117     }
 118     if (!isset($row['Default'])) {
 119         if ($row['Null'] != '') {
 120             $row['Default'] = '<i>NULL</i>';
 121         }
 122     } else {
 123         $row['Default'] = htmlspecialchars($row['Default']);
 124     }
 125
 126     $field_encoded = urlencode($row['Field']);
 127     $field_name    = htmlspecialchars($row['Field']);
 128     if (isset($pk_array[$row['Field']])) {
 129         $field_name = '<u>' . $field_name . '</u>';
 130     }
 131     echo "\n";
 132
 133     ?>
 134 <tr>
 135     <td align="center" bgcolor="<?php echo $bgcolor; ?>">
 136         <input type="checkbox" name="selected_fld[]" value="<?php echo $field_encoded; ?>" id="checkbox_row_<?php echo $i; ?>" <?php echo $checked; ?> />
 137     </td>
 138     <td bgcolor="<?php echo $bgcolor; ?>" nowrap="nowrap">&nbsp;<label for="checkbox_row_<?php echo $i; ?>"><?php echo $field_name; ?></label>&nbsp;</td>
 139     <td bgcolor="<?php echo $bgcolor; ?>"<?php echo $type_nowrap; ?>><?php echo $type; ?><bdo dir="ltr"></bdo></td>
 140     <td bgcolor="<?php echo $bgcolor; ?>" nowrap="nowrap"><?php echo $strAttribute; ?></td>
 141     <td bgcolor="<?php echo $bgcolor; ?>"><?php echo (($row['Null'] == '') ? $strNo : $strYes); ?>&nbsp;</td>
 142     <td bgcolor="<?php echo $bgcolor; ?>" nowrap="nowrap"><?php if (isset($row['Default'])) echo $row['Default']; ?>&nbsp;</td>
 143     <td bgcolor="<?php echo $bgcolor; ?>" nowrap="nowrap"><?php echo $row['Extra']; ?>&nbsp;</td>
 144     <td bgcolor="<?php echo $bgcolor; ?>">
 145         <a href="tbl_alter.php3?<?php echo $url_query; ?>&amp;field=<?php echo $field_encoded; ?>">
 146             <?php echo $strChange; ?></a>
 147     </td>
 148     <td bgcolor="<?php echo $bgcolor; ?>">
 149         <?php
 150         // loic1: Drop field only if there is more than one field in the table
 151         if ($fields_cnt > 1) {
 152             echo "\n";
 153             ?>
 154         <a href="sql.php3?<?php echo $url_query; ?>&amp;sql_query=<?php echo urlencode('ALTER TABLE ' . PMA_backquote($table) . ' DROP ' . PMA_backquote($row['Field'])); ?>&amp;zero_rows=<?php echo urlencode(sprintf($strFieldHasBeenDropped, htmlspecialchars($row['Field']))); ?>"
 155             onclick="return confirmLink(this, 'ALTER TABLE <?php echo PMA_jsFormat($table); ?> DROP <?php echo PMA_jsFormat($row['Field']); ?>')">
 156             <?php echo $strDrop; ?></a>
 157             <?php
 158         } else {
 159             echo "\n" . '        ' . $strDrop;
 160         }
 161         echo "\n";
 162         ?>
 163     </td>
 164     <td bgcolor="<?php echo $bgcolor; ?>">
 165         <?php
 166         if ($type == 'text' || $type == 'blob') {
 167             echo $strPrimary . "\n";
 168         } else {
 169             echo "\n";
 170             ?>
 171         <a href="sql.php3?<?php echo $url_query; ?>&amp;sql_query=<?php echo urlencode('ALTER TABLE ' . PMA_backquote($table) . ' DROP PRIMARY KEY, ADD PRIMARY KEY(' . $primary . PMA_backquote($row['Field']) . ')'); ?>&amp;zero_rows=<?php echo urlencode(sprintf($strAPrimaryKey, htmlspecialchars($row['Field']))); ?>"
 172             onclick="return confirmLink(this, 'ALTER TABLE <?php echo PMA_jsFormat($table); ?> DROP PRIMARY KEY, ADD PRIMARY KEY(<?php echo PMA_jsFormat($row['Field']); ?>)')">
 173             <?php echo $strPrimary; ?></a>
 174             <?php
 175         }
 176         echo "\n";
 177         ?>
 178     </td>
 179     <td bgcolor="<?php echo $bgcolor; ?>">
 180         <?php
 181         if ($type == 'text' || $type == 'blob') {
 182             echo $strIndex . "\n";
 183         } else {
 184             echo "\n";
 185             ?>
 186         <a href="sql.php3?<?php echo $url_query; ?>&amp;sql_query=<?php echo urlencode('ALTER TABLE ' . PMA_backquote($table) . ' ADD INDEX(' . PMA_backquote($row['Field']) . ')'); ?>&amp;zero_rows=<?php echo urlencode(sprintf($strAnIndex ,htmlspecialchars($row['Field']))); ?>">
 187             <?php echo $strIndex; ?></a>
 188             <?php
 189         }
 190         echo "\n";
 191         ?>
 192     </td>
 193     <td bgcolor="<?php echo $bgcolor; ?>">
 194         <?php
 195         if ($type == 'text' || $type == 'blob') {
 196             echo $strUnique . "\n";
 197         } else {
 198             echo "\n";
 199             ?>
 200         <a href="sql.php3?<?php echo $url_query; ?>&amp;sql_query=<?php echo urlencode('ALTER TABLE ' . PMA_backquote($table) . ' ADD UNIQUE(' . PMA_backquote($row['Field']) . ')'); ?>&amp;zero_rows=<?php echo urlencode(sprintf($strAnIndex , htmlspecialchars($row['Field']))); ?>">
 201             <?php echo $strUnique; ?></a>
 202             <?php
 203         }
 204         echo "\n";
 205         ?>
 206     </td>
 207     <?php
 208     if (PMA_MYSQL_INT_VERSION >= 32323) {
 209         if ((!empty($tbl_type) && $tbl_type == 'MYISAM')
 210             && ($type == 'text' || strpos(' ' . $type, 'varchar'))) {
 211             echo "\n";
 212             ?>
 213     <td bgcolor="<?php echo $bgcolor; ?>" nowrap="nowrap">
 214         <a href="sql.php3?<?php echo $url_query; ?>&amp;sql_query=<?php echo urlencode('ALTER TABLE ' . PMA_backquote($table) . ' ADD FULLTEXT(' . PMA_backquote($row['Field']) . ')'); ?>&amp;zero_rows=<?php echo urlencode(sprintf($strAnIndex , htmlspecialchars($row['Field']))); ?>">
 215             <?php echo $strIdxFulltext; ?></a>
 216     </td>
 217             <?php
 218         } else {
 219             echo "\n";
 220             ?>
 221     <td bgcolor="<?php echo $bgcolor; ?>" nowrap="nowrap">
 222         <?php echo $strIdxFulltext . "\n"; ?>
 223     </td>
 224             <?php
 225         } // end if... else...
 226     } // end if
 227     echo "\n"
 228     ?>
 229 </tr>
 230     <?php
 231 } // end while
 232
 233 echo "\n";
 234
 235 $checkall_url = 'tbl_properties_structure.php3?' . PMA_generate_common_url($db,$table);
 236 ?>
 237
 238 <tr>
 239     <td colspan="<?php echo((PMA_MYSQL_INT_VERSION >= 32323) ? '13' : '12'); ?>">
 240         <img src="./images/arrow_<?php echo $text_dir; ?>.gif" border="0" width="38" height="22" alt="<?php echo $strWithChecked; ?>" />
 241         <a href="<?php echo $checkall_url; ?>&amp;checkall=1" onclick="setCheckboxes('fieldsForm', true); return false;">
 242             <?php echo $strCheckAll; ?></a>
 243         &nbsp;/&nbsp;
 244         <a href="<?php echo $checkall_url; ?>" onclick="setCheckboxes('fieldsForm', false); return false;">
 245             <?php echo $strUncheckAll; ?></a>
 246         &nbsp;&nbsp;&nbsp;
 247         <i><?php echo $strWithChecked; ?></i>&nbsp;&nbsp;
 248         <input type="submit" name="submit_mult" value="<?php echo $strChange; ?>" />
 249 <?php
 250 // Drop button if there is at least two fields
 251 if ($fields_cnt > 1) {
 252     ?>
 253         &nbsp;<i><?php echo $strOr; ?></i>&nbsp;
 254         <input type="submit" name="submit_mult" value="<?php echo $strDrop; ?>" />
 255     <?php
 256 }
 257 echo "\n";
 258 ?>
 259     </td>
 260 </tr>
 261 </table>
 262
 263 </form>
 264
 265
 266 <?php
 267 /**
 268  * If there are more than 20 rows, displays browse/select/insert/empty/drop
 269  * links again
 270  */
 271 if ($fields_cnt > 20) {
 272     ?>
 273 <!-- Browse links -->
 274     <?php
 275     echo "\n";
 276     include('./tbl_properties_links.php3');
 277 } // end if ($fields_cnt > 20)
 278 echo "\n\n";
 279
 280
 281 /**
 282  * Displays indexes
 283  */
 284 ?>
 285 <!-- Indexes, space usage and row statistics -->
 286 <br />
 287 <table border="0" cellspacing="0" cellpadding="0">
 288 <tr>
 289     <td>
 290 <?php
 291 define('PMA_IDX_INCLUDED', 1);
 292 require ('./tbl_indexes.php3');
 293 ?>
 294     </td>
 295
 296 <?php
 297 /**
 298  * Displays Space usage and row statistics
 299  */
 300 // BEGIN - Calc Table Space - staybyte - 9 June 2001
 301 // loic1, 22 feb. 2002: updated with patch from
 302 //                      Joshua Nye <josh at boxcarmedia.com> to get valid
 303 //                      statistics whatever is the table type
 304 if ($cfg['ShowStats']) {
 305     $nonisam     = FALSE;
 306     $is_innodb = (isset($showtable['Type']) && $showtable['Type'] == 'InnoDB');
 307     if (isset($showtable['Type']) && !eregi('ISAM|HEAP', $showtable['Type'])) {
 308         $nonisam = TRUE;
 309     }
 310     if (PMA_MYSQL_INT_VERSION >= 32303 && ($nonisam == FALSE || $is_innodb)) {
 311         // Gets some sizes
 312         $mergetable     = FALSE;
 313         if (isset($showtable['Type']) && $showtable['Type'] == 'MRG_MyISAM') {
 314             $mergetable = TRUE;
 315         }
 316         list($data_size, $data_unit)         = PMA_formatByteDown($showtable['Data_length']);
 317         if ($mergetable == FALSE) {
 318             list($index_size, $index_unit)   = PMA_formatByteDown($showtable['Index_length']);
 319         }
 320         if (isset($showtable['Data_free']) && $showtable['Data_free'] > 0) {
 321             list($free_size, $free_unit)     = PMA_formatByteDown($showtable['Data_free']);
 322             list($effect_size, $effect_unit) = PMA_formatByteDown($showtable['Data_length'] + $showtable['Index_length'] - $showtable['Data_free']);
 323         } else {
 324             list($effect_size, $effect_unit) = PMA_formatByteDown($showtable['Data_length'] + $showtable['Index_length']);
 325         }
 326         list($tot_size, $tot_unit)           = PMA_formatByteDown($showtable['Data_length'] + $showtable['Index_length']);
 327         if ($table_info_num_rows > 0) {
 328             list($avg_size, $avg_unit)       = PMA_formatByteDown(($showtable['Data_length'] + $showtable['Index_length']) / $showtable['Rows'], 6, 1);
 329         }
 330
 331         // Displays them
 332         ?>
 333
 334     <!-- Space usage -->
 335     <td width="20">&nbsp;</td>
 336     <td valign="top">
 337         <?php echo $strSpaceUsage . '&nbsp;:' . "\n"; ?>
 338         <a name="showusage"></a>
 339         <table border="<?php echo $cfg['Border']; ?>">
 340         <tr>
 341             <th><?php echo $strType; ?></th>
 342             <th colspan="2" align="center"><?php echo $strUsage; ?></th>
 343         </tr>
 344         <tr>
 345             <td bgcolor="<?php echo $cfg['BgcolorTwo']; ?>" style="padding-right: 10px"><?php echo $strData; ?></td>
 346             <td bgcolor="<?php echo $cfg['BgcolorTwo']; ?>" align="right" nowrap="nowrap"><?php echo $data_size; ?></td>
 347             <td bgcolor="<?php echo $cfg['BgcolorTwo']; ?>"><?php echo $data_unit; ?></td>
 348         </tr>
 349         <?php
 350         if (isset($index_size)) {
 351             echo "\n";
 352             ?>
 353         <tr>
 354             <td bgcolor="<?php echo $cfg['BgcolorTwo']; ?>" style="padding-right: 10px"><?php echo $strIndex; ?></td>
 355             <td bgcolor="<?php echo $cfg['BgcolorTwo']; ?>" align="right" nowrap="nowrap"><?php echo $index_size; ?></td>
 356             <td bgcolor="<?php echo $cfg['BgcolorTwo']; ?>"><?php echo $index_unit; ?></td>
 357         </tr>
 358             <?php
 359         }
 360         if (isset($free_size)) {
 361             echo "\n";
 362             ?>
 363         <tr style="color: #bb0000">
 364             <td bgcolor="<?php echo $cfg['BgcolorTwo']; ?>" style="padding-right: 10px"><?php echo $strOverhead; ?></td>
 365             <td bgcolor="<?php echo $cfg['BgcolorTwo']; ?>" align="right" nowrap="nowrap"><?php echo $free_size; ?></td>
 366             <td bgcolor="<?php echo $cfg['BgcolorTwo']; ?>"><?php echo $free_unit; ?></td>
 367         </tr>
 368         <tr>
 369             <td bgcolor="<?php echo $cfg['BgcolorOne']; ?>" style="padding-right: 10px"><?php echo $strEffective; ?></td>
 370             <td bgcolor="<?php echo $cfg['BgcolorOne']; ?>" align="right" nowrap="nowrap"><?php echo $effect_size; ?></td>
 371             <td bgcolor="<?php echo $cfg['BgcolorOne']; ?>"><?php echo $effect_unit; ?></td>
 372         </tr>
 373             <?php
 374         }
 375         if (isset($tot_size) && $mergetable == FALSE) {
 376             echo "\n";
 377         ?>
 378         <tr>
 379             <td bgcolor="<?php echo $cfg['BgcolorOne']; ?>" style="padding-right: 10px"><?php echo $strTotalUC; ?></td>
 380             <td bgcolor="<?php echo $cfg['BgcolorOne']; ?>" align="right" nowrap="nowrap"><?php echo $tot_size; ?></td>
 381             <td bgcolor="<?php echo $cfg['BgcolorOne']; ?>"><?php echo $tot_unit; ?></td>
 382         </tr>
 383             <?php
 384         }
 385         // Optimize link if overhead
 386         if (isset($free_size) && ($tbl_type == 'MYISAM' || $tbl_type == 'BDB')) {
 387             echo "\n";
 388             ?>
 389         <tr>
 390             <td colspan="3" align="center">
 391                 [<a href="sql.php3?<?php echo $url_query; ?>&amp;pos=0&amp;sql_query=<?php echo urlencode('OPTIMIZE TABLE ' . PMA_backquote($table)); ?>"><?php echo $strOptimizeTable; ?></a>]
 392             </td>
 393         </tr>
 394             <?php
 395         }
 396         echo "\n";
 397         ?>
 398         </table>
 399     </td>
 400
 401     <!-- Rows Statistic -->
 402     <td width="20">&nbsp;</td>
 403     <td valign="top">
 404         <?php echo $strRowsStatistic . '&nbsp;:' . "\n"; ?>
 405         <table border="<?php echo $cfg['Border']; ?>">
 406         <tr>
 407             <th><?php echo $strStatement; ?></th>
 408             <th align="center"><?php echo $strValue; ?></th>
 409         </tr>
 410         <?php
 411         $i = 0;
 412         if (isset($showtable['Row_format'])) {
 413             $bgcolor = ((++$i%2) ? $cfg['BgcolorTwo'] : $cfg['BgcolorOne']);
 414             echo "\n";
 415             ?>
 416         <tr>
 417             <td bgcolor="<?php echo $bgcolor; ?>"><?php echo $strFormat; ?></td>
 418             <td bgcolor="<?php echo $bgcolor; ?>" align="<?php echo $cell_align_left; ?>" nowrap="nowrap">
 419             <?php
 420             echo '                ';
 421             if ($showtable['Row_format'] == 'Fixed') {
 422                 echo $strFixed;
 423             }
 424             else if ($showtable['Row_format'] == 'Dynamic') {
 425                 echo $strDynamic;
 426             }
 427             else {
 428                 echo $showtable['Row_format'];
 429             }
 430             echo "\n";
 431             ?>
 432             </td>
 433         </tr>
 434             <?php
 435         }
 436         if (!$is_innodb && isset($showtable['Rows'])) {
 437             $bgcolor = ((++$i%2) ? $cfg['BgcolorTwo'] : $cfg['BgcolorOne']);
 438             echo "\n";
 439             ?>
 440         <tr>
 441             <td bgcolor="<?php echo $bgcolor; ?>"><?php echo $strRows; ?></td>
 442             <td bgcolor="<?php echo $bgcolor; ?>" align="right" nowrap="nowrap">
 443                 <?php echo number_format($showtable['Rows'], 0, $number_decimal_separator, $number_thousands_separator) . "\n"; ?>
 444             </td>
 445         </tr>
 446             <?php
 447         }
 448         if (!$is_innodb && isset($showtable['Avg_row_length']) && $showtable['Avg_row_length'] > 0) {
 449             $bgcolor = ((++$i%2) ? $cfg['BgcolorTwo'] : $cfg['BgcolorOne']);
 450             echo "\n";
 451             ?>
 452         <tr>
 453             <td bgcolor="<?php echo $bgcolor; ?>"><?php echo $strRowLength; ?>&nbsp;&oslash;</td>
 454             <td bgcolor="<?php echo $bgcolor; ?>" align="right" nowrap="nowrap">
 455                 <?php echo number_format($showtable['Avg_row_length'], 0, $number_decimal_separator, $number_thousands_separator) . "\n"; ?>
 456             </td>
 457         </tr>
 458             <?php
 459         }
 460         if (!$is_innodb && isset($showtable['Data_length']) && $showtable['Rows'] > 0 && $mergetable == FALSE) {
 461             $bgcolor = ((++$i%2) ? $cfg['BgcolorTwo'] : $cfg['BgcolorOne']);
 462             echo "\n";
 463             ?>
 464         <tr>
 465             <td bgcolor="<?php echo $bgcolor; ?>"><?php echo $strRowSize; ?>&nbsp;&oslash;</td>
 466             <td bgcolor="<?php echo $bgcolor; ?>" align="right" nowrap="nowrap">
 467                 <?php echo $avg_size . ' ' . $avg_unit . "\n"; ?>
 468             </td>
 469         </tr>
 470             <?php
 471         }
 472         if (isset($showtable['Auto_increment'])) {
 473             $bgcolor = ((++$i%2) ? $cfg['BgcolorTwo'] : $cfg['BgcolorOne']);
 474             echo "\n";
 475             ?>
 476         <tr>
 477             <td bgcolor="<?php echo $bgcolor; ?>"><?php echo $strNext; ?>&nbsp;Autoindex</td>
 478             <td bgcolor="<?php echo $bgcolor; ?>" align="right" nowrap="nowrap">
 479                 <?php echo number_format($showtable['Auto_increment'], 0, $number_decimal_separator, $number_thousands_separator) . "\n"; ?>
 480             </td>
 481         </tr>
 482             <?php
 483         }
 484         echo "\n";
 485         ?>
 486         </table>
 487     </td>
 488         <?php
 489     }
 490 }
 491 // END - Calc Table Space
 492 echo "\n";
 493 ?>
 494 </tr>
 495 </table>
 496 <hr />
 497
 498
 499 <?php
 500 /**
 501  * Work on the table
 502  */
 503 ?>
 504 <!-- TABLE WORK -->
 505 <ul>
 506
 507     <!-- Printable view of the table -->
 508     <li>
 509         <div style="margin-bottom: 10px"><a href="tbl_printview.php3?<?php echo $url_query; ?>"><?php echo $strPrintView; ?></a></div>
 510     </li>
 511
 512     <!-- Add some new fields -->
 513     <li>
 514         <form method="post" action="tbl_addfield.php3"
 515             onsubmit="return checkFormElementInRange(this, 'num_fields', 1)">
 516             <?php echo PMA_generate_common_hidden_inputs($db, $table); ?>
 517             <?php echo $strAddNewField; ?>&nbsp;:
 518             <input type="text" name="num_fields" size="2" maxlength="2" value="1" class="textfield" style="vertical-align: middle" onfocus="this.select()" />
 519             <select name="after_field" style="vertical-align: middle">
 520                 <option value="--end--"><?php echo $strAtEndOfTable; ?></option>
 521                 <option value="--first--"><?php echo $strAtBeginningOfTable; ?></option>
 522 <?php
 523 reset($aryFields);
 524 while (list($junk, $fieldname) = each($aryFields)) {
 525     echo '                <option value="' . urlencode($fieldname) . '">' . sprintf($strAfter, htmlspecialchars($fieldname)) . '</option>' . "\n";
 526 }
 527 unset($aryFields);
 528 ?>
 529             </select>
 530             <input type="submit" value="<?php echo $strGo; ?>" style="vertical-align: middle" />
 531         </form>
 532     </li>
 533
 534 <?php
 535 if ($cfg['Server']['relation']) {
 536     ?>
 537     <!-- Work on Relations -->
 538     <li>
 539         <div style="margin-bottom: 10px">
 540             <a href="tbl_relation.php3?<?php echo $url_query; ?>"><?php echo $strRelationView; ?></a>
 541         </div>
 542     </li>
 543     <?php
 544 }
 545 echo "\n";
 546 ?>
 547
 548     <!-- Let MySQL propose the optimal structure -->
 549     <li>
 550         <div style="margin-bottom: 10px">
 551         <a href="sql.php3?<?php echo $url_query; ?>&amp;session_max_rows=all&amp;sql_query=<?php echo urlencode('SELECT * FROM ' . PMA_backquote($table) . ' PROCEDURE ANALYSE()'); ?>">
 552             <?php echo $strStructPropose; ?></a>
 553         <?php echo PMA_showMySQLDocu('Extending_MySQL', 'procedure_analyse') . "\n"; ?>
 554         </div>
 555     </li>
 556
 557 <?php
 558 /**
 559  * Query box, bookmark, insert data from textfile
 560  */
 561 $goto = 'tbl_properties_structure.php3';
 562 require('./tbl_query_box.php3');
 563 ?>
 564
 565 </ul>
 566
 567
 568 <?php
 569 /**
 570  * Displays the footer
 571  */
 572 echo "\n";
 573 require('./footer.inc.php3');
 574 ?>