9 lines · 222 B
CREATE TABLE hourly_limits (
  key TEXT NOT NULL,
  window_start INTEGER NOT NULL,
  hits INTEGER NOT NULL DEFAULT 0,
  PRIMARY KEY (key, window_start)
);

CREATE INDEX hourly_limits_window ON hourly_limits(window_start);