mastodon/db/migrate/20210630000137_fix_canonical_email_blocks_foreign_key.rb

# frozen_string_literal: true

class FixCanonicalEmailBlocksForeignKey < ActiveRecord::Migration[6.1]
  def up
    safety_assured do
      execute <<~SQL.squish
        ALTER TABLE canonical_email_blocks
          DROP CONSTRAINT fk_rails_1ecb262096,
          ADD CONSTRAINT fk_rails_1ecb262096
            FOREIGN KEY (reference_account_id)
            REFERENCES accounts(id)
            ON DELETE CASCADE
      SQL
    end
  end

  def down
    safety_assured do
      execute <<~SQL.squish
        ALTER TABLE canonical_email_blocks
          DROP CONSTRAINT fk_rails_1ecb262096,
          ADD CONSTRAINT fk_rails_1ecb262096
            FOREIGN KEY (reference_account_id)
            REFERENCES accounts(id)
      SQL
    end
  end
end