CREATE TABLE IF NOT EXISTS `passwordResetHashes` (
  `id` MEDIUMINT(8) UNSIGNED NOT NULL AUTO_INCREMENT,
  `userId` VARCHAR(36) NOT NULL,
  `passwordResetHash` VARCHAR(64) NOT NULL,
  `expires` DATETIME NOT NULL,
  `created` DATETIME DEFAULT CURRENT_TIMESTAMP,
  `updated` DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `userId` (`userId`),
  KEY `passwordResetHash` (`passwordResetHash`)
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci;