about summary refs log tree commit diff
path: root/db/migrate/20200719184152_add_unpublished_index_to_statuses.rb
blob: ee6d3e9424c21426fd70e11f15617043e4f3c49e (plain) (blame)
1
2
3
4
5
6
7
class AddUnpublishedIndexToStatuses < ActiveRecord::Migration[5.2]
  disable_ddl_transaction!

  def change
    add_index :statuses, [:account_id, :id], where: '(deleted_at IS NULL) AND (published = FALSE)', order: { id: :desc }, algorithm: :concurrently, name: :index_unpublished_statuses
  end
end