broad-announce/migrations/011_sources_secrets.down.sql

-- 010_sources_secrets.down.sql
--
-- Reverts 010_sources_secrets. Drops the columns added in W2.
-- WARNING: this is destructive in the sense that it deletes any
-- HMAC/API key hashes and the mtls_required flag. Sources
-- created under W2 will fall back to the M0 env-based auth.

ALTER TABLE sources
    DROP COLUMN IF EXISTS description,
    DROP COLUMN IF EXISTS mtls_required,
    DROP COLUMN IF EXISTS api_key_hash,
    DROP COLUMN IF EXISTS hmac_secret_hash;