internal/store/migrations/0002_login_tokens.up.sql

1CREATE TABLE login_tokens (
2    token_hash TEXT PRIMARY KEY,
3    user_id    INTEGER NOT NULL REFERENCES users(id) ON DELETE CASCADE,
4    created_at TEXT NOT NULL DEFAULT (strftime('%Y-%m-%dT%H:%M:%fZ','now')),
5    expires_at TEXT NOT NULL,
6    used_at    TEXT
7);