nsecbunkerd/prisma/migrations/20260530112308_add_token_revoked_at/migration.sql
Padreug eb6c86a4d1 chore(schema): add Token.revokedAt for surgical token revocation (#11)
Pre-requisite for the live-policy auth rewrite in #11. The new
revoke_token admin RPC needs a way to mark a single Token as
revoked without nuking the whole KeyUser (revoke_user) or
conflating with future expiry cleanup (deletedAt).

Nullable DateTime — existing rows default to NULL (active), no
data migration needed.

refs: #11
2026-05-30 13:24:14 +02:00

2 lines
67 B
SQL

-- AlterTable
ALTER TABLE "Token" ADD COLUMN "revokedAt" DATETIME;