$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
Example #2
0
 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);
 }