discourse/db/migrate/20240506035024_clear_orphaned_draft_upload_references.rb

# frozen_string_literal: true

class ClearOrphanedDraftUploadReferences < ActiveRecord::Migration[7.0]
  def up
    execute <<~SQL
      DELETE
      FROM
        "upload_references"
      WHERE
        "upload_references"."target_type" = 'Draft' AND
        "upload_references"."target_id" NOT IN (
          SELECT "drafts"."id" FROM "drafts"
        )
    SQL
  end

  def down
    raise ActiveRecord::IrreversibleMigration
  end
end