CREATE TABLE IF NOT EXISTS `wp_tmapp_registration_tokens` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `mobile_normalized` VARCHAR(20) NOT NULL,
  `token_hash` CHAR(64) NOT NULL,
  `expires_at` DATETIME NOT NULL,
  `used_at` DATETIME DEFAULT NULL,
  `created_at` DATETIME DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `token_hash` (`token_hash`),
  KEY `mobile_normalized` (`mobile_normalized`),
  KEY `expires_at` (`expires_at`),
  KEY `used_at` (`used_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

