debian-mirror-gitlab/db/migrate/20230322162512_add_valid_deploy_access_level_constraint.rb
2023-06-20 00:43:36 +05:30

17 lines
516 B
Ruby

# frozen_string_literal: true
class AddValidDeployAccessLevelConstraint < Gitlab::Database::Migration[2.1]
disable_ddl_transaction!
CONSTRAINT_NAME = 'check_deploy_access_levels_user_group_access_level_any_not_null'
CONSTRAINT = '(num_nonnulls(user_id, group_id, access_level) = 1)'
def up
add_check_constraint :protected_environment_deploy_access_levels, CONSTRAINT, CONSTRAINT_NAME
end
def down
remove_check_constraint :protected_environment_deploy_access_levels, CONSTRAINT_NAME
end
end