tbl_properties.inc.php3

   1 <?php
   2 /* $Id$ */
   3 // vim: expandtab sw=4 ts=4 sts=4:
   4
   5
   6 ?>
   7 <!-- Set on key handler for moving using by Ctrl+arrows -->
   8 <script type="text/javascript" language="javascript">
   9 <!--
  10 document.onkeydown = onKeyDownArrowsHandler;
  11 // -->
  12 </script>
  13
  14 <form method="post" action="<?php echo $action; ?>">
  15 <?php
  16 echo PMA_generate_common_hidden_inputs($db, $table);
  17 if ($action == 'tbl_create.php3') {
  18     ?>
  19     <input type="hidden" name="reload" value="1" />
  20     <?php
  21 }
  22 else if ($action == 'tbl_addfield.php3') {
  23     echo "\n";
  24     ?>
  25     <input type="hidden" name="after_field" value="<?php echo $after_field; ?>" />
  26     <?php
  27 }
  28 echo "\n";
  29
  30 if (isset($num_fields)) {
  31     ?>
  32     <input type="hidden" name="orig_num_fields" value="<?php echo $num_fields; ?>" />
  33     <?php
  34 }
  35
  36 if (isset($after_field)) {
  37     ?>
  38     <input type="hidden" name="orig_after_field" value="<?php echo $after_field; ?>" />
  39     <?php
  40 }
  41
  42 if (isset($selected) && is_array($selected)) {
  43     @reset($selected);
  44     while(list($o_fld_nr, $o_fld_val) = each($selected)) {
  45     ?>
  46     <input type="hidden" name="selected[<?php echo $o_fld_nr; ?>]" value="<?php echo urlencode($o_fld_val); ?>" />
  47     <?php
  48         if (!isset($true_selected)) {
  49             ?>
  50     <input type="hidden" name="true_selected[<?php echo $o_fld_nr; ?>]" value="<?php echo urlencode($o_fld_val); ?>" />
  51             <?php
  52         }
  53
  54     }
  55
  56     if (isset($true_selected) && is_array($true_selected)) {
  57         @reset($true_selected);
  58         while(list($o_fld_nr, $o_fld_val) = each($true_selected)) {
  59         ?>
  60         <input type="hidden" name="true_selected[<?php echo $o_fld_nr; ?>]" value="<?php echo urlencode($o_fld_val); ?>" />
  61         <?php
  62         }
  63     }
  64
  65 } elseif (isset($field)) {
  66     ?>
  67     <input type="hidden" name="orig_field" value="<?php echo urlencode($field); ?>" />
  68     <input type="hidden" name="true_selected[] value="<?php echo (isset($orig_field) ? $orig_field : urlencode($field)); ?>" />
  69     <?php
  70 }
  71
  72 $is_backup = ($action != 'tbl_create.php3' && $action != 'tbl_addfield.php3');
  73
  74 $header_cells = array();
  75 $content_cells = array();
  76
  77 $header_cells[] = $strField;
  78 $header_cells[] = $strType . '<br /><span style="font-weight: normal">' . PMA_showMySQLDocu('Reference', 'Column_types') . '</span>';
  79 $header_cells[] = $strLengthSet;
  80 $header_cells[] = $strAttr;
  81 $header_cells[] = $strNull;
  82 $header_cells[] = $strDefault . '**';
  83 $header_cells[] = $strExtra;
  84
  85 require('./libraries/relation.lib.php3');
  86 require('./libraries/transformations.lib.php3');
  87 $cfgRelation = PMA_getRelationsParam();
  88
  89 $comments_map = array();
  90 $mime_map = array();
  91 $available_mime = array();
  92
  93 if ($cfgRelation['commwork']) {
  94     $comments_map = PMA_getComments($db, $table);
  95     $header_cells[] = $strComments;
  96
  97     if ($cfgRelation['mimework'] && $cfg['BrowseMIME']) {
  98         $mime_map = PMA_getMIME($db, $table);
  99         $available_mime = PMA_getAvailableMIMEtypes();
 100
 101         $header_cells[] = $strMIME_MIMEtype;
 102         $header_cells[] = $strMIME_transformation;
 103         $header_cells[] = $strMIME_transformation_options . '***';
 104     }
 105 }
 106
 107
 108 // lem9: We could remove this 'if' and let the key information be shown and
 109 // editable. However, for this to work, tbl_alter must be modified to use the
 110 // key fields, as tbl_addfield does.
 111
 112 if (!$is_backup) {
 113     $header_cells[] = $strPrimary;
 114     $header_cells[] = $strIndex;
 115     $header_cells[] = $strUnique;
 116     $header_cells[] = '---';
 117     $header_cells[] = $strIdxFulltext;
 118 }
 119
 120 // garvin: workaround for field_fulltext, because its submitted indizes contain
 121 //         the index as a value, not a key. Inserted here for easier maintaineance
 122 //         and less code to change in existing files.
 123 if (isset($field_fulltext) && is_array($field_fulltext)) {
 124     @reset($field_fulltext);
 125     while(list($fulltext_nr, $fulltext_indexkey) = each($field_fulltext)) {
 126         $submit_fulltext[$fulltext_indexkey] = $fulltext_indexkey;
 127     }
 128 }
 129
 130 for ($i = 0 ; $i < $num_fields; $i++) {
 131     $submit_null = FALSE;
 132     if (isset($regenerate) && $regenerate == TRUE) {
 133         // An error happened with previous inputs, so we will restore the data
 134         // to embed it once again in this form.
 135
 136         $row['Field']     = (isset($field_name) && isset($field_name[$i]) ? $field_name[$i] : FALSE);
 137         $row['Type']      = (isset($field_type) && isset($field_type[$i]) ? $field_type[$i] : FALSE);
 138         $row['Null']      = (isset($field_null) && isset($field_null[$i]) ? $field_null[$i] : '');
 139         if ($row['Null'] == '') {
 140             $submit_null = TRUE;
 141         }
 142
 143         if (isset(${'field_key_' . $i}) && ${'field_key_' . $i} == 'primary_' . $i) {
 144             $row['Key'] = 'PRI';
 145         } elseif (isset(${'field_key_' . $i}) && ${'field_key_' . $i} == 'index_' . $i) {
 146             $row['Key'] = 'MUL';
 147         } elseif (isset(${'field_key_' . $i}) && ${'field_key_' . $i} == 'unique_' . $i) {
 148             $row['Key'] = 'UNI';
 149         } else {
 150             $row['Key'] = '';
 151         }
 152
 153         $row['Default']   = (isset($field_default) && isset($field_default[$i]) ? $field_default[$i] : FALSE);
 154         $row['Extra']     = (isset($field_extra) && isset($field_extra[$i]) ? $field_extra[$i] : FALSE);
 155         $row['Comment']   = (isset($submit_fulltext) && isset($submit_fulltext[$i]) && ($submit_fulltext[$i] == $i) ? 'FULLTEXT' : FALSE);
 156
 157         $submit_length    = (isset($field_length) && isset($field_length[$i]) ? $field_length[$i] : FALSE);
 158         $submit_attribute = (isset($field_attribute) && isset($field_attribute[$i]) ? $field_attribute[$i] : FALSE);
 159
 160         if (isset($field_comments) && isset($field_comments[$i])) {
 161             $comments_map[$row['Field']] = $field_comments[$i];
 162         }
 163
 164         if (isset($field_mimetype) && isset($field_mimetype[$i])) {
 165             $mime_map[$row['Field']]['mimetype'] = $field_mimetype[$i];
 166         }
 167
 168         if (isset($field_transformation) && isset($field_transformation[$i])) {
 169             $mime_map[$row['Field']]['transformation'] = $field_transformation[$i];
 170         }
 171
 172         if (isset($field_transformation_options) && isset($field_transformation_options[$i])) {
 173             $mime_map[$row['Field']]['transformation_options'] = $field_transformation_options[$i];
 174         }
 175
 176     } elseif (isset($fields_meta)) {
 177         $row = $fields_meta[$i];
 178     }
 179
 180     $bgcolor = ($i % 2) ? $cfg['BgcolorOne'] : $cfg['BgcolorTwo'];
 181
 182     // Cell index: If certain fields get left out, the counter shouldn't chage.
 183     $ci = 0;
 184
 185     if ($is_backup) {
 186         $backup_field = (isset($true_selected) && $true_selected[$i] ? $true_selected[$i] : (isset($row) && isset($row['Field']) ? urlencode($row['Field']) : ''));
 187         $content_cells[$i][$ci] = "\n" . '<input type="hidden" name="field_orig[]" value="' . $backup_field . '" />' . "\n";
 188     } else {
 189         $content_cells[$i][$ci] = '';
 190     }
 191
 192     $content_cells[$i][$ci] .= "\n" . '<input id="field_' . $i . '_1" type="text" name="field_name[]" size="10" maxlength="64" value="' . (isset($row) && isset($row['Field']) ? str_replace('"', '&quot;', $row['Field']) : '') . '" class="textfield" />';
 193     $ci++;
 194     $content_cells[$i][$ci] = '<select name="field_type[]" id="field_' . $i . '_2">' . "\n";
 195
 196     if (empty($row['Type'])) {
 197         $row['Type'] = '';
 198         $type        = '';
 199     }
 200     else {
 201         $type        = $row['Type'];
 202     }
 203     // set or enum types: slashes single quotes inside options
 204     if (eregi('^(set|enum)\((.+)\)$', $type, $tmp)) {
 205         $type   = $tmp[1];
 206         $length = substr(ereg_replace('([^,])\'\'', '\\1\\\'', ',' . $tmp[2]), 1);
 207     } else {
 208         $type   = eregi_replace('BINARY', '', $type);
 209         $type   = eregi_replace('ZEROFILL', '', $type);
 210         $type   = eregi_replace('UNSIGNED', '', $type);
 211
 212         $length = $type;
 213         $type   = chop(eregi_replace('\\(.*\\)', '', $type));
 214         if (!empty($type)) {
 215             $length = eregi_replace("^$type\(", '', $length);
 216             $length = eregi_replace('\)$', '', trim($length));
 217         }
 218         if ($length == $type) {
 219             $length = '';
 220         }
 221     } // end if else
 222
 223     if (isset($submit_length) && $submit_length != FALSE) {
 224         $length = $submit_length;
 225     }
 226
 227     for ($j = 0; $j < count($cfg['ColumnTypes']); $j++) {
 228         $content_cells[$i][$ci] .= '                <option value="'. $cfg['ColumnTypes'][$j] . '"';
 229         if (strtoupper($type) == strtoupper($cfg['ColumnTypes'][$j])) {
 230             $content_cells[$i][$ci] .= ' selected="selected"';
 231         }
 232         $content_cells[$i][$ci] .= '>' . $cfg['ColumnTypes'][$j] . '</option>' . "\n";
 233     } // end for
 234
 235     $content_cells[$i][$ci] .= '    </select>';
 236     $ci++;
 237
 238     if ($is_backup) {
 239         $content_cells[$i][$ci] = "\n" . '<input type="hidden" name="field_length_orig[]" value="' . urlencode($length) . '" />';
 240     } else {
 241         $content_cells[$i][$ci] = '';
 242     }
 243
 244     $content_cells[$i][$ci] .= "\n" . '<input id="field_' . $i . '_3" type="text" name="field_length[]" size="8" value="' . str_replace('"', '&quot;', $length) . '" class="textfield" />' . "\n";
 245     $ci++;
 246
 247     $content_cells[$i][$ci] = '<select name="field_attribute[]" id="field_' . $i . '_4">' . "\n";
 248
 249     if (eregi('^(set|enum)$', $type)) {
 250         $binary           = 0;
 251         $unsigned         = 0;
 252         $zerofill         = 0;
 253     } else {
 254         $binary           = eregi('BINARY', $row['Type'], $test_attribute1);
 255         $unsigned         = eregi('UNSIGNED', $row['Type'], $test_attribute2);
 256         $zerofill         = eregi('ZEROFILL', $row['Type'], $test_attribute3);
 257     }
 258     $strAttribute     = '';
 259     if ($binary) {
 260         $strAttribute = 'BINARY';
 261     }
 262     if ($unsigned) {
 263         $strAttribute = 'UNSIGNED';
 264     }
 265     if ($zerofill) {
 266         $strAttribute = 'UNSIGNED ZEROFILL';
 267     }
 268
 269     if (isset($submit_attribute) && $submit_attribute != FALSE) {
 270         $strAttribute = $submit_attribute;
 271     }
 272
 273     for ($j = 0;$j < count($cfg['AttributeTypes']); $j++) {
 274         $content_cells[$i][3] .= '                <option value="'. $cfg['AttributeTypes'][$j] . '"';
 275         if (strtoupper($strAttribute) == strtoupper($cfg['AttributeTypes'][$j])) {
 276             $content_cells[$i][3] .= ' selected="selected"';
 277         }
 278         $content_cells[$i][3] .= '>' . $cfg['AttributeTypes'][$j] . '</option>' . "\n";
 279     }
 280
 281     $content_cells[$i][$ci] .= '</select>';
 282     $ci++;
 283
 284     $content_cells[$i][$ci] = '<select name="field_null[]" id="field_' . $i . '_5">';
 285
 286     if ((!isset($row) || empty($row['Null']) || $row['Null'] == 'NOT NULL') && $submit_null == FALSE) {
 287         $content_cells[$i][$ci] .= "\n";
 288         $content_cells[$i][$ci] .= '    <option value="NOT NULL">not null</option>' . "\n";
 289         $content_cells[$i][$ci] .= '    <option value="">null</option>' . "\n";
 290     } else {
 291         $content_cells[$i][$ci] .= "\n";
 292         $content_cells[$i][$ci] .= '    <option value="">null</option>' . "\n";
 293         $content_cells[$i][$ci] .= '    <option value="NOT NULL">not null</option>' . "\n";
 294     }
 295
 296     $content_cells[$i][$ci] .= "\n" . '</select>';
 297     $ci++;
 298
 299     if (isset($row)
 300         && !isset($row['Default']) && !empty($row['Null'])) {
 301         $row['Default'] = 'NULL';
 302     }
 303
 304     if ($is_backup) {
 305         $content_cells[$i][5] = "\n" . '<input type="hidden" name="field_default_orig[]" size="8" value="' . (isset($row) && isset($row['Default']) ? urlencode($row['Default']) : '') . '" />';
 306     } else {
 307         $content_cells[$i][5] = "\n";
 308     }
 309
 310     $content_cells[$i][$ci] .= '<input id="field_' . $i . '_6" type="text" name="field_default[]" size="8" value="' . (isset($row) && isset($row['Default']) ? str_replace('"', '&quot;', $row['Default']) : '') . '" class="textfield" />';
 311     $ci++;
 312
 313     $content_cells[$i][$ci] = '<select name="field_extra[]" id="field_' . $i . '_7">';
 314
 315     if(!isset($row) || empty($row['Extra'])) {
 316         $content_cells[$i][$ci] .= "\n";
 317         $content_cells[$i][$ci] .= '<option value=""></option>' . "\n";
 318         $content_cells[$i][$ci] .= '<option value="AUTO_INCREMENT">auto_increment</option>' . "\n";
 319     } else {
 320         $content_cells[$i][$ci] .= "\n";
 321         $content_cells[$i][$ci] .= '<option value="AUTO_INCREMENT">auto_increment</option>' . "\n";
 322         $content_cells[$i][$ci] .= '<option value=""></option>' . "\n";
 323     }
 324
 325     $content_cells[$i][$ci] .= "\n" . '</select>';
 326     $ci++;
 327
 328     // garvin: comments
 329     if ($cfgRelation['commwork']) {
 330         $content_cells[$i][$ci] = '<input id="field_' . $i . '_7" type="text" name="field_comments[]" size="8" value="' . (isset($row) && isset($row['Field']) && is_array($comments_map) && isset($comments_map[$row['Field']]) ?  htmlspecialchars($comments_map[$row['Field']]) : '') . '" class="textfield" />';
 331         $ci++;
 332     }
 333
 334     // garvin: MIME-types
 335     if ($cfgRelation['mimework'] && $cfg['BrowseMIME'] && $cfgRelation['commwork']) {
 336         $content_cells[$i][$ci] = '<select id="field_' . $i . '_8" size="1" name="field_mimetype[]">' . "\n";
 337         $content_cells[$i][$ci] .= '    <option value=""></option>' . "\n";
 338         $content_cells[$i][$ci] .= '    <option value="auto">auto-detect</option>' . "\n";
 339
 340         if (is_array($available_mime['mimetype'])) {
 341             @reset($available_mime['mimetype']);
 342             while(list($mimekey, $mimetype) = each($available_mime['mimetype'])) {
 343                 $checked = (isset($row) && isset($row['Field']) && isset($mime_map[$row['Field']]['mimetype']) && ($mime_map[$row['Field']]['mimetype'] == str_replace('/', '_', $mimetype)) ? 'selected ' : '');
 344                 $content_cells[$i][$ci] .= '    <option value="' . str_replace('/', '_', $mimetype) . '" ' . $checked . '>' . htmlspecialchars($mimetype) . '</option>';
 345             }
 346         }
 347
 348         $content_cells[$i][$ci] .= '</select>';
 349         $ci++;
 350
 351         $content_cells[$i][$ci] = '<select id="field_' . $i . '_9" size="1" name="field_transformation[]">' . "\n";
 352         $content_cells[$i][$ci] .= '    <option value="" title="' . $strNone . '"></option>' . "\n";
 353         if (is_array($available_mime['transformation'])) {
 354             @reset($available_mime['transformation']);
 355             while(list($mimekey, $transform) = each($available_mime['transformation'])) {
 356                 $checked = (isset($row) && isset($row['Field']) && isset($mime_map[$row['Field']]['transformation']) && ($mime_map[$row['Field']]['transformation'] == $available_mime['transformation_file'][$mimekey]) ? 'selected ' : '');
 357                 $tooltip = 'strTransformation_' . strtolower(str_replace('.inc.php3', '', $available_mime['transformation_file'][$mimekey]));
 358                 $tooltip = isset($$tooltip) ? $$tooltip : sprintf(str_replace('<br />', ' ', $strMIME_nodescription), 'PMA_transformation_' . $tooltip . '()');
 359                 $content_cells[$i][$ci] .= '<option value="' . $available_mime['transformation_file'][$mimekey] . '" ' . $checked . ' title="' . $tooltip . '">' . htmlspecialchars($transform) . '</option>' . "\n";
 360             }
 361         }
 362
 363         $content_cells[$i][$ci] .= '</select>';
 364         $ci++;
 365
 366         $content_cells[$i][$ci] = '<input id="field_' . $i . '_10" type="text" name="field_transformation_options[]" size="8" value="' . (isset($row) && isset($row['Field']) && isset($mime_map[$row['Field']]['transformation_options']) ?  htmlspecialchars($mime_map[$row['Field']]['transformation_options']) : '') . '" class="textfield" />';
 367         $ci++;
 368     }
 369
 370     // lem9: See my other comment about removing this 'if'.
 371     if (!$is_backup) {
 372         if (isset($row) && isset($row['Key']) && $row['Key'] == 'PRI') {
 373             $checked_primary = ' checked="checked"';
 374         } else {
 375             $checked_primary = '';
 376         }
 377         if (isset($row) && isset($row['Key']) && $row['Key'] == 'MUL') {
 378             $checked_index   = ' checked="checked"';
 379         } else {
 380             $checked_index   = '';
 381         }
 382         if (isset($row) && isset($row['Key']) && $row['Key'] == 'UNI') {
 383             $checked_unique   = ' checked="checked"';
 384         } else {
 385             $checked_unique   = '';
 386         }
 387         if (empty($checked_primary)
 388             && empty($checked_index)
 389             && empty($checked_unique)) {
 390             $checked_none = ' checked="checked"';
 391         } else {
 392             $checked_none = '';
 393         }
 394
 395         if (PMA_MYSQL_INT_VERSION >= 32323
 396             &&(isset($row) && isset($row['Comment']) && $row['Comment'] == 'FULLTEXT')) {
 397             $checked_fulltext = ' checked="checked"';
 398         } else {
 399             $checked_fulltext = '';
 400         }
 401
 402         $content_cells[$i][$ci] = "\n" . '<input type="radio" name="field_key_' . $i . '" value="primary_' . $i . '"' . $checked_primary . ' />';
 403         $ci++;
 404
 405         $content_cells[$i][$ci] = "\n" . '<input type="radio" name="field_key_' . $i . '" value="index_' . $i . '"' .  $checked_index . ' />';
 406         $ci++;
 407
 408         $content_cells[$i][$ci] = "\n" . '<input type="radio" name="field_key_' . $i . '" value="unique_' . $i . '"' .  $checked_unique . ' />';
 409         $ci++;
 410
 411         $content_cells[$i][$ci] = "\n" . '<input type="radio" name="field_key_' . $i . '" value="none_' . $i . '"' .  $checked_none . ' />';
 412         $ci++;
 413
 414         if (PMA_MYSQL_INT_VERSION >= 32323) {
 415             $content_cells[$i][$ci] = '<input type="checkbox" name="field_fulltext[]" value="' . $i . '"' . $checked_fulltext . ' />';
 416         } // end if (PMA_MYSQL_INT_VERSION >= 32323)
 417     } // end if ($action ==...)
 418 } // end for
 419
 420 if ($cfg['DefaultPropDisplay'] == 'horizontal') {
 421 ?>
 422     <table border="<?php echo $cfg['Border']; ?>">
 423     <tr>
 424 <?php
 425 @reset($header_cells);
 426 while(@list($header_nr, $header_val) = @each($header_cells)) {
 427 ?>
 428         <th><?php echo $header_val; ?></th>
 429 <?php
 430 }
 431 ?>
 432     </tr>
 433 <?php
 434 @reset($content_cells);
 435 $i = 0;
 436 while(@list($content_nr, $content_row) = @each($content_cells)) {
 437     $i++;
 438     echo "\n" . '<tr>' . "\n";
 439
 440     $bgcolor = ($i % 2) ? $cfg['BgcolorOne'] : $cfg['BgcolorTwo'];
 441
 442     while(list($content_row_nr, $content_row_val) = @each($content_row)) {
 443 ?>
 444         <td bgcolor="<?php echo $bgcolor; ?>"><?php echo $content_row_val; ?></td>
 445 <?php
 446     }
 447     echo "\n" . '</tr>' . "\n";
 448 }
 449 ?>
 450     </table>
 451     <br />
 452 <?php
 453 } else {
 454 ?>
 455     <table border="<?php echo $cfg['Border']; ?>">
 456 <?php
 457 @reset($header_cells);
 458 $i = 0;
 459 while(@list($header_nr, $header_val) = @each($header_cells)) {
 460     echo "\n" . '<tr>' . "\n";
 461 ?>
 462         <th align="right"><?php echo $header_val; ?></th>
 463 <?php
 464     for ($j = 0; $j < count($content_cells); $j++) {
 465         if (isset($content_cells[$j][$i]) && $content_cells[$j][$i] != '') {
 466             $bgcolor = ($j % 2) ? $cfg['BgcolorOne'] : $cfg['BgcolorTwo'];
 467     ?>
 468         <td bgcolor="<?php echo $bgcolor; ?>"><?php echo $content_cells[$j][$i]; ?></td>
 469     <?php
 470         }
 471     }
 472
 473     echo "\n" . '</tr>' . "\n";
 474     $i++;
 475 }
 476 ?>
 477     </table>
 478     <br />
 479 <?php
 480 }
 481
 482 if ($action == 'tbl_create.php3' && PMA_MYSQL_INT_VERSION >= 32300) {
 483     echo "\n";
 484     ?>
 485     <table>
 486     <tr valign="top">
 487         <td><?php echo $strTableComments; ?>&nbsp;:</td>
 488     <?php
 489     if ($action == 'tbl_create.php3') {
 490         echo "\n";
 491         ?>
 492         <td width="25">&nbsp;</td>
 493         <td><?php echo $strTableType; ?>&nbsp;:</td>
 494         <?php
 495     }
 496     echo "\n";
 497     ?>
 498     </tr>
 499     <tr>
 500         <td>
 501             <input type="text" name="comment" size="40" maxlength="80" value="<?php echo (isset($comment) ? $comment : ''); ?>" class="textfield" />
 502         </td>
 503     <?php
 504     // BEGIN - Table Type - 2 May 2001 - Robbat2
 505     // change by staybyte - 11 June 2001
 506     if ($action == 'tbl_create.php3') {
 507         // find mysql capability - staybyte - 11. June 2001
 508         $query = 'SHOW VARIABLES LIKE \'have_%\'';
 509         $result = PMA_mysql_query($query);
 510         if ($result != FALSE && mysql_num_rows($result) > 0) {
 511             while ($tmp = PMA_mysql_fetch_array($result)) {
 512                 if (isset($tmp['Variable_name'])) {
 513                     switch ($tmp['Variable_name']) {
 514                         case 'have_bdb':
 515                             if (isset($tmp['Variable_name']) && $tmp['Value'] == 'YES') {
 516                                 $tbl_bdb    = TRUE;
 517                             }
 518                             break;
 519                         case 'have_gemini':
 520                             if (isset($tmp['Variable_name']) && $tmp['Value'] == 'YES') {
 521                                 $tbl_gemini = TRUE;
 522                             }
 523                             break;
 524                         case 'have_innodb':
 525                             if (isset($tmp['Variable_name']) && $tmp['Value'] == 'YES') {
 526                                 $tbl_innodb = TRUE;
 527                             }
 528                             break;
 529                         case 'have_isam':
 530                             if (isset($tmp['Variable_name']) && $tmp['Value'] == 'YES') {
 531                                 $tbl_isam   = TRUE;
 532                             }
 533                             break;
 534                     } // end switch
 535                 } // end if
 536             } // end while
 537         } // end if
 538         mysql_free_result($result);
 539
 540         echo "\n";
 541         ?>
 542         <td width="25">&nbsp;</td>
 543         <td>
 544             <select name="tbl_type">
 545                 <option <?php echo (isset($tbl_type) && $tbl_type == 'Default' ? 'selected="checked"' : ''); ?> value="Default"><?php echo $strDefault; ?></option>
 546                 <option <?php echo (isset($tbl_type) && $tbl_type == 'MYISAM' ? 'selected="checked"' : ''); ?> value="MYISAM">MyISAM</option>
 547                 <option <?php echo (isset($tbl_type) && $tbl_type == 'HEAP' ? 'selected="checked"' : ''); ?> value="HEAP">Heap</option>
 548                 <option <?php echo (isset($tbl_type) && $tbl_type == 'MERGE' ? 'selected="checked"' : ''); ?> value="MERGE">Merge</option>
 549                 <?php if (isset($tbl_bdb)) { ?><option <?php echo (isset($tbl_type) && $tbl_type == 'BDB' ? 'selected="checked"' : ''); ?> value="BDB">Berkeley DB</option><?php } ?>
 550                 <?php if (isset($tbl_gemini)) { ?><option <?php echo (isset($tbl_type) && $tbl_type == 'GEMINI' ? 'selected="checked"' : ''); ?> value="GEMINI">Gemini</option><?php } ?>
 551                 <?php if (isset($tbl_innodb)) { ?><option <?php echo (isset($tbl_type) && $tbl_type == 'INNO DB' ? 'selected="checked"' : ''); ?> value="InnoDB">INNO DB</option><?php } ?>
 552                 <?php if (isset($tbl_isam)) { ?><option <?php echo (isset($tbl_type) && $tbl_type == 'ISAM' ? 'selected="checked"' : ''); ?> value="ISAM">ISAM</option><?php } ?>
 553             </select>
 554         </td>
 555         <?php
 556     }
 557     echo "\n";
 558     ?>
 559         </tr>
 560     </table>
 561     <br />
 562     <?php
 563 }
 564 echo "\n";
 565 // END - Table Type - 2 May 2001 - Robbat2
 566 ?>
 567
 568 <input type="submit" name="submit" value="<?php echo $strSave; ?>" />
 569 </form>
 570
 571 <table>
 572 <tr>
 573     <td valign="top">*&nbsp;</td>
 574     <td>
 575         <?php echo $strSetEnumVal . "\n"; ?>
 576     </td>
 577 </tr>
 578 <tr>
 579     <td valign="top">**&nbsp;</td>
 580     <td>
 581         <?php echo $strDefaultValueHelp . "\n"; ?>
 582     </td>
 583 </tr>
 584
 585 <?php
 586 if ($cfgRelation['commwork'] && $cfgRelation['mimework'] && $cfg['BrowseMIME']) {
 587 ?>
 588 <tr>
 589     <td valign="top" rowspan="2">***&nbsp;</td>
 590     <td>
 591         <?php echo $strMIME_transformation_options_note  . "\n"; ?>
 592     </td>
 593 </tr>
 594
 595 <tr>
 596     <td>
 597         <?php echo sprintf($strMIME_transformation_note, '<a href="libraries/transformations/overview.php3?' . PMA_generate_common_url($db, $table) . '" target="_new">', '</a>') . "\n"; ?>
 598     </td>
 599 </tr>
 600 <?php
 601 }
 602 ?>
 603
 604 </table>
 605 <br />
 606
 607 <center><?php echo PMA_showMySQLDocu('Reference', 'CREATE_TABLE'); ?></center>