add note table user_id, created_at index for non-anonymus notes

[rails.git] / db / migrate / 20250304172798_add_notes_user_id_created_at_index.rb

class AddNotesUserIdCreatedAtIndex < ActiveRecord::Migration[7.2]
  disable_ddl_transaction!

  def change
    add_index :notes, [:user_id, :created_at],
              :algorithm => :concurrently,
              :where => "user_id IS NOT NULL"
  end
end