2 /* vim: set expandtab sw=4 ts=4 sts=4: */
4 * Display form for changing/adding table fields/columns.
5 * Included by tbl_addfield.php and tbl_create.php
9 use PMA\libraries\Response
;
10 use PMA\libraries\Table
;
11 use PMA\libraries\Transformations
;
14 if (!defined('PHPMYADMIN')) {
21 require_once 'libraries/util.lib.php';
23 PMA\libraries\Util
::checkParameters(
24 array('server', 'db', 'table', 'action', 'num_fields')
30 * Initialize to avoid code execution path warnings
33 if (!isset($num_fields)) {
36 if (!isset($mime_map)) {
39 if (!isset($columnMeta)) {
40 $columnMeta = array();
43 $length_values_input_size = 8;
45 $content_cells = array();
47 /** @var string $db */
52 if ($action == 'tbl_create.php') {
53 $form_params['reload'] = 1;
55 if ($action == 'tbl_addfield.php') {
56 $form_params = array_merge(
58 'field_where' => Util\
get($_REQUEST, 'field_where'))
60 if (isset($_REQUEST['field_where'])) {
61 $form_params['after_field'] = $_REQUEST['after_field'];
64 $form_params['table'] = $table;
67 if (isset($num_fields)) {
68 $form_params['orig_num_fields'] = $num_fields;
71 $form_params = array_merge(
74 'orig_field_where' => Util\
get($_REQUEST, 'field_where'),
75 'orig_after_field' => Util\
get($_REQUEST, 'after_field'),
79 if (isset($selected) && is_array($selected)) {
80 foreach ($selected as $o_fld_nr => $o_fld_val) {
81 $form_params['selected[' . $o_fld_nr . ']'] = $o_fld_val;
85 $is_backup = ($action != 'tbl_create.php' && $action != 'tbl_addfield.php');
87 $cfgRelation = PMA_getRelationsParam();
89 $comments_map = PMA_getComments($db, $table);
91 $move_columns = array();
92 if (isset($fields_meta)) {
93 /** @var PMA\libraries\DatabaseInterface $dbi */
94 $dbi = \PMA\libraries\di\Container
::getDefaultContainer()->get('dbi');
95 $move_columns = $dbi->getTable($db, $table)->getColumnsMeta();
98 $available_mime = array();
99 if ($cfgRelation['mimework'] && $GLOBALS['cfg']['BrowseMIME']) {
100 $mime_map = Transformations
::getMIME($db, $table);
101 $available_mime = Transformations
::getAvailableMIMEtypes();
104 // workaround for field_fulltext, because its submitted indices contain
105 // the index as a value, not a key. Inserted here for easier maintenance
106 // and less code to change in existing files.
107 if (isset($field_fulltext) && is_array($field_fulltext)) {
108 foreach ($field_fulltext as $fulltext_nr => $fulltext_indexkey) {
109 $submit_fulltext[$fulltext_indexkey] = $fulltext_indexkey;
112 if (isset($_REQUEST['submit_num_fields'])
113 ||
isset($_REQUEST['submit_partition_change'])
115 //if adding new fields, set regenerate to keep the original values
119 $foreigners = PMA_getForeigners($db, $table, '', 'foreign');
120 $child_references = null;
121 // From MySQL 5.6.6 onwards columns with foreign keys can be renamed.
122 // Hence, no need to get child references
123 if (PMA_MYSQL_INT_VERSION
< 50606) {
124 $child_references = PMA_getChildReferences($db, $table);
127 for ($columnNumber = 0; $columnNumber < $num_fields; $columnNumber++
) {
131 $columnMeta = array();
132 $submit_attribute = null;
133 $extracted_columnspec = array();
135 if (!empty($regenerate)) {
137 $columnMeta = array_merge(
141 $_REQUEST, "field_name.${columnNumber}", false
144 $_REQUEST, "field_type.${columnNumber}", false
146 'Collation' => Util\
get(
147 $_REQUEST, "field_collation.${columnNumber}", ''
150 $_REQUEST, "field_null.${columnNumber}", ''
152 'DefaultType' => Util\
get(
153 $_REQUEST, "field_default_type.${columnNumber}", 'NONE'
155 'DefaultValue' => Util\
get(
156 $_REQUEST, "field_default_value.${columnNumber}", ''
159 $_REQUEST, "field_extra.${columnNumber}", false
161 'Virtuality' => Util\
get(
162 $_REQUEST, "field_virtuality.${columnNumber}", ''
164 'Expression' => Util\
get(
165 $_REQUEST, "field_expression.${columnNumber}", ''
170 $columnMeta['Key'] = '';
172 '_', Util\
get($_REQUEST, "field_key.${columnNumber}", ''), 2
174 if (count($parts) == 2 && $parts[1] == $columnNumber) {
175 $columnMeta['Key'] = Util\
get(
180 'fulltext' => 'FULLTEXT',
181 'spatial' => 'SPATIAL'
187 $columnMeta['Comment']
188 = isset($submit_fulltext[$columnNumber])
189 && ($submit_fulltext[$columnNumber] == $columnNumber)
190 ?
'FULLTEXT' : false;
192 switch ($columnMeta['DefaultType']) {
194 $columnMeta['Default'] = null;
197 $columnMeta['Default'] = $columnMeta['DefaultValue'];
200 case 'CURRENT_TIMESTAMP':
201 $columnMeta['Default'] = $columnMeta['DefaultType'];
205 $length = Util\
get($_REQUEST, "field_length.${columnNumber}", $length);
206 $submit_attribute = Util\
get(
207 $_REQUEST, "field_attribute.${columnNumber}", false
209 $comments_map[$columnMeta['Field']] = Util\
get(
210 $_REQUEST, "field_comments.${columnNumber}"
213 $mime_map[$columnMeta['Field']] = array_merge(
214 $mime_map[$columnMeta['Field']],
216 'mimetype' => Util\
get($_REQUEST, "field_mimetype.${$columnNumber}"),
217 'transformation' => Util\
get(
218 $_REQUEST, "field_transformation.${$columnNumber}"
220 'transformation_options' => Util\
get(
221 $_REQUEST, "field_transformation_options.${$columnNumber}"
226 } elseif (isset($fields_meta[$columnNumber])) {
227 $columnMeta = $fields_meta[$columnNumber];
229 'VIRTUAL', 'PERSISTENT', 'VIRTUAL GENERATED', 'STORED GENERATED'
231 if (in_array($columnMeta['Extra'], $virtual)) {
232 $tableObj = new Table($GLOBALS['table'], $GLOBALS['db']);
233 $expressions = $tableObj->getColumnGenerationExpression(
236 $columnMeta['Expression'] = $expressions[$columnMeta['Field']];
238 switch ($columnMeta['Default']) {
240 if (is_null($columnMeta['Default'])) { // null
241 if ($columnMeta['Null'] == 'YES') {
242 $columnMeta['DefaultType'] = 'NULL';
243 $columnMeta['DefaultValue'] = '';
245 $columnMeta['DefaultType'] = 'NONE';
246 $columnMeta['DefaultValue'] = '';
249 $columnMeta['DefaultType'] = 'USER_DEFINED';
250 $columnMeta['DefaultValue'] = $columnMeta['Default'];
253 case 'CURRENT_TIMESTAMP':
254 $columnMeta['DefaultType'] = 'CURRENT_TIMESTAMP';
255 $columnMeta['DefaultValue'] = '';
258 $columnMeta['DefaultType'] = 'USER_DEFINED';
259 $columnMeta['DefaultValue'] = $columnMeta['Default'];
264 if (isset($columnMeta['Type'])) {
265 $extracted_columnspec = PMA\libraries\Util
::extractColumnSpec(
268 if ($extracted_columnspec['type'] == 'bit') {
269 $columnMeta['Default']
270 = PMA\libraries\Util
::convertBitDefaultValue($columnMeta['Default']);
272 $type = $extracted_columnspec['type'];
274 $length = $extracted_columnspec['spec_in_brackets'];
278 $columnMeta['Type'] = '';
281 // Variable tell if current column is bound in a foreign key constraint or not.
282 // MySQL version from 5.6.6 allow renaming columns with foreign keys
283 if (isset($columnMeta['Field'])
284 && isset($form_params['table'])
285 && PMA_MYSQL_INT_VERSION
< 50606
287 $columnMeta['column_status'] = PMA_checkChildForeignReferences(
289 $form_params['table'],
290 $columnMeta['Field'],
296 // some types, for example longtext, are reported as
297 // "longtext character set latin7" when their charset and / or collation
298 // differs from the ones of the corresponding database.
299 // rtrim the type, for cases like "float unsigned"
301 preg_replace('/[\s]character set[\s][\S]+/', '', $type)
305 * old column attributes
310 if (isset($columnMeta['Field'])) {
311 $form_params['field_orig[' . $columnNumber . ']']
312 = $columnMeta['Field'];
313 if (isset($columnMeta['column_status'])
314 && !$columnMeta['column_status']['isEditable']
316 $form_params['field_name[' . $columnNumber . ']']
317 = $columnMeta['Field'];
320 $form_params['field_orig[' . $columnNumber . ']'] = '';
324 if (isset($columnMeta['Type'])) {
325 // keep in uppercase because the new type will be in uppercase
326 $form_params['field_type_orig[' . $columnNumber . ']'] = mb_strtoupper($type);
327 if (isset($columnMeta['column_status'])
328 && !$columnMeta['column_status']['isEditable']
330 $form_params['field_type[' . $columnNumber . ']'] = mb_strtoupper($type);
333 $form_params['field_type_orig[' . $columnNumber . ']'] = '';
337 $form_params['field_length_orig[' . $columnNumber . ']'] = $length;
339 // old column default
340 $form_params = array_merge(
343 "field_default_value_orig[${columnNumber}]" => Util\
get(
344 $columnMeta, 'Default', ''
346 "field_default_type_orig[${columnNumber}]" => Util\
get(
347 $columnMeta, 'DefaultType', ''
349 "field_collation_orig[${columnNumber}]" => Util\
get(
350 $columnMeta, 'Collation', ''
352 "field_attribute_orig[${columnNumber}]" => trim(
353 Util\
get($extracted_columnspec, 'attribute', '')
355 "field_null_orig[${columnNumber}]" => Util\
get(
356 $columnMeta, 'Null', ''
358 "field_extra_orig[${columnNumber}]" => Util\
get(
359 $columnMeta, 'Extra', ''
361 "field_comments_orig[${columnNumber}]" => Util\
get(
362 $columnMeta, 'Comment', ''
364 "field_virtuality_orig[${columnNumber}]" => Util\
get(
365 $columnMeta, 'Virtuality', ''
367 "field_expression_orig[${columnNumber}]" => Util\
get(
368 $columnMeta, 'Expression', ''
374 $content_cells[$columnNumber] = array(
375 'columnNumber' => $columnNumber,
376 'columnMeta' => $columnMeta,
377 'type_upper' => mb_strtoupper($type),
378 'length_values_input_size' => $length_values_input_size,
380 'extracted_columnspec' => $extracted_columnspec,
381 'submit_attribute' => $submit_attribute,
382 'comments_map' => $comments_map,
383 'fields_meta' => isset($fields_meta) ?
$fields_meta : null,
384 'is_backup' => $is_backup,
385 'move_columns' => $move_columns,
386 'cfgRelation' => $cfgRelation,
387 'available_mime' => $available_mime,
388 'mime_map' => isset($mime_map) ?
$mime_map : array()
392 include 'libraries/tbl_partition_definition.inc.php';
393 $html = PMA\libraries\Template
::get('columns_definitions/column_definitions_form')
396 'is_backup' => $is_backup,
397 'fields_meta' => isset($fields_meta) ?
$fields_meta : null,
398 'mimework' => $cfgRelation['mimework'],
400 'form_params' => $form_params,
401 'content_cells' => $content_cells,
402 'partitionDetails' => $partitionDetails
408 $response = Response
::getInstance();
409 $response->getHeader()->getScripts()->addFiles(
411 'jquery/jquery.uitablefilter.js',
415 $response->addHTML($html);