~cytrogen/masto-fe

ref: cc4560d95bae267a8f9281f9f559f8a08b87bd85 masto-fe/db/migrate/20190823221802_add_local_index_to_statuses.rb -rw-r--r-- 513 bytes
cc4560d9 — Claire Change “privacy and reach” settings so that unchecking boxes always increase privacy and checking them always increase reach (#26508) 2 years ago 
                                                                                
1
2
3
4
5
6
7
8
9
10
11
12
13

# frozen_string_literal: true

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

  def up
    add_index :statuses, [:id, :account_id], name: :index_statuses_local_20190824, algorithm: :concurrently, order: { id: :desc }, where: '(local OR (uri IS NULL)) AND deleted_at IS NULL AND visibility = 0 AND reblog_of_id IS NULL AND ((NOT reply) OR (in_reply_to_account_id = account_id))'
  end

  def down
    remove_index :statuses, name: :index_statuses_local_20190824
  end
end