db/migrate/20230926105908_add_index_to_add_on_purchases_on_last_assigned_users_refreshed_at_and_add_on_id.rb


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17

# frozen_string_literal: true

class AddIndexToAddOnPurchasesOnLastAssignedUsersRefreshedAtAndAddOnId < Gitlab::Database::Migration[2.1]
  disable_ddl_transaction!

  INDEX_NAME = 'idx_addon_purchases_on_last_refreshed_at_desc_nulls_last'

  def up
    add_concurrent_index :subscription_add_on_purchases, %i[last_assigned_users_refreshed_at],
      order: { last_assigned_users_refreshed_at: 'DESC NULLS LAST' },
      name: INDEX_NAME
  end

  def down
    remove_concurrent_index_by_name :subscription_add_on_purchases, INDEX_NAME
  end
end