-- Track who acknowledged an advice — 'user' (manual click in dashboard),
-- 'apply' (auto after Apply with AI), 'verify' (auto by daemon's
-- verify thread after observing the issue is no longer present).
-- The dashboard surfaces this so users can audit auto-acks.
--
-- Apply once after 0001..0009. Idempotent.

alter table public.worker_events
    add column if not exists acked_by text;

-- Allow authenticated UPDATE on the new column too, alongside acked_at.
grant update (acked_by) on public.worker_events to authenticated;
