discourse/db/migrate/20160719002225_add_deleted_post_index_to_posts.rb

# frozen_string_literal: true

class AddDeletedPostIndexToPosts < ActiveRecord::Migration[4.2]
  def change
    add_index :posts,
              %i[topic_id post_number],
              where: "deleted_at IS NOT NULL",
              name: "idx_posts_deleted_posts"
  end
end