USE cashless_db;

CREATE TABLE IF NOT EXISTS email_otp_rate_locks (
  bucket_key VARCHAR(66) CHARACTER SET ascii COLLATE ascii_bin NOT NULL PRIMARY KEY,
  updated_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB;

CREATE INDEX idx_verification_email_created
  ON contact_verifications (purpose, target_email, created_at);