From: Tom Hughes <tom@compton.nu>
Date: Thu, 1 Oct 2009 20:04:33 +0000 (+0000)
Subject: Don't bother creating the user index on user_roles as migration 48 will
X-Git-Tag: live~6596^2~14
X-Git-Url: https://git.openstreetmap.org/rails.git/commitdiff_plain/4708992f1c9e03596d3f9cfe1965c39affe93b56?ds=sidebyside

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 39e224c06..10ec3ee7b 100644
--- 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