Ë
    Z­jÎ  ã                   ó8   — d Z ddlmZ dZdZdZdZdZd	d„Zd	d„Z	y)
zôServer-wide secrets set from the Admin page (the Anthropic API key).

Values are encrypted with APP_SECRET_KEY (server env file) before storage, so
database backups hold ciphertext only.

Revision ID: 0004
Revises: 0003
Create Date: 2026-09-18
é    )ÚopÚ0004Ú0003Nzã
CREATE TABLE app_secrets (
    name text PRIMARY KEY,
    ciphertext text NOT NULL,
    last4 text NOT NULL,
    updated_by integer REFERENCES users(id) ON DELETE SET NULL,
    updated_at timestamptz NOT NULL DEFAULT now()
);
c                  ó6   — t        j                  t        «       y )N)r   ÚexecuteÚUPGRADE© ó    ú>/var/www/avy-guidance/api/alembic/versions/0004_app_secrets.pyÚupgrader      s   € Ü‡J�JŒwÕr
   c                  ó.   — t        j                  d«       y )NzDROP TABLE app_secrets)r   r   r	   r
   r   Ú	downgrader   !   s   € Ü‡J�JÐ'Õ(r
   )ÚreturnN)
Ú__doc__Úalembicr   ÚrevisionÚdown_revisionÚbranch_labelsÚ
depends_onr   r   r   r	   r
   r   ú<module>r      s4   ðñõ à€Ø€Ø€Ø€
ð€óô)r
   