-- Select your pre-created database in phpMyAdmin, then Import this SQL file.
CREATE TABLE IF NOT EXISTS `leads` (
 `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
 `full_name` VARCHAR(120) NOT NULL,
 `email` VARCHAR(254) NOT NULL,
 `phone` VARCHAR(20) NOT NULL,
 `consent_at` DATETIME NOT NULL,
 `created_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
 PRIMARY KEY (`id`),
 UNIQUE KEY `uniq_leads_email` (`email`),
 KEY `idx_leads_created_at` (`created_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `submission_limits` (
 `ip_hash` CHAR(64) CHARACTER SET ascii COLLATE ascii_bin NOT NULL,
 `attempts` INT UNSIGNED NOT NULL DEFAULT 0,
 `window_start` BIGINT UNSIGNED NOT NULL,
 PRIMARY KEY (`ip_hash`),
 KEY `idx_submission_limits_window_start` (`window_start`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;