From 8de014935a2946fb36a8dcde0cd5ee409c54e793 Mon Sep 17 00:00:00 2001 From: Tom Hughes Date: Thu, 14 Jan 2010 18:37:52 +0000 Subject: [PATCH] Add the changeset id to the user index so the next/previous user links can be resolved quickly. --- db/migrate/049_improve_changeset_user_index.rb | 11 +++++++++++ 1 file changed, 11 insertions(+) create mode 100644 db/migrate/049_improve_changeset_user_index.rb diff --git a/db/migrate/049_improve_changeset_user_index.rb b/db/migrate/049_improve_changeset_user_index.rb new file mode 100644 index 000000000..af5d1a2ac --- /dev/null +++ b/db/migrate/049_improve_changeset_user_index.rb @@ -0,0 +1,11 @@ +class ImproveChangesetUserIndex < ActiveRecord::Migration + def self.up + add_index :changesets, [:user_id, :id], :name => "changesets_user_id_id_idx" + remove_index :changesets, :name => "changesets_user_id_idx" + end + + def self.down + add_index :changesets, [:user_id], :name => "changesets_user_id_idx" + remove_index :changesets, [:user_id, :id], :name => "changesets_user_id_id_idx" + end +end -- 2.43.2