Query
CREATE TABLE magic_tokens (
token TEXT PRIMARY KEY,
-- 32 Bytes hex
student_id INTEGER NOT NULL REFERENCES students(id) ON DELETE CASCADE,
expires_at TEXT NOT NULL,
consumed_at TEXT,
-- NULL = noch nicht verwendet
created_at TEXT NOT NULL DEFAULT (datetime('now')),
ip TEXT
)