4, 4.1.y y>12 and also works in 4.0.11, so I decided not to // check for version if ($tbl_type == 'MYISAM' || $tbl_type == 'INNODB') { $sql_query .= !empty($new_auto_increment) ? ' auto_increment=' . PMA_sqlAddslashes($new_auto_increment) : ''; } $result = PMA_DBI_query($sql_query); $message = $strSuccess; $reread_info = TRUE; } if ($reread_info) { require('./tbl_properties_table_info.php'); } unset($reread_info); /** * Reordering the table has been requested by the user */ if (isset($submitorderby) && !empty($order_field)) { $sql_query = 'ALTER TABLE ' . PMA_backquote($table) . ' ORDER BY ' . PMA_backquote(urldecode($order_field)); if (isset($order_order) && $order_order == 'desc') { $sql_query .= ' DESC'; } $result = PMA_DBI_query($sql_query); $message = $result ? $strSuccess : $strError; } // end if /** * Gets tables informations */ require_once('./tbl_properties_table_info.php'); /** * Displays top menu links */ require_once('./tbl_properties_links.php'); /** * Get columns names */ $local_query = 'SHOW COLUMNS FROM ' . PMA_backquote($table) . ' FROM ' . PMA_backquote($db); $result = PMA_DBI_query($local_query); for ($i = 0; $row = PMA_DBI_fetch_assoc($result); $i++) { $columns[$i] = $row['Field']; } PMA_DBI_free_result($result); unset($result); ?> = 32334) { ?> = 40100) { echo "\n" . '' . "\n" . ' ' . "\n" . ' ' . "\n" . ' ' . "\n" . ' ' . "\n" . ' ' . "\n" . ' ' . "\n" . ' ' . "\n" . ' ' . "\n" . ' ' . "\n" . ' ' . "\n"; } // PACK_KEYS: MyISAM or ISAM // DELAY_KEY_WRITE, CHECKSUM, : MyISAM only // AUTO_INCREMENT: MyISAM and InnoDB since 5.0.3 // nijel: Here should be version check for InnoDB, however it is supported // in 5.0.x x>4, 4.1.y y>12 and also works in 4.0.11, so I decided not to // check for version if ($tbl_type == 'MYISAM' || $tbl_type == 'ISAM' || $tbl_type == 'INNODB') { ?>

:
$fieldname) { echo ' ' . htmlspecialchars($fieldname) . '' . "\n"; } unset($columns); ?>
:
' . htmlspecialchars($dblist[$i]) . ''; echo "\n"; } // end for ?>  .
' . htmlspecialchars($dblist[$i]) . ''; echo "\n"; } // end for ?>  .
style="vertical-align: middle" />
:
' . "\n" . PMA_generate_common_hidden_inputs($db, $table, 3) . ' ' . $strCollation . ': ' . "\n" . '
' . "\n" . PMA_generateCharsetDropdownBox(PMA_CSDROPDOWN_COLLATION, 'tbl_collation', NULL, $tbl_collation, FALSE, 3) . '	' . "\n" . ' ' . "\n" . '
:
style="vertical-align: middle" />pack_keys style="vertical-align: middle" />checksum style="vertical-align: middle" />delay_key_write style="width: 30px; vertical-align: middle" /> auto_increment

$arr) { $join_query = 'SELECT ' . PMA_backquote($table) . '.* FROM ' . PMA_backquote($table) . ' LEFT JOIN ' . PMA_backquote($arr['foreign_table']); if ($arr['foreign_table'] == $table) { $foreign_table = $table . '1'; $join_query .= ' AS ' . PMA_backquote($foreign_table); } else { $foreign_table = $arr['foreign_table']; } $join_query .= ' ON ' . PMA_backquote($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($table) . '.' . PMA_backquote($master) . ' IS NOT NULL'; echo ' ' . '' . $master . ' -> ' . $arr['foreign_table'] . '.' . $arr['foreign_field'] . ' ' . "\n"; unset($foreign_table); unset($join_query); } // end while ?>