summaryrefslogtreecommitdiff
path: root/db/migrate/20221221171239_rename_amount_used_column.rb
blob: f25407a85afea35ca582563d38bdaee2b2e902ed (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
# frozen_string_literal: true

class RenameAmountUsedColumn < Gitlab::Database::Migration[2.1]
  TRIGGER_NAME = 'sync_projects_amount_used_columns'
  def up
    rename_column :ci_project_monthly_usages, :amount_used, :tmp_amount_used
    rename_column :ci_project_monthly_usages, :new_amount_used, :amount_used
    rename_column :ci_project_monthly_usages, :tmp_amount_used, :new_amount_used

    remove_rename_triggers(:ci_project_monthly_usages, TRIGGER_NAME)
    install_rename_triggers(:ci_project_monthly_usages, :amount_used, :new_amount_used, trigger_name: TRIGGER_NAME)
  end

  def down
    rename_column :ci_project_monthly_usages, :amount_used, :tmp_amount_used
    rename_column :ci_project_monthly_usages, :new_amount_used, :amount_used
    rename_column :ci_project_monthly_usages, :tmp_amount_used, :new_amount_used

    remove_rename_triggers(:ci_project_monthly_usages, TRIGGER_NAME)
    install_rename_triggers(:ci_project_monthly_usages, :amount_used, :new_amount_used, trigger_name: TRIGGER_NAME)
  end
end