1 files changed, 11 insertions, 0 deletions
diff --git a/spec/dummy/db/migrate/20110802081561_add_missing_indexes_to_roles_users.rb b/spec/dummy/db/migrate/20110802081561_add_missing_indexes_to_roles_users.rb
new file mode 100644
index 0000000..e72d81f
--- /dev/null
+++ b/spec/dummy/db/migrate/20110802081561_add_missing_indexes_to_roles_users.rb
@@ -0,0 +1,11 @@
+class AddMissingIndexesToRolesUsers < ActiveRecord::Migration
+  def self.up
+    add_index ::Refinery::RolesUsers.table_name, [:role_id, :user_id]
+    add_index ::Refinery::RolesUsers.table_name, [:user_id, :role_id]
+  end
+
+  def self.down
+    remove_index ::Refinery::RolesUsers.table_name, :column => [:role_id, :user_id]
+    remove_index ::Refinery::RolesUsers.table_name, :column => [:user_id, :role_id]
+  end
+end