internal/store/migrations/0004_api_tokens.up.sql

 1CREATE TABLE api_tokens (
 2    id           INTEGER PRIMARY KEY,
 3    user_id      INTEGER NOT NULL REFERENCES users(id) ON DELETE CASCADE,
 4    name         TEXT NOT NULL,
 5    token_hash   TEXT NOT NULL UNIQUE,
 6    scope        TEXT NOT NULL DEFAULT 'full' CHECK (scope IN ('full','read')),
 7    created_at   TEXT NOT NULL DEFAULT (strftime('%Y-%m-%dT%H:%M:%fZ','now')),
 8    expires_at   TEXT,
 9    last_used_at TEXT,
10    UNIQUE (user_id, name)
11);