db/migrate/20200731201834_add_foreign_key_to_user_on_experiment_users.rb


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

# frozen_string_literal: true

class AddForeignKeyToUserOnExperimentUsers < ActiveRecord::Migration[6.0]
  include Gitlab::Database::MigrationHelpers

  DOWNTIME = false

  def up
    with_lock_retries do
      # There is no need to use add_concurrent_foreign_key since it's an empty table
      add_foreign_key :experiment_users, :users, column: :user_id, on_delete: :cascade # rubocop:disable Migration/AddConcurrentForeignKey
    end
  end

  def down
    with_lock_retries do
      remove_foreign_key :experiment_users, column: :user_id
    end
  end
end