-- What happened at each sign-in, shown to the customer on their Security page.
CREATE TABLE login_events (
  id          BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
  user_id     INT UNSIGNED NOT NULL,
  ok          TINYINT(1) NOT NULL DEFAULT 1,
  method      VARCHAR(30) NOT NULL,
  why         VARCHAR(80) NULL,
  device      VARCHAR(120) NULL,
  ip          VARCHAR(45) NULL,
  created_at  DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
  KEY idx_user_time (user_id, created_at)
) ENGINE=InnoDB;
