about summary refs log tree commit diff
path: root/db/migrate
diff options
context:
space:
mode:
authortakayamaki <fsgiko@gmail.com>2017-09-05 19:30:01 +0900
committerEugen Rochko <eugen@zeonfederated.com>2017-09-05 12:30:01 +0200
commit672df4ecc0d0563c58877a878264b9807102ecf0 (patch)
tree1cba13ad76d762290a5cf8f341ab9911f5857c3c /db/migrate
parentaefb4719bcab6d9a17b3f2fd063f4c2ad455223d (diff)
add index_notifications_on_id_and_account_id_and_activity_type on notifications table (#4750)
Diffstat (limited to 'db/migrate')
-rw-r--r--db/migrate/20170905044538_add_index_id_account_id_activity_type_on_notifications.rb5
1 files changed, 5 insertions, 0 deletions
diff --git a/db/migrate/20170905044538_add_index_id_account_id_activity_type_on_notifications.rb b/db/migrate/20170905044538_add_index_id_account_id_activity_type_on_notifications.rb
new file mode 100644
index 000000000..c47cea9e2
--- /dev/null
+++ b/db/migrate/20170905044538_add_index_id_account_id_activity_type_on_notifications.rb
@@ -0,0 +1,5 @@
+class AddIndexIdAccountIdActivityTypeOnNotifications < ActiveRecord::Migration[5.1]
+  def change
+    add_index :notifications, [:id, :account_id, :activity_type], order: { id: :desc }
+  end
+end