mirror of
https://github.com/block/buzz.git
synced 2026-11-02 07:22:55 +00:00
8 lines
369 B
SQL
8 lines
369 B
SQL
CREATE TABLE push_gateway_endpoint_quotas (
|
|
token_fingerprint BYTEA PRIMARY KEY CHECK (length(token_fingerprint) = 32),
|
|
window_started_at TIMESTAMPTZ NOT NULL,
|
|
admitted BIGINT NOT NULL CHECK (admitted >= 0),
|
|
updated_at TIMESTAMPTZ NOT NULL DEFAULT now()
|
|
);
|
|
CREATE INDEX push_gateway_endpoint_quotas_updated ON push_gateway_endpoint_quotas (updated_at);
|