$field_index[] = $i; } if (${'field_key_' . $i} == 'unique_' . $i) { $field_unique[] = $i; } } // end if } // end for // Builds the field creation statement and alters the table for ($i = 0; $i < $field_cnt; ++$i) { // '0' is also empty for php :-( if (empty($field_name[$i]) && $field_name[$i] != '0') { continue; } $query .= PMA_generateFieldSpec($field_name[$i], $field_type[$i], $field_length[$i], $field_attribute[$i], isset($field_collation[$i]) ? $field_collation[$i] : '', $field_null[$i], $field_default[$i], isset($field_default_current_timestamp[$i]), $field_extra[$i], isset($field_comments[$i]) ? $field_comments[$i] : '', $field_primary, $i); if ($field_where != 'last') { // Only the first field can be added somewhere other than at the end if ($i == 0) { if ($field_where == 'first') { $query .= ' FIRST'; } else { $query .= ' AFTER ' . PMA_backquote(urldecode($after_field)); } } else { $query .= ' AFTER ' . PMA_backquote($field_name[$i - 1]); } } $query .= ', ADD '; } // end for
function PMA_generateAlterTable($oldcol, $newcol, $type, $length, $attribute, $collation, $null, $default, $default_current_timestamp, $extra, $comment = '', $default_orig) { $empty_a = array(); return PMA_backquote($oldcol) . ' ' . PMA_generateFieldSpec($newcol, $type, $length, $attribute, $collation, $null, $default, $default_current_timestamp, $extra, $comment, $empty_a, -1, $default_orig); }