mirror of
https://github.com/block/buzz.git
synced 2026-10-30 05:51:46 +00:00
8 lines
346 B
SQL
8 lines
346 B
SQL
CREATE TABLE push_gateway_delivery_request_replays (
|
|
relay_pubkey BYTEA NOT NULL CHECK (length(relay_pubkey) = 32),
|
|
request_id UUID NOT NULL,
|
|
expires_at TIMESTAMPTZ NOT NULL,
|
|
PRIMARY KEY (relay_pubkey, request_id)
|
|
);
|
|
CREATE INDEX push_gateway_delivery_request_replays_expiry ON push_gateway_delivery_request_replays (expires_at);
|