Files

8 lines
262 B
SQL

CREATE TABLE idempotency_keys (
scope TEXT PRIMARY KEY,
request_hash CHAR(64) NOT NULL,
response_json JSONB NOT NULL,
created_at TIMESTAMPTZ NOT NULL DEFAULT now()
);
CREATE INDEX idempotency_keys_created_at_idx ON idempotency_keys (created_at);