dawarich/db/migrate/20241226202831_validate_add_database_users_constraints.rb

15 lines
450 B
Ruby
Raw Permalink Normal View History

# frozen_string_literal: true
class ValidateAddDatabaseUsersConstraints < ActiveRecord::Migration[8.0]
def up
validate_check_constraint :users, name: 'users_email_null'
change_column_null :users, :email, false
remove_check_constraint :users, name: 'users_email_null'
end
def down
add_check_constraint :users, 'email IS NOT NULL', name: 'users_email_null', validate: false
change_column_null :users, :email, true
end
end