getColumns($db, $table)) { // table exists already PMA_Util::mysqlDie( sprintf(__('Table %s already exists!'), htmlspecialchars($table)), '', '', 'db_structure.php?' . PMA_generate_common_url($db) ); } $err_url = 'tbl_create.php?' . PMA_generate_common_url($db, $table); // check number of fields to be created if (isset($_REQUEST['submit_num_fields'])) { $regenerate = true; // for libraries/tbl_columns_definition_form.inc.php $num_fields = $_REQUEST['orig_num_fields'] + $_REQUEST['added_fields']; } elseif (isset($_REQUEST['num_fields']) && intval($_REQUEST['num_fields']) > 0) { $num_fields = (int) $_REQUEST['num_fields']; } else { $num_fields = 4; } /** * Selects the database to work with */ if (!$GLOBALS['dbi']->selectDb($db)) { PMA_Util::mysqlDie( sprintf(__('\'%s\' database does not exist.'), htmlspecialchars($db)), '', '', 'index.php' ); } /** * The form used to define the structure of the table has been submitted */ if (isset($_REQUEST['do_save_data'])) { $sql_query = ''; include_once 'libraries/create_addfield.lib.php'; // get column addition statements $sql_statement = PMA_getColumnCreationStatements(true); // Builds the 'create table' statement $sql_query = 'CREATE TABLE ' . PMA_Util::backquote($db) . '.' . PMA_Util::backquote($table) . ' (' . $sql_statement . ')'; // Adds table type, character set, comments and partition definition if (!empty($_REQUEST['tbl_storage_engine']) && ($_REQUEST['tbl_storage_engine'] != 'Default') ) { $sql_query .= ' ENGINE = ' . $_REQUEST['tbl_storage_engine']; } if (!empty($_REQUEST['tbl_collation'])) { $sql_query .= PMA_generateCharsetQueryPart($_REQUEST['tbl_collation']); } if (!empty($_REQUEST['comment'])) { $sql_query .= ' COMMENT = \'' . PMA_Util::sqlAddSlashes($_REQUEST['comment']) . '\''; } if (!empty($_REQUEST['partition_definition'])) { $sql_query .= ' ' . PMA_Util::sqlAddSlashes( $_REQUEST['partition_definition'] ); } $sql_query .= ';'; // Executes the query $result = $GLOBALS['dbi']->tryQuery($sql_query); if ($result) { // If comments were sent, enable relation stuff include_once 'libraries/transformations.lib.php'; // Update comment table for mime types [MIME] if (isset($_REQUEST['field_mimetype']) && is_array($_REQUEST['field_mimetype']) && $cfg['BrowseMIME'] ) { foreach ($_REQUEST['field_mimetype'] as $fieldindex => $mimetype) { if (isset($_REQUEST['field_name'][$fieldindex]) && strlen($_REQUEST['field_name'][$fieldindex]) ) { PMA_setMIME( $db, $table, $_REQUEST['field_name'][$fieldindex], $mimetype, $_REQUEST['field_transformation'][$fieldindex], $_REQUEST['field_transformation_options'][$fieldindex] ); } } } $message = PMA_Message::success(__('Table %1$s has been created.')); $message->addParam( PMA_Util::backquote($db) . '.' . PMA_Util::backquote($table) ); if ($GLOBALS['is_ajax_request'] == true) { /** * construct the html for the newly created table's row to be appended * to the list of tables. * * Logic taken from db_structure.php */ $tbl_url_params = array(); $tbl_url_params['db'] = $db; $tbl_url_params['table'] = $table; $is_show_stats = $cfg['ShowStats']; $tbl_stats_result = $GLOBALS['dbi']->query( 'SHOW TABLE STATUS FROM ' . PMA_Util::backquote($db) . ' LIKE \'' . PMA_Util::sqlAddSlashes($table, true) . '\';' ); $tbl_stats = $GLOBALS['dbi']->fetchAssoc($tbl_stats_result); $GLOBALS['dbi']->freeResult($tbl_stats_result); unset($tbl_stats_result); if ($is_show_stats) { $sum_size = (double) 0; $overhead_size = (double) 0; $overhead_check = ''; $tblsize = doubleval($tbl_stats['Data_length']) + doubleval($tbl_stats['Index_length']); $sum_size += $tblsize; list($formatted_size, $unit) = PMA_Util::formatByteDown( $tblsize, 3, ($tblsize > 0) ? 1 : 0 ); if (isset($tbl_stats['Data_free']) && $tbl_stats['Data_free'] > 0) { list($formatted_overhead, $overhead_unit) = PMA_Util::formatByteDown( $tbl_stats['Data_free'], 3, ($tbl_stats['Data_free'] > 0) ? 1 : 0 ); $overhead_size += $tbl_stats['Data_free']; } if (isset($formatted_overhead)) { $overhead = '' . $formatted_overhead . '' . '' . $overhead_unit . ''; unset($formatted_overhead); } else { $overhead = '-'; } } $new_table_string = '