-- Apply once, after 202609240001 and 202609240002. No existing data is changed.
CREATE TABLE IF NOT EXISTS auth_rate_limits (
    bucket CHAR(64) CHARACTER SET ascii COLLATE ascii_bin PRIMARY KEY,
    attempts INT UNSIGNED NOT NULL DEFAULT 0,
    window_started DATETIME NOT NULL,
    INDEX idx_auth_window_started(window_started)
) ENGINE=InnoDB;
