
    Zj                     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)
zServer-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    JJwr
   c                  .    t        j                  d       y )NzDROP TABLE app_secrets)r   r   r	   r
   r   	downgrader   !   s    JJ'(r
   )returnN)
__doc__alembicr   revisiondown_revisionbranch_labels
depends_onr   r   r   r	   r
   r   <module>r      s4    
)r
   