CREATE TABLE IF NOT EXISTS pocketpapi_site_events (
  id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
  event_type VARCHAR(80) NOT NULL,
  email VARCHAR(191) NULL,
  payload_json LONGTEXT NULL,
  created_at DATETIME NOT NULL,
  INDEX event_type (event_type),
  INDEX created_at (created_at)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;