ikurotime / gitgud

public

main / internal/infra/persistence/sqlite/migrations/0002_sessions.sql

184 B · SQL Raw

1CREATE TABLE IF NOT EXISTS sessions (
2  token  TEXT PRIMARY KEY,
3  data   BLOB NOT NULL,
4  expiry REAL NOT NULL
5);
6
7CREATE INDEX IF NOT EXISTS sessions_expiry_idx ON sessions(expiry);