add index to revoked at.

2 files changed, 3 insertions, 0 deletions

diff --git a/db/migrate/20141115170606_add_revoked_at_to_sessions.rb b/db/migrate/20141115170606_add_revoked_at_to_sessions.rb
index 9c4146b..8804e1a 100644
--- a/db/migrate/20141115170606_add_revoked_at_to_sessions.rb
+++ b/db/migrate/20141115170606_add_revoked_at_to_sessions.rb
@@ -1,5 +1,6 @@
 class AddRevokedAtToSessions < ActiveRecord::Migration
   def change
     add_column :sessions, :revoked_at, :datetime, default: nil
+    add_index :sessions, :revoked_at
   end
 end
diff --git a/db/schema.rb b/db/schema.rb
index aabcd6c..021eeba 100644
--- a/db/schema.rb
+++ b/db/schema.rb
@@ -52,6 +52,8 @@ ActiveRecord::Schema.define(version: 20141115170606) do
     t.datetime "revoked_at"
   end
 
+  add_index "sessions", ["revoked_at"], name: "index_sessions_on_revoked_at", using: :btree
+
   create_table "users", force: true do |t|
     t.string   "email"
     t.string   "password_digest"