From e15fa25639e96c7c1582d793b5b6c22c1969d2f9 Mon Sep 17 00:00:00 2001 From: Gabriel Ebner Date: Sat, 3 May 2008 14:56:43 +0000 Subject: [PATCH] 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.) --- db/migrate/012_add_user_preference_id.rb | 6 ++++-- 1 file changed, 4 insertions(+), 2 deletions(-) diff --git a/db/migrate/012_add_user_preference_id.rb b/db/migrate/012_add_user_preference_id.rb index 7357ca9b2..e644e87a1 100644 --- 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 - 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 -- 2.43.2