-- Fixed-window request counters used to rate limit admin sign-in and the contact form.
CREATE TABLE IF NOT EXISTS `rate_limits` (
  `bucket` char(64) CHARACTER SET ascii COLLATE ascii_bin NOT NULL,
  `hits` int(11) NOT NULL DEFAULT 0,
  `window_start` datetime NOT NULL,
  PRIMARY KEY (`bucket`),
  KEY `rate_limits_window_index` (`window_start`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;