From 672df4ecc0d0563c58877a878264b9807102ecf0 Mon Sep 17 00:00:00 2001 From: takayamaki Date: Tue, 5 Sep 2017 19:30:01 +0900 Subject: add index_notifications_on_id_and_account_id_and_activity_type on notifications table (#4750) --- ...5044538_add_index_id_account_id_activity_type_on_notifications.rb | 5 +++++ 1 file changed, 5 insertions(+) create mode 100644 db/migrate/20170905044538_add_index_id_account_id_activity_type_on_notifications.rb (limited to 'db/migrate/20170905044538_add_index_id_account_id_activity_type_on_notifications.rb') 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 -- cgit