CREATE TABLE lifeos_admin_sessions (
  token_hash TEXT PRIMARY KEY,
  user_id TEXT NOT NULL,
  expires_at INTEGER NOT NULL
);
CREATE INDEX idx_lifeos_admin_sessions_user ON lifeos_admin_sessions(user_id);

CREATE TABLE lifeos_admin_attempts (
  user_id TEXT PRIMARY KEY,
  failures INTEGER NOT NULL DEFAULT 0,
  locked_until INTEGER NOT NULL DEFAULT 0
);