Retention admin UI + drop legacy shared_with JSONB
New /admin/retention tab visualises every row currently flagged for deletion (documents, chats, tabular reviews) with created-at, flagged-at, and days-since-flag. Admins can restore individual rows inside the grace window via POST /admin/retention/restore or kick the job immediately with POST /admin/retention/run. Migration 0018 drops projects.shared_with and tabular_reviews.shared_with JSONB columns. No app code reads or writes them any more; project_members and review_members have been the source of truth since Phase 3. The companion GIN indexes drop implicitly. API responses still surface a shared_with array derived from the members tables, so the frontend wire shape is unchanged.
| Repository | cpatpa/PIP |
|---|---|
| Author | Claude <noreply@anthropic.com> |
| Authored | |
| Parents | 7d24a909 |
| Stats | 10 files changed , +420 , -24 |
| Part of | Phase 10 - document retention enforcement |
Capture this commit into my fork
Download a Markdown prompt that tells Claude how to port this
exact commit into your working tree. Run it via
claude -p < capture-commit-c91262ac.md
from inside the repo you want the change in.