summaryrefslogtreecommitdiff
path: root/db/migrate/20220301091503_add_not_null_constraint_to_security_policy_configurations.rb
blob: 79ffcb2cbb32866dde03d34acb35aa327a1d340a (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
# frozen_string_literal: true

class AddNotNullConstraintToSecurityPolicyConfigurations < Gitlab::Database::Migration[1.0]
  disable_ddl_transaction!

  def up
    change_column_null :security_orchestration_policy_configurations, :project_id, true
  end

  def down
    exec_query 'DELETE FROM security_orchestration_policy_configurations WHERE project_id IS NULL'
    change_column_null :security_orchestration_policy_configurations, :project_id, false
  end
end