krz/gitbay

A CLI-first git forge.

clone: git clone https://gitbay.org/krz/gitbay.git

repo-descriptions: internal/store/migrations/0002_login_tokens.up.sql · raw

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);