debian-mirror-gitlab/db/post_migrate/20230213103019_add_index_for_next_over_limit_check_at.rb
2023-05-27 22:25:52 +05:30

18 lines
438 B
Ruby

# frozen_string_literal: true
class AddIndexForNextOverLimitCheckAt < Gitlab::Database::Migration[2.1]
TABLE_NAME = 'namespace_details'
INDEX_NAME = 'index_next_over_limit_check_at_asc_order'
def up
prepare_async_index TABLE_NAME,
:next_over_limit_check_at,
order: { next_over_limit_check_at: 'ASC NULLS FIRST' },
name: INDEX_NAME
end
def down
unprepare_async_index TABLE_NAME, INDEX_NAME
end
end