diff --git a/htdocs/sql/tbl_addfield.php b/htdocs/sql/tbl_addfield.php new file mode 100755 --- /dev/null +++ b/htdocs/sql/tbl_addfield.php @@ -0,0 +1,236 @@ + $fieldcomment) { + if (isset($field_name[$fieldindex]) && strlen($field_name[$fieldindex])) { + PMA_setComment($db, $table, $field_name[$fieldindex], $fieldcomment, '', 'pmadb'); + } + } + } + + // garvin: Update comment table for mime types [MIME] + if (isset($field_mimetype) && is_array($field_mimetype) && $cfgRelation['commwork'] && $cfgRelation['mimework'] && $cfg['BrowseMIME']) { + foreach ($field_mimetype AS $fieldindex => $mimetype) { + if (isset($field_name[$fieldindex]) && strlen($field_name[$fieldindex])) { + PMA_setMIME($db, $table, $field_name[$fieldindex], $mimetype, $field_transformation[$fieldindex], $field_transformation_options[$fieldindex]); + } + } + } + + // Go back to the structure sub-page + $sql_query = $sql_query_cpy; + unset($sql_query_cpy); + $message = $strTable . ' ' . htmlspecialchars($table) . ' ' . $strHasBeenAltered; + $active_page = 'tbl_structure.php'; + require './tbl_structure.php'; + } else { + PMA_mysqlDie('', '', '', $err_url, FALSE); + // garvin: An error happened while inserting/updating a table definition. + // to prevent total loss of that data, we embed the form once again. + // The variable $regenerate will be used to restore data in libraries/tbl_properties.inc.php + $num_fields = $orig_num_fields; + if (isset($orig_after_field)) { + $after_field = $orig_after_field; + } + if (isset($orig_field_where)) { + $field_where = $orig_field_where; + } + $regenerate = true; + } +} // end do alter table + +/** + * Displays the form used to define the new field + */ +if ($abort == FALSE) { + /** + * Gets tables informations + */ + require_once './libraries/tbl_common.php'; + require_once './libraries/tbl_info.inc.php'; + /** + * Displays top menu links + */ + $active_page = 'tbl_structure.php'; + require_once './libraries/tbl_links.inc.php'; + /** + * Display the form + */ + $action = 'tbl_addfield.php'; + require_once './libraries/tbl_properties.inc.php'; + + // Diplays the footer + echo "\n"; + require_once './libraries/footer.inc.php'; +} + +?>