diff -ur mysql-gui-common/library/source/myx_database_model.c mysql-gui-common.new/library/source/myx_database_model.c
--- mysql-gui-common/library/source/myx_database_model.c	2005-10-01 20:32:14.000000000 +0200
+++ mysql-gui-common.new/library/source/myx_database_model.c	2005-10-05 23:54:15.000000000 +0200
@@ -1660,30 +1660,6 @@
       char previous_column_name[256];
       strcpy(previous_column_name, "");
 
-      // check whether the name of the last existing column was changed
-      // and use the new name in the AFTER clause if so
-      for(j= existing_table->columns_num - 1; j >= 0; j--)
-      {
-        //j= existing_table->columns_num-1;
-        for(i= 0; i < altered_table->columns_num; i++)
-        {
-          if(NAMECMP(altered_table->columns[i].original_name, existing_table->columns[j].name) == 0)
-          {
-            strcpy(previous_column_name, altered_table->columns[i].name);
-            j= -1;
-            break;
-          }
-        }
-        if(j == -1) 
-        {
-          break;
-        }
-      }
-//      if(j != -1)
-//      {
-//        strcpy(previous_column_name, existing_table->columns[j].name);
-//      }
-
       //Add new columns
       for(i= 0; i < altered_table->columns_num; i++)
       {
@@ -1703,17 +1679,17 @@
         {
           tmp2= myx_dbm_get_sql_column_create_code(column, version);
 
-          if(existing_table->columns_num == 0)
+          if(existing_table->columns_num == 0 || strcmp(previous_column_name,"") == 0)
             tmp= g_strdup_printf("," _br " ADD COLUMN %s FIRST", tmp2);
           else
             tmp= g_strdup_printf("," _br " ADD COLUMN %s AFTER `%s`", tmp2, previous_column_name);
 
-          strcpy(previous_column_name, column->name);
-
           alter_spec= str_g_append(alter_spec, tmp);
           g_free(tmp);
           g_free(tmp2);
         }
+
+        strcpy(previous_column_name, column->name);
       }
     }