Add Column

Cancel

Current Schema

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
)