-- Additive: preserve existing supplier relations and enable the shared primary badge.
ALTER TABLE vendor_contacts ADD COLUMN IF NOT EXISTS is_primary BOOLEAN NOT NULL DEFAULT FALSE;