rails_port: fix migration to create a primary key with auto increment (don't

know if that will actually generate valid keys if there is already data in the
table.)

diff --git a/db/migrate/012_add_user_preference_id.rb b/db/migrate/012_add_user_preference_id.rb
index 7357ca9b270ab45955753e16d65cc67af662e009..e644e87a136541e99a2f723c714f74ab1a54fd02 100644 (file)
--- a/db/migrate/012_add_user_preference_id.rb
+++ b/db/migrate/012_add_user_preference_id.rb
@@ -1,7 +1,9 @@
 class AddUserPreferenceId < ActiveRecord::Migration
   def self.up
 class AddUserPreferenceId < ActiveRecord::Migration
   def self.up

-    remove_index 'user_preferences', ['id', 'k']
-    add_column "user_preferences", "id", :bigint, :limit => 64, :null => false, :options => "AUTO_INCREMENT"
+    remove_primary_key 'user_preferences'
+    add_column "user_preferences", "id", :bigint, :limit => 64, :null => false
+    add_primary_key "user_preferences", ["id"]
+    change_column "user_preferences", "id", :bigint, :limit => 64, :null => false, :options => "AUTO_INCREMENT"

     add_index "user_preferences", ["id"], :name => "user_preferences_id_idx"
   end
 
     add_index "user_preferences", ["id"], :name => "user_preferences_id_idx"
   end