mastodon/db/migrate/20210425135952_add_index_on_media_attachments_account_id_status_id.rb

class AddIndexOnMediaAttachmentsAccountIdStatusId < ActiveRecord::Migration[5.2]
  disable_ddl_transaction!

  def up
    add_index :media_attachments, [:account_id, :status_id], order: { status_id: :desc }, algorithm: :concurrently
    remove_index :media_attachments, :account_id, algorithm: :concurrently
  end

  def down
    add_index :media_attachments, :account_id, algorithm: :concurrently
    remove_index :media_attachments, [:account_id, :status_id], order: { status_id: :desc }, algorithm: :concurrently
  end
end