Don't bother creating the user index on user_roles as migration 48 will

create one on user+role that will do the same job.

Removing it here is a bit of a hack as it will not get dropped from
existing databases but as it was not given an explicit name it is hard
to write a migration to drop it.

diff --git a/db/migrate/044_create_user_roles.rb b/db/migrate/044_create_user_roles.rb
index 39e224c0670509f93a286af1b310882e9c972c57..10ec3ee7bf86ab236e8442be3103ffbeda72d084 100644 (file)
--- a/db/migrate/044_create_user_roles.rb
+++ b/db/migrate/044_create_user_roles.rb
@@ -17,7 +17,6 @@ class CreateUserRoles < ActiveRecord::Migration
     remove_column :users, :administrator
 
     add_foreign_key :user_roles, [:user_id], :users, [:id]
-    add_index :user_roles, [:user_id]
   end
 
   def self.down